LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 07-31-2006, 07:31 AM   #1
dave`2005
Member
 
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270

Rep: Reputation: 30
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?
 
Old 07-31-2006, 07:44 AM   #2
PsychoticDude85
Member
 
Registered: Dec 2005
Distribution: Slackware -current - KDE 3.5.10
Posts: 62

Rep: Reputation: 15
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.
 
Old 07-31-2006, 07:49 AM   #3
dave`2005
Member
 
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270

Original Poster
Rep: Reputation: 30
yes and yes.
 
Old 07-31-2006, 07:53 AM   #4
isuck@linux
Member
 
Registered: Jun 2006
Distribution: messed up debian
Posts: 250

Rep: Reputation: 30
Could it be simply that phpmyadmin is looking for files in the wrong directory? any conf files?
 
Old 07-31-2006, 07:57 AM   #5
dave`2005
Member
 
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270

Original Poster
Rep: Reputation: 30
phpMyAdmin was working with the current conf.
 
Old 07-31-2006, 08:08 AM   #6
PsychoticDude85
Member
 
Registered: Dec 2005
Distribution: Slackware -current - KDE 3.5.10
Posts: 62

Rep: Reputation: 15
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.
 
Old 07-31-2006, 09:07 AM   #7
dave`2005
Member
 
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270

Original Poster
Rep: Reputation: 30
phpinfo() seems ok. Am i looking for something specific?
 
Old 07-31-2006, 02:12 PM   #8
dave`2005
Member
 
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270

Original Poster
Rep: Reputation: 30
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?
 
Old 07-31-2006, 02:18 PM   #9
slackamp
Member
 
Registered: Dec 2005
Distribution: slackware-current
Posts: 86

Rep: Reputation: 16
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...
 
Old 07-31-2006, 09:41 PM   #10
isuck@linux
Member
 
Registered: Jun 2006
Distribution: messed up debian
Posts: 250

Rep: Reputation: 30
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.
 
Old 08-01-2006, 07:23 AM   #11
dave`2005
Member
 
Registered: Aug 2005
Distribution: Ubuntu 7.10, Slackware 12
Posts: 270

Original Poster
Rep: Reputation: 30
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.
 
Old 08-01-2006, 11:22 AM   #12
slackamp
Member
 
Registered: Dec 2005
Distribution: slackware-current
Posts: 86

Rep: Reputation: 16
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Autheniticating PHP+LDAP+AD - stopped working. jtlawlor Fedora 0 09-27-2005 12:44 PM
php not working with MySQL pjocus Fedora - Installation 5 07-08-2005 11:42 AM
mysql stopped working with new php xushi Slackware 2 04-08-2005 10:43 AM
PHP / MySQL not working naughtymutt Linux - General 2 05-18-2004 06:41 PM
PHP not working with Apache, nor mysql wldkos Linux - Software 18 05-16-2003 12:23 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 04:35 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration