Topic: MySQL on SME 7 - Client Authentication Error

[pisaacs]

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

[Tib]

pisaacs

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

Regards,

Tib

[pisaacs]

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

[mike_mattos]

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 .