Error upgrading from 3.4.5 to 3.6.4 (via etc/upgrade/3.5.1 script)

Trenton_Taylor · April 17, 2008, 3:30pm

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ --datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at /opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Sean_McCreadie · April 18, 2008, 6:16pm

I had the same issue several months ago and was never able to get my 3.4
database to upgrade to 3.6. It seemed like the script that was provided
was wrong in some way and I could never get it upgraded to the 3.5
schema. Does anyone have any ideas on this? I would love to get my old
ticket in use again! Thanks in advance.

Sean

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Trenton
TaylorSent: Thursday, April 17, 2008 8:30 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] error upgrading from 3.4.5 to 3.6.4
(viaetc/upgrade/3.5.1 script)

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at /opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Kenn_Crocker · April 21, 2008, 7:01pm

Trenton,

Did you get an answer to this? I just finished the same upgrade. We use

Oracle.

Kenn
LBNLOn 4/17/2008 8:30 AM, Trenton Taylor wrote:

Iï¿½m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at /opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance ï¿½

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Trenton_Taylor · April 21, 2008, 7:10pm

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional archive DB
now. We don’t have many tickets on the new DB so I could easily delete
them if someone could explain to me what is going wrong with the upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

TrentFrom: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.

We use
Oracle.

Kenn
LBNL

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,

distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender

that you have received the message in error and then delete it. Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Kenn_Crocker · April 21, 2008, 7:37pm

Trenton,

What I found was that I didn't need to BUILD the schema, just upgrade

it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),
which were:

1) action schema
2) action acl
3) action insert

Turns out, the only one that did anything was action insert. The DB

changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I
actually upgraded and forgot to run the DB upgrade part and RT worked
fine, except those two queries were NOT listed or available. I ran the
three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in terms
of schema changes) so perhaps it requires a rebuild. Here’s what I used
as my commands:

1) Typed ï¿½/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database

ï¿½dba rtadm ï¿½prompt-for-dba-password ï¿½action schema ï¿½datadir
etc/upgrade/[3.5.1]ï¿½ as one line.
2) Typed ï¿½/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
ï¿½dba rtadm ï¿½prompt-for-dba-password ï¿½action acl ï¿½datadir
etc/upgrade/[3.5.1]ï¿½ as one line.
3) Typed ï¿½/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
ï¿½dba rtadm ï¿½prompt-for-dba-password ï¿½action insert ï¿½datadir
etc/upgrade/[3.5.1]ï¿½ as one line.

Hope this helps.

Kenn
LBNLOn 4/21/2008 12:10 PM, Trenton Taylor wrote:

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional archive DB
now. We don’t have many tickets on the new DB so I could easily delete
them if someone could explain to me what is going wrong with the upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

On 4/17/2008 8:30 AM, Trenton Taylor wrote:

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,

distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender

that you have received the message in error and then delete it. Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Trenton_Taylor · April 21, 2008, 7:49pm

I tried running my old database (the one that installs with 3.4.5) and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn't need to BUILD the schema, just

upgrade
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),
which were:

1) action schema
2) action acl
3) action insert

Turns out, the only one that did anything was action insert. The

DB
changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I
actually upgraded and forgot to run the DB upgrade part and RT worked
fine, except those two queries were NOT listed or available. I ran the
three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in terms

of schema changes) so perhaps it requires a rebuild. Here’s what I used
as my commands:

1) Typed

“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.
2) Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.
3) Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional archive
DB
now. We don’t have many tickets on the new DB so I could easily delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use,
dissemination,

distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the
sender

that you have received the message in error and then delete it. Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Kenn_Crocker · April 21, 2008, 8:05pm

Trenton,

By webpage, do you mean the Homepage? In 3.6.4, the first time any user

