Hi Lars J. Helbo I am facing exactly the same problem. Have you solve this problem ? Need help. Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p5622521.htm... Sent from the Koha-general mailing list archive at Nabble.com.
Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 692.
I am facing exactly the same problem.
It either means the MySQL password you specified during the Koha command-line installation process doesn't match the password configured for the 'kohaadmin' MySQL user or the 'kohaadmin' user doesn't have the right privileges to access the database. Double-check the installation instructions in the Ubuntu INSTALL file. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
This is straight from my how-to setup koha. ;-) *[cmd] means you should be entering the following command in the command line / terminal.* (You need to know the password for root or you need to be using the username and password that was given to you by your system administrator.) ** * * *7 - Create MySQL Database and grant all privileges to the koha database to the specified user* (Do not do this step, if a Koha database is already setup. An example of when not to do this step would be installing a second instance of Koha and pointing it to a database that was setup when installing Koha the first time. The only part of Koha I have on the server currently is the MySQL database. I have Koha installed on two separate machines pointing to the hosted MySQL database.) [cmd] mysqladmin -uroot -ppassword create kohadata or, if you prefer not to have your mysql root password in your bash history file, where someone may find it, leave the password out and it will be asked for in a prompt. [cmd] mysqladmin -uroot -p create kohadata It is a good idea not to have koha use the root user for MySQL, but it may be useful to give the root user access to the kohadata database. The koha user and password for MySQL that is identified below will be asked for when you run the Koha install. [cmd] mysql -uroot -p
GRANT ALL ON kohadata.* TO 'root'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON kohadata.* TO 'koha'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
\q
-- Joseph Alway Access Services Coordinator Chan Shun Centennial Library Southwestern Adventist University "The World's Great Literary Masterpieces. Freely Available At Your Fingertips. Project Gutenberg. The Free Digital Library." http://www.gutenberg.org On Fri, Apr 6, 2012 at 5:51 AM, kkahmad <kk.ahmad@gmail.com> wrote:
Hi Lars J. Helbo
I am facing exactly the same problem. Have you solve this problem ? Need help.
Thanks
-- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p5622521.htm... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Here is the link to my Koha Setup document, if anyone is interested. http://dl.dropbox.com/u/21733088/Koha%20on%20Ubuntu%20Installation%20Manual.... -- Joseph Alway Access Services Coordinator Chan Shun Centennial Library Southwestern Adventist University "The World's Great Literary Masterpieces. Freely Available At Your Fingertips. Project Gutenberg. The Free Digital Library." http://www.gutenberg.org =================================================================================== On Fri, Apr 6, 2012 at 9:40 AM, Joe <jbalway@gmail.com> wrote:
This is straight from my how-to setup koha. ;-)
*[cmd] means you should be entering the following command in the command line / terminal.*
(You need to know the password for root or you need to be using the username and password that was given to you by your system administrator.) **
* *
*7 - Create MySQL Database and grant all privileges to the koha database to the specified user* (Do not do this step, if a Koha database is already setup. An example of when not to do this step would be installing a second instance of Koha and pointing it to a database that was setup when installing Koha the first time. The only part of Koha I have on the server currently is the MySQL database. I have Koha installed on two separate machines pointing to the hosted MySQL database.)
[cmd] mysqladmin -uroot -ppassword create kohadata
or, if you prefer not to have your mysql root password in your bash history file, where someone may find it, leave the password out and it will be asked for in a prompt.
[cmd] mysqladmin -uroot -p create kohadata
It is a good idea not to have koha use the root user for MySQL, but it may be useful to give the root user access to the kohadata database. The koha user and password for MySQL that is identified below will be asked for when you run the Koha install.
[cmd] mysql -uroot -p
GRANT ALL ON kohadata.* TO 'root'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON kohadata.* TO 'koha'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
\q
-- Joseph Alway Access Services Coordinator Chan Shun Centennial Library Southwestern Adventist University
"The World's Great Literary Masterpieces. Freely Available At Your Fingertips. Project Gutenberg. The Free Digital Library." http://www.gutenberg.org
On Fri, Apr 6, 2012 at 5:51 AM, kkahmad <kk.ahmad@gmail.com> wrote:
Hi Lars J. Helbo
I am facing exactly the same problem. Have you solve this problem ? Need help.
Thanks
-- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p5622521.htm... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Here is the link to my Koha Setup document, if anyone is interested. http://dl.dropbox.com/u/21733088/Koha%20on%20Ubuntu%20Installation%20Manual....
May I suggest you edit the Ubuntu installation instructions on the wiki and/or submit a patch for the Ubuntu INSTALL file if you know of possible improvements? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
The link I posted was to my original Ubuntu Installation Manual. I created this wiki post when I installed Koha on Ubuntu. http://wiki.koha-community.org/wiki/Koha_on_Ubuntu The online version has undergone a few edits and updates by various people. I may take the time to figure out how to submit patches for the Ubuntu Install file at a later date. I don't know that anything I have done needs or should be submitted as a patch though. We started using Koha for Periodicals in August of 2011. It replaced an outdated Periodicals program we were paying $2,000 a year to use. We are also looking at moving our Acquisitions to Koha as that would save us $4,000 a year. The upside is that the Acquisitions looks like it won't be as much work. I am still working on cataloging the item records for our Non-Current Periodicals and that may get pushed back in favor of setting up Acquisitions. Setting up Acquisitions will be a lot more stress though, because I am going to be dealing with coworkers set processes. We may eventually fully switch over to Koha. One thing that we are waiting for is the patch for the Authorities Records to go through. Last I heard it was slated to go into the next update, but that was at least two months ago. -Joe- On Fri, Apr 6, 2012 at 1:03 PM, Owen Leonard <oleonard@myacpl.org> wrote:
Here is the link to my Koha Setup document, if anyone is interested.
http://dl.dropbox.com/u/21733088/Koha%20on%20Ubuntu%20Installation%20Manual....
May I suggest you edit the Ubuntu installation instructions on the wiki and/or submit a patch for the Ubuntu INSTALL file if you know of possible improvements?
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org
-- Joseph Alway Access Services Coordinator Chan Shun Centennial Library Southwestern Adventist University "The World's Great Literary Masterpieces. Freely Available At Your Fingertips. Project Gutenberg. The Free Digital Library." http://www.gutenberg.org
participants (4)
-
Joe -
kkahmad -
Lars J. Helbo -
Owen Leonard