- Koha - lists.katipo.co.nz

Changed IP - Can't connect to mysql server
by Robert Linebaugh 12 May '08

12 May '08

I had to change the IP scheme of my network. I have changed the interfaces, hosts and koha.conf files to reflect the new IP. When I try to access Koha by typing http://koha.domain.com:8050 I get a 500 internal server error. My opac-error_log file says: Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] DBI connect('Koha:10.0.250.4','kohaadmin',...) failed: Can't connect to MySQL server on '10.0.250.4' (111) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] DBI connect('Koha:10.0.250.4','kohaadmin',...) failed: Can't connect to MySQL server on '10.0.250.4' (111) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Can't call method "prepare" on an undefined value at /usr/local/koha/opac/cgi-bin/opac-main.pl line 16. [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Premature end of script headers: opac-main.pl The Koha database is located on a different server that also received a new IP address. Can anyone help me determine what configuration step I have missed. I should also mention I am fairly new to Linux and Koha. Thanks for the help ******************************* Rob Linebaugh Director of Computer Services Davis College 400 Riverside Drive Johnson City, NY 13790 T: 607.729.1581 ext.404 F: 607.729.2962

4 4

DBD::mysql install error
by Chadwick, John, DCA 09 May '08

09 May '08

I am working on a fresh install of Debian 4 trying to install DBD::mysql First problem, the file would not install. Evidently the mysql_config file that lives in /usr/bin did not get installed with the mysql-server install. I copied the file from a working Ubuntu 7.10 installation. Now, the install finds the file, but I am getting a lot of errors: dbdimp.c:4395: warning: passing argument 3 of âmemcpyâ makes integer from pointer without a cast dbdimp.c:4396: error: âimp_dbh_tâ has no member named âstatsâ dbdimp.c:4396: error: request for member âauto_reconnects_failedâ in something not a structure or union dbdimp.c:4396: error: invalid lvalue in increment dbdimp.c:4399: error: âimp_dbh_tâ has no member named âstatsâ dbdimp.c:4399: error: request for member âauto_reconnects_okâ in something not a structure or union dbdimp.c:4399: error: invalid lvalue in increment dbdimp.c: In function âmysql_db_quoteâ: dbdimp.c:4559: error: âimp_dbh_tâ has no member named âmysqlâ dbdimp.c: In function âmysql_db_last_insert_idâ: dbdimp.c:4582: error: âimp_dbh_tâ has no member named âmysqlâ dbdimp.c:4582: warning: passing argument 2 of âPerl_sv_2mortalâ makes pointer from integer without a cast make: *** [dbdimp.o] Error 1 /usr/bin/make -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible cpan> DBD::mysql Any ideas? Thanks, John +----------------------------------------------------------------------------+ John Chadwick, Ed.D. Information Technology Manager New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9740 Cell: 505-629-8116 Fax: 505-476-9761 john.chadwick(a)state.nm.us http://www.nmstatelibrary.org Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.

4 5

Changed IP, Can't connect to mysql server
by Robert Linebaugh 09 May '08

09 May '08

I had to change the IP scheme of my network. I have changed the interfaces, hosts and koha.conf files to reflect the new IP. When I try to access Koha by typing http://koha.domain.com:8050 I get a 500 internal server error. My opac-error_log file says: Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] DBI connect('Koha:10.0.250.4','kohaadmin',...) failed: Can't connect to MySQL server on '10.0.250.4' (111) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] DBI connect('Koha:10.0.250.4','kohaadmin',...) failed: Can't connect to MySQL server on '10.0.250.4' (111) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Can't call method "prepare" on an undefined value at /usr/local/koha/opac/cgi-bin/opac-main.pl line 16. [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Premature end of script headers: opac-main.pl The Koha database is located on a different server that also received a new IP address. Can anyone help me determine what configuration step I have missed. I should also mention I am fairly new to Linux and Koha. Thanks for the help

1 0

Re: [Koha] Guidelines for barcodes, barcode readers, etc.
by BWS Johnson 09 May '08

09 May '08

Salvete! I vastly prefer the trigger Symbol scanners over the Metrologics. I think they read nicer, you can trigger them when the auto holder doesn't work right, and the stand seems to have it work right automatically much better. If you like torturing yourself, Koha will work with a CueCat. Cheers, Brooke

