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.


1.9.1 problem w/ remote MySQL DB

  • Manny


    I am getting a DB authentication error when I run

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


    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 :

    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

    failed: Client does not support authentication
    protocol requested by server; consider upgrading
    MySQL client at ../lib/Codestriker/DB/
    line 58

    Can you help me out?  Thanks in advance.

    • David Sitsky
      David Sitsky

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

    • Manny

      Thank you very much -- that was it.