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

Tue Sep 21 03:21:40 EDT 2004

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:
> 
> 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.
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com