Forum Moderators: open

Message Too Old, No Replies

MySQL Stopped woking with PHP After using WinXP'x Firewall

         

WyleySam

3:07 pm on Dec 20, 2006 (gmt 0)

10+ Year Member



I have installed Apache2/PHP/MySql as my localhost on my WinXP at least 6 times in the last year with no problems.
Two days ago, while debugging another problem I switched for Norton Internet Security/AntiVirus to WinXP's Firewall. After solving the problem I

switched back to NIS/AntiVirus. Since then I have not be able to use MySQL with PHP. It appears to me that PHP does not know that MySQL is

installed, all it seems to know is ODBC. Some of the errors I'm getting are:

Installing phpBB2 Error: The PHP configuration on your server doesn't support the database type that you chose.
Installing WebCalendar Error: Your current database settings are not able to access the database or have not yet been tested. The only

Database type listed is ODBC.
Accessing existing PHP using MySQL: Fatal error: Call to undefined function mysql_connect() in

D:\Development\Apache2\htdocs\Dev\LRA\SuperCalendar\includes\start.php on line 30.

When looking at phpinfo() MySQL is not listed in Configure Command (Configure Command cscript /nologo configure.js "--enable-snapshot-build"

"--with-gd=shared")

Here are the changes I've made to the configuratiion files

PHP.ini
extension=php_mysql.dll in not commented.
PHP root dir is in the path.
register_globals = Off
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
display_errors = On
extension_dir = "D:\Development\PHP\ext"
session.save_path = "C:\Documents and Settings\Neil\Local Settings\Temp"
max_execution_time = 900 ; Maximum execution time of each script, in seconds

MySQL:
C:\MySQL\bin is in the path

httpd.conf:
LoadModule alias_module modules/mod_alias.so in uncommented
AddType application/x-httpd-php .php .phtml .html .htmwas added
AddType application/x-httpd-php-source .phps was added

DirectoryIndex index.html index.html.var index.php

Since this problem started 2 days ago I have uninstalled and reinstalled Norton Internet Security/AntiVirus, Norton System Works, Apache2, PHP,

and MySQL.

Software Versions:
Apache2:apache_2.0.54-win32-x86-no_ssl.msi
PHP:php-5.2.0-Win32.zip
MySQL:MySQL-4.1.14-win32.zip
Norton Programs: 2006

I am stumped! Can anyone help?

eelixduppy

8:18 pm on Dec 20, 2006 (gmt 0)




Since this problem started 2 days ago I have uninstalled and reinstalled Norton Internet Security/AntiVirus, Norton System Works, Apache2, PHP,

Did you remember to enable mysql again in your php.ini file?

Also, I would turn off your internet security just for test purposes to see if they are interfering with anything. Here's a nice related thread [webmasterworld.com] for apache, php, and mysql installation.