[Typo3-debian] Problems while trying to connect to MySQL after upgrade

[Peter Niederlag]

Hi,

JoH schrieb:
> Hi list.
> 
> After upgrading my PHP and MySQL Versions I am not able to establish any
> MySQL connection via PHP anymore.
> Current Versions are:
> MySQL 4.0.24
> Apache 1.3.33
> PHP 4.3.10-9
> 
> PHP4-MYSQL is installed but seems to be not running.
> MySQL Server is running and databases can be listed via webmin.
> 
> This is the error message from TYPO3:
> Fatal error: Call to undefined function: mysql_pconnect() in
> /var/www/cmsbox/typo3_src-3.7.0/t3lib/class.t3lib_db.php on line 813
> 
> And this the one from PHPmyAdmin:
> Die Erweiterung "mysql" kann nicht geladen werden.
> Bitte überprüfen Sie Ihre PHP-Konfiguration.
> Dokumentation
> 
> The documentation simply states there might be no connection to the MySQL
> server, which is obvious ...
> I googled a few hours now, but there seems to be no real help outthere ...
> 
> I even tried to remove the upgrades and reinstall the stable packages but
> there are some broken dependencies preventing me from doing so.

from what I can tell you upgraded into sid/unstable. so most likley you 
will have a hard time downgrading to stable. going back to sarge/testing 
should be possible without to much hassle.

> Any hints to get this machine running?

1)
Did you upgrade mysql as well?
be aware of changes to my.cnf(see below) in prior versions.
Are you sure mysql is still listening on localhost:3306?
'telnet localhost 3306'

----snipp /etc/mysql/my.cnf-------------------------
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
----snapp-------------------------------------------

2)
have you checked your php.ini?
/etc/php4/apache/php.ini
in 4.3.10-8 afaik mysql is compiled in so no need to load 'mysql.so'
* check if loading of the module might be required
* check if you have any default-settings for mysql in php.ini which 
might infer

what is output of phpinfo()?

-------snipp-------------------------
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	3.23.56
MYSQL_MODULE_TYPE 	external
MYSQL_SOCKET 	/var/run/mysqld/mysqld.sock
MYSQL_INCLUDE 	-I/usr/include/mysql
MYSQL_LIBS 	-L/usr/lib -lmysqlclient_r
--------snapp-------------------

3)
increase log-levels and check your logfiles(apache, php)

4)
be sure to reload apache and/or mysql after changing settings!

5)
check bugs.debian.org, also a brief check didn't show anything.

I guess you messed up some setting somewhere. ;(

mysql-server    4.0.23-7
php4-mysql      4:4.3.10-8
php4-*		4:4.3.10-8
apache		1.3.33-4

everything fine here.

Hth,
Peter
-- 
Peter Niederlag
http://www.niekom.de * TYPO3 & EDV Dienstleistungen *
http://www.typo3partner.net * professional services network *