[rt-users] Re: "Take" in '"N" newest unowned tickets' display
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday, 22.01.2007 at 15:49 -0500, Dave Alden wrote: > I've created my own "N" newest unowned tickets search, but my "Take" > column displays the id, instead of the word "Take". How can I make > it say "Take" instead? I'm interested in this problem too: I can add a new column to the display, which can display *any* field and be a 'Take' link; however, as you, I'd like to make it a text link of the word 'Take'. Basically, I was trying to recreate the 'N newest unowned tickets' search by hand; no luck. Anyone know about this? Dave. - -- Dave Ewart [EMAIL PROTECTED] Computing Manager, Cancer Epidemiology Unit Cancer Research UK / Oxford University PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370 Get key from http://www.ceu.ox.ac.uk/~davee/davee-ceu-ox-ac-uk.asc N 51.7518, W 1.2016 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.2 (GNU/Linux) iD8DBQFFvboqbpQs/WlN43ARAjy3AJsEsxRHSricST3gYPrYNlNlJGbODgCgwlT/ 6sTzDQb3h1N++dcOMkBrzlk= =+Udd -END PGP SIGNATURE- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] mod_fastcgi or mod_fcgi, whats your expirience?
Hi Vivek, the problems are like this: 1. We started 20 fastcgi processes, the idle timeout is like yours, so far so fine, but our installation is splitted to www -> db server on different systems. after the idle timeout, the processes are not reconnecting again. 2. The fast_cgi processes performing under heavy load (6000-9000 concurrent user) absolutly bad. We have enough memory at the www box, enough cpu power but the processes are slow really slow. After this, we switched yesterday to mod_fcgid and from my feeling it is better, the negativ part herethey using more memory...argh. Our fast_cgi config: LoadModule fastcgi_module /usr/lib/httpd/modules/mod_fastcgi.so FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 1200 -processes 20 -listen-queue-depth 300 -priority 9 -appConnTimeout 305 ServerName ticket.int.kn ServerAdmin [EMAIL PROTECTED] DocumentRoot /opt/rt3/share/html AddHandler fastcgi-script .fcgi ExpiresActive On ExpiresByType text/css A3600 ExpiresByType image/png A3600 ExpiresByType application/x-javascript A3600 ExpiresByType image/gif A3600 Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/ Alias /pics/ /opt/rt3/share/html/NoAuth/images/pics/ ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/ Btw. @Vivek. You wrote in another Post about performance "boost" with some new indexes, but i can find this., can you repost it or sent? Thanks 2007/1/24, Vivek Khera <[EMAIL PROTECTED]>: On Jan 23, 2007, at 8:47 AM, Torsten Brumm wrote: who is using mod_fastcgi and who mod_fcgi? Can me tell someone the pros and cons? We are still using mod_fastcgi and we have a lot of problems. Did some have a good configuration example for both?? What does "lot of problems" mean? Perhaps if you described the symptoms we could help fix the cause... I use mod_fastcgi on FreeBSD 6.1 with Apache 2.0, perl 5.8.8, SSL enabled. i have to do an apache reload (graceful restart) once per night to force it to restart the fastcgi processes as they seem to memory bloat and we process a lot of tickets. I'd love it if they had the equivalent of Apache::SizeLimit from mod_perl... ### RT3 FastCGI AllowOverride None Order allow,deny Allow from all # set idle timeout a bit longer than RT's idle timeout. FastCgiServer /usr/local/rt3/bin/mason_handler.fcgi -processes 8 -idle-timeout 305 ServerName www.example.com DocumentRoot "/usr/local/rt3/share/html" AddDefaultCharset UTF-8 ErrorLog /var/log/httpd-rt-error.log CustomLog /var/log/httpd-rt-access.log combined AddHandler fastcgi-script fcgi Alias /NoAuth/images /usr/local/rt3/share/html/NoAuth/images Alias / /usr/local/rt3/bin/mason_handler.fcgi/ SSLEngine on SSLCipherSuite ALL:!ADH:!EXPORT56:!SSLv2:RC4+RSA:+HIGH:+MEDIUM:-LOW:+EXP:+eNULL SSLCertificateFile /usr/local/etc/apache2/ssl.crt/www.example.com.crt SSLCertificateKeyFile /usr/local/etc/apache2/ssl.key/ www.example.com.key SSLOptions +StdEnvVars SetEnvIf User-Agent ".*MSIE.*" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- MFG Torsten Brumm http://www.torsten-brumm.de ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Re: "Take" in '"N" newest unowned tickets' display
Have you tried to open the predefined search (superuser) and edit them by advanced Here is my working one: '__id__/TITLE:#', '__Subject__/TITLE:Subject', '__QueueName__', '__ExtendedStatus__', '__CreatedRelative__', '__loc(Take)__/TITLE: ' Torsten 2007/1/29, Dave Ewart <[EMAIL PROTECTED]>: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday, 22.01.2007 at 15:49 -0500, Dave Alden wrote: > I've created my own "N" newest unowned tickets search, but my "Take" > column displays the id, instead of the word "Take". How can I make > it say "Take" instead? I'm interested in this problem too: I can add a new column to the display, which can display *any* field and be a 'Take' link; however, as you, I'd like to make it a text link of the word 'Take'. Basically, I was trying to recreate the 'N newest unowned tickets' search by hand; no luck. Anyone know about this? Dave. - -- Dave Ewart [EMAIL PROTECTED] Computing Manager, Cancer Epidemiology Unit Cancer Research UK / Oxford University PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370 Get key from http://www.ceu.ox.ac.uk/~davee/davee-ceu-ox-ac-uk.asc N 51.7518, W 1.2016 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.2 (GNU/Linux) iD8DBQFFvboqbpQs/WlN43ARAjy3AJsEsxRHSricST3gYPrYNlNlJGbODgCgwlT/ 6sTzDQb3h1N++dcOMkBrzlk= =+Udd -END PGP SIGNATURE- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- MFG Torsten Brumm http://www.torsten-brumm.de ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Re: "Take" in '"N" newest unowned tickets' display
Hi, On Mon, Jan 29, 2007 at 12:59:33PM +0100, Torsten Brumm wrote: > Have you tried to open the predefined search (superuser) and edit them by > advanced > > Here is my working one: > > '__id__/TITLE:#', > '__Subject__/TITLE:Subject', > '__QueueName__', > '__ExtendedStatus__', > '__CreatedRelative__', > '__loc(Take)__/TITLE: ' Thank you - thank you - thank you. :-) ...dave -- Dave Alden The Ohio State University Department of Mathematics ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] mod_fastcgi or mod_fcgi, whats your expirience?
On Jan 29, 2007, at 6:08 AM, Torsten Brumm wrote:The FastCGI protocol needs to die. It is very cumbersome and difficult to implement efficiently, and the C libraries for it are, shall we say, difficult to modernize. Lately I've been recoding our large projects to use the new SCGI protocol. The speedup and reliability and ease of implementation have dramatically improved.Btw. @Vivek. You wrote in another Post about performance "boost" with some new indexes, but i can find this., can you repost it or sent?These were for Postgres for RT 3.2, but seem to still apply to 3.6. The stock indexes that come with RT are basically unused due to how querybuilder makes queries. rt321index.sql Description: Binary data smime.p7s Description: S/MIME cryptographic signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] mod_fastcgi or mod_fcgi, whats your expirience?
Thanks Vivek, will try it out. Torsten 2007/1/29, Vivek Khera <[EMAIL PROTECTED]>: On Jan 29, 2007, at 6:08 AM, Torsten Brumm wrote: The FastCGI protocol needs to die. It is very cumbersome and difficult to implement efficiently, and the C libraries for it are, shall we say, difficult to modernize. Lately I've been recoding our large projects to use the new SCGI protocol. The speedup and reliability and ease of implementation have dramatically improved. Btw. @Vivek. You wrote in another Post about performance "boost" with some new indexes, but i can find this., can you repost it or sent? These were for Postgres for RT 3.2, but seem to still apply to 3.6. The stock indexes that come with RT are basically unused due to how querybuilder makes queries. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- MFG Torsten Brumm http://www.torsten-brumm.de ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Perl API Help
I'm somewhat new to perl, but I'm starting to pick up a bit of it. There are a bunch of custom tasks I want to do to integrate RT with some other systems. I have been looking for some documentation, but what I saw in the RT wiki was very limited for someone in my position. Can anyone point me towards some documentation that can give me a start at writing some of my own scripts? I would like to see some basics on modifying users, groups, tickets, etc and I can work from there. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
I've been trying to get the same help. However, there is limited documentation on the codebase. I've asked questions here but I often get cryptic answers that leave me not know what even I'm talking about. Mathew John Arends wrote: > I'm somewhat new to perl, but I'm starting to pick up a bit of it. There > are a bunch of custom tasks I want to do to integrate RT with some other > systems. I have been looking for some documentation, but what I saw in > the RT wiki was very limited for someone in my position. > > Can anyone point me towards some documentation that can give me a start > at writing some of my own scripts? I would like to see some basics on > modifying users, groups, tickets, etc and I can work from there. > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy > a copy at http://rtbook.bestpractical.com > > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
On Mon, Jan 29, 2007 at 09:41:08AM -0600, John Arends wrote: > I'm somewhat new to perl, but I'm starting to pick up a bit of it. There > are a bunch of custom tasks I want to do to integrate RT with some other > systems. I have been looking for some documentation, but what I saw in > the RT wiki was very limited for someone in my position. > > Can anyone point me towards some documentation that can give me a start > at writing some of my own scripts? I would like to see some basics on > modifying users, groups, tickets, etc and I can work from there. You might want to start with the O'Reilly book... > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
While the book has done me wonders in learning to use and configure RT, it has done little for me in the realm of the codebase. I'm hoping the training in Boston helps in this regard :) Mathew Jesse Vincent wrote: > > > On Mon, Jan 29, 2007 at 09:41:08AM -0600, John Arends wrote: >> I'm somewhat new to perl, but I'm starting to pick up a bit of it. There >> are a bunch of custom tasks I want to do to integrate RT with some other >> systems. I have been looking for some documentation, but what I saw in >> the RT wiki was very limited for someone in my position. >> >> Can anyone point me towards some documentation that can give me a start >> at writing some of my own scripts? I would like to see some basics on >> modifying users, groups, tickets, etc and I can work from there. > > You might want to start with the O'Reilly book... > >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
I have the book right next to me. (It is a very good book, and buying it was the least I could do to support this project.) The problem is the book just touches on the subject. As someone who is trying to learn perl I can't pick up enough to figure out what to do from the chapter on the perl API. Maybe if someone gives a couple examples, I can work with that. A few things I would like to do (in no particular order): -see a list of all the members of a group -add/remove a user from a group -create a user -set a user as privileged -create a ticket (and populate a custom field while doing it) Jesse Vincent wrote: On Mon, Jan 29, 2007 at 09:41:08AM -0600, John Arends wrote: I'm somewhat new to perl, but I'm starting to pick up a bit of it. There are a bunch of custom tasks I want to do to integrate RT with some other systems. I have been looking for some documentation, but what I saw in the RT wiki was very limited for someone in my position. Can anyone point me towards some documentation that can give me a start at writing some of my own scripts? I would like to see some basics on modifying users, groups, tickets, etc and I can work from there. You might want to start with the O'Reilly book... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
Matt; I found the best resource is in /opt/rt3/lib/RT/ Find the appropriate module (Users_ , Tickets_ blah ) copy and hack away .. Roy Mathew wrote: While the book has done me wonders in learning to use and configure RT, it has done little for me in the realm of the codebase. I'm hoping the training in Boston helps in this regard :) Mathew Jesse Vincent wrote: On Mon, Jan 29, 2007 at 09:41:08AM -0600, John Arends wrote: I'm somewhat new to perl, but I'm starting to pick up a bit of it. There are a bunch of custom tasks I want to do to integrate RT with some other systems. I have been looking for some documentation, but what I saw in the RT wiki was very limited for someone in my position. Can anyone point me towards some documentation that can give me a start at writing some of my own scripts? I would like to see some basics on modifying users, groups, tickets, etc and I can work from there. You might want to start with the O'Reilly book... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
I've been looking at that myself. However some things just aren't clear. For example: I need to create a script that pulls from the database for each user the time spent on each customer (stored in a CF). So this requires me to pull the user, the customer, all ticket transactions associated with both, and the timespent for each transaction. I've been looking at the lib/RT directory but have not found a clear line of sight that leads to this. This is just an example, mind you. Solving this one problem might shed a bit of light on the next but it will be just as daunting sifting through the code to find the next solution. I think it would be helpful to have some documentation outside of the perldocs for each .pm which provides more insight using example code with real world problems such as the one above. Mathew Roy El-Hames wrote: > Matt; > I found the best resource is in /opt/rt3/lib/RT/ > Find the appropriate module (Users_ , Tickets_ blah ) copy and hack away .. > Roy > > Mathew wrote: >> While the book has done me wonders in learning to use and configure RT, >> it has done little for me in the realm of the codebase. I'm hoping the >> training in Boston helps in this regard :) >> >> Mathew >> >> Jesse Vincent wrote: >> >>> On Mon, Jan 29, 2007 at 09:41:08AM -0600, John Arends wrote: >>> I'm somewhat new to perl, but I'm starting to pick up a bit of it. There are a bunch of custom tasks I want to do to integrate RT with some other systems. I have been looking for some documentation, but what I saw in the RT wiki was very limited for someone in my position. Can anyone point me towards some documentation that can give me a start at writing some of my own scripts? I would like to see some basics on modifying users, groups, tickets, etc and I can work from there. >>> You might want to start with the O'Reilly book... >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com >> >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> >> > > > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
On Monday 29 January 2007 10:59, John Arends wrote: > I have the book right next to me. (It is a very good book, and buying it > was the least I could do to support this project.) > > The problem is the book just touches on the subject. As someone who is > trying to learn perl I can't pick up enough to figure out what to do > from the chapter on the perl API. Trying to learn Perl and trying to learn the RT API at the same time is *very* ambitious. The Wiki is your friend. The various modules in RT do have manual pages, too. For example, to find out what methods are available for a RT::Ticket object, just issue this command: $ perldoc /path/to/rt/lib/RT/Ticket_Overlay.pm Another fine source of information is the code itself. Especially the embedded test code in each module. Of course this is quite a challenge, if you do not know Perl. :-( > Maybe if someone gives a couple examples, I can work with that. > > A few things I would like to do (in no particular order): # initialization for a RT batch program # # NOTE: NO ERROR CHECKING below -- very bad -- see the code to # find out how to check return values from various methods use warnings; use strict; use lib '/path/to/rt/lib'; use RT::Interface::CLI; RT::LoadConfig(); RT::Init(); open my $fh, '> /path/to/log/file' or die "can't open /path/to/log/file: $!\n"; > -see a list of all the members of a group my $group = RT::Group->new($RT::SystemUser); $group->LoadUserDefinedGroup('my group name'); my $users = $group->UserMembersObj(); while (my $user = $users->Next()) { print $fh $user->Name(), "\n"; } > -add/remove a user from a group my $group = RT::Group->new($RT::SystemUser); $group->LoadUserDefinedGroup('my group name'); my $user = RT::User->new($RT::SystemUser); $user->Load('my_user_id'); $group->AddMember($user->PrincipalId()); # remove from group left as an exercise > -create a user my $user = RT::User->new($RT::SystemUser); $user->Create(Name => 'my_user_id', Password => 'secret', RealName => 'John Doe', EmailAddress => [EMAIL PROTECTED]', Privileged => 0); > -set a user as privileged > -create a ticket (and populate a custom field while doing it) These are left as an exercise for the reader. Use the code, Luke. :-) -- Garry T. Williams --- 678-370-2438 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Perl API Help
Added examples to http://wiki.bestpractical.com/?CodeSnippets On 1/29/07, Garry T. Williams <[EMAIL PROTECTED]> wrote: [snip] -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] AT_SiteConfig.pm not read after upgrade to AT1.2.3, RT3.6.3
More of an AssetTracker question than RT, but the AT list is still down, and this probably (hopefully?) has some parallels to RT. After upgrading this weekend from RT3.4.4, AT1.2.1 to RT3.6.3, AT1.2.3, it appears that my AT_SiteConfig.pm is not being read. Specifically, my custom statuses do not appear, only the default statuses do. Also, default status I have marked as inactive still appear. Permissions on the file and its parent directories look ok. It is at least readable by all. dr-xr-xr-x 3 root wheel 512 Dec 10 18:51 . drwxr-xr-x 3 root wheel 512 Dec 10 18:51 .. -r-xr-xr-- 1 root wheel 2199 Dec 13 08:33 AT_Config.pm -r-xr-xr-- 1 root wheel 481 Jan 29 10:04 AT_SiteConfig.pm I have attached the file in question. Does anyone have any suggestions for troubleshooting this? I'm logging debug out to file, and I don't see any errors related to this. Thanks, Ryan # You can define new statuses and even reorder existing statuses here. # WARNING. DO NOT DELETE ANY OF THE DEFAULT STATUSES. If you do, RT # will break horribly. @ActiveStatus = ('production','development','test','storage','stock','Initial Request','Submitted to Acad. A','Return from B.O.','Faxed to Vendor','Inventory' ) unless @ActiveStatus; @InactiveStatus = qw(retired dr pilot qa) unless @InactiveStatus; Set ($GlobalUniqueAssetName, 1); Set ($TypeUniqueAssetName, 0); 1; begin:vcard fn:Ryan Fox n:Fox;Ryan org:The University of Findlay;Information Technology Services adr:21 Old Main;;1000 Main St;Findlay;OH;45840;USA email;internet:[EMAIL PROTECTED] title:Network Services Manager tel;work:419-434-4348 x-mozilla-html:TRUE version:2.1 end:vcard ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] AT_SiteConfig.pm not read after upgrade to AT1.2.3, RT3.6.3
Fix the file permissions on etc/AT_*. The RT upgrade process locks down the permissions on everything in etc. -Todd ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT Custom Fields
Hey, I'm hoping that someone can help me out with understanding how to use the 'Link values to' and 'Include page' features of the New Custom Field form? I would really like to pull values into RT custom fields from an external database so that's what I'm hoping these features will do, but I'm having a really hard time finding documentation. I'm using RT 3.6.3. Can someone help? Thanks! Julia ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Mysql to Postgres Problems
Hi there! I´ve successfully migrated the MySQL database to Postgres. But still having some problems. When I finish the import process I access the RT web interface. At the homepage (RT at a Glance), I get: Can't call method "Content" on an undefined value at /usr/local/rt3/share/html/Elements/MyRT line 75. I´ve already solved this problem by running the make upgrade scripts as follows: /path/to/rt/sbin/rt-setup-database --dba root --prompt-for-dba-password --action insert --datadir etc/upgrade/3.5.1 And the previous problem was gone! Now, when I run the upgrade script I get the following error 3 times: Error: Internal Error: Couldn't execute the query 'INSERT INTO Attributes (ContentType, Creator, ObjectId, LastUpdatedBy, Created, Content, LastUpdated, Description, Name, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'ERROR: permission denied for sequence attributes_id_seq Any ideas? Thanks a lot!! Mario Gomide Gilmar Santos Jr escreveu: Hello Mario, I considered migrating a couple weeks ago. I wrote a tutorial[1] about it and a Perl script to help with the process. I've just added a few instructions at RT wiki. We have almost 400.000 tickets and had serious performance problems. Pg performed much worse than MySQL, even after performance tunning configurations. After increasing innodb_buffer_poll_size (MySQL's configuration directive) the performance problem was gone. I tested with RT 3.4.5, but i think it will work fine on 3.6, since there were no schema changes. ps.: create database on postgre with encoding *latin1*. Good luck, Gilmar Santos Jr Mario Gomide escreveu: Hello list! I used to use RT-3.4.1 on MySQL and I´m trying to migrate to RT-3.6.1 on PostgreSQL 8.1. I´m having some problems with the database import process. I get the same errors many times: ERROR: invalid byte sequence for encoding "UTF8": and invalid input syntax for integer: "" Can I just change the value to NULL where the value is empty? I have noticed that most of my data was imported... First of all I begin a new RT 3.6.1 installation, then I follow these instructions (http://wiki.bestpractical.com/index.cgi?MySQLToPg). That is: Dump from mysql is done: mysqldump -u user -p mydatabase > dumpfile.sql I edit this dumpfile leaving it only with INSERT INTO lines and removing everything related to the sessions table. Then on my new installation, I access the DB and DELETE FROM each table. After that, I do: psql -h localhost -f dumpfile.sql newdb After that I run the make upgrade process. I hope you can help me out. Thanks Mario Gomide ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] versioned attachments?
Is it possible to have some sort of version control on RT attachments? i.e. If someone opens a ticket with "foo.tgz" as an attachment, and later in that ticket's history, another "foo.tgz" is attached. RT includes both attachments in the ticket, though they are dated. Normally this is okay, but if we really only wanted to show the latest instance of that particular attachment, is there any way to hide the older ones? thanks, Thomas ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Mysql to Postgres Problems
Mario Gomide escreveu: > [...] > > Now, when I run the upgrade script I get the following error 3 times: > Error: Internal Error: Couldn't execute the query 'INSERT INTO > Attributes (ContentType, Creator, ObjectId, LastUpdatedBy, Created, > Content, LastUpdated, Description, Name, ObjectType) VALUES (?, ?, ?, > ?, ?, ?, ?, ?, ?, ?)'ERROR: permission denied for sequence > attributes_id_seq > > Any ideas? Verify the owner of sequence objects in Pg... -- Gilmar Santos Jr ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] LDAP Overlay and automated logins
Is it possible to pass the username and password to RT in the link? we are running RT3.6.3 with the LDAP overlay. I realize the user would not be terribly secure but i am looking for an easy way to direct many people into a single login without too many steps. --Ryan ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] mailgate not working
I've been having trouble getting rt mailgate to work when using an ssl virtual host. I can get it to work when using a virtual host on port 80. Just wondering if anyone has rt running on a ssl virtual host? Would you mind sharing a sample config for apache httpd-ssl.conf? With the config below, I can connect to the web interface, but email fails with a message saying it "can't connect". ..extra/httpd-ssl.conf: # Fast CGI FastCgiIpcDir /tmp FastCgiServer /usr/local/rt-3.6.3/bin/mason_handler.fcgi -idle-timeout 120 ## ## SSL Virtual Host Context ## # General setup for the virtual host ServerName webrt.rtdomain.com:443 DocumentRoot "/usr/local/rt-3.6.3/share/html" ServerAdmin [EMAIL PROTECTED] AddHandler fastcgi-script fcgi ScriptAlias / /usr/local/rt-3.6.3/bin/mason_handler.fcgi/ AddDefaultCharset UTF-8 SetHandlel fastcgi-script . . . On Mon, Jan 15, 2007 at 04:56:51PM -0500, Tim Longo wrote: > > Hello, > > I'm in the process of installing rt-3.6.3, using > apache-2.2.4 (w/ fastcgi), mysql-5.0.24, perl-5.8.8, using > solaris and sendmail. > > Following the install README, I've gotten to a point where I > am able to access the webrt interface, and have created a > queue, and granted access to the "everyone" group to create > a ticket. I've also created email aliases, but run into some > problems when sending email to create a ticket: ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Merging RT Databases
Hi! I have made a migration of RT from version 3.0.9 to 3.6.1 with MySQL 5.0 and it's working very well. The problem is that I have a second RT running on another machine that contains data that I want to put/merge into the new RT database. With this I'll have one RT with one database instead two RT's with two databases. Is that possible? If so, how can I do that? I can't just make a mysqldump because the Ticket ID's already exists in the first one.! Someone can help me with this? Thanks a lot. Ruben Romao e: [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com