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
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
Your /tmp directory seems to be not writable or full. Please post the output of: df -h and ls -la /tmp
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
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
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 ..
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 -------------
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
Hi, i also tried ls -l /var/lib/mysql | grep mysql and this is the output i got.. please help regards brainz