[rt-users] error using Shredder

[Nathan, Ahalya]

But I am using a Oracle database so why should there be a installation
for DBD::mysql?

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District 
(402) 504-7180 phone
(402) 504-5180 fax



-----Original Message-----
From: Nathan, Ahalya 
Sent: Tuesday, October 25, 2005 12:59 PM
To: 'Nathan Oyler'; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] error using Shredder

It didn't ask me any information about database username and password 

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District 
(402) 504-7180 phone
(402) 504-5180 fax


-----Original Message-----
From: Nathan Oyler [mailto:noyler at khimetrics.com] 
Sent: Tuesday, October 25, 2005 12:54 PM
To: Nathan, Ahalya; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] error using Shredder

> I installed it and it gave me this error:
> root at web sbin]# ./rtx-shredder --object Users=17062 --sqldump
> /usr/local/rt_dev/testdelete
>
************************************************************************
> ***
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
> contains: /opt/rt3/local/lib /opt/rt3/lib
> /usr/local/lib/perl5/5.8.6/i686-linux /usr/local/lib/perl5/5.8.6
> /usr/local/lib/perl5/site_perl/5.8.6/i686-linux
> /usr/local/lib/perl5/site_perl/5.8.6 /usr/local/lib/perl5/site_perl .
> /opt/rt3/local/lib /opt/rt3/lib) at (eval 201) line 3.
> Perhaps the DBD::mysql perl module hasn't been fully installed,
> or perhaps the capitalisation of 'mysql' isn't right.
> Available drivers: DBM, ExampleP, File, Oracle, Proxy, SQLite, Sponge.
>  at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm
> line 108.
>
************************************************************************
> ****
> 
> When I tried installing DBD::mysql, it gave errors. Sample error
message
> towards the end is:
> 
>
************************************************************************
> ***
> not ok 1: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>         It looks as if your server is not up and running.
>         This test requires a running server.
>         Please make sure your server is running and retry.
> FAILED before any test output arrived
> t/mysql2.............Mysql connect('database=test;host=','',...)
failed:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2) at t/mysql2.t line 29
> Can't call method "getserverinfo" on an undefined value at t/mysql2.t
> line 30.
> t/mysql2.............dubious
>         Test returned status 255 (wstat 65280, 0xff00)
> Failed Test         Stat Wstat Total Fail  Failed  List of Failed
>
------------------------------------------------------------------------
> -------
> t/10dsnlist.t         10  2560     9   17 188.89%  1-9
> t/20createdrop.t      10  2560     5    9 180.00%  1-5
> t/30insertfetch.t     10  2560    11   21 190.91%  1-11
> t/35limit.t           10  2560   113  225 199.12%  1-113
> t/40bindparam.t       10  2560    27   53 196.30%  1-27
> t/40blobs.t           10  2560    11   21 190.91%  1-11
> t/40listfields.t      10  2560    18   35 194.44%  1-18
> t/40nulls.t           10  2560    11   21 190.91%  1-11
> t/40numrows.t         10  2560    25   49 196.00%  1-25
> t/41blobs_prepare.t   10  2560    24   47 195.83%  1-24
> t/50chopblanks.t      10  2560    35   69 197.14%  1-35
> t/50commit.t         255 65280    30   59 196.67%  1-30
> t/ak-dbd.t           255 65280    90  175 194.44%  1 4-90
> t/akmisc.t            10  2560   351  701 199.72%  1-351
> t/dbdadmin.t          10  2560    21   41 195.24%  1-21
> t/insertid.t         255 65280    12   24 200.00%  1-12
> t/mysql.t                         ??   ??       %  ??
> t/mysql2.t           255 65280    ??   ??       %  ??
> 1 test skipped.
> Failed 18/20 test scripts, 10.00% okay. 859/866 subtests failed, 0.81%
> okay.
> 
> I can't figure out what the problem is.
> 
> Thanks
> Ahalya


Don't you have to set some configurations when installing DBD::MySQL
like database name, username, and password for it's tests?

I'm new at this, but that seems to be what it is.