Urgent Advices - MySQL 4.1 PSA integration issue

knocx · Unread post by **knocx** » Sat Oct 22, 2005 7:08 pm

2 days ago we had upgraded mySQL to 4.1 from yum repository , after than that we had lots of problem any way we had handled all of these such as old-password format etc...

But the main problem is that we have to start mysql with following options

[mysqld]
default-character-set=latin5
default-collation=latin5_turkish_ci

and if we do that we get this error;

dnsmng Unable to define dns zone for domain : Illegal Mix of Collations (latin5_turkish_ci,IMPLICIT) and latin1_swedish_ci,COERCIBLE for operation '='

when we remove the charset and collation PSA works OK...

this may be normal since collations does not match ,

* We can not downgrade to an MySQL since we got lots of problems as there are databases already created by clients on 4.1 we
receive File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) which seems like a werd issue to resolve

i see lots of people saying that 4.1 is ok with 7.5.4
but we can not get it work like above, any idea helping on that subject matter will be great

knocx

knocx · Unread post by **knocx** » Sat Oct 22, 2005 8:54 pm

it seems this is a bug with 4.1.14

please check http://bugs.mysql.com/bug.php?id=12371

from the page
--------------------
The problem is exists in mysql 4.1.14
but it is ok in mysql 4.1.12/4.1.13.
--------------------

do you plan to fix the distro according to the bug?

knocx · Unread post by **knocx** » Sat Oct 22, 2005 9:41 pm

interestingly this error does not occur when adding/deleting users , databases, but when adding / removing a domain , so this problem is not originated from mySQL i think , it is more likely that this is a bug in plesk

any ideas

knocx · Unread post by **knocx** » Sun Oct 23, 2005 2:12 pm

not interesting?

Unread post by **scott** » Mon Oct 24, 2005 9:22 am

It looks like this is another of those many UTF8 conversion issues. I'll be honest, you're going to keep running into this kind of thing in application after application.

knocx · Unread post by **knocx** » Wed Oct 26, 2005 12:44 pm

so what do you advice?

Unread post by **scott** » Wed Oct 26, 2005 1:59 pm

Im afraid I can't be much help here, UTF8 is problematic everywhere.

knocx · Unread post by **knocx** » Wed Oct 26, 2005 7:05 pm

actually i believe the problem is related with dnsmng tool of PLESK rather than MySQL since every otner portion is working like a clockwork

Unread post by **scott** » Wed Oct 26, 2005 8:42 pm

Definitely take it up with sw-soft then

knocx · Unread post by **knocx** » Thu Oct 27, 2005 8:51 am

we already post it as usual PLESK dont send a response

hardly (after 3 days) we have rolled it back to 4.0 seems working well for now

Why dont you offer your PSA yum channel for a certain price , including support , such a thing will be great for professional service seekers.

regards

Unread post by **scott** » Thu Oct 27, 2005 9:11 am

We do

Atomicorp is the commercial side of ART. We do remote server management, security and support.