SOLVED: Re: [Koha] installer database error

[Jochum van der Heide]

I've just found out what the problem was. I was playing with adding
different mysql users, but all of those users wouldn't connect to the
database with the password supplied, but did connect by just clicking
enter when prompted for the password.

I then discovered that there were 2 Anonymous users installed already
(added by the mysql-server rpm I assume). After deleting those users I
could connect using the passwords and the Koha installer ran without any
problems. So not a Koha installer bug after all ;-)

Hope this helps others with similar problems as well.

Thanks for all those who replied to my questions,

-Jochum


Jochum van der Heide wrote:
> MJ Ray wrote:
>> Jochum van der Heide <jochum.vanderheide at lifehope.om.org> wrote:
>>> If I just click enter when prompted for the password (so empty 
>>> password) then it lets me in fine. Does this mean that the Koha 
>>> installer doesn't pass on the kohaadmin password to mysqld correctly? 
>>> or is it something to do with my mysql configuration?
>>
>> It means the kohaadmin password hasn't been site correctly.  I'm not
>> sure whose fault that is.  Did the password contain any shell special
>> characters (!$ quotes and a few others)?  If so, it's the installer
>> being broken.
> 
> No, the password doesn't use any special characters. Is there anyway to 
> debug this or manually work around this installer problem?
> 
> -Jochum
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha