Re: [rt-users] Cosmetic Issues 3.8 - WYSIWYG, Round corners, FCKeditor not showing
Kevin Falcone wrote: On Nov 12, 2008, at 4:00 PM, Scott Golby wrote: 1. Entering text in the WYSIWYG editor looks fine, I make the font big, change the color to Red - but when you view the ticket history it just shows as all the same size/font, h1 is gone, Red color is gone. (it is there in the Download (untitled) / with headers text/html, so RT did save it) There are fixes for this in 3.8-trunk which will be in 3.8.2 Hi Kevin, I've applied your patch from the 3.8 trunk [http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=16201#diff__rt_3.8_trunk_share_html_Elements_ScrubHTML] , but found it doesn't include H1 - H6 headings. I enclose a diff to add H1 - H6. Best regards, Justin *** ScrubHTML.old 2008-11-26 07:58:58.0 + --- ScrubHTML 2008-11-26 07:41:38.0 + *** *** 64,70 ); $scrubber-deny(qw[*]); $scrubber-allow( ! qw[A B U P BR I HR BR SMALL EM FONT SPAN STRONG SUB SUP STRIKE DIV UL OL LI DL DT DD PRE] ); $scrubber-comment(0); /%ONCE --- 64,70 ); $scrubber-deny(qw[*]); $scrubber-allow( ! qw[A B U P BR I HR BR SMALL EM FONT SPAN STRONG SUB SUP STRIKE H1 H2 H3 H4 H5 H6 DIV UL OL LI DL DT DD PRE] ); $scrubber-comment(0); /%ONCE___ 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] RT at a glance copy to multiple users
Hello! On Di, 2008-11-25 at 15:01 +0100, Bjoern Schulz wrote: is there a way to copy the configuration of RT at a glance from one user to another. I suppose I found the settings in the database, in the table Attributes the records where Name=Pref-HomepageSettings you will find in the column ObjectId the UserId. It should be possible to update or create the column Content to spread the initial Homepage setting of a user. So it should be possible to configure a default portal for each group. regards! sven ___ 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] Add custom fields
Hello, I'm trying to add a custom field in the file Quick Create, but the CF is a combobox which was created in the user interface. Do you know how I could do it?? Thanks a lot! 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: [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] Add custom fields
I have tried the next, but the code is the same that its in the file Create.html td colspan=6 /Ticket/Elements/EditCustomFields, QueueObj = $QueueObj /td /tr % if ($TxnCFs-Count) { % while (my $CF = $TxnCFs-Next()) { tr td align=right% $CF-Name %:/td td /Elements/EditCustomField, CustomField = $CF, NamePrefix = Object-RT::Transaction--CustomField- em% $CF-FriendlyType %/em/$ /td/tr % } % } /tr Thanks! 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Alberto Villanueva Enviado el: miércoles, 26 de noviembre de 2008 10:30 Para: rt-users@lists.bestpractical.com Asunto: [rt-users] Add custom fields Hello, Im trying to add a custom field in the file Quick Create, but the CF is a combobox which was created in the user interface. Do you know how I could do it?? Thanks a lot! 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: [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] Gnupg interaction with speedycgi in RT 3.8.1
On Mon, Nov 24, 2008 at 11:23:55PM +0300, Ruslan Zakirov wrote: On Mon, Nov 24, 2008 at 9:48 PM, Niko Tyni [EMAIL PROTECTED] wrote: On Wed, Nov 19, 2008 at 07:45:35PM +, Dominic Hargreaves wrote: I can easily imagine that gnupg tickles some file descriptor bug somewhere though. Attached is an strace showing the sequence of events in the backend, resulting in the output going to STDERR rather than STDOUT, including an exec of gnupg (note; does this mean that every request will hit exec gpg?) Presumably the backend receiving EPIPE when writing the output is going to be related, but I can't quite follow the strace well enough to see why. If anyone else fancies digging a bit deeper, feel free :) Sounds like Mail::GnuPG 0.15 might fix this. Earlier versions had significant problems in the interaction with the gpg process, including deadlocks and unexpected SIGPIPEs. However Mail::GnuPG is not used in new implementation of RT's gpg interaction, but it's 100% about sig handlers or std{in, out, err}. Right, sorry for my confusion. As penance, I actually looked into this. It's a bug in SpeedyCGI, triggered by the FastCGI filehandle wrapping code in RT::Util::safe_run_child(). See http://bugs.debian.org/506957 for a minimal test script. A workaround would be diff --git a/lib/RT/Util.pm b/lib/RT/Util.pm index 544618b..bf6eb2d 100644 --- a/lib/RT/Util.pm +++ b/lib/RT/Util.pm @@ -56,7 +56,7 @@ our @EXPORT = qw/safe_run_child/; sub safe_run_child () { local @ENV{ 'LANG', 'LC_ALL' } = ( 'C', 'C' ); -return shift-() if $ENV{'MOD_PERL'}; +return shift-() if $ENV{'MOD_PERL'} || $CGI::SpeedyCGI::i_am_speedy; # We need to reopen stdout temporarily, because in FCGI # environment, stdout is tied to FCGI::Stream, and the child which fixes the immediate problem for me. I haven't tested actually using the gpg support with this, though. Dominic, can you do that easily? I should probably mention that I'm the one to blame for keeping SpeedyCGI alive in this context. The project has been inactive since 2003, and I've patched the Debian speedy-cgi-perl package for the Perl 5.10 and Apache 2.2 transitions. I still like the way it gives persistent perl script speedups with minimal or no web server configuration. -- Niko Tyni [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
Re: [rt-users] Cosmetic Issues 3.8 - WYSIWYG, Round corners, FCKeditor not showing
On Nov 26, 2008, at 3:04 AM, [EMAIL PROTECTED] wrote: Kevin Falcone wrote: On Nov 12, 2008, at 4:00 PM, Scott Golby wrote: 1. Entering text in the WYSIWYG editor looks fine, I make the font big, change the color to Red - but when you view the ticket history it just shows as all the same size/font, h1 is gone, Red color is gone. (it is there in the Download (untitled) / with headers text/html, so RT did save it) There are fixes for this in 3.8-trunk which will be in 3.8.2 Hi Kevin, I've applied your patch from the 3.8 trunk [http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=16201#diff__rt_3.8_trunk_share_html_Elements_ScrubHTML ] , but found it doesn't include H1 - H6 headings. I enclose a diff to add H1 - H6. Hi Justin Can you tell me how you were generating the H* from the WYSIWYG so I can confirm before committing? Thanks -kevin *** ScrubHTML.old 2008-11-26 07:58:58.0 + --- ScrubHTML 2008-11-26 07:41:38.0 + *** *** 64,70 ); $scrubber-deny(qw[*]); $scrubber-allow( ! qw[A B U P BR I HR BR SMALL EM FONT SPAN STRONG SUB SUP STRIKE DIV UL OL LI DL DT DD PRE] ); $scrubber-comment(0); /%ONCE --- 64,70 ); $scrubber-deny(qw[*]); $scrubber-allow( ! qw[A B U P BR I HR BR SMALL EM FONT SPAN STRONG SUB SUP STRIKE H1 H2 H3 H4 H5 H6 DIV UL OL LI DL DT DD PRE] ); $scrubber-comment(0); /%ONCE ___ 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] backslash url gives system error
On my production box (3.6.5), the backslash just returns a blank page with Not Found The requested URL /\ was not found on this server. On my dev box (3.8.1) I get the side menu bar, top menu bars, and (in the main content area) The page you requested could not be found Please check the URL and try again. The line in my RT_SiteConfig on both boxes is Set($LogToScreen, undef); I notice that on my 3.6.5 box, the default for $LogToScreen in RT_Config is error while on my 3.8.1 it is info. Sorry I can't provide more help. Do you have a vanilla test box to try this on? Karl Boyken wrote: Interesting--it does not work. I tried setting $LogToScreen to undef, 'emergency', and 0, but the error still displays on the screen. (I'm cleaning out the mason cache and restarting httpd.) Karl Boyken Drew Barnes wrote: $LogToScreen in RT_SiteConfig Fix has existed as long as I have administered RT (3.2) Karl Boyken wrote: When a backslash is appended to the url for our RT 3.6.7 site (running with Perl 5.10.0), RT tosses a system error, which exposes information about where we've installed Perl and RT and their versions. Is this fixed in 3.8.X? If not, is a fix forthcoming? Thanks Here's the error, with paths changed: System error error: could not find component for initial path '/\' (component roots are: '/path_to_rt/local/html', '/path_to_rt/share/html') context: ... 207: $self-{out_method} = sub { $$bufref .= $_[0] }; 208: } 209: $self-{use_internal_component_caches} = 210: $self-{interp}-use_internal_component_caches; 211: $self-_initialize; 212: 213: return $self; 214: } 215: ... code stack: /path_to_perl/lib/site_perl/5.10.0/HTML/Mason/Request.pm:211 /path_to_perl/lib/site_perl/5.10.0/Class/Container.pm:275 /path_to_perl/lib/site_perl/5.10.0/Class/Container.pm:353 /path_to_perl/lib/site_perl/5.10.0/HTML/Mason/Interp.pm:348 /path_to_perl/lib/site_perl/5.10.0/HTML/Mason/Interp.pm:342 /path_to_perl/lib/site_perl/5.10.0/HTML/Mason/CGIHandler.pm:121 /path_to_perl/lib/site_perl/5.10.0/HTML/Mason/CGIHandler.pm:73 /path_to_rt/bin/mason_handler.fcgi:78 raw error Karl Boyken ___ 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 -- 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Including RTFM articles in RT replies when WYSIWYG editor enabled
I have a slight problem including RTFM articles in a ticket reply when WYSIWYG editor is enabled. Everything looks like and it adds the text to the reply, but when it sends it truncates the text, sends a partial email and records the corrupt message. There are also spaces inserted midway into words in the reply. It does this consistently every time, so if the same RTFM article is included it puts the spaces in the same place and truncates the end of the message at the same place too. If the WYSIWYG editor is disabled, then it includes the text verbatim and doesn't truncate the message. This is version RT 3.8.1 and RTFM 2.4.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
Re: [rt-users] Forking a ticket
-Original Message- From: Joop [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 5:14 AM To: Roedel, Mark Cc: RT Users Subject: Re: [rt-users] Forking a ticket If this is still on anybody's radar, I've finally gotten around to packaging the callbacks and related pages referred to below into a plugin for RT 3.8.x, and it's currently available for download from Thanks, I just tried it and it works for me. One little thing though: in the README you say: 'and add an entry for RT::Plugin::ForkTicket to the @Plugins array'. I had to change that to: 'and add an entry for RT::Extension::ForkTicket to the @Plugins array', otherwise Apache won't restart. Oops -- nice catch. I've corrected that in the download package. Thanks, Joop! -- Mark Roedel Senior Programmer/Analyst - Web Services LeTourneau University ___ 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] Notify Owner on Steal
Hi, I have been away from the lists for a few years. I just got RT 3.8.1 up and running, and we are switching over from 1.0.7 (!). I miss a function from 1.0.7 where, when a ticket was stolen, the old owner would get an email. I found the archive here: http://www.gossamer-threads.com/lists/rt/users/79968?do=post_view_flat#79968 Without reposting the whole thing, that seems to bring up the issue, but I don't see an actual fix in there. I also looked through the wiki, but again I didn't find my fix. Assuming a ticket is owned by somebody (not Nobody), when I 'steal' the ticket from them and reassign it, the notification only goes to the new owner, not the old owner. Admittedly I'm new to scrips but I don't see how to add this function. We are still in late 'setup and testing' mode on the new RT, so any advice or maybe a config setting I missed will be accepted humbly. I am running RT 3.8.1 on Mac OS X 10.4. Thanks to everyone who has helped maintain RT over the years! Thanks, -Derek ___ 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] Self Service - missing ticket description box
Hi, I have a customer with IE6 and tries to open a ticket using self service. he gets the new ticket page but the description box where the user needs to write the ticket description is missing. any ideas? ___ 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] Search for Requestor when opening a new ticket
I'm evaluating rt3 to replace our current helpdesk software. So far I like everything I see, but I have one question. We still have a lot of our end-users call into our department to enter a help call. Since there are over 600 of them, we don't have all their email addresses memorized and they aren't the easiest things to type (just take a look at mine). What I would like to know is, when I click on new ticket in and I have the requestor field, is there a way to search based on their real name and have that be input into the requestor field? Or is there another way to search for the requestor and then start a new ticket from that point. Thanks in advance! Troy Brown IT Manager Shawnee Library System 618-985-3711 x2021 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Shawnee is one of nine multitype Library Systems cooperating to provide vital services to the citizens of Illinois. ___ 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] Search for Requestor when opening a new ticket
You could probably work something up with RTx::EmailCompletion http://search.cpan.org/~nchuche/RTx-EmailCompletion-0.05/lib/RTx/EmailCompletion.pm -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] Forward function in 3.8.1
I think ForwardFromUser config option might help. If it's not then I don't get what exactly you want. On Wed, Nov 26, 2008 at 8:56 AM, Carolyn Fairman [EMAIL PROTECTED] wrote: I'm fresh from a successful upgrade to 3.8.1. One thing users asked for was to be able to forward out of RT. When I forward out of RT I get an email with things like this: This is forward of transaction #66135 of a ticket #4081 Then a mime-attachment.eml So this wasn't the expected behavior. Users wanted, well, an *email* that looked just like the process when they use reply, but now 'From' their email to someone else so they can fob off the ticket/email/issue to someone outside the RT system (like management...). Anyone have a way to make Forward work like this? Carolyn ___ 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 -- 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] Cannot Resolve and Delete from Queue
Everyone We have 3 different queues setup in our RT environment. Each queue receives emails from a mailbox we have setup and imports that email into RT. We can Take and Assign ownership to all queues. But we have one queue that will not allow us to change the status of a ticket to Resolved or Deleted. The others work fine. It is just this one queue. We have gone through and checked permissions and it is nothing we can find there. Any of you experienced this before? Thanks in advance. Thanks H. David Anderson IV ___ 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] Forward function in 3.8.1
On Wed, Nov 26, 2008 at 13:13, Ruslan Zakirov [EMAIL PROTECTED] wrote: On Wed, Nov 26, 2008 at 8:56 AM, Carolyn Fairman [EMAIL PROTECTED] wrote: This is forward of transaction #66135 of a ticket #4081 Then a mime-attachment.eml I think ForwardFromUser config option might help. If it's not then I don't get what exactly you want. The complaint seems to be about the attachment. More specifically, I imagine it's Content-Type: message/rfc822 Alas many MUAs don't handle this properly (including gmail). -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] Migrating RT Ticket data only to new RT installation
Hello Cassandra, I am facing a similar situation and the solution I came up with was to identify the changes in the database specifically and use the RT2-to-RT3 migration script to back out the changes on the fly. In our instance priority was set to a word rather than a numeric value. So after digging I found the section of the rt2dumpfile code which deals with that and had it translate the name back to a value. The code changes made internally are being left behind so that we can go to a clean code base and if any changes need to be made we follow the overlay guidelines to make sure they do not halt us from future upgrades. Not sure if this type of solution will work for you but wanted to make sure someone answered your question. - Brian On Mon, Nov 24, 2008 at 4:53 PM, Cassandra L. Brockett [EMAIL PROTECTED] wrote: So, I'm left with a legacy RT installation that has been horribly mangled by way too many sysadmins who did not truly understand how to configure RT, or at least know enough to not play with the production ticketing system :-) My problem is, they have done database and other modifications from the defaults, therefore I can't really trust any data other than the ticket history itself, and I'd like to retain the ticket history... Has anyone done this before, and can suggest any paths to try? I know this isn't a supported option with RT, but I don't believe anyone intended you to just randomly try weird settings or changes on the production system... Regards, Cassandra Brockett Barracuda Networks, Inc. -- Barracuda Networks makes the best spam firewalls and web filters. www.barracudanetworks.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] Cosmetic Issues 3.8 - WYSIWYG, Round corners, FCKeditor not showing
Kevin Falcone wrote: On Nov 26, 2008, at 3:04 AM, [EMAIL PROTECTED] wrote: Kevin Falcone wrote: On Nov 12, 2008, at 4:00 PM, Scott Golby wrote: 1. Entering text in the WYSIWYG editor looks fine, I make the font big, change the color to Red - but when you view the ticket history it just shows as all the same size/font, h1 is gone, Red color is gone. (it is there in the Download (untitled) / with headers text/html, so RT did save it) There are fixes for this in 3.8-trunk which will be in 3.8.2 Hi Kevin, I've applied your patch from the 3.8 trunk [http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=16201#diff__rt_3.8_trunk_share_html_Elements_ScrubHTML ] , but found it doesn't include H1 - H6 headings. I enclose a diff to add H1 - H6. Hi Justin Can you tell me how you were generating the H* from the WYSIWYG so I can confirm before committing? Thanks -kevin Hi Kevin, Thanks for the reply. We're using the 'Format' drop down box in FCKeditor. Included in the options are 'Heading 1' through to 'Heading 6'. Best regards, Justin University of Brighton. ___ 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] RT3 Access Denied DB Error on Install
Hi, I'm working on installing Request Tracker 3.8.1 in order to test it out for our department, however I am running into an error that I've been unable to find a solution to. I have tried the wiki, etc with no success. I have a fresh Debian Etch install. I've ran make fixdeps and have all of the perl modules installed and make testdeps reports complete success. However, on make initialize-database after setting up my custom configuration in RT_SiteConfig.pm, I receive the following error: [EMAIL PROTECTED]:~/rt-3.8.1# make initialize-database /usr/bin/perl sbin/rt-setup-database --action init --dba root --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Name: rt3 User: rt_user DBA:root Now creating a mysql database rt3 for RT. Done. Now populating database schema. Done. Now inserting database ACLs Granting access to rt_user@'localhost' on rt3. Done. DBI connect('dbname=rt3;host=localhost;port=3306','rt_user',...) failed: Access denied for user 'rt_user'@'localhost' (using password: YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106 Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) at /home/kmcdermo/rt-3.8.1/sbin/../lib/RT.pm line 204 make: *** [initialize-database] Error 255 Below are the database settings I have setup (with passwords heavily altered) in my RT_SiteConfig.pm. I have other settings custom-configured as well: #db type Set( $DatabaseType, 'mysql'); #DB Connection stuff Set( $DatabaseHost, 'localhost'); Set( $DatabaseRTHost, 'localhost'); Set( $DatabasePort, '3306'); Set( $DatabaseUser, 'rt_user'); Set( $DatabasePassword, 'rt_password'); Set( $DatabaseName, 'rt3'); Does anyone have any insite into something that I could try to get this up and working? Looks like a good system and am anxious to give it a try. -- Keith McDermott Desktop Support Specialist - PCN Physics Department, Purdue University Web:http://www.physics.purdue.edu/pcn E-mail: [EMAIL PROTECTED] Phone: (765)496-2202 Address:525 Northwestern Avenue West Lafayette, IN 47907 Check out our new documentation at: http://www.physics.purdue.edu/PCN/doc/wiki ___ 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] import users using csv file
Is it possible to import our user information from our current helpdesk software over to RT? I can get the required fields into a CSV no problem, but it importing them directly into the 'Users' all that needs to happen? Troy Brown IT Manager Shawnee Library System 618-985-3711 x2021 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Shawnee is one of nine multitype Library Systems cooperating to provide vital services to the citizens of Illinois. ___ 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] import users using csv file
On Wed, Nov 26, 2008 at 15:05, Troy Brown [EMAIL PROTECTED] wrote: but it importing them directly into the 'Users' all that needs to happen? No, I don't think so. I'm pretty sure Principals is involved too. However, you should be able to script the rt CLI around the CSV pretty easily. -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] import users using csv file
I'm brand new to RT if you could point me in the direction of the command to use. Troy -Original Message- From: Jerrad Pierce [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 2:11 PM To: Troy Brown Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] import users using csv file On Wed, Nov 26, 2008 at 15:05, Troy Brown [EMAIL PROTECTED] wrote: but it importing them directly into the 'Users' all that needs to happen? No, I don't think so. I'm pretty sure Principals is involved too. However, you should be able to script the rt CLI around the CSV pretty easily. -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] import users using csv file
On Wed, Nov 26, 2008 at 15:25, Troy Brown [EMAIL PROTECTED] wrote: I'm brand new to RT if you could point me in the direction of the command to use. As indicated previously, the command is rt. % /opt/rt3/bin/rt help -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] Forward function in 3.8.1
Yes, that's the issue. The email content itself is often (for most mail readers staff here use) just an attachment. In some webmail clients it is ok but not in Apple Mail or Thunderbird (Windows). Carolyn (We're still undecided about the setting for ForwardFromUser actually) On Nov 26, 2008, at 10:39 AM, Jerrad Pierce wrote: On Wed, Nov 26, 2008 at 13:13, Ruslan Zakirov [EMAIL PROTECTED] wrote: On Wed, Nov 26, 2008 at 8:56 AM, Carolyn Fairman [EMAIL PROTECTED] wrote: This is forward of transaction #66135 of a ticket #4081 Then a mime-attachment.eml I think ForwardFromUser config option might help. If it's not then I don't get what exactly you want. The complaint seems to be about the attachment. More specifically, I imagine it's Content-Type: message/rfc822 Alas many MUAs don't handle this properly (including gmail). -- Cambridge Energy Alliance: Save money. Save the planet. __ Carolyn Fairman Education Program for Gifted Youth 650.614.2456 [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
[rt-users] RT emails - Being sent from RT not Some User via RT anymore
Hey, We recently upgraded from Exchange 2003 to Exchange 2007. After we did the upgrade we noticed that responses to tickets are getting sent from RT instead of Some User via RT. It worked perfectly fine in Exchange 2003, but Exchange 2007 changed something. It's basically this: User1 (Ticket owner) User2 (Ticket requester) User2 replies to the ticket. User1 gets an email with correspondence from User2 that comes from RT instead of User2 via RT. I don't think anything was changed in the config for RT, so I would think it would be some sort of Exchange thing, but I'm not too certain. Anyone else ran into this issue before? Some setting that needs to get changed? Any help is appreciated. Thanks, Jared _ Access your email online and on the go with Windows Live Hotmail. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_access_112008___ 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] ModifySelf can modify what things?
In our RT Privileged users have rights to ModifySelf via System groups permission for Privileged.When a user goes to Preferences - About me they can change everything on this page except for Organization, which is blank. Can I set this globally and if not, how can I let users edit this? I've set Set($Organization , Organization Name); But that doesn't populate the field. (Actually I have no idea what this does but it sounded useful to set.) Is this something only the Admin users can do? Since users can change everything else about that page, it is confusing that this one field is immutable. Carolyn ___ 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] Search for Requestor when opening a new ticket
See also http://wiki.bestpractical.com/view/SelectRequestor -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] subject obfuscation problem in 3.8.1
Hello, Occasionally, the subjects on our messages become rather... repetitive. Anyone know what might be causing it, and how to fix it? Initial Subject: River City Condos/Kim Br/10 Rodgers street, [CEA Residences #931] Becomes: River City Condos/Kim B/10 Rodgers street, [CEA Residences #931] [Comment] River City Condos/Kim B/10 Rodgers street, [CEA Residences #931] Via transaction with subject of: RE: [Comment] River City Condos/Kim B/10 Rodgers street, [CEA Residences #931] -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] backslash url gives system error
On Wed 26.Nov'08 at 9:00:15 -0500, Drew Barnes wrote: On my production box (3.6.5), the backslash just returns a blank page with Not Found The requested URL /\ was not found on this server. That's because you have apache matching specific files rather than everything under / pgpu9YIOVrT0y.pgp Description: 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] import users using csv file
And a 3rd and final option, if someone still has a copy (the Internet Archive doesn't) from wiki Contributions page rt-batch-add-usershttp://mimosaid.007sites.com/rt-batch-add-users.txt - command line tool to add a batch of RT users based on data of a csv file. Sorry for the multiple messages. I keep discovering alternatives as I review my own local customization TODO list. -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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