SV: MySQL - PHP Problem

[stg Ideeel Internet (Joris)]

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 at redhat.com
>>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 at redhat.com
>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 at ideeel.nl