[rt-users] error upgrading from 3.4.5 to 3.6.4 (via etc/upgrade/3.5.1 script)
Trenton Taylor
trentt at ssi-invest.com
Mon Apr 21 17:31:00 EDT 2008
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 at lbl.gov]
Sent: Monday, April 21, 2008 2:28 PM
To: Trenton Taylor
Cc: rt-users at 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:
>
> 1. [root at 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, <SCHEMA> line 464.
>
> 2. [root at 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.
>
> 3. [root at 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, <STDIN> 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,
> <STDIN> 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 at lbl.gov]
> Sent: Monday, April 21, 2008 1:05 PM
> To: Trenton Taylor
> Cc: rt-users at 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, <STDIN> 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,
>> <STDIN> line 1.
>> (/opt/rt3/lib/RT.pm:295)
>>
>>
>>
>> Thanks for the help ... Any more ideas?
>>
>>
>>
>> -----Original Message-----
>> From: Kenneth Crocker [mailto:KFCrocker at lbl.gov]
>> Sent: Monday, April 21, 2008 12:38 PM
>> To: Trenton Taylor
>> Cc: rt-users at 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]" <enter> 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]" <enter> 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]" <enter> 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 at lbl.gov]
>>> Sent: Monday, April 21, 2008 12:02 PM
>>> To: Trenton Taylor
>>> Cc: rt-users at 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, <SCHEMA> 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.
>
------------------------------------------------------------------------
>>>> _______________________________________________
>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>
>>>> Community help: http://wiki.bestpractical.com
>>>> Commercial support: sales at 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.
More information about the rt-users
mailing list