Re: [rt-users] User performance reporting

2012-03-20 Thread Ruslan Zakirov
Try SLA extension from repository, there is a branch that implements this report. Ruslan from phone. 20.03.2012 0:38 пользователь David Hollinger david.hollin...@hwtears.com написал: I’m looking for an effective way to create/run a report on tickets from a specific queue, with specific owners

Re: [rt-users] Oddity within the RT database

2012-03-20 Thread Ruslan Zakirov
Have you tried to delete them in ui? Use rt-attributes viewer that is shipped with rt and installed into sbin directory. Decide which one you need and just delete an attribute. As far as I recall dashboards handle this properly. Ruslan from phone. 19.03.2012 20:54 пользователь Tim Cutts

[rt-users] How to automatically activate/enable created accounts.

2012-03-20 Thread Adrian Stel
Hi, I would like to automatically activate/enable accounts when account are created. Right now when accounts are created I must go to Access control and check: Let this user access RT and Let this user be granted rights (Privileged). In my case when some accounts are created automatically a

Re: [rt-users] callback for autoclose in RT4

2012-03-20 Thread inbel1
We automatically close our tickets when replying to the requestor. In RT3 I changed .../Ticket/Update.html from: if ($DefaultStatus =~ '~new$') { $DefaultStatus = 'open'; } We actually removed this code in 4.0, because all the status changes are

Re: [rt-users] Oddity within the RT database

2012-03-20 Thread Tim Cutts
On 20 Mar 2012, at 08:26, Ruslan Zakirov wrote: Have you tried to delete them in ui? Is that possible? These don't show up in the query builder is loadable saved searches - they're the RT::System standard ones, not user or group saved searches. Use rt-attributes viewer that is shipped

Re: [rt-users] Oddity within the RT database

2012-03-20 Thread Ruslan Zakirov
Ruslan from phone. 20.03.2012 14:31 пользователь Tim Cutts t...@sanger.ac.uk написал: On 20 Mar 2012, at 08:26, Ruslan Zakirov wrote: Have you tried to delete them in ui? Is that possible? These don't show up in the query builder is loadable saved searches - they're the RT::System

Re: [rt-users] How to automatically activate/enable created accounts.

2012-03-20 Thread Ruslan Zakirov
You can do it with a scrip that checks creator's record and makes user privileged and enabled. Ruslan from phone. 20.03.2012 13:00 пользователь Adrian Stel adisa...@gmail.com написал: Hi, I would like to automatically activate/enable accounts when account are created. Right now when

[rt-users] Error Condition Unimplemented in RT::Handle migration from 3.6.5 to 4.0.5 database

2012-03-20 Thread Juanjo
Hi again. I installa the new scenario, dump the old database and import in the new database. I try to upgrade the old to rt 4.0.5 installation. I do a Make initalize-database import the rt3 database on rt4 database and do: ./rt-setup-database --prompt-for-dba-password --action upgrade From

[rt-users] Name in use

2012-03-20 Thread Diego Roccia
Hi All, I have RT4.0.5 with RT::Authen::ExternalAuth, and I'm experiencing exactly this problem http://lists.fsck.com/pipermail/rt-users/2011-May/070489.html 1 - u...@domain1.com send an email - the user is created and the ticket opened 2 - u...@domain2.com send an email - the user is not

[rt-users] Create an user using Rest API

2012-03-20 Thread Guillaume Hilt
Hello, I'd like to create an user using RT API (with RT 3.8.7 on Ubuntu 10.04). I tried in PHP with a request to /user/new using this post data : id: user/new Name: test EmailAddress: t...@test.com RealName: test Lang: fr-fr Organization: test But all I got is a bad quest error : RT/3.8.7

Re: [rt-users] Name in use

2012-03-20 Thread Thomas Sibley
On 03/20/2012 07:15 AM, Diego Roccia wrote: I have RT4.0.5 with RT::Authen::ExternalAuth, and I'm experiencing exactly this problem http://lists.fsck.com/pipermail/rt-users/2011-May/070489.html 1 - u...@domain1.com send an email - the user is created and the ticket opened 2 -

Re: [rt-users] Create an user using Rest API

2012-03-20 Thread sunnavy
Is it possible that user test already exists? sunnavy On 12-03-20 13:38, Guillaume Hilt wrote: Hello, I'd like to create an user using RT API (with RT 3.8.7 on Ubuntu 10.04). I tried in PHP with a request to /user/new using this post data : id: user/new Name: test EmailAddress:

