Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: pisaacs on June 13, 2006, 11:08:47 PM

Title: MySQL on SME 7 - Client Authentication Error
Post by: pisaacs on June 13, 2006, 11:08:47 PM
G'day,

I have just upgraded to SME Server 7 RC3 and managed to bust my businesses MRP server.

The MRP server uses MySQL > 4.1 as a back end for database storage.

The problem I am having appears to be because the SME7 (Centos) implimentaion of MySQL uses client 3.23.38, and this does not support the Authentication Protocol needed by our applications (greater than cleint 4.1).

SME 7 ships with mysqlclient10-3.23.28. I have upgraded (successfully) the MySQL implimentation to 5.0.18 including the package mysqlclient14-4.1.14.C4 and would have expected to now see the client as 4.12.14 (solving my authentication protocol problems).

Unfortunately my software is still reporting the authentication error and reporting that it is seeing client 3.23.38 on the SME server.

My question is:
Does anyone know how I can upgrade the SME box so the mysql client (and protocol) is greater than 4.1??

regards

Paul
Title: MySQL on SME 7 - Client Authentication Error
Post by: Tib on June 14, 2006, 02:56:02 AM
pisaacs

Might be a silly question but ... did you do a Post-Update and then a reboot after the upgrade.

Regards,

Tib
Title: MySQL on SME 7 - Client Authentication Error
Post by: pisaacs on June 14, 2006, 03:30:28 AM
Quote from: "Tib"
pisaacs

Might be a silly question but ... did you do a Post-Update and then a reboot after the upgrade.

Regards,

Tib

Yep.... and its not a silly question...
regards
Paul
Title: MySQL on SME 7 - Client Authentication Error
Post by: mike_mattos on June 14, 2006, 09:06:29 PM
I'm guessing you did NOT successfully upgrade to MySQL5

My phpMyAdmin shows MySQL client as 4.1.18  with MySQL server 5.0.18

There was some silliness with rpm versions, I'm going to build an RC3 system next week & I'll update the MySQL5 how to that's in this forum with the suggestions posted after I've tested it.

Meanwhile, I'd check that you did get the mysqlclient rpm to load, and read the how to very carefully, the first methods kill data but do remove the old MySQL files .