Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Address Pools? (Jiann-Ming Su)
2. Upgrade to 1.1.1 (Ramon Velazquez)
3. Re: Address Pools? (Carlos Vicente)
4. Re: Upgrade to 1.1.1 (Carlos Vicente)
5. Re: Upgrade to 1.1.1 (Ramon Velazquez)
----------------------------------------------------------------------
Message: 1
Date: Mon, 13 Aug 2012 22:45:51 -0700 (PDT)
From: Jiann-Ming Su <[email protected]>
Subject: [Netdot-users] Address Pools?
To: "[email protected]" <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset=iso-8859-1
Does Netdot support ISC DHCP address pools?
>From the dhcpd.conf man page:
?????? subnet 10.0.0.0 netmask 255.255.255.0 {
???????? option routers 10.0.0.254;
???????? # Unknown clients get this pool.
???????? pool {
?????????? option domain-name-servers bogus.example.com;
?????????? max-lease-time 300;
?????????? range 10.0.0.200 10.0.0.253;
?????????? allow unknown-clients;
???????? }
???????? # Known clients get this pool.
???????? pool {
?????????? option domain-name-servers ns1.example.com, ns2.example.com;
?????????? max-lease-time 28800;
?????????? range 10.0.0.5 10.0.0.199;
?????????? deny unknown-clients;
???????? }
?????? }
------------------------------
Message: 2
Date: Tue, 14 Aug 2012 11:19:43 -0400
From: Ramon Velazquez <[email protected]>
Subject: [Netdot-users] Upgrade to 1.1.1
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="windows-1252"
Hi Guys,
First of all and like to say thank you for the incredible software. I have
setup the VM Ubuntu 0.9.10, which has been upgraded to 1.0.1-RC3. I want to
upgrade to the stable and latest release 1.0.1; however, when I do the
?make upgrade? command, it quits the process with the following complain:
DEBUG: (SET AUTOCOMMIT = 0): rows affected: 0E0
DEBUG: (INSERT INTO producttype (name) VALUES ('Module')): make[1]: ***
[db] Error 255
make[1]: Leaving directory `/usr/local/src/netdot-1.0.1/upgrade'
make: *** [upgrade] Error 2
I checked the upgrade error.log and has the following errors:
DBD::mysql::db do failed: Table 'schemainfo' already exists at
../lib/DBUTIL.pm line 392.
ERROR while executing CREATE TABLE `schemainfo` (
`id` bigint NOT NULL auto_increment,
`info` text,
`version` varchar(255) NOT NULL,
UNIQUE INDEX schemainfo1 (`version`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'schemainfo' already
exists at ../lib/DBUTIL.pm line 392.
DBD::mysql::db do failed: Duplicate entry '1.0.1' for key 'schemainfo1' at
../lib/DBUTIL.pm line 392.
ERROR while executing INSERT INTO schemainfo (version) VALUES('1.0.1'):
DBD::mysql::db do failed: Duplicate entry '1.0.1' for key 'schemainfo1' at
../lib/DBUTIL.pm line 392.
DBD::mysql::db do failed: Table 'asset' already exists at ../lib/DBUTIL.pm
line 392.
ERROR while executing CREATE TABLE `asset` (
`custom_serial` varchar(255),
`date_purchased` date,
`description` varchar(255),
`id` bigint NOT NULL auto_increment,
`info` text,
`inventory_number` varchar(255),
`maint_contract` bigint,
`maint_from` date,
`maint_until` date,
`physaddr` bigint,
`po_number` varchar(255),
`product_id` bigint NOT NULL,
`reserved_for` varchar(255),
`serial_number` varchar(255),
UNIQUE INDEX asset1 (`physaddr`),
UNIQUE INDEX asset2 (`product_id`, `serial_number`),
INDEX Asset3 (`serial_number`),
INDEX Asset4 (`inventory_number`),
INDEX Asset5 (`po_number`),
INDEX (`maint_contract`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'asset' already
exists at ../lib/DBUTIL.pm line 392.
DBD::mysql::db do failed: Table 'audit' already exists at ../lib/DBUTIL.pm
line 392.
ERROR while executing CREATE TABLE `audit` (
`fields` varchar(255),
`id` bigint NOT NULL auto_increment,
`label` varchar(255) NOT NULL,
`object_id` bigint NOT NULL,
`operation` varchar(255) NOT NULL,
`tablename` varchar(255) NOT NULL,
`tstamp` timestamp NOT NULL DEFAULT '1970-01-02 00:00:01',
`username` varchar(255) NOT NULL,
`vals` varchar(255),
INDEX `Audit2` (`tstamp`),
INDEX `Audit3` (`username`),
INDEX `Audit4` (`tablename`),
INDEX `Audit5` (`label`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'audit' already
exists at ../lib/DBUTIL.pm line 392.
DBD::mysql::db do failed: Duplicate entry 'Module' for key 'producttype1'
at ../lib/DBUTIL.pm line 392.
ERROR while executing INSERT INTO producttype (name) VALUES ('Module'):
DBD::mysql::db do failed: Duplicate entry 'Module' for key 'producttype1'
at ../lib/DBUTIL.pm line 392.
DBD::mysql::db selectall_arrayref failed: Unknown column 'serialnumber' in
'field list' at updatedb line 85.
DBD::mysql::db selectall_arrayref failed: Unknown column 'serialnumber' in
'field list' at updatedb line 85.
I?m a noob on MySQL, so I didn?t want to ?REPLACE? instead of ?INSERT? , or
try anything else. How can I resolve this problem?
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120814/b0d0f148/attachment-0001.html
------------------------------
Message: 3
Date: Tue, 14 Aug 2012 11:38:38 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Address Pools?
To: Jiann-Ming Su <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Jian-Ming,
Netdot currently does not implement DHCP pools as it should. It does
generate pool sections for failover configurations, but you cannot add
attributes to those.
There is an open ticket for this:
https://osl.uoregon.edu/redmine/issues/1639
We intend to address that in a future release.
cv
On 8/14/12 1:45 AM, Jiann-Ming Su wrote:
> Does Netdot support ISC DHCP address pools?
>
>>From the dhcpd.conf man page:
>
> subnet 10.0.0.0 netmask 255.255.255.0 {
> option routers 10.0.0.254;
>
> # Unknown clients get this pool.
> pool {
> option domain-name-servers bogus.example.com;
> max-lease-time 300;
> range 10.0.0.200 10.0.0.253;
> allow unknown-clients;
> }
>
> # Known clients get this pool.
> pool {
> option domain-name-servers ns1.example.com, ns2.example.com;
> max-lease-time 28800;
> range 10.0.0.5 10.0.0.199;
> deny unknown-clients;
> }
> }
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
cv
------------------------------
Message: 4
Date: Tue, 14 Aug 2012 11:39:44 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Upgrade to 1.1.1
To: Ramon Velazquez <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Hi Ramon,
Upgrading from 1.0.1-RC3 to 1.0.1 requires no schema changes, so you do
not need to issue the 'make upgrade' command. Only 'make install', then
restart Apache.
Now that Netdot stores the schema version in the database, we will be
able to avoid this situation in future upgrades.
Cheers,
cv
On 8/14/12 11:19 AM, Ramon Velazquez wrote:
>
>
> Hi Guys,
>
>
>
> First of all and like to say thank you for the incredible software. I
> have setup the VM Ubuntu 0.9.10, which has been upgraded to 1.0.1-RC3. I
> want to upgrade to the stable and latest release 1.0.1; however, when I
> do the ?make upgrade? command, it quits the process with the following
> complain:
>
>
>
> DEBUG: (SET AUTOCOMMIT = 0): rows affected: 0E0
>
> DEBUG: (INSERT INTO producttype (name) VALUES ('Module')): make[1]: ***
> [db] Error 255
>
> make[1]: Leaving directory `/usr/local/src/netdot-1.0.1/upgrade'
>
> make: *** [upgrade] Error 2
>
>
>
> I checked the upgrade error.log and has the following errors:
>
>
>
> DBD::mysql::db do failed: Table 'schemainfo' already exists at
> ../lib/DBUTIL.pm line 392.
>
> ERROR while executing CREATE TABLE `schemainfo` (
>
> `id` bigint NOT NULL auto_increment,
>
> `info` text,
>
> `version` varchar(255) NOT NULL,
>
> UNIQUE INDEX schemainfo1 (`version`),
>
> PRIMARY KEY (`id`)
>
> ) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'schemainfo'
> already exists at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Duplicate entry '1.0.1' for key 'schemainfo1'
> at ../lib/DBUTIL.pm line 392.
>
> ERROR while executing INSERT INTO schemainfo (version) VALUES('1.0.1'):
> DBD::mysql::db do failed: Duplicate entry '1.0.1' for key 'schemainfo1'
> at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Table 'asset' already exists at
> ../lib/DBUTIL.pm line 392.
>
> ERROR while executing CREATE TABLE `asset` (
>
> `custom_serial` varchar(255),
>
> `date_purchased` date,
>
> `description` varchar(255),
>
> `id` bigint NOT NULL auto_increment,
>
> `info` text,
>
> `inventory_number` varchar(255),
>
> `maint_contract` bigint,
>
> `maint_from` date,
>
> `maint_until` date,
>
> `physaddr` bigint,
>
> `po_number` varchar(255),
>
> `product_id` bigint NOT NULL,
>
> `reserved_for` varchar(255),
>
> `serial_number` varchar(255),
>
> UNIQUE INDEX asset1 (`physaddr`),
>
> UNIQUE INDEX asset2 (`product_id`, `serial_number`),
>
> INDEX Asset3 (`serial_number`),
>
> INDEX Asset4 (`inventory_number`),
>
> INDEX Asset5 (`po_number`),
>
> INDEX (`maint_contract`),
>
> PRIMARY KEY (`id`)
>
> ) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'asset'
> already exists at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Table 'audit' already exists at
> ../lib/DBUTIL.pm line 392.
>
> ERROR while executing CREATE TABLE `audit` (
>
> `fields` varchar(255),
>
> `id` bigint NOT NULL auto_increment,
>
> `label` varchar(255) NOT NULL,
>
> `object_id` bigint NOT NULL,
>
> `operation` varchar(255) NOT NULL,
>
> `tablename` varchar(255) NOT NULL,
>
> `tstamp` timestamp NOT NULL DEFAULT '1970-01-02 00:00:01',
>
> `username` varchar(255) NOT NULL,
>
> `vals` varchar(255),
>
> INDEX `Audit2` (`tstamp`),
>
> INDEX `Audit3` (`username`),
>
> INDEX `Audit4` (`tablename`),
>
> INDEX `Audit5` (`label`),
>
> PRIMARY KEY (`id`)
>
> ) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'audit'
> already exists at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Duplicate entry 'Module' for key
> 'producttype1' at ../lib/DBUTIL.pm line 392.
>
> ERROR while executing INSERT INTO producttype (name) VALUES ('Module'):
> DBD::mysql::db do failed: Duplicate entry 'Module' for key
> 'producttype1' at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db selectall_arrayref failed: Unknown column 'serialnumber'
> in 'field list' at updatedb line 85.
>
> DBD::mysql::db selectall_arrayref failed: Unknown column 'serialnumber'
> in 'field list' at updatedb line 85.
>
>
>
> I?m a noob on MySQL, so I didn?t want to ?REPLACE? instead of ?INSERT? ,
> or try anything else. How can I resolve this problem?
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
cv
------------------------------
Message: 5
Date: Tue, 14 Aug 2012 12:26:52 -0400
From: Ramon Velazquez <[email protected]>
Subject: Re: [Netdot-users] Upgrade to 1.1.1
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="windows-1252"
Carlos,
After upgrade, the site doesn't come up. Here is comes up:
*error:*
Unknown configuration item: SHOW_ROOT_BLOCKS at
/usr/local/netdot/htdocs/management/ip.html line 161
*context:*
*...*
*40:*
return $@ if $@;
*41:*
goto &shortmess_real;
*42:*
}
*43:*
*44:*
sub croak { die shortmess @_ }
*45:*
sub confess { die longmess @_ }
*46:*
sub carp { warn shortmess @_ }
*47:*
sub cluck { warn longmess @_ }
*48:*
*...*
*code stack:*
/usr/share/perl/5.10/Carp.pm:44
/usr/local/netdot/lib/Netdot/Config.pm:46
/usr/local/netdot/htdocs/management/ip.html:161
/usr/local/netdot/htdocs/management/index.html:11
/usr/local/netdot/htdocs/management/autohandler:81
/usr/share/perl5/HTML/Mason/Request.pm:948
/usr/local/netdot/htdocs/masondata/obj/1077268618/management/autohandler.obj:21
/usr/local/netdot/htdocs/autohandler:76
raw error <https://netdot.vitacost.com/netdot/management/?page=ADDRESS#raw>
Thankfully I had a system snapshot. I did the upgrade twice and I had same
results. Any insights into this?
Thanks for your help Gents,
Ramon
-----Original Message-----
From: Carlos Vicente [mailto:[email protected]]
Sent: Tuesday, August 14, 2012 11:40 AM
To: Ramon Velazquez
Cc: [email protected]
Subject: Re: [Netdot-users] Upgrade to 1.1.1
Hi Ramon,
Upgrading from 1.0.1-RC3 to 1.0.1 requires no schema changes, so you do not
need to issue the 'make upgrade' command. Only 'make install', then restart
Apache.
Now that Netdot stores the schema version in the database, we will be able
to avoid this situation in future upgrades.
Cheers,
cv
On 8/14/12 11:19 AM, Ramon Velazquez wrote:
>
>
> Hi Guys,
>
>
>
> First of all and like to say thank you for the incredible software. I
> have setup the VM Ubuntu 0.9.10, which has been upgraded to 1.0.1-RC3.
> I want to upgrade to the stable and latest release 1.0.1; however,
> when I do the ?make upgrade? command, it quits the process with the
> following
> complain:
>
>
>
> DEBUG: (SET AUTOCOMMIT = 0): rows affected: 0E0
>
> DEBUG: (INSERT INTO producttype (name) VALUES ('Module')): make[1]:
> *** [db] Error 255
>
> make[1]: Leaving directory `/usr/local/src/netdot-1.0.1/upgrade'
>
> make: *** [upgrade] Error 2
>
>
>
> I checked the upgrade error.log and has the following errors:
>
>
>
> DBD::mysql::db do failed: Table 'schemainfo' already exists at
> ../lib/DBUTIL.pm line 392.
>
> ERROR while executing CREATE TABLE `schemainfo` (
>
> `id` bigint NOT NULL auto_increment,
>
> `info` text,
>
> `version` varchar(255) NOT NULL,
>
> UNIQUE INDEX schemainfo1 (`version`),
>
> PRIMARY KEY (`id`)
>
> ) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'schemainfo'
> already exists at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Duplicate entry '1.0.1' for key 'schemainfo1'
> at ../lib/DBUTIL.pm line 392.
>
> ERROR while executing INSERT INTO schemainfo (version) VALUES('1.0.1'):
> DBD::mysql::db do failed: Duplicate entry '1.0.1' for key 'schemainfo1'
> at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Table 'asset' already exists at
> ../lib/DBUTIL.pm line 392.
>
> ERROR while executing CREATE TABLE `asset` (
>
> `custom_serial` varchar(255),
>
> `date_purchased` date,
>
> `description` varchar(255),
>
> `id` bigint NOT NULL auto_increment,
>
> `info` text,
>
> `inventory_number` varchar(255),
>
> `maint_contract` bigint,
>
> `maint_from` date,
>
> `maint_until` date,
>
> `physaddr` bigint,
>
> `po_number` varchar(255),
>
> `product_id` bigint NOT NULL,
>
> `reserved_for` varchar(255),
>
> `serial_number` varchar(255),
>
> UNIQUE INDEX asset1 (`physaddr`),
>
> UNIQUE INDEX asset2 (`product_id`, `serial_number`),
>
> INDEX Asset3 (`serial_number`),
>
> INDEX Asset4 (`inventory_number`),
>
> INDEX Asset5 (`po_number`),
>
> INDEX (`maint_contract`),
>
> PRIMARY KEY (`id`)
>
> ) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'asset'
> already exists at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Table 'audit' already exists at
> ../lib/DBUTIL.pm line 392.
>
> ERROR while executing CREATE TABLE `audit` (
>
> `fields` varchar(255),
>
> `id` bigint NOT NULL auto_increment,
>
> `label` varchar(255) NOT NULL,
>
> `object_id` bigint NOT NULL,
>
> `operation` varchar(255) NOT NULL,
>
> `tablename` varchar(255) NOT NULL,
>
> `tstamp` timestamp NOT NULL DEFAULT '1970-01-02 00:00:01',
>
> `username` varchar(255) NOT NULL,
>
> `vals` varchar(255),
>
> INDEX `Audit2` (`tstamp`),
>
> INDEX `Audit3` (`username`),
>
> INDEX `Audit4` (`tablename`),
>
> INDEX `Audit5` (`label`),
>
> PRIMARY KEY (`id`)
>
> ) ENGINE=InnoDB: DBD::mysql::db do failed: Table 'audit'
> already exists at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db do failed: Duplicate entry 'Module' for key
> 'producttype1' at ../lib/DBUTIL.pm line 392.
>
> ERROR while executing INSERT INTO producttype (name) VALUES ('Module'):
> DBD::mysql::db do failed: Duplicate entry 'Module' for key
> 'producttype1' at ../lib/DBUTIL.pm line 392.
>
>
>
> DBD::mysql::db selectall_arrayref failed: Unknown column 'serialnumber'
> in 'field list' at updatedb line 85.
>
> DBD::mysql::db selectall_arrayref failed: Unknown column 'serialnumber'
> in 'field list' at updatedb line 85.
>
>
>
> I?m a noob on MySQL, so I didn?t want to ?REPLACE? instead of ?INSERT?
> , or try anything else. How can I resolve this problem?
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
cv
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120814/45b5e1f0/attachment.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 45, Issue 10
********************************************
