cvicente / netdot Goto Github PK

Network Documentation Tool

Makefile 0.43% Perl 64.33% PHP 1.43% HTML 29.62% CSS 1.52% JavaScript 2.66%

ipam dns dhcp topology-visualiztion network-discovery ipv6 perl snmp

netdot's Introduction

Network Documentation Tool

Netdot is an open source tool designed to help network administrators collect, organize and maintain network documentation.

Netdot was initially developed at the University of Oregon and continues to be maintained and expanded with support from volunteers.

Features include:

Device discovery via SNMP
Layer2 topology discovery using:
- CDP/LLDP
- Spanning Tree Protocol
- Switch forwarding tables
- Router point-to-point subnets
IPv4 and IPv6 address space management (IPAM)
Address space visualization
DNS zone file generation (BIND)
ISC DHCPD config generation
IP and MAC address tracking
BGP peer and Autonomous Systems tracking
Cable plant (sites, fiber, copper, closets, circuits...)
Contacts (departments, providers, vendors, etc.)
Export scripts for various monitoring tools (Nagios, Sysmon, RANCID, Cacti, SmokePing)
Multi-level user access: Admin, Operator, User

Documentation

Read the Manual in pdf or html

Contributing

When contributing to this repository, please first discuss the change you wish to make via issue, email, or any other method with the owners of this repository before making a change.

The most effective way to submit changes is to issue a Github pull request.

Authors

Carlos Vicente

Also see Contributors

License

This project is licensed under the GPL

Acknowledgments

The University of Oregon and the Network Startup Resource Center (NSRC)
All the individuals who contributed patches, ideas, suggestions and feedback.

Like us on Facebook

netdot's People

Contributors

Stargazers

Watchers

netdot's Issues

106_107 upgrade

