Slackware This Forum is for the discussion of Slackware Linux.
|
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
|
07-31-2006, 07:31 AM
|
#1
|
Member
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270
Rep:
|
PHP / MySQL stopped working
Hi all, after upgrading to MySQL 5.0.22 i installed phpMyAdmin, it was working fine. I then tried to get SSL working for it, had a quick try, it didnt work so i changed things back.
When i hit my phpMyAdmin page now i get
Code:
phpMyAdmin - Error
Cannot load mysql extension. Please check your PHP configuration.
The other pages on the site that need the database are now just blank.
Any ideas on what ive done and how to fix it?
|
|
|
07-31-2006, 07:44 AM
|
#2
|
Member
Registered: Dec 2005
Distribution: Slackware -current - KDE 3.5.10
Posts: 62
Rep:
|
Can you still access mysql from the CLI? (by running the mysql or mysql -p commands)
Is mysql running in the process list? For example:
Code:
alex@Slackware:~$ ps -A | grep mysql
2004 ? 00:00:00 mysqld_safe
2030 ? 00:00:00 mysqld
Last edited by PsychoticDude85; 07-31-2006 at 07:46 AM.
|
|
|
07-31-2006, 07:49 AM
|
#3
|
Member
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270
Original Poster
Rep:
|
yes and yes.
|
|
|
07-31-2006, 07:53 AM
|
#4
|
Member
Registered: Jun 2006
Distribution: messed up debian
Posts: 250
Rep:
|
Could it be simply that phpmyadmin is looking for files in the wrong directory? any conf files?
|
|
|
07-31-2006, 07:57 AM
|
#5
|
Member
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270
Original Poster
Rep:
|
phpMyAdmin was working with the current conf.
|
|
|
07-31-2006, 08:08 AM
|
#6
|
Member
Registered: Dec 2005
Distribution: Slackware -current - KDE 3.5.10
Posts: 62
Rep:
|
It seems to be complaining that PHP cannot initiate the mysql module, which is weird, since I very much doubt you recompiled PHP recently without mysql support... Ah well, check phpinfo() just in case something has screwed up there.
|
|
|
07-31-2006, 09:07 AM
|
#7
|
Member
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270
Original Poster
Rep:
|
phpinfo() seems ok. Am i looking for something specific?
|
|
|
07-31-2006, 02:12 PM
|
#8
|
Member
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270
Original Poster
Rep:
|
When i run a php script using bash "php info.php" i get
Code:
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php/extensions/mysql.so' - libmysqlclient.so.14: cannot open shared object file: No such file or directory in Unknown on line 0
I checked /usr/lib/php/extensions/mysql.so and its there. Any ideas?
|
|
|
07-31-2006, 02:18 PM
|
#9
|
Member
Registered: Dec 2005
Distribution: slackware-current
Posts: 86
Rep:
|
did you get the mysql package from -current?? if you did, upgrade your php to current also. you might as well upgrade apache, mod_ssl, openssl, openssh, etc...
|
|
|
07-31-2006, 09:41 PM
|
#10
|
Member
Registered: Jun 2006
Distribution: messed up debian
Posts: 250
Rep:
|
do an locate mysql.so and check out the libraries names, you could be in need of a ln -s to another library. Happens to me all the time.
|
|
|
08-01-2006, 07:23 AM
|
#11
|
Member
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270
Original Poster
Rep:
|
I got the mysql 5.0.22 package from linuxpackages.net.
When i do a "locate mysql.so" i get
Code:
/usr/lib/perl5/site_perl/5.8.7/i486-linux/auto/DBD/mysql/mysql.so
/usr/lib/php/extensions/mysql.so
/usr/lib/qt-3.3.4/plugins/sqldrivers/libqsqlmysql.so
/var/run/mysql/mysql.sock
/opt/kde/lib/kde3/keximigrate_mysql.so
I can see 2 mysql.so there, do i need to link something?
Last edited by dave`2005; 08-01-2006 at 07:25 AM.
|
|
|
08-01-2006, 11:22 AM
|
#12
|
Member
Registered: Dec 2005
Distribution: slackware-current
Posts: 86
Rep:
|
NOTE: MySQL 5.0 changes the major version number of libmysqlclient from 14 to 15. This means that any applications linked with MySQL 4.1 will not work with MySQL 5.0. All of my packages that depend on MySQL (eg. PHP, mysql-python, hk_classes, dovecot, proftpd, Qt, and KOffice) will be re-posted here. From this point on, I will only be supporting MySQL 5.0 and greater.
I got that from linuxpackages site. So there you go, update all the packages that are linked to mysql.
|
|
|
All times are GMT -5. The time now is 04:35 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|