Deleting ticket from the RT3 database

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello RT users,

i am using RT3 in the following environment:

OS: RedHat Enterprise Linux AS 3.0
kernel: 2.4.21-4.EL
RT: rt-3.0.10
MySQL: 4.0
Perl: 5.8.0

I would like to know whether it is possible to completely delete a ticket
from the RT3 database, and how to do that.

Much as i have googled, i have failed to find anything on this subject!

any help is greatly appreciated.

regards,

ernest.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVEwyaH3gYhvcd1eAQIrrwYAkDYxjyy3jtoVVPUxs6LWxyiU4ojBqSTg
etSNwNhITsHpOsox4W3FsS57ukEewewkvtwAp5+aWl//fNo9r2FIWZnwXsA5avVa
x07aQN+p9m+XR7v0nQXoRX5+1XjnmlB0K3qizQ64Vu5+OYM0FX3phaRFeyUXNWUA
Km/+slcZ7w/HCa4F/JDKBcQuH7XPXgIbx8/Zu10+gXNeobepMp1GJqj6yP4ePatE
xxtPJSJ03JcfLcRIgpBAl+O0YH1cB6fX
=1sI3
-----END PGP SIGNATURE-----

http://search.cpan.org/dist/RTx-Shredder

Ernest Byaruhanga wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello,

http://search.cpan.org/dist/RTx-Shredder

i’ve installed the module RTx::Shredder - but am wondering what next - how
do i use it for cleaning up rt db?

is there some documentation? (i havent found any).

thanks,

ernest.

Ernest Byaruhanga wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello RT users,

i am using RT3 in the following environment:

OS: RedHat Enterprise Linux AS 3.0
kernel: 2.4.21-4.EL
RT: rt-3.0.10
MySQL: 4.0
Perl:5.8.0

I would like to know whether it is possible to completely delete a ticket
from the RT3 database, and how to do that.

Much as i have googled, i have failed to find anything on this subject!

any help is greatly appreciated.

regards,

ernest.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVEwyaH3gYhvcd1eAQIrrwYAkDYxjyy3jtoVVPUxs6LWxyiU4ojBqSTg
etSNwNhITsHpOsox4W3FsS57ukEewewkvtwAp5+aWl//fNo9r2FIWZnwXsA5avVa
x07aQN+p9m+XR7v0nQXoRX5+1XjnmlB0K3qizQ64Vu5+OYM0FX3phaRFeyUXNWUA
Km/+slcZ7w/HCa4F/JDKBcQuH7XPXgIbx8/Zu10+gXNeobepMp1GJqj6yP4ePatE
xxtPJSJ03JcfLcRIgpBAl+O0YH1cB6fX
=1sI3
-----END PGP SIGNATURE-----


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVFvl6H3gYhvcd1eAQKlvwX+M4XLEXZ5kZprwOM9WQKl68xVQnujSHkh
rTvRisWXK0YEDNtwT2S/qqcJ6pzi22cYLWFwDM74WQLF56MLoa8h2sObh7Nm/o3o
8nlcy8H4tWYnhGKPDBNMYn0T0IyhrX37cnN/9cTBSdRrg4in3Q0gglTZGTAK+H6N
uyLTbg2lIPwZ/bFdgH4rz0RTNg/oaa2PvL8kT6l5YIFPkHFEMai1Lgg5kVmfMijh
Zl2flLlV2n/DnK7hOVxHB7lSybEJ7zo1
=bFJD
-----END PGP SIGNATURE-----

Ernest Byaruhanga wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello,

http://search.cpan.org/dist/RTx-Shredder

i’ve installed the module RTx::Shredder - but am wondering what next - how
do i use it for cleaning up rt db?

is there some documentation? (i havent found any).
Yeah. It’s a little bit crapy, yet.
I’ve updated it locally, but don’t release new version yet.
Use ‘/opt/rt3/local/sbin/rtx-shredder’ script.

perldoc /opt/rt3/local/sbin/rtx-shredder
perldoc /opt/rt3/local/lib/RTx/Shredder.pm

If functionality of rtx-shredder script is not enough report back I’ll
try to help you.

