Re: [rt-users] Enable devel-mode on existing RT instance?

On November 2, 2016 9:33:32 PM GMT+01:00, Landon Stewart wrote: >On Nov 2, 2016, at 10:45 AM, Alex Hall >> wrote: > >Hi all, >I'm getting an error in an overlay, but nothing is logged. I know I can >use >./configure

Re: [rt-users] Status of RepliesToResolved extension for RT 4.4.x?

On September 16, 2016 9:38:30 PM GMT+02:00, Diego Morales wrote: >Does anybody know about the status of the RepliesToResolved extension >for >RT 4.4.x ? > >Not much response about it on its bug tracker (two questions about it, >one >is mine):

Re: [rt-users] System switched to Install screen

Felix Bachmann fe...@earthshadow.org 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

Re: [rt-users] Email Tag

Bryon Baker bba...@copesan.com schreef op 30 juni 2015 17:14:03 CEST: Is there somewhere I can go to find information about the X-headers? For example. serverfault.com/questions/205707/dkim-and-request-tracker-headers Your mail from RT. Joop

Re: [rt-users] Script for AutoResolving after X days?

Johan Sundström johan.sundst...@vbm.se schreef op 23 april 2015 13:35:12 CEST: Hi! I would like to be able to auto-resolve tickets i have replyied to if i dont get a response from the user in X days. Anyone know of a script to make this happen? I looked on the contributions-page but could not

Re: [rt-users] Question about setting RTFM rights

Thanks Ruslan, it works Joop

Re: [rt-users] Emails not getting through spam filters of many ISP's due to Unknown Error

You will need to have a look at your mailserver. Look at masquarading. Sorry to be so brief, send from my phone. Joop Joanne Keown joanne.ke...@coloradogroup.com.au schreef: Hi RT gurus, I have a situation where emails from RT are going into SOME ISP email inboxes but not others. Gmail

Re: [rt-users] Content searching takes a long time and runs multiple queries

Jesse Vincent wrote: Justin Hayes justin.ha...@openbet.com wrote: Any view on which is faster Jesse (postgres or mysql/sphinx)? I haven't yet benchmarked em. Also how much faster than the old Content search are we talking? Orders of magnitude, or just 'faster'? Having played with one

Re: [rt-users] webmux.pl error - Apache won't start

Patton, Brandon wrote: Found another error in the apache2 logfile showing this error when trying to start apache2. Can't locate object method Config via package RT at /opt/rt3/bin/webmux.pl line 136. Compilation failed in require at (eval 242) line 1. This is the other error I have: Can't

Re: [rt-users] webmux.pl error - Apache won't start

Patton, Brandon wrote: Found another error in the apache2 logfile showing this error when trying to start apache2. Can't locate object method Config via package RT at /opt/rt3/bin/webmux.pl line 136. Compilation failed in require at (eval 242) line 1. This is the other error I have: Can't

Re: [rt-users] User login logout details

Hello Tony Any updates on this? Well, you can find login details in rt.log but only when loglevel is debug I think. For logout thats a whole other problem. If someone just decides to close its browser and then go home, you'll never recieve a logout from that. Apart from that I don't think

Re: [rt-users] RT3.8.8 CentOs

Bouzite, Radouan wrote: Where can I find RT3.8.8compiled version for CentOs ? There is no RT3.8.8 version yet in any repo that I know of. But you could download the source, run configure and install it. Using 'make fixdeps' will fix all dependancies for you. Run Centos5 with rt3.8.8 myself and

Re: [rt-users] RT::Extension::PriorityAsString stops working when adding another PLugin.

Michael Neuschafer wrote: Anytime I add any new @Plugins in the RT site config it causes my RT::Extension::PriorityAsString to malfunction and shows numbers rather than Low, Medium, High. Anybody know what can cause this? The new plugin will work but not my RT::Extension::PriorityAsString.

Re: [rt-users] DataBase question for RT 3.8.7

Ken Crocker wrote: To list, Were there any new Tables added to the DataBase for 3.8.7 not in 3.6.4? You can check that yourself by looking at the source archive. Look in the etc/upgrade/.. for the file 'content'. Those files hold changes to the database, if I'm correct. Regards, Joop

Re: [rt-users] Creating Group and giving Rights.

Ken Crocker wrote: JJussi, I use the WebUI. It's wy easier. The programming is already done, so why re-create the same wheel? Well, ever tried to change a couple of hundred users and/or groups that way ;-) I wrote a script which sets rights on groups/queues/global. Will try to dig

Re: [rt-users] PErl question for RT Status values

Ken Crocker wrote: To list, In the past (3.6.4) I was able to add a couple values for my @active ticket statuses by modifying the RT_SiteCOnfig.pm values thus: @ActiveStatus = ('new', 'open', 'pending QA', 'QA approvd', 'stalled') unless @ActiveStatus; Now, with the more stringent

Re: [rt-users] Could not set preferences

Ken Crocker wrote: To list, I finally got 3.8.6 up in Linux. In testing it out, I found that when I made changes to the arrangement in my home page, nothing worked. I tried moving a few queries around from the left to right of the screen and top-down, to no avail. Also, when I tried to

Re: [rt-users] bulk rights change for users?

John Roman wrote: Greetings, is it possible to apply a bulk rights change to every RT users, or a set of users accounts such that the let user be granted rights option is removed? Thank you nimb...@sdf.lonestar.org SDF Public Access UNIX System - http://sdf.lonestar.org

Re: [rt-users] Oracle data problem

Matt Miller wrote: Using RT 3.8.5, Perl 5.10.1, mod_perl 2.0.4, and Apache 2.2.13. I have the following Oracle client packages installed on my CentOS 5.3 x86_64 box: oracle-instantclient11.1-basic-11.1.0.7.0-1 oracle-instantclient11.1-sqlplus-11.1.0.7.0-1

Re: [rt-users] Dashboard subscriptions not working in RT 3.8.4

Justin Hayes wrote: Hopefully my last question before I get 3.8.4 live :) I've playing around with the new 'dashboards' functionality. It all looks very useful, and I think my customers would like it as well, however I can't seem to get subscriptions to work. I've set up a dashboard

Re: [rt-users] Failed To Record Message

