[rt-users] Upgrade RT and migrate to postgresql

2014-08-04 Thread Sternberger, Sven
Hi! we want to upgrade our RT from 3.8.7 to 4.2.6 and we want to migrate from mysql to postgresql. Is it possible to combine these 2 steps, or is it better to first upgrade the RT and in a second step migrate to postgresql? best regards! Sven -- RT Training - Boston, September 9-10 http://best

[rt-users] Howto overwrite user preferences

2014-12-03 Thread Sternberger, Sven
Hello! we will upgrade soon our RT from 3.8.7 to 4.2.9, and I would like to initially set the preference for Theme on System default (in our case now rudder) I found that the Preferences are stored in the DB in the table Attributes with the Name Pref-RT::System-1, but is there a way to override

[rt-users] rt-validator questions!

2014-12-04 Thread Sternberger, Sven
hello! I'm in the process to migrate from 3.8.7. to 4.2.9 and I change the Server at the same time. Till now the tests worked like a charm Now I want to test if we could clean up the data in this procedure. We want to use - shrink_cgm_table.pl - shrink_transactions_table.pl - rt-validator My f

Re: [rt-users] rt-validator questions!

2014-12-05 Thread Sternberger, Sven
Hi! I've continued testing - Ursprüngliche Mail - > My second question I started on my RT4.2.9 test instance (filled with > my 30GB production db) the rt-validator and first It proceed quickly > but now it slows down (in progress, runtime now 20h) .. > - Could I speedup the process (make

Re: [rt-users] Howto overwrite user preferences

2014-12-12 Thread Sternberger, Sven
t-attributes-editor.html > > Am 12.12.2014 um 13:10 schrieb Alex Peters: > > The sbin/rt-preferences-viewer script will at least let you view > > non-default user preferences, but not let you change them. I personally > > don't know of any way to pr

Re: [rt-users] Memory issue

2014-12-18 Thread Sternberger, Sven
Hello! first look at http://www.linuxatemyram.com/ then look at the configuration of your DB Server, the webserver don't need so much memory. For mysql the parameter is innodb_buffer_pool_size And size equal speed and 1GB is is not a lot of memory today regards! Sven - Urspr

[rt-users] RT filter for outgoing mail

2015-01-22 Thread Sternberger, Sven
Hello! we migrated from 3.8.7 to 4.2.9 and see that the way RT handles email adresses from queues changed. In 3.8.7 a a mail address was removed when there was match with the RTAddressRegexp or the the address was configured in the queue. This still happen in 4.2.9 but now the outgoing mail is

[rt-users] RT customize SendEmail.pm

