Re: [Koha] Authorization problems between Koha and Mysql
Thank you for your quick responce.
DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at /usr/local/koha/intranet/modules/C4/Auth.pm line 351.
My first thought is that the database did not install completely. There should be 60 or so tables. Can you check whether there are in your copy? (Connect to mysql and enter "show tables;" IIRC)
mysql> use Koha; mysql> show tables; +--------------------+ | Tables_in_Koha | +--------------------+ | accountlines | | accountoffsets | | additionalauthors | | aqbookfund | | aqbooksellers | | aqbudget | | aqorderbreakdown | | aqorderdelivery | | aqorders | | biblio | | biblioanalysis | | biblioitems | | bibliosubject | | bibliosubtitle | | borexp | | borrowers | | branchcategories | | branches | | branchtransfers | | catalogueentry | | categories | | categoryitem | | classification | | currency | | deletedbiblio | | deletedbiblioitems | | deletedborrowers | | deleteditems | | issues | | items | | itemsprices | | itemtypes | | multipart | | multivolume | | newitems | | printers | | procedures | | publisher | | reserveconstraints | | reserves | | searchstats | | serialissues | | statistics | | stopwords | | systempreferences | | users | +--------------------+ 46 rows in set (0.00 sec) -------------------------------------------------
On 2004-10-30 05:45:44 +0100 csg7142@students.kennesaw.edu wrote:
My first thought is that the database did not install completely. There should be 60 or so tables. Can you check whether there are in your copy? (Connect to mysql and enter "show tables;" IIRC) mysql> use Koha; mysql> show tables; [...] 46 rows in set (0.00 sec)
You are missing a number of tables. Check your installation log for problems, if you made one. You may be able to fix this by running scripts/updater/updatedatabase manually, but I've not tried that recently. Let us know how it goes, please. -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Will HLF fund tree-killings? http://www.thewalks.co.uk/
Quoting MJ Ray <mjr@dsl.pipex.com>:
On 2004-10-30 05:45:44 +0100 csg7142@students.kennesaw.edu wrote:
My first thought is that the database did not install completely. There should be 60 or so tables. Can you check whether there are in your copy? (Connect to mysql and enter "show tables;" IIRC) mysql> use Koha; mysql> show tables; [...] 46 rows in set (0.00 sec)
You are missing a number of tables. Check your installation log for problems, if you made one. You may be able to fix this by running scripts/updater/updatedatabase manually, but I've not tried that recently.
Let us know how it goes, please.
bash# pwd /usr/local/koha/intranet/scripts/updater bash-2.05b# perl updatedatabase -I /usr/local/koha/intranet/modules/C4 Can't locate C4/Context.pm in @INC (@INC contains: /usr/libdata/perl5/i386- openbsd/5.8.0 /usr/local/libdata/perl5/i386- openbsd/5.8.0 /usr/libdata/perl5 /usr/local/libdata/perl5 /usr/local/libdata/per l5/site_perl/i386-openbsd /usr/libdata/perl5/site_perl/i386- openbsd /usr/local/libdata/perl5/site_perl /usr/libdata/perl5/site_perl /usr/loc al/lib/perl5/site_perl .) at updatedatabase line 22. BEGIN failed--compilation aborted at updatedatabase line 22. As for the installation log I am not sure where it would reside, I checked in the dir where I put the tar ball /usr/src/koha-2.0.1 and the koha error logs are /usr/local/koha/log/. -------------------------------------------------
On 2004-10-31 21:20:34 +0000 csg7142@students.kennesaw.edu wrote:
bash-2.05b# perl updatedatabase -I /usr/local/koha/intranet/modules/C4
Can't locate C4/Context.pm [...]
Try without the C4 on the end of the command.
As for the installation log I am not sure where it would reside, I checked in the dir where I put the tar ball /usr/src/koha-2.0.1 and the koha error logs are /usr/local/koha/log/.
No, I meant your logbook. Some sysadmins keep logbooks and some use the "script" command to record installations. If you don't do either, then we probably can't figure out what went wrong. This is probably a problem, so: What would users think of install.pl and upgrade.pl saving a log file in the current directory when run? Good/bad/indifferent? Home directory instead? Thanks for persevering(sp!) -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Will HLF fund tree-killings? http://www.thewalks.co.uk/
On Sun, Oct 31, 2004 at 10:39:04PM +0000, MJ Ray said:
What would users think of install.pl and upgrade.pl saving a log file in the current directory when run? Good/bad/indifferent? Home directory instead?
I think its a good idea. Current directory sounds fine. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Hi all I installed Koha last weekend. Installation went fine, its a nice program. Im evaluating it for use by the Royal Society of NSW's library. http://nsw.royalsoc.org.au so thought I'd better join the list. Most things seems to be working fine. I have gone through and setup most of the things in the "System parameters". I tried the "MARC biblio export" and as it says "leave blank to export every biblio" thats what I did. I had loaded the sample data and so I have biblio info in there - I can search for and find it. But when I click Export it just saves an empty 'marc.pl' file. I expected lots of MARC stuff. If I goto: koha/intranet/cgi-bin/export and try export$ perl -I /home/rsnsw/koha/intranet/modules ./marc.pl I get: DBI connect(':','',...) failed: Access denied for user: 'mikel@localhost' (Using password: NO) at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 368 DBI connect(':','',...) failed: Access denied for user: 'mikel@localhost' (Using password: NO) at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 368 Can't call method "selectrow_array" on an undefined value at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 320. export$ What should I try/look at to solve this? I am using Koha version: 2.0.1RC1 -- Mike Lake Caver, Linux enthusiast and interested in anything technical. -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
Hi again One more bit of info that is prob important. Michael Lake wrote:
If I goto: koha/intranet/cgi-bin/export and try export$ perl -I /home/rsnsw/koha/intranet/modules ./marc.pl
I get:
DBI connect(':','',...) failed: Access denied for user: 'mikel@localhost' (Using password: NO) at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 368 DBI connect(':','',...) failed: Access denied for user: 'mikel@localhost' (Using password: NO) at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 368 Can't call method "selectrow_array" on an undefined value at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 320. export$
The mikel above is my login name for the laptop running Koha. The name of the Administrator for using the Intranet part is a different name. I have a .my.cnf file in my root dir which provides shell access to MySQL so the script should be able to access the koha database. I can access it via mysql at the command line as mikel. Mike -- Mike Lake Caver, Linux enthusiast and interested in anything technical. -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
On 2004-11-02 06:26:25 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote: [...]
loaded the sample data and so I have biblio info in there - I can search for and find it. But when I click Export it just saves an empty 'marc.pl' file. I expected lots of MARC stuff.
I'll take a look at this when testing 2.0.2beta0. It used to work.
If I goto: koha/intranet/cgi-bin/export and try
export$ perl -I /home/rsnsw/koha/intranet/modules ./marc.pl I get: DBI connect(':','',...) failed: Access denied for user: 'mikel@localhost' (Using password: NO) at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 368
You may need to put KOHACONF=/hoem/rsnsw/koha.conf on the start of that line, as it looks like Context.pm isn't finding the login details. This is a direct connect, so I think my.cnf hasn't anything to do with it. -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Unsolicited attachments to the pipex address deleted Will HLF fund tree-killings? http://www.thewalks.co.uk/
MJ Ray wrote:
On 2004-11-02 06:26:25 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote:
[...]
loaded the sample data and so I have biblio info in there - I can search for and find it. But when I click Export it just saves an empty 'marc.pl' file. I expected lots of MARC stuff.
I'll take a look at this when testing 2.0.2beta0. It used to work.
If I goto: koha/intranet/cgi-bin/export and try
export$ perl -I /home/rsnsw/koha/intranet/modules ./marc.pl I get: DBI connect(':','',...) failed: Access denied for user: 'mikel@localhost' (Using password: NO) at /home/rsnsw/koha/intranet/modules/C4/Context.pm line 368
You may need to put KOHACONF=/hoem/rsnsw/koha.conf on the start of that line, as it looks like Context.pm isn't finding the login details. This is a direct connect, so I think my.cnf hasn't anything to do with it.
My koha.conf is still in /etc/koha.conf I see in Context.pm that there is "use constant CONFIG_FNAME => "/etc/koha.conf"; so that should be fine. The koha directory is under a /home/rsnsw/ user. I can see though that /etc/koha.conf wasn't readable by the user rsnsw so I have changed for now the permissions of koha.conf to be readable (it's not a production system yet). I no longer get the DBI connect error. I get: Can't locate object method 'config' via package C4::Context at Output.pm line 78. I can see that config is a defined method in Context.pm and there is a 'use Context;' in Output.pm so it should have found it. The error is prob something else unrelated. I'd best get some real work done and get back to looking at this later :-) Any ideas in the meantime appreciated. Mike -- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
Michael Lake wrote:
loaded the sample data and so I have biblio info in there - I can search for and find it. But when I click Export it just saves an empty 'marc.pl' file. I expected lots of MARC stuff.
Still trying to get this working. I have reinstalled just in case. Running from command line: perl -I /home/rsnsw/koha/intranet/modules -file marc.dat just produces a page of HTML to screen now and at least no errors but no file marc.dat I see that it needs to set a cookie. Cookies are allowed in my browser and I can see the sessionID cookie from localhost there. Im still getting a zero length file from running marc.pl What should I use from the command line to test it? What do people get? I prob also need to try a marc import but I dont have a example of a single marc record. Can one be posted here as an example? I looked at the archives but didnt find an 'example'. Thanks Mike -- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
On 2004-11-02 23:15:19 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote:
MJ Ray wrote:
On 2004-11-02 06:26:25 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote:
loaded the sample data and so I have biblio info in there - I can search for and find it. But when I click Export it just saves an empty 'marc.pl' file. I expected lots of MARC stuff. I'll take a look at this when testing 2.0.2beta0. It used to work.
I've tried this on a 2.0.1 test server that I have here and it works fine. The file is called marc.pl (which we probably should fix), but it does contain MARC data. I don't know what to suggest. -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Unsolicited attachments to the pipex address deleted Will HLF fund tree-killings? http://www.thewalks.co.uk/
Hi all,
On 2004-11-02 06:26:25 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote:
loaded the sample data and so I have biblio info in there - I can search for and find it. But when I click Export it just saves an empty 'marc.pl' file. I expected lots of MARC stuff.
MJ Ray wrote:
I've tried this on a 2.0.1 test server that I have here and it works fine. The file is called marc.pl (which we probably should fix), but it does contain MARC data. I don't know what to suggest.
What exactly is the command line you are using. I was using perl -I /home/rsnsw/koha/intranet/modules marc.pl -file marc.dat (or similar, I'm on my Windows box now) Also if you type "set | grep KOHA" what do you get for the env variables in the bash shell? I have found that if none is set marc.pl prints a web page but if I have something set KOHA_CONF=/etc/koha.conf or KOHA_CONF=/etc I get an error that it can't make a DBI connection. Thus marc.pl is reading the env variable KOHA_CONF though i should not have to set it as marc.pl looks for koha.conf in /etc if there is no env variable set. Mike -- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
On 2004-11-04 22:38:54 +0000 Michael Lake <Mike.Lake@uts.edu.au> wrote:
MJ Ray wrote:
I've tried this on a 2.0.1 test server that I have here and it works fine. The file is called marc.pl (which we probably should fix), but it does contain MARC data. I don't know what to suggest. What exactly is the command line you are using.
I'm not. I'm visiting it from the web interface and clicking "Export". Doing it from the command-line is very tricky, as you found. I'm not sure exactly what settings are required to run it that way. Maybe Chris or Paul can help. -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Unsolicited attachments to the pipex address deleted Will HLF fund tree-killings? http://www.thewalks.co.uk/
MJ Ray wrote:
No, I meant your logbook. Some sysadmins keep logbooks and some use the "script" command to record installations. If you don't do either, then we probably can't figure out what went wrong. This is probably a problem, so:
What would users think of install.pl and upgrade.pl saving a log file in the current directory when run? Good/bad/indifferent? Home directory instead?
Hi all I just used script on Sat when installing koha. For those that don't know it use it like this: $script -c "perl install.pl" It's really useful as it created a transcript of the entire installation process. man script. A logfile would be useful. One thing to be mindful of when having install.pm automatically create a log file is what to do about the library admin username/password that a user chose. Best perhaps to just omit that one bit of info from the log. The advantage of a log file generated by install.pl is that it could also include more behind-the-scenes info for debugging failed installs. Mike -- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.
participants (4)
-
Chris Cormack -
csg7142＠students.kennesaw.edu -
Michael Lake -
MJ Ray