Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

1.9.1 install.pl problem w/ remote MySQL DB

Help
Manny
2006-03-24
2013-06-03
  • Manny
    Manny
    2006-03-24

    Hello,

    I am getting a DB authentication error when I run install.pl

    The db value in my codestriker.conf file is set to

    $db='DBI:mysql:dbname=codestrikerdb;host=winvideo1';

    host "winvideo1" has MySQL v 4.1.7 and has been configured w/ a 'codestriker' database per installation instructions.  I can access it remotely w/ a mysql client version 5.0.18 this way:
      mysql -u codestriker -h winvideo1

    The same mysql command w/ a pre 5.0 version results in a similar authentication error.

    The mysql v 5.0.18 client is included in my PATH.

    And I get the following error when I run install.pl :

    Checking for  LWP::UserAgent (any)     ok: found v2.001
    Checking for         CGI (v2.56)   ok: found v2.81
    Checking for   Net::SMTP (any)     ok: found v2.24
    Checking for         DBI (v1.13)   ok: found v1.29
    Checking for    Template (v2.07)   ok: found v2.14
    Checking for HTML::Entities (any)  ok: found v1.23
    Checking for  File::Temp (any)     ok: found v0.12
    Checking for    XML::RSS (v1.05)   ok: found v1.10
    Checking for  DBD::mysql (any)     ok: found v2.1017

    DBI->connect(dbname=codestrikerdb;host=winvideo1)
    failed: Client does not support authentication
    protocol requested by server; consider upgrading
    MySQL client at ../lib/Codestriker/DB/Database.pm
    line 58

    Can you help me out?  Thanks in advance.

     
    • David Sitsky
      David Sitsky
      2006-03-26

      Try upgrading your DBD::MySQL perl module, so that it supports the more recent authentication protocol required by your SQL server.

       
    • Manny
      Manny
      2006-04-04

      Thank you very much -- that was it.