MySQL php error

[Brian McGrew]

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 at redhat.com
[mailto:redhat-list-bounces at redhat.com] 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 at 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 at 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 at linux1.ca> 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 at palrhsrv /]# /usr/bin/mysqld_safe & [1] 18547 [root at 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 at 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 at redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list