[Koha] DBD Mysql Error problem solved on Debian Installation

Sunita Barve sunitabarve at gmail.com
Sun Aug 2 21:22:06 NZST 2009


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 at lists.katipo.co.nz> wrote:
> Send Koha mailing list submissions to
>        koha at 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 at lists.katipo.co.nz
>
> You can reach the person managing the list at
>        koha-owner at 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 at 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 at gmx.de>
> Subject: Re: [Koha] DBD driver has not implemented the AutoCommit
>        attribute
> To: Joe Atzberger <ohiocore at gmail.com>
> Cc: Koha List <koha at lists.katipo.co.nz>
> Message-ID: <4A7301DE.4050302 at 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 at gmx.de
>> <mailto:marc.nuernberger at 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 at gmail.com>
> Subject: Re: [Koha] MARC record import
> To: Kyle Hall <kyle.m.hall at gmail.com>
> Cc: Koha list <koha at lists.katipo.co.nz>
> Message-ID:
>        <835777770907310754w261f9c62jfda5814d46010389 at 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 at 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 at med.nyu.edu>
> Subject: Re: [Koha] MARC record import
> To: Koha list <koha at lists.katipo.co.nz>
> Message-ID:
>        <543F9234BDD8434A8D45C3D6337B7C8E1956EBDF at 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 at lists.katipo.co.nz [mailto:koha-bounces at 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 at 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 at 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 at myacpl.org>
> Subject: Re: [Koha] MARC record import
> To: Cab Vinton <bibliwho at gmail.com>
> Cc: Koha list <koha at lists.katipo.co.nz>
> Message-ID:
>        <c0aa2140907310805u70641879i1128bb2db6c25321 at 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 at ssss.gouv.qc.ca
> Subject: [Koha] Mahalya Havard est absent(e).
> To: koha at lists.katipo.co.nz
> Message-ID:
>        <OF6D9F8E3B.5EA15F07-ON85257604.005232BF-85257604.005232BF at 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.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090731/371dcbfc/attachment-0001.htm
>
> ------------------------------
>
> Message: 6
> Date: Fri, 31 Jul 2009 11:28:08 -0400
> From: Cab Vinton <bibliwho at gmail.com>
> Subject: Re: [Koha] MARC record import
> To: Owen Leonard <oleonard at myacpl.org>
> Cc: Koha list <koha at lists.katipo.co.nz>
> Message-ID:
>        <835777770907310828o43613e1fpe437e323aaee15fb at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
>> Not really an answer to your question, but... Why not just search for
>> the record using z39.50?
>
> This is for those occasions when z39.50 comes up empty.
>
> Our connection to FirstSearch/ OCLC wasn't working recently & it took
> a while to diagnose. Meanwhile, our backlog of cataloging keeps
> building up ...
>
> My attempts to create additional search points were a bust. I tried
> using the directory at http://irspy.indexdata.com/, but MELVYL,
> AMICUS, & few others didn't work. It would be great if there were a
> central repository of targets + Koha settings that work. Our
> connections to the New York libraries (NYU, NYPL) have never worked.
>
> Cab Vinton, Director
> Sanbornton Public Library
> Sanbornton, NH
>
>
> ------------------------------
>
> Message: 7
> Date: Fri, 31 Jul 2009 09:31:57 -0600
> From: Scott <tacogrande55 at hotmail.com>
> Subject: [Koha] marc record matching rules, not working
> To: koha at lists.katipo.co.nz
> Message-ID: <h4v2pe$857$1 at ger.gmane.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi,
> I am trying to import 1 marc only record, and then import a list of
> items for that marc record. I have the default matching rules that come
> with koha and so I am trying to match the isbn 020a tag.
>
> here is a the marc record only.
> =LDR  00000nam  2200000Ia 45e0
> =008  090731s9999\\\\xx\\\\\\\\\\\\000\0\und\d
> =020  \\$a9780439533263
> =100  1\$a"Blevins, Wiley"
> =245  04$aA Hat
> =650  0\$aGeneral
> =952  \\$oA$p80006$yL
>
> and here is the sample of one of the item records.
> =LDR  00000nam  2200000Ia 45e0
> =008  090731s9999\\\\xx\\\\\\\\\\\\000\0\und\d
> =020  \\$a9780439533263
> =100  1\$a"Blevins, Wiley"
> =245  04$aA Hat
> =952  \\$oA$p80006$yL$v5
>
> there probably shouldnt be a barcode in the record only, since i see
> that now that im writing this, but how i do this is I first stage the
> marc record and just have it replace any matching and to not add any
> items. I then import it, and rebuild_zebra just to be sure its in there
> correctly.
>
> I then stage the item record and tell it to ignore adding records but
> add all items. I then upload it and it ignores all the items. Even
> though the 020$a is the same as the marc record. Shouldnt the items be
> adding to the record?
>
> Is what I am doing even possible? I basically just want to add a marc
> record, then add a bunch of items to it. Instead of having a bunch of
> the same items with different records.
>
> Thanks for all the help.
> -Scott
>
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 31 Jul 2009 09:32:58 -0600
> From: "Harris, Gary, DCA" <Gary.Harris at state.nm.us>
> Subject: Re: [Koha] MARC record import
> To: "Cab Vinton" <bibliwho at gmail.com>
> Cc: Koha list <koha at lists.katipo.co.nz>
> Message-ID: <C16638FFEEC03641A2389ED740D4D3D2036C446A at CEXMB5.nmes.lcl>
> Content-Type: text/plain;       charset="us-ascii"
>
> First, download MarcEdit. Once it is installed:
>
> Take the output from Minuteman, changing whatever filename extension is
> present, if any, to (.mrc). This extension will be recognized by
> MarcEdit. Double-click the on the file and follow the instructions. I
> suspect the file is MARC, and if it is, MarcEdit will convert to
> human-readable text with a new extension (.mrk). Load the .mrc file to
> Koha if all of the above is true. This procedure is for MarcEdit running
> under Windows XP.
>
> Gary
>
>
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Owen Leonard
> Sent: Friday, July 31, 2009 9:05 AM
> To: Cab Vinton
> 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:
>
> 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
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
> ______________________________________________________________________
> This inbound email has been scanned by the MessageLabs Email Security
> System.
> ______________________________________________________________________
>
>
> 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.
>
>
>
>
> 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 MessageLabs Email Security System.
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 46, Issue 2
> ***********************************
>



-- 
Sunita Barve, Ph. D.
SIRC-In-Charge
National Centre for Radio Astrophysics
Post Bag No. 3, Pune Univ. Campus
Pune 411 007, INDIA
Phone : Office : 91-20-25719211
            Residence : 91-020- 24470022
            Mobile: 9922753827
Email : sunitab at ncra.tifr.res.in ; sunitabarve at gmail.com


More information about the Koha mailing list