[rt-users] upgrade-assets error
Hello everyone, After I upgrade my RT to 4.4.1 on centos 6. I'm trying to run the assets-upgrade and I'm getting the error below. How do I solve this issue. I remove the plugin from the configuration already. ## ERROR /upgrade-assets Can't locate RT/Interface/CLI.pm in @INC (@INC contains: lib local/lib /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at ./upgrade-assets line 56. BEGIN failed--compilation aborted at ./upgrade-assets line 56. Thank you. David - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Los Angeles - January 9-11 2017
Re: [rt-users] RT CLI CF query operators
Loos,
Thank you for the help but after I rectified the typo. I still getting a
different errors.
rt list -i 'CF.{Modtrak} 0 AND Created = 2015-07-01 AND Created =
2015-07-31'
rt: Invalid query: 'Wrong query, expecting a AGGREGATOR in 'CF.{Modtrak}
0 AND Created ='2015-07-01' AND Created ='--here2015-07-31'' at
/opt/rt4/sbin/../lib/RT/SQL.pm line 130.
Stack:
[/opt/rt4/sbin/../lib/RT/SQL.pm:130]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
[/opt/rt4/share/html/REST/1.0/search/ticket:89]
[/opt/rt4/share/html/REST/1.0/autohandler:54]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
'.
Invalid query: 'Wrong query, expecting a AGGREGATOR in 'CF.{Modtrak} 0
AND Created ='2015-07-01' AND Created ='--here2015-07-31'' at
/opt/rt4/sbin/../lib/RT/SQL.pm line 130.
Stack:
[/opt/rt4/sbin/../lib/RT/SQL.pm:130]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
[/opt/rt4/share/html/REST/1.0/search/ticket:89]
[/opt/rt4/share/html/REST/1.0/autohandler:54]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
Am 26.08.2015 um 21:25 schrieb supp...@pureview.com:
rt list -i 'CF.{Modtrak}' 0 AND Created = '2015-07-01' AND Create =
'2015-07-31'
rt: Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' 0 AND
Created = '2015-07-01' AND Create = '2015-07-31'' at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.
The error message says all.
It's just a typo, the ticket field is called Created and not Create.
Chris
[rt-users] RT CLI CF query operators
RT users,
I trying to use RT CLI on a CF for operators and I having a hard time to
get this working. Can any help on this. I do not know what I'm doing
wrong.
RT: rt.4.2
OS : RH 6.0
rt list -i 'CF.{Modtrak}' 0 AND Created = '2015-07-01' AND Create =
'2015-07-31'
rt: Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' 0 AND
Created = '2015-07-01' AND Create = '2015-07-31'' at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.
Stack:
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2943]
[/opt/rt4/sbin/../lib/RT/SQL.pm:172]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
[/opt/rt4/share/html/REST/1.0/search/ticket:89]
[/opt/rt4/share/html/REST/1.0/autohandler:54]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
'.
Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' 0 AND Created
= '2015-07-01' AND Create = '2015-07-31'' at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.
Stack:
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2943]
[/opt/rt4/sbin/../lib/RT/SQL.pm:172]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
[/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
[/opt/rt4/share/html/REST/1.0/search/ticket:89]
[/opt/rt4/share/html/REST/1.0/autohandler:54]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
[/opt/rt4/share/html/autohandler:53]
[rt-users] rt-crontool error
Help Please, I'm running this crontool line: rt-crontool --search RT::Search::FromSQL --search-arg Queue = 'general' AND Owner != 'Nobody' AND ( Status = 'open' OR Status = 'new' ) AND Created '1 day ago' --action RT::Action::SendEmail --action-arg Owner,AlwaysNotifyActor --template 'Reminder due soon' --transaction first Once is ran. rt log is showing this errors: [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [error]: Template parsing error: Can't call method TargetObj on an undefined value at template line 1. (/opt/rt4/bin/../lib/RT/Template.pm:546) [19375] [Mon Nov 3 06:01:53 2014] [warning]: Too late to safely run transaction-batch scrips! This is typically caused by using ticket objects at the top-level of a script which uses the RT API. Be sure to explicitly undef such ticket objects, or put them inside of a lexical scope. at /opt/rt4/bin/../lib/RT/Ticket.pm line 2587 during global destruction. (/opt/rt4/bin/../lib/RT/Ticket.pm:2587) [19375] [Mon Nov 3 06:01:53 2014] [warning]: Too late to safely run transaction-batch scrips! This is typically caused by using ticket objects at the top-level of a script which uses the RT API. Be sure to explicitly undef such ticket objects, or put them inside of a lexical scope. at /opt/rt4/bin/../lib/RT/Ticket.pm line 2587 during global destruction. (/opt/rt4/bin/../lib/RT/Ticket.pm:2587) [19375] [Mon Nov 3 06:01:53 2014] [warning]: Too late to safely run transaction-batch scrips! This is typically caused by using ticket objects at the top-level of a script which uses the RT API. Be sure to explicitly undef such ticket objects, or put them inside of a lexical scope. at /opt/rt4/bin/../lib/RT/Ticket.pm line 2587 during global destruction. (/opt/rt4/bin/../lib/RT/Ticket.pm:2587) [19375] [Mon Nov 3 06:01:53 2014] [warning]: Too late to safely run transaction-batch scrips! This is typically caused by using ticket objects at the top-level of a script which uses the RT API. Be sure to explicitly undef such ticket objects, or put them inside of a lexical scope. at /opt/rt4/bin/../lib/RT/Ticket.pm line 2587 during global destruction. (/opt/rt4/bin/../lib/RT/Ticket.pm:2587) [19375] [Mon Nov 3 06:01:53 2014] [warning]: Too late to safely run transaction-batch scrips! This is typically caused by using ticket objects at the top-level of a script which uses the RT API. Be sure to explicitly undef such ticket objects, or put them inside of a lexical scope. at /opt/rt4/bin/../lib/RT/Ticket.pm line 2587 during global destruction. (/opt/rt4/bin/../lib/RT/Ticket.pm:2587) (in cleanup) Can't call method _should_log on an undefined value at /usr/local/share/perl5/Log/Dispatch.pm line 247 during global destruction. (in cleanup) Can't call method _should_log on an undefined value at /usr/local/share/perl5/Log/Dispatch.pm line 247 during global destruction. I'm running RT 4.2.1 on Centos 6 Any advise on this error . Thank you, David
[rt-users] add cc on ticket create based on custom field - and a quick selfservice question
1) Users are members of a security group, I was thinking i could create a CF and add the cc user in there and have a scrip to add them as a cc - any ideas or recipes appreciated... We don't run a queue for each customer so I can't just use the queues 2) In selfservice - the history.html link (from the subject) doesn't work - is this a bug, permissions or something i've broken i'm using rt 4.2.6 on debs ? Thanks Dave -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
[rt-users] rt::extension::import::csv docs
Hi guys, Nearly got this to work i've Installed the cpan module - and manually compiled so its now installed fine Added the plugin and configuration to the RT Siteconfig The distribution notes say i should run SYNOPSIS rt-assets-import /path/to/assets.csv HOW? It would be really helpful to create a work-through for this... Thanks for your time Dave -- David Lane Director GoodChoice.IT Ltd We reward successful referrals W: www.goodchoice.it E: d...@goodchoice.it T: 020 8099 5540 -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] [EXTERNAL] rt::extension::import::csv docs
Thanks so much for that Worked perfectly - I owe you a beer! Please try and get this included in the docs! Dave On Tue, Sep 16, 2014 at 5:11 PM, Mervini, Joseph A jame...@sandia.gov wrote: I just went through this same exercise and posed the same question to the list with a similar response. But I was able to get it working through trial and error and my intent is to create a full blown how-to that may or may not get included in the distribution. In the meantime as a simple example, here are the things that you will need to do: 1. If you are using custom fields for your assets, create and enable them via the web interface. 2. Create your csv file. Here is a simple example of what I am using: Name,Description,Status,Type,Model,Serial Number,IP Address,Location,Rack Number myMachine1,Controller,in-use,Dell Server,R720,abc123,192.168.1.1,Building 1,1 myMachine2,Controller,in-use,Dell Server,R720,def456,192.168.1.2,Building 1,1 myMachine3,Controller,in-use,Dell Server,R720,ghi789,192.168.1.3,Building 1,1 3. Create a custom config file. (This is what I did as opposed to adding it to the RT_SiteConfig.pm file) Set( $AssetsImportUniqueCF, undef ); Set( %AssetsImportFieldMapping, 'id' = 'Name', 'Name' = 'Name', 'Catalog' = \'Storage Assets', 'Description' = 'Description', 'Status' = 'Status', 'CF.Type' = 'Type', 'CF.Model' = 'Model', 'CF.Serial Number' = 'Serial Number', 'CF.IP Address' = 'IP Address', 'CF.Location' = 'Location', 'CF.Rack Number' = 'Rack Number' 4. Running the script to populate the database: /opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/bin/rt-assets-import-csv --update ./test1.csv --debug --config config.test1 I added all the switches to see what's happening. I would suggest that you create a test RT instance to play with to get comfortable with the process. Hope this helps. Joe Mervini Sandia National Laboratories High Performance Computing 505.844.6770 jame...@sandia.gov On Sep 16, 2014, at 4:43 AM, David Lane (IT Support) d...@goodchoice.it wrote: Hi guys, Nearly got this to work i've Installed the cpan module - and manually compiled so its now installed fine Added the plugin and configuration to the RT Siteconfig The distribution notes say i should run SYNOPSIS rt-assets-import /path/to/assets.csv HOW? It would be really helpful to create a work-through for this... Thanks for your time Dave -- David Lane Director GoodChoice.IT Ltd We reward successful referrals W: www.goodchoice.it E: d...@goodchoice.it T: 020 8099 5540 -- RT Training - Boston, September 9-10 http://bestpractical.com/training -- David Lane Director GoodChoice.IT Ltd We reward successful referrals W: www.goodchoice.it E: d...@goodchoice.it T: 020 8099 5540 -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Help please ActivityReport extension doesn't work
Help please. Suddenly my Extension ActivityReport stop working. I'm getting: An internal RT error has occurred. Your administrator can find more details in RT's log files. My log file: [24927] [Sat Sep 6 05:27:11 2014] [error]: read_file: could not open file '/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/Wrapper' for reading: Permission denied Any one can give me clue how to fix this issue. I'm running 4.2.1 / RH6 Thank you, David -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Can't call method content on an undefined value at: Activity Report
Any one.. I'm getting this error: [error]: Can't call method content on an undefined value at /usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm line 217 I'm trying to use Activiry Report Here is the entire error: [8836] [Fri Sep 5 00:57:39 2014] [warning]: Use of uninitialized value $_ in pattern match (m//) at /opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ActivityDetail line 31. (/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ActivityDetail:31) [8836] [Fri Sep 5 00:57:40 2014] [warning]: Use of uninitialized value $_ in concatenation (.) or string at /usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm line 211. (/usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm:211) [8836] [Fri Sep 5 00:57:40 2014] [error]: Can't call method content on an undefined value at /usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm line 217. Stack: [/usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm:217] [/usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm:101] [/usr/local/share/perl5/HTML/FormatText/WithLinks/AndTables.pm:83] [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:1777] [/opt/rt4/sbin/../lib/RT/Transaction.pm:348] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ActivityDetail:46] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Search/Elements/ActivityReport:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/index.html:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/Wrapper:10] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/index.html:11] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368] [/opt/rt4/share/html/autohandler:53] (/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm:211) I'm using rt 4.2.1 RedHat Server 6 Thank you in advanced. -David -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] sql custom fields query display
Hi everyone, Someone can help me to sql query a custom field from RT. select tickets.EFFECTIVEID, users.REALNAME, tickets.STATUS, TO_CHAR(tickets.DUE, '/MM/DD'), tickets.SUBJECT from tickets, users where users.NAME = 'felipe' AND tickets.OWNER = 22 AND tickets.STATUS = 'resolved' order by tickets.EFFECTIVEID desc I need to display a custom field I name: Modtrak and Requestor Would any one help on this please. Thank you, -David -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] articles RTFM WYSIWYG
Kevin, Any feedback on RTFM WYSIWYG? I'll really appreciated any help on this add ons. Thank you, -David On 2/27/2014 6:04 AM, Guadagnino Cristiano wrote: Giles Coochey ha scritto: On 26/02/2014 16:19, Support wrote: Anyone, Any hints, direction, help, links anything trying to put a WYSIWYG to new create articles.. I will be appreciated if any one guide me to the right direccion rt 4.2.1 centos 6 Hi David, Sorry I can't help you, but I would like to have this functionality as well!! rt 4.2.3 centos 6.5 +1 -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
[rt-users] articles RTFM WYSIWYG
Anyone, Any hints, direction, help, links anything trying to put a WYSIWYG to new create articles.. I will be appreciated if any one guide me to the right direccion rt 4.2.1 centos 6 Thank you, -David -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
[rt-users] wysiwyg for article? 4.2.1
Anyone, There any way to implement wysiwyg on articles 4.2.1 on Centos 6? any help would be appreciated.!! Thank you -David -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] home page default
Kevin, Thank you for a feedback. I'll keep eye on your resolution. Regards, -David On Tue, Feb 04, 2014 at 11:45:20AM -0500, supp...@pureview.com wrote: Did you know if I can change the default home page to Articles instead of tickets home page? I would like to change to articles home page Unfortunately - there's no easy callback where you can modify this, but you're trying to change the next parameter in Elements/Login. You can do this with some JS on the login page to set it if it isn't set, a pure perl solution would require a new callback in Elements/Login which is definitely a branch I would review. -kevin
[rt-users] home page default
Hi RT users, Did you know if I can change the default home page to Articles instead of tickets home page? I would like to change to articles home page Thank you, -David
[rt-users] rt 4.2.1 error: Internal Server Error
All, Any one can help me to find the issues here. RH6 Oracle as DB fastcgi Can't locate RT_Config.pm in @INC (@INC contains: /opt/rt4/local/etc /opt/rt4/etc /opt/rt4/sbin/../local/lib /opt/rt4/sbin/../lib /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /opt/rt4/sbin/../lib/RT/Config.pm line 1063. [Wed Dec 18 02:05:41 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi (pid 31300) terminated by calling exit with status '255' [Wed Dec 18 02:05:41 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:42 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:45 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:48 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:51 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:54 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:57 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:06:00 2013] [error] [client 128.122.120.154] FastCGI: comm with (dynamic) server /opt/rt4/sbin/rt-server.fcgi aborted: (first read) idle timeout (30 sec) [Wed Dec 18 02:06:00 2013] [error] [client 128.122.120.154] FastCGI: incomplete headers (0 bytes) received from server /opt/rt4/sbin/rt-server.fcgi [Wed Dec 18 02:06:00 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds
Re: [rt-users] Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017
Alex, It works!! Thanks a lot. -David On Sat, 2013-12-14 at 18:43 -0500, supp...@pureview.com wrote: Could I still install with rt Oracle user in place already. If that is true what would be the new configuration file? What options should I omit...! sbin/rt-setup-database --action init --skip-create - Alex
Re: [rt-users] Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017
Joop, Thanks for the replay. I already created the user in Oracle like this: CREATE USER rt IDENTIFIED BY rtpassword DEFAULT TABLESPACE rtdata TEMPORARY TABLESPACE temp QUOTA 0 ON system PROFILE default; GRANT CONNECT,RESOURCE TO rt; GRANT ALL PRIVILEGES TO rt; See the error below: ERROR: Couldn't create user RT identified by password. Error: ORA-01920: user name 'RT' conflicts with another user or role name (DBD ERROR: error possibly near * indicator at char 12 in 'CREATE USER *RT IDENTIFIED BY password default tablespace USERS temporary tablespace TEMP quota unlimited on USERS') Could I still install with rt Oracle user in place already. If that is true what would be the new configuration file? What options should I omit...! Thank you, Support wrote: [root@toldav:rt-4.2.1]# make initialize-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your Oracle instance on IP Adddress (port '1530') as rt Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: Oracle Host: IP address ( Also I have try with localhost, fqdn and no host and it did not work) Port: 1530 Name: rt User: rt DBA:rt Failed to connect to dbi:Oracle:sid=rt;host=IP Address;port=1530 as user 'rt': ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBeg From this I suspect that RT wants the system account and pw to create the rt user. Could you try and see if that works? Joop
[rt-users] Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017
I need help installing RT with Oracle 11g as a backend database. Also I have set the env for oracle. I was able to to logon to Oracle using sqlplus using rt user name and rt password. Any one can help me to initialize rt with oracle. ERROR: Failed to connect to dbi:Oracle:sid=rt;host=IP Address;port=1530 as user 'rt': ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBeg I know I testedfd the user fine and logon to sqlplus fine. Thanks My Server Info RH 6 64bit RT-4.2.1 --with-db-type=Oracle \ --with-db-database=rt \ --with-db-host=IP Address \ --with-db-port=1530 \ --with-db-dba=system \ --with-db-rt-user=rt \ --with-db-rt-pass=password@rt \ --with-web-user=apache \ --with-web-group=apache \ --with-rt-group=rt \ --prefix=/opt/rt4 \ --enable-graphviz \ --enable-gd \ --enable-gpg [root@toldav:rt-4.2.1]# make initialize-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your Oracle instance on IP Adddress (port '1530') as rt Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: Oracle Host: IP address ( Also I have try with localhost, fqdn and no host and it did not work) Port: 1530 Name: rt User: rt DBA:rt Failed to connect to dbi:Oracle:sid=rt;host=IP Address;port=1530 as user 'rt': ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBeg
[rt-users] ShowStatusInColour - a little help needed with the code to make the subject colourized
Hi guys
I had this working about 5 years ago but can't get it right
I want to make http://requesttracker.wikia.com/wiki/ShowStatusInColor
Make the Subject and maybe the ticket ID show the colour the priority has
so we have... from the wiki...
if ($colors) {
$priority = div style=\color: $colors;\$priority/div
}
return \b$priority/b;
}
# Comment out any line to disable colour change.
$COLUMN_MAP-{Priority}-{value} = \PriorityInColor;
If we can decide how to spell Colour that is (even my spellchecker
gets confused uk/us spelling)
Thanks in advance
--
David Lane
Director
GoodChoice.IT Ltd
We reward successful referrals
W: www.goodchoice.it E: d...@goodchoice.it T: 020 8099 5540
--
RT Training in Seattle, June 19-20: http://bestpractical.com/training
[rt-users] Exim - simple config
Hi everyone, Can anyone point me a simple config for Exim on debian for incoming mail The sendmail old pipes way of doing it worked find for me as I put all mail to the same queue (but today i pop messages but want to deliver direct to the rt server) I want to do it with a split configuration but not being an Exim guru really struggling to get a simple setup thats easily supportable 100% of the messages sent to this box should go into the general queue in RT so i don't need 95% of the config settings in Exim I would like to get this working rather then change the MTA If anyone has a working config that would be great - i'm running 8.8.8 Thanks Dave RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Exim - simple config
Hi - i looked through all the notes (using the packaged version of 8.8.8) and i didn't see anything specific on Exim - I will double check this again as i probably just missed it... Graeme - Thanks for the suggestion but Exim is not happy for me to do piped settings in the alias file and (the Exim documentation specifically says not to do this ) ... http://www.debian-administration.org/users/lee/weblog/7 is the best i've come up with so far but its too complex for my needs - it does have mention of a way of turning the piping back on - which i will try too Dave On Thu, Aug 12, 2010 at 4:10 PM, Dominic Hargreaves dominic.hargrea...@oucs.ox.ac.uk wrote: On Thu, Aug 12, 2010 at 04:02:12PM +0100, David Lane (IT Support) wrote: Can anyone point me a simple config for Exim on debian for incoming mail The sendmail old pipes way of doing it worked find for me as I put all mail to the same queue (but today i pop messages but want to deliver direct to the rt server) I want to do it with a split configuration but not being an Exim guru really struggling to get a simple setup thats easily supportable 100% of the messages sent to this box should go into the general queue in RT so i don't need 95% of the config settings in Exim I would like to get this working rather then change the MTA Have you seen the example configs in the Debian package's README/NOTES.Debian? They generally should be good enough to drop into separate files in the split configuration setup. The trouble is that no one setup is the same as another, so it's hard to give a perfectly general configuration, which is why they are examples rather than shipped config that can be enabled at the press of a button. But any improvements to that documentation (or specific questions based on it) welcomed. Cheers, Dominic. -- RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT!