signs on it will be blank. that’s because the homepage settings (click
“Edit” on the right of the “RT at a glance” tool bar (blue). Select what
you want to see and then click “home”. After that, the homepage will
come up with your selections every time. As to the DB upgrade, I’d
advise to run all three commands anyway, can’t hurt.

Kenn
LBNLOn 4/21/2008 12:49 PM, Trenton Taylor wrote:

I tried running my old database (the one that installs with 3.4.5) and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn’t need to BUILD the schema, just
upgrade
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),
which were:

action schema

action acl

action insert

Turns out, the only one that did anything was action insert. The
DB
changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I
actually upgraded and forgot to run the DB upgrade part and RT worked
fine, except those two queries were NOT listed or available. I ran the
three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in terms

of schema changes) so perhaps it requires a rebuild. Here’s what I used
as my commands:

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

On 4/21/2008 12:10 PM, Trenton Taylor wrote:

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional archive
DB
now. We don’t have many tickets on the new DB so I could easily delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

On 4/17/2008 8:30 AM, Trenton Taylor wrote:

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it. Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Trenton_Taylor · April 21, 2008, 8:45pm

Well now you nailed down exactly what my issue is. I don’t have the “My
Tickets” or “Unowned Tickets” in the options. When I try to run the 3
upgrade scripts, I get the following:

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action schema
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Creating database schema.
Problem with statement:

CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table ‘Attachments’ already exists at /opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action acl
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Done setting up database ACLs.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action insert
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 20:12:58 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

I obviously need to get through these scripts successfully in order to
have those options.

Any ideas?

TrentFrom: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 1:05 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

By webpage, do you mean the Homepage? In 3.6.4, the first time

any user
signs on it will be blank. that’s because the homepage settings (click
“Edit” on the right of the “RT at a glance” tool bar (blue). Select what

you want to see and then click “home”. After that, the homepage will
come up with your selections every time. As to the DB upgrade, I’d
advise to run all three commands anyway, can’t hurt.

Kenn
LBNL

I tried running my old database (the one that installs with 3.4.5) and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn’t need to BUILD the schema, just
upgrade
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),
which were:

action schema

action acl

action insert

Turns out, the only one that did anything was action insert. The
DB
changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I
actually upgraded and forgot to run the DB upgrade part and RT worked
fine, except those two queries were NOT listed or available. I ran the

three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in
terms

of schema changes) so perhaps it requires a rebuild. Here’s what I
used
as my commands:

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional archive
DB
now. We don’t have many tickets on the new DB so I could easily
delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the

reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an

intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you

have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it.
Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.

Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Kenn_Crocker · April 21, 2008, 9:27pm

Trenton,

Yep. Access to DataBases for the purpose of altering them is always

limited. I had to have the permissions changed so I could run those
scripts, then change them back to whatever. I suggest you speak to your
DBA and Unix technicians about this.

Kenn
LBNLOn 4/21/2008 1:45 PM, Trenton Taylor wrote:

Well now you nailed down exactly what my issue is. I don’t have the “My
Tickets” or “Unowned Tickets” in the options. When I try to run the 3
upgrade scripts, I get the following:

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action schema
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Creating database schema.
Problem with statement:

CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table ‘Attachments’ already exists at /opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action acl
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Done setting up database ACLs.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action insert
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 20:12:58 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

I obviously need to get through these scripts successfully in order to
have those options.

Any ideas?

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 1:05 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

By webpage, do you mean the Homepage? In 3.6.4, the first time
any user
signs on it will be blank. that’s because the homepage settings (click
“Edit” on the right of the “RT at a glance” tool bar (blue). Select what

you want to see and then click “home”. After that, the homepage will
come up with your selections every time. As to the DB upgrade, I’d
advise to run all three commands anyway, can’t hurt.

Kenn
LBNL

On 4/21/2008 12:49 PM, Trenton Taylor wrote:

I tried running my old database (the one that installs with 3.4.5) and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn’t need to BUILD the schema, just
upgrade
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),
which were:

