Theology question

RT Users
1

I’m setting up RT, and feeling like there’s a slight blurring (which works to the advantage of the administrator, so I’m not complaining!) between queues. What I notice is that if I have two queues, “apple” and “banana”, it appears that I can send a comment back to an existing ticket in “banana” but send it via the “apple” email address.

Where this works to my advantage is that, in this early stage of deployment, I have a single email address - rt@xxx.com – which is being processed via fetchmail.

So a new ticket gets created by sending mail to that address. It goes into the default queue, which I’ve renamed from General to Incoming.

Once a ticket gets picked up, it gets moved to the appropriate queue. But comments sent back to rt@xxx.com, with the appropriate magic string in the Subject: line, get appended correctly.

Like I said, this isn’t upsetting me – it’s making my life easier! – but I wanted to be sure I was understanding it.

This leads to a closely related theology question: Do I really need separate email addresses for each queue? Clearly if the load is great enough, or separate groups are handling them, or there’s a queue that triggers a pager event, this would be A Good Thing. But are there other reasons?

Currently I’m planning on using the single address; if load/other events suggest more than one, I’ll use apple-issues@xxx.com, banana-issues@xxx.com, etc., and kill rt@xxx.com (that’s one way to retrain the users, eh?).

Any wisdom the group can impart on this would be appreciated!

…phsiii

2

Separate email addresses would be needed if you wanted users to direct
"apple" questions to the “apple” queue (etc). But if your users
wouldn’t know the difference between an apple or banana then one email
address would be best so you can sort the apples from the bananas and
respond from the proper queue – with the user blissfully unaware of
this complexity.

Joby Walker
ITI SSG, University of Washington

Phil Smith III wrote:

3

This leads to a closely related theology question: Do I really
need separate email addresses for each queue?

If you need the initial message to be directed to a specific
queue, you need separate aliases for them. Once in RT, it
is normal and expected that messages may be moved among
queues and it is likely that when a reply to an existing
ticket returns, the ticket itself will be in a different
queue than when the last email was sent. Thus the ticket
number is always used to match up with the corresponding
ticket number regardless of it’s current queue assignment.

Les Mikesell
les@futuresource.com

4

For values of “success” that may or may not be entirely local to my
organization, I think I’ve finally cracked it:

http://blank.org/memory/output/rt-ad-sso.html

Comments, corrections and hints gladly appreciated.

One small note: in my personal instance, I was not able to get the
Web_Local.pm overlay to work (see my last message to rt-users), and
ended up setting “$user_info{‘Privileged’} = 0;” in Web.pm directly.

-n

------------------------------------------------------------memory@blank.org
“When JFK was killed, America lost its innocence. Now, several Kennedy deaths
later, we’ve all learned to just laugh at it. Pretty soon we’ll be killing
them for fun.” (–The Onion)
http://blank.org/memory/----------------------------------------------------

5

This thread reminds me that I have a similar question. I’d like to set
up two incoming email addresses with both feeding to the same queue.
Mails to lowprio@xxx should create tickets with initial priority = X
whereas mails to highprio@xxx should create tickets with initial
priority = Y. How would I go about doing this?

Thanks

6

This thread reminds me that I have a similar question. I’d like to set
up two incoming email addresses with both feeding to the same queue.
Mails to lowprio@xxx should create tickets with initial priority = X
whereas mails to highprio@xxx should create tickets with initial
priority = Y. How would I go about doing this?

I would create an OnCreate scrip that checks the headers to see
which e-mail address the ticket was sent to and modify the priority
based on that. I looked at passing it as an option to rt-mailgate
but the method wasn’t immediately obvious.

-Todd

7

At the risk of following up to myself…

Because creating and maintaining a local/html/autohandler file was too
ugly a hack to tolerate, I broke down and wrote the necessary
Web_Local.pm glue to autofill Name, RealName and EmailAddress from the
LDAP directory.

Updated instructions and the Web_Local.pm file itself are at:

http://blank.org/memory/output/rt-ad-sso.html

-n

----------------------------------------------------------memory@blank.org
And when love is gone, there’s always justice. And when justice is gone
there’s always force. And when force is gone, threre’s always mom. Hi mom!
(–Laurie Anderson)
http://blank.org/memory/--------------------------------------------------

8

With thanks to a couple of helpful souls and my own
obsessive-compulsive leanings:

http://blank.org/memory/output/rt-ad-sso.html

SSO for real this time. SSO as in “single” as in “type your password
once to log on to windows, and that by god is IT.”

Extra points and my eternal adoration to anyone who can figure out how
to do this with modauthkerb instead of mod_ntlm, but it’ll do for now.

-n

------------------------------------------------------------memory@blank.org
“Big summer movies are to political cartoonists what big-haired women are to
Bill Clinton.” (–Tom Tomorrow)
http://blank.org/memory/----------------------------------------------------

9

Trying to blow away a bunch of users created by a spam run, Shredder
kicks back the following error:

error: couldn’t find resolver for dependency ‘RT::User-16346
(depends on,resolvable dependency) RT::Attachment-36478’ at
/usr/local/rt34/local/lib/RTx/Shredder/Dependency.pm line 87.

context: …
83: TargetClass => $self->TargetClass,
84: );
85:
86: unless( $resolver ) {
87: die “couldn’t find resolver for dependency '”. $self->AsString .“'”;
88: }
89: unless( UNIVERSAL::isa( $resolver => ‘CODE’ ) ) {
90: die “resolver is not code reference: ‘$resolver’”;
91: }
…

code stack:
/usr/local/rt34/local/lib/RTx/Shredder/Dependency.pm:87
/usr/local/rt34/local/lib/RTx/Shredder/Record.pm:211
/usr/local/rt34/local/lib/RTx/Shredder/Record.pm:197
/usr/local/rt34/local/lib/RTx/Shredder.pm:348
/usr/local/rt34/share/html/Admin/Tools/Shredder/index.html:73
/usr/local/rt34/share/html/Admin/Tools/Shredder/autohandler:12
/usr/local/rt34/share/html/Admin/autohandler:47
/usr/local/rt34/share/html/autohandler:215

------------------------------------------------------------memory@blank.org
My motorcycle/
stands forlorn on Hurlbut Street.
The fucker won’t start. (–me)
http://blank.org/memory/----------------------------------------------------

10

How did you install RTx::Shredder?

Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District
(402) 504-7180 phone
(402) 504-5180 fax-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Nathan J.
Mehl
Sent: Tuesday, October 25, 2005 11:03 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] error using Shredder

Trying to blow away a bunch of users created by a spam run, Shredder
kicks back the following error:

error: couldn’t find resolver for dependency ‘RT::User-16346
(depends on,resolvable dependency) RT::Attachment-36478’ at
/usr/local/rt34/local/lib/RTx/Shredder/Dependency.pm line 87.

context: …
83: TargetClass => $self->TargetClass,
84: );
85:
86: unless( $resolver ) {
87: die “couldn’t find resolver for dependency '”. $self->AsString
.“'”;
88: }
89: unless( UNIVERSAL::isa( $resolver => ‘CODE’ ) ) {
90: die “resolver is not code reference: ‘$resolver’”;
91: }
…

code stack:
/usr/local/rt34/local/lib/RTx/Shredder/Dependency.pm:87
/usr/local/rt34/local/lib/RTx/Shredder/Record.pm:211
/usr/local/rt34/local/lib/RTx/Shredder/Record.pm:197
/usr/local/rt34/local/lib/RTx/Shredder.pm:348
/usr/local/rt34/share/html/Admin/Tools/Shredder/index.html:73
/usr/local/rt34/share/html/Admin/Tools/Shredder/autohandler:12
/usr/local/rt34/share/html/Admin/autohandler:47
/usr/local/rt34/share/html/autohandler:215

------------------------------------------------------------<memory@blan
k.org>
My motorcycle/
stands forlorn on Hurlbut Street.
The fucker won’t start.
(–me)
http://blank.org/memory/----------------------------------------------
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

11

In the immortal words of Nathan, Ahalya (Ahalya_Nathan@mudnebr.com):

How did you install RTx::Shredder?

    cd RTx-Shredder-0.02_02
    perl Makefile.PL
    make
    make install

    mkdir /opt/rt3/var/data/RTx-Shredder/
    chown apache /opt/rt3/var/data/RTx-Shredder/

-n

------------------------------------------------------------memory@blank.org
“There are only 412 people in the world. And Nathan Mehl is 17 of them.”
(–Pete Ehlke)
http://blank.org/memory/----------------------------------------------------

12

I installed it and it gave me this error:
root@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
AhalyaFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Nathan J.
Mehl
Sent: Tuesday, October 25, 2005 11:48 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error using Shredder

In the immortal words of Nathan, Ahalya (Ahalya_Nathan@mudnebr.com):

How did you install RTx::Shredder?

    cd RTx-Shredder-0.02_02
    perl Makefile.PL
    make
    make install

    mkdir /opt/rt3/var/data/RTx-Shredder/
    chown apache /opt/rt3/var/data/RTx-Shredder/

-n

------------------------------------------------------------<memory@blan
k.org>
“There are only 412 people in the world. And Nathan Mehl is 17 of them.”
(–Pete
Ehlke)
http://blank.org/memory/----------------------------------------------
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

13

I installed it and it gave me this error:
root@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.

14

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 faxFrom: Nathan Oyler [mailto:noyler@khimetrics.com]
Sent: Tuesday, October 25, 2005 12:54 PM
To: Nathan, Ahalya; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] error using Shredder

I installed it and it gave me this error:
root@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.

15

/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@mudnebr.com]
Sent: Tuesday, October 25, 2005 10:59 AM
To: Nathan Oyler; rt-users@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@khimetrics.com]
Sent: Tuesday, October 25, 2005 12:54 PM
To: Nathan, Ahalya; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] error using Shredder

I installed it and it gave me this error:
root@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%

16

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 faxFrom: Nathan, Ahalya
Sent: Tuesday, October 25, 2005 12:59 PM
To: ‘Nathan Oyler’; rt-users@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

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

I installed it and it gave me this error:
root@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.

17

You don’t need DBD::mysql if you use Oracle as RT DB.
If you grep through shredder source you wouldn’t find mysql word.On 10/25/05, Nathan, Ahalya Ahalya_Nathan@mudnebr.com wrote:

I installed it and it gave me this error:
root@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

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Nathan J.
Mehl
Sent: Tuesday, October 25, 2005 11:48 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error using Shredder

In the immortal words of Nathan, Ahalya (Ahalya_Nathan@mudnebr.com):

How did you install RTx::Shredder?

    cd RTx-Shredder-0.02_02
    perl Makefile.PL
    make
    make install

    mkdir /opt/rt3/var/data/RTx-Shredder/
    chown apache /opt/rt3/var/data/RTx-Shredder/

-n

------------------------------------------------------------<memory@blan
k.org>
“There are only 412 people in the world. And Nathan Mehl is 17 of them.”
(–Pete
Ehlke)
http://blank.org/memory/----------------------------------------------

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

18

Trying to blow away a bunch of users created by a spam run, Shredder
kicks back the following error:

error: couldn’t find resolver for dependency ‘RT::User-16346
(depends on,resolvable dependency) RT::Attachment-36478’ at
/usr/local/rt34/local/lib/RTx/Shredder/Dependency.pm line 87.
use --replace_relations option of the users plugin

context: …
83: TargetClass => $self->TargetClass,
84: );
85:
86: unless( $resolver ) {
87: die “couldn’t find resolver for dependency '”. $self->AsString .“'”;
88: }
89: unless( UNIVERSAL::isa( $resolver => ‘CODE’ ) ) {
90: die “resolver is not code reference: ‘$resolver’”;
91: }
…

code stack:
/usr/local/rt34/local/lib/RTx/Shredder/Dependency.pm:87
/usr/local/rt34/local/lib/RTx/Shredder/Record.pm:211
/usr/local/rt34/local/lib/RTx/Shredder/Record.pm:197
/usr/local/rt34/local/lib/RTx/Shredder.pm:348
/usr/local/rt34/share/html/Admin/Tools/Shredder/index.html:73
/usr/local/rt34/share/html/Admin/Tools/Shredder/autohandler:12
/usr/local/rt34/share/html/Admin/autohandler:47
/usr/local/rt34/share/html/autohandler:215

------------------------------------------------------------memory@blank.org
My motorcycle/
stands forlorn on Hurlbut Street.
The fucker won’t start. (–me)
http://blank.org/memory/----------------------------------------------------

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

19

<<<
9. Edit /opt/rt3/lib/RT/User_Local.pm to fix a small logic error in
UIO’s code. At line 374, change the != comparison to a ne comparison,
so that the line reads:

if (defined($RT::LdapUser) && $RT::LdapUser ne ‘’) {

Equive perl code for this is:
if ( $RT::LdapUser ) {
…
}On 10/25/05, Nathan J. Mehl rtusers@memory.blank.org wrote:

At the risk of following up to myself…

Because creating and maintaining a local/html/autohandler file was too
ugly a hack to tolerate, I broke down and wrote the necessary
Web_Local.pm glue to autofill Name, RealName and EmailAddress from the
LDAP directory.

Updated instructions and the Web_Local.pm file itself are at:

    http://blank.org/memory/output/rt-ad-sso.html

-n

----------------------------------------------------------memory@blank.org
And when love is gone, there’s always justice. And when justice is gone
there’s always force. And when force is gone, threre’s always mom. Hi mom!
(–Laurie Anderson)
http://blank.org/memory/--------------------------------------------------

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

20

<<<
If you are not starting from scratch, but are trying to integrate a
pre-existing RT instance with an Active Directory server, you are
going to have to decide what to do about the pre-existing
auto-created-by-email accounts on the RT side (if any). If you do
nothing, you won’t break anything, but you’ll lose some historical
continuity because post-unification RT will create new accounts for
each user as they log in. If that’s an issue, you’ll need to go
through the existing set of auto-created accounts and change their
usernames from “user@domain” to just “user”.

I think this note about internal users only, who are in the AD. AFAIK
RT wouldn’t allow to create new user(even with different Name) with
the same EmailAddress, so you have to do this step if at least one
user from the AD is in RT allready.On 10/25/05, Nathan J. Mehl rtusers@memory.blank.org wrote:

At the risk of following up to myself…

Because creating and maintaining a local/html/autohandler file was too
ugly a hack to tolerate, I broke down and wrote the necessary
Web_Local.pm glue to autofill Name, RealName and EmailAddress from the
LDAP directory.

Updated instructions and the Web_Local.pm file itself are at:

    http://blank.org/memory/output/rt-ad-sso.html

-n

Best regards, Ruslan.