Switching to RT3, few issues

Been running RT2 for ages, works great. Decided to bite the bullet and
upgrade to RT3.

Ticket database is about 200k+ tickets. Tokk about 36 hours to export… Heh.

Anyway, installing 3.0.11 from ports on FreeBSD 4.10. Server is mysql 4.1.3.

My understanding is that I needed to upgrade to mysql 4.0 or later, and 4.1’s been pretty
solid for me.

I get mysql syntax errors on rt-setup-database, that just don’t make sense. I mean,
it can connect, create the database, creates the tables, and they’re definitely there, but gets an
authentication error when trying to load the objects.

I have temporarily commented out the insert_acl call because of a different syntax issue there.

In any case, any suggestions? here’s the error:

rt3# /usr/local/rt3/sbin/rt-setup-database --dba root --dba-password thedbapassword --action init
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
Now inserting RT core system objects
[Tue Sep 21 00:07:22 2004] [crit]: Connect Failed Client does not support authentication protocol requested by server; consider upgrading MySQL client
at /usr/local/rt3/sbin/rt-setup-database line 334

The only thing that comes to mind is if it’s got something to do with SSL, as my MYSQL server
doesnt’ have SSL support turned on.

Any ideas appreciated. THe mysqlclient in question is 4.0.20, so it’s pretty current.

Same error was here a couple of weeks ago.

As far as I know you should use client libraries that comes with your
server. So it should be 4.1.3. Also try to rebuild DBD::mysql and see if
it fails any test.

Jaye Mathisen wrote: