[rt-users] Can't initialize RT4 MySQL DB - RT core system objects fails

pganeshar Puvi.Ganeshar at flexity.com
Thu Jun 16 13:25:10 EDT 2016


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.



More information about the rt-users mailing list