[rt-users] CSS in source code
Hi all! And. good morning! :-) I have a new page for my client in RT. I'm trying to modify this page adding css code in several tags, but the format is not seen as it should. I put a simple example that I'm using in that page: ** The page's name is lalala.html ** I have a table, that it has several rows XD *** I'm using the next: tr style=border: thin solid blue; ** Result: the row hasn't got the blue border :-( :-( Any idea? Any file that I have to search in? Best regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 http://www.altran.es www.altran.es image001.jpg___ 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] CSS in source code
I have found this link [1] on RT Wiki. Should I do it this way?? [1]: http://wiki.bestpractical.com/view/CustomizingWithCallbacks http://wiki.bestpractical.com/view/CustomizingWithCallbacks Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 http://www.altran.es www.altran.es _ size=2 width=100% align=center De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] En nombre de Alberto Villanueva Enviado el: lunes, 16 de marzo de 2009 11:13 Para: rt-users@lists.bestpractical.com Asunto: [rt-users] CSS in source code Hi all! And. good morning! :-) I have a new page for my client in RT. I'm trying to modify this page adding css code in several tags, but the format is not seen as it should. I put a simple example that I'm using in that page: ** The page's name is lalala.html ** I have a table, that it has several rows XD *** I'm using the next: tr style=border: thin solid blue; ** Result: the row hasn't got the blue border :-( :-( Any idea? Any file that I have to search in? Best regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 http://www.altran.es www.altran.es image001.jpg___ 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] Upgrading - 3.6.5 - 3.8.2
Hi, In following the upgrade docs we apply updates to schema with /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade But this gives me error below. Any ideas how I could progress past this issue? Output from console; Processing 3.7.1 Now inserting data Processing 3.7.3 Now populating database schema. Processing 3.7.10 Now inserting data Processing 3.7.15 Now inserting data Processing 3.7.19 Now inserting data Processing 3.7.81 Now populating database schema. [Mon Mar 16 11:26:16 2009] [crit]: DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line 506. (/opt/rt3/sbin/../lib/RT.pm:377) DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line 506. ___ 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] Problem Tools, Reports Postgres 3.8.2
Thank you for the information. I was hoping that it was something like that. Stick with your areas of expertise to reduce support costs. We are more the other way here with more PostgreSQL than MySQL. What is your plan to provide redundancy/business continuity for your RT instance and what does MySQL for handling full-text searching? We are trying to evaluate possible options for some new MySQL instances and any feedback would be appreciated. Redundancy at the moment is just dump/restore of the database and having mirrored disks. When we go MySQL we may add master/slave replication, which we use for most of our smaller databases. -Kristian ___ 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] Upgrading - 3.6.5 - 3.8.2
On Mon, Mar 16, 2009 at 11:30:22PM +1200, Aaron Guise wrote: Hi, In following the upgrade docs we apply updates to schema with /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade But this gives me error below. Any ideas how I could progress past this issue? That suggests you've tried to run the update before or manually added an index. You might try a DROP INDEX CachedGroupMembers3; and starting over from where the upgrade bailed out. Output from console; Processing 3.7.1 Now inserting data Processing 3.7.3 Now populating database schema. Processing 3.7.10 Now inserting data Processing 3.7.15 Now inserting data Processing 3.7.19 Now inserting data Processing 3.7.81 Now populating database schema. [Mon Mar 16 11:26:16 2009] [crit]: DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line 506. (/opt/rt3/sbin/../lib/RT.pm:377) DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line 506. ___ 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 -- ___ 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 template probs using RT::Group
Hi, On RT 3.8.2 I am trying to use the example here: http://wiki.bestpractical.com/view/SendEmailAction When I try and use the section in the template as described in the wiki: To: { my $GroupObj = RT::Group-new($user); $GroupObj-LoadUserDefinedGroup('Group Name'); $GroupObj-MemberEmailAddressesAsString()} it doesn't work for me, I see this error in the system messages file: Mar 16 00:01:52 alpha RT: RT::Users=HASH(0x16b0a97c) was created without a CurrentUser. Any RT object which is subclass of RT::Base must be created with a RT::CurrentUser or a RT::User object as the first argument. (/usr/local/lib/perl5/site_perl/5.8.9/RT/Base.pm:108) Mar 16 00:01:53 alpha RT: Template parsing error: RT::Users=HASH(0x16b0a97c) was created without a CurrentUser at /usr/local/lib/perl5/site_perl/5.8.9/RT/SearchBuilder.pm line 81 RT::SearchBuilder::_Init('RT::Users=HASH(0x16b0a97c)', undef) called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm line 80 RT::Users::_Init('RT::Users=HASH(0x16b0a97c)', undef) called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 93 DBIx::SearchBuilder::new('RT::Users', undef) called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 843 RT::Group::UserMembersObj('RT::Group=HASH(0x16b327ac)') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 878 RT::Group::MemberEmailAddresses('RT::Group=HASH(0x16b327ac)') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 899 RT::Group::MemberEmailAddressesAsString('RT::Group=HASH(0x16b327ac)') called at template line 3 eval 'package Text::Template::GEN2; ; #line 1 template my $GroupObj = RT::Group-new Mar 16 00:01:53 alpha kernel: oup-new It does work if I use this code: To: { my $GroupObj = RT::Group-new($RT::SystemUser); $GroupObj-LoadUserDefinedGroup('Group Name'); $GroupObj-MemberEmailAddressesAsString()} But I don't understand the difference, is using $RT::SystemUser going to do anything bad? If this is ok and there is some problem with the code as is on the wiki should I update the data on the wiki? thanks for any help, Andy. ___ 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] Is RT allright being OK ?
Hello, I discovered I had mistakes in my scrips (forgot the -ISO cast), but I am puzzled : is it normal that my table and field name are lower case even though I installed request tracker with the rt-setup-database script ? Will it be a problem upgrading ? Here is a short sample of /etc/request-tracker3.8/schema.Pg : CREATE TABLE Tickets ( id INTEGER DEFAULT nextval('tickets_id_seq'), Starts TIMESTAMP NULL , Started TIMESTAMP NULL , Due TIMESTAMP NULL , Resolved TIMESTAMP NULL , Here is a short sample of pg_dump -F p rt3 rt320090316.sql: CREATE TABLE tickets ( id integer DEFAULT nextval('tickets_id_seq'::regclass) NOT NULL, starts timestamp without time zone, started timestamp without time zone, due timestamp without time zone, resolved timestamp without time zone, I may seems stupid, but I prefer to bluntly reinstall my RT if I cannot upgrade. -- Julien Tayon // digital craftsman // making things simpler (when possible) Tell a man there are 300 billion stars in the universe and he'll believe you. Tell him a bench has wet paint on it and he'll have to touch to be sure. ___ 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] Asset Tracker + 3.8.2 possible?
Greetings, I'm just getting started with trying to set up a test-instance of RT. Before I possibly break what I've so far accomplished can anyone tell me if Asset Tracker 1.2.3 will work with rt-3.8.2? In the README file there're instructions to patch rt-3.4 but I'm reluctant to run that against 3.8.2 without knowing that someone has done it before successfully. thanks so much in advance for your time, ~c ___ 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] RT 3.8.2 packages for Debian Lenny?
On Wed, Feb 04, 2009 at 02:05:27PM +, Dominic Hargreaves wrote: On Tue, Jan 27, 2009 at 04:45:15PM +, Dominic Hargreaves wrote: I hesitate to say again, since I previously expected to be able to do an upload the same week. I'm just testing our current candidate, but there's a new bug which requires a new package upload to Debian which I'll want to get in before a new upload, so it may not be for another week or so. Current status is that this is currently stalled on a new package waiting in NEW[0] (libipc-run-safehandles-perl) I would hazard a guess that ftpmasters are busy preparing for the release of Lenny, so this might not get processed for a few weeks. RT 3.8.2 packages are now in unstable. Cheers, Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford ___ 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] Asset Tracker + 3.8.2 possible?
I would use 1.2.4b1 from the repo. http://code.google.com/p/asset-tracker-4rt/source/checkout No patching of RT is necessary. Confidence level is high. :) On Mon, Mar 16, 2009 at 12:08 PM, charlie derr cd...@simons-rock.edu wrote: Greetings, I'm just getting started with trying to set up a test-instance of RT. Before I possibly break what I've so far accomplished can anyone tell me if Asset Tracker 1.2.3 will work with rt-3.8.2? In the README file there're instructions to patch rt-3.4 but I'm reluctant to run that against 3.8.2 without knowing that someone has done it before successfully. thanks so much in advance for your time, ~c ___ 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 ___ 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] ruby library for REST access status
I have completed a first version of a ruby library for accessing RT via the REST interface. It supports adding/modifying/corresponding on tickets, adding/modifying users, and attachments (initially, as long as they fit in memory. Streaming attachments and chunking them via HTTP is on my todo list). It's functionally similar to RT::Client::REST in perl, but for ruby. However, since I wrote this on company time I need company approval to open source it. I've requested that and am waiting for approval before releasing the code. Is there anyone on the list who would use this if it were open sourced? It might provide some leverage to get it released if we know if there are others out there who will use it and possibly provide patches / feature enhancements. -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ 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] Asset Tracker + 3.8.2 possible?
Charlie, You can disregard that. At least I did when I installed on my RT but I am on 3.6 John J. Boris, Sr. JEN-A-SyS Administrator Archdiocese of Philadelphia 222 North 17th Street Philadelphia, Pa. 19103 Tel: 215-965-1714 Fax: 215-587-3525 Remember! That light at the end of the tunnel Just might be the headlight of an oncoming train! charlie derr cd...@simons-rock.edu 03/16/09 11:08 AM Greetings, I'm just getting started with trying to set up a test-instance of RT. Before I possibly break what I've so far accomplished can anyone tell me if Asset Tracker 1.2.3 will work with rt-3.8.2? In the README file there're instructions to patch rt-3.4 but I'm reluctant to run that against 3.8.2 without knowing that someone has done it before successfully. thanks so much in advance for your time, ~c ___ 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 ___ 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] Is RT allright being OK ?
jul wrote, On 3/16/09 11:17 AM: Hello, I discovered I had mistakes in my scrips (forgot the -ISO cast), but I am puzzled : is it normal that my table and field name are lower case even though I installed request tracker with the rt-setup-database script ? Yes. SQL names are case-insensitive except when quoted (i.e. used as literals). Will it be a problem upgrading ? No. ___ 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] RTFM installation problem
Hi I try to install RTFM and I got this error when I ran make initdb /usr/bin/perl -Ilib -I/opt/rt3/local/lib -I/opt/rt3/lib /opt/rt3/sbin/rt-setup-database --action schema --datadir etc --dba RT2 --prompt-for-dba-password Setuid/gid script is writable by world. ...returned with error: 6400 make: *** [initdb] Error 25 any help Shaekir, _ Chat with the whole group, and bring everyone together. http://go.microsoft.com/?linkid=9650735___ 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] Victor Da Fonseca/KW/ECS/SCHINDLER est absent(e).
Je serai absent(e) du 16/03/2009 au 20/03/2009. I'am out of office between 16/03/2009 and 20/03/2009. Mail is not forwarded. * Nota : Les informations contenues dans ce message sont exclusivement destineacute;es aux personnes nommeacute;es ci- dessus et peuvent contenir des donneacute;es confidentielles ou proteacute;geacute;es.Une erreur de transmission n'entraicirc;ne aucune renonciation agrave; la onfidentialiteacute; de ces donneacute;es. Si vous n'ecirc;tes pas le destinataire preacute;vu de ce message, vous ecirc;tes informeacute;que vous ne devez pas l'utiliser, le divulguer ou le copier, sous quelque forme que ce soit.Si vous avez reccedil;u ce courrier eacute;lectronique par erreur, merci de le supprimer ainsi que seseacute;ventuelles copies et d'informer immeacute;diatement l'expeacute;diteur.br Notice : The information contained in this message is intended only foruse of the individual(s) named above and may contain confidential,proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance of it. If you have received this message in error please delete it and any copies of it and notify the sender immediately. ** ___ 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] CreatedMonthly Graphs broken with Custom Field parameter?
I have a RT 3.8.2 instance setup and I like to use the CreatedMonthly bar graph to see ticket histories. The graph, however, appears to break if you try to use it with a search that includes a custom field parameter. For example, if I search for all tickets in our firewall queue with the Request Type custom Field set to any valid value, I get a blank graph with no totals at the bottom. I also see the following warnings in the RT logs. [Mon Mar 16 20:56:28 2009] [warning]: DBD::mysql::st execute failed: Column 'Created' in field list is ambiguous at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) [Mon Mar 16 20:56:28 2009] [warning]: RT::Handle=HASH(0x985ec6c) couldn't execute the query 'SELECT DISTINCT COUNT(main.id) AS id, SUBSTR(Created,1,7) AS createdmonthly FROM Tickets main JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '7' ) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_1.Disabled = '0' ) AND ( ObjectCustomFieldValues_1.ObjectId = main.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '4' AND ( ( ( ObjectCustomFieldValues_1.Content LIKE '%Host Add Request%' OR ( ( ObjectCustomFieldValues_1.Content = '' OR ObjectCustomFieldValues_1.Content IS NULL ) AND ObjectCustomFieldValues_1.LargeContent LIKE '%Host Add Request%' ) ) ) ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY SUBSTR(Created,1,7) ' at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 Has anyone else run into this issue? Anyone found a workaround or solution? Thanks, Addam -- Addam Schroll IT Security and Privacy Analyst IT Networks Security, Purdue University ad...@purdue.edu ___ 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] FW: RTFM installation problem
Hi I try to install RTFM and I got this error when I ran make initdb /usr/bin/perl -Ilib -I/opt/rt3/local/lib -I/opt/rt3/lib /opt/rt3/sbin/rt-setup-database --action schema --datadir etc --dba RT2 --prompt-for-dba-password Setuid/gid script is writable by world. ...returned with error: 6400 make: *** [initdb] Error 25 any help Shaekir, _ Share photos with friends on Windows Live Messenger http://go.microsoft.com/?linkid=9650734___ 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 Performance - Intermittent slow spells
Hi, We are currently having some intermittent problems where our RT stops responding. I have isolated this I think to a database problem of some sort. I turned on Slow Query logging and this is what MySQL picked up. Any ideas what may cause such performance issues. It is intermittent but very annoying when it does occur. I have tuned the DB with mysqltuner and when it does run proper then it really hums along. # Time: 090317 12:42:29 # u...@host: rt[rt] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600); # u...@host: rt[rt] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600); # u...@host: rt[rt] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 SELECT GET_LOCK('Apache-Session-288c54fb38d789956edc518ca4321abb', 3600); -- Regards Aaron ___ 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] sort by Custom field
I have some users asking to be able to CLICK on the headers in a search. Headers that contain custom fields are not clickable. How can I make them functional and clickable by our users? Matt ___ 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