LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-03-2005, 06:08 PM   #1
critical
Member
 
Registered: Feb 2005
Location: New Zealand
Distribution: Debian, Ubuntu
Posts: 46

Rep: Reputation: 15
Unhappy Debian + Apache + PHP + MySQL.so = Error


Hi there guys and girls




The basic problem

I'm trying to run phpMyAdmin which is a php admin script for MySQL database server.... it requires the following

Apache (Working)
PHP (Working, using version 4)
MySQL.so (Not working)

mysql.so is located at /user/lib/php4/20020429/mysql.so???

I currently have postgresql and phppgadmin installed and working

pgsql.so is located at /user/lib/php4/20010901/pgsql.so

In my php.ini file I have

extension=pgsql.so
extension=mysql.so




More in depth into the problem

When I try to run the script I get the following error message

"cannot load mysql extension;
please check PHP configuration
Documentation"

In the documentation it says

"Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar."

apt-get install php4-mysql
Reading Package Lists... Done
Building Dependency Tree... Done
php4-mysql is already the newest version.






My troubleshooting so far

I've been googling and it looks as if the link to the mysql.so isn't working...

My current extentsion dir is commented out but the pgsql.so works?!
; extension_dir = ./

?!



Help
 
Old 08-03-2005, 06:44 PM   #2
nolimitz
Member
 
Registered: Jul 2005
Distribution: openSUSE Tumbleweed
Posts: 73

Rep: Reputation: 15
critical, looks like it's your case that the link is broken...i don't use php with postgree, but from my windows experience I know that you should copy mysql.so in the extension dir and uncomment the extension dir(it comes commented in php, but you MUST uncomment it for extensions 2 work).Otherwise, you could set the path 2 mysql.so somewhere in the file, usually down under the extension dir..good luck.tell me if it works.plz.
 
Old 08-03-2005, 11:21 PM   #3
critical
Member
 
Registered: Feb 2005
Location: New Zealand
Distribution: Debian, Ubuntu
Posts: 46

Original Poster
Rep: Reputation: 15
Hey there, thanks for the tips

I've changed my extension dir to /user/lib/php4 and also copied mysql.so to that directory

I created a phpinfo() dump here

I noticed that mysql.so doesn't appear under "additional modules"?

Still doesn't work...

I'm confused =)
 
Old 08-04-2005, 12:20 AM   #4
critical
Member
 
Registered: Feb 2005
Location: New Zealand
Distribution: Debian, Ubuntu
Posts: 46

Original Poster
Rep: Reputation: 15
I fixed the issue by doing the following

apt-get remove php4-mysql
apt-get remove php4-pgsql
apt-get remove php4

apt-get install php4
apt-get install php4-mysql
apt-get install php4-pgsql



apt-get rocks!
 
Old 08-04-2005, 04:18 AM   #5
nolimitz
Member
 
Registered: Jul 2005
Distribution: openSUSE Tumbleweed
Posts: 73

Rep: Reputation: 15
yes, unfortunatley just for debian...it is true there is apt4rpm, but i downloaded it and guess what : more dependencies before instalation .
 
  


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
Debian, Apache, PHP, MySQL rossp Linux - Software 2 10-30-2004 06:51 AM
Apache Mysql Php: mysql with php doesn't work breakerfall Linux - Networking 6 12-27-2003 08:59 PM
Apache / PHP / Mysql config problem - debian bandit Linux - Software 14 09-03-2003 09:04 AM
php-nuke with apache php mysql c0c0deuz Linux - Software 0 03-30-2003 06:23 AM
RH/Apache/MySQL/PHP c0c0deuz Linux - Software 8 12-24-2001 07:05 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:28 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