LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon (http://www.linuxquestions.org/questions/linux-software-2/starting-mysql-old-error-imeout-error-occurred-trying-to-start-mysql-daemon-357499/)

Fr33B5D 08-27-2005 09:40 AM

Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon
 
Hi friends,
I just installed MySQL 3.23.58 on an FC2 machine, but I can not start it :

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

Please note that I found some threads recommending edit the mysqld scripts to $RANDOM and etc. But :
I did not find any thing similar to recommendations in my own mysqld file and when I tried to change the similar parts I did not obtain any success and got same error message.
Thank you,

trickykid 08-27-2005 09:50 AM

Did you actually run or install a DB yet(install_mysql_db)? What do your logs tell you, with any more verbose error messages besides [FAILED]?

Fr33B5D 08-27-2005 10:23 AM

Dear friend,
I have already run mysql_install_db and unfortunately there is no special log in my log file just :
Aug 27 01:15:20 fed02 mysqld: Starting MySQL: failed
and :
service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: FAILED

thank you again,

trickykid 08-27-2005 10:26 AM

You mean there is nothing in your /var/run/mysql or might be in /var/lib/mysql .err log files with any verbose errors to actually determine why mysql is failing to start?

Are you using the Fedora startup script or by any particular command?

Fr33B5D 08-27-2005 10:53 AM

Dear friend,
I used service command in addition to ./mysqld script to start it :
./mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
but I got same error message.
In addition when I check the logs in /var/lib I do not find any thing.... unless some logs related to another version of MySQL (previous one).
Regards,

Fr33B5D 08-27-2005 10:59 AM

In addtiion this is the relevant part of mysqld script after recommended modifications:

if [ $ret -eq 0 ]; then
STARTTIMEOUT=10
while [ $STARTTIMEOUT -gt 0 ]; do
RESPONSE=`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null` && break
echo "$RESPONSE" | grep -q "Access denied for user" && break
sleep 1
let STARTTIMEOUT=${STARTTIMEOUT}-1
done
if [ $STARTTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to start MySQL Daemon."
action $"Starting $prog: " /bin/false
else
action $"Starting $prog: " /bin/true
fi

Fr33B5D 08-27-2005 11:14 AM

More info
 
In addition when i try to get the status of mysqld :

service mysqld status
mysqld dead but subsys locked

Thank you,

trickykid 08-27-2005 11:23 AM

Quote:

Originally posted by Fr33B5D
In addtiion this is the relevant part of mysqld script after recommended modifications:

if [ $ret -eq 0 ]; then
STARTTIMEOUT=10
while [ $STARTTIMEOUT -gt 0 ]; do
RESPONSE=`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null` && break
echo "$RESPONSE" | grep -q "Access denied for user" && break
sleep 1
let STARTTIMEOUT=${STARTTIMEOUT}-1
done
if [ $STARTTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to start MySQL Daemon."
action $"Starting $prog: " /bin/false
else
action $"Starting $prog: " /bin/true
fi

Did mysql start before these modifications? If so, remove them and attempt to restart.

Fr33B5D 08-27-2005 11:06 PM

Dear friend it did not work fine before modifications in mysqld script and now after them does not work too.
I think that the last solution is matching a newer version of MySQL ,maybe 4.1, with Fedora2 and installing that..
What is your suggestion?

abhi2778 10-28-2006 06:23 AM

Hello ,

I am in mess i have started 2 mysqld server process how to

kill one of server permanently .(3390) .

Because of this errror my sugar CRM cannot locate database .


Plz go through it .

service mysqld restart
Stopping MySQL: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost root]# service mysqld status
mysqld (pid 3390) is running...
[root@localhost root]# service mysqld restart
Stopping MySQL: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost root]# service mysqld status
mysqld (pid 3497) is running...
[root@localhost root]# ps -el |grep mysqld
4 S 0 3473 1 0 83 0 - 1235 wait4 pts/0 00:00:00 safe_mysqld
4 S 27 3497 3473 0 76 0 - 7688 - pts/0 00:00:00 mysqld


Plz help me out .


All times are GMT -5. The time now is 01:59 PM.