Install/Upgrade issue

RT Users
1

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
[cid:image001.png@01CE728F.61780B30]
12249 Science Drive Suite 160
Orlando, FL 32826
office: (407) 541-4062
fax: (407) 380-3823
mark.sears@gdit.commailto:mark.sears@gdit.com
www.gdit.comhttp://www.gdit.com/

2

$ 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@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
fax: (407) 380-3823
mark.sears@gdit.com mark.sears@gdit.com
www.gdit.com http://www.gdit.com/

–
RT Training - Boston, September 9-10
http://bestpractical.com/training

lenjaffe@jaffesystems.com 614-404-4214 @lenjaffe
Information Technology Smoke Jumper, Host of Columbus Code
Jamhttp://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Advent Planet http://www.lenjaffe.com/AdventPlanet/ - An Aggregation of
Online Advent Calendars.

3

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, 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, 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, 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, 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, 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@01CE728F.61780B30]
12249 Science Drive Suite 160
Orlando, FL 32826
office: (407) 541-4062
fax: (407) 380-3823
mark.sears@gdit.commailto:mark.sears@gdit.com
www.gdit.comhttp://www.gdit.com/From: lenjaffe@gmail.com [mailto:lenjaffe@gmail.com] On Behalf Of Len Jaffe
Sent: Thursday, May 22, 2014 2:18 PM
To: Sears, Mark
Cc: rt-users@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.

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-4062tel:(407)%20541-4062
fax: (407) 380-3823tel:(407)%20380-3823
mark.sears@gdit.commailto:mark.sears@gdit.com
www.gdit.comhttp://www.gdit.com/

RT Training - Boston, September 9-10
http://bestpractical.com/training

lenjaffe@jaffesystems.commailto:lenjaffe@jaffesystems.com 614-404-4214 @lenjaffe
Information Technology Smoke Jumper, Host of Columbus Code Jamhttp://www.meetup.com/techlifecolumbus/
www.lenjaffe.comhttp://www.lenjaffe.com/ http://www.theycomewithcheese.comhttp://www.theycomewithcheese.com/
Advent Planethttp://www.lenjaffe.com/AdventPlanet/ - An Aggregation of Online Advent Calendars.

4

That worked…actually swapped command around using RHEL.

Now I ran into another error doing make-upgrade database

Instead of adding groups, why not just tell RT the right group to use.
You didn’t show your configure output where it picked www-data so it’s
hard to advise.

Read ./configure --help as suggested in step 2 of the README

$ ./configure --help | grep group
–with-libs-group=GROUP group that will own RT binaries (default bin)
–with-web-group=GROUP group the web server runs as (default: www)
–with-rt-group=GROUP group to own all files (default: rt)

  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)

Couldn’t finish ‘upgrade’ step.

If your database has no Attributes table, it is not a complete RT
database and something went horribly wrong in your copy/restore of it.

-kevin