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

[Chris Hammond-Thrasher]

Chris (and list),

 

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

 

<snip/>

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

 

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.

 

-cht

 

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.

 

Chris

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