ln -s /mnt/data/www/netdot/doc/manual/netdot-manual.htm /htdocs/help/manual.html
make[1]: Leaving directory /home/SQL/***/netdot-master/htdocs' cd lib ; make all DIR=lib make[1]: Entering directory/home/SQL/**/netdot-master/lib'
Wiping out directory before installing
rm -fr /lib
make[1]: /bin/sh: Команда не найдена
make[1]: ** [wipedir] Ошибка 127
make[1]: Leaving directory `/home/SQL/**/netdot-master/lib'
make: ** [lib] Ошибка 2

You kill my system :-) rm -fr /lib

Add foolproof pliz.

netdot throws error when using non existent fiber type

Netdot uses a static list of fiber types when making a range edit on fiber strands via:

htdocs/cable_plant/cable_backbone.html

If the fiber types have been modified, then an error is thrown.

A PR is on the way to fix this issue.

allow custom attributes to be added to Resource Records (RRs)

It would be great to be able to add custom attributes to RRs.

Debian 9.7 Pg make installdb fails

Debian 9.7
Postgresql 9.6

Everything goes well until...

DROP USER IF EXISTS netdot;
CREATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUSER):
DBD::Pg::db do failed: ERROR: opci�n de rol no reconocida �nocreateuser�
L�NEA 3: ...REATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUS...
^ at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing
DROP USER IF EXISTS netdot;
CREATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUSER: DBD::Pg::db do failed: ERROR: opci�n de rol no reconocida �nocreateuser�
L�NEA 3: ...REATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUS...
^ at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON asn TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON asn TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

Full log (excluding oui):

root@nicopc:~/Netdot# make install APACHEUSER=www-data APACHEGROUP=www-data

Creating necessary directories...
echo /usr/local/netdot > ./.prefix
for dir in bin doc htdocs tmp tmp/sessions /tmp/sessions/locks lib etc var import export; do
if test -d /usr/local/netdot/$dir; then
echo "Skipping dir /usr/local/netdot/$dir; already exists";
else
mkdir -m 0775 -p /usr/local/netdot/$dir ;
fi ;
done
Skipping dir /usr/local/netdot/bin; already exists
Skipping dir /usr/local/netdot/doc; already exists
Skipping dir /usr/local/netdot/htdocs; already exists
Skipping dir /usr/local/netdot/tmp; already exists
Skipping dir /usr/local/netdot/tmp/sessions; already exists
Skipping dir /usr/local/netdot//tmp/sessions/locks; already exists
Skipping dir /usr/local/netdot/lib; already exists
Skipping dir /usr/local/netdot/etc; already exists
Skipping dir /usr/local/netdot/var; already exists
Skipping dir /usr/local/netdot/import; already exists
Skipping dir /usr/local/netdot/export; already exists
chown -R www-data:www-data /usr/local/netdot/tmp
chmod 750 /usr/local/netdot/tmp
cd doc ; make all DIR=doc
make[1]: se entra en el directorio '/root/Netdot/doc'
Creating necessary directories...
for dir in manual; do if test -d /usr/local/netdot/doc/$dir; then echo "Skipping dir /usr/local/netdot/doc/$dir; already exists"; else mkdir -m 0775 -p /usr/local/netdot/doc/$dir ; fi ; done
Done.

Preparing and installing doc files...
for file in find . -type f |egrep -v '\.svn|Makefile' |sed -e 's/\.\///'; do sed -r -e "s|<Make:PREFIX>|/usr/local/netdot|g" -e "s|<Make:LIB>|/usr/local/netdot/lib|g" -e "s|<Make:ETC>|/usr/local/netdot/etc|g" -e "s|<Make:PERL>|/usr/bin/perl|g" $file > $file.tmp; install -m 0644 $file.tmp /usr/local/netdot/doc/$file; rm -rf $file.tmp; done
Done.
for dir in manual; do
chown www-data:www-data /usr/local/netdot/doc/$dir;
chmod 0755 /usr/local/netdot/doc/$dir;
done
make[1]: se sale del directorio '/root/Netdot/doc'
cd htdocs ; make all DIR=htdocs
make[1]: se entra en el directorio '/root/Netdot/htdocs'
Wiping out directory before installing
rm -fr /usr/local/netdot/htdocs
done
Creating necessary directories...
for dir in cable_plant css generic help img img/graphs java_script management contacts operations reports export user_management user_help masondata/obj masondata/cache rest; do if test -d /usr/local/netdot/htdocs/$dir; then echo "Skipping dir /usr/local/netdot/htdocs/$dir; already exists"; else mkdir -m 0775 -p /usr/local/netdot/htdocs/$dir ; fi ; done
Done.
Hacking together mason permissions fix...
touch /usr/local/netdot/htdocs/masondata/obj/.__obj_create_marker
chown -R www-data:www-data /usr/local/netdot/htdocs/masondata
chmod 0755 /usr/local/netdot/htdocs/masondata
chown www-data:www-data /usr/local/netdot/htdocs/img/graphs
chmod 0750 /usr/local/netdot/htdocs/img/graphs

Preparing and installing htdocs files...
for file in find . -name "*" | egrep ".*(rest\/.*|handler|\.?html|\.css|\.png|\.gif|\.js|\.ico)$" | sed -e 's/\.\///'; do sed -r -e "s|<Make:PREFIX>|/usr/local/netdot|g" -e "s|<Make:LIB>|/usr/local/netdot/lib|g" -e "s|<Make:ETC>|/usr/local/netdot/etc|g" -e "s|<Make:PERL>|/usr/bin/perl|g" $file > $file.tmp; install -m 0644 $file.tmp /usr/local/netdot/htdocs/$file; rm -rf $file.tmp; done
Done.
ln -s /usr/local/netdot/doc/manual/netdot-manual.htm /usr/local/netdot/htdocs/help/manual.html
make[1]: se sale del directorio '/root/Netdot/htdocs'
cd lib ; make all DIR=lib
make[1]: se entra en el directorio '/root/Netdot/lib'
Wiping out directory before installing
rm -fr /usr/local/netdot/lib
done
Creating necessary directories...
for dir in Netdot Netdot/Manual Netdot/Meta Netdot/Meta/Table Netdot/Model Netdot/Model/Plugins Netdot/Model/Device Netdot/Model/Device/CLI Netdot/Model/Device/API Netdot/UI Netdot/Util Netdot/Exporter; do if test -d /usr/local/netdot/lib/$dir; then echo "Skipping dir /usr/local/netdot/lib/$dir; already exists"; else mkdir -m 0775 -p /usr/local/netdot/lib/$dir ; fi ; done
Done.

Preparing and installing lib files...
for file in find . -name "*.pm" | grep -v snmp-info | sed -e 's/\.\///'; do sed -r -e "s|<Make:PREFIX>|/usr/local/netdot|g" -e "s|<Make:LIB>|/usr/local/netdot/lib|g" -e "s|<Make:ETC>|/usr/local/netdot/etc|g" -e "s|<Make:PERL>|/usr/bin/perl|g" $file > $file.tmp; install -m 0644 $file.tmp /usr/local/netdot/lib/$file; rm -rf $file.tmp; done
Done.
make[1]: se sale del directorio '/root/Netdot/lib'
cd var ; make all DIR=var
make[1]: se entra en el directorio '/root/Netdot/var'
if ! test -r /usr/local/netdot/var/pollstats.rrd; then
rrdtool create pollstats.rrd -s 3600
DS:ips:GAUGE:7200:0:4294967296
DS:macs:GAUGE:7200:0:4294967296
DS:arp_devs:GAUGE:7200:0:4294967296
DS:fwt_devs:GAUGE:7200:0:4294967296
DS:poll_time:GAUGE:7200:0:4294967296
RRA:AVERAGE:0.5:1:24
RRA:AVERAGE:0.5:24:365
RRA:MAX:0.5:24:30
RRA:MIN:0.5:24:30;
install -m 0644 pollstats.rrd /usr/local/netdot/var/pollstats.rrd;
fi;
make[1]: se sale del directorio '/root/Netdot/var'
cd bin; make install DIR=bin
make[1]: se entra en el directorio '/root/Netdot/bin'

Preparing and installing bin files...
for file in build_topo_graph.pl check_bgppeer.pl check_ifstatus.pl check_link_state.pl device_checks.pl dump-db.pl ether_ip_port.pl exporter.pl find_address.pl free_ip_space.pl ipblock_checks.pl perldeps.pl prune_db.pl updatedevices.pl ; do sed -r -e "s|<Make:PREFIX>|cat ../.prefix|g" -e "s|<Make:LIB>|cat ../.prefix/lib|g" -e "s|<Make:ETC>|cat ../.prefix/etc|g" -e "s|<Make:PERL>|/usr/bin/perl|g" $file > $file.tmp; install -m 755 $file.tmp /usr/local/netdot/bin/$file; rm -rf $file.tmp; done
Done.
make[1]: se sale del directorio '/root/Netdot/bin'
cd etc; make all DIR=etc
make[1]: se entra en el directorio '/root/Netdot/etc'

Preparing and installing import files...
for file in import_bind_zones.pl import_closets.pl import_hosts.pl import_ip_bulk.pl subnet_zone.pl update_dev_rest.pl ; do sed -r -e "s|<Make:PREFIX>|/usr/local/netdot|g" -e "s|<Make:LIB>|/usr/local/netdot/lib|g" -e "s|<Make:ETC>|/usr/local/netdot/etc|g" -e "s|<Make:PERL>|/usr/bin/perl|g" $file > $file.tmp; install -m 0644 $file.tmp /usr/local/netdot/import/$file; rm -rf $file.tmp; done
Done.
make[1]: se sale del directorio '/root/Netdot/import'
Going into _export...
cd export ; make all DIR=export
make[1]: se entra en el directorio '/root/Netdot/export'
Creating necessary directories...
for dir in docs nagios sysmon rancid cacti ethers smokeping bind dhcpd; do if test -d /usr/local/netdot/export/$dir; then echo "Skipping dir /usr/local/netdot/export/$dir; already exists"; else mkdir -m 0775 -p /usr/local/netdot/export/$dir ; fi ; done
Done.

Netdot is installed.
Please read the available documentation before proceeding.
root@nicopc:~/Netdot# make installdb
echo /usr/local/netdot > ./.prefix
Preparing to create netdot database
cd bin ; make installdb
make[1]: se entra en el directorio '/root/Netdot/bin'
/usr/bin/perl initdb initdb

Creating Pg database netdot.
Generating schema for Pg...done.

Creating database schema.
DEBUG: init: dbi:Pg:dbname=netdot;host=localhost;port=5432
DEBUG: Connected successfully
DEBUG: (CREATE TABLE "asn" (
"description" character varying(255),
"id" bigserial NOT NULL,
"info" text,
"number" bigint NOT NULL,
"rir" character varying(255),
CONSTRAINT "asn1" UNIQUE ("number"),
CONSTRAINT "pk_asn" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "ASN2" on "asn" ("rir")):
rows affected: 0E0
DEBUG: (CREATE TABLE "accessright" (
"access" character varying(128) NOT NULL,
"id" bigserial NOT NULL,
"object_class" character varying(128) NOT NULL,
"object_id" bigint NOT NULL,
CONSTRAINT "pk_accessright" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "arpcache" (
"device" bigint NOT NULL,
"id" bigserial NOT NULL,
"tstamp" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
CONSTRAINT "arpcache1" UNIQUE ("device", "tstamp"),
CONSTRAINT "pk_arpcache" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "ArpCache2" on "arpcache" ("device")):
rows affected: 0E0
DEBUG: (CREATE INDEX "ArpCache3" on "arpcache" ("tstamp")):
rows affected: 0E0
DEBUG: (CREATE TABLE "arpcacheentry" (
"arpcache" bigint NOT NULL,
"id" bigserial NOT NULL,
"interface" bigint NOT NULL,
"ipaddr" bigint NOT NULL,
"physaddr" bigint NOT NULL,
CONSTRAINT "pk_arpcacheentry" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "ArpCacheEntry1" on "arpcacheentry" ("arpcache")):
rows affected: 0E0
DEBUG: (CREATE INDEX "ArpCacheEntry2" on "arpcacheentry" ("interface")):
rows affected: 0E0
DEBUG: (CREATE INDEX "ArpCacheEntry3" on "arpcacheentry" ("physaddr")):
rows affected: 0E0
DEBUG: (CREATE INDEX "ArpCacheEntry4" on "arpcacheentry" ("ipaddr")):
rows affected: 0E0
DEBUG: (CREATE TABLE "asset" (
"custom_serial" character varying(255),
"date_purchased" date,
"description" character varying(255),
"id" bigserial NOT NULL,
"info" text,
"inventory_number" character varying(255),
"maint_contract" bigint,
"maint_from" date,
"maint_until" date,
"physaddr" bigint,
"po_number" character varying(255),
"product_id" bigint NOT NULL,
"reserved_for" character varying(255),
"serial_number" character varying(255),
CONSTRAINT "asset1" UNIQUE ("physaddr"),
CONSTRAINT "asset2" UNIQUE ("product_id", "serial_number"),
CONSTRAINT "pk_asset" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Asset3" on "asset" ("serial_number")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Asset4" on "asset" ("inventory_number")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Asset5" on "asset" ("po_number")):
rows affected: 0E0
DEBUG: (CREATE TABLE "audit" (
"fields" character varying(255),
"id" bigserial NOT NULL,
"label" character varying(255) NOT NULL,
"object_id" bigint NOT NULL,
"operation" character varying(255) NOT NULL,
"tablename" character varying(255) NOT NULL,
"tstamp" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"username" character varying(255) NOT NULL,
"vals" character varying(255),
CONSTRAINT "pk_audit" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Audit1" on "audit" ("tstamp")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Audit2" on "audit" ("username")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Audit3" on "audit" ("tablename")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Audit4" on "audit" ("label")):
rows affected: 0E0
DEBUG: (CREATE TABLE "availability" (
"id" bigserial NOT NULL,
"info" text DEFAULT NULL,
"name" character varying(128) NOT NULL,
CONSTRAINT "availability1" UNIQUE ("name"),
CONSTRAINT "pk_availability" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "bgppeering" (
"authkey" character varying(255),
"bgppeeraddr" character varying(64) NOT NULL,
"bgppeerid" character varying(64) NOT NULL,
"contactlist" bigint,
"device" bigint,
"entity" bigint,
"id" bigserial NOT NULL,
"info" text,
"last_changed" timestamp,
"max_v4_prefixes" integer NOT NULL,
"max_v6_prefixes" integer NOT NULL,
"monitored" bool DEFAULT FALSE NOT NULL,
"peer_group" character varying(255),
"state" character varying(255),
CONSTRAINT "bgppeering1" UNIQUE ("device", "bgppeeraddr"),
CONSTRAINT "pk_bgppeering" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "BGPPeering2" on "bgppeering" ("bgppeerid")):
rows affected: 0E0
DEBUG: (CREATE TABLE "backbonecable" (
"end_closet" bigint NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"installdate" date,
"length" character varying(32),
"name" character varying(64) NOT NULL,
"owner" bigint,
"start_closet" bigint NOT NULL,
"type" bigint NOT NULL,
CONSTRAINT "backbonecable1" UNIQUE ("name"),
CONSTRAINT "pk_backbonecable" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "BackboneCable2" on "backbonecable" ("name")):
rows affected: 0E0
DEBUG: (CREATE INDEX "BackboneCable3" on "backbonecable" ("start_closet")):
rows affected: 0E0
DEBUG: (CREATE INDEX "BackboneCable4" on "backbonecable" ("end_closet")):
rows affected: 0E0
DEBUG: (CREATE TABLE "cablestrand" (
"cable" bigint NOT NULL,
"circuit_id" bigint,
"description" character varying(128),
"fiber_type" bigint,
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
"number" integer NOT NULL,
"status" bigint NOT NULL,
CONSTRAINT "cablestrand1" UNIQUE ("cable", "name"),
CONSTRAINT "pk_cablestrand" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "CableStrand2" on "cablestrand" ("cable")):
rows affected: 0E0
DEBUG: (CREATE INDEX "CableStrand3" on "cablestrand" ("name")):
rows affected: 0E0
DEBUG: (CREATE INDEX "CableStrand4" on "cablestrand" ("number")):
rows affected: 0E0
DEBUG: (CREATE INDEX "CableStrand5" on "cablestrand" ("circuit_id")):
rows affected: 0E0
DEBUG: (CREATE TABLE "cabletype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "cabletype1" UNIQUE ("name"),
CONSTRAINT "pk_cabletype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "circuit" (
"cid" character varying(128) NOT NULL,
"datetested" date,
"id" bigserial NOT NULL,
"info" text,
"installdate" date,
"linkid" bigint,
"loss" character varying(32),
"speed" character varying(32),
"status" bigint NOT NULL,
"type" bigint,
"vendor" bigint,
CONSTRAINT "circuit1" UNIQUE ("vendor", "cid"),
CONSTRAINT "pk_circuit" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Circuit2" on "circuit" ("linkid")):
rows affected: 0E0
DEBUG: (CREATE TABLE "circuitstatus" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "circuitstatus1" UNIQUE ("name"),
CONSTRAINT "pk_circuitstatus" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "circuittype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "circuittype1" UNIQUE ("name"),
CONSTRAINT "pk_circuittype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "closet" (
"access_key_type" character varying(128),
"asbestos_tiles" bool DEFAULT FALSE NOT NULL,
"catv_taps" character varying(128),
"converted_patch_panels" bool DEFAULT FALSE NOT NULL,
"dimensions" character varying(64),
"ground_buss" bool DEFAULT FALSE NOT NULL,
"hvac_type" character varying(255),
"id" bigserial NOT NULL,
"info" text,
"name" character varying(32) NOT NULL,
"ot_blocks" character varying(128),
"outlets" character varying(128),
"pair_count" character varying(128),
"patch_panels" character varying(128),
"rack_type" character varying(255),
"racks" character varying(128),
"room" bigint NOT NULL,
"ru_avail" character varying(128),
"shared_with" character varying(255),
"ss_blocks" character varying(128),
"work_needed" character varying(128),
CONSTRAINT "closet1" UNIQUE ("name", "room"),
CONSTRAINT "pk_closet" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Closet2" on "closet" ("room")):
rows affected: 0E0
DEBUG: (CREATE TABLE "closetpicture" (
"bindata" bytea NOT NULL,
"closet" bigint NOT NULL,
"filename" character varying(64) NOT NULL,
"filesize" character varying(64) NOT NULL,
"filetype" character varying(64) NOT NULL,
"id" bigserial NOT NULL,
"info" text,
CONSTRAINT "closetpicture1" UNIQUE ("filename", "closet"),
CONSTRAINT "pk_closetpicture" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "contact" (
"contactlist" bigint NOT NULL,
"contacttype" bigint NOT NULL,
"escalation_level" integer NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"notify_email" bigint,
"notify_pager" bigint,
"notify_voice" bigint,
"person" bigint NOT NULL,
CONSTRAINT "pk_contact" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Contact1" on "contact" ("contactlist")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Contact2" on "contact" ("contacttype")):
rows affected: 0E0
DEBUG: (CREATE TABLE "contactlist" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "contactlist1" UNIQUE ("name"),
CONSTRAINT "pk_contactlist" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "contacttype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "contacttype1" UNIQUE ("name"),
CONSTRAINT "pk_contacttype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "datacache" (
"data" bytea,
"id" bigserial NOT NULL,
"name" character varying(255) NOT NULL,
"tstamp" bigint DEFAULT 0 NOT NULL,
CONSTRAINT "datacache1" UNIQUE ("name"),
CONSTRAINT "pk_datacache" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "device" (
"aliases" character varying(255),
"asset_id" bigint,
"auto_dns" bool DEFAULT FALSE NOT NULL,
"bgpid" character varying(64),
"bgplocalas" bigint,
"canautoupdate" bool DEFAULT FALSE NOT NULL,
"collect_arp" bool DEFAULT FALSE NOT NULL,
"collect_fwt" bool DEFAULT FALSE NOT NULL,
"collect_stp" bool DEFAULT FALSE NOT NULL,
"community" character varying(64),
"customer_managed" bool DEFAULT FALSE NOT NULL,
"date_installed" timestamp DEFAULT '1970-01-02 00:00:01',
"down_from" date,
"down_until" date,
"extension" integer,
"host_device" bigint,
"id" bigserial NOT NULL,
"info" text,
"ipforwarding" bool DEFAULT FALSE NOT NULL,
"last_arp" timestamp DEFAULT '1970-01-02 00:00:01',
"last_fwt" timestamp DEFAULT '1970-01-02 00:00:01',
"last_updated" timestamp DEFAULT '1970-01-02 00:00:01',
"layers" character varying(8),
"monitor_config" bool DEFAULT FALSE NOT NULL,
"monitor_config_group" character varying(64),
"monitored" bool DEFAULT FALSE NOT NULL,
"monitoring_path_cost" integer,
"monitoring_template" character varying(255),
"monitorstatus" bigint,
"name" bigint NOT NULL,
"oobname" character varying(255),
"oobname_2" character varying(255),
"oobnumber" character varying(32),
"oobnumber_2" character varying(32),
"os" character varying(128),
"owner" bigint,
"power_outlet" character varying(255),
"power_outlet_2" character varying(255),
"rack" character varying(32),
"room" bigint,
"site" bigint,
"snmp_authkey" character varying(255),
"snmp_authprotocol" character varying(32),
"snmp_bulk" bool DEFAULT FALSE NOT NULL,
"snmp_conn_attempts" integer,
"snmp_down" bool DEFAULT FALSE NOT NULL,
"snmp_managed" bool DEFAULT FALSE NOT NULL,
"snmp_polling" bool DEFAULT FALSE NOT NULL,
"snmp_privkey" character varying(255),
"snmp_privprotocol" character varying(32),
"snmp_securitylevel" character varying(32),
"snmp_securityname" character varying(255),
"snmp_target" bigint,
"snmp_version" integer,
"stp_enabled" bool DEFAULT FALSE NOT NULL,
"stp_mst_digest" character varying(255),
"stp_mst_region" character varying(128),
"stp_mst_rev" integer,
"stp_type" character varying(128),
"sysdescription" character varying(255),
"syslocation" character varying(255),
"sysname" character varying(255),
"used_by" bigint,
CONSTRAINT "device1" UNIQUE ("name", "asset_id"),
CONSTRAINT "device2" UNIQUE ("name"),
CONSTRAINT "pk_device" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device3" on "device" ("used_by")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device4" on "device" ("owner")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device5" on "device" ("os")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device6" on "device" ("sysname")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device7" on "device" ("down_from")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device8" on "device" ("down_until")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Device9" on "device" ("extension")):
rows affected: 0E0
DEBUG: (CREATE TABLE "deviceattr" (
"device" bigint NOT NULL,
"id" bigserial NOT NULL,
"name" bigint NOT NULL,
"value" character varying(255) NOT NULL,
CONSTRAINT "deviceattr1" UNIQUE ("name", "device"),
CONSTRAINT "pk_deviceattr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "DeviceAttr2" on "deviceattr" ("device")):
rows affected: 0E0
DEBUG: (CREATE TABLE "deviceattrname" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "deviceattrname1" UNIQUE ("name"),
CONSTRAINT "pk_deviceattrname" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "devicecontacts" (
"contactlist" bigint NOT NULL,
"device" bigint NOT NULL,
"id" bigserial NOT NULL,
CONSTRAINT "devicecontacts1" UNIQUE ("device", "contactlist"),
CONSTRAINT "pk_devicecontacts" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "devicemodule" (
"asset_id" bigint,
"class" character varying(128),
"contained_in" integer,
"date_installed" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"description" character varying(255),
"device" bigint NOT NULL,
"fru" bool DEFAULT FALSE NOT NULL,
"fw_rev" character varying(128),
"hw_rev" character varying(128),
"id" bigserial NOT NULL,
"last_updated" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"model" character varying(128),
"name" character varying(128),
"number" integer NOT NULL,
"pos" integer,
"sw_rev" character varying(128),
"type" character varying(128),
CONSTRAINT "devicemodule1" UNIQUE ("device", "number"),
CONSTRAINT "pk_devicemodule" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "dhcpattr" (
"id" bigserial NOT NULL,
"name" bigint NOT NULL,
"scope" bigint NOT NULL,
"value" character varying(255) NOT NULL,
CONSTRAINT "dhcpattr1" UNIQUE ("name", "scope"),
CONSTRAINT "pk_dhcpattr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "DhcpAttr2" on "dhcpattr" ("scope")):
rows affected: 0E0
DEBUG: (CREATE TABLE "dhcpattrname" (
"code" integer,
"format" character varying(128),
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "dhcpattrname1" UNIQUE ("name"),
CONSTRAINT "pk_dhcpattrname" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "dhcpscope" (
"active" bool DEFAULT FALSE NOT NULL,
"container" bigint,
"duid" character varying(255),
"enable_failover" bool DEFAULT FALSE NOT NULL,
"export_file" character varying(255),
"failover_peer" character varying(128),
"id" bigserial NOT NULL,
"ipblock" bigint,
"name" character varying(128) NOT NULL,
"physaddr" bigint,
"text" text,
"type" bigint NOT NULL,
"version" integer NOT NULL,
CONSTRAINT "dhcpscope1" UNIQUE ("name"),
CONSTRAINT "pk_dhcpscope" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "DhcpScope2" on "dhcpscope" ("ipblock")):
rows affected: 0E0
DEBUG: (CREATE INDEX "DhcpScope3" on "dhcpscope" ("type")):
rows affected: 0E0
DEBUG: (CREATE INDEX "DhcpScope4" on "dhcpscope" ("physaddr")):
rows affected: 0E0
DEBUG: (CREATE TABLE "dhcpscopetype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "dhcpscopetype1" UNIQUE ("name"),
CONSTRAINT "pk_dhcpscopetype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "dhcpscopeuse" (
"id" bigserial NOT NULL,
"scope" bigint NOT NULL,
"template" bigint NOT NULL,
CONSTRAINT "dhcpscopeuse1" UNIQUE ("scope", "template"),
CONSTRAINT "pk_dhcpscopeuse" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "DhcpScopeUse2" on "dhcpscopeuse" ("template")):
rows affected: 0E0
DEBUG: (CREATE TABLE "entity" (
"acctnumber" character varying(128),
"aliases" character varying(255),
"asname" character varying(32),
"asnumber" integer,
"availability" bigint,
"config_type" character varying(255),
"contactlist" bigint,
"id" bigserial NOT NULL,
"info" text,
"maint_contract" character varying(128),
"name" character varying(128) NOT NULL,
"oid" character varying(32),
"short_name" character varying(64),
CONSTRAINT "entity1" UNIQUE ("name"),
CONSTRAINT "entity2" UNIQUE ("oid"),
CONSTRAINT "pk_entity" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Entity3" on "entity" ("asname")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Entity4" on "entity" ("asnumber")):
rows affected: 0E0
DEBUG: (CREATE TABLE "entityrole" (
"entity" bigint NOT NULL,
"id" bigserial NOT NULL,
"type" bigint NOT NULL,
CONSTRAINT "entityrole1" UNIQUE ("entity", "type"),
CONSTRAINT "pk_entityrole" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "entitysite" (
"entity" bigint NOT NULL,
"id" bigserial NOT NULL,
"site" bigint NOT NULL,
CONSTRAINT "entitysite1" UNIQUE ("entity", "site"),
CONSTRAINT "pk_entitysite" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "entitytype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "entitytype1" UNIQUE ("name"),
CONSTRAINT "pk_entitytype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "fwtable" (
"device" bigint NOT NULL,
"id" bigserial NOT NULL,
"tstamp" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
CONSTRAINT "fwtable1" UNIQUE ("device", "tstamp"),
CONSTRAINT "pk_fwtable" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "FWTable2" on "fwtable" ("device")):
rows affected: 0E0
DEBUG: (CREATE INDEX "FWTable3" on "fwtable" ("tstamp")):
rows affected: 0E0
DEBUG: (CREATE TABLE "fwtableentry" (
"fwtable" bigint NOT NULL,
"id" bigserial NOT NULL,
"interface" bigint NOT NULL,
"physaddr" bigint NOT NULL,
CONSTRAINT "pk_fwtableentry" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "FWTableEntry1" on "fwtableentry" ("fwtable")):
rows affected: 0E0
DEBUG: (CREATE INDEX "FWTableEntry2" on "fwtableentry" ("interface")):
rows affected: 0E0
DEBUG: (CREATE INDEX "FWTableEntry3" on "fwtableentry" ("physaddr")):
rows affected: 0E0
DEBUG: (CREATE TABLE "fibertype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "fibertype1" UNIQUE ("name"),
CONSTRAINT "pk_fibertype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "FiberType2" on "fibertype" ("name")):
rows affected: 0E0
DEBUG: (CREATE TABLE "floor" (
"id" bigserial NOT NULL,
"info" text,
"level" character varying(32) NOT NULL,
"site" bigint NOT NULL,
CONSTRAINT "floor1" UNIQUE ("level", "site"),
CONSTRAINT "pk_floor" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "floorpicture" (
"bindata" bytea NOT NULL,
"filename" character varying(64) NOT NULL,
"filesize" character varying(64) NOT NULL,
"filetype" character varying(64) NOT NULL,
"floor" bigint NOT NULL,
"id" bigserial NOT NULL,
"info" text,
CONSTRAINT "floorpicture1" UNIQUE ("filename", "floor"),
CONSTRAINT "pk_floorpicture" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "groupright" (
"accessright" bigint NOT NULL,
"contactlist" bigint NOT NULL,
"id" bigserial NOT NULL,
CONSTRAINT "groupright1" UNIQUE ("contactlist", "accessright"),
CONSTRAINT "pk_groupright" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "GroupRight2" on "groupright" ("accessright")):
rows affected: 0E0
DEBUG: (CREATE TABLE "horizontalcable" (
"account" character varying(32),
"closet" bigint NOT NULL,
"contactlist" bigint,
"datetested" date,
"faceplateid" character varying(64) NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"installdate" date,
"jackid" character varying(64) NOT NULL,
"length" character varying(32),
"room" bigint NOT NULL,
"testpassed" bool DEFAULT FALSE NOT NULL,
"type" bigint NOT NULL,
CONSTRAINT "horizontalcable1" UNIQUE ("jackid", "faceplateid", "closet", "room"),
CONSTRAINT "pk_horizontalcable" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "HorizontalCable2" on "horizontalcable" ("account")):
rows affected: 0E0
DEBUG: (CREATE TABLE "hostaudit" (
"id" bigserial NOT NULL,
"pending" bool DEFAULT FALSE NOT NULL,
"scope" character varying(255),
"tstamp" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"zone" character varying(255),
CONSTRAINT "pk_hostaudit" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "HostAudit1" on "hostaudit" ("zone")):
rows affected: 0E0
DEBUG: (CREATE INDEX "HostAudit2" on "hostaudit" ("scope")):
rows affected: 0E0
DEBUG: (CREATE INDEX "HostAudit3" on "hostaudit" ("pending")):
rows affected: 0E0
DEBUG: (CREATE TABLE "interface" (
"admin_duplex" character varying(16),
"admin_status" character varying(16),
"auto_dns" bool DEFAULT FALSE NOT NULL,
"bpdu_filter_enabled" bool DEFAULT FALSE NOT NULL,
"bpdu_guard_enabled" bool DEFAULT FALSE NOT NULL,
"circuit" bigint,
"contactlist" bigint,
"description" character varying(128),
"device" bigint NOT NULL,
"dlci" character varying(64),
"doc_status" character varying(32),
"down_from" date,
"down_until" date,
"dp_remote_id" character varying(128),
"dp_remote_ip" character varying(128),
"dp_remote_port" character varying(128),
"dp_remote_type" character varying(255),
"id" bigserial NOT NULL,
"ignore_ip" bool DEFAULT FALSE NOT NULL,
"info" text,
"jack" bigint,
"jack_char" character varying(32),
"loop_guard_enabled" bool DEFAULT FALSE NOT NULL,
"monitored" bool DEFAULT FALSE NOT NULL,
"monitorstatus" bigint,
"name" character varying(255),
"neighbor" bigint,
"neighbor_fixed" bool DEFAULT FALSE NOT NULL,
"neighbor_missed" integer DEFAULT 0 NOT NULL,
"number" character varying(64) NOT NULL,
"oper_duplex" character varying(16),
"oper_status" character varying(16),
"overwrite_descr" bool DEFAULT FALSE NOT NULL,
"physaddr" bigint,
"room_char" character varying(32),
"root_guard_enabled" bool DEFAULT FALSE NOT NULL,
"snmp_managed" bool DEFAULT FALSE NOT NULL,
"speed" bigint,
"stp_id" character varying(32),
"type" character varying(32),
CONSTRAINT "interface1" UNIQUE ("device", "number", "name"),
CONSTRAINT "pk_interface" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface2" on "interface" ("description")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface3" on "interface" ("stp_id")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface4" on "interface" ("physaddr")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface5" on "interface" ("jack")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface6" on "interface" ("neighbor")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface7" on "interface" ("oper_duplex")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface8" on "interface" ("oper_status")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface9" on "interface" ("speed")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Interface10" on "interface" ("circuit")):
rows affected: 0E0
DEBUG: (CREATE TABLE "interfacevlan" (
"id" bigserial NOT NULL,
"interface" bigint NOT NULL,
"stp_des_bridge" character varying(32),
"stp_des_port" character varying(32),
"stp_instance" bigint,
"stp_state" character varying(32),
"vlan" bigint NOT NULL,
CONSTRAINT "interfacevlan1" UNIQUE ("interface", "vlan"),
CONSTRAINT "pk_interfacevlan" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "InterfaceVlan2" on "interfacevlan" ("stp_instance")):
rows affected: 0E0
DEBUG: (CREATE INDEX "InterfaceVlan3" on "interfacevlan" ("stp_des_bridge")):
rows affected: 0E0
DEBUG: (CREATE INDEX "InterfaceVlan4" on "interfacevlan" ("stp_des_port")):
rows affected: 0E0
DEBUG: (CREATE INDEX "InterfaceVlan5" on "interfacevlan" ("vlan")):
rows affected: 0E0
DEBUG: (CREATE TABLE "ipservice" (
"contactlist" bigint,
"id" bigserial NOT NULL,
"ip" bigint NOT NULL,
"monitored" bool DEFAULT FALSE NOT NULL,
"monitorstatus" bigint,
"service" bigint NOT NULL,
CONSTRAINT "ipservice1" UNIQUE ("ip", "service"),
CONSTRAINT "pk_ipservice" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "ipblock" (
"address" numeric(40,0) NOT NULL,
"asn" bigint,
"description" character varying(128),
"first_seen" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"interface" bigint,
"last_seen" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"monitored" bool DEFAULT FALSE NOT NULL,
"owner" bigint,
"parent" bigint,
"prefix" integer NOT NULL,
"rir" character varying(255),
"status" bigint NOT NULL,
"use_network_broadcast" bool DEFAULT FALSE NOT NULL,
"used_by" bigint,
"version" integer NOT NULL,
"vlan" bigint,
CONSTRAINT "ipblock1" UNIQUE ("address", "prefix"),
CONSTRAINT "pk_ipblock" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock2" on "ipblock" ("parent")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock3" on "ipblock" ("status")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock4" on "ipblock" ("first_seen")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock5" on "ipblock" ("last_seen")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock6" on "ipblock" ("interface")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock7" on "ipblock" ("vlan")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Ipblock8" on "ipblock" ("version")):
rows affected: 0E0
DEBUG: (CREATE TABLE "ipblockattr" (
"id" bigserial NOT NULL,
"ipblock" bigint NOT NULL,
"name" bigint NOT NULL,
"value" character varying(255) NOT NULL,
CONSTRAINT "ipblockattr1" UNIQUE ("name", "ipblock"),
CONSTRAINT "pk_ipblockattr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "IpblockAttr2" on "ipblockattr" ("ipblock")):
rows affected: 0E0
DEBUG: (CREATE TABLE "ipblockattrname" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "ipblockattrname1" UNIQUE ("name"),
CONSTRAINT "pk_ipblockattrname" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "ipblockstatus" (
"id" bigserial NOT NULL,
"name" character varying(64) NOT NULL,
CONSTRAINT "ipblockstatus1" UNIQUE ("name"),
CONSTRAINT "pk_ipblockstatus" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "maintcontract" (
"id" bigserial NOT NULL,
"info" text,
"number" character varying(255) NOT NULL,
"provider" bigint NOT NULL,
CONSTRAINT "maintcontract1" UNIQUE ("number"),
CONSTRAINT "pk_maintcontract" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "monitorstatus" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "monitorstatus1" UNIQUE ("name"),
CONSTRAINT "pk_monitorstatus" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "oui" (
"id" bigserial NOT NULL,
"oui" character varying(6) NOT NULL,
"vendor" character varying(128) NOT NULL,
CONSTRAINT "oui1" UNIQUE ("oui"),
CONSTRAINT "pk_oui" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "person" (
"aliases" character varying(255),
"cell" character varying(32),
"email" character varying(255),
"emailpager" character varying(255),
"entity" bigint,
"extension" integer,
"fax" character varying(32),
"firstname" character varying(64),
"home" character varying(32),
"id" bigserial NOT NULL,
"info" text,
"lastname" character varying(64) NOT NULL,
"location" bigint,
"office" character varying(32),
"pager" character varying(32),
"password" character varying(255),
"position" character varying(64),
"room" bigint,
"user_type" bigint,
"username" character varying(128),
CONSTRAINT "person1" UNIQUE ("firstname", "lastname", "entity"),
CONSTRAINT "person2" UNIQUE ("username"),
CONSTRAINT "person3" UNIQUE ("email"),
CONSTRAINT "pk_person" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "physaddr" (
"address" character varying(128) NOT NULL,
"first_seen" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"id" bigserial NOT NULL,
"last_seen" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"static" bool DEFAULT FALSE NOT NULL,
CONSTRAINT "physaddr1" UNIQUE ("address"),
CONSTRAINT "pk_physaddr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "PhysAddr2" on "physaddr" ("first_seen")):
rows affected: 0E0
DEBUG: (CREATE INDEX "PhysAddr3" on "physaddr" ("last_seen")):
rows affected: 0E0
DEBUG: (CREATE TABLE "physaddrattr" (
"id" bigserial NOT NULL,
"name" bigint NOT NULL,
"physaddr" bigint NOT NULL,
"value" character varying(255) NOT NULL,
CONSTRAINT "physaddrattr1" UNIQUE ("name", "physaddr"),
CONSTRAINT "pk_physaddrattr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "PhysAddrAttr2" on "physaddrattr" ("physaddr")):
rows affected: 0E0
DEBUG: (CREATE TABLE "physaddrattrname" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "physaddrattrname1" UNIQUE ("name"),
CONSTRAINT "pk_physaddrattrname" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "product" (
"config_type" character varying(255),
"description" character varying(128),
"id" bigserial NOT NULL,
"info" text,
"latest_os" character varying(128),
"manufacturer" bigint NOT NULL,
"name" character varying(64) NOT NULL,
"part_number" character varying(255),
"sysobjectid" character varying(128),
"type" bigint NOT NULL,
CONSTRAINT "product1" UNIQUE ("name", "manufacturer"),
CONSTRAINT "pk_product" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Product2" on "product" ("sysobjectid")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Product3" on "product" ("type")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Product4" on "product" ("latest_os")):
rows affected: 0E0
DEBUG: (CREATE TABLE "producttype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "producttype1" UNIQUE ("name"),
CONSTRAINT "pk_producttype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "rr" (
"active" bool DEFAULT FALSE NOT NULL,
"auto_update" bool DEFAULT FALSE NOT NULL,
"created" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"expiration" date,
"id" bigserial NOT NULL,
"info" text,
"modified" timestamp DEFAULT '1970-01-02 00:00:01' NOT NULL,
"name" character varying(128) NOT NULL,
"zone" bigint NOT NULL,
CONSTRAINT "rr1" UNIQUE ("zone", "name"),
CONSTRAINT "pk_rr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RR2" on "rr" ("name")):
rows affected: 0E0
DEBUG: (CREATE INDEX "RR3" on "rr" ("expiration")):
rows affected: 0E0
DEBUG: (CREATE INDEX "RR4" on "rr" ("created")):
rows affected: 0E0
DEBUG: (CREATE INDEX "RR5" on "rr" ("modified")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rraddr" (
"id" bigserial NOT NULL,
"ipblock" bigint NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "rraddr1" UNIQUE ("rr", "ipblock"),
CONSTRAINT "pk_rraddr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRADDR2" on "rraddr" ("ipblock")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrcname" (
"cname" character varying(128) NOT NULL,
"id" bigserial NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "rrcname1" UNIQUE ("rr"),
CONSTRAINT "pk_rrcname" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRCNAME2" on "rrcname" ("cname")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrds" (
"algorithm" integer NOT NULL,
"digest" character varying(255) DEFAULT 'The digest is calculated by concatenating the canonical form of the fully qualified owner name of the DNSKEY RR with the DNSKEY RDATA, and then applying the digest algorithm.' NOT NULL,
"digest_type" integer NOT NULL,
"id" bigserial NOT NULL,
"key_tag" integer NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "rrds1" UNIQUE ("rr", "key_tag", "algorithm", "digest_type"),
CONSTRAINT "pk_rrds" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRDS2" on "rrds" ("key_tag")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrhinfo" (
"cpu" character varying(32) NOT NULL,
"id" bigserial NOT NULL,
"os" character varying(32) NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "pk_rrhinfo" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRHINFO1" on "rrhinfo" ("rr")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrloc" (
"altitude" bigint NOT NULL,
"horiz_pre" character varying(32),
"id" bigserial NOT NULL,
"latitude" bigint NOT NULL,
"longitude" bigint NOT NULL,
"rr" bigint NOT NULL,
"size" character varying(32),
"ttl" character varying(32),
"vert_pre" character varying(32),
CONSTRAINT "rrloc1" UNIQUE ("rr"),
CONSTRAINT "pk_rrloc" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrmx" (
"exchange" character varying(255) NOT NULL,
"id" bigserial NOT NULL,
"preference" integer DEFAULT 0 NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "rrmx1" UNIQUE ("rr", "exchange"),
CONSTRAINT "pk_rrmx" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRMX2" on "rrmx" ("exchange")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrnaptr" (
"flags" character varying(1),
"id" bigserial NOT NULL,
"order_field" integer DEFAULT 0 NOT NULL,
"preference" integer DEFAULT 0 NOT NULL,
"regexpr" character varying(255) NOT NULL,
"replacement" character varying(255) NOT NULL,
"rr" bigint NOT NULL,
"services" character varying(255) NOT NULL,
"ttl" character varying(32),
CONSTRAINT "pk_rrnaptr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRNAPTR1" on "rrnaptr" ("rr")):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRNAPTR2" on "rrnaptr" ("services")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrns" (
"id" bigserial NOT NULL,
"nsdname" character varying(255) NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "rrns1" UNIQUE ("rr", "nsdname"),
CONSTRAINT "pk_rrns" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRNS2" on "rrns" ("nsdname")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrptr" (
"id" bigserial NOT NULL,
"ipblock" bigint,
"ptrdname" character varying(255) NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
CONSTRAINT "rrptr1" UNIQUE ("ptrdname", "ipblock"),
CONSTRAINT "pk_rrptr" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRPTR2" on "rrptr" ("ipblock")):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRPTR3" on "rrptr" ("rr")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrsrv" (
"id" bigserial NOT NULL,
"port" integer DEFAULT 0 NOT NULL,
"priority" integer DEFAULT 0 NOT NULL,
"rr" bigint NOT NULL,
"target" character varying(255) NOT NULL,
"ttl" character varying(32),
"weight" integer DEFAULT 0 NOT NULL,
CONSTRAINT "rrsrv1" UNIQUE ("rr", "port", "target"),
CONSTRAINT "pk_rrsrv" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRSRV2" on "rrsrv" ("target")):
rows affected: 0E0
DEBUG: (CREATE TABLE "rrtxt" (
"id" bigserial NOT NULL,
"rr" bigint NOT NULL,
"ttl" character varying(32),
"txtdata" character varying(255) NOT NULL,
CONSTRAINT "pk_rrtxt" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRTXT1" on "rrtxt" ("rr")):
rows affected: 0E0
DEBUG: (CREATE INDEX "RRTXT2" on "rrtxt" ("txtdata")):
rows affected: 0E0
DEBUG: (CREATE TABLE "room" (
"floor" bigint NOT NULL,
"id" bigserial NOT NULL,
"name" character varying(64) NOT NULL,
CONSTRAINT "room1" UNIQUE ("name", "floor"),
CONSTRAINT "pk_room" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Room2" on "room" ("name")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Room3" on "room" ("floor")):
rows affected: 0E0
DEBUG: (CREATE TABLE "stpinstance" (
"bridge_priority" integer,
"device" bigint NOT NULL,
"id" bigserial NOT NULL,
"number" integer NOT NULL,
"root_bridge" character varying(12),
"root_port" integer NOT NULL,
CONSTRAINT "stpinstance1" UNIQUE ("device", "number"),
CONSTRAINT "pk_stpinstance" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "STPInstance2" on "stpinstance" ("root_bridge")):
rows affected: 0E0
DEBUG: (CREATE TABLE "savedqueries" (
"id" bigserial NOT NULL,
"name" character varying(255) NOT NULL,
"querytext" text NOT NULL,
CONSTRAINT "savedqueries1" UNIQUE ("name"),
CONSTRAINT "pk_savedqueries" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "schemainfo" (
"id" bigserial NOT NULL,
"info" text,
"version" character varying(255) NOT NULL,
CONSTRAINT "schemainfo1" UNIQUE ("version"),
CONSTRAINT "pk_schemainfo" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "service" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
CONSTRAINT "service1" UNIQUE ("name"),
CONSTRAINT "pk_service" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "site" (
"aliases" character varying(255),
"availability" bigint,
"city" character varying(64),
"contactlist" bigint,
"country" character varying(64),
"gsf" integer,
"id" bigserial NOT NULL,
"info" text,
"name" character varying(64) NOT NULL,
"number" character varying(64),
"pobox" character varying(32),
"state" character varying(32),
"street1" character varying(128),
"street2" character varying(128),
"zip" character varying(16),
CONSTRAINT "site1" UNIQUE ("name"),
CONSTRAINT "site2" UNIQUE ("number"),
CONSTRAINT "pk_site" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Site3" on "site" ("street1")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Site4" on "site" ("name")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Site5" on "site" ("number")):
rows affected: 0E0
DEBUG: (CREATE TABLE "sitelink" (
"entity" bigint,
"farend" bigint NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
"nearend" bigint NOT NULL,
CONSTRAINT "sitelink1" UNIQUE ("name"),
CONSTRAINT "pk_sitelink" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "sitepicture" (
"bindata" bytea NOT NULL,
"filename" character varying(64) NOT NULL,
"filesize" character varying(64) NOT NULL,
"filetype" character varying(64) NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"site" bigint NOT NULL,
CONSTRAINT "sitepicture1" UNIQUE ("filename", "site"),
CONSTRAINT "pk_sitepicture" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "sitesubnet" (
"id" bigserial NOT NULL,
"site" bigint NOT NULL,
"subnet" bigint NOT NULL,
CONSTRAINT "sitesubnet1" UNIQUE ("subnet", "site"),
CONSTRAINT "pk_sitesubnet" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "splice" (
"id" bigserial NOT NULL,
"info" text,
"strand1" bigint NOT NULL,
"strand2" bigint NOT NULL,
CONSTRAINT "pk_splice" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Splice1" on "splice" ("strand1")):
rows affected: 0E0
DEBUG: (CREATE INDEX "Splice2" on "splice" ("strand2")):
rows affected: 0E0
DEBUG: (CREATE TABLE "strandstatus" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "strandstatus1" UNIQUE ("name"),
CONSTRAINT "pk_strandstatus" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "subnetzone" (
"id" bigserial NOT NULL,
"subnet" bigint NOT NULL,
"zone" bigint NOT NULL,
CONSTRAINT "subnetzone1" UNIQUE ("subnet", "zone"),
CONSTRAINT "pk_subnetzone" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "userright" (
"accessright" bigint NOT NULL,
"id" bigserial NOT NULL,
"person" bigint NOT NULL,
CONSTRAINT "userright1" UNIQUE ("person", "accessright"),
CONSTRAINT "pk_userright" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "UserRight2" on "userright" ("accessright")):
rows affected: 0E0
DEBUG: (CREATE TABLE "usertype" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
CONSTRAINT "usertype1" UNIQUE ("name"),
CONSTRAINT "pk_usertype" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "vlan" (
"description" character varying(255),
"id" bigserial NOT NULL,
"info" text,
"name" character varying(255),
"vid" integer NOT NULL,
"vlangroup" bigint,
CONSTRAINT "vlan1" UNIQUE ("vid"),
CONSTRAINT "pk_vlan" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE INDEX "Vlan2" on "vlan" ("vlangroup")):
rows affected: 0E0
DEBUG: (CREATE TABLE "vlangroup" (
"description" character varying(255),
"end_vid" integer NOT NULL,
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
"start_vid" integer NOT NULL,
CONSTRAINT "vlangroup1" UNIQUE ("name"),
CONSTRAINT "pk_vlangroup" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "zone" (
"active" bool DEFAULT FALSE NOT NULL,
"contactlist" bigint,
"default_ttl" integer NOT NULL,
"expire" integer NOT NULL,
"export_file" character varying(255) NOT NULL,
"id" bigserial NOT NULL,
"include" text,
"info" text,
"minimum" bigint NOT NULL,
"mname" character varying(128) NOT NULL,
"name" character varying(128) NOT NULL,
"refresh" integer NOT NULL,
"retry" integer NOT NULL,
"rname" character varying(128) NOT NULL,
"serial" bigint NOT NULL,
CONSTRAINT "zone1" UNIQUE ("name"),
CONSTRAINT "pk_zone" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (CREATE TABLE "zonealias" (
"id" bigserial NOT NULL,
"info" text,
"name" character varying(128) NOT NULL,
"zone" bigint NOT NULL,
CONSTRAINT "zonealias1" UNIQUE ("name"),
CONSTRAINT "pk_zonealias" PRIMARY KEY ("id")
)):
rows affected: 0E0
DEBUG: (ALTER TABLE "arpcache" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "arpcacheentry" ADD CONSTRAINT "fk_arpcache" FOREIGN KEY ("arpcache")
REFERENCES "arpcache" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "arpcacheentry" ADD CONSTRAINT "fk_interface" FOREIGN KEY ("interface")
REFERENCES "interface" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "arpcacheentry" ADD CONSTRAINT "fk_ipaddr" FOREIGN KEY ("ipaddr")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "arpcacheentry" ADD CONSTRAINT "fk_physaddr" FOREIGN KEY ("physaddr")
REFERENCES "physaddr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "asset" ADD CONSTRAINT "fk_maint_contract" FOREIGN KEY ("maint_contract")
REFERENCES "maintcontract" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "asset" ADD CONSTRAINT "fk_physaddr" FOREIGN KEY ("physaddr")
REFERENCES "physaddr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "asset" ADD CONSTRAINT "fk_product_id" FOREIGN KEY ("product_id")
REFERENCES "product" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "bgppeering" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "bgppeering" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "bgppeering" ADD CONSTRAINT "fk_entity" FOREIGN KEY ("entity")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "backbonecable" ADD CONSTRAINT "fk_end_closet" FOREIGN KEY ("end_closet")
REFERENCES "closet" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "backbonecable" ADD CONSTRAINT "fk_owner" FOREIGN KEY ("owner")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "backbonecable" ADD CONSTRAINT "fk_start_closet" FOREIGN KEY ("start_closet")
REFERENCES "closet" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "backbonecable" ADD CONSTRAINT "fk_type" FOREIGN KEY ("type")
REFERENCES "cabletype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "cablestrand" ADD CONSTRAINT "fk_cable" FOREIGN KEY ("cable")
REFERENCES "backbonecable" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "cablestrand" ADD CONSTRAINT "fk_circuit_id" FOREIGN KEY ("circuit_id")
REFERENCES "circuit" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "cablestrand" ADD CONSTRAINT "fk_fiber_type" FOREIGN KEY ("fiber_type")
REFERENCES "fibertype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "cablestrand" ADD CONSTRAINT "fk_status" FOREIGN KEY ("status")
REFERENCES "strandstatus" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "circuit" ADD CONSTRAINT "fk_linkid" FOREIGN KEY ("linkid")
REFERENCES "sitelink" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "circuit" ADD CONSTRAINT "fk_status" FOREIGN KEY ("status")
REFERENCES "circuitstatus" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "circuit" ADD CONSTRAINT "fk_type" FOREIGN KEY ("type")
REFERENCES "circuittype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "circuit" ADD CONSTRAINT "fk_vendor" FOREIGN KEY ("vendor")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "closet" ADD CONSTRAINT "fk_room" FOREIGN KEY ("room")
REFERENCES "room" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "closetpicture" ADD CONSTRAINT "fk_closet" FOREIGN KEY ("closet")
REFERENCES "closet" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "contact" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "contact" ADD CONSTRAINT "fk_contacttype" FOREIGN KEY ("contacttype")
REFERENCES "contacttype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "contact" ADD CONSTRAINT "fk_notify_email" FOREIGN KEY ("notify_email")
REFERENCES "availability" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "contact" ADD CONSTRAINT "fk_notify_pager" FOREIGN KEY ("notify_pager")
REFERENCES "availability" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "contact" ADD CONSTRAINT "fk_notify_voice" FOREIGN KEY ("notify_voice")
REFERENCES "availability" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "contact" ADD CONSTRAINT "fk_person" FOREIGN KEY ("person")
REFERENCES "person" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_asset_id" FOREIGN KEY ("asset_id")
REFERENCES "asset" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_bgplocalas" FOREIGN KEY ("bgplocalas")
REFERENCES "asn" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_host_device" FOREIGN KEY ("host_device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_monitorstatus" FOREIGN KEY ("monitorstatus")
REFERENCES "monitorstatus" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_name" FOREIGN KEY ("name")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_owner" FOREIGN KEY ("owner")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_room" FOREIGN KEY ("room")
REFERENCES "room" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_site" FOREIGN KEY ("site")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_snmp_target" FOREIGN KEY ("snmp_target")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "device" ADD CONSTRAINT "fk_used_by" FOREIGN KEY ("used_by")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "deviceattr" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "deviceattr" ADD CONSTRAINT "fk_name" FOREIGN KEY ("name")
REFERENCES "deviceattrname" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "devicecontacts" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "devicecontacts" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "devicemodule" ADD CONSTRAINT "fk_asset_id" FOREIGN KEY ("asset_id")
REFERENCES "asset" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "devicemodule" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpattr" ADD CONSTRAINT "fk_name" FOREIGN KEY ("name")
REFERENCES "dhcpattrname" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpattr" ADD CONSTRAINT "fk_scope" FOREIGN KEY ("scope")
REFERENCES "dhcpscope" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpscope" ADD CONSTRAINT "fk_container" FOREIGN KEY ("container")
REFERENCES "dhcpscope" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpscope" ADD CONSTRAINT "fk_ipblock" FOREIGN KEY ("ipblock")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpscope" ADD CONSTRAINT "fk_physaddr" FOREIGN KEY ("physaddr")
REFERENCES "physaddr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpscope" ADD CONSTRAINT "fk_type" FOREIGN KEY ("type")
REFERENCES "dhcpscopetype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpscopeuse" ADD CONSTRAINT "fk_scope" FOREIGN KEY ("scope")
REFERENCES "dhcpscope" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "dhcpscopeuse" ADD CONSTRAINT "fk_template" FOREIGN KEY ("template")
REFERENCES "dhcpscope" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "entity" ADD CONSTRAINT "fk_availability" FOREIGN KEY ("availability")
REFERENCES "availability" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "entity" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "entityrole" ADD CONSTRAINT "fk_entity" FOREIGN KEY ("entity")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "entityrole" ADD CONSTRAINT "fk_type" FOREIGN KEY ("type")
REFERENCES "entitytype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "entitysite" ADD CONSTRAINT "fk_entity" FOREIGN KEY ("entity")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "entitysite" ADD CONSTRAINT "fk_site" FOREIGN KEY ("site")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "fwtable" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "fwtableentry" ADD CONSTRAINT "fk_fwtable" FOREIGN KEY ("fwtable")
REFERENCES "fwtable" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "fwtableentry" ADD CONSTRAINT "fk_interface" FOREIGN KEY ("interface")
REFERENCES "interface" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "fwtableentry" ADD CONSTRAINT "fk_physaddr" FOREIGN KEY ("physaddr")
REFERENCES "physaddr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "floor" ADD CONSTRAINT "fk_site" FOREIGN KEY ("site")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "floorpicture" ADD CONSTRAINT "fk_floor" FOREIGN KEY ("floor")
REFERENCES "floor" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "groupright" ADD CONSTRAINT "fk_accessright" FOREIGN KEY ("accessright")
REFERENCES "accessright" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "groupright" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "horizontalcable" ADD CONSTRAINT "fk_closet" FOREIGN KEY ("closet")
REFERENCES "closet" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "horizontalcable" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "horizontalcable" ADD CONSTRAINT "fk_room" FOREIGN KEY ("room")
REFERENCES "room" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "horizontalcable" ADD CONSTRAINT "fk_type" FOREIGN KEY ("type")
REFERENCES "cabletype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_circuit" FOREIGN KEY ("circuit")
REFERENCES "circuit" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_jack" FOREIGN KEY ("jack")
REFERENCES "horizontalcable" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_monitorstatus" FOREIGN KEY ("monitorstatus")
REFERENCES "monitorstatus" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_neighbor" FOREIGN KEY ("neighbor")
REFERENCES "interface" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interface" ADD CONSTRAINT "fk_physaddr" FOREIGN KEY ("physaddr")
REFERENCES "physaddr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interfacevlan" ADD CONSTRAINT "fk_interface" FOREIGN KEY ("interface")
REFERENCES "interface" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interfacevlan" ADD CONSTRAINT "fk_stp_instance" FOREIGN KEY ("stp_instance")
REFERENCES "stpinstance" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "interfacevlan" ADD CONSTRAINT "fk_vlan" FOREIGN KEY ("vlan")
REFERENCES "vlan" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipservice" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipservice" ADD CONSTRAINT "fk_ip" FOREIGN KEY ("ip")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipservice" ADD CONSTRAINT "fk_monitorstatus" FOREIGN KEY ("monitorstatus")
REFERENCES "monitorstatus" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipservice" ADD CONSTRAINT "fk_service" FOREIGN KEY ("service")
REFERENCES "service" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_asn" FOREIGN KEY ("asn")
REFERENCES "asn" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_interface" FOREIGN KEY ("interface")
REFERENCES "interface" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_owner" FOREIGN KEY ("owner")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_parent" FOREIGN KEY ("parent")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_status" FOREIGN KEY ("status")
REFERENCES "ipblockstatus" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_used_by" FOREIGN KEY ("used_by")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblock" ADD CONSTRAINT "fk_vlan" FOREIGN KEY ("vlan")
REFERENCES "vlan" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblockattr" ADD CONSTRAINT "fk_ipblock" FOREIGN KEY ("ipblock")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "ipblockattr" ADD CONSTRAINT "fk_name" FOREIGN KEY ("name")
REFERENCES "ipblockattrname" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "maintcontract" ADD CONSTRAINT "fk_provider" FOREIGN KEY ("provider")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "person" ADD CONSTRAINT "fk_entity" FOREIGN KEY ("entity")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "person" ADD CONSTRAINT "fk_location" FOREIGN KEY ("location")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "person" ADD CONSTRAINT "fk_room" FOREIGN KEY ("room")
REFERENCES "room" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "person" ADD CONSTRAINT "fk_user_type" FOREIGN KEY ("user_type")
REFERENCES "usertype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "physaddrattr" ADD CONSTRAINT "fk_name" FOREIGN KEY ("name")
REFERENCES "physaddrattrname" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "physaddrattr" ADD CONSTRAINT "fk_physaddr" FOREIGN KEY ("physaddr")
REFERENCES "physaddr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "product" ADD CONSTRAINT "fk_manufacturer" FOREIGN KEY ("manufacturer")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "product" ADD CONSTRAINT "fk_type" FOREIGN KEY ("type")
REFERENCES "producttype" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rr" ADD CONSTRAINT "fk_zone" FOREIGN KEY ("zone")
REFERENCES "zone" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rraddr" ADD CONSTRAINT "fk_ipblock" FOREIGN KEY ("ipblock")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rraddr" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrcname" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrds" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrhinfo" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrloc" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrmx" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrnaptr" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrns" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrptr" ADD CONSTRAINT "fk_ipblock" FOREIGN KEY ("ipblock")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrptr" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrsrv" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "rrtxt" ADD CONSTRAINT "fk_rr" FOREIGN KEY ("rr")
REFERENCES "rr" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "room" ADD CONSTRAINT "fk_floor" FOREIGN KEY ("floor")
REFERENCES "floor" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "stpinstance" ADD CONSTRAINT "fk_device" FOREIGN KEY ("device")
REFERENCES "device" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "site" ADD CONSTRAINT "fk_availability" FOREIGN KEY ("availability")
REFERENCES "availability" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "site" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "sitelink" ADD CONSTRAINT "fk_entity" FOREIGN KEY ("entity")
REFERENCES "entity" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "sitelink" ADD CONSTRAINT "fk_farend" FOREIGN KEY ("farend")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "sitelink" ADD CONSTRAINT "fk_nearend" FOREIGN KEY ("nearend")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "sitepicture" ADD CONSTRAINT "fk_site" FOREIGN KEY ("site")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "sitesubnet" ADD CONSTRAINT "fk_site" FOREIGN KEY ("site")
REFERENCES "site" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "sitesubnet" ADD CONSTRAINT "fk_subnet" FOREIGN KEY ("subnet")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "splice" ADD CONSTRAINT "fk_strand1" FOREIGN KEY ("strand1")
REFERENCES "cablestrand" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "splice" ADD CONSTRAINT "fk_strand2" FOREIGN KEY ("strand2")
REFERENCES "cablestrand" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "subnetzone" ADD CONSTRAINT "fk_subnet" FOREIGN KEY ("subnet")
REFERENCES "ipblock" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "subnetzone" ADD CONSTRAINT "fk_zone" FOREIGN KEY ("zone")
REFERENCES "zone" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "userright" ADD CONSTRAINT "fk_accessright" FOREIGN KEY ("accessright")
REFERENCES "accessright" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "userright" ADD CONSTRAINT "fk_person" FOREIGN KEY ("person")
REFERENCES "person" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "vlan" ADD CONSTRAINT "fk_vlangroup" FOREIGN KEY ("vlangroup")
REFERENCES "vlangroup" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "zone" ADD CONSTRAINT "fk_contactlist" FOREIGN KEY ("contactlist")
REFERENCES "contactlist" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: (ALTER TABLE "zonealias" ADD CONSTRAINT "fk_zone" FOREIGN KEY ("zone")
REFERENCES "zone" ("id") DEFERRABLE):
rows affected: 0E0
DEBUG: Disconnected successfully
Schema inserted sucessfully
Now building ACL's for postgres
DEBUG: init: dbi:Pg:dbname=netdot;host=localhost;port=5432
DEBUG: Connected successfully
DEBUG: (
DROP USER IF EXISTS netdot;
CREATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUSER):
DBD::Pg::db do failed: ERROR: opci�n de rol no reconocida �nocreateuser�
L�NEA 3: ...REATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUS...
^ at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing
DROP USER IF EXISTS netdot;
CREATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUSER: DBD::Pg::db do failed: ERROR: opci�n de rol no reconocida �nocreateuser�
L�NEA 3: ...REATE USER netdot WITH PASSWORD 'lala' NOCREATEDB NOCREATEUS...
^ at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON asn_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON asn_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON accessright TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON accessright TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON accessright_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON accessright_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON arpcache TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON arpcache TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON arpcache_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON arpcache_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON arpcacheentry TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON arpcacheentry TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON arpcacheentry_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON arpcacheentry_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON asset TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON asset TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON asset_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON asset_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON audit TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON audit TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON audit_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON audit_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON availability TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON availability TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON availability_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON availability_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON bgppeering TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON bgppeering TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON bgppeering_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON bgppeering_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON backbonecable TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON backbonecable TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON backbonecable_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON backbonecable_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON cablestrand TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON cablestrand TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON cablestrand_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON cablestrand_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON cabletype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON cabletype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON cabletype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON cabletype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON circuit TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON circuit TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON circuit_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON circuit_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON circuitstatus TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON circuitstatus TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON circuitstatus_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON circuitstatus_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON circuittype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON circuittype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON circuittype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON circuittype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON closet TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON closet TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON closet_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON closet_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON closetpicture TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON closetpicture TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON closetpicture_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON closetpicture_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON contact TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON contact TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON contact_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON contact_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON contactlist TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON contactlist TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON contactlist_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON contactlist_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON contacttype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON contacttype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON contacttype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON contacttype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON datacache TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON datacache TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON datacache_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON datacache_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON device TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON device TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON device_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON device_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattrname TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattrname TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattrname_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON deviceattrname_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON devicecontacts TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON devicecontacts TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON devicecontacts_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON devicecontacts_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON devicemodule TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON devicemodule TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON devicemodule_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON devicemodule_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattrname TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattrname TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattrname_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpattrname_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscope TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscope TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscope_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscope_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopetype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopetype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopetype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopetype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopeuse TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopeuse TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopeuse_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON dhcpscopeuse_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entity TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entity TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entity_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entity_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entityrole TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entityrole TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entityrole_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entityrole_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entitysite TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entitysite TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entitysite_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entitysite_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entitytype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entitytype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON entitytype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON entitytype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON fwtable TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON fwtable TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON fwtable_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON fwtable_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON fwtableentry TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON fwtableentry TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON fwtableentry_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON fwtableentry_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON fibertype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON fibertype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON fibertype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON fibertype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON floor TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON floor TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON floor_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON floor_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON floorpicture TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON floorpicture TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON floorpicture_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON floorpicture_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON groupright TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON groupright TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON groupright_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON groupright_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON horizontalcable TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON horizontalcable TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON horizontalcable_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON horizontalcable_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON hostaudit TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON hostaudit TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON hostaudit_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON hostaudit_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON interface TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON interface TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON interface_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON interface_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON interfacevlan TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON interfacevlan TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON interfacevlan_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON interfacevlan_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipservice TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipservice TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipservice_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipservice_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblock TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblock TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblock_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblock_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattrname TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattrname TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattrname_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockattrname_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockstatus TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockstatus TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockstatus_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON ipblockstatus_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON maintcontract TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON maintcontract TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON maintcontract_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON maintcontract_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON monitorstatus TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON monitorstatus TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON monitorstatus_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON monitorstatus_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON oui TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON oui TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON oui_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON oui_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON person TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON person TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON person_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON person_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON physaddr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON physaddr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON physaddr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON physaddr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattrname TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattrname TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattrname_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON physaddrattrname_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON product TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON product TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON product_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON product_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON producttype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON producttype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON producttype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON producttype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rraddr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rraddr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rraddr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rraddr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrcname TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrcname TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrcname_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrcname_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrds TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrds TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrds_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrds_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrhinfo TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrhinfo TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrhinfo_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrhinfo_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrloc TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrloc TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrloc_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrloc_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrmx TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrmx TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrmx_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrmx_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrnaptr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrnaptr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrnaptr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrnaptr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrns TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrns TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrns_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrns_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrptr TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrptr TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrptr_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrptr_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrsrv TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrsrv TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrsrv_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrsrv_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrtxt TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrtxt TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON rrtxt_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON rrtxt_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON room TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON room TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON room_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON room_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON stpinstance TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON stpinstance TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON stpinstance_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON stpinstance_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON savedqueries TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON savedqueries TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON savedqueries_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON savedqueries_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON schemainfo TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON schemainfo TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON schemainfo_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON schemainfo_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON service TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON service TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON service_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON service_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON site TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON site TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON site_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON site_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON sitelink TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON sitelink TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON sitelink_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON sitelink_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON sitepicture TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON sitepicture TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON sitepicture_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON sitepicture_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON sitesubnet TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON sitesubnet TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON sitesubnet_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON sitesubnet_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON splice TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON splice TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON splice_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON splice_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON strandstatus TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON strandstatus TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON strandstatus_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON strandstatus_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON subnetzone TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON subnetzone TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON subnetzone_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON subnetzone_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON userright TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON userright TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON userright_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON userright_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON usertype TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON usertype TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON usertype_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON usertype_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON vlan TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON vlan TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON vlan_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON vlan_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON vlangroup TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON vlangroup TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON vlangroup_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON vlangroup_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON zone TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON zone TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON zone_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON zone_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON zonealias TO netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON zonealias TO netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: (GRANT SELECT, INSERT, UPDATE, DELETE ON zonealias_id_seq to netdot):
DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.
ERROR while executing GRANT SELECT, INSERT, UPDATE, DELETE ON zonealias_id_seq to netdot: DBD::Pg::db do failed: ERROR: no existe el rol �netdot� at ../lib/DBUTIL.pm line 594, line 2714.

DEBUG: Disconnected successfully
Inserting default data
DEBUG: init: dbi:Pg:dbname=netdot;host=localhost;port=5432
DEBUG: Connected successfully
DEBUG: (INSERT INTO schemainfo (version) VALUES('1.0.7')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('DS3')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('xDSL')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('Ethernet')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('Frame Relay')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('LADS')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('OC3')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('OC12')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('OC48')):
rows affected: 1
DEBUG: (INSERT INTO circuittype (name) VALUES ('T1')):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Cat3 UTP')):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Cat5 UTP')):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Cat5e UTP'); ):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Cat6 UTP')):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Fiber')):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Coaxial')):
rows affected: 1
DEBUG: (INSERT INTO cabletype (name) VALUES ('Copper Bundle')):
rows affected: 1
DEBUG: (INSERT INTO fibertype (name) VALUES ('Multimode Fiber')):
rows affected: 1
DEBUG: (INSERT INTO fibertype (name) VALUES ('Singlemode Fiber')):
rows affected: 1
DEBUG: (INSERT INTO availability (name) VALUES ('24x7')):
rows affected: 1
DEBUG: (INSERT INTO availability (name) VALUES ('Never')):
rows affected: 1
DEBUG: (INSERT INTO availability (name) VALUES ('8:00-17:00')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Branch', 'Branches of our organization.')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Customer', 'Entities that receives products and or services from our organization.')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Department', 'Departments.')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Manufacturer', 'Companies that manufacture network hardware.')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Peer', 'BGP Peers that exchange traffic with us.')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Provider', 'Circuit providers.')):
rows affected: 1
DEBUG: (INSERT INTO entitytype (name, info) VALUES ('Vendor', 'Companies that sell hardware or services to us.')):
rows affected: 1
DEBUG: (INSERT INTO entity (name) VALUES ('Unknown')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid, config_type) VALUES ('Cisco', 'Cisco', '1.3.6.1.4.1.9', 'cisco')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid, config_type) VALUES ('Hewlett Packard', 'HP', '1.3.6.1.4.1.11', 'hp')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Nortel BayRS', 'BayRS', '1.3.6.1.4.1.18')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Sun Microsystems', 'Sun', '1.3.6.1.4.1.42')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('D-Link', 'D-Link', '1.3.6.1.4.1.171')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Microsoft', 'Microsoft', '1.3.6.1.4.1.311')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Dell', 'Dell', '1.3.6.1.4.1.674')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid, config_type) VALUES ('Extreme', 'Extreme', '1.3.6.1.4.1.1916', 'extreme')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid, config_type) VALUES ('Foundry', 'Foundry', '1.3.6.1.4.1.1991', 'foundry')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('UCD-SNMP', 'UCD-SNMP', '1.3.6.1.4.1.2021')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('RapidCity', 'RapidCity', '1.3.6.1.4.1.2272')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid, config_type) VALUES ('Juniper Networks', 'Juniper', '1.3.6.1.4.1.2636', 'juniper')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Cyclades', 'Cyclades', '1.3.6.1.4.1.2925')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Netgear', 'Netgear', '1.3.6.1.4.1.4526')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid, config_type) VALUES ('Enterasys', 'Enterasys', '1.3.6.1.4.1.5624', 'enterasys')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Alcatel-Lucent', 'Lucent', '1.3.6.1.4.1.6486')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Alcatel-Lucent (Timetra)', 'Timetra', '1.3.6.1.4.1.6527')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Net-SNMP', 'Net-SNMP', '1.3.6.1.4.1.8072'); ):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Cisco Airespace', 'Airespace', '1.3.6.1.4.1.14179')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Aruba Networks', 'Aruba', '1.3.6.1.4.1.14823')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Cisco (Altiga)', 'Altiga', '1.3.6.1.4.1.3076')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, oid) VALUES ('Avaya', 'Avaya', '1.3.6.1.4.1.6889')):
rows affected: 1
DEBUG: (INSERT INTO contactlist (name) VALUES ('Network Services Contacts')):
rows affected: 1
DEBUG: (INSERT INTO entity (name, short_name, contactlist ) VALUES ('Network Services', 'NS', '1')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('1', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('2', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('3', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('4', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('5', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('6', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('7', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('8', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('9', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('10', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('11', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('12', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('13', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('14', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('15', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('16', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('17', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('18', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('19', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('20', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('21', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('22', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('23', '4')):
rows affected: 1
DEBUG: (INSERT INTO entityrole (entity,type) VALUES ('24', '3')):
rows affected: 1
DEBUG: (INSERT INTO circuitstatus (name) VALUES ('Active')):
rows affected: 1
DEBUG: (INSERT INTO circuitstatus (name) VALUES ('Disabled')):
rows affected: 1
DEBUG: (INSERT INTO circuitstatus (name) VALUES ('Disconnected')):
rows affected: 1
DEBUG: (INSERT INTO circuitstatus (name) VALUES ('Pending')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Container')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Discovered')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Dynamic')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Reserved')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Subnet')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Static')):
rows affected: 1
DEBUG: (INSERT INTO ipblockstatus (name) VALUES ('Available')):
rows affected: 1
DEBUG: (INSERT INTO strandstatus (name) VALUES ('In Use')):
rows affected: 1
DEBUG: (INSERT INTO strandstatus (name) VALUES ('Available')):
rows affected: 1
DEBUG: (INSERT INTO strandstatus (name) VALUES ('Not Terminated')):
rows affected: 1
DEBUG: (INSERT INTO strandstatus (name) VALUES ('Damaged')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Access Point')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Console Server')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Firewall')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Hub')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('IP Phone')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Router')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Module')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Server')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Switch')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Wireless Bridge')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Wireless Controller')):
rows affected: 1
DEBUG: (INSERT INTO producttype (name) VALUES ('Unknown')):
rows affected: 1
DEBUG: (INSERT INTO product (name,type,manufacturer,sysobjectid,part_number) VALUES ('Generic Net-SNMP Agent', 7, 19, '1.3.6.1.4.1.8072.3.2.10', 2)):
rows affected: 1
DEBUG: (INSERT INTO product (name,type,manufacturer,sysobjectid,part_number) VALUES ('Windows Server', 7, 7, '1.3.6.1.4.1.311.1.1.3.1.3', 2)):
rows affected: 1
DEBUG: (INSERT INTO product (name,type,manufacturer,part_number) VALUES ('Unknown', 11, 1, 1)):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('DHCPD')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('DNS')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('HTTP')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('IMAP')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('MySQL')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('POP3')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('SMTP')):
rows affected: 1
DEBUG: (INSERT INTO service (name) VALUES ('Radius')):
rows affected: 1
DEBUG: (INSERT INTO contacttype (name) VALUES ('Administrative Contact')):
rows affected: 1
DEBUG: (INSERT INTO contacttype (name) VALUES ('Primary Technical Contact')):
rows affected: 1
DEBUG: (INSERT INTO contacttype (name) VALUES ('Secondary Technical Contact')):
rows affected: 1
DEBUG: (INSERT INTO contacttype (name) VALUES ('Billing Contact')):
rows affected: 1
DEBUG: (INSERT INTO contacttype (name) VALUES ('End User')):
rows affected: 1
DEBUG: (INSERT INTO monitorstatus (name) VALUES ('Down')):
rows affected: 1
DEBUG: (INSERT INTO monitorstatus (name) VALUES ('Up')):
rows affected: 1
DEBUG: (INSERT INTO monitorstatus (name) VALUES ('Unknown')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('global')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('group')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('shared-network')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('subnet')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('host')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('template')):
rows affected: 1
DEBUG: (INSERT INTO dhcpscopetype (name) VALUES ('class')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('always-broadcast')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('always-reply-rfc1048')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow booting')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow bootp')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow client-updates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow all clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow authenticated clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow unauthenticated clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow declines')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow duplicates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow dynamic bootp clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow known-clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow leasequery')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('allow unknown-clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('authoritative')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('boot-unknown-clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('db-time-format')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('default-lease-time')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('ddns-hostname')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('ddns-domainname')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('ddns-rev-domainname')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('ddns-updates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('ddns-update-style')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny-duplicates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny all clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny authenticated clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny unauthenticated clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny booting')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny bootp')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny client-updates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny declines')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny duplicates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny dynamic bootp clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny known-clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny leasequery')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('deny unknown-clients')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('do-forward-updates')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('dynamic-bootp-lease-length')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('dynamic-bootp-lease-cutoff')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('get-lease-hostnames')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('filename')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('lease limit')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('log-facility')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('match')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('match if')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('max-lease-time')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('min-lease-time')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('min-secs')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('next-server')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('not authoritative')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('omapi-port')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('preferred-lifetime')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('range')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('server-identifier')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('server-name')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('site-option-space')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('use-host-decl-names')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('use-lease-addr-for-default-route')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('vendor-option-space')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option subnet-mask', '1', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option time-offset', '2', 'signed integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option routers', '3', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option time-servers', '4', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option ien116-name-servers', '5', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option domain-name-servers', '6', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option log-servers', '7', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option cookie-servers', '8', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option lpr-servers', '9', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option imporess-servers', '10', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option resource-location-servers', '11', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option host-name', '12', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option boot-size', '13', 'unsigned integer 16' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option merit-dump', '14', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option domain-name', '15', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option swap-server', '16', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option root-path', '17', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option extensions-path', '18', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option ip-forwarding', '19', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option non-local-source-routing', '20', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option policy-filter', '21', 'array of { ip-address, ip-address }' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option max-dgram-reassembly', '22', 'unsigned integer 16' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option default-ip-ttl', '23', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option path-mtu-aging-timeout', '24', 'unsigned integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option path-mtu-plateau-table', '25', 'array of unsigned integer 16' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option interface-mtu', '26', 'unsigned integer 16' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option all-subnets-local', '27', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option broadcast-address', '28', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option perform-mask-discovery', '29', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option mask-supplier', '30', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option router-discovery', '31', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option router-solicitation-address', '32', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option static-routes', '33', 'array of { ip-address, ip-address }' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option trailer-encapsulation', '34', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option arp-cache-timeout', '35', 'unsigned integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option ieee802-3-encapsulation', '36', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option default-tcp-ttl', '37', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option tcp-keepalive-internal', '38', 'unsigned integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option tcp-keepalive-garbage', '39', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nis-domain', '40', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nis-servers', '41', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option ntp-servers', '42', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option vendor-encapsulated-options', '43', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option netbios-name-servers', '44', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option netbios-dd-server', '45', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option netbios-node-type', '46', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option netbios-scope', '47', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option font-servers', '48', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option x-display-manager', '49', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-requested-address', '50', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-lease-time', '51', 'unsigned integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-option-overload', '52', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-message-type', '53', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-server-identifier', '54', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-parameter-request-list', '55', 'array of unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-message', '56', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-max-message-size', '57', 'unsigned integer 16' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-renewal-time', '58', 'unsigned integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-rebinding-time', '59', 'unsigned integer 32' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option vendor-class-identifier', '60', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option dhcp-client-identifier', '61', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nwip-domain', '62', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nisplus-domain', '64', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nisplus-servers', '65', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option tftp-server-name', '66', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option bootfile-name', '67', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option mobile-ip-home-agent', '68', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option smtp-server', '69', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option pop-server', '70', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nntp-server', '71', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option www-server', '72', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option finger-server', '73', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option irc-server', '74', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option streettalk-server', '75', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option streettalk-directory-assistance-server', '76', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option slp-directory-agent', '78', 'array of { boolean, ip-address }' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nds-servers', '85', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nds-tree-name', '86', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nds-context', '87', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option uap-servers', '98', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option subnet-selection', '118', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nwip.nsq-broadcast', '5', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nwip.preferred-dss', '6', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option nwip.nearest-nwip-server', '7', 'array of ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option nwip.autoretries', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option nwip.autoretry-secs', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option nwip.nwip-1-1', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option nwip.primary-dss', 'ip-address' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.no-client-update', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.server-update', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.encoded', 'boolean' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.rcode1', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.rcode2', 'unsigned integer 8' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.hostname', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.domainname', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, format) VALUES ('option fqdn.fqdn', 'text' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option agent.circuit-id', '1', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name, code, format) VALUES ('option agent.remote-id', '2', 'string' )):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('option dhcp6.name-servers')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('option dhcp6.domain-search')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('option dhcp6.preference')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('option dhcp6.rapid-commit')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('option dhcp6.info-refresh-time')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('dhcpv6-lease-file-name')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('range6')):
rows affected: 1
DEBUG: (INSERT INTO dhcpattrname (name) VALUES ('prefix6')):
rows affected: 1
DEBUG: (INSERT INTO usertype (name, info) VALUES ('Admin', 'An Admin user has full access to Netdot')):
rows affected: 1
DEBUG: (INSERT INTO usertype (name, info) VALUES ('Operator', 'Operators have the same view as Admins, but have read-only access')):
rows affected: 1
DEBUG: (INSERT INTO usertype (name, info) VALUES ('User', 'Regular users have a restricted view of objects in Netdot, and can only read and/or write objects depending on the permissions assigned to them.')):
rows affected: 1
DEBUG: (INSERT INTO person (lastname, firstname, username, user_type, password) VALUES ('Admin', 'Admin', 'admin', '1', 'jGl25bVBBBW96Qi9Te4V37Fnqchz/Eu4qB9vKrRIqRg')):
rows affected: 1
DEBUG: (INSERT INTO person (lastname, firstname, username, user_type, password) VALUES ('Operator', 'Operator', 'operator', '2', 'BuVbYzSB97sHKVfqvPEQyXLoZpHDz+2r4IgCS//kLyM')):
rows affected: 1
DEBUG: (INSERT INTO person (lastname, firstname, username, user_type, password) VALUES ('Guest', 'Guest', 'guest', '3', 'hJg8YPfarcHLhphiH4AsDZ+aPDwpXIEHSPsEgRXBhuw')):
rows affected: 1
DEBUG: (INSERT INTO ipblock (address, prefix, version, status, owner, used_by, description) VALUES ('3232235520', '16', '4', '1', '1', '1', 'RFC-1918')):
rows affected: 1
DEBUG: (INSERT INTO ipblock (address, prefix, version, status, owner, used_by, description) VALUES ('2886729728', '12', '4', '1', '1', '1', 'RFC-1918')):
rows affected: 1
DEBUG: (INSERT INTO ipblock (address, prefix, version, status, owner, used_by, description) VALUES ('167772160', '8', '4', '1', '1', '1', 'RFC-1918')):
rows affected: 1
DEBUG: (INSERT INTO ipblock (address, prefix, version, status, owner, used_by, description) VALUES ('2851995648', '16', '4', '1', '1', '1', 'IPv4 Link Local')):
rows affected: 1
DEBUG: (INSERT INTO ipblock (address, prefix, version, status, owner, used_by, description) VALUES ('42540766411282592856903984951653826560', '32', '6', '1', '1', '1', 'RFC-3849')):
rows affected: 1
DEBUG: (INSERT INTO ipblock (address, prefix, version, status, owner, used_by, description) VALUES ('338288524927261089654018896841347694592', '10', '6', '1', '1', '1', 'Link-Local Unicast')):
rows affected: 1
DEBUG: (INSERT INTO zone (name, active, default_ttl, info, minimum, mname, refresh, retry, rname, serial, expire, export_file) VALUES ('defaultdomain', '0', '86400', 'Default Zone', '86400', 'localhost.defaultdomain', '7200', '900', 'hostmaster.defaultdomain', '0', 1577858400, '/tmp/zone_export.txt')):
rows affected: 1
DEBUG: (INSERT INTO rr (name, active, zone, auto_update) VALUES ('@', '0', '1', true)):
rows affected: 1
DEBUG: (INSERT INTO rrns (rr, nsdname, ttl) VALUES ('1', 'ns1.defaultdomain', '86400')):
rows affected: 1
DEBUG: (INSERT INTO rrns (rr, nsdname, ttl) VALUES ('1', 'ns2.defaultdomain', '86400')):
rows affected: 1
DEBUG: Disconnected successfully
Database initialized successfully

NetdotLDAPServer2 is ignored

Option NetdotLDAPServer2 is ignored, as there is a typo in configuration handler. It just gets overridden by primary server value: f165066

SSH connection to ASA for ARP collection no longer works ("prompt does not match")

ERROR: Device::CLI::_get_arp_from_cli: wrn-asa1.int.example.net: login failed to remote host - prompt does not match at /usr/share/perl5/Net/Appliance/Session/Transport.pm line 78.

But if I login manually, the prompt is a simple one which looks like it should match the generic prompt in /usr/share/perl5/Net/CLI/Interact/phrasebook/cisco/pb

[email protected]'s password:
Type help or '?' for a list of available commands.
wrn-asa1#

Unfortunately the error message doesn't show what text it was trying to match against the prompt.

Configuration in Site.conf is:

DEVICE_CLI_CREDENTIALS  => [
    {   pattern     => '.*',
        login       => 'netdot',
        password    => '<snip>',
        privileged  => '<snip>',
        transport   => 'SSH',
        timeout     => '30',
    },
],

system has libnet-appliance-session-perl 4.131260-1

root@netdot:~# ls -l /usr/share/perl5/Net/Appliance/Session/Transport.pm
-rw-r--r-- 1 root root 3493 May  6  2013 /usr/share/perl5/Net/Appliance/Session/Transport.pm

This used to work a while ago. Possible differences now are: (1) ASAs are now running firmware 9.1 and 9.6; (2) I may have done an "apt-get dist-upgrade" at some point.

Add config option to ignore external subnets from transit/peering links

mark strand "In Use" when adding a strand to a circuit

In our version (circa 1.0.7) of Netdot, when adding a strand to a circuit, the strand's status is still "Available" after adding. It should probably be automatically set to "In Use".

Wanting to contribute but a bit lost

Hello,
I have made several "improvements" to Nedot i'd like to share.
However what i have made is changing things in the production code of my Netdot (based on 1.0.7).
So i'm a bit loss as to what should i do to try to pull the changes in the right way.
What i'm thinking on doing is cloning the official Netdot repo, then change remote to a local git. Incoporate the modiffied files then commit them, and after that change remote to github repo and then the pulling requests (suggestion). I don't know if it's the right way. One of my worries is that the files on the repo are not meant to be used directly and maybe cointain variables used by the Makefile.
My changes include:
Adding the use of a proxy ldap user to do the actual validation of ldap users, thus have it working on LDAP servers that don't allow anonymous bind and possibiliting the users on the LDAP server to reside in more than one branch.
github_issue.zip

This modifies:
apache config file (should point to a newly created file called netdot_apache2_ldap_proxyuser.conf).
<NETDOT_PROD>/lib/Netdot/LDAP.pm
I'm using it with apache-2.4
Other changes are:
New CLI device support (ipv4 arp and fwt):
H3C switches (tested on H3C A5500-48G-PoE+, H3C JD377A, H3C JG240A)
JunOS (tested on Juniper Networks .92)
NetScreen (tested on 5400 and 5200 units) (this was included but not working for me).
This modifies:
lib/Netdot/Meta.pm
and adds:
lib/Netdot/Model/Device/CLI/H3C.pm
lib/Netdot/Model/Device/CLI/JunOS.pm
lib/Netdot/Model/Device/CLI/Netscreen.pm (modified)
As well as some new phrasebook personalities wich i have in
/usr/lib/perl5/site_perl/5.10.0/Net/CLI/Interact/phrasebook/h3c/pb
/usr/lib/perl5/site_perl/5.10.0/Net/CLI/Interact/phrasebook/cisco/junos/pb
I'm trying to add support for F5 LTM device, and having troubles becouse VLAN interfaces are not added to Netdot (DEBUG - xxxx.xxx.xxx [0.5]: VLAN 2230 not mapped to any STP instance), then the F5 CLI commands seems to give ARP table related to VLAN and not to physical interface, don't know if it will be better to try to add the vlans as interfaces on netdot, or just find a way to map them to the physical interface. But i guess that matter should be treated on a different issue.
I also have made some auxiliar scripts written in python, i've called it netdot-adds and have them on a local git repo. Some of their uses are:
Automatically assing device Site bassed on the Site of the ipblock parent where the snmp_target ipblock resides (this uses a temporal table created from ipblock wich cointains first ip and last ip number for every network to fast locate wich ipblock network an ipblock host (prefix=32) belongs to).
A script to poll "alive" ipblocks in Netdot using WMII and storing the results in the ipblockattr table (motherboard serial number, processor, ram, interfaces with mac...). This is quite big, for it to work you need to have valid WMII credentials on the windows hosts obviously (and they will travel over the netword).
A script to generate xls spreadsheets with above information, site->networks->devices->[ipblocks] with edgeports (i've rewritten find_edge_port on python becouse calling the external perl program was too slow)
Create a kml (google earth file) with sites from the gps coordinates (addded as new fields on site table and guesses from postal address from google online services), this was posted on mailing list some years ago).
A script to parse cisco CSS load balancers configuration file and add real servers -> virtual servers

correlation using fake dns domains.
Not sure if this last could be of interest to anyone else, having for some of the things to work you will need to modify netdot DB schema (adding some fields and temporal tables).

Container containing subnets converts into subnet by router discovery

Backbone cable site search show too many results

Version: Latest

I'm submitting a : Bug Report

Current behavior: When searching Backbone Cable on (Cable Plant=>Backbone Cables) Site Name: [Building] shows double results

Expected behavior: When searching Backbone Cable on (Cable Plant=>Backbone Cables) Connected from: [Building] To: [Same Building] only one result should appear in this case two not four.

Steps to reproduce: Create one building, create one floor, create two closets. Create two backbone cables going from closet1 to closet2. Once this is complete go to Cable Plant=> Backbone Cables and search for site name in Site Name : [Building].

Related code: Currently Unknown

TXT Record more than 255 chars

I need to add a DKIM record with a long key (the TXT record is more than 254 characters).

RFC4408 (3.1.3) explain that we have to split record as following:

IN TXT "v=DKIM .... first" "second string..."

Each string is no more than 254 characters

Not able to add the Devices in Netnot

Please help me to figure out the following issue;

Wen I am running the update script as follow :

sudo bin/updatedevices.pl -E discoverme.txt -IAF ( disocoverme.txt contains the device names) but it is giving following error :
ERROR - Error while inserting DeviceModule: Can't insert new DeviceModule: Can't get last insert id at /usr/local/netdot/lib/Netdot/Model/Device.pm line 5964.
at /usr/local/netdot/lib/Netdot/Model/Device.pm line 5964

Then not able to start apache2 as well.

Thanks

whois query for BGP peers doesn't work behind a proxy

Hello,
When doing discovery it seems to timeout on discovering information about our BGP peers - disabling this fixes the issue.
The environment variables HTTP_PROXY and HTTPS_PROXY are set - perhaps Netdot could use those?

Same zone records in bulk import are ignored

When importing zone data in BIND format, and zone contains multiple records for the same label (even in case with A/AAAA types) only the last one is stored (with import_overwrite=on):

ns1.asf.as.              300     IN      A       127.0.0.1
ns1.asf.as.              300     IN      AAAA    ::1
ns1.asf.as.              300     IN      A       127.0.0.2
ns1.asf.as.              300     IN      AAAA    ::2

-> ns1 IN AAAA ::2

mail.asf.as.             300     IN      A       127.0.0.1
mail.asf.as.             300     IN      A       127.0.0.2

-> mail IN A 127.0.0.2

Cannot add RR without sub-records via UI

User should be able to add an RR and then select the other sub-records attached to the label.

This changed recently when that form was modified.

Debian 9.7 make apt-install fails (as in Ubuntu 18.04.1)

Similar to the problems pointed in Ubuntu 18.04.1

root@nicopc:~/Netdot# lsb_release -da
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 9.7 (stretch)
Release: 9.7
Codename: stretch

root@nicopc:~/Netdot# make apt-install
Installing required APT packages
/usr/bin/perl bin/perldeps.pl apt-install

Which RDBMS do you plan to use as backend: [mysql|Pg]? Pg

We need to add a temporary repository of Netdot dependencies until all packages are in Debian/Ubuntu official repositories.
Would you like to continue? [y/n] y
Use of uninitialized value $debian_version in pattern match (m//) at bin/perldeps.pl line 171, line 2.
Updating package indexes from sources
Ign:1 http://ftp.es.debian.org/debian stretch InRelease
Obj:2 http://ftp.es.debian.org/debian stretch-updates InRelease
Obj:3 http://ftp.es.debian.org/debian stretch Release
Obj:4 http://security.debian.org/debian-security stretch/updates InRelease
Ign:6 http://dl.google.com/linux/chrome/deb stable InRelease
Obj:7 http://dl.google.com/linux/chrome/deb stable Release
Ign:9 http://netdot.apt.nsrc.org unstable/ InRelease
Des:10 http://netdot.apt.nsrc.org unstable/ Release [1.578 B]
Ign:11 http://netdot.apt.nsrc.org unstable/ Release.gpg
Des:12 http://netdot.apt.nsrc.org unstable/ Sources [5.124 B]
Des:13 http://netdot.apt.nsrc.org unstable/ Packages [5.411 B]
Descargados 12,1 kB en 2s (4.355 B/s)
Leyendo lista de paquetes... Hecho
W: El repositorio «http://netdot.apt.nsrc.org unstable/ Release» no está firmado.
N: Los datos de un repositorio como este no se pueden autenticar y por tanto su uso es potencialmente peligroso.
N: Vea la página de manual apt-secure(8) para los detalles sobre la creación de repositorios y la configuración de usuarios.
Use of uninitialized value $debian_version in pattern match (m//) at bin/perldeps.pl line 196, line 2.
Leyendo lista de paquetes... Hecho
Creando árbol de dependencias
Leyendo la información de estado... Hecho
Nota, seleccionando «perl-modules-5.24» en lugar de «libtime-local-perl»
Nota, seleccionando «perl-modules-5.24» en lugar de «libfile-spec-perl»
El paquete dnssec-tools no está disponible, pero algún otro paquete hace referencia
a él. Esto puede significar que el paquete falta, está obsoleto o sólo se
encuentra disponible desde alguna otra fuente
Sin embargo, los siguientes paquetes lo reemplazan:
libnet-dns-zonefile-fast-perl

E: El paquete «dnssec-tools» no tiene un candidato para la instalación
There was a problem running apt-get -y --force-yes install --no-install-recommends apache2 libapache2-mod-perl2 rrdtool librrds-perl graphviz libgraphviz-perl libmodule-build-perl libcgi-pm-perl libclass-dbi-perl libclass-dbi-abstractsearch-perl libapache2-request-perl libhtml-mason-perl libapache-session-perl liburi-perl libsql-translator-perl libsnmp-info-perl netdisco-mibs-installer libnetaddr-ip-perl libapache2-authcookie-perl libapache2-sitecontrol-perl liblog-dispatch-perl liblog-log4perl-perl libparallel-forkmanager-perl libnet-patricia-perl libauthen-radius-perl libtest-simple-perl libtest-exception-perl libnet-irr-perl libtime-local-perl libfile-spec-perl libnet-appliance-session-perl libbind-config-parser-perl libnet-dns-perl libcarp-assert-perl libdigest-sha-perl libssl-dev dnssec-tools libsocket6-perl libxml-simple-perl snmp postgresql libdbd-pg-perl libcrypt-cast5-perl
Makefile:81: fallo en las instrucciones para el objetivo 'apt-install'
make: *** [apt-install] Error 25

I just manually executed the apt-get command withoud the dnssec-tools and it worked:

apt-get -y --force-yes install --no-install-recommends apache2 libapache2-mod-perl2 rrdtool librrds-perl graphviz libgraphviz-perl libmodule-build-perl libcgi-pm-perl libclass-dbi-perl libclass-dbi-abstractsearch-perl libapache2-request-perl libhtml-mason-perl libapache-session-perl liburi-perl libsql-translator-perl libsnmp-info-perl netdisco-mibs-installer libnetaddr-ip-perl libapache2-authcookie-perl libapache2-sitecontrol-perl liblog-dispatch-perl liblog-log4perl-perl libparallel-forkmanager-perl libnet-patricia-perl libauthen-radius-perl libtest-simple-perl libtest-exception-perl libnet-irr-perl libtime-local-perl libfile-spec-perl libnet-appliance-session-perl libbind-config-parser-perl libnet-dns-perl libcarp-assert-perl libdigest-sha-perl libssl-dev libsocket6-perl libxml-simple-perl snmp postgresql libdbd-pg-perl libcrypt-cast5-perl

Only missing dependency after that was:
Net::DNS::ZoneFile::Fast..........................MISSING

And that was solved by installing:
apt-get install libnet-dns-zonefile-fast-perl

One could guess that the name of the apt changed from dnssec-tools to libnet-dns-zonefile-fast-perl from one debian version to another.

BTW right now, i'm not using the official repo but the one from https://github.com/vink78/Netdot becouse I want to test his PaloAlto API changes. Anyway on this weekend at home i installed Netdot from the official Repo on a Debian 9.7 and had the same errors.

Netdot/Model/Plugins/DeviceIpNamesFixed.pm did not return a true value

attaching a pull request. Inserting a 1; at the end of the file fixes it.

Postgres upgrading 104_105 fails

I think this first part is caused by two statements being out of order, but I'm not sure.

NOTICE:  CREATE TABLE will create implicit sequence "asn_id_seq" for serial column "asn.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pk_asn" for table "asn"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asn1" for table "asn"
DBD::Pg::db do failed: ERROR:  insert or update on table "device" violates foreign key constraint "fk_bgplocalas"
DETAIL:  Key (bgplocalas)=(0) is not present in table "asn". at ../lib/DBUTIL.pm line 589.
ERROR while executing ALTER TABLE device ADD CONSTRAINT "fk_bgplocalas" FOREIGN KEY ("bgplocalas") REFERENCES "asn" ("id") DEFERRABLE: DBD::Pg::db do failed: ERROR:  insert or update on table "device" violates foreign key constraint "fk_bgplocalas"
DETAIL:  Key (bgplocalas)=(0) is not present in table "asn". at ../lib/DBUTIL.pm line 589.

Second problem appears to be this:

push @statements, 'DROP CONSTRAINT "rrds1";';
push @statements, 'ALTER TABLE bgppeering ADD CONSTRAINT "rrds1" UNIQUE ("rr", "key_tag", "algorithm", "digest_type");';

I think it should be:

ALTER TABLE rrds DROP CONSTRAINT rrds1;
ALTER TABLE rrds ADD CONSTRAINT "rrds1" UNIQUE ("rr", "key_tag", "algorithm", "digest_type");

DBD::Pg::db do failed: ERROR:  syntax error at or near "CONSTRAINT" LINE 1: DROP CONSTRAINT "rrds1"
         ^ at ../lib/DBUTIL.pm line 589.
ERROR while executing DROP CONSTRAINT "rrds1": DBD::Pg::db do failed: 
ERROR:  syntax error at or near "CONSTRAINT" LINE 1: DROP CONSTRAINT "rrds1"
         ^ at ../lib/DBUTIL.pm line 589.

DBD::Pg::db do failed: ERROR:  column "rr" named in key does not exist at ../lib/DBUTIL.pm line 589.
ERROR while executing ALTER TABLE bgppeering ADD CONSTRAINT "rrds1" UNIQUE ("rr", "key_tag", "algorithm", "digest_type"): DBD::Pg::db do failed
ERROR:  column "rr" named in key does not exist at ../lib/DBUTIL.pm line 589.

Finally, it appears that the new asn table is created with the postgres user and not given permission to be used by netdot_user. I get this:

DBD::Pg::st execute failed: ERROR: permission denied for relation asn [for Statement "SELECT COUNT(*)

Fixed with:

grant select,insert,update,delete on asn to netdot_user;

Problem adding DNS record

User went to "Management -> DNS Records -> [new]". Error was intermittent.

Missing required argument: version Trace begun at /usr/local/netdot/lib/Netdot.pm line 105 Netdot::throw_fatal('Ipblock=HASH(0x7f5994b27760)', 'Missing required argument: version ') called at /usr/local/netdot/lib/Netdot/Model/Ipblock.pm line 84 Netdot::Model::Ipblock::int2ip('Ipblock=HASH(0x7f5994b27760)', 2147483648, undef) called at /usr/local/netdot/lib/Netdot/Model/Ipblock.pm line 3643 Netdot::Model::Ipblock::_obj_int2ip('Ipblock=HASH(0x7f5994b27760)') called at /usr/share/perl5/Class/Trigger.pm line 74 Class::Trigger::call_trigger('Ipblock=HASH(0x7f5994b27760)', 'select') called at /usr/share/perl5/Class/DBI.pm line 859 Class::DBI::_flesh('Ipblock=HASH(0x7f5994b27760)', 'Others') called at /usr/local/netdot/lib/Netdot/Model.pm line 318 Netdot::Model::_flesh('Ipblock=HASH(0x7f5994b27760)', 'Others') called at /usr/share/perl5/Class/DBI.pm line 844 Class::DBI::get('Ipblock=HASH(0x7f5994b27760)', 'version') called at /usr/share/perl5/Class/Accessor.pm line 180 Class::Accessor::__ANON__('Ipblock=HASH(0x7f5994b27760)') called at /usr/local/netdot/lib/Netdot/Model/Ipblock.pm line 3643 Netdot::Model::Ipblock::_obj_int2ip('Ipblock=HASH(0x7f5994b27760)') called at /usr/share/perl5/Class/Trigger.pm line 74 Class::Trigger::call_trigger('Ipblock=HASH(0x7f5994b27760)', 'select') called at /usr/share/perl5/Class/DBI.pm line 717 Class::DBI::construct('Ipblock', 'HASH(0x7f5981dccaf8)') called at /usr/share/perl5/Class/DBI.pm line 1159 Class::DBI::_ids_to_objects('Ipblock', 'ARRAY(0x7f593953c138)') called at /usr/share/perl5/Class/DBI.pm line 1145 Class::DBI::sth_to_objects('Ipblock', 'DBIx::ContextualFetch::st=HASH(0x7f59823e5308)', 'ARRAY(0x7f59945c0520)') called at /usr/share/perl5/Class/DBI/Search/Basic.pm line 169 Class::DBI::Search::Basic::run_search('Class::DBI::Search::Basic=HASH(0x7f5939847570)') called at /usr/share/perl5/Class/DBI.pm line 1094 Class::DBI::__ANON__('Ipblock', 'status', 5, 'HASH(0x7f5982198dc0)') called at /usr/local/netdot/lib/Netdot/Model/Ipblock.pm line 177 Netdot::Model::Ipblock::search('Ipblock', 'status', 'Subnet') called at /usr/local/netdot/htdocs/management/host_tasks.html line 138 HTML::Mason::Commands::__ANON__('view', 'new', 'showheader', 1, 'page', 'HOSTS') called at /usr/share/perl5/HTML/Mason/Component.pm line 138 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f599479e998)', 'view', 'new', 'showheader', 1, 'page', 'HOSTS') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305 eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295 HTML::Mason::Request::comp(undef, undef, undef, 'view', 'new', 'showheader', 1, 'page', 'HOSTS') called at /usr/share/perl5/HTML/Mason/Request.pm line 958 HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f59821903d8)', 'page', 'HOSTS') called at /usr/local/netdot/htdocs/management/autohandler line 81 HTML::Mason::Commands::__ANON__('view', 'new', 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Component.pm line 160 HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f599479a7b0)', 'main', 'view', 'new', 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 951 HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f59821903d8)', 'main', 'view', 'new', 'showheader', 1) called at /usr/local/netdot/htdocs/masondata/obj/1693244019/management/autohandler.obj line 21 HTML::Mason::Commands::__ANON__('view', 'new', 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Component.pm line 138 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f599479a7b0)', 'view', 'new', 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 1305 eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295 HTML::Mason::Request::comp(undef, undef, undef, 'view', 'new', 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 958 HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f59821903d8)', 'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76 HTML::Mason::Commands::__ANON__('view', 'new') called at /usr/share/perl5/HTML/Mason/Component.pm line 138 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f5a1410c468)', 'view', 'new') called at /usr/share/perl5/HTML/Mason/Request.pm line 1300 eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295 HTML::Mason::Request::comp(undef, undef, undef, 'view', 'new') called at /usr/share/perl5/HTML/Mason/Request.pm line 484 eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 484 eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 436 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f59821903d8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f59821903d8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x564a188a0a10)', 'Apache2::RequestRec=SCALAR(0x7f5939985398)') called at /usr/local/netdot/lib/Netdot/Mason.pm line 59 Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f5939985398)') called at -e line 0 eval {...} at -e line 0

Enable DHCP has no save button

I am trying to enable DHCP for a subnet, but when I navigate to the subnet, click the DHCP tab, and then click "enable DHCP" I get a page with no save button.

Backbone cable building search does not show all results

Version: Latest

I'm submitting a : Bug Report

Current behavior: When searching Backbone Cable on (Cable Plant=>Backbone Cables) Connected from: [Building] To: [Same Building] only one results appears when there is two backbone cables connected between two diffrent closets within the same building.

Expected behavior: When searching Backbone Cable on (Cable Plant=>Backbone Cables) Connected from: [Building] To: [Same Building] all results in this case two backbone cables should appear

Related code: Currently Unknown

would you please add ping check to detect the address space ?

Dear cvicente ,
Netdot is a very nice IPAM system, but when i use it manage the ip address found not every host install snmp , but they really exist.
kindly, would you please add ping check to detect the address space ?
thanks.

mac.html - Show interfaces where MAC is the LLDP remote

Show names of end hosts in interface table

Currently we only show other network devices in the neighbors column. I'd like to see the names of connected machines. This information is available in the DB (fw_table -> MAC -> IP -> name)

Display issue on management/i_fdb.html

When looking for mac addresses attached to an interface (FDB Entry), I am not able to see the MAC Address on management/i_fdb.html page. 'n/a' is displayed for the MAC Address, but the id is correct:

When I click on 'n/a', the URL is correct (I've access to management/mac.html?table=PhysAddr&id= )

It looks like be a un-assigned value for the MAC Address.

Makefile:103: recipe for target 'htdocs' failed

make install PREFIX=/usr/local/netdot APACHEUSER=www-data APACHEGROUP=www-data

then got:
cd htdocs ; make all DIR=htdocs
make[1]: Entering directory '/usr/local/netdot/htdocs'
make[1]: *** No rule to make target 'all'. Stop.
make[1]: Leaving directory '/usr/local/netdot/htdocs'
Makefile:103: recipe for target 'htdocs' failed
make: *** [htdocs] Error 2

clear instalation, ubuntu 16.04.5

Error when new device's SNMP target address is same as parent block's

Support of XML API for FWT and ARP lookup

It seems that network devices are adopting XML API to expose configuration and ARP/FWT:

I've tested it successfully for PaloAlto device: vink78@eb83655

Do you have similar needs?

updatedevice.html produced the following error:

RR can't SELECT id, zone, name
FROM rr
WHERE name = ? AND zone = ?
: DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "dom.name" [for Statement "SELECT id, zone, name
FROM rr
WHERE name = ? AND zone = ?
" with ParamValues: 1='switch9', 2='dom.name'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52, line 867.

Stack:
[/usr/share/perl5/DBIx/ContextualFetch.pm:52]
[/usr/share/perl5/DBIx/ContextualFetch.pm:32]
[/usr/share/perl5/Class/DBI.pm:1139]
[/usr/share/perl5/Class/DBI/Search/Basic.pm:169]
[/usr/share/perl5/Class/DBI.pm:1094]
[/mnt/data/www/netdot/lib/Netdot/Model/RR.pm:63]
[/usr/share/perl5/Class/DBI.pm:424]
[/mnt/data/www/netdot/lib/Netdot/Model/Device.pm:514]
[/mnt/data/www/netdot/lib/Netdot/Model/Device.pm:1519]
[/mnt/data/www/netdot/htdocs/management/updatedevice.html:257]
[/mnt/data/www/netdot/htdocs/management/autohandler:81]
[/usr/share/perl5/HTML/Mason/Request.pm:948]
[/mnt/data/www/netdot/htdocs/masondata/obj/1249759374/management/autohandler.obj:21]
[/mnt/data/www/netdot/htdocs/autohandler:76]
at /usr/share/perl5/Class/DBI/Search/Basic.pm line 169

Stack:
[/usr/share/perl/5.14/Carp.pm:79]
[/usr/share/perl5/Class/DBI.pm:169]
[/usr/share/perl5/Class/DBI.pm:1143]
[/usr/share/perl5/Class/DBI/Search/Basic.pm:169]
[/usr/share/perl5/Class/DBI.pm:1094]
[/mnt/data/www/netdot/lib/Netdot/Model/RR.pm:63]
[/usr/share/perl5/Class/DBI.pm:424]
[/mnt/data/www/netdot/lib/Netdot/Model/Device.pm:514]
[/mnt/data/www/netdot/lib/Netdot/Model/Device.pm:1519]
[/mnt/data/www/netdot/htdocs/management/updatedevice.html:257]
[/mnt/data/www/netdot/htdocs/management/autohandler:81]
[/usr/share/perl5/HTML/Mason/Request.pm:948]
[/mnt/data/www/netdot/htdocs/masondata/obj/1249759374/management/autohandler.obj:21]
[/mnt/data/www/netdot/htdocs/autohandler:76]

dot1qTpFdbPort value of 0 should not be looked up

"A value of '0' indicates that the port number has not been learned but that the device does have some forwarding/filtering information about this address"

We have seen cases where the value "0" yields incorrect results

Error at logout

Clicked on "logout" link, got the following:


error: | Can't locate object method "getAttribute" via package "0" (perhaps you forgot to load "0"?) at /usr/local/netdot/htdocs/autohandler line 47.
-- | --
context: | ... 43: </%init>44: 45: <%perl>46: # Set user type if needed47: if ( defined $user && !defined $user->getAttribute('USER_TYPE') ){48: eval {49: $ui->set_user_type($r, $user);50: };51: if ( my $e = $@ ){... | ... |   | 43: | </%init> | 44: |   | 45: | <%perl> | 46: | # Set user type if needed | 47: | if ( defined $user && !defined $user->getAttribute('USER_TYPE') ){ | 48: | eval { | 49: | $ui->set_user_type($r, $user); | 50: | }; | 51: | if ( my $e = $@ ){ | ... |  
... |  
43: | </%init>
44: |  
45: | <%perl>
46: | # Set user type if needed
47: | if ( defined $user && !defined $user->getAttribute('USER_TYPE') ){
48: | eval {
49: | $ui->set_user_type($r, $user);
50: | };
51: | if ( my $e = $@ ){
... |  
code stack: | /usr/local/netdot/htdocs/autohandler:47

Pgsql import schema

OS: CentOS 7
PG: 9.4

exec command:
make installdb

DEBUG: init: dbi:Pg:dbname=netdot;host=localhost;port=5432
DEBUG: Connected successfully
DEBUG: (COPY oui(oui, vendor) FROM '/tmp/oui.txt'):
DBD::Pg::db do failed: ERROR:  relation "oui" does not exist at ../lib/DBUTIL.pm line 594.
**ERROR while executing COPY oui(oui, vendor) FROM '/tmp/oui.txt': DBD::Pg::db do failed: ERROR:**  relation "oui" does not exist at ../lib/DBUTIL.pm line 594.

DEBUG: Disconnected successfully
Inserted 24688 entries from oui.txt
make[1]: Leaving directory `/usr/local/src/Netdot/bin'

