[rt-users] Install/Upgrade issue
Sears, Mark
Mark.Sears at GDIT.com
Thu May 22 15:58:24 EDT 2014
That worked…actually swapped command around using RHEL.
Now I ran into another error doing make-upgrade database
1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <STDIN> line 5. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa62d778) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <STDIN> line 5. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa62d778) couldn't prepare the query 'INSERT INTO Attributes (ContentType, ObjectType, ObjectId, Description, Created, LastUpdated, id, Name, Content, Creator, LastUpdatedBy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <STDIN> line 5. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa62d778) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Users at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <STDIN> line 5. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT * FROM Users WHERE Name = ?'no such table: Users (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Users at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <STDIN> line 5. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT * FROM Users WHERE Name = ?'no such table: Users (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
Now inserting data.
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <$handle> line 1. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <$handle> line 1. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <$handle> line 1. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <$handle> line 1. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <$handle> line 1. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'INSERT INTO Attributes (Created, LastUpdated, ContentType, ObjectType, Description, ObjectId, Content, Creator, LastUpdatedBy, id, Name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <$handle> line 1. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Groups at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Groups main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) WHERE (Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'Group') AND (main.Domain = 'SystemInternal') AND (main.Name != main.Type OR main.Name IS NULL) ORDER BY main.Name ASC LIMIT 1'no such table: Groups (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: ObjectCustomFields at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT DISTINCT main.* FROM ObjectCustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomField = main.CustomField ) WHERE (ObjectCustomFields_1.ObjectId = '0') AND (main.ObjectId != '0') ORDER BY main.SortOrder ASC, main.id ASC 'no such table: ObjectCustomFields (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: ObjectCustomFields at ./etc/upgrade/3.8.8/content line 21, <> line 2. (./etc/upgrade/3.8.8/content:21)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'INSERT INTO Attributes (Created, LastUpdated, ObjectType, ContentType, Description, ObjectId, Content, LastUpdatedBy, Creator, Name, id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [warning]: DBD::SQLite::db prepare failed: no such table: Attributes at /usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm line 549, <> line 2. (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:549)
[20229] [Thu May 22 19:57:12 2014] [warning]: RT::Handle=HASH(0xa7263e8) couldn't prepare the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectId = 1) AND (main.ObjectType = 'RT::System') ORDER BY main.id ASC 'no such table: Attributes (/usr/local/lib/perl5/site_perl/5.20.0/DBIx/SearchBuilder/Handle.pm:556)
[20229] [Thu May 22 19:57:12 2014] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/root/Desktop/Software/rt-4.2.4/sbin/../lib/RT/Attributes.pm:84)
Couldn't finish 'upgrade' step.
ERROR: One of initial functions failed: Can't call method "execute" on an undefined value at ./etc/upgrade/3.8.8/content line 27, <> line 2.
make: *** [upgrade-database] Error 255
Thoughts??
Thanks,
Mark Sears – CISSP-M.S. IA
Principal Information Security Analyst
[cid:image001.png at 01CE728F.61780B30]
12249 Science Drive Suite 160
Orlando, FL 32826
office: (407) 541-4062
fax: (407) 380-3823
mark.sears at gdit.com<mailto:mark.sears at gdit.com>
www.gdit.com<http://www.gdit.com/>
From: lenjaffe at gmail.com [mailto:lenjaffe at gmail.com] On Behalf Of Len Jaffe
Sent: Thursday, May 22, 2014 2:18 PM
To: Sears, Mark
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Install/Upgrade issue
$ addgroup www-data
will add an entry for the www-data group to the groups file.
On Thu, May 22, 2014 at 2:11 PM, Sears, Mark <Mark.Sears at gdit.com<mailto:Mark.Sears at gdit.com>> wrote:
I'm running into the following error when upgrading.
>>
>> All dependencies have been found, but when I run "make upgrade" it errors out with the following after re-checking dependencies:
>>
>> ./install-sh -m 0755 -o root -g www-data -d /opt/rt4/etc
>> chgrp: invalid group: `www-data'
>> make: *** [config-install] Error 1
>>
How can I set this group
Thanks,
Mark Sears – CISSP-M.S. IA
Principal Information Security Analyst
12249 Science Drive Suite 160
Orlando, FL 32826
office: (407) 541-4062<tel:%28407%29%20541-4062>
fax: (407) 380-3823<tel:%28407%29%20380-3823>
mark.sears at gdit.com<mailto:mark.sears at gdit.com>
www.gdit.com<http://www.gdit.com/>
--
RT Training - Boston, September 9-10
http://bestpractical.com/training
--
lenjaffe at jaffesystems.com<mailto:lenjaffe at jaffesystems.com> 614-404-4214 @lenjaffe
Information Technology Smoke Jumper, Host of Columbus Code Jam<http://www.meetup.com/techlifecolumbus/>
www.lenjaffe.com<http://www.lenjaffe.com/> http://www.theycomewithcheese.com<http://www.theycomewithcheese.com/>
Advent Planet<http://www.lenjaffe.com/AdventPlanet/> - An Aggregation of Online Advent Calendars.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140522/10c9498c/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1262 bytes
Desc: image001.png
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140522/10c9498c/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 631 bytes
Desc: image002.jpg
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140522/10c9498c/attachment.jpg>
More information about the rt-users
mailing list