Dear Marc, After struggling hard for last one month we could find solution for DBD mysql error on Debian 5.0.1 and 5.0.2. We tried installing KOHA on Either Debian 5.0.1 or 5.0.2 and we followed following steps and it worked successfully. Pl. try these steps and check. 1. While Installing Debian we selected only Desktop & Standard Installation. 2. After logging into the system installed apache2 and mysql related all files (such as apache2, apache2.2-common, apache2-util, apache2-mod-perl2, apache2-mod-php5, apache2-mod-python, apache2-reload-perl, apache2-mpm-worker, libdbd-mysql, libdbd-mysql-perl, libdbd-sqlit3-perl, libdbi-perl, libmysqlclient15-dev, libmysqlclient15off, mysql-admin, mysql-client, mysql-common, mysql-server, mysql-server-5.0) through Synaptic instead of installing them through "sudo dselect" command. 3. Edited file koha-3.00.03/install_misc/debian-lenny.packages and deleted the lines apache2-install, apache2-mpm-worker-install, libdbd-mysql-perl install, libdbd-mysql-perl, libdbd-sqlite3-install, libdbi-perl install lines. 4. Now run "sudo dselect" command and it will install all other perl libraries than mysql and apache2 as well as libdbd and libdbi related files. 5. We found that when we run "dselect" command it tries to install latest dbi and dbd related files along with mysql where there is mismatch and we get DBD error. But if we do not install mysql and libdbd-mysql, libdbd-mysql-perl and libdbi-perl files through dselect and install them through synaptic it solves the DBD error problem. 6. While mysql is installed through synaptic it installes libdbd-mysql-perl/libdbi-perl automatically. 7. Installing mysql through synaptic takes care of proper file version requirements of libdbd-mysql, libdbd-mysql-perl & libdbi-perl hence we do not have to install them separately. 8. Then run further steps for KOHA installation as mentioned in INSTALL.debian-lenny file. 9. We have tried these steps and we could run the KOHA sucessfully. If it works for you as well then it is necessary that KOHA installation manual for INSTALL.debian-lenny needs to be updated. reg, Sunita Barve NCRA, Pune On Fri, Jul 31, 2009 at 9:03 PM, <koha-request@lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Re: DBD driver has not implemented the AutoCommit attribute (Marc N?rnberger) 2. Re: MARC record import (Cab Vinton) 3. Re: MARC record import (Walls, Ian) 4. Re: MARC record import (Owen Leonard) 5. Mahalya Havard est absent(e). (Mahalya_Havard@ssss.gouv.qc.ca) 6. Re: MARC record import (Cab Vinton) 7. marc record matching rules, not working (Scott) 8. Re: MARC record import (Harris, Gary, DCA)
----------------------------------------------------------------------
Message: 1 Date: Fri, 31 Jul 2009 16:38:22 +0200 From: Marc N?rnberger <marc.nuernberger@gmx.de> Subject: Re: [Koha] DBD driver has not implemented the AutoCommit attribute To: Joe Atzberger <ohiocore@gmail.com> Cc: Koha List <koha@lists.katipo.co.nz> Message-ID: <4A7301DE.4050302@gmx.de> Content-Type: text/plain; charset=UTF-8; format=flowed
Dear Joe,
Thanks for your advice! Unfortunately a Centos (Perl 5.8.8, koha 3.00.03) install, leads finally to the same error on the intranet page:
DBD driver has not implemented the Autocommit attribute at /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBI.pm line 705
Any idea?
Best, Marc
Joe Atzberger schrieb:
Weird. I think this came up before, without resolution. Maybe try with perl 5.8.8?
-- Joe Atzberger LibLime - Open Source Library Solutions
2009/6/17 Marc N?rnberger <marc.nuernberger@gmx.de <mailto:marc.nuernberger@gmx.de>>
Dear all,
I am struggling hard with this DBD driver problem, ever since I did one reboot on an lenny & perl 5.10 & Koha 3.00.02-final. Make test always fails with the below message.
On a test system the same combination is running just fine. So I thought it's just a matter of the right Perl modules, DBI and DBD::mysql. But no matter if I use the latest packages, or the working combination of DBI 1.605 and DBD:mysql 4.007 from the test system, I cannot get past this one...
Any suggestions, what could be a next step in troubleshooting? Thanks a lot.
Best regards, Marc
*****************************************
t/Circulation_barcodedecode.t .. 1/16 # Failed test 'use C4::Circulation;' # at t/Circulation_barcodedecode.t line 10. # Tried to use 'C4::Circulation'. # Error: DBD driver has not implemented the AutoCommit attribute at /usr/local/lib/perl/5.10.0/DBI.pm line 690. # Compilation failed in require at /root/kohaclone/blib/PERL_MODULE_DIR/C4/Circulation.pm line 25. # BEGIN failed--compilation aborted at /root/kohaclone/blib/PERL_MODULE_DIR/C4/Circulation.pm line 25. # Compilation failed in require at (eval 4) line 2. # BEGIN failed--compilation aborted at (eval 4) line 2. Undefined subroutine &C4::Circulation::barcodedecode called at t/Circulation_barcodedecode.t line 31. # Looks like you planned 16 tests but ran 1. # Looks like you failed 1 test of 1 run. # Looks like your test exited with 255 just after 1. t/Circulation_barcodedecode.t .. Dubious, test returned 255 (wstat 65280, 0xff00) Failed 16/16 subtests
****************************************** Test Summary Report ------------------- t/Circulation_barcodedecode.t (Wstat: 65280 Tests: 1 Failed: 1) Failed test: 1 Non-zero exit status: 255 Parse errors: Bad plan. You planned 16 tests but ran 1. t/Dates.t (Wstat: 65280 Tests: 135 Failed: 9) Failed tests: 127-135 Non-zero exit status: 255 Parse errors: Bad plan. You planned 126 tests but ran 135. Files=21, Tests=183, 3 wallclock secs ( 0.08 usr 0.02 sys + 2.48 cusr 0.18 csys = 2.76 CPU) Result: FAIL Failed 2/21 test programs. 10/183 subtests failed. make: *** [test_dynamic] Fehler 255
------------------------------
Message: 2 Date: Fri, 31 Jul 2009 10:54:19 -0400 From: Cab Vinton <bibliwho@gmail.com> Subject: Re: [Koha] MARC record import To: Kyle Hall <kyle.m.hall@gmail.com> Cc: Koha list <koha@lists.katipo.co.nz> Message-ID: <835777770907310754w261f9c62jfda5814d46010389@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
http://library.minlib.net/search/#
SirsiDynix catalogs also present options for displaying MARC records that could be copied. One example:
http://catalog.dalnet.lib.mi.us/ http://catalog.dalnet.lib.mi.us/ipac20/ipac.jsp?full=3100001~!431721~!1&fullmarc=true
But in this instance, some processing would be required as the tags & tag contents end up on separate lines.
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
On Fri, Jul 31, 2009 at 9:57 AM, Kyle Hall<kyle.m.hall@gmail.com> wrote:
Is that a MicroLIF format? I think I might have a script laying around that could help you.
Kyle
http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )
------------------------------
Message: 3 Date: Fri, 31 Jul 2009 11:10:47 -0400 From: "Walls, Ian" <Ian.Walls@med.nyu.edu> Subject: Re: [Koha] MARC record import To: Koha list <koha@lists.katipo.co.nz> Message-ID: <543F9234BDD8434A8D45C3D6337B7C8E1956EBDF@MSGWSDCPMB07.nyumc.org> Content-Type: text/plain; charset="us-ascii"
Perhaps some kind of script to parse each line of the text file into MARCXML; it would mostly just be adding XML wrappers around the data, so I doubt it'd be horrible to code up.
Ian Walls Systems Integration Librarian NYU Health Sciences Libraries 550 First Ave., New York, NY 10016 (212) 263-8687
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Cab Vinton Sent: Friday, July 31, 2009 10:54 AM To: Kyle Hall Cc: Koha list Subject: Re: [Koha] MARC record import
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
http://library.minlib.net/search/#
SirsiDynix catalogs also present options for displaying MARC records that could be copied. One example:
http://catalog.dalnet.lib.mi.us/ http://catalog.dalnet.lib.mi.us/ipac20/ipac.jsp?full=3100001~!431721~!1&fullmarc=true
But in this instance, some processing would be required as the tags & tag contents end up on separate lines.
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
On Fri, Jul 31, 2009 at 9:57 AM, Kyle Hall<kyle.m.hall@gmail.com> wrote:
Is that a MicroLIF format? I think I might have a script laying around that could help you.
Kyle
http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------------------------------------ This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no liability for any damage caused by any virus transmitted by this email. =================================
------------------------------
Message: 4 Date: Fri, 31 Jul 2009 11:05:03 -0400 From: Owen Leonard <oleonard@myacpl.org> Subject: Re: [Koha] MARC record import To: Cab Vinton <bibliwho@gmail.com> Cc: Koha list <koha@lists.katipo.co.nz> Message-ID: <c0aa2140907310805u70641879i1128bb2db6c25321@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Not exactly sure what format it's in -- I just copy & pasted into a text file from a record in the Minuteman Library Network in Mass:
Not really an answer to your question, but... Why not just search for the record using z39.50?
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org
------------------------------
Message: 5 Date: Fri, 31 Jul 2009 10:57:49 -0400 From: Mahalya_Havard@ssss.gouv.qc.ca Subject: [Koha] Mahalya Havard est absent(e). To: koha@lists.katipo.co.nz Message-ID: <OF6D9F8E3B.5EA15F07-ON85257604.005232BF-85257604.005232BF@ssss.gouv.qc.ca>
Content-Type: text/plain; charset="iso-8859-1"
Je serai absent(e) du Ven 31-07-2009 au Lun 03-08-2009.
Je r?pondrai ? votre message d?s mon retour, mardi, le 4 ao?t 2009. Merci.