Apache log:

localhost httpd: DBD::Pg::db selectrow_array failed: ERROR:  relation "schemainfo" does not exist\nLINE 1: SELECT version FROM schemainfo\n                            ^ [for Statement "SELECT version FROM schemainfo"] at
/usr/local/netdot/lib/Netdot/Model.pm line 68.\nBEGIN failed--compilation aborted at /usr/local/netdot/lib/Netdot/Model.pm line 382.\nCompilation failed in require at /usr/local/netdot/lib/Netdot/UI.pm line 5.\nBEGIN failed--compilation
aborted at /usr/local/netdot/lib/Netdot/UI.pm line 5.\nCompilation failed in require at /usr/local/netdot/lib/Netdot/Mason.pm line 21.\nBEGIN failed--compilation aborted at /usr/local/netdot/lib/Netdot/Mason.pm line 21.\nCompilation fail
ed in require at /etc/httpd/conf.d/netdot_apache24_local.conf line 33.\nBEGIN failed--compilation aborted
Oct  8 16:15:22 localhost systemd: httpd.service: main process exited, code=exited, status=1/FAILURE

Problem restarting apache

I was following the installation steps but when it got to restarting apache it brought this error

root@ubuntu:/usr/local/netdot# /etc/init.d/apache2 start

Starting web server apache2 [Mon Mar 25 13:01:41 2013] [warn] module apreq_module is already loaded, skipping
Syntax error on line 28 of /etc/apache2/sites-enabled/netdot:
mod_perl is already running, too late for PerlSwitches
Action 'start' failed.
The Apache error log may have more information.

