Re: [Koha-win32] issue between koha 2.5 and mysql 5.0

[Partha Mukhopadhyay]

Hello Dana,

I would like to have your advice on another MySQL related problem. MySQL 5x suppors Unicode. Can I keep the default charset as UTF-8. This is required in view of the following problem with MySQL 3x:

I'm doing Bengali Version of Koha (Bengali is an Indic script spoken by around 270 m people in West Bengal - a major state in India and Bangladesh). I have developed a complete theme that provides Bengali language based interface, data entry, retrival and ISO-2709 based export/import. But at the core of the database (i.e. MySQL) the records are getting saved as HTML special characters e.g Bengali letter Kaa is saved as ক - The Unicode value of Bengali Kaa is 2453. Although as everythin in Koha is over the web interface, the characters and scripts are displayed properly and even export/import operation can also be performed in the Bengali script. Here lies my aim to use MySQL 5x to see whether records are getting stored in native scripts or as HTML special characters.

Awaiting for ur valuable advice

Partha

----- Original Message -----
From: "P. S. Mukhopadhyay"
To: address@hidden
Subject: Re: [Koha-win32] issue between koha 2.5 and mysql 5.0
Date: Fri, 1 Sep 2006 13:41:28 +0530

Hello Dana,

 

Thanks a lot for your informative posting. Hope I can now solve the problem by following your instructions.

 

Partha

 

On 8/29/06, Dana Huff <address@hidden> wrote:

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 ( address@hidden) 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 and which you probably didn't do
to install Koha on Windows; anyway, that is what I did.

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. It
will be an issue if you write any of your own sql scripts for ad-hoc
reporting.

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)

That seems to have taken care of my problems. We now have Koha 2.2.5 working
with MySQL 5.0 at our installation.

Dana Huff
Madrid, Spain
address@hidden

________________________________________
From: koha-win32-bounces+dana=address@hidden
[mailto:address@hidden ] On Behalf Of P. S.
Mukhopadhyay
Sent: Tuesday, August 29, 2006 8:18 AM
To: address@hidden
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

_______________________________________________
Koha-win32 mailing list
address@hidden
http://lists.nongnu.org/mailman/listinfo/koha-win32

_______________________________________________
Koha-win32 mailing list
address@hidden
http://lists.nongnu.org/mailman/listinfo/koha-win32

--

---