Hey am a noob to MySQL and PHP. I am trying to install G2 on my Web Server. I have PHP 5.0.5 installed along with MySQL 4.1.15 installed (Because I also am planning on using phpBB and 5 doesn't work with it). I've gone through all the steps up until Step 5 I entered the DB Password because all the rest that was filled in was correct. Then I clicked save and I got this "You must have the MySQL PHP module installed" I googled it. It brought me here and I read several post about it trying what they did but it didn't help any. So now am posting asking for your help. Like I said I am new to MySQL and PHP. THanks gor the help. Info about my server below.
AntwonW
--
Gallery version (not just "2"):2.0 Developers
PHP version (e.g. 4.3.11): 5.0.5
PHPInfo Link (see FAQ): ?
Webserver (e.g. Apache 1.3.33): Abyss
Database (e.g. MySql 4.0.11): MySQL 4.1.15
Activated toolkits (e.g. NetPbm, GD): GD not installed yet
Operating system (e.g. Linux): Windwos Xp Pro
Browser (e.g. Firefox 1.0): Internet Explorer 6.0
Posts: 32509
please post a phpinfo link.
my guess:
your php 5 has "mysqli" support, but no "mysql" support loaded.
in php.ini, uncomment the extension= ...mysql line if there is any, then restart the webserver.
if the problem persists, post the phpinfo link.
FAQ: What information is required when I ask for help in the forums?
Posts: 9
PHPINFO: http://thewhitehouse.cjb.net/phpinfo.php
restart the whole computer or just my web server appilaction?
Posts: 9
Hey now that I uncommented the extension=php_mysql.dll my computer is giving me this Warning "PHP Startup: Unable to load dynamic libary './php_mysql.dll' - The specified module could not be found." That is probably why you can't see my phpinfo.php file. So what do I do now?
Posts: 9
If you can read this this is my phpinfo file in stright text format
Posts: 32509
yep, no mysql section in this phpinfo.
check your php.ini
maybe there's something like a line
;extension=php_mysql.dll or another line with extension= ...mysql ..dll
remove the leading ; and save the file, and restart the webserver.
if that doesn't help, you need another php binary / package, which has mysql support.
Posts: 9
i already did that. in the post above i posted this
So i need to go to PHP's web site and download a different version or just a different package of the same one?
Posts: 32509
read the note on:
http://ch2.php.net/mysql
about Installation on Windows Systems, PHP 5+
Posts: 9
Ok I've read that page and almost ever page linked off it. And I've done all of it I installed PHP 5.1 and did everything. And it is still giving me the warning message and its not working. Help please!!
Posts: 39
I have the exact same thing, I click save and nothing happens, no error messages. I also do not have the mysql section in the phpinfo ( www.petermucha.com/phpinfo.php ). I tried everthing mentioned in other threads: mysql extension uncommented, set extensions directory, set up mysql and user and permissions. Is there anywhere I can see what errors are being caused? A log? Thanks fo rany help.
Peter
Here is some more of my info:
Gallery version (not just "2"):2.0 Unpossible
PHP version (e.g. 4.3.11): 5.1.0
PHPInfo Link (see FAQ): http://www.petermucha.com/phpinfo.php
Webserver (e.g. Apache 1.3.33): Apache 2.0.55
Database (e.g. MySql 4.0.11): MySQL 4.1.15-nt
Activated toolkits (e.g. NetPbm, GD): Imagemagik, netpbm
Operating system (e.g. Linux): Windwos Xp Pro
Browser (e.g. Firefox 1.0): Firefox
Posts: 32509
googling...
http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Installation/Q_21077014.html
http://www.webmasterstop.com/86.html
http://www.apachefriends.org/en/xampp.html
Posts: 39
I tried all that stuff but I think I have bigger problems. I renamed php.ini to old.php.ini.old and I can still run the gallery installer. Shouldn't the lack of a php.ini file casue php not to eecute files? I can restart apache and I even restarted the computer and apache works fine. The installer passes all the systems checks in step 2. My php info says its using a file from c:\windows but there is no php.ini there only old.php.ini.old. How do I know what file its using?
Thanks, Peter
Posts: 32509
after changing php.ini, you need to restart the webserver.
to check if you edit the right php.ini file, take a look at your phpinfo, right at the top is the php.ini path.
don't know what phpinfo is? google knows ;)
Posts: 39
I tried changing some valuse in php.ini in my windows directory, but the changes dont show up in phpinfo after restarting the server. No other versions of php.ini on computer, where are these settings coming from!?
Look three posts above your last one valiant. My phpinfo link is there and it says c:\windows is the path to php.ini but there is no php.ini there. Have you gotten yours to work?
Posts: 32509
i've never tried g2 on iis. i test g2 with apache2 on windows, from time to time.
check your phpinfo page for the php.ini path, it's there. after changing php.ini, restart IIS (no need to restart windows).
Posts: 39
I finally got G2 working with PHP4 on Apache2. I coulnd't get PHP5 to work. Not sure what else I might have changed along the way but downgrading PHP worked.
Peter
Posts: 9
Ok i've read all the links given and read all the posts. I search my entire HDD for libmysql.dll and php_mysql.dll. i found libmysql.dll in C:\Program Files\MySQL\MySQL Server 4.1\bin\libmySQL.dll. i did not find php_mysql.dll anywhere on my HDD. So that leads me to believe that I installed PHP5.1 wrong. i installed it through a installer. should i have installed it through the source?
Posts: 13
I also have a similar problem prompted "...MySQL PHP module installed" message in Step 5. My OS is Linux 9.
Please help on this.
Posts: 32509
please search the forums for similar issues. also, google has tutorials on how to setup apache/php/mysql .
Posts: 1
Just for a test and quote above I tested and managed to set up correctly on following cfg:
PHP Version 5.1.1
mysql version 5.0.18
platform OS winxppro_sp2 on Apache 2.0.55
Generally here's step by step info what I modified assuming that your apache/php/mysql is set up and working correctly. Its not that hard using pre-made installers and following simple instructions like http://www.webmasterstop.com/48.html
so after basic server/php/mysql were set, here what I have modified.
1) in php.ini
# extension_dir left by default, coz php5 tends to keep its extensions in php root dir
extension_dir = "./"
# uncommented by removing ";" in php.ini
extension=php_mysql.dll
2) also be sure you have following files in your php root directory (in my case its in c:\php )
php_mysql.dll
libmysql.dll
3) restert apache
net stop apache2
net start apache2
Worked for me to pass STEP 5 in G2 installation process