Configuring PHP and MySQL

[r035198x]

I have configured my PHP (5) to work on vista business fine.
I've also successfully installed MySQL server 5.0 fine.
In my php.ini I have enabled the line

extension=php_mysql.dll

I have php_mysql.dll, libmysql.dll and libmysqli.dll in my PHP directory which I have added to my PATH variable.

Still when I try to connect to MySQL from my PHP scripts, I get

Call to undefined function mysql_connect()

What did I miss?

[Atli]

What HTTP server are you using?

I had a similar problem on Vista Ultimate using IIS7. Usually ISS reflects changes right away, but I had to go as far as to reboot the computer to get this going.
If it is Apache, restarting the server is required for any change, but since it's Vista rebooting wouldn't be a bad idea.

If that doesn't fix it, it might be a security thing. Vista's user system is kind of weird. Might be a good idea to just turn the extra security off. I did :P

And you could try to copy the mysql DLL files to the windows directory. Setting the PATH should be enought, but you never know.

[r035198x]

What HTTP server are you using?

I had a similar problem on Vista Ultimate using IIS7. Usually ISS reflects changes right away, but I had to go as far as to reboot the computer to get this going.
If it is Apache, restarting the server is required for any change, but since it's Vista rebooting wouldn't be a bad idea.

If that doesn't fix it, it might be a security thing. Vista's user system is kind of weird. Might be a good idea to just turn the extra security off. I did :P

And you could try to copy the mysql DLL files to the windows directory. Setting the PATH should be enought, but you never know.

I'm using Apache 2.0.59. I've already restarted the server, and the machine several times. I've been having the problem for about three days now.

[Atli]

Ok, thats weird.

Did you install MySQL in Admin mode? If not there might be some user privaleges or services missing.
Aparently no user can be admin, so the first time I installed this it failed. It worked however after I ran the install from a cmd window running admin mode.

Also, are you absolutely sure you'r editing the correct php.ini?
I've made that mistake annoyingly often :P

[r035198x]

Ok, thats weird.

Did you install MySQL in Admin mode? If not there might be some user privaleges or services missing.
Aparently no user can be admin, so the first time I installed this it failed. It worked however after I ran the install from a cmd window running admin mode.

Also, are you absolutely sure you'r editing the correct php.ini?
I've made that mistake annoyingly often :P

I installed as Admin alright, same user I used to install apache, php and all my other programs. I can run MySQL fine from the command prompt and I connect to MySQL with Java using jdbc.
The .ini file is the correct one. The changes I make to it reflect in my PHP code like

asp_tags = On

e.t.c

[Atli]

Ok, then the php.ini works perfectly; the MySQL server works perfectly...
The only thing it can be is those DLL files. If PATH doesn't work then physicly putting them into the c:/windows/ dir must work.

If not then there is either something horribly wrong, or something extremely simple that we missed :P

You could always try to download the source and rebuild the whole thing :)

[r035198x]

Ok, then the php.ini works perfectly; the MySQL server works perfectly...
The only thing it can be is those DLL files. If PATH doesn't work then physicly putting them into the c:/windows/ dir must work.

If not then there is either something horribly wrong, or something extremely simple that we missed :P

You could always try to download the source and rebuild the whole thing :)

Just put the files in the windows directory, it didn't work.
Then I tried in the system32 folder and it didn't work either.
I have a feeling I'm missing something extremely simple ...

[nathj]

I had exactly the problem you are experiencing just the other day. It looks like some good may come of it. I mean exactly the same set up and error message

What I did in the end, under guidance from other members of this forum was to unistall PHP, IIS, Apache (plus other web servers I was trying in my panicked state) and then turn the machine off and on again.

Then I installed IIS7 and insured that was working with the old //localhost. Then I installed the latest PHP onto the laptop and updated the ini file accordingly, leaving it where it was - I did not and do not have a copy in my windows directory. I tested this with the classic phpInfo() and all was well. I should point out that I did leave MySQL as it was at the start.

The final result is that everything works, I hope this will be the same for you, I know the frustration.

Cheers
Nathan

[r035198x]

I had exactly the problem you are experiencing just the other day. It looks like some good may come of it. I mean exactly the same set up and error message

What I did in the end, under guidance from other members of this forum was to unistall PHP, IIS, Apache (plus other web servers I was trying in my panicked state) and then turn the machine off and on again.

Then I installed IIS7 and insured that was working with the old //localhost. Then I installed the latest PHP onto the laptop and updated the ini file accordingly, leaving it where it was - I did not and do not have a copy in my windows directory. I tested this with the classic phpInfo() and all was well. I should point out that I did leave MySQL as it was at the start.

The final result is that everything works, I hope this will be the same for you, I know the frustration.

Cheers
Nathan

Thanks for the advice. I don't like the idea of uninstalling everything but it seems I may have to do that ....

[nomad]

Thanks for the advice. I don't like the idea of uninstalling everything but it seems I may have to do that ....

that's what I would do, make sure you get those files in placed in your system as well. Make sure when you reload the files and you update the info in your httpd.conf that you first shut down the services.

I'm using XAMPP which will load Apache, Mysql and PHP for you then all you have to do is update the info you want.

nomad

[Atli]

Hey, r035198x.

Did you set the 'extension_dir' in the php.ini?

[r035198x]

Hey, r035198x.

Did you set the 'extension_dir' in the php.ini?

Yep. I set it alright .