[Koha] apache configuration and login problem

[Carmel Young]

Hi, there.  Still having problems trying to reset the databaseuser
password.  We have authentication denied because of too many failed
attempts.  We tried your suggestion:

Try checking /etc/koha/koha-conf.xml. Find following section.

We got stuck here:  Access denied/
....
<config>
<db_scheme>mysql</db_scheme>
<database>koha</database>
<hostname>localhost</hostname>
<port>3306</port>
<user>kohaadmin</user>
<pass>kohaadmin</pass>
> ....


On 27/03/2009, Abhishek Amberkar [अभिषेक] <abhishek.amberkar at gmail.com> wrote:
> On Thu, Mar 26, 2009 at 6:24 PM, Carmel Young
> <carmely.cunima at googlemail.com> wrote:
>> Using Koha 3.0.0 on Linux  NOT WINDOWS!  We have two problems.
>
> That's really good. :)
>
>>
>> 1.    Follow up to the login issue;
>>
>>  Using Koha 3.0.0 on Linux.
>>
>>  We had trouble with a failed file - you sent us some advice to use
>>  gedit, and we recovered this file.  Unfortunately, another problem has
>>  arisen - cannot log into "kohadbuser" because of too many
>>  authentication failures - the exact message reads "Access denied for
>>  127.0.0.1.  The host has been blocked because of too many
>>  authentication failures."
>
> Try checking /etc/koha/koha-conf.xml. Find following section.
> ....
> <config>
>  <db_scheme>mysql</db_scheme>
>  <database>koha</database>
>  <hostname>localhost</hostname>
>  <port>3306</port>
>  <user>kohaadmin</user>
>  <pass>kohaadmin</pass>
> ....
> In your case database, user, pass may be different. So using that
> information try to logging in MySQL from command line
>
> $ mysql -u kohaadmin -pkohadmin -h localhost
>
> Note : there is no space between "-p" and "kohaadmin"
> If you are not able to get mysql prompt, "mysql>", then there's the
> problem with login information.
>
> Then you may try login as a root user to mysql
> $ mysql -u root -p<root_user_password>
>
> You should get mysql prompt "mysql>". Now try adding user for koha.
> 1) First create database for koha, if not created already
> mysql> CREATE DATABASE <databasename>;
>
> 2) Now add user who will use newly created koha database
> mysql> GRANT ALL ON <databasename>.* FOR '<username>'@'<hostname>'
> IDENTIFIED BY '<password>';
>
> Replace <databasename>, <username>, <password> with your choice.
> Replace <hostname> with localhost, since your mysql and koha
> installation resides on same system. Please note that username,
> hostname and password are in single quotes.
>
> 3) mysql> FLUSH PRIVILEGES;
> 4) mysql> QUIT;
>
> Now, remember that, fields in "GRANT ALL" command should match to
> /etc/koha/kona-conf.xml file fields, then only you will get proper
> connectivity.
>
>
>>
>> The advice you sent us was for a Windows platform, but we are using Debian
>> Etch.
>
> Debian Rocks!!!
>
>>
>> 2.  We want to configure the apache IP address, but we can't get to
>> sites-available.  When we type in "cd/etc/apache2/sites-available", it
>> tells us there is no directory
>>
>>  I hope this is not too many problems for you to solve...
>
> As Joe rightly pointed there's space after "cd" command.
>
> But let's check if you have apache installed or not. From command line try
>
> $ aptitude search apache | grep ^i
> $ ls /etc/apache2
>
> Post the output of both commands and /etc/koha/koha-conf.xml file's
> database connectivity section to this list.
>
>
> --
> With Regards
> Abhishek Amberkar
>
> Learn to appreciate a beauty within...
>