HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   LAMP System Fedora Core 6 MySQL start error (http://www.howtoforge.com/forums/showthread.php?t=12290)

gavino 24th April 2007 11:26

LAMP System Fedora Core 6 MySQL start error
 
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

falko 25th April 2007 13:24

What's the output of
Code:

netstat -tap
? Do you find any MySQL errors in the logs in /var/log/?

gavino 26th April 2007 08:14

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

till 26th April 2007 10:29

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

df -h

and

ls -la /tmp

gavino 27th April 2007 05:14

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

falko 27th April 2007 14:21

What's the output of
Code:

ls -la /
?

gavino 28th April 2007 04:19

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

falko 28th April 2007 18:32

Quote:

Originally Posted by 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 ..

This looks wrong. Did you accidentally do a chmod on /?
It should look like this instead:
Code:

mh1:~# ls -la /
insgesamt 4317
drwxr-xr-x  20 root    root        4096  7. Mär 13:47 .
drwxr-xr-x  20 root    root        4096  7. Mär 13:47 ..


gavino 29th April 2007 13:59

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

-------------
Quote:

Originally Posted by falko
This looks wrong. Did you accidentally do a chmod on /?
It should look like this instead:
Code:

mh1:~# ls -la /
insgesamt 4317
drwxr-xr-x  20 root    root        4096  7. Mär 13:47 .
drwxr-xr-x  20 root    root        4096  7. Mär 13:47 ..



brainz 19th November 2007 16:41

Hi Guys,

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

the mysqld.log has this in it
Quote:

071120 01:54:25 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/ibfOkm25' (Errcode: 13)
071120 1:54:26 InnoDB: Error: unable to create temporary file; errno: 13
071120 1:54:26 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 1:54:26 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
071120 1:54:26 [ERROR] bdb: PANIC: Permission denied
071120 1:54:26 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
071120 1:54:26 [ERROR] bdb: fatal region error detected; run recovery
071120 1:54:26 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 1:54:26 [ERROR] Can't start server : Bind on unix socket: Permission denied
071120 1:54:26 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
071120 1:54:26 [ERROR] Aborting

071120 1:54:26 [Note] /usr/libexec/mysqld: Shutdown complete

071120 01:54:26 mysqld ended
here is the output of df -h

Quote:

[root@xxxx log]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda2 72G 6.8G 62G 10% /
/dev/hda1 99M 13M 81M 14% /boot
tmpfs 221M 0 221M 0% /dev/shm
here is the output of ls -la /

Quote:

[root@xxxxx]# ls -la /
total 254
drwxr-xr-x 24 109 112 4096 Nov 20 01:54 .
drwxr-xr-x 24 109 112 4096 Nov 20 01:54 ..
-rw------- 1 root root 16384 Nov 20 02:06 aquota.group
-rw------- 1 root root 17408 Nov 20 02:06 aquota.user
-rw-r--r-- 1 root root 0 Nov 20 01:54 .autofsck
drwxr-x--- 2 109 112 4096 Nov 18 22:02 .automount
-rw-r--r-- 1 root root 0 May 22 20:27 .autorelabel
drwxr-x--- 2 109 112 4096 Nov 18 22:02 bin
drwxr-xr-x 4 root root 1024 Jun 24 17:22 boot
drwxr-xr-x 11 root root 4180 Nov 20 02:20 dev
drwxr-xr-x 101 root root 12288 Nov 20 01:54 etc
drwxr-xr-x 4 root root 4096 Jun 18 23:21 home
drwxr-xr-x 11 root root 4096 Jul 2 05:00 lib
drwx------ 2 root root 16384 May 23 05:54 lost+found
drwxr-xr-x 2 root root 4096 May 26 14:37 media
drwxr-xr-x 2 root root 4096 Oct 25 2006 misc
drwxr-xr-x 2 root root 4096 Feb 12 2006 mnt
drwxr-xr-x 2 root root 0 Nov 20 01:54 net
drwxr-xr-x 2 root root 4096 Feb 12 2006 opt
dr-xr-xr-x 113 root root 0 Nov 20 2007 proc
-rw------- 1 root root 1024 Nov 10 06:45 .rnd
drwxr-x--- 17 root root 4096 Nov 20 01:18 root
drwxr-xr-x 2 root root 12288 Nov 19 04:59 sbin
drwxr-xr-x 2 root root 4096 May 22 19:54 selinux
drwxr-xr-x 2 root root 4096 Feb 12 2006 srv
drwxr-xr-x 11 root root 0 Nov 20 2007 sys
drwxr-xr-x 27 root root 36864 Nov 20 02:31 tmp
drwxr-xr-x 14 root root 4096 May 22 20:00 usr
drwxr-x--- 29 109 112 4096 Nov 14 22:47 var
-rw-r--r-- 1 root root 2085 Jun 24 20:36 webmin-setup.out




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

Quote:

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

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

Quote:

071120 08:57:12 mysqld started
071120 8:57:12 InnoDB: Started; log sequence number 0 43685
071120 8:57:12 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 8:57:12 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
071120 8:57:12 [ERROR] bdb: PANIC: Permission denied
071120 8:57:12 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
071120 8:57:12 [ERROR] bdb: fatal region error detected; run recovery
071120 8:57:12 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 8:57:12 [ERROR] Can't start server : Bind on unix socket: Permission denied
071120 8:57:12 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
071120 8:57:12 [ERROR] Aborting

071120 8:57:12 InnoDB: Starting shutdown...
071120 8:57:14 InnoDB: Shutdown completed; log sequence number 0 43685
071120 8:57:14 [Note] /usr/libexec/mysqld: Shutdown complete

071120 08:57:14 mysqld ended
please any help would be appreciated...


regards
brainz


All times are GMT +2. The time now is 12:48.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.