Re: [rt-users] External Auth on Server with Multiple Instances
Helmuth Ramirez wrote: Ok, I got it working. I don't know if it's the right way, but its working. I just copied files from my existing installation into my new one. Specifically: /opt/rt3/local/plugins/RT-Authen-ExternalAuth /opt/rt3/local/lib/RT/Authen/ExternalAuth.pm /opt/rt3/local/man/auto/RT/Authen/ExternalAuth /opt/rt3/local/man/auto/RT/Authen/ExternalAuth/.packlist /opt/rt3/local/man/man3/RT::Authen::ExternalAuth.3pm To respective location in new tree Yes, that's right. ExternalAuth isn't installed into a system.. it's installed into an RT installation. -- Kind Regards, __ Mike Peachey, IT Tel: +44 114 281 2655 Fax: +44 114 281 2951 Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK Comp Reg No: 3191371 - Registered In England http://www.jennic.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] Rt3.8 package for debian
Hi Johan, Could you please let me know what request of my request-tracker3.8 package you've installed? libemail-address-perl is on the dependency list at the moment, but there was a missing comma that might have caused issues. I've added libgraphviz-perl, thanks! Cheers! On Mon, 2008-08-18 at 10:03 +0300, johan baarman wrote: Hi Andrew, Yes, I found your instructions later while browsing the email-archive. Since this is a fresh install I went ahead and upgraded to lenny at the same time. It worked like a charm except when initializing the database. It was complaining that Can't locate Email/Address.pm in @INC... I figured it was missing package libemail-address-perl and after starting RT there were also an error about missing Graphviz so I also had to install package libgraphviz-perl. It's running fine now, thanks to your package. Br, Johan -- Andrew Ruthven Wellington, New Zealand At home: [EMAIL PROTECTED] | This space intentionally |left blank. signature.asc Description: This is a digitally signed message part ___ 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] Rt3.8 package for debian
On Wed, 2008-08-20 at 12:04 +1000, Trent W. Buck wrote: Andrew Ruthven [EMAIL PROTECTED] writes: I've built some RT 3.8.1rc5 packages which I've been using on Lenny. deb http://debian.etc.gen.nz lenny rt There is a missing Recommends for libgraphviz-perl. Rats, so it is. I add the build-deps line, but not the dependency. Fixed. And I've updated the Lenny version to 3.8.1. Also, I'd appreciate copies of the .dsc and .diff.gz. Sure. My repository management software doesn't handle source at the moment. I'll email them privately. I'm storing my build tree in a git repo at: http://git.catalyst.net.nz/gw?p=request-tracker.git;a=summary You can check it out using: git clone git://git.catalyst.net.nz/request-tracker.git Cheers! -- Andrew Ruthven Wellington, New Zealand At home: [EMAIL PROTECTED] | This space intentionally |left blank. signature.asc Description: This is a digitally signed message part ___ 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] Problem upgrading from 3.6.1 to 3.8.1
ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL DEFAULT NULL; I don't see anything wrong with that line. Panu - Don't know about your other problem, but I ran into this SQL burp in four or five different tables while going from 3.6.0 to 3.8.1rc5. MySQL doesn't like the CHARACTER SET directive for a field of type BLOB. These lines should probably be changed to specify TEXT instead of BLOB (or you could remove the 'CHARACTER SET utf8' directive if you know the fields in question are used to store binary data instead of text.) Looking at my database, Templates.Content is definitely TEXT. Oh, and one other thing to watch out for -- the sql.queries file that I got out of running etc/upgrade/schema.mysql-4.0-4.1.pl contained some destructive transforms that I had to change. Several multi-character fields were temporarily transformed into type CHAR, which truncated them to a single character. Check your sql.queries file (e.g. 'grep CHAR sql.queries) and make sure you're not hitting the same thing; in my case, one of the fields that was thus truncated was in fact this same Templates.Content field. RT's templates don't work so good when they consist of only one character. :-) Ole, thanks a lot, I should have paid more attention to that. I for some reason mixed up TEXT and CHAR. As the fields the queries wanted to convert to blob were already blob I just deleted those rows and I now have probably? a properly upgraded DB. (yes I restored an old dump first :) I still have various problems, the cleanslate problem still appear in the logs with various pages. For example: Can't locate object method CleanSlate via package RT::Action::SendEmail at /opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer: http://xxx.yyy.com/Search/Simple.html I also get internal server error with simple search. And for example homepage has: RT::Ticket::ACLEquivalenceObjects Unimplemented in RT::Principal. (/opt/rt38/bin/../lib/RT/Principal_Overlay.pm line 327) and I can't see any of my tickets. Same kind of error appears on almost all pages. ___ 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] ORA-12154: TNS:could not resolve the connect identifier specified
Hi... I am new to this list so please apologize if I do not know yet the etiquette in her and if the error I get confused with is a trivial one. I am a Perl devloper but Oracle is rather new to me. My job is to move an RT 3.6.5 to an RT 3.8.0. The OS is RHEL5. The database system is an remote Oracle server. So far so good. I installed the Oracle client along with RT and always get the error mentioned above. in $ORACLE_HOME/network/admin there reside the following .ora files: ldap.ora, sqlnet.ora and tnsnames.ora ( I can send them if needed, just don't wanted to send a huge bunch of files). All perl modules seem to be installed. Can anybody give me a hint on where to look for a solution? DBD::Oracle: 1.22 DBI: 1.607 rt-3.8.0 Oracle: 10.2.0 -- Mit freundlichen Grüßen Michael Burghart CAT Service Center AUDI AG, I/ET-83 extern Tel: +49 841 89 - 39819 http://catsc-web.in.audi.vwg mailto:[EMAIL PROTECTED] EPOS CAT GmbH Tel: +49 841 88197070 Fax: +49 841 88197080 http://www.epos-cat.de/ mailto:[EMAIL PROTECTED] Sitz/Domicile: Ingolstadt Registergericht/Court of Registry: Amtsgericht Ingolstadt HRB Nr./Commercial Register No.: 2802 Geschäftsführer/Managing Director: Günter See Wichtiger Hinweis: Die vorgenannten Angaben werden jeder E-Mail automatisch hinzugefügt und lassen keine Rückschlüsse auf den Rechtscharakter der E-Mail zu. Important Notice: The above information is automatically added to this e-mail. This addition does not constitute a representation that the content of this e-mail is legally relevant and/or is intended to be legally binding upon EPOS CAT GmbH. ___ 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 3.8.x port for FreeBSD?
Le 19/08/2008 à 18:08:44-0400, Tom Uffner a écrit Is there a FreeBSD port for RT 3.8.x in the works? and if so, about how soon will it be ready? http://lists.freebsd.org/pipermail/freebsd-ports/2008-August/050271.html Regards. -- Albert SHIH SIO batiment 15 Observatoire de Paris Meudon 5 Place Jules Janssen 92195 Meudon Cedex Heure local/Local time: Mer 20 aoû 2008 12:55:53 CEST ___ 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] Move RT instance to new server
Tom, That sounds like what I did when I had to move my RT instance. Don't forget your aliases file :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Smith Sent: Tuesday, August 19, 2008 5:09 PM To: rt-users Subject: [rt-users] Move RT instance to new server Hi, I need to move an RT 3.6.6 install from one server to another. I've been looking for instructions for doing this but haven't been abel to locate any. Without any documentation, the migration path that I've worked out is this... - Install RT 3.6.6 on the new server. - Copy RT_SiteConfig.pm and any other customizations (such as those in /opt/rt3/local) to the new server. - Dump and restore the MySQL database to the new server. Can anyone offer any input on this? Am I missing anything? Anything else that I should consider prior to moving RT over? Thanks in advance for your help! ~ Tom ___ 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] ORA-12154: TNS:could not resolve the connect identifier specified
On Wed, 20 Aug 2008 05:58:24 -0400, Burghart, Michael (I/ET-83, extern) [EMAIL PROTECTED] wrote: Hi... I am new to this list so please apologize if I do not know yet the etiquette in her and if the error I get confused with is a trivial one. I am a Perl devloper but Oracle is rather new to me. My job is to move an RT 3.6.5 to an RT 3.8.0. The OS is RHEL5. The database system is an remote Oracle server. So far so good. I installed the Oracle client along with RT and always get the error mentioned above. in $ORACLE_HOME/network/admin there reside the following .ora files: ldap.ora, sqlnet.ora and tnsnames.ora ( I can send them if needed, just don't wanted to send a huge bunch of files). All perl modules seem to be installed. Can anybody give me a hint on where to look for a solution? Michael, This is an Oracle config problem, so it's beyond the scope of the list. Having said that, the problem appears to be that the Oracle client isn't configured correctly and it can't locate your remote database. The oerr utility gives this info for the error code you see: % oerr ora 12154 12154, 0, TNS:could not resolve service name // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager. I'd enlist the help of your DBA to get you past this problem... Steve ___ 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] First login not working
Hi, Looking to log into RT for the very first time. I entered root and 'password' for the user details and it returns 'Your username or password is incorrect'. During the install I did have issues with the init of the database. During the make initialize db I got this error. I ran this from the source directory. ./sbin/rt-setup-database --action init --dba rtuser --prompt-for-dba- password In order to create or update your RT database, this script needs to connect to your Pg instance on localhost as rtuser Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: Pg Host: localhost Name: rt3 User: rtuser DBA:rtuser Now creating a Pg database rt3 for RT. Done. Now populating database schema. Done. Now inserting database ACLs Couldn't finish 'acl' step. ERROR: Couldn't run SQL query: GRANT USAGE, SELECT, UPDATE ON attachments_id_seq TO rtuser; ERROR: ERROR: invalid privilege type USAGE for table The rtuser should be able to do everything. It does create the database. It is owned by rtuser. So that seems to be pretty much good to go. But setting the permissions seems to fail. I'm installing rt 3.8.0 I'm using postgres 8.1.11 Any ideas here? Thanks, Charlie ___ 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-mailgate] --action comment not commenting
Hi all, I am running RT 3.6.3 using fetchmail to retrieve messages from our mail server. I have two email addresses setup to receive mail, [EMAIL PROTECTED] and [EMAIL PROTECTED] Within the fetchmail config file [EMAIL PROTECTED] correctly uses '--action correspond' to make a ticket within RT. However, when sending mail to [EMAIL PROTECTED] it doesn't seem to correctly use the '--action comment' to comment on tickets, rather it never comments and only corresponds, creating new tickets. Though rt-mailgate shows this: =item Action The action being performed. At the moment, it's one of comment or correspond I've isolated it to rt-mailgate, ruling out the mail server and fetchmail. Any ideas? Thanks, -Tyler -- Tyler Knappe | IT Assistant | VisionLink | First National Center | 3101 Iris Avenue, Suite 240 | Boulder CO, 80301 | 303.402.0170 ext. 124 ___ 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] Able to login with fake password
I did as you suggested and that resolved the problem. Thanks for the help. From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 1:24 PM To: Percynski, Fred Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Able to login with fake password On Aug 18, 2008, at 3:51 PM, Percynski, Fred wrote: The last changes I was making was to get external authentication to Active Directory working.I tried installing RT::Authen::ExternalAuth but it never finished successfully. I did install Bundle::Net::LDAP sucessfully. It looks like RT::Authen::ExternalAuth left things lying around which are messing with RT's authentication process. I'd recommend fully removing the files it installed and seeing how things look then. In particular, I'd remove things from /opt/rt3/local -j From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 1:59 PM To: Percynski, Fred Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Able to login with fake password On Aug 18, 2008, at 1:40 PM, Percynski, Fred wrote: error: Can't use an undefined value as an ARRAY reference at /opt/rt3/local/lib/RT/User_Vendor.pm line 56. Fred, Looks like you've installed a custom RT extension. What did you install? - The information contained in this message is privileged and confidential. It is intended only for the recipient or entity listed above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by replying to the message and promptly deleting it from your computer. Thank you. Health Data Management Solutions. ___ 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 - The information contained in this message is privileged and confidential. It is intended only for the recipient or entity listed above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by replying to the message and promptly deleting it from your computer. Thank you. Health Data Management Solutions.___ 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] Move RT instance to new server
If I go through the standard RT installation, including the db initialization, will I still need to follow the steps in UPGRADING? ~ Tom On Aug 19, 2008, at 3:17 PM, Joachim Thuau wrote: The schema of the db also needs to be upgraded. It should be documented in the UPGRADING file. Jok - Original Message - From: [EMAIL PROTECTED] rt-users- [EMAIL PROTECTED] To: rt-users rt-users@lists.bestpractical.com Sent: Tue Aug 19 14:08:55 2008 Subject: [rt-users] Move RT instance to new server Hi, I need to move an RT 3.6.6 install from one server to another. I've been looking for instructions for doing this but haven't been abel to locate any. Without any documentation, the migration path that I've worked out is this... - Install RT 3.6.6 on the new server. - Copy RT_SiteConfig.pm and any other customizations (such as those in /opt/rt3/local) to the new server. - Dump and restore the MySQL database to the new server. Can anyone offer any input on this? Am I missing anything? Anything else that I should consider prior to moving RT over? Thanks in advance for your help! ~ Tom ___ 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] Move RT instance to new server
According to your e-mail though you're doing a lateral migration 3.6.6 to 3.6.6. You wouldn't need to do anything other than restore the db. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Smith Sent: Wednesday, August 20, 2008 10:58 AM To: Joachim Thuau Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Move RT instance to new server If I go through the standard RT installation, including the db initialization, will I still need to follow the steps in UPGRADING? ~ Tom On Aug 19, 2008, at 3:17 PM, Joachim Thuau wrote: The schema of the db also needs to be upgraded. It should be documented in the UPGRADING file. Jok - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: rt-users rt-users@lists.bestpractical.com Sent: Tue Aug 19 14:08:55 2008 Subject: [rt-users] Move RT instance to new server Hi, I need to move an RT 3.6.6 install from one server to another. I've been looking for instructions for doing this but haven't been abel to locate any. Without any documentation, the migration path that I've worked out is this... - Install RT 3.6.6 on the new server. - Copy RT_SiteConfig.pm and any other customizations (such as those in /opt/rt3/local) to the new server. - Dump and restore the MySQL database to the new server. Can anyone offer any input on this? Am I missing anything? Anything else that I should consider prior to moving RT over? Thanks in advance for your help! ~ Tom ___ 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] Issue with iso/utf in 3.8.1?
Hello, Has anyone else had problems with special character after upgrading to rt 3.8.1? The nordic letters æøå is now missrepresented in both user-realname and case texts. It looks like some iso-8859-x - utf-8 problems, but I can't seem to find any settings related to this in the configuration files. -geir -- **--**--**--**--**--**--**--**--**--**--**--**--**--**-- Geir Skjotskift, mnemonic ASEmail : [EMAIL PROTECTED] Wergelandsveien 25 Cell : +47 95 10 51 09 N-0167 Oslo, NORWAY Fax : +47 23 20 47 01 Key A2360FF3 availiable at subkeys.pgp.net pgpibtUGx1an4.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] Issue with iso/utf in 3.8.1?
On Wed, Aug 20, 2008 at 04:54:11PM +0200, Geir Skjotskift wrote: Hello, Has anyone else had problems with special character after upgrading to rt 3.8.1? The nordic letters æøå is now missrepresented in both user-realname and case texts. It looks like some iso-8859-x - utf-8 problems, but I can't seem to find any settings related to this in the configuration files. You're using mysql, right? Did you run the schema.mysql-4.0-4.1 upgrade ? ___ 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] Issue with iso/utf in 3.8.1?
Emmanuel Lacour wrote: You're using mysql, right? Did you run the schema.mysql-4.0-4.1 upgrade ? using mysql yes. I ran the /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade and specified 3.8.0 as upgrade from and it said no database updates from 3.8.0 I did the upgrade from 3.6.1 - 3.8.0 three days ago, and did the same thing. It made (apparently) a lot of changes to the db at that run. -geir -- **--**--**--**--**--**--**--**--**--**--**--**--**--**-- Geir Skjotskift, mnemonic ASEmail : [EMAIL PROTECTED] Wergelandsveien 25 Cell : +47 95 10 51 09 N-0167 Oslo, NORWAY Fax : +47 23 20 47 01 Key A2360FF3 availiable at subkeys.pgp.net pgpN6bkqiovPd.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] Issue with iso/utf in 3.8.1?
On Wed, Aug 20, 2008 at 05:20:44PM +0200, Geir Skjotskift wrote: Emmanuel Lacour wrote: You're using mysql, right? Did you run the schema.mysql-4.0-4.1 upgrade ? using mysql yes. I ran the /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade and specified 3.8.0 as upgrade from and it said no database updates from 3.8.0 I did the upgrade from 3.6.1 - 3.8.0 three days ago, and did the same thing. It made (apparently) a lot of changes to the db at that run. You forgot to read UPGRADING.mysql. It will tell you to upgrade format of DB fields as now RT uses full UTF-8 colation. Just run the steps related to schema.mysql-4.0-4.1 (make a backup before!) and you're non ascii chars will be back :) ___ 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] delivery to RT queue returning EX_TEMPFAIL but not debug logs or anything useful
Tom H wrote: Hi RT list, According to the rt-mailgate script, there should be something for this; warn $content if ($opts{debug}); and according to perldoc warnings, the function warn should send the content to STDERR... So I've no idea where that information is going So further digging reveals this possibility; http://docs.hp.com/en/B2355-90685/ch04s03.html#ccicedga If stdout and stderr are not redirected, they are not printed to the terminal, and they disappear. However, if a command returns a non-zero exit status, its output to stderr becomes part of the sendmail error transcript. And the message that is sent back through the relay is; # #4.4.7 X-Unix; 75 #SMTP# So rt-mailgate is sending back exit status 75, its just doesn't look like its sending the STDERR, which should at least include stuff like; warn Connecting to $full_url if $opts{'debug'}; So I'm still losing my rt-mailgate STDERR Tom ___ 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] Problem upgrading from 3.6.1 to 3.8.1
Forwarded to rt3.fsck.com where it's now #12278. Will be fixed in 3.8.2 On Wed, Aug 20, 2008 at 3:24 AM, Ole Craig [EMAIL PROTECTED] wrote: On Tue, 2008-08-19 at 17:29 +0200, [EMAIL PROTECTED] wrote: ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL DEFAULT NULL; I don't see anything wrong with that line. Panu - Don't know about your other problem, but I ran into this SQL burp in four or five different tables while going from 3.6.0 to 3.8.1rc5. MySQL doesn't like the CHARACTER SET directive for a field of type BLOB. These lines should probably be changed to specify TEXT instead of BLOB (or you could remove the 'CHARACTER SET utf8' directive if you know the fields in question are used to store binary data instead of text.) Looking at my database, Templates.Content is definitely TEXT. Oh, and one other thing to watch out for -- the sql.queries file that I got out of running etc/upgrade/schema.mysql-4.0-4.1.pl contained some destructive transforms that I had to change. Several multi-character fields were temporarily transformed into type CHAR, which truncated them to a single character. Check your sql.queries file (e.g. 'grep CHAR sql.queries) and make sure you're not hitting the same thing; in my case, one of the fields that was thus truncated was in fact this same Templates.Content field. RT's templates don't work so good when they consist of only one character. :-) (And of course, you should reload the pristine 3.6.1 database snapshot and start all over again after editing the sql.queries file. But you knew that. :-) Cheers, Ole - /Ole Craig Security Engineer Team lead, customer support [EMAIL PROTECTED] 303-381-3802 main support line 303-381-3824 my voicemail 303-381-3880 fax www.stillsecure.com On Tue, 2008-08-19 at 17:29 +0200, [EMAIL PROTECTED] wrote: ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL DEFAULT NULL; I don't see anything wrong with that line. ___ 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
Re: [rt-users] delivery to RT queue returning EX_TEMPFAIL but not debug logs or anything useful
On Wed, Aug 20, 2008 at 04:29:55PM +0100, Tom H wrote: warn $content if ($opts{debug}); and according to perldoc warnings, the function warn should send the content to STDERR... So I've no idea where that information is going Any ideas? Try to log the error to a file by modifying a little bit rt-mailgate. Look in you're apache and rt error logs, if rt-mailgate cannot submit, there should be an error there. Try to get the source email which causes problem and to pipe it manually to the same rt-mailgate command and the same user as sendmail does. ___ 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] Problem upgrading from 3.6.1 to 3.8.1
Apache+mod_perl with two RTs in different virtual hosts? On Wed, Aug 20, 2008 at 2:03 PM, [EMAIL PROTECTED] wrote: ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL DEFAULT NULL; I don't see anything wrong with that line. Panu - Don't know about your other problem, but I ran into this SQL burp in four or five different tables while going from 3.6.0 to 3.8.1rc5. MySQL doesn't like the CHARACTER SET directive for a field of type BLOB. These lines should probably be changed to specify TEXT instead of BLOB (or you could remove the 'CHARACTER SET utf8' directive if you know the fields in question are used to store binary data instead of text.) Looking at my database, Templates.Content is definitely TEXT. Oh, and one other thing to watch out for -- the sql.queries file that I got out of running etc/upgrade/schema.mysql-4.0-4.1.pl contained some destructive transforms that I had to change. Several multi-character fields were temporarily transformed into type CHAR, which truncated them to a single character. Check your sql.queries file (e.g. 'grep CHAR sql.queries) and make sure you're not hitting the same thing; in my case, one of the fields that was thus truncated was in fact this same Templates.Content field. RT's templates don't work so good when they consist of only one character. :-) Ole, thanks a lot, I should have paid more attention to that. I for some reason mixed up TEXT and CHAR. As the fields the queries wanted to convert to blob were already blob I just deleted those rows and I now have probably? a properly upgraded DB. (yes I restored an old dump first :) I still have various problems, the cleanslate problem still appear in the logs with various pages. For example: Can't locate object method CleanSlate via package RT::Action::SendEmail at /opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer: http://xxx.yyy.com/Search/Simple.html I also get internal server error with simple search. And for example homepage has: RT::Ticket::ACLEquivalenceObjects Unimplemented in RT::Principal. (/opt/rt38/bin/../lib/RT/Principal_Overlay.pm line 327) and I can't see any of my tickets. Same kind of error appears on almost all pages. ___ 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] delivery to RT queue returning EX_TEMPFAIL but not debug logs or anything useful
Hi RT list, I have about 20 RT queues and my users are reporting intermittent failures with delivery. One example is as follows; Aug 11 21:32:20 dcmon01 sendmail[8402]: m7BLWJQC008218: to=|/opt/rt3/bin/rt-mailgate --debug --queue 'Operations' --action correspond --url http://dcmon01.osti.local/rt/;, ctladdr=op [EMAIL PROTECTED] (8/0), delay=00:00:01, xdelay=00:00:01, mailer=prog, p ri=46549, dsn=4.0.0, stat=Deferred: prog mailer (/usr/sbin/smrsh) exited with EX_TEMPFAIL A what appears to be, well formed ticket email is sent to my request alias, and is rejected with EX_TEMPFAIL. (There are further EX_TEMPFAILS for the same message) Eventually the exchange server gives up. However the confusing thing is that with --debug set in the alias command, I would expect something useful to be logged in either /opt/rt3/log/rt.log or /var/log/messages However there is nothing at all in them for the relevant time for the message and EX_TEMPFAIL time. According to the rt-mailgate script, there should be something for this; warn $content if ($opts{debug}); and according to perldoc warnings, the function warn should send the content to STDERR... So I've no idea where that information is going Any ideas? Thanks, Tom ___ 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] Command line tool: Create ticket with attachments?
Hi, I'm trying to script RT using the command line tool rt, and I'm stuck at the following: I can create tickets fine (rt create ticket -i -e) and manage to pass text as the content of the tickets as it is created. I can create a correspondence within a ticket using rt correspond -a which included an attachment. All fine so far. What I want to achieve is that the requester of my newly created ticket gets a mail containing an attachment. As I have a Autoreply scrip on ticket creation, I can't just do rt create followed by a rt correspond as that would send an empty mail to the user. I need some way of doing the attachment during the ticket creation. Digging through the rt client code, the changes to add this feature don't seem so tricky, but it looks like changes are also needed on the REST code. That is beyond what I want to do now. My best guess as of now is to change the autoreply-scrip to suppress empty mails. Any other hints/ideas for me? /ol -- -=- Otmar Lendl -- [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 3.8 and Ubuntu
Hi, Can anyone recommend a good idiots guide for installing 3.8 on ubuntu with mysql.. I set up 3.6 on ubuntu before but I had installed it via the Synaptic package manager first. ps I don't want to upgrade as I am installing on a vmware image. Thanks in advance, Andy _ Win a voice over part with Kung Fu Panda Live Search and 100’s of Kung Fu Panda prizes to win with Live Search http://clk.atdmt.com/UKM/go/107571439/direct/01/___ 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] Timer for TimeWorked
Greg Evans schrieb: That seemed weird to me as well, but I have an example here (that I got somewhere else) that I was working from. Here is the code of the example if you would like to try to paste it into a file and see what happens. Hi, did you find a working solution for your problem in the meantime? I couldn't find anything in the wiki about it. I either need to get a timer working (with a start/stop button, which I personally find stupid but may be helpful to some of our users) or at least I need to make Time Worked a mandatory field. Browsing through my personal RT archive, it seems this feature request comes up every once in a while Any ideas? Rainer ___ 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-Users Digest, Vol 53, Issue 59
From: Ruslan Zakirov [EMAIL PROTECTED] Apache+mod_perl with two RTs in different virtual hosts? Can't locate object method CleanSlate via package RT::Action::SendEmail at /opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer: http://xxx.yyy.com/Search/Simple.html Yes... That was it. Slowly learning the wonders or Perl Apache :) Another thing is that the scandinavian characters are messed up like Geirs said. But that is not that important at this time (especially if new tickets will have them correctly). Thanks for the help. ___ 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] Issue with iso/utf in 3.8.1?
Emmanuel Lacour wrote: You forgot to read UPGRADING.mysql. It will tell you to upgrade format of DB fields as now RT uses full UTF-8 colation. hm. Indeed I did. Sorry. However, when I do the : mysql -u root -p rt3 sql.queries it tells me : Enter password: ERROR 1067 (42000) at line 3: Invalid default value for 'RightName' zsh: 6183 exit 1 mysql -u root -p rt3 sql.queries Line three contains : ALTER TABLE ACL MODIFY RightName VARBINARY(25) NOT NULL DEFAULT NULL; -geir -- **--**--**--**--**--**--**--**--**--**--**--**--**--**-- Geir Skjotskift, mnemonic ASEmail : [EMAIL PROTECTED] Wergelandsveien 25 Cell : +47 95 10 51 09 N-0167 Oslo, NORWAY Fax : +47 23 20 47 01 Key A2360FF3 availiable at subkeys.pgp.net pgp0xb1T0d4Bb.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] Issue with iso/utf in 3.8.1?
On Wed, Aug 20, 2008 at 06:22:28PM +0200, Geir Skjotskift wrote: Emmanuel Lacour wrote: You forgot to read UPGRADING.mysql. It will tell you to upgrade format of DB fields as now RT uses full UTF-8 colation. hm. Indeed I did. Sorry. However, when I do the : mysql -u root -p rt3 sql.queries it tells me : Enter password: ERROR 1067 (42000) at line 3: Invalid default value for 'RightName' zsh: 6183 exit 1 mysql -u root -p rt3 sql.queries Line three contains : ALTER TABLE ACL MODIFY RightName VARBINARY(25) NOT NULL DEFAULT NULL; Which RT version you used to generate sql.queries? 3.8.0 or 3.8.1? (this bug was reported in list before 3.8.1 and should be fixed as I remember). ___ 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] Issue with iso/utf in 3.8.1?
Emmanuel Lacour wrote: Which RT version you used to generate sql.queries? 3.8.0 or 3.8.1? (this bug was reported in list before 3.8.1 and should be fixed as I remember). Ok. Thanks. I made the assumption that these files had been upgraded as well and used the ones in the rt3 installation directory. When I used the ones directly from the tarball everything worked fine. My nordic letters are back again. :-) Thank you so much. You have been of great help. -geir -- **--**--**--**--**--**--**--**--**--**--**--**--**--**-- Geir Skjotskift, mnemonic ASEmail : [EMAIL PROTECTED] Wergelandsveien 25 Cell : +47 95 10 51 09 N-0167 Oslo, NORWAY Fax : +47 23 20 47 01 Key A2360FF3 availiable at subkeys.pgp.net pgpfRokMLZlLQ.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] [rt-mailgate] --action comment not commenting
I would rather avoid upgrading at this time. An upgrade is planned, but not at this time. Plus this feature appears to have been working since at least RT 3.4. http://wiki.bestpractical.com/view/UbuntuInstallGuide One thing we noticed was that rt-mailgate defaults to correspond; Note that Ctake and Cresolve actions ignore message text if used alone. Include a Ccomment or Ccorrespond action if you want RT to record the incoming message. The default action is Ccorrespond. Jerrad, did you have to do anything special to your fetchmail setup to have mail correctly comment, other than the '--action comment'? Also, how does rt-mailgate know which ticket to comment on? Does it match the subject to an existing ticket? If so, wouldn't things like 'Re:' or 'Fwd:' break subject matching? I can't seem to figure this out looking at the source code. Thanks, -Tyler Jerrad Pierce wrote: On Wed, Aug 20, 2008 at 10:33, Tyler Knappe [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi all, I am running RT 3.6.3 using fetchmail to retrieve messages from our mail server. I have two email addresses setup to receive mail, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] and [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]. Within the fetchmail config file [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] correctly uses '--action correspond' to make a ticket within RT. However, when sending mail to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] it doesn't seem to correctly use the '--action comment' to comment on tickets, rather it never comments and only corresponds, creating new tickets. Though rt-mailgate shows this: =item Action The action being performed. At the moment, it's one of comment or correspond I've isolated it to rt-mailgate, ruling out the mail server and fetchmail. Any ideas? Upgrade? 3.8 works for me. -- Cambridge Energy Alliance: Save money the planet -- Tyler Knappe | IT Assistant | VisionLink | First National Center | 3101 Iris Avenue, Suite 240 | Boulder CO, 80301 | 303.402.0170 ext. 124 ___ 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] Upgrading RT's mysql DB version
People, This probably is not the right forum to ask, but as this is a RT related task, I'd appreciate any feedback from this list. Do someone have any recommendations to upgrade the mysql server version from 5.0.51 to 5.1.x with a RT DB, taking in account that the RT 3.4.5 will be upgraded to 3.8.x? Thanks in advance, Alex ___ 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] delivery to RT queue returning EX_TEMPFAIL but not debug logs or anything useful
Emmanuel Lacour wrote: On Wed, Aug 20, 2008 at 04:29:55PM +0100, Tom H wrote: warn $content if ($opts{debug}); and according to perldoc warnings, the function warn should send the content to STDERR... So I've no idea where that information is going Any ideas? Try to log the error to a file by modifying a little bit rt-mailgate. Look in you're apache and rt error logs, if rt-mailgate cannot submit, there should be an error there. The problem itself is odd, because RT itself is returning 200 for the request to create the message; 10.127.2.24 - - [11/Aug/2008:21:32:19 +] POST /rt//REST/1.0/NoAuth/mail-gateway HTTP/1.1 200 721 - libwww-perl/5.808 but rt-mailgate is returning exit code 75 to smrsh/sendmail; Date: Mon, 11 Aug 2008 21:31:23 + [EMAIL PROTECTED] # #4.4.7 X-Unix; 75 #SMTP# By the looks of it the server returns EX_TEMPFAIL if the return content didn't include ok|not ok 114: if ( $content !~ /^(ok|not ok)/ ) { But sendmail is still not including this error text in the bounce mail to the requestor.. which I guess is the part I am confused about. I'm going to patch rt-mailgate to log that stuff to a local file for the meanwhile. But I would be keen to understand where the option to do that is in the sendmail config. Tom ___ 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] No permission notify
Is there any way to not notify the sender when they don't have permission? I don't mind the root@ notification but spammers just hammer all our queues and the closed ones don't have a spam filter on it .. so it causes tons of backscatter (spoofed sender returns spam). All our public queues are controlled mostly through web forms and other apps, so there's no reason to notify anyone about permissions in these cases for us. If there's any reason why this would be a bad idea I wouldn't mind hearing too. -- /RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for this email ([EMAIL PROTECTED]). You might need to grant 'Everyone' the right 'CreateTicket' for the queue queue::blah. -- /Thanks Curtis ___ 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] No permission notify
Curtis, Try removing those permissions from EVERYONE and UNPRIVILEGED to PRIVILEGED only. Hope this helps. Kenn LBNL On 8/20/2008 10:48 AM, Curtis Bruneau wrote: Is there any way to not notify the sender when they don't have permission? I don't mind the root@ notification but spammers just hammer all our queues and the closed ones don't have a spam filter on it .. so it causes tons of backscatter (spoofed sender returns spam). All our public queues are controlled mostly through web forms and other apps, so there's no reason to notify anyone about permissions in these cases for us. If there's any reason why this would be a bad idea I wouldn't mind hearing too. -- /RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for this email ([EMAIL PROTECTED]). You might need to grant 'Everyone' the right 'CreateTicket' for the queue queue::blah. -- /Thanks Curtis ___ 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] apache/perl error for rt 3.8.1 on apache start
I can't get Apache to start after adding the RT virtual host. Solaris 10u5 Apache 2.2.9 mod_perl 2.0.4 RT 3.8.1 I get the following error in the Apache error log. [Wed Aug 20 14:35:17 2008] [error] Can't locate object method mk_classdata via package Exception::Class::Base at /opt/csw/share/perl/site_perl/Exception/Class.pm line 198.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/site_perl/Exception/Class.pm line 211.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/Mason/Exceptions.pm line 73.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Exceptions.pm line 73.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/Mason/Tools.pm line 18.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Tools.pm line 18.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/Mason/Request.pm line 40.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Request.pm line 40.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/Mason/ApacheHandler.pm line 49.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ApacheHandler.pm line 49.\nCompilation failed in require at /opt/rt3/bin/../lib/RT/Interface/Web/Handler.pm line 140.\nCompilation failed in require at (eval 2) line 1.\n Am I missing a Perl Module, or is there a version mismatch? Thanks, Jess ___ 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] 3.8 GraphViz
I cannot seem to get the GraphViz working properly... I am trying to migrate from 3.6.5 to the 3.8.rc5... the issues that I have are: 1. I seem to require copying /opt/rt3/share/html/NoAuth/RichText/FCKeditor/fckstyles.xml up one directory. if I do not do this, when I try to add a comment or a reply to a ticket the dialogue box is not accessible... When I looked at the html source it indicated /RichText/fckstyles... so that is why I tried copying the file up one directory...then things worked... I mentioned this earlier on the list when I first attempted 3.8.0, Jesse mentioned that dhandler should automagically handle this, ( it was the least of my early challenges ), but this still exists even on mylatest numerous attempts. (I mention it because it may be related ) 2. I had version 3.8.rc3 working ( with the above kludge in place so things appeared to be working) and thought I would experiment with the GraphViz feature... This also sorta works... I just cannot get it to draw the relational images , I just get an unknown icon image. If I click on the icon , I do get taken back to the record, and if I select the fill boxes with ... something the proper information boxes appear in the Legends area.. I tried using different browsers, ugraded the GraphViz and GD...still no luck I am running on SUSE and have used the following configure: ./configure --enable-graphviz --enable-gd --enable-gpg I assume that both above issues are my install attempt related. I have tried numerous re-installs and even a brand new clean ( ie no old database or customizations ) but the result is the same... Any hints at how I got myself in the weeds...( and how to get out of the them !!!) PS: I am running lighttpd with the below /usr/bin/perl ./sbin/rt-test-dependencies --verbose --install --with-mysql --with-fastcgi perl: =5.8.3(5.8.8)...found users: rt group (www)...found bin owner (root)...found libs owner (root)...found libs group (bin)...found web owner (nobody)...found web group (www)...found CLI dependencies: Term::ReadKey...found Getopt::Long = 2.24...found HTTP::Request::Common...found Term::ReadLine...found Text::ParseWords...found LWP...found CORE dependencies: Class::ReturnValue = 0.40...found Text::Quoted = 2.02...found CSS::Squish = 0.06...found Encode = 2.13...found Module::Versions::Report = 1.05...found MIME::Entity = 5.425...found DBI = 1.37...found Locale::Maketext::Lexicon = 0.32...found Devel::StackTrace = 1.19...found Digest::base...found Time::ParseDate...found File::Temp = 0.18...found Locale::Maketext = 1.06...found Tree::Simple = 1.04...found Text::Template...found Scalar::Util...found HTML::Scrubber = 0.08...found File::Spec = 0.8...found Calendar::Simple...found DBIx::SearchBuilder = 1.54...found Mail::Mailer = 1.57...found File::ShareDir...found Regexp::Common...found Digest::MD5 = 2.27...found HTML::Entities...found Cache::Simple::TimedExpiry...found File::Glob...found Locale::Maketext::Fuzzy...found Time::HiRes...found Text::Wrapper...found Log::Dispatch = 2.0...found UNIVERSAL::require...found Email::Address...found DASHBOARDS dependencies: HTML::RewriteAttributes = 0.02...found MIME::Types...found FASTCGI dependencies: CGI::Fast...found CGI = 3.38...found FCGI...found GD dependencies: GD::Text...found GD...found GD::Graph...found GPG dependencies: PerlIO::eol...found GnuPG::Interface...found GRAPHVIZ dependencies: IPC::Run...found GraphViz...found IPC::Run::SafeHandles...found ICAL dependencies: Data::ICal...found MAILGATE dependencies: Pod::Usage...found HTML::TreeBuilder...found Getopt::Long...found HTML::FormatText...found LWP::UserAgent...found MASON dependencies: Storable = 2.08...found CSS::Squish = 0.06...found Apache::Session = 1.53...found Errno...found Devel::StackTrace = 1.19...found CGI::Cookie = 1.20...found Text::WikiFormat = 0.76...found XML::RSS = 1.05...found HTML::Mason = 1.36...found Digest::MD5 = 2.27...found MYSQL dependencies: DBD::mysql = 2.1018...found SMTP dependencies: Net::SMTP...found STANDALONE dependencies: Net::Server::PreFork...found Net::Server...found HTTP::Server::Simple = 0.34...found HTTP::Server::Simple::Mason = 0.09...found All dependencies have been found. ___
Re: [rt-users] apache/perl error for rt 3.8.1 on apache start
On Aug 20, 2008, at 2:37 PM, Jess wrote: I can't get Apache to start after adding the RT virtual host. Solaris 10u5 Apache 2.2.9 mod_perl 2.0.4 RT 3.8.1 I get the following error in the Apache error log. [Wed Aug 20 14:35:17 2008] [error] Can't locate object method mk_classdata via package Exception::Class::Base at Sounds like you failed to install Class::Data::Inheritable which Exception::Class requires and is in turn required by HTML::Mason -kevin /opt/csw/share/perl/site_perl/Exception/Class.pm line 198.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/site_perl/ Exception/Class.pm line 211.\nCompilation failed in require at /opt/ csw/share/perl/csw/HTML/Mason/Exceptions.pm line 73.\nBEGIN failed-- compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ Exceptions.pm line 73.\nCompilation failed in require at /opt/csw/ share/perl/csw/HTML/Mason/Tools.pm line 18.\nBEGIN failed-- compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Tools.pm line 18.\nCompilation failed in require at /opt/csw/share/perl/csw/ HTML/Mason/Request.pm line 40.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Request.pm line 40.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/ Mason/ApacheHandler.pm line 49.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ApacheHandler.pm line 49.\nCompilation failed in require at /opt/rt3/bin/../lib/RT/ Interface/Web/Handler.pm line 140.\nCompilation failed in require at (eval 2) line 1.\n Am I missing a Perl Module, or is there a version mismatch? Thanks, Jess ___ 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] upgrade 3.6.1-3.8.1 Looping login
Upgraded 3.6.1 to 3.8.1, carefully read the docs, followed the instructions (for mysql) and the upgrade went brilliantly. Good job folks. Very nice. Logged into my new shiny RT. And all looks good. however, when running (some) reports, and fiddling about with advanced searches, I'll get returned to a login screen, and I must log in again in order to access the result. ___ 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] 3.8 GraphViz
On Aug 20, 2008, at 2:38 PM, Roy Sowa wrote: I cannot seem to get the GraphViz working properly... I am trying to migrate from 3.6.5 to the 3.8.rc5... Any reason not to use the official 3.8.1? the issues that I have are: 1. I seem to require copying /opt/rt3/share/html/NoAuth/RichText/ FCKeditor/fckstyles.xml up one directory. if I do not do this, when I try to add a comment or a reply to a ticket the dialogue box is not accessible... When I looked at the html source it indicated /RichText/ fckstyles... so that is why I tried copying the file up one directory...then things worked... I mentioned this earlier on the list when I first attempted 3.8.0, Jesse mentioned that dhandler should automagically handle this, ( it was the least of my early challenges ), but this still exists even on mylatest numerous attempts. (I mention it because it may be related ) You mention in your PS the most important thing - you use lighttpd It sounds like you've told lighttpd to not run Mason under NoAuth rather than NoAuth/images, or that mason and the lighttpd dhandler aren't playing well together. You should instrument the dhandler and try to figure out what is happening You should not need to copy fckstyles.xml around, feel free to look at rt3.fsck.com for an example of it working fine (under apache and fcgi) 2. I had version 3.8.rc3 working ( with the above kludge in place so things appeared to be working) and thought I would experiment with the GraphViz feature... This also sorta works... I just cannot get it to draw the relational images , I just get an unknown icon image. If I click on the icon , I do get taken back to the record, and if I select the fill boxes with ... something the proper information boxes appear in the Legends area.. What showed up in your logs? It sounds like there should be an error. These images are dynamically generated by RT, do you need to configure lighttpd differently to support that? -kevin I tried using different browsers, ugraded the GraphViz and GD...still no luck I am running on SUSE and have used the following configure: ./configure --enable-graphviz --enable-gd --enable-gpg I assume that both above issues are my install attempt related. I have tried numerous re-installs and even a brand new clean ( ie no old database or customizations ) but the result is the same... Any hints at how I got myself in the weeds...( and how to get out of the them !!!) PS: I am running lighttpd with the below /usr/bin/perl ./sbin/rt-test-dependencies --verbose --install --with- mysql --with-fastcgi perl: =5.8.3(5.8.8)...found users: rt group (www)...found bin owner (root)...found libs owner (root)...found libs group (bin)...found web owner (nobody)...found web group (www)...found CLI dependencies: Term::ReadKey...found Getopt::Long = 2.24...found HTTP::Request::Common...found Term::ReadLine...found Text::ParseWords...found LWP...found CORE dependencies: Class::ReturnValue = 0.40...found Text::Quoted = 2.02...found CSS::Squish = 0.06...found Encode = 2.13...found Module::Versions::Report = 1.05...found MIME::Entity = 5.425...found DBI = 1.37...found Locale::Maketext::Lexicon = 0.32...found Devel::StackTrace = 1.19...found Digest::base...found Time::ParseDate...found File::Temp = 0.18...found Locale::Maketext = 1.06...found Tree::Simple = 1.04...found Text::Template...found Scalar::Util...found HTML::Scrubber = 0.08...found File::Spec = 0.8...found Calendar::Simple...found DBIx::SearchBuilder = 1.54...found Mail::Mailer = 1.57...found File::ShareDir...found Regexp::Common...found Digest::MD5 = 2.27...found HTML::Entities...found Cache::Simple::TimedExpiry...found File::Glob...found Locale::Maketext::Fuzzy...found Time::HiRes...found Text::Wrapper...found Log::Dispatch = 2.0...found UNIVERSAL::require...found Email::Address...found DASHBOARDS dependencies: HTML::RewriteAttributes = 0.02...found MIME::Types...found FASTCGI dependencies: CGI::Fast...found CGI = 3.38...found FCGI...found GD dependencies: GD::Text...found GD...found GD::Graph...found GPG dependencies: PerlIO::eol...found GnuPG::Interface...found GRAPHVIZ dependencies: IPC::Run...found GraphViz...found IPC::Run::SafeHandles...found ICAL dependencies: Data::ICal...found MAILGATE dependencies: Pod::Usage...found HTML::TreeBuilder...found Getopt::Long...found HTML::FormatText...found
Re: [rt-users] RT 3.8 and Ubuntu
This guide should be able to take you pretty far (I've used it as a complete Linux noob) http://wiki.bestpractical.com/view/DebianStableInstallGuide It is a little older but you should be able to replace with newer versions (like if you want to use Apache2, MySQL 5, etc) on the package list From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of andrew fay Sent: Wednesday, August 20, 2008 11:59 AM To: rt mailing list Subject: [rt-users] RT 3.8 and Ubuntu Hi, Can anyone recommend a good idiots guide for installing 3.8 on ubuntu with mysql.. I set up 3.6 on ubuntu before but I had installed it via the Synaptic package manager first. ps I don't want to upgrade as I am installing on a vmware image. Thanks in advance, Andy Get Hotmail on your mobile from Vodafone Try it Now! http://clk.atdmt.com/UKM/go/107571435/direct/01/ ___ 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 3.8 and Ubuntu
On Aug 20, 2008, at 11:58 AM, andrew fay wrote: Can anyone recommend a good idiots guide for installing 3.8 on ubuntu with mysql.. I set up 3.6 on ubuntu before but I had installed it via the Synaptic package manager first. ps I don't want to upgrade as I am installing on a vmware image. Have you tried following the README? -kevin ___ 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] Rich Text E-mail in 3.8
On Aug 20, 2008, at 3:18 PM, Helmuth Ramirez wrote: I have my 3.8.1 instance up and running and was looking into getting RT to send out Rich Text e-mail messages (correspondence) without much luck. I came across this in the archives: From http://www.gossamer-threads.com/lists/rt/users/77177#77177 i only see plain text after save. and i get plain text email. You need to tweak your templates slightly in order to send html mail, but it seems to tickle a bug. You should get mail about a bug report in a few minutes. Does this mean its not working yet (and its not just me :) or do I need to “tweak” my templates. If so, how would I go about doing that? I do have PreferRichText set in my RT_SiteConfig.pm file and am using the WYSIWYG editor. As I said in that email, a ticket has been opened. It is a blocker for 3.8.2, and you can find it on rt3.fsck.com ticket 11013 Documentation and a fix will be included in 3.8.2 -kevin ___ 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] Rich Text E-mail in 3.8
Thanks Kevin, Didn't mean to push, just wasn't exactly sure what tickle a bug meant :) ___ 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] apache/perl error for rt 3.8.1 on apache start
On Aug 20, 2008, at 3:49 PM, Jess wrote: Please don't reply to me privately off the list, it means other people can't see a reply and offer insight Thanks. CPAN install claims that Class::Data::Inheritable is up to date. And the RT make testdeps shows that dependencies are all found. You should test with the standalone_httpd or rt-server binaries to try and narrow down what is going wrong, it looks like the inheritance in mason exceptions is breaking somewhere. -kevin On Wed, Aug 20, 2008 at 2:48 PM, Kevin Falcone [EMAIL PROTECTED] wrote: On Aug 20, 2008, at 2:37 PM, Jess wrote: I can't get Apache to start after adding the RT virtual host. Solaris 10u5 Apache 2.2.9 mod_perl 2.0.4 RT 3.8.1 I get the following error in the Apache error log. [Wed Aug 20 14:35:17 2008] [error] Can't locate object method mk_classdata via package Exception::Class::Base at Sounds like you failed to install Class::Data::Inheritable which Exception::Class requires and is in turn required by HTML::Mason -kevin /opt/csw/share/perl/site_perl/Exception/Class.pm line 198.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/site_perl/ Exception/Class.pm line 211.\nCompilation failed in require at /opt/ csw/share/perl/csw/HTML/Mason/Exceptions.pm line 73.\nBEGIN failed-- compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ Exceptions.pm line 73.\nCompilation failed in require at /opt/csw/ share/perl/csw/HTML/Mason/Tools.pm line 18.\nBEGIN failed-- compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Tools.pm line 18.\nCompilation failed in require at /opt/csw/share/perl/csw/ HTML/Mason/Request.pm line 40.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Request.pm line 40.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/ Mason/ApacheHandler.pm line 49.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ApacheHandler.pm line 49.\nCompilation failed in require at /opt/rt3/bin/../lib/RT/ Interface/Web/Handler.pm line 140.\nCompilation failed in require at (eval 2) line 1.\n Am I missing a Perl Module, or is there a version mismatch? Thanks, Jess ___ ___ 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] apache/perl error for rt 3.8.1 on apache start
Sorry about that, I meant to hit reply-all. I found the problem though (Truss or DTrace should always be step a first step, duh). I had attempted to install 3.8.0 on this host and fought through all of the autoconf and other issues with that, and then when 3.8.1 came out I just installed over the existing directory. I removed the old rt3 directory and did a clean install of 3.8.1 and I now have a login page. Thanks for such quick responses. -jess On Wed, Aug 20, 2008 at 3:57 PM, Kevin Falcone [EMAIL PROTECTED]wrote: On Aug 20, 2008, at 3:49 PM, Jess wrote: Please don't reply to me privately off the list, it means other people can't see a reply and offer insight Thanks. CPAN install claims that Class::Data::Inheritable is up to date. And the RT make testdeps shows that dependencies are all found. You should test with the standalone_httpd or rt-server binaries to try and narrow down what is going wrong, it looks like the inheritance in mason exceptions is breaking somewhere. -kevin On Wed, Aug 20, 2008 at 2:48 PM, Kevin Falcone [EMAIL PROTECTED] wrote: On Aug 20, 2008, at 2:37 PM, Jess wrote: I can't get Apache to start after adding the RT virtual host. Solaris 10u5 Apache 2.2.9 mod_perl 2.0.4 RT 3.8.1 I get the following error in the Apache error log. [Wed Aug 20 14:35:17 2008] [error] Can't locate object method mk_classdata via package Exception::Class::Base at Sounds like you failed to install Class::Data::Inheritable which Exception::Class requires and is in turn required by HTML::Mason -kevin /opt/csw/share/perl/site_perl/Exception/Class.pm line 198.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/site_perl/ Exception/Class.pm line 211.\nCompilation failed in require at /opt/ csw/share/perl/csw/HTML/Mason/Exceptions.pm line 73.\nBEGIN failed-- compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ Exceptions.pm line 73.\nCompilation failed in require at /opt/csw/ share/perl/csw/HTML/Mason/Tools.pm line 18.\nBEGIN failed-- compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Tools.pm line 18.\nCompilation failed in require at /opt/csw/share/perl/csw/ HTML/Mason/Request.pm line 40.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/Request.pm line 40.\nCompilation failed in require at /opt/csw/share/perl/csw/HTML/ Mason/ApacheHandler.pm line 49.\nBEGIN failed--compilation aborted at /opt/csw/share/perl/csw/HTML/Mason/ApacheHandler.pm line 49.\nCompilation failed in require at /opt/rt3/bin/../lib/RT/ Interface/Web/Handler.pm line 140.\nCompilation failed in require at (eval 2) line 1.\n Am I missing a Perl Module, or is there a version mismatch? Thanks, Jess ___ ___ 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] Upgrade database from 3.6.1 to new server running RT3.8.1
Hi again, I'm sorry, I didn't send to mail list, I forgot. But here it's history: I discovered my problem. In fact, my database upgrade was right, but it's happening something stranger. In my main page on RT the url tickets are: http://site/rt/Ticket/Display.html?id=1 and it should be: http://gonzales/Ticket/Display.html?id=1 If I access from that link (http://site/rt/Ticket/Display.html?id=1) , RT can't access the page. In search results page, the url is right: http://gonzales/Ticket/Display.html?id=382 Why ? I didn't configure RT_SiteConfig.pm where it show WebPath, in fact, I didn't need set this parameter to work. Thank's, Pedro 2008/8/19 Pedro Bomente Filho [EMAIL PROTECTED]: 2008/8/19 Helmuth Ramirez [EMAIL PROTECTED]: Pedro, I'm sorry, I don't think I'll be able to be much help here. The /usr/src location, is that where you extracted the .gz file to? For Yes, that is. what its worth, I was having trouble with my upgrade until I ran the command from the location where I extracted the files. In my case: cd'd to source directory (example /tmp/stuff/rt/rt-3.8.0) once there, ran /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade I remember. But, anyway, thank you for help me. Pedro -Original Message- From: Pedro Bomente Filho [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 4:51 PM To: Helmuth Ramirez Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server running RT3.8.1 Helmuth, From RT source, I mean: /usr/src/rt-3.8.1 so, I ran: perl sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade These were my steps to upgrade database: - I installed RT 3.8.1 - Here it work normally! I did every steps from file README - I dumped my old RT 3.6.1: I ran: ' mysqldump --opt --skip-lock-tables --single-transaction --default-character-set=binary --databases rtdb backup.sql ' - I imported backup from old server to new server: I ran: ' mysql -u root -p backup.sql ' - Upgrade RT schema: I ran: ' perl sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade ' from /usr/src/rt-3.8.1 Where can it be wrong? I don't know. Thank you, Pedro 2008/8/19 Helmuth Ramirez [EMAIL PROTECTED]: Pedro, When you run the rt-setup-database script, what folder are you running it from? -Original Message- From: Pedro Bomente Filho [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 4:31 PM To: Helmuth Ramirez Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server running RT3.8.1 Hi Helmuth, thank's for answer again! Well, 2008/8/19 Helmuth Ramirez [EMAIL PROTECTED]: Pedro, Based on our offline conversation, I think the first thing issue that needs to be tackled is why you can't access your db properly in the 3.8 world. Unfortunately I'm not smart enough to answer that, but maybe I can help troubleshoot with you. I too moved my RT installation to a new server (3.6.3 to 3.8.0 to 3.8.1). Prior to me upgrading the db, I was able to successfully access my new 3.8.0 installation and view my tickets. I imagine you should be able to also. I'm able to successfully access my new 3.8.1 and view my tickets. I'm going to throw out some basic things (please do not take offense), Ok, no problem. do you have all the dependencies met for 3.8.1? Did you update your Yes, I ran make testdeps before installation and it returned me All dependencies have been found. RT_SiteConfig.pm with your db name (I think you are using a different name from the default). Yes, I did. In RT 3.8.1, when I run make initialize-database, it create a db in mysql acordding RT_SiteConfig.pm. For example: My RT_SiteConfig.pm: Set($DatabaseName , 'rtdb'); My mysql: mysql show databases; ++ | Database | ++ | information_schema | | mysql | | rtdb | ++ In my RT 3.8.1 without to upgrade database RT 3.6.1, I can use normally. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pedro Bomente Filho Sent: Tuesday, August 19, 2008 4:03 PM To: RT Users Subject: [rt-users] Upgrade database from 3.6.1 to new server running RT3.8.1 Hi people, Can anyone help me to upgrade database from RT 3.6.1 to new server RT 3.8.1? I don't know what I'm doing wrong. How can I do it? I only found documentation to upgrade an existing server. Thank you, Pedro Bomente ___ 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] Upgrade database from 3.6.1 to new server runningRT3.8.1
Try modifying this in your RT_SiteConfig.pm Set($WebBaseURL , http://gonzales;); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pedro Bomente Filho Sent: Wednesday, August 20, 2008 4:03 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server runningRT3.8.1 Hi again, I'm sorry, I didn't send to mail list, I forgot. But here it's history: I discovered my problem. In fact, my database upgrade was right, but it's happening something stranger. In my main page on RT the url tickets are: http://site/rt/Ticket/Display.html?id=1 and it should be: http://gonzales/Ticket/Display.html?id=1 If I access from that link (http://site/rt/Ticket/Display.html?id=1) , RT can't access the page. In search results page, the url is right: http://gonzales/Ticket/Display.html?id=382 Why ? I didn't configure RT_SiteConfig.pm where it show WebPath, in fact, I didn't need set this parameter to work. Thank's, Pedro ___ 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] Upgrade database from 3.6.1 to new server runningRT3.8.1
2008/8/20 Helmuth Ramirez [EMAIL PROTECTED]: Try modifying this in your RT_SiteConfig.pm Set($WebBaseURL , http://gonzales;); It did work. But I did a thing tha worked. I added in my apache configution, Alias /rt /opt/rt3/share/html It worked, but I shouldn't solve this, do you understand me? RT main page should link to: http://gonzales/Ticket/Display.html?id=1 and not to: http://gonzales/rt/Ticket/Display.html?id=1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pedro Bomente Filho Sent: Wednesday, August 20, 2008 4:03 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server runningRT3.8.1 Hi again, I'm sorry, I didn't send to mail list, I forgot. But here it's history: I discovered my problem. In fact, my database upgrade was right, but it's happening something stranger. In my main page on RT the url tickets are: http://site/rt/Ticket/Display.html?id=1 and it should be: http://gonzales/Ticket/Display.html?id=1 If I access from that link (http://site/rt/Ticket/Display.html?id=1) , RT can't access the page. In search results page, the url is right: http://gonzales/Ticket/Display.html?id=382 Why ? I didn't configure RT_SiteConfig.pm where it show WebPath, in fact, I didn't need set this parameter to work. Thank's, Pedro ___ 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] Upgrade database from 3.6.1 to new server runningRT3.8.1
2008/8/20 Helmuth Ramirez [EMAIL PROTECTED]: Try modifying this in your RT_SiteConfig.pm Set($WebBaseURL , http://gonzales;); Sorry, now it's correct: It did NOT work. But I did a thing thaT worked. I added in my apache configution, Alias /rt /opt/rt3/share/html It worked, but I shouldn't solve this way, do you understand me? RT main page should link to: http://gonzales/Ticket/Display.html?id=1 and not to: http://gonzales/rt/Ticket/Display.html?id=1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pedro Bomente Filho Sent: Wednesday, August 20, 2008 4:03 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server runningRT3.8.1 Hi again, I'm sorry, I didn't send to mail list, I forgot. But here it's history: I discovered my problem. In fact, my database upgrade was right, but it's happening something stranger. In my main page on RT the url tickets are: http://site/rt/Ticket/Display.html?id=1 and it should be: http://gonzales/Ticket/Display.html?id=1 If I access from that link (http://site/rt/Ticket/Display.html?id=1) , RT can't access the page. In search results page, the url is right: http://gonzales/Ticket/Display.html?id=382 Why ? I didn't configure RT_SiteConfig.pm where it show WebPath, in fact, I didn't need set this parameter to work. Thank's, Pedro ___ 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] Upgrade from 3.4.2
I did a fresh install to a new server for 3.8. Worked fine. Then I used the pg to mysql conversion tool, dumped the converted db, copied it over to the new server and followed the upgrade path. When I try to login, I get the following error in my browser. Can't call method Disabled on an undefined value at /opt/rt3/bin/../lib/RT/User_Overlay.pm line 971. And the error [crit]: No principal for user #2323 in the apache log. Any ideas? I can see that it's likely the PrincipalObj isn't defined but that's about as far as I went with debugging. It's a definitely a data issue that occurred during the update of the older database. Thanks, Diona ___ 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] Delete dashboard
Is there anyway to delete a dashboard (a most unintuitive name for an email)? -- Cambridge Energy Alliance: Save money 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] Delete dashboard
On Aug 20, 2008, at 5:30 PM, Jerrad Pierce wrote: Is there anyway to delete a dashboard Click the 'basics' link. then click the Delete button. (a most unintuitive name for an email)? Ah, Email is only one of the ways you can get at the content. I browse them on the web to keep tabs on Best Practical's sales process and our open RT bugs. -- Cambridge Energy Alliance: Save money 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 ___ 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] Upgrade from 3.4.2
On Aug 20, 2008, at 5:29 PM, Diona Kidd wrote: I did a fresh install to a new server for 3.8. Worked fine. Then I used the pg to mysql conversion tool, I suspect this stage didn't go as you'd hoped. dumped the converted db, copied it over to the new server and followed the upgrade path. Can you give me SELECT * From Principals where id = 2323? When I try to login, I get the following error in my browser. Can't call method Disabled on an undefined value at /opt/rt3/bin/../lib/RT/User_Overlay.pm line 971. And the error [crit]: No principal for user #2323 in the apache log. Any ideas? I can see that it's likely the PrincipalObj isn't defined but that's about as far as I went with debugging. It's a definitely a data issue that occurred during the update of the older database. Thanks, Diona ___ 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] Delete dashboard
Have you tried as a superuser? I suspect you may not have granted yourself the right. Indeed. I had not noticed that there were several Delete*Dashboard ACLs. Doh! -- Cambridge Energy Alliance: Save money 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] Upgrading RT's mysql DB version
1) Several people tried RT on 5.1.23-5.1.25 and reported major performance degradation because of bug in mysql query planner. mysql team said that it's fixed in 5.1.28, but I have at least one report from an user that it's still terribly slow. The user downgraded to 5.0.xx 2) Do one step then another. Upgrade RT on mysql 5.0 and only when you're sure that it works ok, try 5.1. Considering above you should try the latest mysql 5.1.x available. On Wed, Aug 20, 2008 at 9:19 PM, Alex Moura [EMAIL PROTECTED] wrote: People, This probably is not the right forum to ask, but as this is a RT related task, I'd appreciate any feedback from this list. Do someone have any recommendations to upgrade the mysql server version from 5.0.51 to 5.1.x with a RT DB, taking in account that the RT 3.4.5 will be upgraded to 3.8.x? Thanks in advance, Alex ___ 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
Re: [rt-users] Problem after an upgrade to 3.8.1
Sebastien, I had this issue as well - luckily I was running in a Virtual Machine, so I upped the allocated memory from 1Gig to 2Gig and the problem went away. It looks like RT is a bit of a memory pig (in the nicest possible way!) How much memory do you have in your machine? Cheers, David - Original Message - From: Sebastien Termeau [EMAIL PROTECTED] To: rt-users@lists.bestpractical.com Sent: Wednesday, 20 August, 2008 11:22:13 PM GMT +10:00 Brisbane Subject: [rt-users] Problem after an upgrade to 3.8.1 Dear RT-Users, I have a really recent RT 3.6.7 installation (around 200 tickets) running on CentOS 5.2. I was able to upgrade to 3.8.0 without problems. The problems appear when I tried to upgrade either from 3.6.7 to 3.8.1 or from 3.8.0 to 3.8.1. A fresh 3.8.1 installation works fine. After the upgrade, when I try to access the web interface I only receive a blank page. In my apache error log file, the following message is present: Out of memory! Callback called exit. I got the same error when I tried to use rt-clean-sessions. Using 'perl -d', I tracked down the error to RT::Interface::Web::Session::ClearByUser line 246 eval { tie %session, $class, $id, $attrs }; - $class=Apache::Session::MySQL - $id=3d97a1c2c09740acfee006d0221d1d12 - attrs is an empty hash I tried to remove all the existing sessions in the database : delete from sessions; And it was working fine for 5 minutes. Then the same error rise again. Did I missed something in the upgrade process? Do you have a suggestion? Regards ___ 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 -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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] rt: Server error: Internal Server Error (500) for rt ls -i LastUpdated = '$(date -d 1 month ago)'
Something is seriously wrong with my RT deployment. I first noticed the problem with Ubuntu Hardy 8.04's RT 3.6 packages; yesterday I upgraded to 3.8.1rc5 without noticeable improvement. I also tried upgrading the hardware to a 2.4GHz Celeron with 2Gb of RAM; this didn't seem to help. I'm using the postgres backend and there are currently less than 200 tickets in my RT instance (this was a pilot deployment). This (draft) bash script to rip timesheet data out of RT falls down and dies: FIELDS=Ticket,Created,Creator,TimeTaken rt ls -i LastUpdated = '$(date -d 1 month ago)' | sed 's|$|/history/type/Correspond|' | rt show -l -f $FIELDS - | egrep -v '^(#|$|--|RT/.* 200 Ok)' | # Remove lines that aren't data cut -d: -f 2- | # remove field names tr -d , | # kludge; comma is the delimiter paste -sd ${FIELDS//[!,]},\n It doesn't seem to always fail at the same point; right now it's failing before it even gets to rt show: $ rt ls -i LastUpdated = '$(date -I -d 1 week ago)' ++ date -I -d '1 week ago' + rt ls -i 'LastUpdated = '\''2008-08-14'\''' rt: Server error: Internal Server Error (500) I strongly suspect this is because apache's perl interface (mod_perl2?) is severing the connection because it took too long. Possibly related, there are tens of thousands of lines in syslog of the form: Aug 19 16:08:54 oyster RT: We found a merged ticket.3/66 Aug 19 16:09:10 oyster last message repeated 376 times Aug 19 16:09:11 oyster RT: We found a merged ticket.4/65 Aug 19 16:09:38 oyster last message repeated 686 times These syslog messages seem to be appear when doing rt show ticket/$n/history, but not rt ls -i $query. The offending process seems to be CPU-bound for some time after rt(1) fails, for example: PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 29445 www-data 20 0 63304 56m 4084 R 96.6 2.8 29:27.53 /usr/bin/perl /usr/share/request-tracker3.8/libexec/mason_handler.fcgi ___ 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