Pg IPv6 quoting bug

Netdot/lib/Netdot/Model/Ipblock.pm

Line 2922 in f8b0da5

$query.=" AND ipblockstatus.name != \"Discovered\" ";

(master at time of raising issue) uses double quotes to escape the literal string Discovered. This works in MySQL, but causes an error in Pg as Pg treats this as a column name:

error:  DBD::Pg::db selectall_arrayref failed: ERROR: column "Discovered" does not exist
LINE 7: ...s=ipblockstatus.id AND ipblockstatus.name != "Discovere...
^ [for Statement " 
SELECT ipblock.id
FROM ipblockstatus, ipblock 
LEFT JOIN (rraddr CROSS JOIN rr) ON (rraddr.ipblock=ipblock.id AND rraddr.rr=rr.id)
LEFT JOIN entity ON (ipblock.used_by=entity.id)
WHERE ipblock.parent=112
AND ipblock.status=ipblockstatus.id AND ipblockstatus.name != "Discovered" GROUP BY ipblock.id 
ORDER BY ipblock.address"] at /usr/local/www/netdot/lib/Netdot/Model/Ipblock.pm line 2928.
context:    
...     
2924:   $query .= "GROUP BY ipblock.id
2925:   ORDER BY $sort2field{$sort}";
2926:   
2927:   my $dbh = $self->db_Main();
2928:   my $rows = $dbh->selectall_arrayref($query);
2929:   my @objects;
2930:   map { push @objects, Ipblock->retrieve($_->[0]) } @$rows;
2931:   return @objects;
2932:   }
...     
code stack:     /usr/local/www/netdot/lib/Netdot/Model/Ipblock.pm:2928
/usr/local/www/netdot/htdocs/management/ip.html:1794
/usr/local/www/netdot/htdocs/management/autohandler:81
/usr/local/lib/perl5/site_perl/5.16/HTML/Mason/Request.pm:951
/usr/local/www/netdot/htdocs/masondata/obj/1784076917/management/autohandler.obj:21
/usr/local/www/netdot/htdocs/autohandler:76

Reproducible by creating an IPv6 subnet and attempting to view details while using Pg for the database. Replacing with single quotes fixes the issue, but I haven't tested under MySQL.

Cannot add a device VIA the GUI

If this is the wrong place to address this my apologies.
I am running Ubuntu Server 14.04
Apache2 version 2.4.7
Netdot 1.0.7
I installed using a number of references:
https://nsrc.org/workshops/2016/rwnog-nmm/netmgmt/en/netdot/exercises-netdot.htm
http://snazone.blogspot.com/2011/07/installing-and-setting-up-netdot-on.html (though not the same version)
I also used the Netdot - Users Manual
I can add devices all day long using the terminal and the updatedevices.pl file HOWEVER
Attempting to add any device from the web GUI presents the error:
Device::_get_snmp_session: Cannot connect to x.x.x.x. Tried communities: public
I can verify that snmp is set up on the device the GUI is attempting to connect to using Paessler SNMP Tester v. 5.2.3
I cannot tell if this is a permissions issue or if the web service is somehow trying to use a different set of MIBs.
And I am very much a Ubuntu server "noob" so.. I'm struggling. Any help would be much appreciated

D-link STP Root Port

Not find STP Root Port in some D-Link switch
Des-1210-10/ME (OID - .1.3.6.1.4.1.171.10.75.14.1.6.1.13.0)
Des-1210-26/ME (OID - .1.3.6.1.4.1.171.10.75.14.6.1.13.0)
Des-1210-10 (OID - .1.3.6.1.4.1.171.10.75.16.1.6.1.13.0)
Des-3200 rev. A1, Des-3028, Des-3016, Des-1228/ME (OID - .1.3.6.1.4.1.171.12.15.2.3.1.18.0)

