Mysql integration php problem

O

ODT

New member
Joined
Feb 25, 2011
Messages
23
After making the mistake of updating httpd through yum, I had to recompile apache/mysql/php through custombuild.

After that my mysql integration is no longer working :
http://cyclingtorrents.nl/info.php

When I tried to install php-mysql it comes with a missing dependency libmysqlclient.so.15

So I manually copied an older version of mysql.so to /usr/lib64/php/modules/
But now i'm getting all kind of weird behaviour

Any pointers?

My os is Centos 5.5 x64
 
Getting this with install php-mysql

--> Running transaction check
---> Package mysql.x86_64 0:5.0.77-4.el5_5.4 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.77-4.el5_5.4.x86_64 from updates has depsolving problems
--> mysql conflicts with MySQL-server
Error: mysql conflicts with MySQL-server
 
Got a little further and managed to install php-mysql by installing mysql-shared-community. However all php pages that use mysql turn up white. Also roundcube/phpmyadmin not working. Any clues?

When I type php-m Mysql is listed, but it's still not lised under phpinfo
 
@ODT,

You should never use yum to upgrade any software, controlled by directadmin, untill you really know, what you're doing.

So as user SeLLeRoNe has already mentioned, you need to remove all software installed with yum and re-install it with custombuild.
 
Thank you.
I removed al packages mysql* and php* installed with yum.
Now I'm installing them with custombuild agian
 
Still no luck, white page problem again. No Mysql integration.
 
Thanks for the reply. Yes I can access mysql. It seems like it won't load mysql integration in php. Still says no mysql
http://cyclingtorrents.nl/info.php

php-v
PHP 5.2.17 (cli) (built: Feb 26 2011 23:19:25)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
php -m
mysql
mysqli
 
@ODT,

according to your http://cyclingtorrents.nl/info.php, your box is still messed up. Directadmin does not keep php.ini in /etc/php.ini and does not scan /etc/php.d for additional .ini files.

So that's the problem. Your php still uses configuration provided with yum.

You should see something like the following:

Code: 
# php --ini
Configuration File (php.ini) Path: /usr/local/etc/php5/cgi
Loaded Configuration File:         /usr/local/etc/php5/cgi/php.ini
Scan for additional .ini files in: (none)
Additional .ini files parsed:      (none)

and

Code: 
# which php
/usr/local/bin/php

Show results for:

Code: 
# updatedb
# locate php | grep "/php$" | grep -v "/home"

Please show all results
 
Additionally you can run this (it might fix your problem, but not the best way):

Code: 
rm -f /etc/php.ini
ln -s /usr/local/etc/php5/cgi/php.ini /etc/php.ini

Of course, if you are running PHP-CGI (mod_suphp).

And if you running mod_php:

Code: 
rm -f /etc/php.ini
ln -s /usr/local/lib/php.ini /etc/php.ini
 
Zeiter: the output of the first two commands is as you said

Output of
/files/var/lib/php
/usr/bin/php
/usr/include/php
/usr/lib64/php
/usr/local/bin/php
/usr/local/php5/bin/php
/usr/local/php5/include/php
/usr/local/php5/lib/php
/var/lib/php
/var/www/html/atmail-1.04/javascript/fckeditor/editor/filemanager/connectors/php

Also did the latter command
 
This is what I get when I specify mysql.so in php.ini

php -v


Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
 
You did not show results for:

Code: 
# php --ini

additionally post here:

Code: 
# yum list installed | grep php
 
Configuration File (php.ini) Path: /usr/local/etc/php5/cgi
Loaded Configuration File: /usr/local/etc/php5/cgi/php.ini
Scan for additional .ini files in: (none)
Additional .ini files parsed: (none)


We tried reinstall via Yum ,but sites still using directadmin, how do you change this?

php.x86_64 5.1.6-27.el5_5.3 installed
php-cli.x86_64 5.1.6-27.el5_5.3 installed
php-common.x86_64 5.1.6-27.el5_5.3 installed
php-mysql.x86_64 5.1.6-27.el5_5.3 installed
php-pdo.x86_64 5.1.6-27.el5_5.3 installed
 
yum remove php.x86_64 5.1.6-27.el5_5.3
yum remove php-cli.x86_64 5.1.6-27.el5_5.3
yum remove php-common.x86_64 5.1.6-27.el5_5.3
yum remove php-mysql.x86_64 5.1.6-27.el5_5.3
yum remove php-pdo.x86_64 5.1.6-27.el5_5.3
 
I tried that yesterday.

I saw an error in the compiling:
ln -s /usr/lib/libmysqlclient.so /usr/lib/mysql/libmysqlclient.so

there was no /usr/lib/mysql....created that.

If that doesn't work I'll try to uninstall all yum again
 
You must log in or register to reply here.
Back
Top