Varun wrote: Apache error log says fail to execute query [Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server /opt/rt3/bin/mason_handler.fcgi stderr: RT::Handle=HASH(0x9acfd4c) couldn't execute the query 'INSERT INTO Transactions (OldValue, NewReference, OldReference,

Re: [rt-users] RT Query Logging

Varun Vyas wrote: Hello All Can anyone can tell me how i can log my queries that hits my database in RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as I saw that it is now working for you, query logging that is. our RT is very slow and takes 15-20 seconds for

Re: [rt-users] RT 3.8.4 install on Oracle - ORA-04043: object Users does not exist

Eric Coleman wrote: When the RT build process (make initialize-database) reaches the create schema step I’m receiving an Oracle 4043 error when the Users tables is populated. The schema objects (tables, indexes and sequences) are being generated successfully so I’m confident that DBI is

Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

Nick Yonko wrote: I am getting an error when rt-mailgate sends an email to RT saying that the Attachments object does not exist. The email is received and the details of it are written to the database, however the body of the email is missing. Has anyone dealt with this? I am on Oracle

Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

Nick Yonko wrote: That was my initial thought, but when I log into the database using the rt user with sqlplus, as the account that runs the apache daemon no less, I can issue a 'desc attachments' command and a 'desc Attachments' command and both return the table structure. Can you turn on

Re: [rt-users] Auditing ticket accesses

Flynn, Timothy J wrote: I am looking for a way to record when someone views a ticket and log it somehow. I know the url accesses are in apache logs. I am looking for something long term that people could easily see when a ticket was accessed, by who, and when. I was thinking about a scrip

Re: [rt-users] rt3 performance problem when updating a ticket

Thiruselvam V wrote: I am trying to evaluate RT with Oracle 10g database. Does any one have details step to do this? I am going through the url's meanwhile, if I get this would be great. thanks Thiru Anything in particular you're having problems with? We use Oracle

Re: [rt-users] sessions table is lost after a system crash

Asif Iqbal wrote: (user)@webrt:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 to server version: 4.0.24-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use rt3; Reading table

Re: [rt-users] sessions table is lost after a system crash

Asif Iqbal wrote: How do I fix it? Have a look at the mysql.sql file in your setup folder of RT or download rt and recreate the table. I do not see any mysql.sql file in the src dir of rt 3.4.5 ./etc/schema.mysql Maybe I meant this file. Did you look at the sql file to

Re: [rt-users] sessions table is lost after a system crash

Asif Iqbal wrote: I looked at it now. So I can just delete the sessions.MYI, sessions.MYD and frm files and recreate the sessions table as in the schema? I am assuming it wont break the RT mysqlcheck says this btw, [..all OK..] rt3.Users

Re: [rt-users] Hanging Login Page (ModPerl2, HTTPD, Oracle, RHEL5)

Charles Kugelman wrote: Ken, Thanks for the response. The problem in fact presents itself even before we get to that point (the home page). Essentially, it’s the login page where we see the problem. We come in (in the morning, after RT has been sitting all night with no activity)

Re: [rt-users] Advice for New Machine

Ken Crocker wrote: John, We are currently running 3.6.4, but DESPERATELY want to upgrade to 3.8.2. Hence the desire to get this new zone set up right FIRST, before trying to upgrade. We are an Oracle house, so that's not on the table. So far, I'm leaning toward Linux, but I haven't

Re: [rt-users] CommandByMail HELP with install

Kenneth Crocker wrote: To all, FIRST and FOREMOST!!! I am NOT a Unix guy. I know it runs on a server and we have a Sparc server and our DataBase is Oracle 10g and we are on RT 3.6.4. However, I have NO IDEA how directories work when it comes to how an install program looks

Re: [rt-users] RT-Extension-CommandByMail

Monti gmail wrote: Hi, I am trying to install RT-Extension-CommandByMail Extention and it does not work well. When I restart the webserver I get this error: Sun Oct 19 20:23:25 2008]* [error] Can't locate RT/Extension/CommandByMail.pm in @INC (@INC contains:*

Re: [rt-users] Trouble upgrading to 3.8.1

Kenneth Crocker wrote: Any clues as to why the C compiler is needed? Thanks. Not all Perl modules are Pure Perl modules which means that for example GD has a Perl interface to the gd.so which fixdeps will try to compile for you. That is probably not the right thing to say but I hope its

[rt-users] Newest history is not being displayed

Hi All, I have a rather strange case where the newest history of a ticket is not displayed or when the pref display newest transactions first is set the oldest is not displayed. When people comment/reply to the ticket then the email is send but looking at the web interface the correspondence

Re: [rt-users] FW: Updating Tickets - MessageBox Size Double Lines

Paul Broadwith wrote: I would like to change the size of the message box that is shown when you update a ticket. It’s currently around 10 lines high. In the RT_SiteConfig.pm file I changed the MessageBoxHeight variable to 30 but this doesn’t seem to have made a difference – either it’s the

Re: [rt-users] Forking a ticket

Roedel, Mark wrote: When we upgraded to 3.8.0, I reworked most of Dirk's forking patch into callbacks (I did keep the standalone select-queue page, although at some point I'd like to try eliminating that as well with some sort of ajaxy dropdown queue selector) so I wouldn't have to keep

Re: [rt-users] Enhancements and workflows that we have added

Kenneth Crocker wrote: Aaron, We are VERY interested in what you have developed. Whether or not you post to the list, please send us what you have. It will be extremely appreciated. Also, do you have anything that increases the box size of a free-test CF?. Thanks in advance. If

Re: [rt-users] Upgrade Oracle to 10g r2

Kenneth Crocker wrote: To all, Does anyone know if there is an RT problem related to upgrading Oracle DB to 10g r2? We're running 3.6.4 and planning to do that but I wanted to see if that would cause any RT problems. Thanks in advance. I have been running RT on Oracle XE, not quite

Re: [rt-users] Wishlist emails

