The mysql user needs write permission on the directory /usr/local/mysql-3.23.51/var
Mark Gillett wrote: >Having done some further work (I re-built using 3.23.51) I have managed to >have the server startup and run, however I am still experiencing the : > >020814 15:25:48 /usr/local/mysql-3.23.51/libexec/mysqld: Can't create/write >to file '/usr/local/mysql-3.23.51/var/host.domain.pid' (Errcode: 13) > >Which is v. confusing..... the daemon is running and works fine ... just no >PID file (so the automated shutdown script won't work etc). > >Getting there (slowly) > >Regards, > >Mark > >-----Original Message----- >From: Mark Gillett [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 14, 2002 5:26 PM >To: [EMAIL PROTECTED] >Subject: Re: problem starting mysqld on Solaris 2.8 (source >distribution) > > >Hi All (Gerald), > >Not sure why that should make a difference as the daemon is trying (it >claims) to write to /usr/local/mysql/var. > >Have updated the privs : > >from ls -al /usr/local/mysql/var > >total 32 >drw-rw-rw- 4 mysql mysql 512 Aug 14 11:27 . >drwxr-xr-x 12 mysql mysql 512 Aug 14 10:12 .. >-rw-rw-rw- 1 mysql mysql 4908 Aug 14 11:01 midguard-bin.001 >-rw-rw-rw- 1 mysql mysql 19 Aug 14 11:01 midguard-bin.index >-rw-rw-rw- 1 mysql other 5369 Aug 14 15:25 midguard.sthelier.err >drw-rw-rw- 2 mysql mysql 512 Aug 14 11:01 mysql >drw-rw-rw- 2 mysql mysql 512 Aug 14 11:01 test > >and still have the same problem : > >020814 15:25:48 mysqld started >020814 15:25:48 /usr/local/mysql-3.23.49/libexec/mysqld: Can't create/write >to file '/usr/local/mysql-3.23.49/var/host.domain.pid' (Errcode: 13) >020814 15:25:48 /usr/local/mysql-3.23.49/libexec/mysqld: Can't find file: >'./mysql/host.frm' (errno: 13) >020814 15:25:48 /usr/local/mysql-3.23.49/libexec/mysqld: Error on delete of >'/usr/local/mysql-3.23.49/var/host.domain.pid' (Errcode: 13) >020814 15:25:48 mysqld ended > >Good thought though ! Any other ideas ? > > >Regards, > >Mark > >From: Gerald Clark >Date: Wed, 14 Aug 2002 08:53:17 -0500 >---------------------------------------------------------------------------- >--- > >Look again. >/usr/local/mysql is owned by root. > >Mark Gillett wrote: > >>Hi all, >> >>Have built mysql (mysql-3.23.49.tar.gz) >> >> --prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enabl >> >e > >>-assembler >> >>on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended >>patch level). >> >>The configure, make and install seemed to go ok and were done as root. >> >>I have run the ./scripts/mysql_install_db script and then (here comes the >>problem) tried to startup the server. >> >>cd /usr/local/mysql >>./bin/safe_mysqld --user=mysql & >> >>but the bad news is that it doesn't appear to work: >> >># Starting mysqld daemon with databases from /usr/local/mysql/var >>020814 12:00:18 mysqld ended >> >>when I look in the .err file (usr/local/mysql/var/hostname.domain.err), I >>see : (tail hostname.domain.err) >> >>---snip >>020814 11:28:44 mysqld started >>020814 11:28:44 /usr/local/mysql/libexec/mysqld: Can't create/write to >> >file > >>'/usr/local/mysql/var/hostname.domain.pid' (Errcode: 13) >>020814 11:28:44 /usr/local/mysql/libexec/mysqld: Can't find file: >>'./mysql/host .frm' (errno: 13) >>020814 11:28:44 /usr/local/mysql/libexec/mysqld: Error on delete of >>'/usr/local/mysql/var/hostname.domain.pid' (Errcode: 13) >>020814 11:28:44 mysqld ended >>----snip >> >>So I checked the ownership on the /usr/local/mysql/var directory etc: >> >>chgrp -R mysql /usr/local/mysql/var >>chown -R mysql /usr/local/mysql/var >> >>and ls -al shows that this lot seems ok : >> >>---snip >>total 28 >>drw-rw-rw- 4 mysql mysql 512 Aug 14 11:27 . >>drwxr-xr-x 12 root mysql 512 Aug 14 10:12 .. >>-rw-rw-rw- 1 mysql mysql 4908 Aug 14 11:01 hostname-bin.001 >>-rw-rw-rw- 1 mysql mysql 19 Aug 14 11:01 hostname-bin.index >>-rw-rw-rw- 1 mysql other 3124 Aug 14 11:28 hostname.domain.err >>drw-rw-rw- 2 mysql mysql 512 Aug 14 11:01 mysql >>drw-rw-rw- 2 mysql mysql 512 Aug 14 11:01 test >>---snip >> >>What am I missing ? Any ideas on the cause of this problem ? >> >>Thanks for your assistance (would be grateful for direct as well as list >>response as I am slower in wading through the lists than I would like!), >> >>Regards, >> >>Mark >> >>--- >> >>Mark Gillett >>IXIF Limited >> >> > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
