[Koha-devel] Re: [Koha] Re: OpenSolaris and kohaadmin rights at installation

[Chris Cormack]

On 22/06/2007, at 1:01 AM, Thommy M. wrote:

> Nope, exactly the same error from what I see...
>
> Creating the MySQL database for Koha...
>
> ERROR 1045 (28000): Access denied for user  
> 'kohaadmin'@'localhost' (using password: YES)
>
> DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied  
> for user 'kohaadmin'@'localhost' (using password: YES) at /usr/ 
> local/koha/intranet/modules/C4/Context.pm line 411
> Can't call method "prepare" on an undefined value at scripts/ 
> updater/updatedatabase line 1553.
> Problem updating database...
> address@hidden:/opt/local/src/koha-2.2.8#
>
>
> Did this before running the new install:
>
> mysqladmin -f -uroot -p drop Koha
> mysql -uroot -p -Dmysql -e"delete from user where user='kohaadmin'"
> mysql -uroot -p -Dmysql -e"delete from db where user='kohaadmin'"
> mysqladmin -uroot -p reload
Shifting this to the devel list as it seems a better place to talk  
about it.

I think I have round the problem, heres what happens
essentially the installer runs
mysql -uroot -e "GRANT ALL PRIVILEGES on Koha2.* to 'kohaadmin2'  
Identified by 'fish'"

Then it tries to use that user .. this worked with MySQL 4 .. but  
with MySQL 5 we need

mysql -uroot -e "GRANT ALL PRIVILEGES on Koha2.* to  
'kohaadmin2'@'localhost' Identified by 'fish'"

If someone who is running MySQL 4 could try the above statement and  
make sure it works fine with 4 ... i'll update the installer, if it  
doesnt, Ill update it to do a version check and then run the  
appropriate grant line.

If I dont hear back by morning 7 time (about 11 hours), Ill get a  
version 4 up and running so I can test.

For the people who want to install 2.2.9 with MySQL 5 you can edit  
line 1803 in Install.pm, to add the @'localhost' bit ie
        system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL  
PRIVILEGES on ".$database.".* to '$user' IDENTIFIED BY '$pass' \"  
mysql");
becomes
        system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL  
PRIVILEGES on ".$database.".* to '$user'\@'localhost' IDENTIFIED BY  
'$pass' \" mysql");


Hope this helps

Chris
--
Chris Cormack                            address@hidden
VP Research and Development                        www.liblime.com
LibLime                                             +64 21 542 131