Hi, this is my first time to installing koha on linux platform, so I'm a newbie. I'm using ubuntu linux ver. 2.12.1. I already finish my "apt-get" installation followed by the additional perl modules using MCPAN install. And when I try to install koha I see this message : ------------------------------------------------------------------------------------------- MYSQL ROOT USER PASSWORD To create the koha database, please enter your mysql server's root user password: Password: CREATING DATABASE Creating the MySQL database for Koha... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) 256ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'syamsinar@localhost' (Using password: YES)' ERROR CREATING DATABASE Couldn't connect to the MySQL server for the reason given above. This is a serious problem, the database will not get installed. Press <ENTER> to continue: DBI connect('sd_yps:localhost','syamsinar',...) failed: Access denied for user: 'syamsinar@localhost' (Using password: YES) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1008. Problem updating database... root@yps-013:/home/syamsinar/koha-2.2.4# ------------------------------------------------------------------------------------------ I got a problem with mysql.... At first I thought, maybe it is because I haven't set the password for mysql (I put blank when the installation ask me to enter mysql root password), so I go back to the terminal and type mysqladmin password, and then I got this message : ------------------------------------------------------------------------------------------- root@yps-013:/home/syamsinar/koha-2.2.4# mysqladmin password mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' root@yps-013:/home/syamsinar/koha-2.2.4# ------------------------------------------------------------------------------------------- please help me, what should I do? I'm not familiar with sql database. Regards, Wahyu W. H. --------------------------------- Yahoo! Cars NEW - sell your car and browse thousands of new and used cars online search now ---------------------------------
I'm guessing that you are using MySQL 4.1 or 5.0. The password hashing in those versions is currently incompatible with Koha, so you would need to roll back to an earlier version of MySQL. Stephen Wahyu Wijaya H. said: [..]
And when I try to install koha I see this message :
------------------------------------------------------------------------------------------- MYSQL ROOT USER PASSWORD
To create the koha database, please enter your mysql server's root user password:
Password:
CREATING DATABASE
Creating the MySQL database for Koha... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) 256ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'syamsinar@localhost' (Using password: YES)'
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
Actually I'm using mysql ver. 4.0.24 with apache2. Is there any possibility that the problem came from my apache2 configuration? But I already try it using apache 1.33 and the installation is successful. But there is a message told me to add some lines to include the /etc/koha.httpd.conf to the original httpd.conf Can you tell me how to do it? In which line do I have to write it? Thanks. Regard, Wahyu W. H. Stephen Hedges <shedges@skemotah.com> wrote: I'm guessing that you are using MySQL 4.1 or 5.0. The password hashing in those versions is currently incompatible with Koha, so you would need to roll back to an earlier version of MySQL. Stephen Wahyu Wijaya H. said: [..]
And when I try to install koha I see this message :
------------------------------------------------------------------------------------------- MYSQL ROOT USER PASSWORD
To create the koha database, please enter your mysql server's root user password:
Password:
CREATING DATABASE
Creating the MySQL database for Koha... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) 256ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'syamsinar@localhost' (Using password: YES)'
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com --------------------------------- To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.
Wahyu - I don't think this is an Apache problem, but I could be wrong. Look in the "Hints" file in the directory where you unzipped your Koha download for instructions on modifying the httpd.conf file. Stephen Wahyu Wijaya H. said:
Actually I'm using mysql ver. 4.0.24 with apache2. Is there any possibility that the problem came from my apache2 configuration?
But I already try it using apache 1.33 and the installation is successful. But there is a message told me to add some lines to include the /etc/koha.httpd.conf to the original httpd.conf
Can you tell me how to do it? In which line do I have to write it?
Thanks.
Regard, Wahyu W. H.
Stephen Hedges <shedges@skemotah.com> wrote: I'm guessing that you are using MySQL 4.1 or 5.0. The password hashing in those versions is currently incompatible with Koha, so you would need to roll back to an earlier version of MySQL.
Stephen
Wahyu Wijaya H. said: [..]
And when I try to install koha I see this message :
------------------------------------------------------------------------------------------- MYSQL ROOT USER PASSWORD
To create the koha database, please enter your mysql server's root user password:
Password:
CREATING DATABASE
Creating the MySQL database for Koha... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) 256ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'syamsinar@localhost' (Using password: YES)'
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
I have followed the installation document obtained from Drupals web site to install Koha to Ubuntu 7.10. Everything goes well until I get an error 1045 from mysql and the install aborts. I can open mysqladmin and connect to mysql using the same password as I give in the installer.pl file. Does anyone know of a work a round?
participants (3)
-
Michael Ives -
Stephen Hedges -
Wahyu Wijaya H.