Re: SV: MySQL - PHP Problem

At 11:26 03/12/2003 -0500, Paul_Lin wrote:

Paolo Nesti Poggi wrote:

Hi all,
I ran a php/mysql script and got 'unkown function mysql_connect()' ->
thinking I knew why I did 'yum install php-mysql' and it installed that
rpm.

Now when I go to restart mysqld it FAILS! - A 'Timeout' error...

Anyone know what I should do please?

did you change the root password for MySQLd?

Many thanks...
-- Nick W

it might help to see the output of:
#rpm -qa | grep php
and
#rpm -qa | grep MySQL

/paolo

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list

I had the same problem. The mysqld script is bad in /etc/rc.d/init.d I googled around and found this replacement that worked fine (I forgot where I found it or I would have jsut posted the link). Save the following as mysqld and replace the one in init.d:

#!/bin/bash
#
# mysqld    This shell script takes care of starting and stopping
#        the MySQL subsystem (mysqld).
#
# chkconfig: - 78 12
# description:    MySQL database server.
# processname: mysqld
# config: /etc/my.cnf
# pidfile: /var/run/mysqld/mysqld.pid

# Source function library.
. /etc/rc.d/init.d/functions

# Source networking configuration.
. /etc/sysconfig/network

prog="MySQL"

datadir="/var/lib/mysql"

start(){
touch /var/log/mysqld.log
chown mysql.mysql /var/log/mysqld.log
chmod 0640 /var/log/mysqld.log
if [ ! -d $datadir/mysql ] ; then
action $"Initializing MySQL database: " /usr/bin/mysql_install_db
ret=$?
chown -R mysql.mysql $datadir
if [ $ret -ne 0 ] ; then
return $ret
fi
fi
chown -R mysql.mysql $datadir
chmod 0755 $datadir
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf >/dev/null 2>&1 &
ret=$?
# Spin for a maximum of ten seconds waiting for the server to come up
if [ $ret -eq 0 ]; then
for x in 1 2 3 4 5 6 7 8 9 10; do
if [ -n "`/usr/bin/mysqladmin -u mysqld ping 2> /dev/null`" ]; then
break;
else
sleep 1;
fi
done
if !([ -n "`/usr/bin/mysqladmin -u mysqld ping 2> /dev/null`" ]); then
echo "Timeout error occurred trying to start MySQL Daemon."
action $"Starting $prog: " /bin/false
else
action $"Starting $prog: " /bin/true
fi
else
action $"Starting $prog: " /bin/false
fi
[ $ret -eq 0 ] && touch /var/lock/subsys/mysqld
return $ret
}

stop(){
/bin/kill `cat /var/run/mysqld/mysqld.pid 2> /dev/null ` > /dev/null 2>&1
ret=$?
if [ $ret -eq 0 ]; then
action $"Stopping $prog: " /bin/true
else
action $"Stopping $prog: " /bin/false
fi
[ $ret -eq 0 ] && rm -f /var/lock/subsys/mysqld
[ $ret -eq 0 ] && rm -f $datadir/mysql.sock
return $ret
}
restart(){
stop
start
}

condrestart(){
   [ -e /var/lock/subsys/mysqld ] && restart || :
}

# See how we were called.
case "$1" in
 start)
   start
   ;;
 stop)
   stop
   ;;
 status)
   status mysqld
   ;;
 restart)
   restart
   ;;
 condrestart)
   condrestart
   ;;
 *)
   echo $"Usage: $0 {start|stop|status|condrestart|restart}"
   exit 1
esac

exit $?

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list

*-------------------------------------
Joris Benschop
Stichting Ideeel Internet

Oude Gracht 42
3511 AR Utrecht
girorek. 9270464
http://www.ideeel.nl
info@xxxxxxxxx