[Koha] Re: OpenSolaris and kohaadmin rights at installation

[Chris Cormack]

Hi All

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...
> root at schumi:/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
>
>
Ive fixed this in cvs now, in the rel_2_2 branch.
So if you grab the Install.pm file from cvs you will get the fix.

Otherwise, the change is line 1083
  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                            chris.cormack at liblime.com
VP Research and Development                        www.liblime.com
LibLime                                             +64 21 542 131