action schema

action acl

action insert

Turns out, the only one that did anything was action insert. The
DB
changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I
actually upgraded and forgot to run the DB upgrade part and RT worked
fine, except those two queries were NOT listed or available. I ran the

three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in
terms
of schema changes) so perhaps it requires a rebuild. Here’s what I
used
as my commands:

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

On 4/21/2008 12:10 PM, Trenton Taylor wrote:

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional archive
DB
now. We don’t have many tickets on the new DB so I could easily
delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

On 4/17/2008 8:30 AM, Trenton Taylor wrote:

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the

reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an

intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you

have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it.
Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.

Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Trenton_Taylor · April 21, 2008, 9:31pm

I’m running the script as root with the root password for the SQL
database. I can give myself whatever permissions needed. Am I missing
that step? I though root had unlimited privilege to the DB.From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 2:28 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Yep. Access to DataBases for the purpose of altering them is

always
limited. I had to have the permissions changed so I could run those
scripts, then change them back to whatever. I suggest you speak to your
DBA and Unix technicians about this.

Kenn
LBNL

Well now you nailed down exactly what my issue is. I don’t have the
“My
Tickets” or “Unowned Tickets” in the options. When I try to run the 3
upgrade scripts, I get the following:

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action schema
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Creating database schema.
Problem with statement:

CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action acl
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Done setting up database ACLs.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action insert
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 20:12:58 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

I obviously need to get through these scripts successfully in order to
have those options.

Any ideas?

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 1:05 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

By webpage, do you mean the Homepage? In 3.6.4, the first time
any user
signs on it will be blank. that’s because the homepage settings (click

“Edit” on the right of the “RT at a glance” tool bar (blue). Select
what

you want to see and then click “home”. After that, the homepage will
come up with your selections every time. As to the DB upgrade, I’d
advise to run all three commands anyway, can’t hurt.

Kenn
LBNL

I tried running my old database (the one that installs with 3.4.5)
and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC
(@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line
464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn’t need to BUILD the schema, just
upgrade
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),

which were:

action schema

action acl

action insert

Turns out, the only one that did anything was action insert. The
DB
changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I

actually upgraded and forgot to run the DB upgrade part and RT worked

fine, except those two queries were NOT listed or available. I ran
the

three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in
terms
of schema changes) so perhaps it requires a rebuild. Here’s what I
used
as my commands:

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional
archive
DB
now. We don’t have many tickets on the new DB so I could easily
delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If
the

reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to
an

intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If
you

have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it.
Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.

Buy a copy at http://rtbook.bestpractical.com

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Kenn_Crocker · April 21, 2008, 10:17pm

Trenton,

I don't know how MySQL is set up.

Kenn
LBNLOn 4/21/2008 2:31 PM, Trenton Taylor wrote:

I’m running the script as root with the root password for the SQL
database. I can give myself whatever permissions needed. Am I missing
that step? I though root had unlimited privilege to the DB.

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 2:28 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Yep. Access to DataBases for the purpose of altering them is
always
limited. I had to have the permissions changed so I could run those
scripts, then change them back to whatever. I suggest you speak to your
DBA and Unix technicians about this.

Kenn
LBNL

On 4/21/2008 1:45 PM, Trenton Taylor wrote:

Well now you nailed down exactly what my issue is. I don’t have the
“My
Tickets” or “Unowned Tickets” in the options. When I try to run the 3
upgrade scripts, I get the following:

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action schema
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Creating database schema.
Problem with statement:

CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action acl
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Done setting up database ACLs.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action insert
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 20:12:58 2008] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line 464,
line 1.
(/opt/rt3/lib/RT.pm:295)

I obviously need to get through these scripts successfully in order to
have those options.

Any ideas?

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 1:05 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

