Skip to content

Initdb AssetTracker v3.2 fails for Rt 4.2.0 #63

@bmt-johnboers

Description

@bmt-johnboers

I am installing AssetTracker as part of my RT 4.2.0 system on a Debian 6.0 64-bit system. I am using v3.2 for rt 4.2 version from github.

Everything goes fine until make initdb. During the insert data step the following errors appear:

/usr/bin/perl -Ilib -I/data/opt/rt4/local/lib -I/opt/rt4/lib /data/opt/rt4/sbin/rt-setup-database --action insert --datadir etc --datafile etc/initialdata --dba postgres --prompt-for-dba-password --package RTx::AssetTracker --ext-version 3.0.0
In order to create or update your RT database, this script needs to connect to your Pg instance on localhost (port '') as postgres
Please specify that user's database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: Pg
Host: localhost
Port:
Name: rt4
User: rt_user
DBA: postgres
Now inserting data.
Creating default asset types...(Error: at_default is not a valid lifecycle)0.done.
Creating default asset scrips conditions...[22487] [Fri Nov 8 13:30:57 2013] [warning]: DBD::Pg::st execute failed: ERROR: permission denied for relation at_scripconditions at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 589, <$handle> line 1. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:589)
[22487] [Fri Nov 8 13:30:57 2013] [warning]: RT::Handle=HASH(0x3b1bd78) couldn't execute the query 'INSERT INTO AT_ScripConditions (ApplicableTransTypes, Creator, LastUpdatedBy, Argument, Created, ExecModule, LastUpdated, Name, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 602, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x3b1bd78), "INSERT INTO AT_ScripConditions (ApplicableTransTypes, Creator"..., "Any", 1, 1, undef, "2013-11-08 13:30:57", "UserDefined", "2013-11-08 13:30:57", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x3b1bd78), "AT_ScripConditions", "ApplicableTransTypes", "Any", "Creator", 1, "LastUpdatedBy", 1, "Argument", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert(RT::Handle=HASH(0x3b1bd78), "AT_ScripConditions", "ApplicableTransTypes", "Any", "Creator", 1, "LastUpdatedBy", 1, "Argument", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RTx::AssetTracker::ScripCondition=HASH(0x6d45d40), "ApplicableTransTypes", "Any", "Creator", 1, "LastUpdatedBy", 1, "Argument", undef, ...) called at /data/opt/rt4/sbin/../lib/RT/Record.pm line 337
RT::Record::Create(RTx::AssetTracker::ScripCondition=HASH(0x6d45d40), "ApplicableTransTypes", "Any", "Argument", undef, "ExecModule", "UserDefined", "Description", "Whenever a user-defined condition occurs", ...) called at lib/RTx/AssetTracker/ScripCondition.pm line 109
RTx::AssetTracker::ScripCondition::Create(RTx::AssetTracker::ScripCondition=HASH(0x6d45d40), "ApplicableTransTypes", "Any", "Argument", undef, "ExecModule", "UserDefined", "Description", "Whenever a user-defined condition occurs", ...) called at etc/initialdata line 39
RT::Handle::AssetScripConditions() called at /data/opt/rt4/sbin/../lib/RT/Handle.pm line 1177
eval {...} called at /data/opt/rt4/sbin/../lib/RT/Handle.pm line 1177
RT::Handle::InsertData(RT::Handle=HASH(0x3b1bd78), "etc/initialdata", undef) called at /data/opt/rt4/sbin/rt-setup-database line 380
main::ANON() called at /data/opt/rt4/sbin/rt-setup-database line 393
main::action_insert("prompt-for-dba-password", 1, "datafile", "etc/initialdata", "action", "insert", "ext-version", "3.0.0", "datadir", ...) called at /data/opt/rt4/sbin/rt-setup-database line 208 (/usr/local/share/perl/5.10.1/Carp.pm:169)
(Error: Internal Error: Couldn't execute the query 'INSERT INTO AT_ScripConditions (ApplicableTransTypes, Creator, LastUpdatedBy, Argument, Created, ExecModule, LastUpdated, Name, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)'ERROR: permission denied for relation at_scripconditions)0.done.
Creating default asset scrips actions...[22487] [Fri Nov 8 13:30:57 2013] [warning]: DBD::Pg::st execute failed: ERROR: permission denied for relation at_scripactions at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 589, <$handle> line 1. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:589)
[22487] [Fri Nov 8 13:30:57 2013] [warning]: RT::Handle=HASH(0x3b1bd78) couldn't execute the query 'INSERT INTO AT_ScripActions (Creator, LastUpdatedBy, Argument, Created, ExecModule, LastUpdated, Name, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 602, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x3b1bd78), "INSERT INTO AT_ScripActions (Creator, LastUpdatedBy, Argument"..., 1, 1, undef, "2013-11-08 13:30:57", "UserDefined", "2013-11-08 13:30:57", "User Defined", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x3b1bd78), "AT_ScripActions", "Creator", 1, "LastUpdatedBy", 1, "Argument", undef, "Created", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert(RT::Handle=HASH(0x3b1bd78), "AT_ScripActions", "Creator", 1, "LastUpdatedBy", 1, "Argument", undef, "ExecModule", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RTx::AssetTracker::ScripAction=HASH(0x6d45d40), "Creator", 1, "LastUpdatedBy", 1, "Argument", undef, "Created", "2013-11-08 13:30:57", ...) called at /data/opt/rt4/sbin/../lib/RT/Record.pm line 337
RT::Record::Create(RTx::AssetTracker::ScripAction=HASH(0x6d45d40), "Argument", undef, "ExecModule", "UserDefined", "Description", "Perform a user-defined action", "Name", "User Defined", ...) called at lib/RTx/AssetTracker/ScripAction.pm line 105
RTx::AssetTracker::ScripAction::Create(RTx::AssetTracker::ScripAction=HASH(0x6d45d40), "Argument", undef, "ExecModule", "UserDefined", "Description", "Perform a user-defined action", "Name", "User Defined", ...) called at etc/initialdata line 58
RT::Handle::AssetScripActions() called at /data/opt/rt4/sbin/../lib/RT/Handle.pm line 1177
eval {...} called at /data/opt/rt4/sbin/../lib/RT/Handle.pm line 1177
RT::Handle::InsertData(RT::Handle=HASH(0x3b1bd78), "etc/initialdata", undef) called at /data/opt/rt4/sbin/rt-setup-database line 380
main::ANON() called at /data/opt/rt4/sbin/rt-setup-database line 393
main::action_insert("prompt-for-dba-password", 1, "datafile", "etc/initialdata", "action", "insert", "ext-version", "3.0.0", "datadir", ...) called at /data/opt/rt4/sbin/rt-setup-database line 208 (/usr/local/share/perl/5.10.1/Carp.pm:169)
(Error: Internal Error: Couldn't execute the query 'INSERT INTO AT_ScripActions (Creator, LastUpdatedBy, Argument, Created, ExecModule, LastUpdated, Name, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'ERROR: permission denied for relation at_scripactions)0.done.
Creating default asset templates...[22487] [Fri Nov 8 13:30:57 2013] [warning]: DBD::Pg::st execute failed: ERROR: permission denied for relation at_templates at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 589, <$handle> line 1. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:589)
[22487] [Fri Nov 8 13:30:57 2013] [warning]: RT::Handle=HASH(0x3b1bd78) couldn't execute the query 'INSERT INTO AT_Templates (AssetType, Creator, LastUpdatedBy, Type, Created, Content, LastUpdated, Name, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 602, <$handle> line 1.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x3b1bd78), "INSERT INTO AT_Templates (AssetType, Creator, LastUpdatedBy, "..., 0, 1, 1, "Perl", "2013-11-08 13:30:57", undef, "2013-11-08 13:30:57", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x3b1bd78), "AT_Templates", "AssetType", 0, "Creator", 1, "LastUpdatedBy", 1, "Type", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert(RT::Handle=HASH(0x3b1bd78), "AT_Templates", "AssetType", 0, "Creator", 1, "Type", "Perl", "LastUpdatedBy", ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RTx::AssetTracker::Template=HASH(0x6d3de20), "AssetType", 0, "Creator", 1, "LastUpdatedBy", 1, "Type", "Perl", ...) called at /data/opt/rt4/sbin/../lib/RT/Record.pm line 337
RT::Record::Create(RTx::AssetTracker::Template=HASH(0x6d3de20), "Content", undef, "AssetType", 0, "Description", "A blank template", "Name", "Blank", ...) called at lib/RTx/AssetTracker/Template.pm line 260
RTx::AssetTracker::Template::Create(RTx::AssetTracker::Template=HASH(0x6d3de20), "AssetType", 0, "Content", undef, "Description", "A blank template", "Name", "Blank", ...) called at etc/initialdata line 77
RT::Handle::AssetTemplates() called at /data/opt/rt4/sbin/../lib/RT/Handle.pm line 1177
eval {...} called at /data/opt/rt4/sbin/../lib/RT/Handle.pm line 1177
RT::Handle::InsertData(RT::Handle=HASH(0x3b1bd78), "etc/initialdata", undef) called at /data/opt/rt4/sbin/rt-setup-database line 380
main::ANON() called at /data/opt/rt4/sbin/rt-setup-database line 393
main::action_insert("prompt-for-dba-password", 1, "datafile", "etc/initialdata", "action", "insert", "ext-version", "3.0.0", "datadir", ...) called at /data/opt/rt4/sbin/rt-setup-database line 208 (/usr/local/share/perl/5.10.1/Carp.pm:169)
(Error: )0.done.
Done inserting data.
Done.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions