[rt-users] error using Shredder

[Nathan Oyler]

/root/.cpan/build/DBD-mysql-3.0002/INSTALL.html

May help, or whatever suitable path for your system.

> -----Original Message-----
> From: Nathan, Ahalya [mailto:Ahalya_Nathan at mudnebr.com]
> Sent: Tuesday, October 25, 2005 10:59 AM
> 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.