Sorry if this is a duplicate, but I noticed that I sent this message from
a different email account, so I assume it was hung up in moderation if not
disposed of entirely.
I installed RT3 last week, and was having some problems getting it to work.
I then saw that RT4 was released (Earlier I used the package for FC16),
so I downloaded that (4.0.5) and built it. This is also running on FC16.
All packages are up to date, including CPAN stuff.
I do OK until I get to the step where we create a new database. I deleted
the rt3 database and ran "make initialize-database". This starts out good,
but then runs into a problem as shown below:
I've searched on Google and the mailing list archives, but see no mention
of such a beast. The rest of the install seems fine, as I was able to
run it against the RT3 database (I did save a copy). Well OK until I went
to access queues, then httpd goes nuts. I'm chocking that up to an
incompatibility in the database, I'm sure the schema changed.
So it seems really important that I have a pristine RT4 database, yet the
script is dying. Below is output with no RT databases existing. Does
anyone have any
recommendations?
----------------------
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rt_user
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rt_user@'localhost' on rt4.
Done.
Now inserting RT core system objects.
[Fri Mar 2 00:22:14 2012] [warning]: DBD::mysql::st execute failed:
Unknown column
'DelegatedFrom' in 'where clause' at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm:587)
[Fri Mar 2 00:22:14 2012] [warning]: RT::Handle=HASH(0x354e8f8)
couldn't execute the
query 'SELECT * FROM ACL WHERE PrincipalType = ? AND PrincipalId = ?
AND DelegatedFrom =
? AND RightName = ? AND DelegatedBy = ? AND ObjectType = ? AND
ObjectId = ?' at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 600
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x354e8f8)',
'SELECT *
FROM ACL WHERE PrincipalType = ? AND PrincipalId = ...', 'Group', 7,
0, 'OwnTicket', 0,
'RT::System', 1, ...) called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Record.pm
line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::ACE=HASH(0x3688320)',
'SELECT *
FROM ACL WHERE PrincipalType = ? AND PrincipalId = ...', 'Group', 7,
0, 'OwnTicket', 0,
'RT::System', 1, ...) called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Record.pm
line 1125
DBIx::SearchBuilder::Record::LoadByCols('RT::ACE=HASH(0x3688320)',
'PrincipalType', 'Group', 'DelegatedFrom', 0, 'PrincipalId', 7,
'DelegatedBy', 0, ...)
called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Record/Cachable.pm
line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::ACE=HASH(0x3688320)',
'PrincipalId', 7, 'PrincipalType', 'Group', 'RightName', 'OwnTicket',
'ObjectType',
'RT::System', ...) called at
/home/jon/dist/rt-4.0.5/sbin/../lib/RT/Record.pm line 375
RT::Record::LoadByCols('RT::ACE=HASH(0x3688320)', 'PrincipalId', 7,
'PrincipalType', 'Group', 'RightName', 'OwnTicket', 'ObjectType',
'RT::System', ...)
called at /usr/share/perl5/vendor_perl/RT/ACE_Overlay.pm line 287
RT::ACE::Create('RT::ACE=HASH(0x3688320)', 'RightName',
'OwnTicket', 'Object',
'RT::System=HASH(0x3688dd0)', 'PrincipalType', 'User', 'PrincipalId',
6, ...) called at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 168
RT::Principal::GrantRight('RT::Principal=HASH(0x36afa58)',
'Right', 'OwnTicket',
'Object', 'RT::System=HASH(0x3688dd0)') called at
/home/jon/dist/rt-4.0.5/sbin/../lib/RT/Handle.pm line 704
RT::Handle::InsertInitialData('RT::Handle=HASH(0x354e8f8)') called at
sbin/rt-setup-database line 262
main::action_coredata('prompt-for-dba-password', 1, 'action',
'init', 'dba',
'root') called at sbin/rt-setup-database line 198
(/usr/share/perl5/Carp.pm:65)
[Fri Mar 2 00:22:14 2012] [warning]: DBD::mysql::st execute failed:
Unknown column
'DelegatedFrom' in 'field list' at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm:587)
[Fri Mar 2 00:22:14 2012] [warning]: RT::Handle=HASH(0x354e8f8)
couldn't execute the
query 'INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
Creator, ObjectId,
LastUpdatedBy, PrincipalType, Created, DelegatedBy, LastUpdated,
ObjectType) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 600
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x354e8f8)',
'INSERT
INTO ACL (PrincipalId, DelegatedFrom, RightName, Creat...', 7, 0,
'OwnTicket', 1, 1, 1,
'Group', ...) called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 350
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x354e8f8)', 'ACL',
'PrincipalId', 7, 'DelegatedFrom', 0, 'RightName', 'OwnTicket',
'Creator', ...) called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle/mysql.pm line 36
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x354e8f8)',
'ACL',
'PrincipalId', 7, 'DelegatedFrom', 0, 'RightName', 'OwnTicket',
'Creator', ...) called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Record.pm line 1292
DBIx::SearchBuilder::Record::Create('RT::ACE=HASH(0x3688320)',
'DelegatedFrom',
0, 'PrincipalId', 7, 'Creator', 1, 'RightName', 'OwnTicket', ...) called at
/home/jon/dist/rt-4.0.5/sbin/../lib/RT/Record.pm line 316
RT::Record::Create('RT::ACE=HASH(0x3688320)', 'PrincipalId',
7, 'PrincipalType',
'Group', 'RightName', 'OwnTicket', 'ObjectType', 'RT::System', ...) called at
/usr/share/perl5/vendor_perl/RT/ACE_Overlay.pm line 298
RT::ACE::Create('RT::ACE=HASH(0x3688320)', 'RightName',
'OwnTicket', 'Object',
'RT::System=HASH(0x3688dd0)', 'PrincipalType', 'User', 'PrincipalId',
6, ...) called at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 168
RT::Principal::GrantRight('RT::Principal=HASH(0x36afa58)',
'Right', 'OwnTicket',
'Object', 'RT::System=HASH(0x3688dd0)') called at
/home/jon/dist/rt-4.0.5/sbin/../lib/RT/Handle.pm line 704
RT::Handle::InsertInitialData('RT::Handle=HASH(0x354e8f8)') called at
sbin/rt-setup-database line 262
main::action_coredata('prompt-for-dba-password', 1, 'action',
'init', 'dba',
'root') called at sbin/rt-setup-database line 198
(/usr/share/perl5/Carp.pm:65)
Couldn't finish 'coredata' step.
ERROR: System error. Right not granted.
make: *** [initialize-database] Error 255
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
