[Koha-win32] need help

[Dana Huff]

Hello Partha,

 

There are indeed several issues with running Koha on MySQL 5.0 and not just
with Windows so I'm posting this on the Koha general list also.

 

First, to log in to Koha you need to make some changes to your MySQL
authentication. With the default installation you will get something like:

 

>> DBI connect('mycomputer:localhost','koha',...) failed: Client does not
support 
>> authentication protocolrequested by server; consider upgrading MySQL
client at 
>> C:\usr\koha225\modules/C4/Context.pm line 409.

 

You can overcome the problem by editing line 1808 of Install.pm from:
 
print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user
(Host,User,Password) values
('$hostname','$user',password('$pass'))\" mysql\;"); 
 
to:  
 
print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user
(Host,User,Password) values
('$hostname','$user',OLD_PASSWORD('$pass'))\" mysql\;");
 

(Thanks to Andrew Koebrick (Andrew.Koebrick at state.mn.us) for that solution.)

 

Or, of course, you can execute the mysql command manually to do the same
thing if you don't use the install script, which you probably didn't to
install Koha on Windows. 

 

Then there is a new reserved word in MySQL 5 - "return" which is used as a
field name in the issues table in Koha. So in any place that is referenced
it must be enclosed in single quotes, or back-quotes. I haven't found an
instance of that in the Koha modules or scripts but I'm still looking.

 

Finally, there are a couple of modules that must be modified because of
changes in the SQL syntax rules with MySQL 5. Theses are in
intranet/modules/C4:

 

Search.pm

918c918

<
on additionalauthors.biblionumber =biblio.biblionumber

---

>
on (additionalauthors.biblionumber =biblio.biblionumber)

989c989

<
biblio.biblionumber=bibliosubtitle.biblionumber

---

>
(biblio.biblionumber=bibliosubtitle.biblionumber)

1305c1305

<                                                           left join
itemtypes on biblioitems.itemtype = itemtypes.itemtype

---

>                                                           left join
itemtypes on (biblioitems.itemtype = itemtypes.itemtype)

1494c1494

<
from biblio, biblioitems

---

>
from biblioitems, biblio

1496,1497c1496,1497

<
biblio.biblionumber = bibliosubtitle.biblionumber

<
left join itemtypes on biblioitems.itemtype=itemtypes.itemtype

---

>
(biblio.biblionumber = bibliosubtitle.biblionumber)

>
left join (itemtypes on biblioitems.itemtype=itemtypes.itemtype)

 

SearchMarc.pm

344,346c344,346

<
FROM biblio, marc_biblio 

<
LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber

<
LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype

---

>
FROM marc_biblio, biblio

>
LEFT JOIN biblioitems on (biblio.biblionumber = biblioitems.biblionumber)

>
LEFT JOIN itemtypes on (itemtypes.itemtype=biblioitems.itemtype)

 

  _____  

From: koha-win32-bounces+dana=sefovan.org at nongnu.org
[mailto:koha-win32-bounces+dana=sefovan.org at nongnu.org] On Behalf Of P. S.
Mukhopadhyay
Sent: Tuesday, August 29, 2006 8:18 AM
To: Koha-win32 at nongnu.org
Subject: Re: [Koha-win32] need help

 



Hello friends,

 

Is any one of us using MySQL 5.0 as backend RDBMS for Koha on Windows? I'm
running it through MySQL 3.23.58 but facing problems with MySQL 5.x. What is
the problem? Pl. suggest.

 

Partha

DLISc, Vidyasagar University

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-win32/attachments/20060829/567f5730/attachment-0001.htm>