LAMP System Fedora Core 6 MySQL start error

Discussion in 'HOWTO-Related Questions' started by gavino, Apr 24, 2007.

  1. gavino

    gavino New Member

    Hi
    I was following the tutorial by Falko A LAMP System With Fedora Core 6 and I get to paragraph 9 MySQL (5.0) and try to start mysqld as follows:

    [root@aimsafe ~]# /etc/init.d/mysqld start
    Timeout error occurred trying to start MySQL Daemon.
    Starting MySQL: [FAILED]

    I have google for days but still don't know what to do. I am newbie. I think
    I am root, I only have root user as far as I know. I don't know where to
    find the <hostname>.err log. or the sqld data directory. I used locate command ie locate / -name mysql*.err but nothing.

    Any suggestions appreciated.
    Thanks..gavino
     
  2. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    ? Do you find any MySQL errors in the logs in /var/log/?
     
  3. gavino

    gavino New Member

    Hi there

    What's the output of netstat -tap
    Typed up as follows:

    [root@aimsafe ~]# netstat -tap

    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address Stat
    e PID/Program name
    tcp 0 0 *:sunrpc *:* List
    EN 1594/portmap
    tcp 0 0 *:946 *:* List
    EN 1612/rpc.statd
    tcp 0 0 localhost.localdomai:domain *:* List
    EN 1572/named
    tcp 0 0 localhost.localdomain:ipp *:* List
    EN 1769/cupsd
    tcp 0 0 localhost.localdomain:smtp *:* List
    EN 2040/sendmail: acce
    tcp 0 0 localhost.localdomain:rndc *:* List
    EN 1572/named
    tcp 0 0 aimsafe.programs.com:domain *:* List
    EN 1572/named
    tcp 0 0 *:ssh *:* List
    EN 1777sshd
    tcp 0 0 aimsafe.programs.com:ipp *:* List
    EN 1769/cupsd
    tcp 0 0 aimsafe.programs.com:rndc *:* List
    EN 1572/named

    ---------------------------------------------------
    Do you find any MySQL errors in the logs in /var/log/?
    Yes. I have typed log out as follows:

    070427 01:55:50 mysqld started
    ^G/usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13)
    ^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ib2AsGQr' (Errcode: 13)
    070427 1:55:51 InnoDB: Error: unable to create temporary file; errno: 13
    070427 1:55:51 [ERROR] bdb: /var/lib/mysql: Permission denied
    070427 1:55:51 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
    070427 1:55:51 [ERROR] bdb: PANIC: Permission denied
    070427 1:55:51 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
    070427 1:55:51 [ERROR] bdb: fatal region error detected; run recovery
    070427 1:55:51 [ERROR] bdb: /var/lib/mysql: Permission denied
    070427 1:55:51 [ERROR] Can't start server : Bind on unix socket: Permission denied
    070427 1:55:51 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
    070427 1:55:51 [ERROR] Aborting

    070427 1:55:51 [Note] /usr/libexec/mysqld: Shutdown complete

    070427 01:55:51 mysqld ended

    Regards..Gavino
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Your /tmp directory seems to be not writable or full. Please post the output of:

    df -h

    and

    ls -la /tmp
     
  5. gavino

    gavino New Member

    Thanks Till, Here are output of [df -h] & [ls -la /tmp]:

    # df -h
    -------
    Filesystem Size Used Avail Use% Mounted on
    /dev/mapper/VolGroup00-LogVol00
    72G 2.3G 66G 4% /
    /dev/hda1 99M 11M 84M 12% /boot
    tmpfs 125M 0 125M 0% /dev/shm

    # ls -la /tmp
    ----------
    total 32
    drwxrwxrwt 4 root root 4096 Apr 27 19:33 .
    d-w-------23 root root 4096 Apr 27 19:32 ..
    drwxrwxrwt 2 root root 4096 Apr 27 19:33 .font-unix
    drwxrwxrwt 2 root root 4096 Apr 27 19:32 .ICE-unix
    d-w------- 1 root root 1024 Apr 27 19:30 .rnd


    [off topic..I can't use the tab key to line up columns, so its jumbled, how to do it?]
    Regards..gavino
     
    Last edited: Apr 27, 2007
  6. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    ls -la /
    ?
     
  7. gavino

    gavino New Member

    thanks for reply Falko

    output of (ls -la /) is:

    total 178
    d-w------- 23 root root 4096 Apr 28 20:24 .
    d-w------- 23 root root 4096 Apr 28 20:24 ..
    -rw------- 1 root root 7168 Apr 28 20:24 aquota.group
    -rw------- 1 root root 6144 Apr 28 21:30 aquota.user
    -rw-r--r-- 1 root root 0 Apr 28 20:24 .autofsck
    -rw-r--r-- 1 root root 0 Apr 22 04:53 .autorelabel
    drwxr-xr-x 2 root root 4096 Apr 23 23:43 bin
    drwxr-xr-x 4 root root 1024 Apr 22 03:59 boot
    drwxr-xr-x 12 root root 4000 Apr 28 20:25 dev
    drwxr-xr-x 91 root root 12288 Apr 28 20:24 etc
    drwxr-xr-x 2 root root 4096 Oct 11 2006 home
    drwxr-xr-x 14 root root 4096 Apr 23 23:41 lib
    drwx------ 2 root root 16384 Apr 22 03:43 lost+found
    drwxr-xr-x 2 root root 4096 Apr 22 04:39 media
    drwxr-xr-x 2 root root 0 Apr 28 20:24 misc
    drwxr-xr-x 2 root root 4096 Oct 11 2006 mnt
    drwxr-xr-x 2 root root 0 Apr 28 20:24 net
    drwxr-xr-x 2 root root 4096 Oct 11 2006 opt
    dr-xr-xr-x 65 root root 0 Apr 28 20:23 proc
    -rw-r--r-- 1 root root 0 Apr 24 01:28 quota.group
    -rw-r--r-- 1 root root 0 Apr 24 02:42 quota.user
    drwxr-x--- 2 root root 4096 Apr 27 00:43 root
    drwxr-xr-x 2 root root 12288 Apr 24 02:52 sbin
    drwxr-xr-x 2 root root 4096 Apr 22 03:44 selinux
    drwxr-xr-x 2 root root 4096 Oct 11 2006 srv
    drwxr-xr-x 11 root root 0 Apr 28 20:23 sys
    drwxrwxrwt 4 root root 4096 Apr 28 21:45 tmp
    drwxr-xr-x 14 root root 4096 Apr 22 03:52 usr
    drwxr-xr-x 25 root root 4096 Apr 22 04:15 var

    regards ..gavino
     
  8. falko

    falko Super Moderator ISPConfig Developer

    This looks wrong. Did you accidentally do a chmod on /?
    It should look like this instead:
    Code:
    mh1:~# ls -la /
    insgesamt 4317
    [B][COLOR="Red"]drwxr-xr-x[/COLOR][/B]   20 root     root         4096  7. Mär 13:47 .
    [B][COLOR="Red"]drwxr-xr-x[/COLOR][/B]   20 root     root         4096  7. Mär 13:47 ..
     
  9. gavino

    gavino New Member

    Thanks Falko and Till, it's fixed, ok now, SQL starts without error.
    I did this (chmod 755 /) and the (ls -la /) is now ok.
    drwxr-xr-x 23 root root 4096 Apr 28 20:24 .
    drwxr-xr-x 23 root root 4096 Apr 28 20:24 ..
    Thanks again...gavino

    -------------
     
  10. brainz

    brainz Member

    Hi Guys,

    i have problem with mysqld as well and it will not start...

    the mysqld.log has this in it
    here is the output of df -h

    here is the output of ls -la /





    i try to start mysqld but i get this...


    I also did this chmod 755 /
    What is did is brought up the ispconfig login page but when i try to login i get all sorts of mysqld errors due to it not being able to start..

    Please help.....

    hi the mysqld.log seems to have updated itself to

    please any help would be appreciated...


    regards
    brainz
     
    Last edited: Nov 19, 2007
  11. brainz

    brainz Member

    Hi,

    i also tried ls -l /var/lib/mysql | grep mysql

    and this is the output i got..

    please help

    regards
    brainz


     
  12. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    ls -la /var/lib/mysql
    ?
     
  13. brainz

    brainz Member

    Hi Falko,

    Below is the out put of ls -la /var/lib/mysql



    regard
    brainz
     
  14. falko

    falko Super Moderator ISPConfig Developer

    Looks ok. What's in /etc/mysql/my.cnf?
     

Share This Page