2015-01-28 Thread Sternberger, Sven
Hello! I want to modify the SendEmail.pm module, to disable the check for RTAdresses, so we want to send emails even if RT thinks they are RT email adresses. I would copy the file SendEmail.pm to "SendEmail_Local.pm" and remove these lines $self->RecipientFilter( Callback => sub {

Re: [rt-users] RT customize SendEmail.pm

2015-01-30 Thread Sternberger, Sven
Hello! - Ursprüngliche Mail - > Von: k...@rice.edu > That sounds like a really, really bad idea. This is a great way to start > a mail loop, having a program Email itself. Why are you trying to do this? all emails to RT will be filtered with procmail, if the mail is originated by the RT,

Re: [rt-users] Retrieving information from RT-database

2015-01-30 Thread Sternberger, Sven
Hi! a simple way is to use the commandline interface /opt/rt4/bin/rt ls -t user - gives you a list of all user /opt/rt4/bin/rt show user/123456 - gives you all information about user with the id 123456 the interface utilize the rest interface, which is much easier to use than the perl api (IMHO

Re: [rt-users] RT customize SendEmail.pm

2015-01-30 Thread Sternberger, Sven
Hi! - Ursprüngliche Mail - > Von: k...@rice.edu > on message details. I do not understand what you mean by: > >> if the mail is originated >> by the RT, we will reroute the mail to the mailadresses of the queue members. >> This gives you simple way to send mail from queue_a to all members

[rt-users] rt-shredder problems

2015-02-09 Thread Sternberger, Sven
Hello! i have a cron job which purges deleted tickets if they are older than 6 month. this worked for quite a long time but for a week I get an error message Tickets will be deleted nevertheless. I also ran rt-validator. Message: Couldn't wipeout object: Can't call method "IsLocal" on an undefine

[rt-users] [Solved] rt-shredder problems

2015-02-16 Thread Sternberger, Sven
The problem is a entry in "Links" with the "Target" NULL so "delete from Links where Target is NULL;" helped - Ursprüngliche Mail - > Von: "Sternberger, Sven" > An: "rt-users" > Gesendet: Montag, 9. Februar 2015 15:16:46 >

Re: [rt-users] RT customize SendEmail.pm

2015-02-20 Thread Sternberger, Sven
: * In incomming emails, the queue email adress is removed. * I can create a ticket in the WebUI set the requestor/cc/admincc to a "RT" mail address. * My procmail recipes prevents RT loops but send the mail to the queue staff regards! Sven - Ursprüngliche Mail - > Von: "

Re: [rt-users] RT customize SendEmail.pm

2015-03-02 Thread Sternberger, Sven
Hi! this sounds good but I can't find it in the UI. Your are probably not referring the "rt-email-group-admin" command and a static configuration. regards! Sven > Von: "Alex Peters" > For posterity, RT v4.2.10 introduces the ability to add groups as requestors. > If > I understand this

Re: [rt-users] RT customize SendEmail.pm

2015-03-02 Thread Sternberger, Sven
create page? regards! Sven > Von: "Sternberger, Sven" > An: rt-users@lists.bestpractical.com > CC: "Alex Peters" > Gesendet: Montag, 2. März 2015 10:37:59 > Betreff: Re: [rt-users] RT customize SendEmail.pm > Hi! > this sounds good but I can&#

[rt-users] RT stops occasionally sending mail

2015-09-29 Thread Sternberger, Sven
Hello! I use RT4.2.11 on Ubuntu14.04 since a week I notice that mail occasionally is not sended by notify scrips. They are also not in the history and in the log I see Sep 28 13:40:40 rthost RT: [16910] Scrip Prepare 483 died. - Can't locate object method "" via package "RT::Action::Notify" a

[rt-users] Mails not sended

2015-11-11 Thread Sternberger, Sven
Hello! I have again the problem that RT from time to time has problems to send mails. But in the logs I have a new error message Scrip Prepare 158 died. - panic: attempt to copy freed scalar 7f89fe68dc08 to 7f8a641ca550 at /usr/local/share/perl/5.18.2/Devel/StackTrace.pm line 59 any ideas? ME

[rt-users] Bizarre errors with shredder

2016-04-12 Thread Sternberger, Sven
Hello! >From time to time I purge unused accounts in the RT database with shredder. Suddenly it starts to throw "bizarre" exceptions. Now I can't purge any accounts. root@rt:~# /opt/rt4/sbin/rt-shredder --force --plugin "Users=no_tickets,1;status,any;replace_relations,Nobody;limit,3;member_of,u

[rt-users] Scrips dying now and then when sending email

2016-05-31 Thread Sternberger, Sven
Hello! I have an really ugly bug and I can't find the reason. The bug is: From time to time (once a week). For 5-15sec RT dont send mails created by scrips. This could strike one but also several emails. I see in the logs lines like: RT: [14868] Use of uninitialized value in method with known

[rt-users] Lost emails!

2016-11-21 Thread Sternberger, Sven
Hello! I wrote now several time to the list but it seems that our problem ist to "special" So sometimes RT don't send emails. If I look in the logs I see lines like: Nov 17 16:20:48 myrtsys RT: [9992] Scrip Prepare 88 died. - Can't locate object method "" via package "MIME::Head" at /opt/rt4/s

Re: [rt-users] Lost emails!

2016-11-22 Thread Sternberger, Sven
rds! Sven - Ursprüngliche Mail - > Von: "Shawn M Moore" > An: "Sternberger, Sven" > CC: "rt-users" > Gesendet: Montag, 21. November 2016 17:10:01 > Betreff: Re: [rt-users] Lost emails! >> On Nov 21, 2016, at 06:12, Sternberger, S

Re: [rt-users] Lost emails!

2016-12-01 Thread Sternberger, Sven
Hello! I now changed some things. I switched to perl 5.24 (perlbrew) and I updated to 4.2.13 but the problem is still the same Dec 1 12:27:40 rt- RT: [5776] Ticket 699881 created in queue 'it-' by it-x...@desy.de Dec 1 12:27:40 rt- RT: [5776] Redundant argument in sprintf at /opt

Re: [rt-users] Lost emails!

2016-12-05 Thread Sternberger, Sven
t;RT::Base->_ImportOverlays();" which is maybe not a good idea to have it in SendEmail_Local.pm file? Now I have only the header and the method I've changed in SendEmail_Local.pm. best regards! Sven - Ursprüngliche Mail ----- > Von: "Sternberger, Sven" > An: "rt-user

Re: [rt-users] Lost emails!

2016-12-05 Thread Sternberger, Sven
forgot the attachment - Ursprüngliche Mail - > Von: "Sternberger, Sven" > An: "rt-users" > Gesendet: Montag, 5. Dezember 2016 09:40:25 > Betreff: Re: [rt-users] Lost emails! > Hello! > > it would be very helpful if somebody could look at

Re: [rt-users] Lost emails!

2016-12-20 Thread Sternberger, Sven
Just for the records, the problem was that I copied SendEmail.pm to SendEmail_Local.pm. In the "Local" copy I made my customization. This is not a good idea because at the end of SendEmail.pm you find "RT::Base->_ImportOverlays();" so I gues this triggered an endless loop which most of the time