Re: MySQL php error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [CentOS]     [Kernel Development]     [PAM]     [Fedora Users]     [Red Hat Development]     [Big List of Linux Books]     [Linux Admin]     [Gimp]     [Asterisk PBX]     [Yosemite News]     [Red Hat Crash Utility]


  Powered by Linux