Re: [rt-users] Query Tracing
Varun; I think I have mailed you this before, to log the sql queries within RT you need to add the following line to you RT_SiteConfig.pm file # DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be # the level that you wish SQL statements to be logged at. Set($StatementLog,1); Then restart the web server, at that point any sql query called will be logged to your rt.log file, if not enough logging is been written you can increase the level of logging by increasing 1 to 2 or 3 (not sure what each level log). Also I would recommend you log at the sql level , not sure about Oracle but I am sure there is a tool or variable to allow you to log slow queries some where, or you can once you do show queries from the oracle commend line during creating a ticket. By the way what version of DBIx::SearchBuilder and DBD you have installed, have you googled for common problems with the versions you have installed. You can determine the version of modules you have installed by browsing to your: https://YOUR_RT_URL/Admin/Tools/Configuration.html Roy Varun wrote: Hello All I want to trace queries that are dynamically firing in RT to track where they are making application slow. But I m not able to find out from where all queries are fired and from which file. My main concern is to trace Insert query for ticket creation and Update queries. Do any one has idea where I can find all this queries in which file. Any help is highly appreciated. Thanks Regards Varun Vyas ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] clickable link in custom field
On Thu, Jul 2, 2009 at 9:37 AM, Christian Looscl...@netcologne.de wrote: Natxo Asenjo schrieb: [knip explanation of what I would like to achieve] If you have example.com in the custom field and want to have a link like: http://example.com/webinterface/ you have to put this in Link values to field: http://__CustomField__/webinterface/ So, I make a CF management_url. Name and description are management_url, type is 'enter one value', applies to 'assets', no validation, Link values is then __CustomField__ and I apply it to the selected objects. What I want is in to enter in the CF a url that can be clickable, like http://ip.addres.of.switch If I then go to the asset and enter in the CF management_url the value http://ip.addr.of.switch then it is not clickable. If I enter http://__CustomField__ then it does make a link but it links to http://rtinstance.tld/AssetTracker/Asset/http%3A%2F%2F__CustomField__ and that goes nowhere obviously. Forgive my asking, maybe it is too hot and I do not see the obvious mistake in front of me. What am I doing wrong here? TIA, Natxo ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Query Tracing
Well I have already made the changes u told me .But still I m not getting any queries logged in my rt.log(Don't know why is it bcoz of log level which I set or something else :( ). And I have DBIx::SearchBuilder 1.55 and DBD::Oracle v1.19. -Original Message- From: Raed El-Hames [mailto:r...@vialtus.com] Sent: Thursday, July 02, 2009 2:03 PM To: Varun Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Query Tracing Varun; I think I have mailed you this before, to log the sql queries within RT you need to add the following line to you RT_SiteConfig.pm file # DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be # the level that you wish SQL statements to be logged at. Set($StatementLog,1); Then restart the web server, at that point any sql query called will be logged to your rt.log file, if not enough logging is been written you can increase the level of logging by increasing 1 to 2 or 3 (not sure what each level log). Also I would recommend you log at the sql level , not sure about Oracle but I am sure there is a tool or variable to allow you to log slow queries some where, or you can once you do show queries from the oracle commend line during creating a ticket. By the way what version of DBIx::SearchBuilder and DBD you have installed, have you googled for common problems with the versions you have installed. You can determine the version of modules you have installed by browsing to your: https://YOUR_RT_URL/Admin/Tools/Configuration.html Roy Varun wrote: Hello All I want to trace queries that are dynamically firing in RT to track where they are making application slow. But I m not able to find out from where all queries are fired and from which file. My main concern is to trace Insert query for ticket creation and Update queries. Do any one has idea where I can find all this queries in which file. Any help is highly appreciated. Thanks Regards Varun Vyas ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] clickable link in custom field
ok, it works now :-) in the link of the CF I fill this in: http://__CustomField__ and it works. Another question: how can I enter a port in the link? Like http://ip.add.of.device:9100 for a jetdirect printer, for instance. If I enter in the CF hostname:9100 then it takes me to this url (in another tab! great stuff): http://hostname%3a9100/ and then it does not work. I suppose it has to do with html encoding, but do not know how to fix this. Any clues? TIA, Natxo ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] DashBoard create rights
Hi, I am trying to configure Dashboards to all the users in my system. How do I assign the global right : CreateDashboard to all? I have a LOT of users in my system and it is hard to open Configuration/Global/UserRights.html and assign each one of them this right. Sometimes the system crashes just trying to list out all the users in this page. Is there a simpler way? Thank you, -Ashish ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] DashBoard create rights
Assign the right to the Privileged system group Potla, Ashish Bassaliel wrote: Hi, I am trying to configure Dashboards to all the users in my system. How do I assign the global right : CreateDashboard to all? I have a LOT of users in my system and it is hard to open Configuration/Global/UserRights.html and assign each one of them this right. Sometimes the system crashes just trying to list out all the users in this page. Is there a simpler way? Thank you, -Ashish ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] DashBoard create rights
On Thu, Jul 2, 2009 at 1:26 PM, Potla, Ashish Bassalielc_apo...@qualcomm.com wrote: Hi, I am trying to configure Dashboards to all the users in my system. How do I assign the global right : CreateDashboard to all? login as root of rt and create a systemwide dashboard: tools, dashboards, new and in privacy, choose rt system's dashboard. natxo ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT and Procmail
Hi experts, Im testing Procmail filtering for RT based on http://wiki.bestpractical.com/view/SpamFiltering and previous request http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg10144.html The procmail is not currently working. I'm always getting The following recipient(s) could not be reached: i...@data1.domain.net on 2009-07-02 09:52 AM There was a SMTP communication problem with the recipient's email server. Please contact your system administrator. data1.domain.net #5.5.0 X-Unix; 69 I do not know, what I'm missing. Please help My /etc/aliases it: |/usr/bin/procmail -m QUEUE=it /etc/procmailrcs/it-deliver.rc my /etc/procmailrcs/it-deliver.rc PATH=/usr/local/bin:/bin:/usr/bin LOGFILE=/var/log/procmail.log VERBOSE=YES LOGABSTRACT=YES # Trash email with failure notice :0w * ^subject:.*failure notice /dev/null # Send it to RT queue :0w | /opt/rt3/bin/rt-mailgate --queue $QUEUE --action correspond --url http://data1.echoworx.net/rt/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] How to make the subject field mandatory?
It works like a charm, thanks. Kevin W. Gagel Network Administrator Local 5448 My blog: http://mail.cnc.bc.ca/blogs/gagel My shared files: http://mail.cnc.bc.ca/users/gagel --- Original message --- Subject: Re: [rt-users] How to make the subject field mandatory? From: Elton S. Fenner elton.fen...@al.rs.gov.br To: Kevin Gagel ga...@cnc.bc.ca Cc: RT Users RT-Users@lists.bestpractical.com Date: 01/07/2009 10:08 AM Kevin! I implemented Mandatory Subject in my RT 3.8.2 following the instructions on: http://wiki.bestpractical.com/view/Extensionsand http://search.cpan.org/dist/RT-Extension-MandatorySubject/ Its working fine. Elton On 06/30/2009 05:41 PM, Kevin Gagel wrote: How can I make the subject field a mandatory field? Kevin W. Gagel Network Administrator Local 5448 My blog: http://mail.cnc.bc.ca/blogs/gagel My shared files: http://mail.cnc.bc.ca/users/gagel !DSPAM:8,4a4a78a053771833920503! Caro usuário: * Se este e-mail não foi corretamente classificado como spam, encaminhe paras...@dspam.al.rs.gov.br, ou apenas Spam. * Se este e-mail foi erroneamente classificado como spam, encaminhe paranots...@dspam.al.rs.gov.br, ou apenas Inocente. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:http://wiki.bestpractical.com Commercial support:sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy athttp://rtbook.bestpractical.com !DSPAM:8,4a4a78a053771833920503! Caro usuÃrio: * Se este e-mail nÃo foi corretamente classificado como spam, ecaminhe paras...@dspam.al.rs.gov.brou apenas Spam. * Se este e-mail foi erroneamente classificado como spam, encaminhe paranots...@dspam.al.rs.gov.brou apenas Inocente. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT-Authen-ExternalAuth-0.08 , privileged user if in group otherwise unprivileged
Hi, RT newbie here. I've got RT-Authen-ExternalAuth-0.08 set up and working against our eDirectory. What I'd like to do now, is have users created in RT as privileged if they are members of a specific group in the directory, and unprivileged if they exist but are not in the specific group. Is this possible? Mike Ellis___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Custom Fields not available for dashboard edit's
I'm having a problem with customfields not showing up when a user (me included) tries to change the column's available in a dashboard. The custom fields just don't show up. This started happening after I made a number of changes which included renaming the organization. I don't recall exactly what the old name was and tried a few variations but I can't seem to get those custom fields back. I've looked at user and group rights to ensure the showcustomfield and modifycustomfields are selected. That doesn't seem to be the problem. I fear the org name change did it and I can't set it back because I don't recall the exact string I used before changing it. So my question's are these: 1.) Would a change to the $Organization variable cause this problem? 2.) What would the query be to determine what names have been used so I can correct it? Kevin W. Gagel Network Administrator Local 5448 My blog: http://mail.cnc.bc.ca/blogs/gagel My shared files: http://mail.cnc.bc.ca/users/gagel ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Reqest Tracker CentOS 5.3 setup
Hi Moseley, Here is my configuration on httpd.conf. VirtualHost 172.16.0.1:80 ServerName rt.abc.com DocumentRoot /opt/rt3/share/html ErrorLog /var/log/httpd/rt.abc.com_error CustomLog /var/log/httpd/rt.abc.com-access_log common AddHandler fastcgi-script fcgi ScriptAlias / /opt/rt3/bin/mason_handler.fcgi /VirtualHost but it doesn't work for me. note: http://172.16.0.1/rt is working fine. would you please advise on this issue? regards, chanty From: jmose...@corp.xanadoo.com jmose...@corp.xanadoo.com To: ty chan chanty...@yahoo.com Cc: rt-users@lists.bestpractical.com; rt-users-boun...@lists.bestpractical.com Sent: Thursday, July 2, 2009 8:43:42 PM Subject: Re: [rt-users] Reqest Tracker CentOS 5.3 setup Threre really isn't much difference in the Apache configuration if using a virtual host. Simply put the RT apache config in a virtual host stanza: VirtualHost _default_:80 ServerName somertserver.com RT config lines... /VirtualHost The above example would use the default IP of the server and listen on port 80. You could also add other lines so that RT has its own log file, etc. I believe there are several virtual host configuration examples in the wiki. James Moseley ty chan chanty...@yahoo. com To jmose...@corp.xanadoo.com, Grant 07/02/2009 02:11 Deters gdet...@usd250.org AM cc rt-users@lists.bestpractical.com, rt-users-boun...@lists.bestpractica l.com Subject Re: [rt-users] Reqest Tracker CentOS 5.3 setup Hi Moseley, You guid how to configure virtualhost on apache for RT also. best regards, chanty___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com