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 586. 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 Sent from the Request Tracker - User mailing list archive at Nabble.com. --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016