Also don’t forget about patch.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi Ruslan,

Ernest Byaruhanga wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

http://search.cpan.org/dist/RTx-Shredder

i’ve installed the module RTx::Shredder - but am wondering what next -
how do i use it for cleaning up rt db?

is there some documentation? (i havent found any).
Yeah. It’s a little bit crapy, yet.
I’ve updated it locally, but don’t release new version yet.
Use ‘/opt/rt3/local/sbin/rtx-shredder’ script.

when i use that script, below is the output i get:

[root@emu log]# /usr/local/rt3/local/sbin/rtx-shredder 2004-09-23
Tickets list is empty.
[root@emu log]#

when i log in back to RT and search for ticket numbers i deleted, i still
see the tickets (though marked as deleted of course). please advise what i
am missing - and thanks for the help so far!

Also don’t forget about patch.

please advise which patch this is… (I can see in the documentation about
a patch to enable RT to search for deleted tickets, but my RT can search
for deleted tickets).

regards,

ernest.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVGw2aH3gYhvcd1eAQLWjAX9FiK1nUbDNgqcLt0evoFmBNGNpWgFuMWX
cua7rpjcs0vbu51e//Pq4+WiGtGyFpN6xBiAUAZ+24kF/6NsxfN/m/b1bgauHLui
B31Y6MY7KKGTiRkfZaGTJLjmWxSXifaXPkBO855nFEFwu4ty0lR2fLl328au7gXV
CzkNArb21Uyj4N66koRaxIj0+H0/8gablRlRpIcwAqyqTtEJWawbczP1wHl2SNz3
0gFPJhl6IGnV044xgS2jhUzU6Jlj0Jga
=G+oz
-----END PGP SIGNATURE-----

Ernest Byaruhanga wrote:

http://search.cpan.org/dist/RTx-Shredder

i’ve installed the module RTx::Shredder - but am wondering what next -
how do i use it for cleaning up rt db?

is there some documentation? (i havent found any).

Yeah. It’s a little bit crapy, yet.
I’ve updated it locally, but don’t release new version yet.
Use ‘/opt/rt3/local/sbin/rtx-shredder’ script.

when i use that script, below is the output i get:

[root@emu log]# /usr/local/rt3/local/sbin/rtx-shredder 2004-09-23
Tickets list is empty.
[root@emu log]#

when i log in back to RT and search for ticket numbers i deleted, i still
see the tickets (though marked as deleted of course). please advise what i
am missing - and thanks for the help so far!
patch is in ‘patches’ dir.

Also don’t forget about patch.

please advise which patch this is… (I can see in the documentation about
a patch to enable RT to search for deleted tickets, but my RT can search
for deleted tickets).
No, it shouldn’t. API doesn’t allow to do it well because of this you
see ‘Tickets list is empty’ message.

Ernest Byaruhanga wrote:

patch is in ‘patches’ dir.

thanks, i am however getting a timeout error while trying to access:

http://search.cpan.org/src/RUZ/RTx-Shredder-0.01/patches/
Get tarball.
tar -xzvf RTx-Shredder-0.01.tar.gz
cd RTx-Shredder-0.01
ls patches

If you installed via CPAN shell then you have tarball allready in
~/.cpan/sources/authors/id/R/RU/RUZ/

I’ll release new version with updated docs today.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello Ruslan,

patch is in ‘patches’ dir.

thanks, i am however getting a timeout error while trying to access:

http://search.cpan.org/src/RUZ/RTx-Shredder-0.01/patches/

is there another site i can find this patch? i will keep trying though,
may be its temporary?

i have downloaded the patch now, but i am wondering how to apply it, as i
cant see any README about it. please advise me which file i should copy it
to, or how to apply this patch to my RT instance!

thanks,

ernest.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVKLyaH3gYhvcd1eAQJHqgYAs/aB1Ju+jjFn488l+GnbrVMdbwB9Yu6u
tORKmwueQTTYoLg5n4g79YRbxRTe6MPm3JAW9rVY9CbsuPVL0lby5JzZ/+xhWB8D
TSOI7wWX1hGwkZW3hkx8JBOAAY3QThwNeYcFaTAXkzOoRtCgzYxfL5MLNQnfZSnp
MFhwkYyCohlyfvmmjoMkJ7WwZWiujTrYITZuwSU23F1L/Xp5mVNtexdF4JgVxP/D
0JW5egJOMvxQhPgvqZC9/m6nH8hoTsrw
=rAZg
-----END PGP SIGNATURE-----

Ernest Byaruhanga wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello Ruslan,

patch is in ‘patches’ dir.

thanks, i am however getting a timeout error while trying to access:

http://search.cpan.org/src/RUZ/RTx-Shredder-0.01/patches/

is there another site i can find this patch? i will keep trying though,
may be its temporary?

i have downloaded the patch now, but i am wondering how to apply it, as i
cant see any README about it. please advise me which file i should copy it
to, or how to apply this patch to my RT instance!
cd /opt/rt3/

or dir where your RT lib dir is located

cat /path/to/patch | patch -p0

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

http://search.cpan.org/dist/RTx-Shredder

i’ve installed the module RTx::Shredder - but am wondering what
next - how do i use it for cleaning up rt db?

is there some documentation? (i havent found any).

Yeah. It’s a little bit crapy, yet.
I’ve updated it locally, but don’t release new version yet.
Use ‘/opt/rt3/local/sbin/rtx-shredder’ script.

when i use that script, below is the output i get:

[root@emu log]# /usr/local/rt3/local/sbin/rtx-shredder 2004-09-23
Tickets list is empty.
[root@emu log]#

when i log in back to RT and search for ticket numbers i deleted, i
still see the tickets (though marked as deleted of course). please
advise what i am missing - and thanks for the help so far!

patch is in ‘patches’ dir.

thanks, i am however getting a timeout error while trying to access:

http://search.cpan.org/src/RUZ/RTx-Shredder-0.01/patches/

is there another site i can find this patch? i will keep trying though,
may be its temporary?

thanks,

ernest.

Also don’t forget about patch.

please advise which patch this is… (I can see in the documentation
about a patch to enable RT to search for deleted tickets, but my RT
can search for deleted tickets).

No, it shouldn’t. API doesn’t allow to do it well because of this you
see ‘Tickets list is empty’ message.

regards,

ernest.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVKHbKH3gYhvcd1eAQJpuAX/abID3zx6YRmbmlfQKNZOojKlXzsbVhDr
ZyPxGk9jVSgSYNn/TnLlOcp/GvftJFgRDKdZm8z/udXDIoq8iY1qjX5PAJxDYzLc
zalya0jzoLeKetejBkoZsfnb7ls8F9bwgVlm27qT0vh7nicTNQzQgZzQXc+dgzOJ
yF5c1f+uHZu0KcpqxShr8NIz59o7NnSXubOET2D6+xJmffSpEv/GxDzgU//7iHeq
HFDKnES+fstb0qaqedKIk1QgdG3BFJ1P
=we7F
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi Ruslan,On Thu, 23 Sep 2004, Ruslan U. Zakirov wrote:

i have downloaded the patch now, but i am wondering how to apply it,
as i cant see any README about it. please advise me which file i
should copy it to, or how to apply this patch to my RT instance!

cd /opt/rt3/

or dir where your RT lib dir is located

cat /path/to/patch | patch -p0

thanks a lot - it worked like a charm :-))

ernest.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQDVAwUBQVKZHaH3gYhvcd1eAQJpmgYAg/AxUAw2j62aGGo/pSgogq/Fi+Lp8r3x
2xa/Amb+TzDIe0ItI6K/XtPxelHMzE75B7u4IqVL06ozN0/GXt99jTHfRxAlhE1/
vbai0P8Hsf1NJC8LLcbdRSk1OrxIFeuJ+ClCqjh5S3TYZusLA/QnH/PxVy3ebLbm
ofE4912MvJ8uJ2ljhcvExKryKcK0HjDrxAFR3CSLYoY8oKK+gle5U/KwNv62Q2I9
0HhLubsn6H709JAeWnLvaY+mcyH/8VXh
=o8Wy
-----END PGP SIGNATURE-----