Fedora Users — Re: SV: MySQL

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?

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 $?

Re: SV: MySQL - PHP Problem