Hello,
I try to upgrade RT 3.0.12 to RT 4.0.20. It works well until finally I
get to the
make upgrade-database
command which dies. See below. I do these as root user.
-BEGIN-
root@ubuntu:/w/install/new/rt# make upgrade-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
Running this step as the Unix root user should not be necessary.
The error message is interesting, because it suggests that RT is not
attempting to connect to the database as the correct database user.
Do you have two separate database user accounts set up for RT—one for
regular use, and one for
Hello,
I want to build some absence planning into our RT to avoid that absent users
receive messages and nobody sees this message. What I'm planning is the
following:
1. Creating a user's custom field absent which is yes or no
2. When a user is absence, this user changes this field
I only have one database user, the default 'root' DB user with a password.
The command you suggested results the same error unfortunately.
I do these in a sandbox environment so I can step back to any saved
snapshots and try and try again. The RT4 upgrade process is done except
this final one, the
RT is defaulting to database username rt_user because you didn't specify
the correct value when you ran the configure script.
You can work around this by setting environment variable RT_DB_USER to
root before running the command:
RT_DB_USER=root /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
You can probably use:
$self-TicketObj-OwnerObj-FirstCustomFieldValue('absent')
to access the value of the owner's absent custom field.
I don't understand why you are testing for a ticket status change.
Wouldn't you want the scrip to run only when correspondence occurs?
On 24 July 2014 23:14,
Now it says (went back to the right snapshot ofcourse):
Processing 3.1.0
Now populating database schema.
Now inserting database ACLs.
DBI connect('dbname=rt4;host=localhost','root',...) failed: Access
denied for user 'root'@'localhost' (using password: YES) at
To me, this suggests a problem independent of RT.
Is your database running on localhost? What happens when you try to
connect to the database directly with that username using a MySQL client?
On 24 July 2014 23:41, Tamás, Szép tamas.s...@govcert.hu wrote:
Now it says (went back to the right
Everything seems to work smoothly:
root@ubuntu:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53
Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)
-blablabla-
mysql show databases;
++
|
I've just realised that RT will be using a default password of rt_pass in
some cases.
Try additionally setting the RT_DB_PASSWORD environment variable before
running the script.
Alternatively, create an RT_SiteConfig.pm file in the etc directory of your
upgrade containing all of the necessary
There might be API inconsistency across RT versions. What version of RT
are you using? Also, are you receiving any errors in RT's logs when that
code runs?
If I understand you correctly, the on correspond, open inactive tickets
scrip is interfering with your ability to test whether an absent
On Wed, Jul 23, 2014 at 03:31:02PM -0400, Jeff Blaine wrote:
Shouldn't Told '48 hours ago' return the tickets that have NEVER
even been Told?
It doesn't as far as I can see.
I'm failing to find a way to search for tickets that have never been told.
RT 4.2.3.
The last upgrading
On Wed, Jul 09, 2014 at 05:16:52AM -0700, andriusk wrote:
Is there any way to export charts or chart data from RT in excel, pdf, or
maybe json for data?
Feeds - spreadsheet is your best current bet.
-kevin
pgpXYqk0vSm3e.pgp
Description: PGP signature
--
RT Training - Boston, September 9-10
On Thu, Jul 10, 2014 at 12:50:43PM -0400, Jeff Blaine wrote:
Where are user preferences stored?
I can't find them in the database.
RT 4.2.5
User preferences are attributes, like most other blobular data in RT
without an obvious table.
-kevin
pgpMsOqflinPn.pgp
Description: PGP signature
--
On Tue, Jul 15, 2014 at 11:06:16AM +0300, Mikko Talvenmaa wrote:
As its relatively easy to create RSS feed on tickets, is there anyway on RT
using its own tools to create feed of transactions?
Something like - date/time user x made an action on ticket id with subject
xyz. That would be
On Wed, Jul 16, 2014 at 06:30:48AM -0700, andriusk wrote:
How can I get data in JSON format from REST or other way using the query
used to form the chart?
RT does not generate JSON in the 1.0 rest interface or from the chart.
You may wish to track down discussion of REST/2.0 on the rt-devel
On Wed, Jul 16, 2014 at 03:32:55PM +, Karres, Dean wrote:
Are there examples of using rtldapimport to import specific groups and just
the
group members?
You write the filter argument for groups/users (usually filtering on
group name) and run rtldapimport with --debug and NOT with
Hello all -
I am currently attempting to upgrade from 4.0.19 to 4.2.6 and am seeing the
following:
Processing 4.1.0
[17123] [Thu Jul 24 14:52:41 2014] [warning]: The default stylesheet
(aileron) does not exist in this instance of RT. Defaulting to rudder.
On Wed, Jul 16, 2014 at 02:54:48PM -0400, Boris Epstein wrote:
1) List all users
rt help ls
2) List all tickets including the resolved one
3) List all tickets filed by a user whose city is, for instance, Chicago.
Use the query builder to build a search, then pass that search to the
CLI.
On Thu, Jul 17, 2014 at 12:58:04PM +0530, Ajay Kumar wrote:
Have any one has migrated request-tracker database from sqlite3 to mysql
successfully?If yes, pls share the steps. I am using rt 4.2.1.We tried
recently then I was not able to create ticket and getting below mentioned
error:
On Thu, Jul 17, 2014 at 11:44:42AM -0400, Mike Johnson wrote:
First, we are on RT 3.8.10 (I know, it's old!!!) and I searched
google/listserv
and the extensions list on BP's site and didn't find anything that looked like
this...
Is there functionality out there for RT that allows 1 custom
On Fri, Jul 18, 2014 at 12:25:35AM -0700, Adam Siecinski wrote:
Owner1 sends mail1 to requestor1
Owner1 changes requestor of the Ticket from requestor1 to requestor2
Owner1 sends mail2 to requestor2
Requestor1 forwarded mail1 to requestor2
Requestor2 answers mail2 attaching mail1 (Outlook
Hello Kevin,
Thanks a lot for your reply. This makes sense - but the question is, can I
build such a query? Is it possible? I know these are likely dumb questions
but the documentation I found on the Query builder is rather sparse and for
that reason I just don't know how to do that - or even if
On Mon, Jul 21, 2014 at 10:58:03AM -0500, Lists wrote:
I have been working on upgrading our production RT 3.8.1 install to RT 4.2.6
and am almost ready to deploy to production. The only issue I am having is
after the upgrade process, when I log in I am seeing missing reminders.
An RT that old
Nevermind. I missed the *make upgrade* step before the *make
upgrade-database*.
I am, however, having another issue. After the upgrades successfully
completed I went to restart my web server and got the following:
root@help:/tmp/rt-4.2.6# /etc/init.d/apache2 restart
Syntax error on line 44 of
On Thu, Jul 24, 2014 at 09:55:06AM -0500, Max McGrath wrote:
[17123] [Thu Jul 24 14:52:41 2014] [warning]: The default stylesheet (aileron)
does not exist in this instance of RT. Defaulting to rudder. (/tmp/rt-4.2.6/
sbin/../lib/RT/Config.pm:237)
This makes me question your config and
And here is lines 39 - 47 of *000-default*:
38
39 SetHandler modperl
40 PerlResponseHandler Plack::Handler::Apache2
41 PerlSetVar psgi_app /opt/rt4/sbin/rt-server
42 /Location
43 Perl
44 use Plack::Handler::Apache2;
45
On Thu, Jul 24, 2014 at 11:14:52AM -0400, Boris Epstein wrote:
Thanks a lot for your reply. This makes sense - but the question is, can I
build such a query? Is it possible? I know these are likely dumb questions but
the documentation I found on the Query builder is rather sparse and for that
On Wed, Jul 23, 2014 at 01:47:32PM -0400, Mohammed Cyclegar wrote:
I am in need of help for the following tasks.
1) Email configuration for all the Queues and user permissions.
2) Creating multiple tickets with parsing single incoming email which has
multiple similar data set.
If any one
On Thu, Jul 24, 2014 at 10:19:03AM -0500, Max McGrath wrote:
Can't locate Symbol/Global/Name.pm in @INC (@INC contains: /opt/rt4/sbin/../
Symbol::Global::Name is required for RT.
Have you built your own perl? Have you recompiled mod_perl to use it?
39 SetHandler modperl
40
Thanks for the info Kevin.
After poking around in the database, I saw where the status of the
reminders were still set as open. There were few enough orphaned
reminders such that I just opened the reminder via simple search and the
changed the status to resolved.
I don't think this will be
Kevin -
Thanks for the response. I wouldn't know how to do either of those things!
So no, I haven't. :)
According to CPAN it is installed: Symbol::Global::Name is up to date (0.05)
I guess I should figure out how to recompile mod_perl. Is that fairly
simple?
Thanks!
--
Max McGrath
Network
On 07/24/2014 11:25 AM, Kevin Falcone wrote:
On Thu, Jul 24, 2014 at 11:14:52AM -0400, Boris Epstein wrote:
Thanks a lot for your reply. This makes sense - but the question
is, can I build such a query? Is it possible? I know these are
likely dumb questions but the documentation I found on the
On Thu, Jul 24, 2014 at 10:41:01AM -0500, Max McGrath wrote:
Thanks for the response. I wouldn't know how to do either of those things!
So
no, I haven't. :)
According to CPAN it is installed: Symbol::Global::Name is up to date (0.05)
I guess I should figure out how to recompile
I am wishing that RT supported CustomFields in a way other than Name == Value
This makes it impossible to have a CustomField showing a bunch of Names whose
Values are [for example] integer Object IDs
In my case I have to store billing rates for service calls, supporting multiple
external
I feel that you are overcomplicating your scrip by testing for a status
change (which is actually a side effect of another scrip), because your
primary goal is to perform this action when correspondence occurs.
If I were in your position, I would have two scrips in place:
1. On (correspond AND
I'm not sure I understand your question. Are you asking whether custom
fields can hold multiple values at once? You can set up custom fields that
do this. What exactly are you wanting to achieve? Custom field options
that depend on a previously-selected value?
Custom field values can safely
thanks!!
I'm very glad to hear that the it's store by value and not by reference, that's
perfect !!
Let me reduce my request to simplest possible contrivance -- that'll be easier
then trying to explain the chain, when all that matters is the final link
I want a custom field that displays as a
I'd probably implement that as two separate custom fields:
1. the Plan value, which is visible to and modifiable by the users;
2. the dollar value, which is not visible to the users.
I'd then build a scrip that fires on changes to the Plan value, and sets
the dollar value accordingly using
Ah,
I thought I'd have to use code before this was done
Thanks, this'll be my intro into Scrip'ing
Al;
On Jul 24, 2014, at 10:55 PM, Alex Peters a...@peters.net wrote:
I'd probably implement that as two separate custom fields:
the Plan value, which is visible to and
Thanks for your reply Kevin,
I think i figured it out. RT treats the Attachment like a 3rd party
correspondence. I'll try to export an email as soon as possible. But for now
I wrote a work-around-scrip.
Here's my scrip:
Condition: User Defined
Action: Notify requestors and Ccs
Template:
41 matches
Mail list logo