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

[Scott T. Hildreth]

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 <shildreth at allantgroup.com>