Support for privilege levels

I have several ASAs that I'm collecting ARP tables from. I am locking it down so that the netdot login only has minimal permissions.

Starting point:

username netdot password XXXX privilege 5
enable password XXXX level 5
privilege show level 5 command arp
privilege show level 5 command ipv6
aaa authorization command LOCAL

However to do this, at login time the client needs to send "enable 5" instead of "enable" before sending the enable password.

Newer versions of ASA support aaa authorization exec LOCAL auto-enable, which skips the enable prompt entirely, but sadly these ones don't.

I found it is possible to frig it by patching /usr/share/perl5/Net/CLI/Interact/phrasebook/cisco/pb

macro begin_privileged
    send enable   << change to "send enable 5"
    match user or pass or privileged

... but it would be nice if there were a simple way to override this without patching.

Ubuntu 18.04.1 install fails

Hello I am looking for help on the following issue when installing netdot on ubuntu 18.04.1

Which RDBMS do you plan to use as backend: [mysql|Pg]? mysql

We need to add a temporary repository of Netdot dependencies until all packages are in Debian/Ubuntu official repositories.
Would you like to continue? [y/n] n
Use of uninitialized value $debian_version in pattern match (m//) at bin/perldeps.pl line 196, line 2.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'perl-modules-5.26' instead of 'libtime-local-perl'
Note, selecting 'perl-modules-5.26' instead of 'libfile-spec-perl'
Package dnssec-tools is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
libnet-dns-zonefile-fast-perl

W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Package 'dnssec-tools' has no installation candidate
There was a problem running apt-get -y --force-yes install --no-install-recommends apache2 libapache2-mod-perl2 rrdtool librrds-perl graphviz libgraphviz-perl libmodule-build-perl libcgi-pm-perl libclass-dbi-perl libclass-dbi-abstractsearch-perl libapache2-request-perl libhtml-mason-perl libapache-session-perl liburi-perl libsql-translator-perl libsnmp-info-perl netdisco-mibs-installer libnetaddr-ip-perl libapache2-authcookie-perl libapache2-sitecontrol-perl liblog-dispatch-perl liblog-log4perl-perl libparallel-forkmanager-perl libnet-patricia-perl libauthen-radius-perl libtest-simple-perl libtest-exception-perl libnet-irr-perl libtime-local-perl libfile-spec-perl libnet-appliance-session-perl libbind-config-parser-perl libnet-dns-perl libcarp-assert-perl libdigest-sha-perl libssl-dev dnssec-tools libsocket6-perl libxml-simple-perl snmp mysql-server libdbd-mysql-perl libcrypt-cast5-perl
Makefile:81: recipe for target 'apt-install' failed
make: *** [apt-install] Error 100

I also now get an error the source is not signed and will not allow me to update them. I put in my main source list deb [trusted=yes] however the install overrides that even if I alter the source list the makefile installs I just overwrite is over and over again any help here?

PhysAddr->format_address_db undefined

It seems this function does not exist.

It seems to be possible to call PhysAddr->_format_address_db instead?

Regards,

Vincent

allow custom attributes to be applied to cable plant schema

It would be great to have the flexibility to add a custom attribute to cable plant entries.

deleting MX record also deletes indirect A, AAAA, and PTR records

Deleting a DNS record that is the target for MX records also deletes the A, AAAA, and PTR records for those systems that have the MX record.

For instance:

foo IN A 10.0.0.1
foo IN MX 10 mail.example.com

Deleting the DNS record mail.example.com also deletes the A record for foo.

new cablestrandend schema?

We need to keep track of (fiber) cable terminations on each end of a given cablestrand.

One solution could look like...

Create a new table cable_strand_end that references cablestrand.

create table cable_strand_end (
id bigint primary key default nextval('cable_strand_end_id_seq'),
cablestrand foreign key references cablestrand(id),
closet foreign key references closet(id),
strand_termination foreign key references strand_termination(id)
);

create table strand_termination(
id bigint primar key default nextval('strand_termination_id_seq'),
description varchar not null unqiue
);
insert into strand_termination (description) values ('LC - UPC');
insert into strand_termination (description) values ('LC - APC');
insert into strand_termination (description) values ('SC');
insert into strand_termination (description) values ('ST');

Obviously there would be a bit of work to build up the UI around this schema, but it would give us the relational data structures to track the data.

Bug in Device::update_bgp_peering()

Some entities have multiple ASNs but use the same ASNAME. The bug causes the entity to be repeatedly updated with different AS numbers.

Apache 2.4.10 unable to start

Installing netdot 1.0.7 on debian jessie with libperl 5.20 apache did not start after. Apache did not show any messages than [pid 21877] AH01574: module apreq_module is already loaded, skipping

The solution was to add "PerlSwitches -I/usr/local/netdot/lib" in the section of netdot_apache24_local.conf .
Hope can you place the line in the right place.

Part of netdot_apache24_local.conf

Add Netdot's libraries to @inc

PerlSwitches -I/usr/local/netdot/lib

# Set up the Mason handler and global variables and import modules. **PerlSwitches -I/usr/local/netdot/lib**

use Netdot::Mason;

Override SiteControl's login method

use Netdot::SiteControlLoginWrapper;

Can not download MIBs with non English locale

Hello,

installing netdot by make apt-install results in error when running on English locale

# make apt-install
.
.
.
We will install the MIB files now. Continue? [y/n] y
Downloading necessary SNMP MIB files. This may take a few minutes.
Downloaded ok, please now run netdisco-mibs-install.

Installing SNMP MIB files
/usr/sbin/netdisco-mibs-install: error: Should be writable only by root: /tmp/netdisco-mibs
There was a problem running /usr/sbin/netdisco-mibs-install
Makefile:81: návod pro cíl „apt-install“ selhal
make: *** [apt-install] Chyba 25

prune_db option to remove interfaces fails due to foreign key constraints

Device::_get_bgp_peer_entity() does not deal well with private ASNs

It should create an entity whose name is "AS$ASN" but instead it returns the "Unknown" entity, which results in incomplete information about the peering (can't see ASN).

Error when trying to update multiple "global" DhcpScopes

DhcpScope::_assign_name: Don't know how to assign name for type: global Trace begun at /usr/local/netdot/lib/Netdot.pm line 105 Netdot::throw_fatal('DhcpScope=HASH(0x7f55d01088f8)', 'DhcpScope::_assign_name: Don\'t know how to assign name for type: global') called at /usr/local/netdot/lib/Netdot/Model/DhcpScope.pm line 973 Netdot::Model::DhcpScope::_assign_name('DhcpScope=HASH(0x7f55d01088f8)', 'HASH(0x7f55cc0107d0)') called at /usr/local/netdot/lib/Netdot/Model/DhcpScope.pm line 207

Add zone-list option to exporter.pl (patch)

A request for simple feature. Add an option for exporter.pl so that it will list all available BIND zones. For example, if one wants only export .ninja and .x.xyz domains:

bin/exporter.pl -t BIND -z $(bin/exporter.pl --list-zones | grep -P '(\.ninja|\.x.xyz)$' | cut -d\; -f2 | paste -d, -s -)

or generate bind config file from list, without using netdot API/direct database access.

Same scenario could be applied to DHCP scopes. Therefore command line interface would be consistent with web interface, in a way it provides data to user.

listzones.patch.txt

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.

cvicente / netdot Goto Github PK

netdot's Introduction

Network Documentation Tool

Documentation

Contributing

Authors

License

Acknowledgments

netdot's People

Contributors

Stargazers

Watchers

Forkers

netdot's Issues

Add Netdot's libraries to @inc

Override SiteControl's login method

Recommend Projects

Recommend Topics

Recommend Org