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

[Scott T. Hildreth]

On Mon, 2006-03-06 at 18:31 -0600, Scott T. Hildreth wrote:
> Never mind, the hostname was pointing at the wrong IP address.
> 
>                                 Thanks for listening. :-)

  Well not the case.  I can connect with DBIx::SearchBuilder::Handle,

  DB<3> use DBIx::SearchBuilder::Handle;

  DB<4> $handle = DBIx::SearchBuilder::Handle->new();

  DB<5> $handle->Connect( Driver => 'mysql', Database => 'rt', Host => 'localhost', User => 'rt-user', Password => 'rtpas');

  DB<6> x $handle
0  DBIx::SearchBuilder::Handle::mysql=HASH(0x846fb50)
   'DisconnectHandleOnDestroy' => undef
   'StatementLog' => ARRAY(0x855f4fc)
        empty array
   'dsn' => 'dbi:mysql:dbname=rt3;host=localhost'

...I only get the error message when running in RT.


> 
> 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>