On Fri, 2004-10-08 at 11:00, Stew Benedict wrote: > On Fri, 8 Oct 2004, Adolfo Bello wrote: > > > Hi: > > > > I've worked with MySQL 4.1 since the alpha release (4.1.0). I always > > download the latest rpms from mysql.com and install them with rpm. Until > > version 4.1.4 every thing was just fine. > > > > However, when I tried to install 4.1.5 rpms in my fully updated Mandrake > > 10.0, I got an error telling me that mysql didn't have permissions to > > access /root/tmp. MySQL was installed but couldn't be started. > > > > Humm, something wrong with this rpms. I post a message in the mysql list > > and they told me to give, temporarily, 777 access to /root/tmp to start > > the service, which I did. The service started but I couldn't work with > > the database after settings /root/tmp permissions back to the original > > ones (700). > > > > I went back to install 4.1.4, which I had working before, and I got the > > same error. My conclusion was that something was wrong with my box. I > > modified the mysql init script in /etc/init.d to start mysql as user > > root and the database started working nicely. After that I installed > > 4.1.5 which is now working without problem. However, running mysql as > > root is not considered a good security practice. > > > > Then, one of my coworker, who uses Mandrake 9.2, told me that he was > > facing the same problem with 4.1.5. After modifying mysql init script as > > I did the data base started to work. > > > > Then I decided to go to a different computer and installed 10.1 CE. The > > same problem with mysql. Again, modifying mysql init script solved the > > situation. > > > > Decided to go deeper into it, I installed mysql in a box running Debian > > 3.0r2 using the generic Linux installer. No problem whatsoever. Then I > > tried installing mysql in 10.0 using the same binary and I got the same > > problem. BTW, Debian has no /root/tmp at all. > > > > At this point, I believe that there is something in Mandrake causing the > > problem but I have no idea where to start looking at. > > > > Can I just remove /root/tmp and try to start mysql again? Has anybody in > > this list tried to install MySQL 4.1.4 or 4.1.5 in 9.2 or 10 fully > > updated or in 10.1 CE without update? > > > > Can some body give me a hint about where the problem might be? > > > > Sounds like the init script is picking up root's TMPDIR TMP variables. > You might try unsetting these in the init script, rather than running > MySQL as root. > > You'll note the mandrake package defines these vars in "start": > > TMPDIR=/tmp > export TMPDIR > TMP=/tmp > export TMP
That was it! It is working now as user mysql. Thanks a lot. Adolfo
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________
