Re: [rt-users] Default password

2007-08-01 Thread Ruslan Zakirov
On 8/1/07, John Oliver <[EMAIL PROTECTED]> wrote: > On Wed, Aug 01, 2007 at 06:09:42PM +0100, Roy El-Hames wrote: > > Have you any users in your Users table, if not then I would recommend > > re-installing RT, cause you need more than just the root user like the > > user Nobody and RT_System. > > R

Re: [rt-users] Default password

2007-08-01 Thread Raed El-Hames
Yes all you need is ~]# /usr/sbin/rt-setup-database and all mysql related stuff as per the read me .. have a look at the wiki installation document it explains how to deal with your error. Roy - Original Message - From: "John Oliver" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 01, 200

RE: [rt-users] Attachments table of RT's Mysql database

2007-08-01 Thread Justin Brodley
We actually had to disable the attachment feature as we were having our customers attach enormous files and killed our DB processing. Ultimately we are looking into rewriting the attachment feature to store the attachments on the web server to alleviate this overhead from the DB. I understand th

[rt-users] Attachments table of RT's Mysql database

2007-08-01 Thread Gregory Harper
Hello everybody. We've been using RT for more than three months as part of our customer concern processes. Overall, things have been going well. The configuration includes Mysql, Apache2 and Postfix running on Ubuntu 6.06. I've made no modifications to the databases. The primary concern at

Re: [rt-users] Default password

2007-08-01 Thread John Oliver
On Wed, Aug 01, 2007 at 06:09:42PM +0100, Roy El-Hames wrote: > Have you any users in your Users table, if not then I would recommend > re-installing RT, cause you need more than just the root user like the > user Nobody and RT_System. Reinstall??? Wouldn't dropping the database and re-running

[rt-users] Ticket import problem

2007-08-01 Thread Petr Grolmus
Hi I'm trying to migrate tickets from RT2 to RT3 using rt2-to-rt3-1.26 Since I have all sorts of problems with migrating character encoding, I have decided to convert all texts in the dumped tickets to ASCII. However, though all the headers seem untouched by the conversion, I'm not able to import

Re: [rt-users] Default password

2007-08-01 Thread Roy El-Hames
Have you any users in your Users table, if not then I would recommend re-installing RT, cause you need more than just the root user like the user Nobody and RT_System. Rgds; Roy John Oliver wrote: On Tue, Jul 31, 2007 at 02:53:50PM -0700, Chaim Rieger wrote: John Oliver wrote: I sho

Re: [rt-users] Default password

2007-08-01 Thread John Oliver
On Tue, Jul 31, 2007 at 02:53:50PM -0700, Chaim Rieger wrote: > John Oliver wrote: > >I shouldn't have to manually add a 'root' user. Right? > > > > > > after use rt3 do show tables > then > select * from Users > > is root in there ? No. But the tables are there... [EMAIL PROTECTED] ~]# mys

Re: [rt-users] Error writing to rt.log

2007-08-01 Thread Mathew Snyder
I haven't changed the file. I cleared it out by running echo '' > rt.log The permissions are the same as they have always been and it is actually being written to. The problem is only intermittent. Keep up with me and what I'm up to: http://theillien.blogspot.com Jesse Vincent wrote: > > On

Re: [rt-users] Error writing to rt.log

2007-08-01 Thread Roy El-Hames
most likely permissions on rt.log .. make sure your web user can write to rt.log chown your_web_user:your_web_group rt.log Roy Mathew Snyder wrote: I just cleared out a 35GB rt.log file. Now, people are getting intermittent errors: System error error: Cannot write to '/usr/local/rt-3.6.

Re: [rt-users] Error writing to rt.log

2007-08-01 Thread Mathew Snyder
The errors appear to be different when it happens too: error: Cannot write to '/usr/local/rt-3.6.1/var/log/rt.log': at /usr/lib/perl5/vendor_perl/5.8.8/Log/Dispatch/File.pm line 124. context: ... 120: } 121: else 122: { 123: $fh = $self

Re: [rt-users] Error writing to rt.log

2007-08-01 Thread Jesse Vincent
On Aug 1, 2007, at 12:56 PM, Mathew Snyder wrote: I just cleared out a 35GB rt.log file. Now, people are getting intermittent errors: Is the file in fact writable? Have you stopped and started your server? System error error: Cannot write to '/usr/local/rt-3.6.1/var/log/rt.log': at /

[rt-users] Error writing to rt.log

2007-08-01 Thread Mathew Snyder
I just cleared out a 35GB rt.log file. Now, people are getting intermittent errors: System error error: Cannot write to '/usr/local/rt-3.6.1/var/log/rt.log': at /usr/lib/perl5/vendor_perl/5.8.8/Log/Dispatch/File.pm line 124. context: ... 120: } 121:

[rt-users] Callback lesson please please

2007-08-01 Thread Roy El-Hames
Hi There; RT-3.6.4 Can someone give me few lines on how to use callbacks to customise RT, I've installed shredder for the only purpose of learning how it used callbacks, but it just added to my confusion , I want to add the CreateChildTicket callback as described in the Wiki but I am failing t

[rt-users] Scrip question: Approvals and changing ownership of the originating ticket

2007-08-01 Thread Chris Nelson
I implemented the approval process listed in the wiki here: http://wiki.bestpractical.com/view/ApprovalCreation If a ticket is created via email sent to the "approval" queue, the ticket and the resulting "approval" ticket do not have an owner. I wrote a scrip to set the owner of the approval

Re: [rt-users] Limit size of rt.log

2007-08-01 Thread Jesse Vincent
On Aug 1, 2007, at 12:41 PM, Mathew Snyder wrote: Is this possible? I just had to clear out a 35GB log file. Generally, I'd recommend using syslog logging instead. That way your regular syslog rotator would handle it. -jesse PGP.sig Description: This is a digitally signed message part

[rt-users] Limit size of rt.log

2007-08-01 Thread Mathew Snyder
Is this possible? I just had to clear out a 35GB log file. -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commerci

Re: [rt-users] relogin necessary after changing/creating queue

2007-08-01 Thread Jesse Vincent
On Aug 1, 2007, at 12:39 PM, Benjamin Weser wrote: Hello everybody, Whenever I create a queue or only change its name, this change will be visible after a relogin. I thought it could be a problem of cache so I looked for cache in the RT_Config.pm and found this entry which should be ok like it

[rt-users] relogin necessary after changing/creating queue

2007-08-01 Thread Benjamin Weser
Hello everybody, Whenever I create a queue or only change its name, this change will be visible after a relogin. I thought it could be a problem of cache so I looked for cache in the RT_Config.pm and found this entry which should be ok like it is: Set($WebFlushDbCacheEveryRequest, '1'); I also ad

[rt-users] users and group sequence resetting

2007-08-01 Thread Donal O'C
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, We noticed a problem recently with our RT install. Some incoming mails didn't get created as tickets. Checking the logs we get the errors below. I've copied 2 instances. This led us to check users_id_seq and groups_id_seq, both of whose "last

Re: [rt-users] Problem with OnQueueChange scrip

2007-08-01 Thread Roy El-Hames
This tells you the problem is with your template, I usually have the following 2 lines at the very top of the template: Subject: New Correspondence: {$Ticket->Subject} RT-Attach-Message: Yes Then leave 2 empty lines (you should do that) before adding any template text. If you are questioning N