[rt-users] Switching to RT3, few issues.

[Jaye Mathisen]

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
 (/usr/local/rt3/lib/RT.pm:257)


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.