[rt-users] rt::extension::import::csv Configuration isseu
Hi, I have the RT::extension::import::CSV working but having a problem with importing in the field "Held By". Getting the error: [warning]: Unknown asset field Held By for column Assigned User, skipping (/opt/rt/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/Import/CSV.pm:66) Below is my configuration in the RT_SiteConfig.pm Set( $AssetsImportUniqueCF, 'Serial Number' ); Set( %AssetsImportFieldMapping, 'Name' => 'System Name', 'Catalog' => \'Neuro Hardware', 'Owner' => \'Neurology', 'Held By' => 'Assigned User', 'Contact' => \'neurolog...@urmc.rochester.edu', 'CF.Manufacturer' => 'Make', 'CF.Model' => 'Model', 'CF.Neuro IT SN #'=> 'Neuro IT Tag', 'CF.Serial Number' => 'Serial Number', 'CF.OS' => 'OS', 'CF.Location'=> 'Location', 'CF.Division' => 'Division', 'CF.Asset Tag'=> 'Asset Tag', 'CF.Notes' => 'Notes', ); Wondering how I can define the Held By name so it is recognized /rt-assets-import-csv? Thanks B Barrett University of Rochester Medical Center
Re: [rt-users] [phish?] RE: No outbound email after upgrade
On Tue, Aug 25, 2015 at 3:39 PM, Ditri, Chris wrote: > > > From: Matt Zagrabelny > Sent: Tuesday, August 25, 2015 2:55 PM > To: Ditri, Chris > Cc: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] No outbound email after upgrade > > On Tue, Aug 25, 2015 at 1:43 PM, Ditri, Chris wrote: >> Hi Matt, >> >> There is absolutely nothing in ObjectScrips, and everything is set to NULL >> in Scrips (in the database). >> >> Are you implying that I need to make custom scrips to send routine emails >> regarding tickets? >> Something is different then... I definitely didn't have to do that before... >> must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 >> with Jessie). Was it normal to lose that functionality in the upgrade? > > Certainly not normal. > > You do need to run some upgrade commands (DB scripts) when upgrading > though. The (upstream) upgrade will normally prompt you for what > version of RT you are upgrading from and which one you are upgrading > to. Do you remember seeing that? > > For the RT 3.8 Debian package, there was a directory, > /etc/request-tracker3.8/etc/upgrade. Do you have something similar for > RT 4(.2) ? > > 3.8 was the last time I used the deb package for RT, and I don't > remember what the upgrades were like - I'd imagine it also varies > depending on if you use db-config or not. We use Debian for the OS, > but use upstream tarballs for the RT installation. There is a make > target that handles applying the DB upgrade scripts. > > Cheers, > > -m > > > Now that you mention it, Matt, there was an issue with dbconfig-common. It > didn't want to take the root password for the the database. Eventually I got > it to go through, but there were some errors. I found a log for > dbconfig-common... but I honestly don't know why it goofed up, and how tor > re-run dbconfig common for rt. I don't know anything about dbconfig-common. I generally stay away from it, but perhaps it is useful in certain circumstances. You could always file a Debian bug against the package if it broke during upgrades. Dom is a very good maintainer. > Here is the log I found in /var/log/dbconfig-common: > > RROR 2002 (HY000): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2). > unable to connect to mysql server. > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2). > unable to connect to mysql server. > granting access to database rtdb for rtuser@localhost: success. > verifying access for rtuser@localhost: success. > creating database rtdb: success. > verifying database rtdb exists: success. > populating database via scriptfile... done. > dbconfig-common: dumping mysql database rtdb to > /var/tmp/request-tracker4.rtdb.2013-12-16-14.45.mysql.q3wmxz. > dbconfig-common: dropping mysql database rtdb. > dropping database rtdb: success. > verifying database rtdb was dropped: success. > dbconfig-common: revoking privileges for user rtuser on rtdb. > revoking access to database rtdb from rtuser@localhost: success. > granting access to database rtdb for rtuser@localhost: success. > verifying access for rtuser@localhost: success. > creating database rtdb: success. > verifying database rtdb exists: success. > populating database via scriptfile... done. > creating database backup in > /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES). > unable to connect to mysql server. > creating database backup in > /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES). > unable to connect to mysql server. > creating database backup in > /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES). > unable to connect to mysql server. > creating database backup in > /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES). > unable to connect to mysql server. > creating database backup in > /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES). > unable to connect to mysql server. > creating database backup in > /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. > applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.10. > applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.12. > applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.12-2. > applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.19. > applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.3. > applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.4. > applying upgrade
Re: [rt-users] No outbound email after upgrade
From: Matt Zagrabelny Sent: Tuesday, August 25, 2015 2:55 PM To: Ditri, Chris Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] No outbound email after upgrade On Tue, Aug 25, 2015 at 1:43 PM, Ditri, Chris wrote: > Hi Matt, > > There is absolutely nothing in ObjectScrips, and everything is set to NULL in > Scrips (in the database). > > Are you implying that I need to make custom scrips to send routine emails > regarding tickets? > Something is different then... I definitely didn't have to do that before... > must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 > with Jessie). Was it normal to lose that functionality in the upgrade? Certainly not normal. You do need to run some upgrade commands (DB scripts) when upgrading though. The (upstream) upgrade will normally prompt you for what version of RT you are upgrading from and which one you are upgrading to. Do you remember seeing that? For the RT 3.8 Debian package, there was a directory, /etc/request-tracker3.8/etc/upgrade. Do you have something similar for RT 4(.2) ? 3.8 was the last time I used the deb package for RT, and I don't remember what the upgrades were like - I'd imagine it also varies depending on if you use db-config or not. We use Debian for the OS, but use upstream tarballs for the RT installation. There is a make target that handles applying the DB upgrade scripts. Cheers, -m Now that you mention it, Matt, there was an issue with dbconfig-common. It didn't want to take the root password for the the database. Eventually I got it to go through, but there were some errors. I found a log for dbconfig-common... but I honestly don't know why it goofed up, and how tor re-run dbconfig common for rt. Here is the log I found in /var/log/dbconfig-common: RROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). unable to connect to mysql server. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). unable to connect to mysql server. granting access to database rtdb for rtuser@localhost: success. verifying access for rtuser@localhost: success. creating database rtdb: success. verifying database rtdb exists: success. populating database via scriptfile... done. dbconfig-common: dumping mysql database rtdb to /var/tmp/request-tracker4.rtdb.2013-12-16-14.45.mysql.q3wmxz. dbconfig-common: dropping mysql database rtdb. dropping database rtdb: success. verifying database rtdb was dropped: success. dbconfig-common: revoking privileges for user rtuser on rtdb. revoking access to database rtdb from rtuser@localhost: success. granting access to database rtdb for rtuser@localhost: success. verifying access for rtuser@localhost: success. creating database rtdb: success. verifying database rtdb exists: success. populating database via scriptfile... done. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). unable to connect to mysql server. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). unable to connect to mysql server. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). unable to connect to mysql server. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). unable to connect to mysql server. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). unable to connect to mysql server. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.10. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.12. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.12-2. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.19. applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.3. applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.4. applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.6. applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.7. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.10. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.12. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.12-2. applying upgrade script for 4.0.7-5+deb7u3 -> 4.0.19. applying upgrade script for 4.0.7-5+deb7u3 -> 4.2.3. creating database backup in /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql. applying upgrade script f
Re: [rt-users] No outbound email after upgrade
On Tue, Aug 25, 2015 at 1:43 PM, Ditri, Chris wrote: > Hi Matt, > > There is absolutely nothing in ObjectScrips, and everything is set to NULL in > Scrips (in the database). > > Are you implying that I need to make custom scrips to send routine emails > regarding tickets? > Something is different then... I definitely didn't have to do that before... > must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 > with Jessie). Was it normal to lose that functionality in the upgrade? Certainly not normal. You do need to run some upgrade commands (DB scripts) when upgrading though. The (upstream) upgrade will normally prompt you for what version of RT you are upgrading from and which one you are upgrading to. Do you remember seeing that? For the RT 3.8 Debian package, there was a directory, /etc/request-tracker3.8/etc/upgrade. Do you have something similar for RT 4(.2) ? 3.8 was the last time I used the deb package for RT, and I don't remember what the upgrades were like - I'd imagine it also varies depending on if you use db-config or not. We use Debian for the OS, but use upstream tarballs for the RT installation. There is a make target that handles applying the DB upgrade scripts. Cheers, -m
Re: [rt-users] No outbound email after upgrade
Hi Matt, There is absolutely nothing in ObjectScrips, and everything is set to NULL in Scrips (in the database). Are you implying that I need to make custom scrips to send routine emails regarding tickets? Something is different then... I definitely didn't have to do that before... must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 with Jessie). Was it normal to lose that functionality in the upgrade? I have never messed with Scrips before... not sure I understand them. Is there a good resource on the subject? Thank you. From: Matt Zagrabelny Sent: Tuesday, August 25, 2015 12:52 PM To: Ditri, Chris Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] No outbound email after upgrade On Tue, Aug 25, 2015 at 11:46 AM, Ditri, Chris wrote: > Ok... > > After turning the debugging, I captured this from the log: > > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for > text/html - Subjectless message > (/usr/share/request-tracker4/lib/RT/I18N.pm:295) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for > text/html - Subjectless message > (/usr/share/request-tracker4/lib/RT/I18N.pm:295) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to prepare scrips for > transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:187) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for > TransactionCreate stage with applicable type(s) Correspond for txn #8404 on > ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to commit scrips for > transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:210) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for > TransactionBatch stage with applicable type(s) Correspond for txn #8404 on > ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4484 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4486 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4488 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4490 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4492 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4495 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4497 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4499 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4504 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4506 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4508 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4510 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4512 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4514 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4516 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4518 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > > > It says it didn't find a script for transaction batch and for transaction > create... Makes me wonder if I'm missing a package? Not a package. Check your DB or your admin web interface. SELECT * from objectscrips; SELECT * from scrips; The objectscrips is h
Re: [rt-users] RT-Extension-Assets : Howto change Elements/MyAssets to show assets for all users
We at Reed recently sponsored an updated version of Assets, which allows for ticket-like asset searching, and saved asset searches. You'd be able to build a saved search that displays all assets in a catalog, with custom display formatting to boot. This is in version 1.06, but it doesn't appear to be posted yet on BP's website. So my suggestion: hold on for a bit, it's coming. Tony On Tue, Aug 25, 2015 at 7:35 AM, Carl van Litsenborgh < carl.vanlitsenbo...@za.saabgroup.com> wrote: > Hi, > > > > How can I change/modify either Elements/MyAssets OR > User/Elements/AssetList (or both) to show assets for ALL users, and not > only the logged-in user? > > > > Any help suggestions would be appreciated. > > > > Thank you. > > > > Carl van Litsenborgh > -- tony.palom...@reed.edu Director, Computer User Services Reed College 503-788-6622
Re: [rt-users] No outbound email after upgrade
On Tue, Aug 25, 2015 at 11:46 AM, Ditri, Chris wrote: > Ok... > > After turning the debugging, I captured this from the log: > > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for > text/html - Subjectless message > (/usr/share/request-tracker4/lib/RT/I18N.pm:295) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for > text/html - Subjectless message > (/usr/share/request-tracker4/lib/RT/I18N.pm:295) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to prepare scrips for > transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:187) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for > TransactionCreate stage with applicable type(s) Correspond for txn #8404 on > ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to commit scrips for > transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:210) > [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for > TransactionBatch stage with applicable type(s) Correspond for txn #8404 on > ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4484 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4486 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4488 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4490 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4492 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4495 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4497 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4499 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4504 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4506 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4508 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4510 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4512 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4514 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4516 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4518 of > 'text/html' type > (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) > > > It says it didn't find a script for transaction batch and for transaction > create... Makes me wonder if I'm missing a package? Not a package. Check your DB or your admin web interface. SELECT * from objectscrips; SELECT * from scrips; The objectscrips is how scrips can be selectively applied to individual queues. -m
Re: [rt-users] No outbound email after upgrade
Ok... After turning the debugging, I captured this from the log: [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for text/html - Subjectless message (/usr/share/request-tracker4/lib/RT/I18N.pm:295) [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for text/html - Subjectless message (/usr/share/request-tracker4/lib/RT/I18N.pm:295) [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to prepare scrips for transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:187) [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for TransactionCreate stage with applicable type(s) Correspond for txn #8404 on ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495) [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to commit scrips for transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:210) [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for TransactionBatch stage with applicable type(s) Correspond for txn #8404 on ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4484 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4486 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4488 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4490 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4492 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4495 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4497 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4499 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4504 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4506 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4508 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4510 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4512 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4514 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4516 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4518 of 'text/html' type (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182) It says it didn't find a script for transaction batch and for transaction create... Makes me wonder if I'm missing a package? Here is what aptitude says I have installed (and what's available): p rt-app - Test application which simulates a real-ti p rt-tests- Test programs for rt kernels i rt4-apache2 - Apache 2 specific files for request-tracke i A rt4-clients - mail gateway and command-line interface to i rt4-db-mysql- MySQL database backend for request-tracker p rt4-db-postgresql - PostgreSQL database backend for request-tr p rt4-db-sqlite - SQLite database backend for request-tracke p rt4-doc-html- HTML documentation for request-tracker4 i rt4-extension-authenexternalaut - External authentication module for request p rt4-extension-calendar - Calendar view for Request Tracker 4 p rt4-extension-customfieldsonupd - edit ticket's custom fields on reply/comme p rt4-extension-jsgantt - Gantt charts for Request Tracker p rt4-extension-spawnlinkedticket - quickly spawn linked tickets in diff
Re: [rt-users] No outbound email after upgrade
HI Again, Yes, I'm using debian. No, I haven't put it in my RT_SiteConfig.d directory because I don't want to lose track of the settings. When the config is good, I will move them into the appropriate file and re-execute my update update-rt-siteconfig-4. I'm trying to keep the debris out of my configs. It only reads RT_SiteConfig.pm, so I don't see any harm in this strategy. I have set the logging on, thank you for that... lets hope it dumps some useful info! Thanks again. From: Matt Zagrabelny Sent: Tuesday, August 25, 2015 11:13 AM To: Ditri, Chris Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] No outbound email after upgrade On Tue, Aug 25, 2015 at 10:00 AM, Ditri, Chris wrote: > Hi Matt, and thanks for your response. > > I have tried this. It still produces nothing. Here is what I added to my > RT_SiteConfig.pm: > > Set($MailCommand, "mbox"); > Set($SendmailPath, "/usr/lib/sendmail"); > Set($SendmailArguments, "-t"); > Set($OwnerEmail, "m...@workplace.com"); > > > I have also tried: > Set($MailCommand, "sendmailpipe"); > Set($MailCommand, "smtp"); > Set($MailCommand, "sendmail"); > Set($MailCommand, "test"); > > I do a '/etc/init.d/request-tracker4 restart' after each, and even try > rebooting. No good. > > I'm sure I'm missing something silly here... but I just don't know what it > is... > > Any other suggestions? It looks like you are using Debian. Are you using the SiteConfig.d directory and running update-rt-siteconfig before restarting apache? Other things you could try: Set($LogStackTraces, 'debug'); Set($LogToSTDERR, 'debug'); then check the apache error log (/var/log/apache2/error.log) for output. -m
Re: [rt-users] Problem with extension RepeatTicket
Hmmm... I'm unsure what is causing that for you. When I open a console window and run the 'daily' command on it's own ("/usr/local/share/request-tracker4/plugins/RT-Extension-RepeatTicket/bin/rt-repeat-ticket --type daily") then ALL daily recurrence tickets get repeated, regardless of the day of the week I have chosen on the Ticket Recurrence tab. The same happens for the 'weekly' 'monthly' & 'yearly' commands when dealing with 'weekly', 'monthly' & 'yearly' recurrence tickets. This is why I created the 4 cronjobs - to workaround the fact that individual recurrence settings were actually being ignored. The cronjobs are *supposed* to separately target each of the 4 types of recurrence ticket. They are timed for the start of the day/week/month/year and /should/ only fire for the relevant type of recurrence. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Problem-with-extension-RepeatTicket-tp60471p60522.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] No outbound email after upgrade
On Tue, Aug 25, 2015 at 10:00 AM, Ditri, Chris wrote: > Hi Matt, and thanks for your response. > > I have tried this. It still produces nothing. Here is what I added to my > RT_SiteConfig.pm: > > Set($MailCommand, "mbox"); > Set($SendmailPath, "/usr/lib/sendmail"); > Set($SendmailArguments, "-t"); > Set($OwnerEmail, "m...@workplace.com"); > > > I have also tried: > Set($MailCommand, "sendmailpipe"); > Set($MailCommand, "smtp"); > Set($MailCommand, "sendmail"); > Set($MailCommand, "test"); > > I do a '/etc/init.d/request-tracker4 restart' after each, and even try > rebooting. No good. > > I'm sure I'm missing something silly here... but I just don't know what it > is... > > Any other suggestions? It looks like you are using Debian. Are you using the SiteConfig.d directory and running update-rt-siteconfig before restarting apache? Other things you could try: Set($LogStackTraces, 'debug'); Set($LogToSTDERR, 'debug'); then check the apache error log (/var/log/apache2/error.log) for output. -m
Re: [rt-users] No outbound email after upgrade
Hi Matt, and thanks for your response. I have tried this. It still produces nothing. Here is what I added to my RT_SiteConfig.pm: Set($MailCommand, "mbox"); Set($SendmailPath, "/usr/lib/sendmail"); Set($SendmailArguments, "-t"); Set($OwnerEmail, "m...@workplace.com"); I have also tried: Set($MailCommand, "sendmailpipe"); Set($MailCommand, "smtp"); Set($MailCommand, "sendmail"); Set($MailCommand, "test"); I do a '/etc/init.d/request-tracker4 restart' after each, and even try rebooting. No good. I'm sure I'm missing something silly here... but I just don't know what it is... Any other suggestions? Thank you. From: Matt Zagrabelny Sent: Friday, August 21, 2015 4:05 PM To: Ditri, Chris Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] No outbound email after upgrade On Fri, Aug 21, 2015 at 2:09 PM, Ditri, Chris wrote: > But, it was always able to send emails with no problem through exim, and I > can send emails from the bash command prompt with no problem as well. >From RT_Config.pm: $MailCommand $MailCommand defines which method RT will use to try to send mail. We know that 'sendmailpipe' works fairly well. If 'sendmailpipe' doesn't work well for you, try 'sendmail'. 'qmail' is also a supported value. For testing purposes, or to simply disable sending mail out into the world, you can set $MailCommand to 'mbox' which logs all mail, in mbox format, to files in /opt/rt4/var/ based in the process start time. The 'testfile' option is similar, but the files that it creates (under /tmp) are temporary, and removed upon process completion; the format is also not mbox-compatable. Perhaps try setting MailCommand to mbox or testfile. -m
[rt-users] RT-Extension-Assets : Howto change Elements/MyAssets to show assets for all users
Hi, How can I change/modify either Elements/MyAssets OR User/Elements/AssetList (or both) to show assets for ALL users, and not only the logged-in user? Any help suggestions would be appreciated. Thank you. Carl van Litsenborgh
[rt-users] Prevent ticket creation by email
Dear all, I have a queue which has some mandatory custom fields. I wish to prevent ticket creation by email for this queue (and not any other queues) but still allow communication between requestor and owner by email once the ticket has been created. Is this possible? The users will be creating tickets in this queue using SelfService. If this cannot be done, but instead the email returned with a message stating what to do (ie login to SelfService) then that is fine too. We are using RT 3.8.8. Thanks, Matt.
Re: [rt-users] System switched to Install screen
Hi Joop, I was thinking that too and therefore even gave permissions to all. Didn’t work either. This morning I tried again and everything all of the sudden is working again. I have not the slightest idea what was going on. In any case, thanks for your answer. I will keep an eye on the installation Kind regards Felix On Aug 25, 2015, at 2:05 AM, Joop van de Wege wrote: Felix Bachmann schreef op 25 augustus 2015 01:04:29 CEST: > Hi all, > I am hoping to get some hints for you. I was running version 4.2.4 for > a long time. Today I had some issues with the mysql database server and > after restart RT is always switching to the install screen as if it > doesn’t find the database. It looks like apache can't access rt_siteconfig.pm. Joop
Re: [rt-users] Problem with extension RepeatTicket
thx for helping, i changed the cronjobs like you said yesterday, but today i'm still getting tickets from monday or for example friday. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Problem-with-extension-RepeatTicket-tp60471p60516.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] no To: field leads to "RFC compliant TO required" mail server error
Hello everyone. I have upgraded RT system, with following changes: FreeBSD 6.2 -> 10.1 RT 3.8.8 -> 4.2.11 Postfix 2.4.6 -> Exim 4.85 On the new system i'm having error in mail system "RFC compliant TO required" when RT tries to send mails about my comments on mine ticket. As far as i understand the logic behind, RT compose email with ticket's author email in To: header, and all other queue's followers in Cc: header, then see that it's me, the comment's author, is in To: header, and configured for not sending me email about my own comment, strips my email and effectively entire To: header from email. Then there is a difference between old and new system: on the old system everything was exactly the same as on the new system (according to email headers in rt.log), but emails without To: header somehow were delivered to all Cc: addresses, but on the new system i get this error. Logs from the old system: http://pastebin.com/mUJzFg2m (there is "To: v...@zato.ru" header in the beginning, and then it's gone) Logs from the new system: http://pastebin.com/2PykYK71 (same with "To: l...@zato.ru") Emails from the old system have To: header with "undisclosed-recipients:;" in it. Emails from the new system, according to Mailer-Daemon messages, have not. I think that maybe the old system's Postfix mail server inserting To: undisclosed-recipients:; header. I've tried to install and use new version of Postfix 2.11.6 with no changes - emails still doesn't delivered. To overcome this situation i have configured Exim with the following ACL: acl_check_data: warn condition = ${if !def:h_To: {1}} add_header = To: Undisclosed-Recipients:; But i wonder, if there is a better for populating To: header with "undisclosed-recipients:;"? Or maybe there is something i missed in upgrade? I did run rt-setup-database after moving DB to new host, if that's matter. -- best regards