Re: Mysql + PHP4 problem

> PHP is installed and working, but refuses to acknowledge mysql. > Mysql. on the other hand, is working OK too (for Bugzilla). > > Details: > Mandrake 8; PHP 4.0.6 (but reports 4.0.4pl1 on php -v) ; mysql 3.23.39 > PHP was built with --with-mysql=/usr/local/mysql --with-apxs > > php -h gives out a warning: > unable to load dynamic library '/usr/lib/php/extensions/mysql.so' .... file > not found. > > (not that it really matters, but: httpd -l lists mod_so.c) > > Now - I've tried to link the only mysql.so file in the system > (/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBD/mysql/..) to that > location > (though the location seems strange), but then failed on undefined refs in > that library. You are confusing a bunch of things here. First, --with-mysql=/usr/local/mysql could not possibly create /usr/lib/php/extensions/mysql.so. Where did you get this file? From some sort of RPM? If so, why are you compiling things yourself? Pick one or the other. Second, that mysql.so would be a PHP-specific share library which can not be loaded into Perl. I am not sure why you are trying to do that at all. Third, huh? The file doesn't actually appear to be there, so why are you trying to load it from your php.ini file? When you compile PHP using --with-mysql=/some/path --with-apxs you are building MySQL support directly into the resulting libphp4.so shared library. You should remove any "extension=mysql.so" lines from your php.ini file if this is how you want to do things. If you install some sort of php-mysql rpm which I suspect Mandrake probably provides then that RPM is likely to stick a mysql.so shared library in your extensions dir in which case you would use "extension=mysql.so" in your php.ini file. -Rasmus