Hi !
Trying to create the database from scrath :
psql:/usr/local/nav/doc/sql/manage.sql:3: ERROR: table "mem" does not exist psql:/usr/local/nav/doc/sql/manage.sql:4: ERROR: table "swportblocked" does not exist psql:/usr/local/nav/doc/sql/manage.sql:5: ERROR: table "swportallowedvlan" does not exist psql:/usr/local/nav/doc/sql/manage.sql:6: ERROR: table "swportvlan" does not exist psql:/usr/local/nav/doc/sql/manage.sql:7: ERROR: table "gwport" does not exist psql:/usr/local/nav/doc/sql/manage.sql:8: ERROR: table "vlan" does not exist psql:/usr/local/nav/doc/sql/manage.sql:9: ERROR: table "prefix" does not exist psql:/usr/local/nav/doc/sql/manage.sql:10: ERROR: table "gwportprefix" does not exist psql:/usr/local/nav/doc/sql/manage.sql:11: ERROR: table "swport" does not exist psql:/usr/local/nav/doc/sql/manage.sql:12: ERROR: table "module" does not exist psql:/usr/local/nav/doc/sql/manage.sql:13: ERROR: table "netboxcategory" does not exist psql:/usr/local/nav/doc/sql/manage.sql:14: ERROR: table "netboxinfo" does not exist psql:/usr/local/nav/doc/sql/manage.sql:15: ERROR: table "netbox" does not exist psql:/usr/local/nav/doc/sql/manage.sql:16: ERROR: table "emotd" does not exist psql:/usr/local/nav/doc/sql/manage.sql:17: ERROR: table "maintenance" does not exist psql:/usr/local/nav/doc/sql/manage.sql:18: ERROR: table "emotd_related" does not exist psql:/usr/local/nav/doc/sql/manage.sql:19: ERROR: table "cat" does not exist psql:/usr/local/nav/doc/sql/manage.sql:20: ERROR: table "device" does not exist psql:/usr/local/nav/doc/sql/manage.sql:21: ERROR: table "product" does not exist psql:/usr/local/nav/doc/sql/manage.sql:22: ERROR: table "vendor" does not exist psql:/usr/local/nav/doc/sql/manage.sql:23: ERROR: table "type" does not exist psql:/usr/local/nav/doc/sql/manage.sql:24: ERROR: table "snmpoid" does not exist psql:/usr/local/nav/doc/sql/manage.sql:25: ERROR: table "typegroup" does not exist psql:/usr/local/nav/doc/sql/manage.sql:26: ERROR: table "room" does not exist psql:/usr/local/nav/doc/sql/manage.sql:27: ERROR: table "location" does not exist psql:/usr/local/nav/doc/sql/manage.sql:28: ERROR: table "usage" does not exist psql:/usr/local/nav/doc/sql/manage.sql:29: ERROR: table "org" does not exist psql:/usr/local/nav/doc/sql/manage.sql:30: ERROR: table "port2off" does not exist psql:/usr/local/nav/doc/sql/manage.sql:32: ERROR: table "swp_netbox" does not exist psql:/usr/local/nav/doc/sql/manage.sql:33: ERROR: table "alertengine" does not exist psql:/usr/local/nav/doc/sql/manage.sql:36: ERROR: table "vp_netbox_xy" does not exist psql:/usr/local/nav/doc/sql/manage.sql:37: ERROR: table "vp_netbox_grp" does not exist psql:/usr/local/nav/doc/sql/manage.sql:38: ERROR: table "vp_netbox_grp_info" does not exist psql:/usr/local/nav/doc/sql/manage.sql:41: ERROR: sequence "netbox_netboxid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:42: ERROR: sequence "gwport_gwportid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:43: ERROR: sequence "prefix_prefixid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:44: ERROR: sequence "type_typeid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:45: ERROR: sequence "swport_swportid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:46: ERROR: sequence "swp_netbox_swp_netboxid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:47: ERROR: sequence "device_deviceid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:48: ERROR: sequence "product_productid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:49: ERROR: sequence "module_moduleid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:50: ERROR: sequence "mem_memid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:51: ERROR: sequence "emotd_emotdid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:52: ERROR: sequence "maintenance_maintenanceid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:55: ERROR: sequence "vp_netbox_grp_vp_netbox_grp_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:56: ERROR: sequence "vp_netbox_xy_vp_netbox_xyid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:60: ERROR: table "status" does not exist psql:/usr/local/nav/doc/sql/manage.sql:61: ERROR: sequence "status_statusid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:72: NOTICE: CREATE TABLE will create implicit sequence "status_statusid_seq" for serial column "status.statusid" psql:/usr/local/nav/doc/sql/manage.sql:72: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "status_pkey" for table "status" CREATE TABLE psql:/usr/local/nav/doc/sql/manage.sql:83: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "org_pkey" for table "org" CREATE TABLE psql:/usr/local/nav/doc/sql/manage.sql:89: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usage_pkey" for table "usage" CREATE TABLE psql:/usr/local/nav/doc/sql/manage.sql:95: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "location_pkey" for table "location" CREATE TABLE psql:/usr/local/nav/doc/sql/manage.sql:105: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "room_pkey" for table "room" CREATE TABLE psql:/usr/local/nav/doc/sql/manage.sql:111: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nettype_pkey" for table "nettype"
CREATE TABLE psql:/usr/local/nav/doc/sql/manage.sql:432: ERROR: table "arp" does not exist psql:/usr/local/nav/doc/sql/manage.sql:433: ERROR: table "cam" does not exist psql:/usr/local/nav/doc/sql/manage.sql:434: ERROR: view "netboxmac" does not exist psql:/usr/local/nav/doc/sql/manage.sql:435: ERROR: view "prefix_active_ip_cnt" does not exist psql:/usr/local/nav/doc/sql/manage.sql:436: ERROR: view "prefix_max_ip_cnt" does not exist psql:/usr/local/nav/doc/sql/manage.sql:437: ERROR: view "prefixreport" does not exist psql:/usr/local/nav/doc/sql/manage.sql:438: ERROR: view "netboxreport" does not exist psql:/usr/local/nav/doc/sql/manage.sql:439: ERROR: view "allowedvlan_both" does not exist psql:/usr/local/nav/doc/sql/manage.sql:440: ERROR: view "allowedvlan" does not exist psql:/usr/local/nav/doc/sql/manage.sql:441: ERROR: table "eventtype" does not exist psql:/usr/local/nav/doc/sql/manage.sql:442: ERROR: table "range" does not exist psql:/usr/local/nav/doc/sql/manage.sql:444: ERROR: sequence "arp_arpid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:445: ERROR: sequence "cam_camid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:447: ERROR: function netboxid_null_upd_end_time() does not exist
psql:/usr/local/nav/doc/sql/manage.sql:619: ERROR: table "subsystem" does not exist psql:/usr/local/nav/doc/sql/manage.sql:620: ERROR: table "rrd_file" does not exist psql:/usr/local/nav/doc/sql/manage.sql:621: ERROR: table "rrd_datasource" does not exist psql:/usr/local/nav/doc/sql/manage.sql:623: ERROR: sequence "rrd_file_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:624: ERROR: sequence "rrd_datasource_seq" does not exis
psql:/usr/local/nav/doc/sql/manage.sql:719: ERROR: table "eventq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:720: ERROR: sequence "eventq_eventqid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:721: ERROR: table "eventqvar" does not exist
psql:/usr/local/nav/doc/sql/manage.sql:748: ERROR: table "alertq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:749: ERROR: sequence "alertq_alertqid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:750: ERROR: table "alertqmsg" does not exist
psql:/usr/local/nav/doc/sql/manage.sql:841: ERROR: table "alerthist" does not exist psql:/usr/local/nav/doc/sql/manage.sql:842: ERROR: sequence "alerthist_alerthistid_seq" does not exist psql:/usr/local/nav/doc/sql/manage.sql:843: ERROR: table "alerthistmsg" does not exist psql:/usr/local/nav/doc/sql/manage.sql:844: ERROR: table "alerthistvar" does not exist
psql:/usr/local/nav/doc/sql/manage.sql:941: ERROR: table "service" does not exist psql:/usr/local/nav/doc/sql/manage.sql:942: ERROR: table "serviceproperty" does not exist psql:/usr/local/nav/doc/sql/manage.sql:943: ERROR: sequence "service_serviceid_seq" does not exist
Have tried with postgresql 7.4/8.0 and 8.1, same error messages each time.
-- Med vennlig hilsen / Regards;
Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen@it.uib.no - IT-Avd, UiB - http://www.uib.no
From morten.vold at uninett.no Mon Jul 3 11:41:11 2006
From: morten.vold at uninett.no (Morten Vold) Date: Mon Jul 3 10:41:19 2006 Subject: [Nav-users] please help me In-Reply-To: 20060630014922.55933.qmail@web15907.mail.cnb.yahoo.com References: 20060630014922.55933.qmail@web15907.mail.cnb.yahoo.com Message-ID: 44A8D827.3080408@uninett.no
wenjun peng wrote:
the system shows: ImportError: cannot import psycopgmodule.so, the request denied this made me go mad, I got so puzzled with it, I thought maybe because I' m using psycopg2 instead of psycopg1, then each time when this problem occured, I add this sentence into the file: from psycopg2 import psycopg1 as psycopg Then the problem solved.
According to http://www.initd.org/tracker/psycopg/wiki/Migration, psycopg2 is not entirely backwards compatible with psycopg1. I cannot guarantee that NAV doesn't use features of psycopg1 that have changed in psycopg2, so I would say that you need to use psycopg1 only.
Now I can see webpages, but when I want to login as a user named 'admin' , and using the ' admin ' as the password , the system said no such name segment named 'admin' .
"No such name segment"? Are you sure that's the exact error message you received, it sounds pretty fishy to me.. The default password of the admin user is 'admin', if that doesn't work for you, the problem is elsewhere.
What do you see if you use psql to connect to the navprofiles database and issue the following SQL query:
SELECT * FROM account WHERE login='admin';
You should see the account details for the admin account - the default password created at installation time will be visible in plaintext until you change it from the web interface.