[SOLVED] "You must have the MySQL PHP module installed&
|
tamo
Joined: 2004-11-08
Posts: 5 |
Posted: Sat, 2004-12-18 00:57
|
|
Hi all, In my phpinfo the php Mysql module seems to be installed. I've mysql.so in my ../php/extensions/ I've even restarted MySql Server and httpd2 server. can someone help me ? I don't find solutions on this forum. thx Tamo |
|
Posts: 8194
Moving to G2 forum.
Posts: 3236
It might be that you need to add a line to your php.ini file or uncomment a line. Open it up and search for things like "mysql". Also, just because php works and mysql works, doesn't mean that php has mysql support in it. PHP needs to be compiled or configured to provide mysql support. Good luck
Posts: 328
tamo, if phpMyAdmin works, the mysql module should be working too. The installer just checks if the PHP function "mysql_connect" is present to proceed with installation. Create a test.php file with:
<pre><?php echo function_exists('mysql_connect') ? 'YES' : 'NO'; print_r(get_defined_functions()); ?></pre>And see what you get. The second line in PHP returns a list of defined functions in PHP. Check to see if the Mysql ones are amongst them.
What PHP version/OS are you using?
Posts: 5
Hi baschny;
thx for the help. ;)
This is my softs versions :
The code give me : NO (you can see yourself at http://tamo.no-ip.org/test.php )
All worked fine. I did a large update (update of mandrake by the GUI and the update of G2). After that, G2 crashed. I've deleted Mysql, Apache and PHP (command urpme) then urpmi httpd then urpmi mysql and finally urpmi php-mysql.
I do a last update of phpmyadmin.
Phpmyadmin works fine but not G2.
I think you're right when you say " mysql_connect" is missing look here : http://tamo.no-ip.org/gallery2/main.php
Tamo :roll:
Posts: 8601
is phpmyadmin running on a different php or webserver? it really doesn't look like the php you're using for G2 was compiled with mysql support.
Posts: 5
PhpMyAdmin is on the same server.
I don't use compiled sources but i use urpmi (i'm a noob on linux)
You think i've two web server on the same machine who listen on 2 differents sockets ?
I'll get a look...
Tamo
Posts: 8601
in any case you'll need to compile or find a php with mysql support in order to use G2 with mysql.. i don't know how your phpmyadmin is working.
Posts: 5
I called a friend to look at my linux. He don't understand how my phpmyadmin works nor why my php-mysql looks like installed and G2 doesn't work !!!
I'll continu to search. when i find i share my knowledge ;-)
Tamo
Posts: 5
A friend of mine found the solution of my problem :
the 34_mysql.ini wasn't int the good directory.
If you have the same problem, check it with the directory declared in the php.ini
Tamo
Posts: 1
what does 34_mysql.ini mean?
I serched my entire HDD for this file, but it doesen't exist.
Please be a little more explicit with your solution.
Thank you.
Posts: 32509
mysql.ini maybe, don't think there's a 34_mysql.ini, doesn't make sense to me.
Posts: 1
This is not enough information to help others (me) with this issue. Please include more information so I can resolve this problem...
Thanks
Posts: 8601
what issue? you don't have mysql support in your php? See: http://www.php.net/manual/en/ref.mysql.php
Posts: 1
Don't worry, he has signed the right way for us. Follow these steps :
-edit /etc/php{4,5}/apache{1,2}/php.ini
-uncomment this line : ;extension=mysql.so removing the ";" at the beginning
-restart apache : sudo apachectl restart
-turn on gallery2 configuration and continue with step 6
Good Luck,
AranBenjO ... a Bear Lover ^_-
Posts: 18
Thanks, that solution worked for me. I'm running Gallery2 on lighttpd.
Posts: 1
I had same issue while doing at that step. Afer uncomment the extension=mysql.so from my php.ini and restart apache2, gallery can keep going on the installation.
-eric