1 0

Fwd: Problems Adding Members
by Jesse 09 May '08

09 May '08

Bleh. I'm not sure how to apply patches on windows myself (the relevant one is attached). Does anybody on this list? ---------- Forwarded message ---------- From: KATHRYN J RUDOLPH <kjrudolph(a)wisc.edu> Date: Thu, May 8, 2008 at 6:27 PM Subject: Re: Problems Adding Members To: Jesse <pianohacker(a)gmail.com> Thanks, Jesse! I am totally new to this and don't know what I should be doing with the patch....sorry to ask perhaps a stupid question, but where do I go from here? Thank you so much! Katie -- Jesse

1 0

"Software error" on Web page
by Mitchell, Michael 09 May '08

09 May '08

I spent yesterday trying to get a fresh install of Debian Etch and Koha3Beta following the instructions maintained by Joshua Ferraro at http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=INSTALL.debian;h= 1c35e8098c561f3f563b9c8f5f7e5844c60cdab5;hb=HEAD. After many false starts I finally got to this point on my web browser when connecting to both the 80 and 8080 ports. I thought all the cpan/Perl modules had loaded without error but I guess not. I tried reloading the ZOOM::Z39.50 module but got a bunch of test errors this time. Anybody know what's wrong here and how I can fix it?-- Software error: Can't locate ZOOM.pm in @INC (@INC contains: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /usr/share/koha/lib/C4/Context.pm line 59. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Context.pm line 59. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 29. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. CGI::Carp Michael Mitchell Technical Services Librarian Brazosport College Lake Jackson, TX michael.mitchell at brazosport.edu

2 5

Debian fun continues
by Chadwick, John, DCA 09 May '08

09 May '08

Thanks to all who have offered advice recently. I discovered that part of the problem in my first install was that I skipped a step when installing Koha, the dselect debian packages. I finally did a clean install of the server software and started again. The only problem I had and I finally resolved it was with ImageMagick. You need to install PerlMagick as well to make everything work. Now my problem is probably very simple, but I did not have any problems like this with Ubuntu 7.10. I am using Debian Etch and I am having trouble getting port 80 or 8080 to work properly. I can go to the console (using Gnome) and use the browser to go to http://127.0.0.1 <http://127.0.0.1/> or http://127.0.0.1:8080 <http://127.0.0.1:8080/> and everything is fine. When I use the IP address I get the default IP Apache web page ("It Works!). Doesn't matter if I specify a port or not. When I edit the conf file for koha and put in the IP address, it works, but then I lose the ability to use phpmyadmin. John +----------------------------------------------------------------------- -----+ John Chadwick, Ed.D. Information Technology Manager New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9740 Cell: 505-629-8116 Fax: 505-476-9761 john.chadwick(a)state.nm.us http://www.nmstatelibrary.org Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.

1 0

koha limit storage
by Mohamed Fekry Negm 08 May '08

08 May '08

Hi all i want to ask about koha limit storage and is it any different between MYSQL versions about this point ? thank's _________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=…

1 0

little things on Debian
by Chadwick, John, DCA 08 May '08

08 May '08

Thanks to everyone who offered help and advice on getting some extra libraries installed on a fresh install of Debian Etch. I finally got Koha to install with no errors. When I fire up the web browser to the http://ipaddress:8080 <http://ipaddress:8080/> I get the following error: production mode - trapped fatal error The URL shows http://164.64.109.234:8080/cgi-bin/koha/installer/install.pl Any suggestions on this one? Thanks, John +----------------------------------------------------------------------- -----+ John Chadwick, Ed.D. Information Technology Manager New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9740 Cell: 505-629-8116 Fax: 505-476-9761 john.chadwick(a)state.nm.us http://www.nmstatelibrary.org Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.

2 1

Choon Kheng Caroline Loh-Phua/lib/staff/npnet is out of the office.
by Caroline Loh 07 May '08

07 May '08

I will be out of the office starting 08/05/2008 and will not return until 12/05/2008. Please contact Ms Lim Li Hoon, Librarian at ext 6284 for any library matters. If you need to reach me, please call my Secretary, Norlizah at ext 6280 . Best regards Caroline NOTICE: This message may contain privileged/confidential information. If you are not the intended recipient of this email, please delete it immediately and notify the sender .

1 0