Did you install the mysql-devel package? If so, compile up a new version of php with --with-mysql=<path> --with-mysql-lib=<path_to_libmysql> --with-mysql-includes=<path_to_mysql.h> -brian -----Original Message----- From: redhat-list-bounces@xxxxxxxxxx [mailto:redhat-list-bounces@xxxxxxxxxx] On Behalf Of Edward Iglesias Sent: Friday, November 12, 2004 1:28 PM To: General Red Hat Linux discussion list Subject: Re: MySQL php error I actually tried to install this package and got dependency errors [root@sandbox root]# rpm -i php-mysql-4.3.2-18.ent.i386.rpm warning: php-mysql-4.3.2-18.ent.i386.rpm: V3 DSA signature: NOKEY, key ID 897da07a error: Failed dependencies: libmysqlclient.so.10 is needed by php-mysql-4.3.2-18.ent Suggested resolutions: mysql-3.23.58-1.i386.rpm [root@sandbox root]# This is proboably because I upgraded to mysql-4.3.2 E Ed Wilts wrote: >On Fri, Nov 12, 2004 at 02:56:26PM -0600, Edward Iglesias wrote: > > >>Somewhat along the same lines, I keep getting a mysql_connect error >>when trying to install postnuke. The Postnuke website suggests that >>it is a php configuration error. I tried changingmysql.default_host >>to >>127.0.0.1 in php.ini. >> >> > >The one I've seen multiple people get bitten by is forgetting to >install the php-mysql rpm. Did that to myself once too. > > .../Ed > > > >>Any suggestions? >> >>Edward >> >>J G wrote: >> >> >> >>>Hi Pete >>> >>>I looked at the ps -ef output and saw that mysqld had already started. >>> >>>SO <slapping forehead>, like i mentioned below, i just killed the >>>existing processes, and the restarted the safe_mysqld command and >>>BOOM, it worked.!!!! >>> >>>able to go to ./mysqladmin and create dbases now..:) >>> >>>thanks for your help... >>> >>>Pete Nesbitt <pete@xxxxxxxxx> wrote: >>>Please see the botom post. >>> >>> >>>On November 9, 2004 02:35 pm, J G wrote: >>> >>> >>> >>> >>>>Hi Pete >>>> >>>>here are my findings per your suggestion: >>>> >>>>-when you changed "permissions' on /var/lib/mysql to be owned by >>>>mysql, did you also ensure the dir is writeable by mysql? Isn't the >>>>group 'mysql' >>>>as not >>>>'daemon'? >>>>reply: I just changed it to 777 to be sure, and started >>>>./bin/mysqld_safe & and still got the error. >>>> >>>>-is there anything in /var/log/mysqld.log or /var/log/messages ? >>>>reply: mysqld.log does not exist and there is nothing in dmesg. >>>>(weird) >>>> >>>>-make sure /var/log/mysqld.log is writeable by the mysql user >>>>(probably >>>>mysql) >>>>reply: there is no such log either...:) >>>> >>>>-that seems like strange place for a pid file, they usually go in >>>>/var/run >>>>reply: there is no pid file located in var/run/ >>>> >>>>there is however, a "server.err" file that is generated under >>>>/var/lib/mysql. it states that port 3306 is already in use and mysql >>>>cannot be started. so maybe I will start with that one and go from >>>>there.. >>>> >>>>thanks >>>> >>>> >>>> >>>>Pete Nesbitt >>>> >>>> >>>> >>>> >>>wrote: >>> >>> >>> >>> >>>>On November 8, 2004 04:50 pm, J G wrote: >>>> >>>> >>>> >>>> >>>>>Hi all, >>>>> >>>>>just installed Mysql binaries. >>>>> >>>>>When i try to start Mysql using the mysql_safe command, i get the >>>>>message: >>>>> >>>>>[root@palrhsrv /]# /usr/bin/mysqld_safe & [1] 18547 [root@palrhsrv >>>>>/]# Starting mysqld daemon with databases from /var/lib/mysql >>>>>STOPPING server from pid file /var/lib/mysql/palrhsrv.pid >>>>>041108 16:44:48 mysqld ended >>>>> >>>>> >>>>>[1]+ Done /usr/bin/mysqld_safe >>>>> >>>>>************************************ >>>>> >>>>>then, when I start the command: >>>>> >>>>>[root@palrhsrv bin]# ./mysqladmin create testDB >>>>>./mysqladmin: connect to server at 'localhost' failed >>>>>error: 'Can't connect to local MySQL server through socket >>>>>'/var/lib/mysql/mysql.sock' (2)' >>>>>Check that mysqld is running and that the socket: >>>>>'/var/lib/mysql/mysql.sock' exists! >>>>> >>>>> >>>>>I looked under the var/lib/mysql and obviously the mysql.sock does >>>>>not exist. >>>>> >>>>>I changed permissions under /var/lib/mysql to chown -R mysql and >>>>>chrgp to daemon. >>>>>Still getting the same errors. >>>>> >>>>>any help? >>>>> >>>>>thanks >>>>> >>>>> >>>>> >>>>> >>> >>>HI, >>>what does your /etc/my.cnf file show. If you don't have that, look in >>>/usr/local/etc >>> >>>Just curious, why didn't you just install the rpm? >>> >>>What version of rh & mysql? >>> >>>Did you follow all the steps for the binary install? (they show about >>>a dozen steps for a generic unix-like install) >>> >>> >>> >>> >>-- >>Edward Iglesias >>Integrated Library Systems Coordinator >>504.864.7838 (work) >>504.864.7842 (FAX) >> >> > > > -- Edward Iglesias Integrated Library Systems Coordinator 504.864.7838 (work) 504.864.7842 (FAX) -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
