[Rt-devel] Problems updating to RT 3.8.0

[Tim Cutts]

Many thanks for your reply.

On 17 Jul 2008, at 3:13 pm, bertbat wrote:

>
>
> Tim Cutts-2 wrote:
>>
>> # /itch/rt-3.8.0/sbin/rt-setup-database --action schema --datadir  
>> 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 rtuser
>> Please specify that user's database password below. If the user has  
>> no
>> database
>> password, just press return.
>>
>
> I think you probably got the datadir wrong. Try
> /itch/rt-3.8.0/etc/upgrade/3.5.1 as the datadir.

Nope, still doesn't work.  The upgrade dirs are where I initially  
unpacked the software:

# ls /itch/rt-3.8.0-tmp/etc/upgrade
3.1.0	3.7.1	3.7.82				 3.8-ical-extension
3.1.15	3.7.10	3.7.85				 3.8-ical-extension.in
3.1.17	3.7.15	3.7.86				 3.8.0
3.3.0	3.7.19	3.7.87				 schema.mysql-4.0-4.1.pl
3.3.11	3.7.3	3.8-branded-queues-extension	 shrink_cgm_table.pl
3.5.1	3.7.81	3.8-branded-queues-extension.in

So they're all there.  Now, when I try to apply them, with the full  
path this time:

# /itch/rt-3.8.0/sbin/rt-setup-database --action schema --datadir / 
itch/rt-3.8.0-tmp/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 rtuser
Please specify that user's database password below. If the user has no  
database
password, just press return.

Password:
Working with:
Type:	mysql
Host:	localhost
Name:	rtdb
User:	rtuser
DBA:	rtuser
Now populating database schema.
Couldn't finish 'schema' step.

ERROR: Couldn't find schema file(s) '*'

I've now run the script through the perl debugger, and it's looking  
for files in the patch datadir called 'schema' or 'schema.mysql'.   
There's no such file.  Is it expected that in some patches there's no  
schema change?   I sort of figured there had to be one for 3.5.1 for  
the changes in the UI that happened in RT 3.6.  If it *is* OK that  
it's not there, then should I just proceed with the next steps, even  
though it's reported this error?

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.