Installation on Debian Linux

Anon

Hello all,

I've been using Apache/PHP/MySQL on Win32 for sometime now and am now trying to convert over to Linux. I've installed Apache and PHP from the *.deb packages but I can seem to get PHP to talk to MySQL. I know that PHP does work as calling php_info() gives me my configuration info (no mention of MySQL), however all the rest of my documents will not load due to the 'or die' call I use after mysql_connect(). These are the same docs my Windows installation uses so I know there's no problems with the scripts themselves. In addtion if I comment out the mysql calls, the pages load fine.

I've tried placing extension=mysql.so in my php.ini with no luck. The module is in the directory specified in extension_dir (/usr/lib/php4/apache). Any suggestions? If your answer is to grab the latest CVS and recompile, please take pity on a Linux newbie and give me the commands I'll need to accomplish this. Thanks!!!

Anon

It was the same with me, i just had a look at the debian.README file in php directory tree and i find that you can activate a module (liche mysql.so module) in two ways:
1) addind a line like activate=mysql.so in your php.ini file (but this one did not work for me)
2) just add a line like dl("/path_to_your_modules/mysql.so"); before you use a database in your scripts.

Hope it helps.

P.S.
just type locate mysql.so to find it in yor system (or "find / | grep mysql.so")

P.P.S.
I suppose you have installed the appropriate .deb packages for mysql_php support with apache or cgi.

Anon

Hi Luca,

Thanx for your reply. As it turned out, the problem wasn't actually with my installations at all. Rather, it some of the require and include calls within my code I had used backslashes instead of forward slashes. On Win32, PHP doesn't care whether it gets forward or baclshes, but of course it does matter on Linux🙂 Now the only issue remaining is to try and figure out how to make the Linux installation of MySQL use the same files as the WinDoze. Try as I may, I haven't been to make that happen. However, both OS's are now setup to run table dumps on all tables at reboot and then use the resulting files to update the tables when they restart. Perhaps not the most elegant solution, but it works. Anyways, thanx for you help!!

Cheers,

Geoff A. Virgo