DBD Mysql Error problem solved on Debian Installation

2 Aug 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@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.

Sunita Barve

tags

participants (1)