[rt-users] mysql connect fails in DBIx::SearchBuilder rt-3.6pre0

[Scott T. Hildreth]

Never mind, the hostname was pointing at the wrong IP address.

                                Thanks for listening. :-)

On Mon, 2006-03-06 at 17:57 -0600, Scott T. Hildreth wrote:
> I get this in the error logs,
> 
> ..failed: Client does not support authentication protocol requested by server; 
> consider upgrading MySQL client at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 108
> [Mon Mar 06 17:17:04 2006] [error] [client 199.67.51.179] Connect Failed Client does not support authentication protocol requested by server; 
> consider upgrading MySQL client\n at /usr/local/rt-3.6pre0/lib/RT.pm line 176\n
> 
> ..This is connecting to the localhost using the same server-client 5.0.  I can connect to the rt db with
> the same Perl & DBI, 
> 
> /usr/packages/Perl># perl -MDBI -d -e0                                                                    5:45PM 03/06 tstest
> 
> Loading DB routines from perl5db.pl version 1.28
> Editor support available.
> 
> Enter h or `h h' for help, or `man perldebug' for more help.
> 
> main::(-e:1):   0
>   DB<1> $dbh = DBI->connect('dbi:mysql:dbname=rt;host=localhost', 'rt-user', 'rtpass');
> 
>   DB<2> x $dbh->tables;
> 0  '`ACL`'
> 1  '`Attachments`'
> 2  '`Attributes`'
> 3  '`CachedGroupMembers`'
> 4  '`CustomFieldValues`'
> 5  '`CustomFields`'
> 6  '`GroupMembers`'
> 7  '`Groups`'
> 8  '`Links`'
> 9  '`Principals`'
> 10  '`Queues`'
> 11  '`ScripActions`'
> 12  '`ScripConditions`'
> 13  '`Scrips`'
> 14  '`Templates`'
> 15  '`TicketCustomFieldValues`'
> 16  '`Tickets`'
> 17  '`Transactions`'
> 18  '`Users`'
> 19  '`sessions`'
> 
> 
> ... but it fails in DBIx::SearchBuilder.
> 
> =======================================================================
> 
>  perl -MDBI -e 'DBI->installed_versions'  
>                                              
>   Perl            : 5.008008    (i686-linux)
>   OS              : linux       (2.6.14.6)
>   DBI             : 1.50
>   DBD::mysql      : 3.0002
>   DBD::Sponge     : 11.10
>   DBD::SQLite     : 1.11
>   DBD::Proxy      : 0.2004
>   DBD::Oracle     : 1.16
>   DBD::Multiplex  : 1.98
>   DBD::File       : 0.33
>   DBD::ExampleP   : 11.12
>   DBD::DBM        : 0.03
> 
> 
> perl -MDBIx::SearchBuilder -e 'print $DBIx::SearchBuilder::VERSION, $/'
> 
> 1.39
> =======================================================================
> 
>                                               
> 
>                                                          Any ideas?
> 
>                                                                   STH
> 
> 
>  
-- 
Scott T. Hildreth <shildret at scotth.emsphone.com>