Mysql 4.1 is it worth it and potential problems.

Chrysalis

Verified User
Joined
Aug 25, 2004
Messages
1,340
Location
uk
Hi

I had a quick look through the pages on this section and seen a thread by olivier but not much else on this topic.

So here is situation.

We installed directadmin on a spare server we had since the licence was free to us and we could use this server to test apache 2.x, the server was already running mysql 4.1.x for an application that specifically needs mysql 4.1.

So after I killed the old apache and mysql 4.0.17 that DA installed I had removed all conflicting software.

I then recompiled php to link with the new mysql client and to enable all mbstrings, this instantly made all the php software we had on the machine work such as phpmyadmin, however Directadmin itself cannot interface with mysql, it shows the error that the client authentication is too old. So it seems directadmin itself is compiled with a built in mysql client so with this problem no databases can be created or managed in the control panel. I tried adding the old passwords entry to my.cnf but Directadmin still fails. I also rebuilt the tables as instructed in the knowledgebase,

So my questions are.

1 - Has anyone got Directadmin and mysql 4.1.x running if so what problems did you come up with and how did you counteract them?
2 - Do you still have problems coming up and if so have you been able to workaround them?
3 - Is 4.1.x faster then 4.0.x?

Chris
 
It's working for me along with php5
The only problem I had was the passwords issue. I simply enabled compatibility with old passwords and everything started working again.

I have not noticed any speed differences, but then again I'm not running any benchmarks.
 
I am running 4.1 with the new passwords and DA can interact with it because I set an old password for that account. I thought I had documented this in my post (haven't looked), but if you say you're confused, then I must have done a poor job ;).
 
Sorry for bumping, but is there an easy way to use 'old password' by default, instead of having to do it manually SET password = OLD_PASSWORD('...')?
 
Back
Top