List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 15 2002 2:55pm
Subject:Re: problem starting mysqld on Solaris 2.8 (source distribution)
View as plain text  
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:mgillett@stripped]
>Sent: Wednesday, August 14, 2002 5:26 PM
>To: mysql@stripped
>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 <mysql-thread117098@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
problem starting mysqld on Solaris 2.8 (source distribution)Mark Gillett14 Aug
  • Re: problem starting mysqld on Solaris 2.8 (source distribution)Gerald Clark14 Aug
Re: problem starting mysqld on Solaris 2.8 (source distribution)Mark Gillett14 Aug
  • Re: problem starting mysqld on Solaris 2.8 (source distribution)Mark Gillett14 Aug
    • Re: problem starting mysqld on Solaris 2.8 (source distribution)Gerald Clark15 Aug