Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Initdb AssetTracker v3.2 fails for Rt 4.2.0 #63

Open
bmt-johnboers opened this issue Nov 8, 2013 · 0 comments
Open

Initdb AssetTracker v3.2 fails for Rt 4.2.0 #63

bmt-johnboers opened this issue Nov 8, 2013 · 0 comments

Comments

@bmt-johnboers
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant