Re: [rt-users] time ticket creation incorrect
Also found out that after the creation, the 'last updated' time of the ticket in fact is correct. Only the creation time is off. Any idea? -- Jac On Mon, Jan 4, 2010 at 8:38 AM, Jac Gubbels jhj.gubb...@gmail.com wrote: hmmm, but both the server time and 'Select NOW()' give the correct time ... Where else should I be looking? (a mysql forum probably :) ) -- Jac ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] time ticket creation incorrect
Hi, Today I noticed the ticket creation time is between 25 and 28 minutes earlier than the time the ticket actually got created. After submitting a ticket through email the 'last updated' time is correct but the creation time is wrong. Now, given the fact that we are close to half an hour off, I concluded it is not a time zone issue. It is also not the server time, as I checked that that is correct. So my question: Would anybody have an idea on what causes the creation time to end up wrong in the database!? Looking forward to your replies! Jac Gubbels Istanbul, Turkey. Jac ___ 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] Email completion and LDAP authentication
Hi, I am having trouble running two plugins at the same time. Probably i am missing something stupid. Here is a snipped of my RT_SiteConfig.pm. Set(@Plugins,(qw(RTx::EmailCompletion))); Set(@Plugins,(qw(RT::Authen::ExternalAuth))); Now, depending on the order I set the @plugins they work individually but not together. The plugin that gets listed last works. I have recently upgraded to the new LDAP authentication plugin. With the old one things worked together. I have carefully followed the steps in the README of both plugins. Both are the latest versions. I run RT3.8.4 on an ubuntu box. Thanks heaps for any help or pointers. Jac ___ 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] ticket creation from web interface fails
Hi, Upon creation of a ticket through the web interface I get the following error: Undefined subroutine RT::EmailParser::ParseAddressFromHeader called at /opt/rt3/bin/../lib/RT/User_Local.pm line 272. My staff has reported this error recently, but it might be related to an update from 3.8.2 to 3.8.4 as that is the last change that was made to our installation. In the wiki and lists I could only find this error in relation to LDAP authentication. We are in fact authenticating using LDAP (AD). Here is our full setup Apache/2.2.8 (Ubuntu) DAV/2 SVN/1.4.4 PHP/5.2.3-1ubuntu6.5 mod_ssl/2.2.8 OpenSSL/0.9.8g mod_perl/2.0.3 Perl/v5.8.8 Any suggestions as on where to start looking for a fix to this problem? I can see the routine ParseAddressFromHeader does not exist in /opt/rt3/lib/RT/EmailParser.pm. I have installed all perl mail functionality I could find using CPAN. Thanks a lot! -- Jac ___ 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] RTx::EmailCompletion config problems
Hi Aaron, You might need to make symbolic link from RTx-EmailCompletion to EmailCompletion as apparently that is what RT is looking for. in /opt/rt3/local/plugins/ do ln -s EmailCompletion RTx-EmailCompletion Hope that helps -- Jac winmail.dat___ 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] HTML emails
Hi, Taking the risk of this question be posed already: Has 3.8.1 a problem with sending HTML emails? I found something like that in the mailing list archive, but did not know how to value it. Just upgraded from 3.6.4 and all seems to work except the sending of HTML mails. Replying to a ticket from within the RT web interface gives me a message stored with the mark-up in RT, but the user gets a plain text email!? The mail header tells me 'Content-Type: text/plain; charset=utf-8. Is there a quick fix? Something wrong with my mail server settings or just the mentioned issue with 3.8.1? Also, does this perhaps relate to the fact that the FCKeditor is collapsed by default? Thanks for your help! Jac ___ 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] RTx::EmailCompletion config problems
Ok, but the link you need points from RTx-EmailCompletion to EmailCompletion. The EmailCompletion dir is created by the install script, but the link to it has to be made manually as RT is looking for RTx-EmailCompletion directory. The Heritage of earlier versions of this plugin I think. So I think you got my point backwards :-) -- Jac Gubbels PS: I have cc-ed this message (striped of your personal data) to the rt users list. So others can benefit from it as well. Sent: Monday, November 17, 2008 9:47 PM To: Jac Gubbels GUBBELS Subject: Re: [rt-users] RTx::EmailCompletion config problems Thanks for the input but unfortunately not, I checked the plugins directory and in fact the plugin folder is named EmailCompletion already so symbolic link wouldn't work. Alas we are still without email completion. Regards, Aaron Guise ___ 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] plain text emails
Hi, Taking the risk of this question be posed already: Has 3.8.1 a problem with sending HTML emails? I found something like that in the mailing list archive, but did not know how to value it. Just upgraded from 3.6.4 and all seems to work except the sending of HTML mails. Replying to a ticket from within the RT web interface gives me a message stored with the mark-up in RT, but the user gets a plain text email!? The mail header tells me 'Content-Type: text/plain; charset=utf-8. Is there a quick fix? Something wrong with my mail server settings or just the mentioned issue with 3.8.1? Also, does this perhaps relate to the fact that the FCKeditor is collapsed by default? Thanks for your help! Jac ___ 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] character encoding issues after updating
Thanks heaps! I read the README and UPGRADING instructions but somehow missed UPGRADING.mysql. Sorry for bothering you! Keep up the good work! -- Jac -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Mon 10/20/2008 3:46 PM To: Jac Gubbels GUBBELS Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] character encoding issues after updating On Sun 19.Oct'08 at 21:23:27 +0300, Jac Gubbels GUBBELS wrote: Hi, After having successfully implemented version 3.6.4 in our organization, I have started an attempt at updating the installation to 3.8.1. It seems to be successful, however I have one show stopping issue. When I look at the tickets the Turkish characters we use have become corrupted. Here is what I do in terms of upgrading the database: There's an upgrade script one needs to run, documented in the UPGRADING file. It's badly named (etc/schema.mysql-4.0-4.1.pl), but you need it. * I copy the database to a new one using phpmyadmin (I can run the new version now! even without the db update, but with the character issues) * I run the update script over the copy (from the temporary directory that holds the 'upgrade' directory) * I am using the copy for the new installation as I have to keep the original database in one piece, it is live... When I look at the fields in the database I see no differences between the two ('fotokopi(C500) sarı ve mavi toner bitik!' remains 'fotokopi(C500) sarı ve mavi toner bitik!' - apparently we need blue and yellow toner for a printer ;-), so that makes me think something changed somewhere else. 3.6.4 shows this ticket as it should, with a dotless i, 3.8.1 gives 'ı' When I play with the character encoding using my browser I am not able to get things to show up right. Any suggestions would be great. -- Jac Istanbul, Turkey ___ 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] character encoding issues after updating
Hi, After having successfully implemented version 3.6.4 in our organization, I have started an attempt at updating the installation to 3.8.1. It seems to be successful, however I have one show stopping issue. When I look at the tickets the Turkish characters we use have become corrupted. Here is what I do in terms of upgrading the database: * I copy the database to a new one using phpmyadmin (I can run the new version now! even without the db update, but with the character issues) * I run the update script over the copy (from the temporary directory that holds the 'upgrade' directory) * I am using the copy for the new installation as I have to keep the original database in one piece, it is live... When I look at the fields in the database I see no differences between the two ('fotokopi(C500) sarı ve mavi toner bitik!' remains 'fotokopi(C500) sarı ve mavi toner bitik!' - apparently we need blue and yellow toner for a printer ;-), so that makes me think something changed somewhere else. 3.6.4 shows this ticket as it should, with a dotless i, 3.8.1 gives 'ı' When I play with the character encoding using my browser I am not able to get things to show up right. Any suggestions would be great. -- Jac Istanbul, Turkey ___ 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