Re: MySQL php error

Edward Iglesias <iglesias@xxxxxxxxx> · Mon, 15 Nov 2004 11:06:58 -0600

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@xxxxxxxxxx
[mailto:redhat-list-bounces@xxxxxxxxxx] 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@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