Roy El-Hames wrote: Hi ; I have seen a couple of emails in the past a couple of months about wish list etc which I assume for a new major release, and I have a couple of wishes wondering if these can be looked into, Content searching I have tried many hacks to get an efficient content

Re: [rt-users] OCIEnvNlsCreate error trying to initialize Oracle DB

Joe Casadonte wrote: Having been scared off of using SQLite even for a small system, I've now bought some more memory and put Oracle on my home machine. I can't get the damn schema set up, instead getting the following error: # perl sbin/rt-setup-database --dba=reqtrack

Re: [rt-users] Recurring signin with 3.6.4

Kenneth Crocker wrote: Kenneth, We are on Oracle 9 (soon going to 10) and RT doesn't seem to work well with Oracle for sessions. So we use the file method for storing. I would love to hear from anyone using Oracle on how they deal with the sessions table problem. Kenn LBNL On

Re: [rt-users] Web and Encoding on RedHat EL5

Emmanuel Lacour wrote: On Sun, Dec 02, 2007 at 04:17:29PM +0100, Emmanuel Lacour wrote: After configuring fastcgi instead of mod_perl2, it works :( So I will continue investigate with mod_perl2. I can't find the source of this problem, so I will continue using fastcgi, sorry for mod_perl2

Re: [rt-users] Purge status deleted item from database

Debra Deyette wrote: Hello. We have a ticket with confidential information that was accidentally posted to our queue in RT. I changed the status of this ticket to deleted. However, since our techs may have seen the initial ticket and they know the number, if you do a search on that ticket

Re: [rt-users] Sizing a Custom Field display box

Stephen Turner wrote: At Wednesday 10/17/2007 01:00 PM, Kenneth Crocker wrote: To all, I have a Custom Field that is Fill in one text area. On the display page, there is a tiny little box in which the user is supposed to enter, what could be, a very large paragraph or two. They

Re: [rt-users] Can I deselect a Global Scrip on a per queue basis?

David Hobley wrote: Looking through the Mail archives, Dirk Pape has an extension for this, but all links point to his page which appears to no longer exist. Anyone have a link to the latest version of this extension? The link I have from the Wiki is:

Re: R: [rt-users] Chart grouped by customfield

Ruslan Zakirov wrote: On 10/11/07, Emmanuel Lacour [EMAIL PROTECTED] wrote: On Thu, Oct 11, 2007 at 06:44:04AM +0400, Ruslan Zakirov wrote: It's an experimental and untested patch that may help. It helps, and works here :)) Thanks you very much! That's cool, let it spin for several

Re: [rt-users] Chart grouped by customfield

Jesse Vincent wrote: I suspect that it has to do with this was tested on mysql and pg Any oracle folks see what we're doing wrong with that SQL? There is DBD prepare errors: RT: RT::Handle=HASH(0x8134df1c) couldn't prepare the query 'SELECT COUNT(main.id) AS id,

Re: R: [rt-users] Chart grouped by customfield

Emmanuel Lacour wrote: On Wed, Oct 10, 2007 at 05:46:31PM +0200, Gianluca Cecchi wrote: Sorry main was an alias for Tickets table If I use the same query on mysql 9without the comma...) I get: ERROR 1054 (42S22): Unknown column 'ObjectCustomFieldValues_1.Content' in 'field list' And

Re: [rt-users] Migrate database from PostgreSQL to Oracle

Peer Michael wrote: Hello all, I want to migrate our rt-3.4.6-database from postgresql to Oracle. Has someone else done this before? Some people have gone from MySQL to Oracle in the last couple of months, search the archives for it, else let me know and I might be able to help. Joop

Re: [rt-users] Re: Slow Query

Asif Iqbal wrote: I am reposting in case anyone missed my previous post On 8/17/07, Asif Iqbal [EMAIL PROTECTED] wrote: I have few queries that are extremely slow. I am using RT 3.4.5, Perl 5.8.6, Solaris 10 x86, Apache/1.3.33 (Unix) mod_perl/1.29 mod_ssl/2.8.22 OpenSSL/0.9.7g, mysql 4.0.24,

