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

[Chris Cormack]

On 25/06/2007, at 11:23 AM, Rick Welykochy wrote:

> Chris Cormack wrote:
>
>> 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");
>
>
> Chris,
>
> IIRC, when I specify a host different from 'localhost' for the MySQL
> configuration during install.pl, the install fails. This is because
> 'localhost' is hardcoded in various parts of the install.
>
> See http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1323
> for details.
>
> Might I suggest that @'localhost' be replaced by @'$installhost'
> in the above, so that it works with any server configured for
> MySQ, not just localhost.
>
>
Hi Rick

Yep long term thats the plan, short term, there is no $installhost  
defined at that point, nor are we currently prompting the user for  
the host.
So I wanted to get a fix out that would allow the people with mysql 5  
(who were currently trying to install on localhost) get koha installed.

Phase 2 can be to prompt the user for a hostname for the mysql db and  
use that.
I'm taking volunteers? :)

Chris

PS Im trying to shift development discussion to the dev lists, so we  
dont clutter the main Koha list up. so if you could reply to there  
that would be great.
--
Chris Cormack                            chris.cormack at liblime.com
VP Research and Development                        www.liblime.com
LibLime                                             +64 21 542 131