MySQL php error

Fri Nov 12 22:59:58 UTC 2004

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)

-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list