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@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131