Access denied for user 'kohaadmin'@'localhost' koha 2.2.9 setup
I am making my own life miserable.... While installing koha 3 I accidentally somehow deleted koha 2.2.9 (Yes, yes, stupid, I know, luckily it's not the production server yet) So, I thought, big deal, I reinstall it (for the sake of updating from there to koha 3) but I keep getting this: Creating the MySQL database for Koha... ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES) DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'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 1553. Problem updating database... I do have the password, I can login to mysql debian:/home/marty/koha-2.2.9# mysql -u kohaadmin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. So where do I enter the password? Or what could be wrong? I had Koha 2.2.9 running fine until I screwed up.... Marty
The password goes in your KOHA_CONF file. For 2.2 that should be a flat text file. --joe On Mon, Feb 2, 2009 at 8:07 PM, Marty <ontariowolf64@yahoo.com> wrote:
I am making my own life miserable.... While installing koha 3 I accidentally somehow deleted koha 2.2.9 (Yes, yes, stupid, I know, luckily it's not the production server yet) So, I thought, big deal, I reinstall it (for the sake of updating from there to koha 3) but I keep getting this:
Creating the MySQL database for Koha...
ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES)
DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'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 1553. Problem updating database...
I do have the password, I can login to mysql debian:/home/marty/koha-2.2.9# mysql -u kohaadmin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.
So where do I enter the password? Or what could be wrong? I had Koha 2.2.9 running fine until I screwed up....
Marty
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks Joe, but I do not have a KOHA_CONF file, I do have a koha.conf file, maybe because I have a Linux installation (Debian), its' contents are: database=koha hostname=localhost user=Koha pass='mypassword' the password is the password that allows me to log in from root using mysql -u kohaadmin -p, so I am still stuck... Marty --- On Mon, 2/2/09, Joe Atzberger <ohiocore@gmail.com> wrote:
From: Joe Atzberger <ohiocore@gmail.com> Subject: Re: [Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9 setup To: ontariowolf64@yahoo.com Cc: "koha koha" <koha@lists.katipo.co.nz> Date: Monday, February 2, 2009, 8:25 PM The password goes in your KOHA_CONF file. For 2.2 that should be a flat text file. --joe
On Mon, Feb 2, 2009 at 8:07 PM, Marty <ontariowolf64@yahoo.com> wrote:
I am making my own life miserable.... While installing koha 3 I accidentally somehow deleted koha 2.2.9 (Yes, yes, stupid, I know, luckily it's not the production server yet) So, I thought, big deal, I reinstall it (for the sake of updating from there to koha 3) but I keep getting this:
Creating the MySQL database for Koha...
ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES)
DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'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 1553. Problem updating database...
I do have the password, I can login to mysql debian:/home/marty/koha-2.2.9# mysql -u kohaadmin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.
So where do I enter the password? Or what could be wrong? I had Koha 2.2.9 running fine until I screwed up....
Marty
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Marty, Granting permissions to this user on the koha database might work. Rgds, Savitra Nucsoft OSS Labs www.osslabs.biz On Tue, Feb 3, 2009 at 8:45 AM, Marty <ontariowolf64@yahoo.com> wrote:
Thanks Joe, but I do not have a KOHA_CONF file, I do have a koha.conf file, maybe because I have a Linux installation (Debian), its' contents are: database=koha hostname=localhost user=Koha pass='mypassword'
the password is the password that allows me to log in from root using mysql -u kohaadmin -p, so I am still stuck...
Marty
--- On Mon, 2/2/09, Joe Atzberger <ohiocore@gmail.com> wrote:
From: Joe Atzberger <ohiocore@gmail.com> Subject: Re: [Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9 setup To: ontariowolf64@yahoo.com Cc: "koha koha" <koha@lists.katipo.co.nz> Date: Monday, February 2, 2009, 8:25 PM The password goes in your KOHA_CONF file. For 2.2 that should be a flat text file. --joe
On Mon, Feb 2, 2009 at 8:07 PM, Marty <ontariowolf64@yahoo.com> wrote:
I am making my own life miserable.... While installing koha 3 I accidentally somehow deleted koha 2.2.9 (Yes, yes, stupid, I know, luckily it's not the production server yet) So, I thought, big deal, I reinstall it (for the sake of updating from there to koha 3) but I keep getting this:
Creating the MySQL database for Koha...
ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES)
DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'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 1553. Problem updating database...
I do have the password, I can login to mysql debian:/home/marty/koha-2.2.9# mysql -u kohaadmin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.
So where do I enter the password? Or what could be wrong? I had Koha 2.2.9 running fine until I screwed up....
Marty
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks, but does not work... I did: mysql> GRANT ALL ON Koha.* TO 'kohaadmin'@'localhost' IDENTIFIED BY 'mypassword'; Query OK, 0 rows affected (0.06 sec) But I am actually granting privileges on a database that does not yet exist? Anyway, it does not work, I still get: CREATING DATABASE Creating the MySQL database for Koha... ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using passwo rd: YES) DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'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 1553. Problem updating database... I also found that when entering a password for the database I get this message; Password for database user kohaadmin: password Use of uninitialized value in concatenation (.) or string at Install.pm line 1358, <STDIN> line 10. Does that matter anyhow? Thanks, Marty --- On Mon, 2/2/09, savitra sirohi <savitra.sirohi@osslabs.biz> wrote:
From: savitra sirohi <savitra.sirohi@osslabs.biz> Subject: Re: [Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9 setup To: ontariowolf64@yahoo.com Cc: "Joe Atzberger" <ohiocore@gmail.com>, "koha koha" <koha@lists.katipo.co.nz> Date: Monday, February 2, 2009, 11:34 PM Marty,
Granting permissions to this user on the koha database might work.
Rgds, Savitra Nucsoft OSS Labs www.osslabs.biz
Thanks Joe, but I do not have a KOHA_CONF file, I do have a koha.conf file, maybe because I have a Linux installation (Debian), its' contents are: database=koha hostname=localhost user=Koha pass='mypassword'
the password is the password that allows me to log in from root using mysql -u kohaadmin -p, so I am still stuck...
Marty
--- On Mon, 2/2/09, Joe Atzberger <ohiocore@gmail.com> wrote:
From: Joe Atzberger <ohiocore@gmail.com> Subject: Re: [Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9 setup To: ontariowolf64@yahoo.com Cc: "koha koha" <koha@lists.katipo.co.nz> Date: Monday, February 2, 2009, 8:25 PM The password goes in your KOHA_CONF file. For 2.2
should be a flat text file. --joe
On Mon, Feb 2, 2009 at 8:07 PM, Marty <ontariowolf64@yahoo.com> wrote:
I am making my own life miserable.... While installing koha 3 I accidentally somehow deleted koha 2.2.9 (Yes, yes, stupid, I know, luckily it's not the production server yet) So, I thought, big deal, I reinstall it (for
On Tue, Feb 3, 2009 at 8:45 AM, Marty <ontariowolf64@yahoo.com> wrote: that the sake
of updating from
there to koha 3) but I keep getting this:
Creating the MySQL database for Koha...
ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES)
DBI
connect('Koha:localhost','kohaadmin',...)
user 'kohaadmin'@'localhost' (using
failed: Access denied for 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 1553. Problem updating database...
I do have the password, I can login to mysql debian:/home/marty/koha-2.2.9# mysql -u kohaadmin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.
So where do I enter the password? Or what could be wrong? I had Koha 2.2.9 running fine until I screwed up....
Marty
Koha mailing list Koha@lists.katipo.co.nz
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Marty a écrit :
pass='mypassword'
do you mean you have ' on this line ? If yes, then you must type it : 'mypassword' , not mypassword HTH -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
participants (4)
-
Joe Atzberger -
Marty -
paul POULAIN -
savitra sirohi