By webpage, do you mean the Homepage? In 3.6.4, the first time
any user
signs on it will be blank. that’s because the homepage settings (click

“Edit” on the right of the “RT at a glance” tool bar (blue). Select
what
you want to see and then click “home”. After that, the homepage will
come up with your selections every time. As to the DB upgrade, I’d
advise to run all three commands anyway, can’t hurt.

Kenn
LBNL

On 4/21/2008 12:49 PM, Trenton Taylor wrote:

I tried running my old database (the one that installs with 3.4.5)
and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC
(@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line
464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn’t need to BUILD the schema, just
upgrade
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1),

which were:

action schema

action acl

action insert

Turns out, the only one that did anything was action insert. The
DB
changes due to 3.5.1 do not really change any schema design or major
stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used. I

actually upgraded and forgot to run the DB upgrade part and RT worked

fine, except those two queries were NOT listed or available. I ran
the
three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in
terms
of schema changes) so perhaps it requires a rebuild. Here’s what I
used
as my commands:

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

On 4/21/2008 12:10 PM, Trenton Taylor wrote:

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional
archive
DB
now. We don’t have many tickets on the new DB so I could easily
delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

On 4/17/2008 8:30 AM, Trenton Taylor wrote:

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If
the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to
an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If
you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it.
Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.
Buy a copy at http://rtbook.bestpractical.com
Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.

Trenton_Taylor · April 22, 2008, 12:23am

Kenneth,

So I ended up building a new server (VM) and installing RT 3.6 with
apt-get. Once I had RT installed and running, I restored the old RT
database over the new one (which of course broke the features I needed).
Then I copied over the upgrade directory that I needed to my home dir
and ran the rt-setup-database (from the new server
/usr/sbin/rt-setup-database) against the 3.5.1 upgrade directory that I
had just copied to my home dir. It ran fine. Now I have the upgraded DB
with the features I need.

Thanks for all the help. Here is my exact command:

root@:/home/trentt/BUILD/rt3.6# /usr/sbin/rt-setup-database
-dba root -prompt-for-dba-password -action insert -datadir
/home/trentt/BUILD/rt3.6/etc/upgrade/3.5.1

In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.

Please specify that user’s database password below. If the user has no
databasepassword, just press return.

Password:
Creating predefined searches…237.238.239.done.
Done setting up database content.

TrentFrom: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 3:17 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

I don't know how MySQL is set up.

Kenn
LBNL

I’m running the script as root with the root password for the SQL
database. I can give myself whatever permissions needed. Am I missing
that step? I though root had unlimited privilege to the DB.

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 2:28 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Yep. Access to DataBases for the purpose of altering them is
always
limited. I had to have the permissions changed so I could run those
scripts, then change them back to whatever. I suggest you speak to
your
DBA and Unix technicians about this.

Kenn
LBNL

Well now you nailed down exactly what my issue is. I don’t have the
“My
Tickets” or “Unowned Tickets” in the options. When I try to run the 3
upgrade scripts, I get the following:

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action schema
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has
no
database
password, just press return.

Password:
Creating database schema.
Problem with statement:

CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action acl
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has
no
database
password, just press return.

Password:
Done setting up database ACLs.

[root@ssilxapp00 ~]# /opt/rt3.6/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action insert
In order to create or update your RT database,this script needs to
connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has
no
database
password, just press return.

