Hi, I'm installing Koha on CentOS 4.3. I've installed mysql-4.1.12-3 and all required Perl mods. But it gives me the error: 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've searched the list archives and seen this error in relation to MySQL5, so doesn't seem applicable in my case. Any idea what I'm doing wrong? -- Jochum
Hi, I'm sorry to bug the list with this question again, but I really need some help with the error I get below when running the installer script. 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 did forgot to mention that also get the following error during the Perl module check: Checking perl modules ... Subroutine PDF::API2::Resource::Font::Postscript::O_RDONLY redefined at /usr/lib/perl5/5.8.5/Exporter.pm line 65. at /usr/lib/perl5/site_perl/5.8.5/PDF/API2/Resource/Font/Postscript.pm line 46 Thanks in advance, -Jochum Jochum van der Heide wrote:
Hi,
I'm installing Koha on CentOS 4.3. I've installed mysql-4.1.12-3 and all required Perl mods. But it gives me the error:
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've searched the list archives and seen this error in relation to MySQL5, so doesn't seem applicable in my case.
Any idea what I'm doing wrong?
Hello, Folks - I am a Computer Tech for a public library in Michigan. We are looking at Koha as a possible replacement for our aging Dynix system. I have Koha running in a VMware virtual machine, running on Ubuntu Server 7.04. The install was not at all easy, but what do you want for free, eh? When I tried to add a user, the first thing Koha told me is that the card number was "Invalid cardnumber". We use a 14-digit codabar barcoded patron library card system. An example is "23330001535735". It is crucial that we be able to keep this intact, otherwise we will not be able to even consider Koha. Is there a way to modify this? Where is the documentation that talks about such things? Thanks very much, Mark
On 24/04/2007, at 11:35 AM, Mark Ehle wrote:
Hello, Folks -
I am a Computer Tech for a public library in Michigan. We are looking at Koha as a possible replacement for our aging Dynix system.
I have Koha running in a VMware virtual machine, running on Ubuntu Server 7.04. The install was not at all easy, but what do you want for free, eh?
When I tried to add a user, the first thing Koha told me is that the card number was "Invalid cardnumber". We use a 14-digit codabar barcoded patron library card system. An example is "23330001535735". It is crucial that we be able to keep this intact, otherwise we will not be able to even consider Koha.
Hi Mark First thing Id check is in systempreferences because Koha allows up to 16 chars in the database. Check the members/patron tab in systempreferences make sure no checkdigit routine is turned on. If its set to none, then let me know and ill have a look at the code. You installed version 2.2.8 right? http://www.kohadocs.org/newbieguide.html and http://www.kohadocs.org/usersguide/ Might be useful Chris -- Chris Cormack chris.cormack@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131
Chris - Thanks so much for the reply. I'm wondering if maybe there was a problem with my install. I am using 2.2.8. When I install it, there is a series of errors (this is just a snippet): DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2145. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. I would guess that this needs to be fixed first. What am I missing? Thanks again! Mark Quoting Chris Cormack <crc@liblime.com>:
On 24/04/2007, at 11:35 AM, Mark Ehle wrote:
Hello, Folks -
I am a Computer Tech for a public library in Michigan. We are looking at Koha as a possible replacement for our aging Dynix system.
I have Koha running in a VMware virtual machine, running on Ubuntu Server 7.04. The install was not at all easy, but what do you want for free, eh?
When I tried to add a user, the first thing Koha told me is that the card number was "Invalid cardnumber". We use a 14-digit codabar barcoded patron library card system. An example is "23330001535735". It is crucial that we be able to keep this intact, otherwise we will not be able to even consider Koha.
Hi Mark
First thing Id check is in systempreferences because Koha allows up to 16 chars in the database. Check the members/patron tab in systempreferences make sure no checkdigit routine is turned on. If its set to none, then let me know and ill have a look at the code.
You installed version 2.2.8 right?
http://www.kohadocs.org/newbieguide.html and http://www.kohadocs.org/usersguide/
Might be useful
Chris
-- Chris Cormack chris.cormack@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On 24/04/2007, at 12:06 PM, Mark Ehle wrote:
Chris -
Thanks so much for the reply.
I'm wondering if maybe there was a problem with my install.
I am using 2.2.8. When I install it, there is a series of errors (this is just a snippet):
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2145. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153.
I would guess that this needs to be fixed first.
Hmm is there an error before that that might explain why systempreferences wasnt created? And what version of mysql are you using? Chris -- Chris Cormack chris.cormack@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131
I bet it's MySQL 5.x. I had similar errors installing 2.2.8 the first time because of the return key word problem. Mark if you are using MySQL 5 then see this reply I sent Friday. http://thread.gmane.org/gmane.comp.misc.koha/7429/focus=7430 You'll have to fix koha.mysql, dump the database and reinstall. At least that's what I had to do... Mike D. -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz]On Behalf Of Chris Cormack Sent: April 23, 2007 8:11 PM To: Mark Ehle Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha patron card number length On 24/04/2007, at 12:06 PM, Mark Ehle wrote:
Chris -
Thanks so much for the reply.
I'm wondering if maybe there was a problem with my install.
I am using 2.2.8. When I install it, there is a series of errors (this is just a snippet):
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2145. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153.
I would guess that this needs to be fixed first.
Hmm is there an error before that that might explain why systempreferences wasnt created? And what version of mysql are you using? Chris -- Chris Cormack chris.cormack@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks, Chris, Mike - My installation is much happier now. Our library card barcode numbers work just fine. Next task is to convince the management that this is the way to go! Thanks again - Mark Quoting Mike Dalgity <dalgity@htl.net>:
I bet it's MySQL 5.x. I had similar errors installing 2.2.8 the first time because of the return key word problem. Mark if you are using MySQL 5 then see this reply I sent Friday. http://thread.gmane.org/gmane.comp.misc.koha/7429/focus=7430 You'll have to fix koha.mysql, dump the database and reinstall. At least that's what I had to do...
Mike D.
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz]On Behalf Of Chris Cormack Sent: April 23, 2007 8:11 PM To: Mark Ehle Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha patron card number length
On 24/04/2007, at 12:06 PM, Mark Ehle wrote:
Chris -
Thanks so much for the reply.
I'm wondering if maybe there was a problem with my install.
I am using 2.2.8. When I install it, there is a series of errors (this is just a snippet):
DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2145. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at s cripts/updater/updatedatabase line 2153.
I would guess that this needs to be fixed first.
Hmm is there an error before that that might explain why systempreferences wasnt created?
And what version of mysql are you using?
Chris -- Chris Cormack chris.cormack@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131
_______________________________________________ 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
Jochum van der Heide <jochum.vanderheide@lifehope.om.org> wrote:
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 you connect as kohaadmin from the prompt? Command should be: mysql -u kohaadmin -h localhost -p If not, then it's a mysql administration problem.
I did forgot to mention that also get the following error during the Perl module check: Checking perl modules ... Subroutine PDF::API2::Resource::Font::Postscript::O_RDONLY redefined at /usr/lib/perl5/5.8.5/Exporter.pm line 65. at /usr/lib/perl5/site_perl/5.8.5/PDF/API2/Resource/Font/Postscript.pm line 46
That's irrelevant: PDF::API2 has changed since the installer test was written. Regards, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
Hi MJ, MJ Ray wrote:
Jochum van der Heide <jochum.vanderheide@lifehope.om.org> wrote:
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 you connect as kohaadmin from the prompt? Command should be: mysql -u kohaadmin -h localhost -p
If not, then it's a mysql administration problem.
Interresting. Just tried your command and it doesn't let me in with the password I entered when prompted by the Koha installer. ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES) If I just click enter when prompted for the password (so empty password) then it lets me in fine. Does this mean that the Koha installer doesn't pass on the kohaadmin password to mysqld correctly? or is it something to do with my mysql configuration? -Jochum
Jochum van der Heide <jochum.vanderheide@lifehope.om.org> wrote:
If I just click enter when prompted for the password (so empty password) then it lets me in fine. Does this mean that the Koha installer doesn't pass on the kohaadmin password to mysqld correctly? or is it something to do with my mysql configuration?
It means the kohaadmin password hasn't been site correctly. I'm not sure whose fault that is. Did the password contain any shell special characters (!$ quotes and a few others)? If so, it's the installer being broken. The installer is currently being rewritten (cue cheers) but I have hit a problem that I've yet to email to koha-devel (boo!). While I'm writing here: does anyone know a complicated (one with extra modules) perl web application with a particularly good installation? Thanks, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
MJ Ray wrote:
The installer is currently being rewritten (cue cheers) but I have hit a problem that I've yet to email to koha-devel (boo!). While I'm writing here: does anyone know a complicated (one with extra modules) perl web application with a particularly good installation?
I'm not sure if these projects use perl, but they are rather large. I've never used them myself, so do not know: MythTV GnuCash Could I provide a bit of installer feedback? (a) it should be easier to get out of the damn thing! when things go wrong during install, Ctrl-C is intercepted by a signal handler and I cannot exit ungracefully. (b) readline support is required, or at least the ability to edit a line of input. So may times I have mistyped something and had to start again from scratch. On average, for one Koha install, I seem to have to run the script about ten times, fixing things up as I go along. (c) Make it easier to re-run the installer, perhaps with a --uninstall option. Right now each time I re-run, I must remove files in /etc, files in /usr/local/koha and drop the database. The set of Perl modules that works with Koha version X (e.g. 2.2.8) should be cast in concrete. e.g. if XML::Parser version 3.2 works with Koha 2.2.8, then XML::Parser/3.2 should be downloaded and form part of the the Koha set of sources. It is asking for trouble (MUCH trouble!) to allow CPAN to download the latest set of everything and "hope" it will all fit together. I find it never does. In the process of installing perl modules prior to running installer.pl, something always breaks via CPAN, i.e. a version of one module has changed which now breaks its relationship with another module. I've worked with Perl for ten years now and one thing learned the hard way is that for a given project version, always download and nail down a compatible working set of perl Modules that work with your project. And never upgrade or change those modules without thorough unit and integration testing. We should be using the power of open source in Koha to its full advantage. Would it be possible starting at Koha/3.0 to make a tarball available containing all the required perl modules, versions of which are known to be compatible with each other and Koha itself? I cannot see any other way to guarantee a smooth and painless install. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Klingon function calls do not have parameters, they have 'arguments' and they ALWAYS win them.
Rick Welykochy <rick@praxis.com.au> wrote:
Could I provide a bit of installer feedback?
You can, but it's not going to be used in a direct way. I can't remember how much of this has been published yet, but where's why: 1. the current installer will die. It's a bit hack-after-hack-after-hack, doesn't handle several complications terribly well, isn't very portable and mixes up sysadmin and librarian options. Unless you have both people available during installation (or a sysadmin who knows what to ask the librarian), it can require several attempts to get a fully-working install. I hope it will die during 2.2.x but definitely by 3.0. 2. there will be a sysadmin installer and a librarian installer. The sysadmin installer will handle things like getting the right perl modules, installing koha's files and configuring apache. HDL is writing a great web-based installer for the librarian parts which does the superlibrarian and database setup and does some other things. I think that works for some people, but had hit a design problem which needed a bit more thinking last I heard. 3. the sysadmin installer will use standard portable tools. It's probably going to be MakeMaker (as used when you install most stuff from CPAN) if I can figure out how to install koha's cgi-bin scripts and html templates with it in a portable way. However, the method to do that is not obvious to me, which is why I'd love to find another complex perl web application to see how they do it. (Good artists copy - great artists steal.) As far as possible, it will be non-interactive, which handles the ^C point. Using MakeMaker should give us an uninstall. I hope there will be an uninstall for the librarian step too. Now, to the other relevant comment:
The set of Perl modules that works with Koha version X (e.g. 2.2.8) should be cast in concrete. e.g. if XML::Parser version 3.2 works with Koha 2.2.8, then XML::Parser/3.2 should be downloaded and form part of the the Koha set of sources. It is asking for trouble (MUCH trouble!) to allow CPAN to download the latest set of everything and "hope" it will all fit together. I find it never does. [...]
This will happen. It is necessary for the sysadmin installer too. It is actually one of the most difficult things for me: when do I require an obsolete version and when do I upgrade the Koha code to use the current one? Bundling XML::Parser/3.2 with the main release of Koha would cause other problems for packaged distributions, but maybe there should be a Koha-comprehensive download as well as the usual Koha release. What do others think about this? With the MakeMaker installer, I think I may be able to make CPAN install a particular version rather than the latest version, but I could be wrong about that. Regards, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
MJ Ray wrote:
Jochum van der Heide <jochum.vanderheide@lifehope.om.org> wrote:
If I just click enter when prompted for the password (so empty password) then it lets me in fine. Does this mean that the Koha installer doesn't pass on the kohaadmin password to mysqld correctly? or is it something to do with my mysql configuration?
It means the kohaadmin password hasn't been site correctly. I'm not sure whose fault that is. Did the password contain any shell special characters (!$ quotes and a few others)? If so, it's the installer being broken.
No, the password doesn't use any special characters. Is there anyway to debug this or manually work around this installer problem? -Jochum
I've just found out what the problem was. I was playing with adding different mysql users, but all of those users wouldn't connect to the database with the password supplied, but did connect by just clicking enter when prompted for the password. I then discovered that there were 2 Anonymous users installed already (added by the mysql-server rpm I assume). After deleting those users I could connect using the passwords and the Koha installer ran without any problems. So not a Koha installer bug after all ;-) Hope this helps others with similar problems as well. Thanks for all those who replied to my questions, -Jochum Jochum van der Heide wrote:
MJ Ray wrote:
Jochum van der Heide <jochum.vanderheide@lifehope.om.org> wrote:
If I just click enter when prompted for the password (so empty password) then it lets me in fine. Does this mean that the Koha installer doesn't pass on the kohaadmin password to mysqld correctly? or is it something to do with my mysql configuration?
It means the kohaadmin password hasn't been site correctly. I'm not sure whose fault that is. Did the password contain any shell special characters (!$ quotes and a few others)? If so, it's the installer being broken.
No, the password doesn't use any special characters. Is there anyway to debug this or manually work around this installer problem?
-Jochum _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
It means the kohaadmin password hasn't been site correctly. I'm not sure whose fault that is. Did the password contain any shell special characters (!$ quotes and a few others)? If so, it's the installer being broken.
I also experienced problems with installing Koha 2.2.8 last week (FreeBSD 6.2/MySQL 4.1/Perl 5.8). I gave up in the end (I never used anything other then alphanumeric characters) trying to figure out why the password was not working. In the end, I made the following changes (oh not so good for real production environments though!) Line 1803: I commented it out; system("$mysqldir/bin/mysql '-u$mysqluser' ... so that becomes #system... After line 1803, I inserted two lines:
$user=$mysql; $pass=$mysqlpass;
This way, the system installed with the mysql 'root' user and the password.
The installer is currently being rewritten (cue cheers) but I have hit a problem that I've yet to email to koha-devel (boo!). While I'm writing here: does anyone know a complicated (one with extra modules) perl web application with a particularly good installation?
My personal favorite installer for a web based application is for Typo3 (Sorry, not perl - php) ... You copy it to a folder, and the remainder is done via the web. You could maybe however consider some way with simple menus, and/or a chance to review the options given in the end before commiting everything. As somebody else wrote, I second the idea of being able to stop it with ctrl-c... Looking forward to working more with Koha! Andrew Seguin
On Tue, 24 Apr 2007, MJ Ray wrote: ---snip---
The installer is currently being rewritten (cue cheers) but I have hit a problem that I've yet to email to koha-devel (boo!). While I'm writing here: does anyone know a complicated (one with extra modules) perl web application with a particularly good installation?
discus. www.discusware.com uses web setup, all perl.
Ron Wickersham <rjw@mail.alembic.net> wrote:
On Tue, 24 Apr 2007, MJ Ray wrote:
[...] does anyone know a complicated (one with extra modules) perl web application with a particularly good installation?
discus. www.discusware.com
uses web setup, all perl.
Thanks. I took a look. First, the disappointment: the discus installer is actually less advanced than our current installer, so it doesn't handle any of the complications that have broken ours (VirtualHosts, databases, multiple installs). It has lots of toggles for Unix or Windows, which I'd really like to avoid if possible because it makes it harder to support Windows users when they hit problems. The discus installer doesn't handle prerequisites at all - it just says in the licence that your warranty is void if you don't have the prerequisites already. I know our current checker is broken, but at least we check. Voiding users who don't have all the modules yet isn't an option for a GPL'd package like Koha. Discus has one extra module, which it just copies it into the source tree, as far as I can see. I'm not sure that's a good idea for something like Koha which uses lots of its own modules. Now the good: It does have one very good feature which Koha should imitate. If the installer can't write a config file (permissions or other reasons), it displays it as text for the user to copy-paste into the right place. So, thanks for the tip, as we got an idea from it. Any more suggestions of complex perl web applications? Thanks, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
participants (8)
-
Andrew Seguin -
Chris Cormack -
Jochum van der Heide -
Mark Ehle -
Mike Dalgity -
MJ Ray -
Rick Welykochy -
Ron Wickersham