Re: [rt-users] Create an user using Rest API

2012-03-20 Thread Guillaume Hilt
No, I got no users right now, it's a fresh install. I tried again, adding Password and Privileged fields, same error. Guillaume Hilt Le 20/03/2012 14:13, sunnavy a écrit : Is it possible that user test already exists? sunnavy On 12-03-20 13:38, Guillaume Hilt wrote: Hello, I'd like

Re: [rt-users] Create an user using Rest API

2012-03-20 Thread Guillaume Hilt
Ok, I just noticed that, despite the error, the users were created in the database. Strange, but as long as it works. Guillaume Hilt Le 20/03/2012 14:16, Guillaume Hilt a écrit : No, I got no users right now, it's a fresh install. I tried again, adding Password and Privileged fields, same

[rt-users] Migrate Tickets from Trac to RT

2012-03-20 Thread Thomas Misilo
Hello, I was wondering if there are any tips/guides on migrating tickets from Trac to RT? Thanks, Tom

Re: [rt-users] Oddity within the RT database

2012-03-20 Thread Tim Cutts
On 20 Mar 2012, at 10:52, Ruslan Zakirov wrote: Ruslan from phone. 20.03.2012 14:31 пользователь Tim Cutts t...@sanger.ac.uk написал: On 20 Mar 2012, at 08:26, Ruslan Zakirov wrote: Have you tried to delete them in ui? Is that possible? These don't show up in the query

[rt-users] ERD (with relationships) for MySQL databases for versions 3.8.8 and 4.0.5 of RT?

2012-03-20 Thread Jeff Lucas
Hello folks. Does anybody have an ERD (with relationships) for the databases for version 3.8.8 and 4.0.5 of RT? I tried to create one with MySQL Workbench but all I can get is primary keys, are there any foreign keys or are the relationships defined anywhere? If it includes Asset Tracker,

Re: [rt-users] ERD (with relationships) for MySQL databases for versions 3.8.8 and 4.0.5 of RT?

2012-03-20 Thread Thomas Sibley
On 03/20/2012 12:28 PM, Jeff Lucas wrote: Hello folks. Does anybody have an ERD (with relationships) for the databases for version 3.8.8 and 4.0.5 of RT? I tried to create one with MySQL Workbench but all I can get is primary keys, are there any foreign keys or are the relationships defined

[rt-users] Renaming instance when no tickets

2012-03-20 Thread Guillaume Hilt
Hi all, Still with RT 3.8.7, I updated rtname and rt organisation from support.domain.tld to domain to match our company name. I don't have any tickets in the database. But, now, RT won't work, it fails to find the queue for the new emails I sent : temporary failure - RT couldn't find the

[rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread senior.unix
I'm getting the below warning when I'm upgrading my RT 3.8.8 mySQL DB to RT 4.0.5. I checked the source DB I used mysql SELECT * FROM `rt388`.`Tickets` where Type = 'approval'; and the upgraded DB using the below command mysql SELECT * FROM `rt405`.`Tickets` where Type =

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread Thomas Sibley
On 03/20/2012 04:02 PM, senior.unix wrote: I'm getting the below warning when I'm upgrading my RT 3.8.8 mySQL DB to RT 4.0.5. I checked the source DB I used mysql SELECT * FROM `rt388`.`Tickets` where Type = 'approval'; and the upgraded DB using the below command mysql SELECT * FROM

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread UnixMan
I get : mysql select name from queues; ERROR 1146 (42S02): Table 'rt405.queues' doesn't exist I ran this on the source system too and get the same thing for its rt388 DB Thomas Sibley wrote: On 03/20/2012 04:02 PM, senior.unix wrote: I'm getting the below warning when I'm upgrading my

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread Thomas Sibley
On 03/20/2012 04:39 PM, UnixMan wrote: mysql select name from queues; ERROR 1146 (42S02): Table 'rt405.queues' doesn't exist I ran this on the source system too and get the same thing for its rt388 DB You didn't type the query I typed, you lowercased it. See below: Thomas Sibley wrote:

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread UnixMan
I do the below and it looks like the queues table exists though : mysql show tables; +-+ | Tables_in_rt405 | +-+ | ACL | | AT_Assets | | AT_IPs | | AT_Ports| | AT_Types

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread UnixMan
ahh - here it is again with the right case : mysql select Name from Queues; ++ | Name | ++ | A General Request | | Approvals | | Audit-related

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread UnixMan
ahh - here it is again with the right case : mysql select Name from Queues; ++ | Name | ++ | A General Request | | Approvals | | Audit-related

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread Thomas Sibley
On 03/20/2012 04:59 PM, UnixMan wrote: ahh - here it is again with the right case : mysql select Name from Queues; ++ | Name | ++ | A General Request | | Approvals

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread UnixMan
Thanks - do you know how I can rename it ? Thanks for all your efforts, Scott Thomas Sibley wrote: On 03/20/2012 04:59 PM, UnixMan wrote: ahh - here it is again with the right case : mysql select Name from Queues; ++ | Name

Re: [rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

2012-03-20 Thread Jeff Blaine
On 3/20/2012 5:17 PM, UnixMan wrote: Thanks - do you know how I can rename it ? UPDATE Queues SET Name = '___Approvals' WHERE Name = 'Approvals';

Re: [rt-users] Error Condition Unimplemented in RT::Handle migration from 3.6.5 to 4.0.5 database

2012-03-20 Thread Juanjo
Anybody could help me? Thanks. El 20 de marzo de 2012 12:06, Juanjo juanji...@gmail.com escribió: Hi again. I installa the new scenario, dump the old database and import in the new database. I try to upgrade the old to rt 4.0.5 installation. I do a Make initalize-database import the

Re: [rt-users] ExternalAuth problem

2012-03-20 Thread Sandra Wittenbrock
Hello, Turns out my problem was that when I added MergeUsers, I had both: Set( @Plugins, (qw( RT::Authen::ExternalAuth RT::Extension::LDAPImport RT::Extension::MergeUsers RT::Extension::CommandByMail))); And a separate line; Set(@Plugins, qw(RT::Extension::MergeUsers)); It appears RT was

Re: [rt-users] How to delete reminders of unexisted tickets

2012-03-20 Thread Kevin Falcone
On Mon, Mar 19, 2012 at 06:52:02PM +0100, Wiktor Cetera wrote: I`ve deleted all tickets from RT by Shredder, but I had active Reminders. Now in the 'My Reminders' box i see information: Couldn't find Ticket for reminder 63. Please contact administrator. How can I delete this?

Re: [rt-users] What determines external auth vs. local auth

2012-03-20 Thread Kevin Falcone
On Mon, Mar 19, 2012 at 04:12:56PM -0400, Jeff Blaine wrote: When using RT-Extension-ExternalAuth, what is the logic for determining whether to authenticate to the external source or via RT's database? Will it always try the external source and then only use local if that was a connection

Re: [rt-users] callback for autoclose in RT4

2012-03-20 Thread Kevin Falcone
On Tue, Mar 20, 2012 at 10:34:42AM +0100, inb...@telenet.be wrote: We automatically close our tickets when replying to the requestor. In RT3 I changed .../Ticket/Update.html from: if ($DefaultStatus =~ '~new$') { $DefaultStatus = 'open'; }

Re: [rt-users] Name in use

2012-03-20 Thread Kevin Falcone
On Tue, Mar 20, 2012 at 12:15:01PM +0100, Diego Roccia wrote: I have RT4.0.5 with RT::Authen::ExternalAuth, and I'm experiencing exactly this problem http://lists.fsck.com/pipermail/rt-users/2011-May/070489.html 1 - u...@domain1.com send an email - the user is created and the ticket

Re: [rt-users] Oddity within the RT database

2012-03-20 Thread Kevin Falcone
On Mon, Mar 19, 2012 at 04:54:30PM +, Tim Cutts wrote: It looks as though at some point, probably a long time ago during an upgrade, that I accidentally ran part of the upgrade database task twice, and as a result some of the standard portlet searches are duplicated: select id, Name

Re: [rt-users] Renaming instance when no tickets

2012-03-20 Thread Kevin Falcone
On Tue, Mar 20, 2012 at 06:19:21PM +0100, Guillaume Hilt wrote: Still with RT 3.8.7, I updated rtname and rt organisation from support.domain.tld to domain to match our company name. I don't have any tickets in the database. But, now, RT won't work, it fails to find the queue for the new

Re: [rt-users] Error Condition Unimplemented in RT::Handle migration from 3.6.5 to 4.0.5 database

2012-03-20 Thread Kevin Falcone
On Tue, Mar 20, 2012 at 12:06:46PM +0100, Juanjo wrote: I installa the new scenario, dump the old database and import in the new database. I try to upgrade the old to rt 4.0.5 installation. I do a Make initalize-database import the rt3 database on rt4 database and do: