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. (no subject) (????? ?)
2. Re: Unable to delete records (YUUNI, OSAY OSMAN)
3. Cisco Wireless Controller Issue (YUUNI, OSAY OSMAN)
----------------------------------------------------------------------
Message: 1
Date: Mon, 15 Jul 2013 22:12:02 +0300
From: ????? ? <[email protected]>
Subject: [Netdot-users] (no subject)
To: "[email protected]" <[email protected]>
Message-ID:
<canifkqs1zc9sydpztqv5enzy3+e4trwv8uwjn0sbyb8vh33...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20130715/cab84b50/attachment-0001.html
------------------------------
Message: 2
Date: Tue, 16 Jul 2013 06:02:35 +0000
From: "YUUNI, OSAY OSMAN" <[email protected]>
Subject: Re: [Netdot-users] Unable to delete records
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="us-ascii"
Thanks Carlos. I wonder why it affects some people and not others. What
version of SQL::Translator will be the correct one? I have manually created
the table as you suggested and everything works fine now.
Thanks once again.
Osay
-----Original Message-----
From: Carlos Vicente [mailto:[email protected]]
Sent: 15 July 2013 07:13 PM
To: YUUNI, OSAY OSMAN
Cc: [email protected]
Subject: Re: [Netdot-users] Unable to delete records
Hi Yuuni,
There was a bug in 1.0.4. It happened to some people and not others (depending
on their version of SQL::Translator).
You can create the table manually by pasting the following into your mysql
client:
CREATE TABLE `rrloc` (
`altitude` bigint NOT NULL,
`horiz_pre` varchar(32) NULL,
`id` bigint NOT NULL auto_increment,
`latitude` bigint NOT NULL,
`longitude` bigint NOT NULL,
`rr` bigint NOT NULL,
`size` varchar(32) NULL,
`ttl` varchar(32) NULL,
`vert_pre` varchar(32) NULL,
UNIQUE INDEX `rrloc1` (`rr`),
PRIMARY KEY (`id`),
CONSTRAINT `fk_rr_4` FOREIGN KEY (`rr`) REFERENCES `rr` (`id`)
) ENGINE=InnoDB;
cv
On 7/15/13 11:01 AM, YUUNI, OSAY OSMAN wrote:
>
> Hi everyone,
>
> When I try to delete a record I get the following error. I'm not sure
> what the issue is. I've checked the netdot database and it does not
> contain any table called rrloc. Can anyone help?
>
> ==
>
> Transaction aborted: Netdot::Model::RRLOC can't SELECT id, longitude,
> latitude, rr, altitude
>
> FROM rrloc
>
> WHERE rr = ?
>
> : DBD::mysql::st execute failed: Table 'netdot.rrloc' doesn't exist
> [for Statement "SELECT id, longitude, latitude, rr, altitude
>
> FROM rrloc
>
> WHERE rr = ?
>
> " with ParamValues: 0='385'] at
> /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52, line 4.
>
> Stack:
>
> [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]
>
> [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]
>
> [/usr/local/share/perl5/Class/DBI.pm:1139]
>
> [/usr/local/share/perl5/Class/DBI/Search/Basic.pm:169]
>
> [/usr/local/share/perl5/Class/DBI.pm:1094]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/None.pm:68]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/Delete.pm:21]
>
> [/usr/local/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
>
> [/usr/local/share/perl5/Class/Trigger.pm:74]
>
> [/usr/local/share/perl5/Class/DBI.pm:735]
>
> [/usr/local/netdot/lib/Netdot/Model.pm:876]
>
> [/usr/local/netdot/lib/Netdot/Model/RR.pm:373]
>
> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2379]
>
> [/usr/local/netdot/htdocs/generic/delete.html:161]
>
> [/usr/local/netdot/htdocs/generic/delete.html:163]
>
> [/usr/local/netdot/htdocs/autohandler:110]
>
> [/usr/local/netdot/htdocs/management/dhandler:1]
>
> [/usr/local/netdot/htdocs/management/autohandler:81]
>
> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/991088776/management/autohandl
> er.obj:21]
>
> [/usr/local/netdot/htdocs/autohandler:76]
>
> at /usr/local/share/perl5/Class/DBI/Search/Basic.pm line 169.
>
> Stack:
>
> [/usr/local/share/perl5/Carp.pm:100]
>
> [/usr/local/share/perl5/Class/DBI.pm:169]
>
> [/usr/local/share/perl5/Class/DBI.pm:1143]
>
> [/usr/local/share/perl5/Class/DBI/Search/Basic.pm:169]
>
> [/usr/local/share/perl5/Class/DBI.pm:1094]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/None.pm:68]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/Delete.pm:21]
>
> [/usr/local/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
>
> [/usr/local/share/perl5/Class/Trigger.pm:74]
>
> [/usr/local/share/perl5/Class/DBI.pm:735]
>
> [/usr/local/netdot/lib/Netdot/Model.pm:876]
>
> [/usr/local/netdot/lib/Netdot/Model/RR.pm:373]
>
> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2379]
>
> [/usr/local/netdot/htdocs/generic/delete.html:161]
>
> [/usr/local/netdot/htdocs/generic/delete.html:163]
>
> [/usr/local/netdot/htdocs/autohandler:110]
>
> [/usr/local/netdot/htdocs/management/dhandler:1]
>
> [/usr/local/netdot/htdocs/management/autohandler:81]
>
> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/991088776/management/autohandl
> er.obj:21]
>
> [/usr/local/netdot/htdocs/autohandler:76]
>
> <http://www.afdb.org/>Osay Osman YUUNI**| Lead IT Infrastructure
> Specialist/Regional ICT Coordinator
>
> *African Development Bank Group | Southern Africa Resource Center
> *Office: +27 12 003 6900 | Ext:8402|+216 7110 2111| E-Mail:
> [email protected] <mailto:[email protected]>_
>
> Mobile: +27 78 090 5501 | Web: http://www.afdb.org
> <http://www.afdb.org/>
>
> Please consider the environment before printing this email...
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 3
Date: Tue, 16 Jul 2013 09:39:17 +0000
From: "YUUNI, OSAY OSMAN" <[email protected]>
Subject: [Netdot-users] Cisco Wireless Controller Issue
To: "[email protected]" <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="us-ascii"
Hi all,
Strange thing happening here. I'm trying to discover our wireless network via
the controller and am getting nothing. When I insert the IP of the controller
(management IP) and the community string it returns an error but creates the
controller with not assets and no IP address. I have deleted the entry several
times and tried with different community strings to no avail. This is a cisco
wireless controller 5508. On the management tab on the controller I have
created a community string and also a trap destination for it. On general tab
it shows system object ID to be 1.3.6.1.4.1.9.1.1069 but when I use snmpwalk or
snmpget it returns SNMPv2-SMI::enterprises.9.1.1069 = No Such Object available
on this agent at this OID.
The logs on NetDot show the following:
======
Jul 16 08:22:04 netmon netdot: INFO - Device::_get_snmp_session:
sarc-a-wctrl01.afdb.local: Failed connection attempts: 1
Jul 16 08:22:04 netmon netdot: ERROR - Device::_get_snmp_session: Cannot
connect to sarc-a-wctrl01.afdb.local. Tried communities: AFDB
Jul 16 09:11:13 netmon netdot: ERROR - Netdot::Util::DNS::resolve_ip: Can't
resolve 10.29.133.10
Jul 16 09:11:13 netmon netdot: ERROR - RR::Insert: sarc-a-wctrl01.afdb.local
already exists!
Jul 16 09:11:50 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: update, table: device, id: 16 (sarc-a-wctrl01.afdb.local), fields:
(last_updated,snmp_conn_attempts), values: ('
2013/07/16 09:11:50','2')
Jul 16 09:11:50 netmon netdot: INFO - Device::_get_snmp_session:
sarc-a-wctrl01.afdb.local: Failed connection attempts: 2
Jul 16 09:11:50 netmon netdot: ERROR - Device::_get_snmp_session: Cannot
connect to sarc-a-wctrl01.afdb.local. Tried communities: AFDB
Jul 16 09:12:13 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: delete, table: device, id: 16 (sarc-a-wctrl01.afdb.local)
Jul 16 09:12:13 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: delete, table: devicecontacts, id: 16 (Network Services Contacts)
Jul 16 09:12:13 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: delete, table: rr, id: 387 (sarc-a-wctrl01.afdb.local)
Jul 16 09:12:35 netmon netdot: ERROR - Netdot::Util::DNS::resolve_ip: Can't
resolve 10.29.133.10
Jul 16 09:12:35 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: insert, table: rr, id: 388 (sarc-a-wctrl01.afdb.local), fields:
(auto_update,zone,active,name,modified,created,i
d), values: ('0','afdb.local','1','sarc-a-wctrl01','2013-07-16
09:12:35','2013-07-16 09:12:35','388')
Jul 16 09:12:35 netmon netdot: INFO - Inserted new RR: sarc-a-wctrl01.afdb.local
Jul 16 09:12:35 netmon netdot: INFO - Inserting new Device: 10.29.133.10
Jul 16 09:12:35 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: insert, table: device, id: 17 (sarc-a-wctrl01.afdb.local), fields:
(monitor_config,monitored,snmp_bulk,community
,snmp_down,id,auto_dns,canautoupdate,last_updated,date_installed,stp_enabled,name,collect_fwt,collect_stp,used_by,ipforwarding,customer_managed,snmp_polling,last_arp,owner,collect_arp,snmp_version,
snmp_managed,s), values: ('0','0','1','private','0','17','1','1','1970-01-02
00:00:01','2013-07-16
09:12:35','0','sarc-a-wctrl01.afdb.local','1','1','AfDB-Southern African
Resource Center','0','0',
'1','1970-01-02 00:00:01','Network Services','0','2','1','Southern Regional
Resource)
Jul 16 09:12:35 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: insert, table: devicecontacts, id: 17 (Network Services Contacts),
fields: (contactlist,id,device), values: ('Ne
twork Services Contacts','17','sarc-a-wctrl01.afdb.local')
Jul 16 09:12:36 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: update, table: device, id: 17 (sarc-a-wctrl01.afdb.local), fields:
(last_updated,snmp_conn_attempts), values: ('
2013/07/16 09:12:36','1')
Jul 16 09:12:36 netmon netdot: INFO - Device::_get_snmp_session:
sarc-a-wctrl01.afdb.local: Failed connection attempts: 1
Jul 16 09:12:36 netmon netdot: ERROR - Device::_get_snmp_session: Cannot
connect to sarc-a-wctrl01.afdb.local. Tried communities: private
Jul 16 09:13:37 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: update, table: device, id: 17 (sarc-a-wctrl01.afdb.local), fields:
(monitoring_path_cost,customer_managed,last_u
pdated,monitored,monitor_config), values: ('0','1','2013/07/16
09:13:37','1','1')
Jul 16 09:13:44 netmon netdot: INFO - Netdot::Model::_audit: user: admin,
operation: update, table: device, id: 17 (sarc-a-wctrl01.afdb.local), fields:
(last_updated,snmp_conn_attempts), values: ('
2013/07/16 09:13:44','2')
=====
I'd be grateful if someone can check and see if something is sticking out. I'm
not sure if the DNS resolution is the cause of this. I'll fix the DNS issue
but will be happy of someone can spot something that's whacky in this whole
saga.
Kind regards,
Osay
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20130716/3fcf2ca7/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 56, Issue 11
********************************************
