----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 06, 2004 1:21 PM Subject: Re: MySQL 4.1.4 RPM Distribution startup problem
> >> >error log: > >> > > >> >040902 21:47:53 mysqld started > >> >040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got > >> >126976 > >> >/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi' > > (Errcode: > >> >13) > >> > > >> mysql does not have permission to write to /root/tmp > >> Why do you have the temp directory set here? > > > > I've wrote that I have following lines in my.cnf: > > > > [mysqld] > > tmpdir=/var/mysqltmp > Then temporary give a+rw on /root/tmp (don't forget to +x /root) > and see what's mysqld_safe gonna write there. Maybe it's a bug in the > script. > Also please check the environment for TMPDIR. After this mysql started successfully but it didn't write anything in /root/tmp. #mysqladmin -u root variables | grep tmp | tmpdir | /var/mysqltmp | # stat /var/mysqltmp/ File: `/var/mysqltmp/' Size: 48 Blocks: 1 IO Block: 131072 directory Device: 306h/774d Inode: 29292 Links: 2 Access: (0755/drwxr-xr-x) Uid: ( 72/ mysql) Gid: ( 72/ mysql) Access: 2004-09-06 17:54:33.000000000 +0400 Modify: 2004-08-17 12:17:13.000000000 +0400 Change: 2004-09-06 17:55:21.000000000 +0400 Does MySQL need rights to /root/tmp to work well? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]