Password:
Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 20:12:58 2008] [crit]: Can’t locate /content in @INC
(@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line
464,
line 1.
(/opt/rt3/lib/RT.pm:295)

I obviously need to get through these scripts successfully in order
to
have those options.

Any ideas?

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 1:05 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

By webpage, do you mean the Homepage? In 3.6.4, the first time
any user
signs on it will be blank. that’s because the homepage settings
(click

“Edit” on the right of the “RT at a glance” tool bar (blue). Select
what
you want to see and then click “home”. After that, the homepage will
come up with your selections every time. As to the DB upgrade, I’d
advise to run all three commands anyway, can’t hurt.

Kenn
LBNL

I tried running my old database (the one that installs with 3.4.5)
and
the webpage is blank after a user logs in.

If I skip the Schema and run the Insert, I get:

Use of uninitialized value in concatenation (.) or string at
/opt/rt3.6/sbin/rt-setup-database line 164, line 1.
[Mon Apr 21 19:45:31 2008] [crit]: Can’t locate /content in @INC
(@INC
contains: /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/5.8.6 .) at /opt/rt3.6/sbin/rt-setup-database line
464,
line 1.
(/opt/rt3/lib/RT.pm:295)

Thanks for the help … Any more ideas?

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:38 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

What I found was that I didn’t need to BUILD the schema, just
upgrade
it. In fact, there are 3 DB upgrade executions we did (due to
3.5.1),

which were:

action schema

action acl

action insert

Turns out, the only one that did anything was action insert. The
DB
changes due to 3.5.1 do not really change any schema design or major

stuff like that, it merely adds two new queries (10 unowned & my
tickets) as default and updates the privileges so they can be used.
I

actually upgraded and forgot to run the DB upgrade part and RT
worked

fine, except those two queries were NOT listed or available. I ran
the
three actions and those two queries were available for home page
selection. I’m not familiar with how MySQL works as a database (in
terms
of schema changes) so perhaps it requires a rebuild. Here’s what I
used
as my commands:

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action schema -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action acl -datadir
etc/upgrade/[3.5.1]” as one line.

Typed
“/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database
-dba rtadm -prompt-for-dba-password -action insert -datadir
etc/upgrade/[3.5.1]” as one line.

Hope this helps.

Kenn
LBNL

Nope …

Still no upgraded DB. We use Mysql.

I am basically running a new instance of RT and an additional
archive
DB
now. We don’t have many tickets on the new DB so I could easily
delete
them if someone could explain to me what is going wrong with the
upgrade
script.

Kenn … what did your upgrade command look like? Anything
different
than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema
–datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)

Thanks in advance to anyone who helps out …

Trent

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Monday, April 21, 2008 12:02 PM
To: Trenton Taylor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
etc/upgrade/3.5.1 script)

Trenton,

Did you get an answer to this? I just finished the same upgrade.
We use
Oracle.

Kenn
LBNL

I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via:

command:

/opt/rt3.6/sbin/rt-setup-database --action schema \ –datadir
etc/upgrade/3.5.1 --dba root --prompt-for-dba-password

But I am getting this error:

#:

Creating database schema.

Problem with statement:

CREATE TABLE Attachments (

id INTEGER NOT NULL AUTO_INCREMENT,

TransactionId integer NOT NULL ,

Parent integer NOT NULL DEFAULT 0 ,

MessageId varchar(160) NULL ,

Subject varchar(255) NULL ,

Filename varchar(255) NULL ,

ContentType varchar(80) NULL ,

ContentEncoding varchar(80) NULL ,

Content LONGTEXT NULL ,

Headers LONGTEXT NULL ,

Creator integer NOT NULL DEFAULT 0 ,

Created DATETIME NULL ,

PRIMARY KEY (id)

) TYPE=InnoDB

Table ‘Attachments’ already exists at
/opt/rt3.6/sbin/rt-setup-database
line 220, line 464.

Thanks in advance -

Trent

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If
the
reader of this e-mail message is not an intended recipient (or the

individual responsible for the delivery of this e-mail message to
an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If
you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it.
Thank
you.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.
Buy a copy at http://rtbook.bestpractical.com
Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it.
Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use,
dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the
sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is
confidential and is intended only for the named addressee(s). If the
reader of this e-mail message is not an intended recipient (or the
individual responsible for the delivery of this e-mail message to an
intended recipient), please be advised that any re-use, dissemination,
distribution or copying of this e-mail message is prohibited. If you
have received this e-mail message in error, please reply to the sender
that you have received the message in error and then delete it. Thank
you.

Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you.