[rt-users] how to setup two apache vhosts towards the same RT with fastcgi
Hi I have been working on migrating our existing old RT 3.8.8 to RT 4.2.9. We currently have two domains that point towards the same RT – and that works in RT 3.8.8 – and I’d like to have the same setup in the new RT, so I don’t break any links to the two current domains that I am not aware of… But – when I try to do something similar with RT 4.2.9 + Apache2 + fastcgi – the first vhost resolves just fine – whereas the second site just hangs….. My guess is I am doing something wrong – how to make two vhosts in apache2 point to the same RT backend with fastcgi? A pointer in the right direction will be deeply appreciated. My Apache config looks as follows: # Tell FastCGI to put its temporary files somewhere sane; this may # be necessary if your distribution doesn't already set it FastCgiIpcDir /opt/rt4/tmp FastCgiServer /opt/rt4/sbin/rt-server.fcgi -processes 5 -idle-timeout 300 NameVirtualHost rt4.example.com:80 NameVirtualHost rt4-test.example.com:80 Listen 80 NameVirtualHost rt4.example.com:443 NameVirtualHost rt4-test.example.com:443 Listen 443 VirtualHost rt4.example.com:80 ServerName rt4.example.com ErrorLog /var/log/httpd/rt4_error_log CustomLog /var/log/httpd/rt4_access_log common RedirectPermanent / https://rt4.example.com/ /VirtualHost VirtualHost rt4-test.example.com:80 ServerName rt4-test.example.com ErrorLog /var/log/httpd/rt4_error_log CustomLog /var/log/httpd/rt4_access_log common RedirectPermanent / https://rt4-test.example.com/ /VirtualHost VirtualHost rt4.example.com:443 ServerName rt4.example.com ### Optional apache logs for RT # Ensure that your log rotation scripts know about these files ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access LogLevel debug SSLEngine on SSLCertificateChainFile /etc/httpd/ssl/secret.cer SSLCertificateFile/etc/httpd/ssl/certificate.pem SSLCertificateKeyFile /etc/httpd/ssl/certificate.key AddDefaultCharset UTF-8 ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/ DocumentRoot /opt/rt4/share/html Location / Order allow,deny Allow from all Options +ExecCGI AddHandler fastcgi-script fcgi /Location /VirtualHost VirtualHost rt4-test.example.com:443 ServerName rt4-test.example.com ### Optional apache logs for RT # Ensure that your log rotation scripts know about these files ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access LogLevel debug SSLEngine on SSLCertificateChainFile /etc/httpd/ssl/secret.cer SSLCertificateFile/etc/httpd/ssl/certificate.pem SSLCertificateKeyFile /etc/httpd/ssl/certificate.key AddDefaultCharset UTF-8 ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/ DocumentRoot /opt/rt4/share/html Location / Order allow,deny Allow from all Options +ExecCGI AddHandler fastcgi-script fcgi /Location /VirtualHost — Kind Regards, Sidsel Jensen
[rt-users] change login page lang
Thanks...But I have a new problem I have edited the word quot;usernamequot; in login.html file to persian language quot; نام کاربری quot; and it work correctly but my problem is this that when I enter incorrect username or password , the persian words such as quot; نام کاربری quot; is shown illegible. What I have to do?Thanks for your attention
[rt-users] Add Values from a textarea to another
Hi
I have problem with a template that creates a child ticket, right now it
looks like this
===Create-Ticket: New Equipment Network
Subject: { $Tickets{'TOP'}-Subject( ) } -
{$Tickets{'TOP'}-FirstCustomFieldValue('ICM Object Type');} :
#[{$Tickets{'TOP'}-Id( )}]
Queue: ICM Network
RefersTo: { $Tickets{'TOP'}-Id( ) }
DependedOnBy: { $Tickets{'TOP'}-Id( ) }
Request Type: { $Tickets{'TOP'}-FirstCustomFieldValue('Request Type');}
Request Area: { $Tickets{'TOP'}-FirstCustomFieldValue('Request Area');}
Request Action: { $Tickets{'TOP'}-FirstCustomFieldValue('Request Action');}
Request Content: { $Tickets{'TOP'}-FirstCustomFieldValue('Request
Content');}
Content: New equipment requested.
The problem is on my custom field Request Content.
Request Content is a textarea that have text like this
Type: 48V
Object ID: rect-4520
Position: 00*425*04/12
...
But when the child ticket is created only the first row added to the
textarea in this case Type: 48V
all the other text is removed
Is there someone who kowns what i´m doing wrong?
Best regards
John
--
View this message in context:
http://requesttracker.8502.n7.nabble.com/Add-Values-from-a-textarea-to-another-tp59564.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] use customFields extracted by ExtractCustomFieldValues in creation mail
On 02/06/2015 07:02 PM, Kenneth Crocker wrote:
Arnaud,
You need to make sure the scrips are running in the right sequence. You
do this by setting the execution to transaction batch and give them
names that ensure the correct sequence.
Thanks Kenneth, took me a while to find how to put a scrip in
transactionbatch mode, but it works!
Arnaud
Kenn
Sent from my Windows PhoneFrom: Arnaud Abélard
Sent: 2/6/2015 8:29 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] use customFields extracted by
ExtractCustomFieldValues in creation mail
Hello,
I have a working instance of RT 4.2.9. Everything has been running as
expected for years (started with RT 3.8). I have a few queues that use
custom fields. Upon the creation of a new ticket, a mail is sent to the
queue administrator with the list of the queue's custom fields and their
value and the body of the ticket. This works well when the ticket is
created from RT.
Now, I have been trying to use the ExtractCustomFieldValues extension to
extract my custom fields from an email. That actually works. The custom
fields are set properly in the ticket but in the mail sent to the queue
admins, the custom fields value are missing.
In my template (which works fine when the ticket is created from RT) I
used the following code:
{
my $res = ;
my $customFields = = ;
while ( my $customField = $customFields-Next) {
$res.= $customField-Name.:
.$Ticket-FirstCustomFieldValue($customField-Name).\n;
}
$res;
}
I am also sure that my extractCustomField scrip is being executed
_before_ my oncreation scrip (scrip #50 is my extractcustomvalue scrip
and scrip #15 my oncreation sent mail to queue admins:
Feb 6 17:14:21 rt4 RT: [19913] Committing scrip #50 on txn #90275 of
ticket #3782 (/opt/rt4/sbin/../lib/RT/Scrips.pm:306)
...
Feb 6 17:14:21 rt4 RT: [19913] CustomFieldValue (Numéro de porte,123)
added: 5355 Numéro de porte 123 added
...
Feb 6 17:14:21 rt4 RT: [19913] CustomFieldValue (UMR,915) added: 5356
UMR 915 added
...
Feb 6 17:14:21 rt4 RT: [19913] CustomFieldValue (Numéro de
téléphone,123) added: 5357 Numéro de téléphone 123 added
...
Feb 6 17:14:21 rt4 RT: [19913] Committing scrip #15 on txn #90275 of
ticket #3782 (/opt/rt4/sbin/../lib/RT/Scrips.pm:306)
Feb 6 17:14:21 rt4 RT: [19913] Calling SetRecipientDigests for
transaction RT::Transaction=HASH(0x7f91d5eadf40), id 90275
(/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:623)
...
The log confirms the customfield are set before the mail is sent so why
aren't the values set when queried from my template?
Thanks in advance,
Arnaud Abélard
--
Arnaud Abélard (jabber: arnaud.abel...@univ-nantes.fr)
Administrateur Système - Responsable Services Web
Direction des Systèmes d'Informations
Université de Nantes
-
ne pas utiliser: trapem...@univ-nantes.fr
Re: [rt-users] change login page lang
You are not supposed to modify the string username in login.html directly. instead, you could make use of RT's i18n function to choose the language you want, the easiest way is changing browser's language settings. Regards sunnavy On Feb 9, 2015, at 5:24 PM, Shahab Sharifzadeh sshgu...@ymail.com wrote: Thanks...But I have a new problem I have edited the word username in login.html file to persian language نام کاربری and it work correctly but my problem is this that when I enter incorrect username or password , the persian words such as نام کاربری is shown illegible. What I have to do?Thanks for your attention From: Shahab Sharifzadeh sshgu...@ymail.com; To: sunn...@bestpractical.com; Subject: Re: [rt-users] change login page lang Sent: Thu, Feb 5, 2015 10:44:02 PM Thanks... But I have a new problem I have edited the word username in login.html file to persian language نام کاربری and it work correctly but my problem is this that when I enter incorrect username or password , the persian words such as نام کاربری is shown illegible. What I have to do? Thanks for your attention -- On Thu, Feb 5, 2015 3:32 PM IRST sunnavy wrote: Hi Shahab The language on login page respects your browser settings, so you can set your _browser_ language to fr to achieve it. Regards sunnavy On Feb 5, 2015, at 7:45 AM, Shahab Sharifzadeh sshgu...@ymail.com wrote: hi login page language in RT is EN by default. how i can change default language in login page? for example: fr.po
[rt-users] rt-shredder problems
Hello! i have a cron job which purges deleted tickets if they are older than 6 month. this worked for quite a long time but for a week I get an error message Tickets will be deleted nevertheless. I also ran rt-validator. Message: Couldn't wipeout object: Can't call method IsLocal on an undefined value at /opt/rt4/sbin/../lib/RT/URI.pm line 262. This is my cmd line: /opt/rt4/sbin/rt-shredder --force --sqldump /tmp/backup.ticket6 --plugin Tickets=query,Status ='deleted' AND LastUpdated '-6 Month';limit,100 Any idea what is going wrong regards Sven Sternberger System Engineer Tel.: 040/8998-4397 DESY IT
Re: [rt-users] Upgrade fail
Here is the upgrade error in full. mysql -u root -p create database rt4; quit; git clone git://github.com/bestpractical/rt.git -b stable cd rt autoconf ./configure configure.log sudo make fixdeps fixdeps.log make testdeps testdeps.log sudo make upgrade upgrade.log 21 mysql -u root -p rt4 ../../rtbackup.sql cat EOF | sudo tee /opt/rt4/etc/RT_SiteConfig.pm Set( \$DatabaseRequireSSL, '' ); Set( \$DatabaseType, 'mysql' ); Set( \$CommentAddress, '**hidden**' ); Set( \$CorrespondAddress, '**hidden**' ); Set( \$DatabaseHost, 'localhost' ); Set( \$DatabaseName, 'rt4' ); Set( \$DatabasePassword, '**hidden**' ); Set( \$DatabasePort, '' ); Set( \$DatabaseUser, 'rt_user' ); Set( \$Organization, 'public.laserlinc.com' ); Set( \$OwnerEmail, '**hidden**' ); Set( \$SendmailPath, '/usr/sbin/sendmail' ); Set( \$WebDomain, 'public.laserlinc.com' ); Set( \$WebPort, '80' ); Set( \$rtname, 'public.laserlinc.com' ); Set( \$WebPath, /rt ); 1; EOF sudo make upgrade-database 21 | tee upgrade-database.log The outputs are attached. ~Joshua On Fri, Feb 6, 2015 at 3:44 PM, Joshua Lansford joshua.lansf...@laserlinc.com wrote: Upgrading in stages did solve the problem. I downloaded version 3.9.7 which is the version Lifecycle was introduced. Upgrading using this version and then upgrading using the latest version of the code completed without errors. From the log I believe I am now on 4.2.10. I'll back up and restore the unupgraded database to reproduce the complete error message. ~Joshua /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost (port '') as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Port: Name: rt4 User: rt_user DBA: root Enter RT version you're upgrading from: * There are upgrades for 4.2.10, which is later than 4.2.10rc1, * which you are nominally upgrading to. Upgrading to 4.2.10 instead. Going to apply following upgrades: * 3.9.1 * 3.9.2 * 3.9.3 * 3.9.5 * 3.9.6 * 3.9.7 * 3.9.8 * 4.0.0rc2 * 4.0.0rc4 * 4.0.0rc7 * 4.0.1 * 4.0.3 * 4.0.4 * 4.0.6 * 4.0.9 * 4.0.12 * 4.0.13 * 4.0.18 * 4.0.19 * 4.1.0 * 4.1.1 * 4.1.4 * 4.1.5 * 4.1.6 * 4.1.7 * 4.1.8 * 4.1.9 * 4.1.10 * 4.1.11 * 4.1.12 * 4.1.13 * 4.1.14 * 4.1.15 * 4.1.16 * 4.1.17 * 4.1.18 * 4.1.19 * 4.1.20 * 4.1.21 * 4.1.22 * 4.1.23 * 4.2.1 * 4.2.2 * 4.2.4 * 4.2.6 * 4.2.7 * 4.2.8 * 4.2.10 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:Processing 3.9.1 [31689] [Mon Feb 9 13:11:50 2015] [info]: Using internal Perl HTML - text conversion (/home/user/temp/rt/sbin/../lib/RT/Interface/Email.pm:1817) [31689] [Mon Feb 9 13:11:50 2015] [warning]: DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. (/usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm:635) [31689] [Mon Feb 9 13:11:50 2015] [critical]: DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. (/home/user/temp/rt/sbin/../lib/RT.pm:388) DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. make: *** [upgrade-database] Error 255 /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql --with-fastcgi perl: =5.10.1(5.18.2) ...found users: rt group (www-data) ...found bin owner (root) ...found libs owner (root) ...found libs group (bin) ...found web owner (www-data) ...found web group (www-data) ...found CLI dependencies: Term::ReadKey ...found LWP ...found Text::ParseWords ...found HTTP::Request::Common ...found Getopt::Long = 2.24 ...found Term::ReadLine ...found CORE dependencies: Devel::StackTrace = 1.19 ...found LWP::Simple ...found File::Spec = 0.8 ...found Email::Address = 1.897 ...found Text::Password::Pronounceable ...found List::MoreUtils ...found Sys::Syslog = 0.16 ...found Date::Extract = 0.02 ...found Module::Versions::Report = 1.05 ...found Apache::Session = 1.53 ...found DBIx::SearchBuilder = 1.65 ...found DateTime = 0.44 ...found DBI = 1.37 ...found DateTime::Format::Natural = 0.67 ...found HTML::Entities ...found Email::Address::List = 0.02 ...found Errno ...found HTML::Quoted ...found Mail::Header = 2.12 ...found Scalar::Util ...found Date::Manip ...found UNIVERSAL::require ...found CGI::PSGI = 0.12 ...found Regexp::IPv6 ...found CGI::Emulate::PSGI ...found XML::RSS = 1.05 ...found Devel::GlobalDestruction ...found Class::Accessor = 0.34 ...found Locale::Maketext::Fuzzy = 0.11 ...found Crypt::Eksblowfish
Re: [rt-users] Upgrade fail
Trying that again with .txt attachments to prevent mail list scrubbing. On Mon, Feb 9, 2015 at 8:17 AM, Joshua Lansford joshua.lansf...@laserlinc.com wrote: Here is the upgrade error in full. mysql -u root -p create database rt4; quit; git clone git://github.com/bestpractical/rt.git -b stable cd rt autoconf ./configure configure.log sudo make fixdeps fixdeps.log make testdeps testdeps.log sudo make upgrade upgrade.log 21 mysql -u root -p rt4 ../../rtbackup.sql cat EOF | sudo tee /opt/rt4/etc/RT_SiteConfig.pm Set( \$DatabaseRequireSSL, '' ); Set( \$DatabaseType, 'mysql' ); Set( \$CommentAddress, '**hidden**' ); Set( \$CorrespondAddress, '**hidden**' ); Set( \$DatabaseHost, 'localhost' ); Set( \$DatabaseName, 'rt4' ); Set( \$DatabasePassword, '**hidden**' ); Set( \$DatabasePort, '' ); Set( \$DatabaseUser, 'rt_user' ); Set( \$Organization, 'public.laserlinc.com' ); Set( \$OwnerEmail, '**hidden**' ); Set( \$SendmailPath, '/usr/sbin/sendmail' ); Set( \$WebDomain, 'public.laserlinc.com' ); Set( \$WebPort, '80' ); Set( \$rtname, 'public.laserlinc.com' ); Set( \$WebPath, /rt ); 1; EOF sudo make upgrade-database 21 | tee upgrade-database.log The outputs are attached. ~Joshua On Fri, Feb 6, 2015 at 3:44 PM, Joshua Lansford joshua.lansf...@laserlinc.com wrote: Upgrading in stages did solve the problem. I downloaded version 3.9.7 which is the version Lifecycle was introduced. Upgrading using this version and then upgrading using the latest version of the code completed without errors. From the log I believe I am now on 4.2.10. I'll back up and restore the unupgraded database to reproduce the complete error message. ~Joshua /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost (port '') as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Port: Name: rt4 User: rt_user DBA:root Enter RT version you're upgrading from: * There are upgrades for 4.2.10, which is later than 4.2.10rc1, * which you are nominally upgrading to. Upgrading to 4.2.10 instead. Going to apply following upgrades: * 3.9.1 * 3.9.2 * 3.9.3 * 3.9.5 * 3.9.6 * 3.9.7 * 3.9.8 * 4.0.0rc2 * 4.0.0rc4 * 4.0.0rc7 * 4.0.1 * 4.0.3 * 4.0.4 * 4.0.6 * 4.0.9 * 4.0.12 * 4.0.13 * 4.0.18 * 4.0.19 * 4.1.0 * 4.1.1 * 4.1.4 * 4.1.5 * 4.1.6 * 4.1.7 * 4.1.8 * 4.1.9 * 4.1.10 * 4.1.11 * 4.1.12 * 4.1.13 * 4.1.14 * 4.1.15 * 4.1.16 * 4.1.17 * 4.1.18 * 4.1.19 * 4.1.20 * 4.1.21 * 4.1.22 * 4.1.23 * 4.2.1 * 4.2.2 * 4.2.4 * 4.2.6 * 4.2.7 * 4.2.8 * 4.2.10 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:Processing 3.9.1 [31689] [Mon Feb 9 13:11:50 2015] [info]: Using internal Perl HTML - text conversion (/home/user/temp/rt/sbin/../lib/RT/Interface/Email.pm:1817) [31689] [Mon Feb 9 13:11:50 2015] [warning]: DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. (/usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm:635) [31689] [Mon Feb 9 13:11:50 2015] [critical]: DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. (/home/user/temp/rt/sbin/../lib/RT.pm:388) DBD::mysql::db selectcol_arrayref failed: Unknown column 'main.Lifecycle' in 'field list' at /usr/local/share/perl/5.18.2/DBIx/SearchBuilder.pm line 635. make: *** [upgrade-database] Error 255 /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql --with-fastcgi perl: =5.10.1(5.18.2) ...found users: rt group (www-data) ...found bin owner (root) ...found libs owner (root) ...found libs group (bin) ...found web owner (www-data) ...found web group (www-data) ...found CLI dependencies: Term::ReadKey ...found LWP ...found Text::ParseWords ...found HTTP::Request::Common ...found Getopt::Long = 2.24 ...found Term::ReadLine ...found CORE dependencies: Devel::StackTrace = 1.19 ...found LWP::Simple ...found File::Spec = 0.8 ...found Email::Address = 1.897 ...found Text::Password::Pronounceable ...found List::MoreUtils ...found Sys::Syslog = 0.16 ...found Date::Extract = 0.02 ...found Module::Versions::Report = 1.05 ...found Apache::Session = 1.53 ...found DBIx::SearchBuilder = 1.65 ...found DateTime = 0.44 ...found DBI = 1.37 ...found DateTime::Format::Natural = 0.67 ...found HTML::Entities ...found
