[Typo3] typo3.8.beta and MySQL 4.1.10a

[Peter Niederlag]

Hi,

Torsten Schrade schrieb:
> Hi all,
> 
> recently I updated my MySQL-Server to 4.1.10a cause I needed utf-8 and 
> wanted to gather some experience with the typo3.8beta. Till now 
> everything worked smoothly, no probs with the running typo3-installations.
> 
> But now every time I add a new MySQL user I can't connect with 
> typo3/install-tool to the MySQL-Server. There's some debug info in the 
> install tool:
> 
> Warning: mysql_pconnect(): Client does not support authentication 
> protocol requested by server; consider upgrading MySQL client in 
> /srv/www/t3_shared/apps/typo3_src-3.8.0beta2.1/t3lib/class.t3lib_db.php 
> on line 830
> 
> The funny thing is that I can connect to any new or old database on the 
> server with any user that existed since before the upgrade. It's only 
> the new ones causing trouble.

This seems to be something mysql-specific to me.

Have you checked your /etc/mysql/my.cnf or wherever your mysql-server 
has its startup-config?

I do notice a
<cite>
# For compatibility to other Debian packages that still use
# libmysqlclient10 and libmysqlclient12.
old_passwords   = 1
</cite>

I dont have any clue right now what and when mysql has changed anything 
related to password-handling but you might(!) want to have a look into that.

Cheers,
Peter

P.S.: also be aware that recent security updates for mysql (at least on 
3.x/debian) changed behaviour on some wildcard/special-strings. At least 
we had some troubles with mysql-GRANT with users and db's that used a 
'_' in their names. Escaping and quoting had to be changed.
-- 
Peter Niederlag
http://www.niekom.de * TYPO3 & EDV Dienstleistungen *
http://www.typo3partner.net * professional services network *