Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-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 netdisco-users digest..."
Today's Topics:
1. Cisco 3750 versus 3750X (Peter Grasso)
2. Re: Cisco 3750 versus 3750X ([email protected])
3. Re: Cisco 3750 versus 3750X (Joseph Bernard)
4. mac/ip addresses device found, but port/vlan info empty
(Natxo Asenjo)
5. DB Schema Upgrade Error on NetDisco (Steven Xu)
6. Re: DB Schema Upgrade Error on NetDisco (Steven Xu)
--- Begin Message ---
Hi all,
Is there any way for me to differentiate between Cisco 3750 and 3750X switches
in Netdisco 2 ? (I am running on version 2.029014) We are retiring the older
3750 switches, so it would be nice if I could differentiate between the models
on the inventory page.
Both simply show up as 37xx stack (just like 29xx stack for 2960's or 38xx
stack for 3850's) Regards,Pete
--- End Message ---
--- Begin Message ---
Hi,
> Is there any way for me to differentiate between Cisco 3750 and 3750X
> switches in Netdisco 2 ? (I am running on version 2.029014) We are
> retiring the older 3750 switches, so it would be nice if I could
> differentiate between the models on the inventory page.
> Both simply show up as 37xx stack (just like 29xx stack for 2960's or 38xx
> stack for 3850's)
yes, but not 'obvious' (unless you use a naming convention or the SNMP
field...) - the DB does have information - in the Description field...the old
switches are just C3750, the 3750X have C3750E IIRC - so just look for that
in the Device Search Options 'Description' field
alan
--- End Message ---
--- Begin Message ---
I go to Reports -> Device -> Module Inventory
You can put 3750 in the Module Model field and get a listing of all the 3750’s.
Just remember that the Name isn’t how many but the position in the stack.
Thanks,
Joseph B.
On May 19, 2015, at 5:06 PM, Peter Grasso
<[email protected]<mailto:[email protected]>> wrote:
Hi all,
Is there any way for me to differentiate between Cisco 3750 and 3750X switches
in Netdisco 2 ? (I am running on version 2.029014) We are retiring the older
3750 switches, so it would be nice if I could differentiate between the models
on the inventory page.
Both simply show up as 37xx stack (just like 29xx stack for 2960's or 38xx
stack for 3850's)
Regards,
Pete
--- End Message ---
--- Begin Message ---
hi,
using 2.032003. When I lookup mac adresses sometimes it does not find in
what switch the device is found. It does find the mac address/ip address of
the device.
How can I troubleshoot this?
Thanks!
--
Groeten,
natxo
--- End Message ---
--- Begin Message ---
Hi all,
I would like to find the sql statements used to upgrade the netdisco schema.
I'm trying to upgrade a very old netdisco server to the latest version (< version 1). When I run netdisco-deploy, the database upgrade performed in netdisco-db-deploy gives the errors below.
DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version (4) is lower t han the schema version (40). Attempting upgrade.
Error: DBIx::Class::Schema::Versioned::apply_statement(): DBI Exception: DBD::Pg ::db do failed: ERROR: syntax error at end of input
LINE 1: ...stamp default now(), time_last timestamp default now())
^ at /hom e/netdisco/perl5/bin/netdisco-db-deploy line 130
DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version (5) is lower t han the schema version (40). Attempting upgrade.
Error: DBIx::Class::Schema::Versioned::apply_statement(): DBI Exception: DBD::Pg ::db do failed: ERROR: syntax error at end of input
LINE 1: ...t integer, creation TIMESTAMP DEFAULT now() )
^ at /hom e/netdisco/perl5/bin/netdisco-db-deploy line 130
Inspecting netdisco-db-deploy, there is a function upgrade_single_step called on $schema. The documentation says "It requires an SQL diff file to exist in your
upgrade_directory, normally you will have created this using
"create_ddl_dir" in DBIx::Class::Schema."
Where does the netdisco installation put these? I would like to know so I could work on fixing the errors in the upgrade.
Steven
--- End Message ---
--- Begin Message ---
My message wasn't posted to the mailing list until a day later. Since then, I found the schema update sql files in
~/perl5/lib/perl5/App/Netdisco/DB/schema_versions/ The reason for the errors was that DBD::Pg::db did not know how to execute multi-line CREATE TABLE statements with comments on a column like so
. psql accepts them without problems.
CREATE TABLE device_port_ssid (
ip inet,
-- ip of device
....
)
I worked around this problem by removing all the comments for
App-Netdisco-DB-4-5-PostgreSQL.sql and pp-Netdisco-DB-5-6-PostgreSQL.sql
with sed:
sed -i 's/\-\-.*$//' file
Should I open a bug report against DBD::Pg::db or Netdisco?
Steven
-----Steven Xu <[email protected]> wrote: -----
To:
[email protected]From: Steven Xu <
[email protected]>
Date: 05/29/2015 08:28AM
Subject: [Netdisco] DB Schema Upgrade Error on NetDisco
Hi all,
I would like to find the sql statements used to upgrade the netdisco schema.
I'm trying to upgrade a very old netdisco server to the latest version (< version 1). When I run netdisco-deploy, the database upgrade performed in netdisco-db-deploy gives the errors below.
DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version (4) is lower t han the schema version (40). Attempting upgrade.
Error: DBIx::Class::Schema::Versioned::apply_statement(): DBI Exception: DBD::Pg ::db do failed: ERROR: syntax error at end of input
LINE 1: ...stamp default now(), time_last timestamp default now())
^ at /hom e/netdisco/perl5/bin/netdisco-db-deploy line 130
DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version (5) is lower t han the schema version (40). Attempting upgrade.
Error: DBIx::Class::Schema::Versioned::apply_statement(): DBI Exception: DBD::Pg ::db do failed: ERROR: syntax error at end of input
LINE 1: ...t integer, creation TIMESTAMP DEFAULT now() )
^ at /hom e/netdisco/perl5/bin/netdisco-db-deploy line 130
Inspecting netdisco-db-deploy, there is a function upgrade_single_step called on $schema. The documentation says "It requires an SQL diff file to exist in your
upgrade_directory, normally you will have created this using
"create_ddl_dir" in DBIx::Class::Schema."
Where does the netdisco installation put these? I would like to know so I could work on fixing the errors in the upgrade.
Steven
------------------------------------------------------------------------------
--- End Message ---
------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
