MySQL php error

Mon Nov 15 17:06:58 UTC 2004

Thanks for the help.  Just to clarify.

running MySQL version 4.17 standard
installed php-mysql-4.3.2-18.ent.i386.rpm
client 5.01
OS RH Enterprise Linux 3

After installing php-mysql-4.3.2-18 I still am getting this

*Warning*: mysql_connect(): Client does not support authentication 
protocol requested by server; consider upgrading MySQL client in 
*/var/www/html/postnuke/html/pnadodb/drivers/adodb-mysql.inc.php* on 
line *339*
Error connecting to db
Program: /var/www/html/postnuke/html/install/db.php - Line N.: 45
Database: webdb
Error (1251) : Client does not support authentication protocol requested 
by server; consider upgrading MySQL client

Any ideas?

E

IT Dept wrote:

>Just to note, there is no such mySQL version (4.3.2) so ...
>
>Assuming for the moment that you are running a 4.0.xx version of mySQL
>you could try this link:
>
>http://at.rpmfind.net/opsys/linux/RPM/mysql/MySQL-4.0/MySQL-shared-compa
>t-4.0.18-0.i386.html
>
>I didn't see where you posted what version of RH you are using. If I
>knew what version you had I could help direct you to the right archive.
>Best chances (unless you are running RHEL) are:
>
>http://rpm.pbone.net/
>http://fedoralegacy.org/
>http://www.rpmfind.net
>
>The big problem is that most contrib'ed RPMs for php-mysql are made
>based on older versions of mySQL (installed on the creating system) so
>be aware that you might be stuck with either using an older version of
>mySQL (3.28.xx) or upgrading the whole shabang.
>
>For RHEL, I'd stick with what ever they list as the "approved" RPM
>package.
>
>Currently in Fedora Core the versions that are listed togeather are
>php-myslq-5.0.2-7 and mySQL-4.1.7-3.
>
>Good luck.
>
>Paul Pettit
>IT Manager
>CCB Inc.  
>
>-----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 3: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)