Hello,
I am trying to install RT-4.4.0 on CentOS 6.6. I have successfully installed
all the Perl libs and mods and stuck at the “make initialize-database” stage
currently.
Its failing at the “Now inserting RT core system objects.” step.
From the stack trace I believe the problem is originated here:
[warning]: DBD::mysql::st execute failed: Unknown column ‘ObjectId’ in
‘field list’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
Here is the whole stack trace:
make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
–action init --prompt-for-dba-password
Subroutine IsGroup redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 76.
Subroutine IsUser redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 96.
Subroutine Object redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 116.
Subroutine GrantRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 153.
Subroutine RevokeRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 190.
Subroutine HasRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 286.
Subroutine _HasRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 376.
Subroutine _HasGroupRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 394.
Subroutine _HasRoleRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 448.
Subroutine RolesWithRight redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 520.
Subroutine InvalidateACLCache redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 585.
Subroutine _GetPrincipalTypeForACL redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 606.
Subroutine _ReferenceId redefined at
/usr/share/perl5/vendor_perl/RT/Principal_Overlay.pm line 632.
Subroutine _InitSQL redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 64.
Subroutine _OpenParen redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 106.
Subroutine _CloseParen redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 109.
Subroutine _parser redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 171.
Subroutine ClausesToSQL redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 247.
Subroutine FromSQL redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 282.
Subroutine Query redefined at
/usr/share/perl5/vendor_perl/RT/Tickets_Overlay_SQL.pm line 348.
In order to create or update your RT database, this script needs to connect
to your mysql instance on localhost (port ‘’) as root
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
Port:
Name: rt4
User: rt_user
DBA: root
[24612] [Thu Jun 16 17:28:31 2016] [warning]: max_allowed_packet is set to
1.0M, which limits the maximum attachment or email size that RT can process.
Consider adjusting MySQL’s max_allowed_packet setting.
(/tmp/rt-4.4.0/sbin/…/lib/RT/Handle.pm:307)
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Done.
Now inserting RT core system objects.
[24612] [Thu Jun 16 17:28:31 2016] [warning]: DBD::mysql::st execute failed:
Unknown column ‘ObjectId’ in ‘field list’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[24612] [Thu Jun 16 17:28:31 2016] [warning]: RT::Handle=HASH(0x4d39290)
couldn’t execute the query ‘INSERT INTO Principals (PrincipalType, ObjectId)
VALUES (?, ?)’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x4d39290),
“INSERT INTO Principals (PrincipalType, ObjectId) VALUES (?, ?)”, “User”, 0)
called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x4d39290),
“Principals”, “PrincipalType”, “User”, “ObjectId”, 0) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm line 36
DBIx::SearchBuilder::Handle::mysql::Insert(RT::Handle=HASH(0x4d39290),
“Principals”, “PrincipalType”, “User”, “ObjectId”, 0) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RT::Principal=HASH(0x4d1aa48),
“PrincipalType”, “User”, “ObjectId”, 0) called at
/tmp/rt-4.4.0/sbin/…/lib/RT/Record.pm line 317
RT::Record::Create(RT::Principal=HASH(0x4d1aa48), “PrincipalType”, “User”,
“ObjectId”, 0) called at /usr/share/perl5/vendor_perl/RT/User_Overlay.pm
line 381
RT::User::_BootstrapCreate(RT::User=HASH(0x4d2a088), “Name”, “RT_System”,
“RealName”, “The RT System itself”, “Comments”, “Do not delete or modify
this user. It is integral to RT’s int”…, “Creator”, …) called at
/tmp/rt-4.4.0/sbin/…/lib/RT/Handle.pm line 692
RT::Handle::InsertInitialData(RT::Handle=HASH(0x4d39290)) called at
sbin/rt-setup-database line 348
main::action_coredata(“prompt-for-dba-password”, 1, “action”, “init”,
“package”, “RT”) called at sbin/rt-setup-database line 210
(/usr/local/share/perl5/Carp.pm:170)
[24612] [Thu Jun 16 17:28:31 2016] [warning]: DBD::mysql::st execute failed:
Unknown column ‘ObjectId’ in ‘field list’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[24612] [Thu Jun 16 17:28:31 2016] [warning]: RT::Handle=HASH(0x4d39290)
couldn’t execute the query 'UPDATE Principals SET ObjectId=? WHERE id=? ’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x4d39290),
"UPDATE Principals SET ObjectId=? WHERE id=? ", 0, undef) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 453
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x4d39290),
“Table”, “Principals”, “IsSQLFunction”, undef, “Column”, “ObjectId”,
“PrimaryKeys”, …) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Principal=HASH(0x4d1aa48), “Field”,
“ObjectId”, “Value”, 0) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Principal=HASH(0x4d1aa48),
“Field”, “ObjectId”, “Value”, 0) called at
/usr/share/perl5/vendor_perl/RT/User_Overlay.pm line 382
RT::User::_BootstrapCreate(RT::User=HASH(0x4d2a088), “Name”, “RT_System”,
“RealName”, “The RT System itself”, “Comments”, “Do not delete or modify
this user. It is integral to RT’s int”…, “Creator”, …) called at
/tmp/rt-4.4.0/sbin/…/lib/RT/Handle.pm line 692
RT::Handle::InsertInitialData(RT::Handle=HASH(0x4d39290)) called at
sbin/rt-setup-database line 348
main::action_coredata(“prompt-for-dba-password”, 1, “action”, “init”,
“package”, “RT”) called at sbin/rt-setup-database line 210
(/usr/local/share/perl5/Carp.pm:170)
[24612] [Thu Jun 16 17:28:31 2016] [critical]: Couldn’t create a Principal
on new user create. Strange things are afoot at the circle K
(/usr/share/perl5/vendor_perl/RT/User_Overlay.pm:387)
Couldn’t finish ‘coredata’ step.
ERROR: Could not create user
make: *** [initialize-database] Error 255
Can someone help me to resolve this issue so I can get this up and running.
Thank you.
Regards,
Puvi
View this message in context: http://requesttracker.8502.n7.nabble.com/Can-t-initialize-RT4-MySQL-DB-RT-core-system-objects-fails-tp62035.html