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@gmail.com> wrote:
On Thu, Mar 26, 2009 at 6:24 PM, Carmel Young <carmely.cunima@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...