Ankarloo, Gustaf
2014-10-15 14:06:58 UTC
Hi I'm getting the following error trying to run netdisco-deploy
And I haven't found any answers in the mailinglist
***@NetDisco2:~$ ~/bin/netdisco-deploy
This is the Netdisco II deployment script.
Before we continue, the following prerequisites must be in place:
* Database added to PostgreSQL for Netdisco
* User added to PostgreSQL with rights to the Netdisco Database
* "~/environments/deployment.yml" file configured with Database dsn/user/pass
* A full backup of any existing Netdisco database data
* Internet access (for OUIs and MIBs)
You will be asked to confirm all changes to your system.
So, is all the above in place? [y/N]: y
Would you like to deploy or upgrade your database schema? [y/N]: y
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently unversioned. Please call upgrade on your schema to sync the DB. at /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
DBIx::Class::Storage::DBI::catch {...} (): DBIx::Class::Storage::DBI::try {...} (): DBI Exception (unhandled by DBIC, ::Schema GCed): DBD::Pg::db do failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /home/netdisco/perl5/bin/netdisco-db-deploy line 88
(running "CREATE TABLE dbix_class_schema_versions (
version character varying(10) NOT NULL,
installed character varying(20) NOT NULL,
PRIMARY KEY (version)
)") at /home/netdisco/perl5/bin/netdisco-db-deploy line 88
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception (unhandled by DBIC, ::Schema GCed): DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [for Statement "INSERT INTO dbix_class_schema_versions ( installed, version) VALUES ( ?, ? )" with ParamValues: 1='v20141015_140324.825', 2='1'] at /home/netdisco/perl5/bin/netdisco-db-deploy line 88
DB schema update complete.
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently unversioned. Please call upgrade on your schema to sync the DB. at /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception (unhandled by DBIC, ::Schema GCed): DBD::Pg::st execute failed: ERROR: relation "users" does not exist
LINE 1: SELECT COUNT( * ) FROM users me WHERE ( admin )
^ [for Statement "SELECT COUNT( * ) FROM users me WHERE ( admin )"] at /home/netdisco/bin/netdisco-deploy line 129
Any thoughts ?
Cheers \\Gustaf
And I haven't found any answers in the mailinglist
***@NetDisco2:~$ ~/bin/netdisco-deploy
This is the Netdisco II deployment script.
Before we continue, the following prerequisites must be in place:
* Database added to PostgreSQL for Netdisco
* User added to PostgreSQL with rights to the Netdisco Database
* "~/environments/deployment.yml" file configured with Database dsn/user/pass
* A full backup of any existing Netdisco database data
* Internet access (for OUIs and MIBs)
You will be asked to confirm all changes to your system.
So, is all the above in place? [y/N]: y
Would you like to deploy or upgrade your database schema? [y/N]: y
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently unversioned. Please call upgrade on your schema to sync the DB. at /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
DBIx::Class::Storage::DBI::catch {...} (): DBIx::Class::Storage::DBI::try {...} (): DBI Exception (unhandled by DBIC, ::Schema GCed): DBD::Pg::db do failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /home/netdisco/perl5/bin/netdisco-db-deploy line 88
(running "CREATE TABLE dbix_class_schema_versions (
version character varying(10) NOT NULL,
installed character varying(20) NOT NULL,
PRIMARY KEY (version)
)") at /home/netdisco/perl5/bin/netdisco-db-deploy line 88
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception (unhandled by DBIC, ::Schema GCed): DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [for Statement "INSERT INTO dbix_class_schema_versions ( installed, version) VALUES ( ?, ? )" with ParamValues: 1='v20141015_140324.825', 2='1'] at /home/netdisco/perl5/bin/netdisco-db-deploy line 88
DB schema update complete.
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently unversioned. Please call upgrade on your schema to sync the DB. at /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm line 62
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception (unhandled by DBIC, ::Schema GCed): DBD::Pg::st execute failed: ERROR: relation "users" does not exist
LINE 1: SELECT COUNT( * ) FROM users me WHERE ( admin )
^ [for Statement "SELECT COUNT( * ) FROM users me WHERE ( admin )"] at /home/netdisco/bin/netdisco-deploy line 129
Any thoughts ?
Cheers \\Gustaf