[Koha] Trouble with MySQL, DBI/DBD::mysql

Chris Hammond-Thrasher hammondthrasher_c at usp.ac.fj
Wed Feb 7 17:18:00 NZDT 2007

Chris (and list),


I can connect via a TCP/IP port from the command line. For example,
"mysqladmin -h penguin version" yields:



Server version          5.0.33-log

Protocol version        10

Connection              penguin via TCP/IP

TCP port                3306

Uptime:                 41 sec


Threads: 1  Questions: 2  Slow queries: 0  Opens: 12  Flush tables: 1  Open
tables: 6  Queries per second avg: 0.049


So, I changed my koha.conf to point to "penguin" rather than "localhost" and
tried to hit opac-main.pl again and I found a new error in my apache error


DBI connect('CKI:penguin','kohaadmin',...) failed: Client does not support
authentication protocol requested by server; consider upgrading MySQL client
at /usr/local/koha/intranet/modules/C4/Context.pm line 411

Can't call method "prepare" on an undefined value at opac-main.pl line 17.


What on earth does that mean? If I try, "mysql -h penguin -u kohaadmin -p
CKI" from the command line and provide the password in the koha.conf file, I
get a very nice connection to the CKI db.




Chris Hammond-Thrasher  MLIS

Library Systems Manager

University of the South Pacific

Suva, Fiji

+679 3232233

hammondthrasher_c at usp.ac.fj

-----Original Message-----
From: Chris Cormack [mailto:chris at katipo.co.nz] 
Sent: Wednesday, 7 February 2007 2:01 PM
To: Chris Hammond-Thrasher
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Trouble with MySQL, DBI/DBD::mysql




> In summary, I cannot make mysqld_safe listen at anything other than 

> /tmp/mysql.sock and I cannot make perl DBI/DBD::mysql attempt to connect 

> anywhere other than /var/run/mysqld/mysqld.sock .




> Any ideas?


Hi Chris


In your /etc/my.cnf is skip-networking set on, if you turn this off you 

could get mysql listening on the network, and then connect to it with a 

tcp socket, rather than a unix one.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20070207/cbb42340/attachment.htm

More information about the Koha mailing list