Hi there
I am having schema.mysql-4.0-4.1.pl problems upgrading to version
3.8.0 from 3.6.6.
make upgrade worked well.
As in point 4) of UPGRADING.mysql
[EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl sql.queries
but
usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user
I've been fiting for days with the install and I finally seem to have
everything running on the server side with no errors, and yet I can't
login...
When I go to www.mywebaddress.com/rt I get the message stating You're
almost there and telling me that I need to configure the site to use
mod_perl,
I'm having the same issue. I get that error when I try to go to
http://www.mywebaddress.com/rt/install/index.htm When I go to
www.mywebaddress.com/rt I get the You're almost there message telling me I
need to configure my server to use mod_perl, fastcgi, etc...
this thing is giving me a
Hello all,
I am trying to install RT-3.8.0 under Solaris 10 (SPARC) and can't seem
to get it to work. The error seems to suggest the install-sh script
is not found in etc (and several other subdirectories). I tried to copy
the install-sh script into those directories. The installation went
Alan Cheng wrote:
Hello all,
I am trying to install RT-3.8.0 under Solaris 10 (SPARC) and can't seem
to get it to work. The error seems to suggest the install-sh script
is not found in etc (and several other subdirectories). I tried to copy
the install-sh script into those directories.
Hi all
I use RT 3.6.5 on Centos5. Last night I performed a rather large
yum update and since then rt stopped working. When I go to the rt
webpage it comes up with a windows asking if I want to download a file.
Can anybody help with this please.
Let em know if you need more info
Hi Joop,
Thank you very much for the tip. I thought it may have something to do
with the incompatibility with Soalris make (/usr/ccs/bin/make). The
companion CD would install the GNU make. With the latest version of
Solaris 10, most GNU packages have been installed in /usr/sfw/bin.
I
What did yum update?
Kobus Bensch wrote:
Hi all
I use RT 3.6.5 on Centos5. Last night I performed a rather large yum
update and since then rt stopped working. When I go to the rt webpage
it comes up with a windows asking if I want to download a file.
Can anybody help with this please.
Did you verify the contents of /opt/rt3/etc? The script output indicates
that the schema and acl files in that directory don't exist, which means
the preceding operation failed:
./install-sh -c -m 0755 -d /opt/rt3/etc
cd etc ./install-sh -c -m 0644 acl.Informix acl.Pg acl.Oracle
acl.mysql
In 3.8.0 it's one step :)
However, we've done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.
On Wed, Jul 16, 2008 at 5:24 PM, [EMAIL PROTECTED] wrote:
Did you follow these steps first?
You may also need to update RT's database. To find out, type:
Sounds like the perl/mysql update will require some perl module
updates. make fixdeps may do you some good.
Kobus Bensch wrote:
There was 215 updates including perl and mysql. I will post the full
log here in a bit.
Kobus
Quoting Drew Barnes [EMAIL PROTECTED]:
What did yum update?
Indeed those files don't exist. I will have to dig further...
[/opt/rt3/etc]$ ls -l
total 72
-r 1 root root 90 Jul 16 09:26 acl.Informix
-r--r- 1 root apache 34202 Jul 16 09:33 RT_Config.pm
-rw-r- 1 root apache 632 Jul 16 08:45
Hello,
I'd like my support guys to be able to handle incoming phone calls, as
well as incoming emails. RT works really well for incoming emails, but
it's harder to set up a ticket with the right parameters when it's
started from a phone call.
I'd like Support to be able to be able to
I am getting the same column_info failed error message when running the
script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to
the DB server since we are not running RT and the DB on the same
machine.
--Ryan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Hi Kobus,
I had the same problem about two weeks ago. Unfortunately, I never did find
out EXACTLY what the problem was, however, an upgrade to 3.8 fixed it.
Testdeps and fixdeps didn't help me, everything was there.
My upgrade consisted of backing up the database, blowing away the site, and
So, if you are upgrading from 3.6.x to 3.8.0, you don't need to follow the
step below?
You may also need to update RT's database. To find out, type:
ls etc/upgrade
Also, which step that you refer to below fails? Fails for everyone?
James Moseley
Interesting. We're running 5.0.27 and the script worked just fine.
However, I ran all the schema/acl/insert upgrade commands using all the
5.7.xx directories in etc/upgrade.
Still waiting to hear from Ruslan to confirm 100% that you don't need to
run all these commands and you need only run the
Hi Jake,
I think your apache config needs help. The only reason you'll get the you're
almost there page is if mason isn't running in the directory your index.html
file exists in.
If you have RT installed under your document root, you'll have to tell apache
that mason handles files in that
Well I ran all the etc/upgrade/3.7.* upgrades and then created the
query script with schema.mysql-4.0-4.1.pl and I get this error,
ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType'
I am using Server version: 5.0.51a.
I am confused as well, if you are already on mysql 4.0
Hi, I'm installing an instance of RT in a non-standard local directory
(/opt/csr/). The wiki indicates that when I run perl Makefile.PL, it will
prompt me for the path to my RT instance, but... it doesn't. So, how can I
specify the RT directory? You can see below - I want /opt/rt3 to be
Hello everyone,
We recently upgraded from 3.6.6 to 3.8.0 and after the upgrade, we
immediately noticed delays loading pages within RT-3.8.0 website.
Currently, the web interface is hosted on a Gentoo Linux system
running apache2-2.8 with modperl 2.0.3 (portage) and Postfix MTA.
RT3.8 was built
Let's make it clear:
* you still must upgrade DB using files in etc/upgrade/x.x.x/
* however in 3.8.0 you can do it using one command:
rt-setup-database --dba root --prompt-for-dba-password --action upgrade
it will ask for the old version (for example you can enter 3.6.7) and
will apply all
Your local version of DBD::mysql is out of date. The relevant notes from my
rt3.8 upgrade on Debian Etch are below. Hope that helps.
Kris Boutilier
Information Services Coordinator
Sunshine Coast Regional District
-
'column_info failed: column_info doesn't support
Is there a way to explicitly turn off the standalone server during
install/compile? the previous versions didn't force it. I'm trying to
stay away from the extra perl modules as I don't believe I'll be using
it at all. I've tried various configure switches but it doesn't appear
to be
On Jul 16, 2008, at 2:08 PM, Curtis Bruneau wrote:
Is there a way to explicitly turn off the standalone server during
install/compile? the previous versions didn't force it.
There is not. We've made it a core RT dependency. The additional
dependencies are relatively light-weight and
What modifications would need to be made to make the Simple Search
function accept more than one word?
It can do two words when the search terms are put in single
quotes...but the string has to match exactly a string in the Subject.
If the ticket subject is barack obama beat hillary
Ruslan, thanks for sharing this.
James Moseley
Ruslan Zakirov
[EMAIL PROTECTED]
l.com
Is there a way to get Service Updates extension to work in 3.8?
It installs, but when I go to enter an item I get:
Undefined subroutine HTML::Mason::Commands::Error called at
/opt/rt3/share/html/ServiceUpdate/Edit/dhandler line 20.
This is a fresh 3.8, with the extension installed via cpan.
In fact, this function I describe below *IS* built into the new RT
somewhere...or Best Practical developed it for themselves..
Their website at rt3.fsck.com DOES handle searches the way I'd like
them to be handled.
A search for:
anti anxiety
...finds:
10208
On Jul 16, 2008, at 3:31 PM, Jake Zack wrote:
In fact, this function I describe below *IS* built into the new RT
somewhere...or Best Practical developed it for themselves..
We don't have any special code in there for this. Have you tested
3.8.0 locally?
Their website at rt3.fsck.com
On Jul 16, 2008, at 2:00 PM, Jessie Bryan wrote:
Hello everyone,
We recently upgraded from 3.6.6 to 3.8.0 and after the upgrade, we
immediately noticed delays loading pages within RT-3.8.0 website.
Currently, the web interface is hosted on a Gentoo Linux system
running apache2-2.8 with
OK...I lied.
Well, not below...but initially.
The RT 8.0 search function does work properly...UNLESS...as
below...there are numbers involved.
I created ticket subject 'one two three four five six', and a search of:
one six
Finds it.
But if the search string contains numbers, it fails.
When replying or commenting on a ticket, I can see the text color, if color
is selected. When viewing the source, I can also see the span tags.
But after updating the ticket, the span tags disappear and thus the color
does too when displaying the ticket.
Am I missing something in the
Have just upgraded RT 3.6.5 to RT 3.8 and am quite impressed overall ...
kudos to all involved in its development :o) ...
... however there are a few minor things I'd like to modify:
1. Inevitably a certain amount of spam leaks through the spam filters
and creates tickets ... currently on each
On Jul 16, 2008, at 4:07 PM, Jake Zack wrote:
OK...I lied.
Well, not below...but initially.
The RT 8.0 search function does work properly...UNLESS...as
below...there are numbers involved.
I created ticket subject 'one two three four five six', and a search
of:
one six
Finds it.
On Thu, Jul 17, 2008 at 12:37 AM, Bill Davis [EMAIL PROTECTED] wrote:
Have just upgraded RT 3.6.5 to RT 3.8 and am quite impressed overall ...
kudos to all involved in its development :o) ...
... however there are a few minor things I'd like to modify:
1. Inevitably a certain amount of spam
On Wed, 2008-07-16 at 11:53 -0500, Scott T. Hildreth wrote:
Well I ran all the etc/upgrade/3.7.* upgrades and then created the
query script with schema.mysql-4.0-4.1.pl and I get this error,
ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType'
I looked at the sql,
hi all,
tried to upgrade the database with the following command (from version
3.6.6 to 3.8.0):
rt-setup-database --dba root --prompt-for-dba-password --action upgrade
it worked but then it stopped with this error:
Processing 3.7.1
Processing 3.7.3
Now populating database schema.
Processing
There's some nice new options for Search/Build.html (such as all the
Queue* stuff, but the label field is a bit narrow.
Attached is a patch that allows me to see the tail end of such options
as QueueAdminCC EmailAddress rather than just a list of QueueAdminC.
Jeff Voskamp
***
I'm wondering if the 3.8.0 DB schema is backwards compatible with 3.6.0.
Does anyone know?
--
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
On Jul 16, 2008, at 5:36 PM, Jeff Voskamp wrote:
There's some nice new options for Search/Build.html (such as all the
Queue* stuff, but the label field is a bit narrow.
Attached is a patch that allows me to see the tail end of such
options as QueueAdminCC EmailAddress rather than just a
On Jul 16, 2008, at 5:56 PM, Micah Gersten wrote:
I'm wondering if the 3.8.0 DB schema is backwards compatible with
3.6.0.
Does anyone know?
It is. some types have been tweaked, but they should all work fine
with a 3.6.0 instance. The only real changes are added data.
-j
--
Thank
On Wed, Jul 16, 2008 at 12:45 PM, Jesse Vincent [EMAIL PROTECTED] wrote:
Are you doing automated vacuum analyzes? Do you have Postgres' slow query
log on? If so, what does it report?
AFAICT, postgresql.conf show me that autovacuum is on:
autovacuum = on
autovacuum_naptime = 300
I don't see
Jesse Vincent wrote:
On Jul 16, 2008, at 5:36 PM, Jeff Voskamp wrote:
There's some nice new options for Search/Build.html (such as all the
Queue* stuff, but the label field is a bit narrow.
Attached is a patch that allows me to see the tail end of such
options as QueueAdminCC EmailAddress
On Jul 16, 2008, at 6:21 PM, Jeff Voskamp wrote:
Jesse Vincent wrote:
On Jul 16, 2008, at 5:36 PM, Jeff Voskamp wrote:
There's some nice new options for Search/Build.html (such as all
the Queue* stuff, but the label field is a bit narrow.
Attached is a patch that allows me to see the
you should read this:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
On Thu, Jul 17, 2008 at 1:21 AM, Raphael [EMAIL PROTECTED] wrote:
hi all,
tried to upgrade the database with the following command (from version 3.6.6
to 3.8.0):
rt-setup-database --dba root
Thanks Ruslan ... items 1 3 turned out to be in the same set of
Callbacks originally from the University of Kent, which worked just
fine when I moved it to 3.8 from 3.6.5. Item 2: I've opened a ticket.
You made my day ... :o)
Bill Davis
Ruslan Zakirov wrote:
On Thu, Jul 17, 2008 at
Looking through the RT_Config.pm file, I've set this in my site config
file:
Set($PreferRichText, 1);
However, colored text still does not display in emails sent by RT nor in
the ticket display view - only while creating text while commenting,
replying, etc. Bold and italicized email displays,
I think my experience will not help anyone, but it's from all the others, so I
think it can be usefull:
I had the same problem in my production RT server. But I did a brand new
installation of RT 3.8 in my personal computer, then I removed completely the
database and restored a copy from the
Hi all,
I was wondering if anyone's familiar with any such add-ons for RT or even
had some experience setting one up?
I've come across this:
http://wiki.bestpractical.com/view/AssetTracker
Unfortunately it looks like a relatively dead project nowadays.
Still, I wouldn't mind have a
Update-
Ok, after several hours of logging, what I see most common in the slow
query (1s) log is:
LOG: duration: 3151.786 ms statement: EXECUTE unnamed [PREPARE:
SELECT * FROM Groups WHERE LOWER(Domain) = LOWER($1) AND LOWER(Type)
= LOWER($2)]
Several hundred of these queries in the slow
Hi all,
I'm hoping someone can provide some insight/thoughts on an issue I am
having with a wget request for a page from RT.
If I do the following from the web browser I get exactly what I'd
expect, including all of the CustomField requested data:
My sincere apologies for wasting everyone's time. It was a permissions
problem on the custom field.
Doh!
Thanks to everyone who thought about it for a moment.
BenR
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ben
Robson
Sent: Thursday, 17 July 2008 2:01 PM
To:
53 matches
Mail list logo