Re: [rt-users] query problem after 3.4.5 - 3.6.4 upgrade

Brian Kerr wrote: On 7/23/07, Ruslan Zakirov [EMAIL PROTECTED] wrote: Do I understand right that the query is like Requestor.EmailAddress = 'xxx' OR Status = 'new' OR Status = 'open'? * Note all binary operators (aggregators) are ORs. The above queries were done with status delimiters. The

Re: [rt-users] MySQL-Oracle DB Migration Binary Attachment data corruption - UTF8 issue?

Todd Williams wrote: Hello, Here are the pertinent details for our attempted migration: Suse Linux 9.3 x86 32-bit MIGRATING: MySQL 4.0.18 to Oracle 9i 9.2.0.6.0 RT 3.6.3 Perl 5.8.3 DBIx::SearchBuilder 1.45, DBD::Oracle 1.19 Apache 2.0.49 Oracle SQL Developer MySQL Migration Workbench plugin

Re: [rt-users] RT 3.6.1 died, restore on 3.6.3?

Nicolas Chuche wrote: On 5/20/07, Bill Davis [EMAIL PROTECTED] wrote: OK ... I've compared the rt3-schema-relationships.dot files included in the two distributions they appear to be identical. With my limited knowledge of RT that is indicating that the databases are identical. Could anyone

Re: [rt-users] Desperately ned Oracle help

Baytalskiy, Sal wrote: Hey guys! A little update: i've been looking at the rt-setup-database script trying to figure out how to get around the issues i'm having. So the very first error mentioned this: at //usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this *$dbh = DBI-connect(

Re: [rt-users] Re: InnoDB Ticket IDs incrementing by 10?

mike wrote: I hate to reply to my own question, but does anyone else see this issue with new tickets being generated with IDs of n+10 rather than n+1? It has to be something simple/stupid that I'm missing, but I've been looking at it for days and am clearly overlooking something at this

Re: [rt-users] Detailed registration of time spend on a ticket

Tommy Abrahamsson wrote: Hi I'm trying to figure out how to use RT for more detailed time tracking when working on tickets. The reason is that I work for a specific client, which require specific hours and dates - not just 4 hours - when I send the bill. The bill is monthly, which is why

Re: [rt-users] DBIx::Searchbuilder issue

Justin Brodley wrote: We just got our oracle box working and I’ve gotten RT installed and all the modules. I had some inititial difficulty with DBD::Oracle but finally got “make test” to complete without failures. But I’m still getting the attached errors in my apache logs from

Re: [rt-users] Google Summer of Code

Kenneth Marshall wrote: Joop, I saw a reference to your Oracle full-text add-in, but not the actual patch. I know that it can be done. I was hoping for more uniform support within RT when you use any DB that supports it. If you could send or post the patch for Oracle again, that would be

RE: [rt-users] version 3.6.1--dreaded infinite login

page and clicked Home again-- no loginbox ;-))) yeah. Further config details: RT-3.6.1 RTFM latest svn AT latest svn Oracle XE Joop -- Joop van de Wege [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community

Re: [rt-users] Installing RTFM

was to use the latest svn version of RTFM. Joop -- Joop van de Wege [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

Re: [rt-users] RT-3.6.x and SavedSearches on the frontpage

On Wed, 26 Jul 2006 10:20:50 -0400 Todd Chapman [EMAIL PROTECTED] wrote: On Wed, Jul 26, 2006 at 03:47:57PM +0200, Joop van de Wege wrote: Hello All, I have been looking at modifying the RT startpage and noticed that I can only place RT saved searches on it. I have been using RTFM (svn

[rt-users] Spell Check for RT 3.0.10

thought that I had put a patch on this list, try to search for WBOSS and see if it comes up or else I'll try to make a patch against 3.6 and I have a patch lying around for 3.4.3 Joop -- Joop van de Wege [EMAIL PROTECTED] ___ http://lists.bestpractical.com

[rt-users] Spam on the Wiki

if this is not the right place but I feel that on this list (all) the relevent people will read it -- Joop van de Wege [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support