Martin, thank you for writing and offering your advice. Unfortunately, it doesn't seem to have helped. I tried to follow your suggestions throughly. I purged all the php4* packages, then ran 'apt-get clean' to remove all vestiges of them. After 'updatedb', 'locate php4' didn't produce any returns. I then 'apt-get install php4-mysql' which installed 'php4' as well as 'php4-mysql'. The install seemed to go well, but restarting Apache produced this error in the web logs: PHP Warning: Unable to load dynamic library '/usr/lib/php4/20010901/mysql.so' - /usr/lib/libmysqlclient.so.10: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference in Unknown on line 0 I pasted in the entire dialog when I was installing php4-mysql, at the end of this message, in case there were any remnants of the 'testing' distribution left, which I suspect is still the problem. I'm going to write this problem to the debian-users list, but if you or anyone else know how I can revert a system with some packages in 'testing' to all Debian 'stable', this is what I'd like to try next. Thanks, again, for your help and suggestions. -Kevin Zembower >>> martin.norland@xxxxxxxxxx 05/31/05 03:03PM >>> KEVIN ZEMBOWER wrote: > I'm trying to fix PHP and MySQL on a Debian woody system that might be pretty messed up. The system has some parts, perhaps some libraries, in Debian testing with the bulk of the system in stable. I thought it's been running okay since I made these system changes, but today I had to reboot it and php and MySQL failed. > > I've removed and reinstalled the Debian packages from stable: > cn2:/var/www/centernet/htdocs/phpmyadmin# apt-get install -t stable php4 php4-cgi php4-common php4-mysql php4-mcal php4-cli [snip] > Is it normal that the php4, php4-mysql, php4-mcal and php4-cgi versions are all 4.1.2, but that php4-common and php4-cli are 4.3.10? [snip] > I tried linking or copying the files in 20010901 to 20020429, but that gave an error about a mismatch. > > Any suggestions on what I can try to get this system back in working order? If possible, I'd like to stay within the Debian system, using Debian package management commands rather than downloading source and recompiling. > > Thanks for reading through all this and for your advice and suggestions. php4-cli and php4-common don't exist in stable, it's pulling from testing - I expect you've got apt-pining setup: http://packages.debian.org/cgi-bin/search_packages.pl?keywords=php4&searchon=names&subword=1&version=all&release=all so I would start there... apt-get remove php4-common php4-cli php4-mysql; apt-get update; apt-get install php4-mysql; see how that goes. You might need to re-remove everything. When all is said and done check your php.ini, in case it has remaining lines pointing at wrong libs/etc. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ============================================================== cn2:/etc/apache# apt-get install php4-mysql Reading Package Lists... Done Building Dependency Tree... Done The following extra packages will be installed: php4 The following NEW packages will be installed: php4 php4-mysql 0 packages upgraded, 2 newly installed, 0 to remove and 0 not upgraded. Need to get 597kB of archives. After unpacking 1462kB will be used. Do you want to continue? [Y/n] y Get:1 http://security.debian.org stable/updates/main php4 4:4.1.2-7.woody4 [582kB] Get:2 http://security.debian.org stable/updates/main php4-mysql 4:4.1.2-7.woody4 [15.1kB] Fetched 597kB in 4s (135kB/s) Selecting previously deselected package php4. (Reading database ... 29348 files and directories currently installed.) Unpacking php4 (from .../php4_4%3a4.1.2-7.woody4_i386.deb) ... Selecting previously deselected package php4-mysql. Unpacking php4-mysql (from .../php4-mysql_4%3a4.1.2-7.woody4_i386.deb) ... Setting up php4 (4.1.2-7.woody4) ... I see you have apache webserver installed and so far you haven't used the apache module version of php4 in your apache. If you want to use it, you should reconfigure the apache webserver and select to load the php module. I can call the apacheconfig script now for you to do it, or you can insert the following line into /etc/apache/httpd.conf manually: LoadModule php4_module /usr/lib/apache/1.3/libphp4.so Do you want me to run the apacheconfig script now [y/N] ? y WARNING: Use of apacheconfig has been deprecated! apache-modconf should be used instead. Setting up php4-mysql (4.1.2-7.woody4) ... You are installing MySQL support for php4, but it's not enabled in your /etc/php4/apache/php.ini. To enable it you need to add this line: extension=mysql.so Do you want me to add it now [Y/n] ?y cn2:/etc/apache# apachectl graceful /usr/sbin/apachectl graceful: configuration broken, ignoring restart /usr/sbin/apachectl graceful: (run 'apachectl configtest' for details) cn2:/etc/apache# apachectl configtest fopen: No such file or directory apache: could not open document config file /etc/apache/conf.d cn2:/etc/apache# mkdir /etc/apache/conf.d cn2:/etc/apache# apachectl configtest Syntax OK cn2:/etc/apache# apachectl graceful /usr/sbin/apachectl graceful: httpd gracefully restarted cn2:/etc/apache# cd /var/www/centernet/logs/ cn2:/var/www/centernet/logs# tail -40 error_log <snip> [Wed Jun 1 12:11:49 2005] [notice] SIGUSR1 received. Doing graceful restart PHP Warning: Unable to load dynamic library '/usr/lib/php4/20010901/mysql.so' - /usr/lib/libmysqlclient.so.10: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference in Unknown on line 0 [Wed Jun 1 12:11:51 2005] [notice] Apache/1.3.33 (Debian GNU/Linux) PHP/4.1.2 configured -- resuming normal operations [Wed Jun 1 12:11:51 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache/suexec) [Wed Jun 1 12:11:51 2005] [notice] Accept mutex: sysvsem (Default: sysvsem) cn2:/var/www/centernet/logs# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
