When using Mysql 4.1 with either the LFC or the DPM, you get the following error (here in /var/log/dpns/log) :

09/23 12:19:41 26938 Cns_opendb: CONNECT error: Client does not support authentication protocol requested by server; consider upgrading Mysql client.


According to the Mysql documentation, paragraph A.2.3, there is a very simple solution to this problem: use the OLD_PASSWORD() function instead of the PASSWORD() function when creating the DB account.

As from gLite3.0 release, the LFC and DPM RPMs are built against MySQL 4.1. But they stay compatible with MySQL 4.0.

-- SophieLemaitre - 27 Sep 2005

This topic: LCG > WebHome > LCGGridDeployment > LCGSoftware > DataManagementTop > DataManagementDocumentation > LfcTroubleshooting > LfcAndDpmWithMySQL14
Topic revision: r2 - 2006-03-23 - unknown
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback