Re: [snmpsim-users] snmpsim 0.2.4rc1 with mysql
Brought to you by:
elie
Menu
▾
▴
Re: [snmpsim-users] snmpsim 0.2.4rc1 with mysql
|
From: Bhagat, Y. (Yateen) <yat...@al...> - 2013-09-03 04:51:20
|
Hi Ilya,
Without doing commit on mysql side, I was still able to see the updated values using mysql command line client. The same was true when I used a remote mysql client.
-Yateen
-----Original Message-----
From: Ilya Etingof [mailto:il...@gl...]
Sent: Monday, September 02, 2013 12:17 AM
To: Bhagat, Yateen (Yateen)
Cc: snm...@li...
Subject: Re: snmpsim 0.2.4rc1 with mysql
Hi Yateen,
That's very curious. %-\
What is you do the same read query through mysql command-line tool? Will it also require a commit to get updated values? If not, it could be a MySQL/Connection module issue...
-ilya
On Aug 29, 2013, at 1:59 PM, Bhagat, Yateen (Yateen) wrote:
> Hi Ilya,
>
> I have found a solution to this issue.
>
> I made a small addition to the "sql.py" variation script as under :
> (added commit after cursor.fetch() )
>
> -----------
> -----------
> cursor.execute('select tag, value from %s where oid="%s"' % (dbTable, sqlOid))
> resultset = cursor.fetchone();dbConn.commit()
> cursor.close()
> -----------
> -----------
> It worked !!!! However I just wonder why a DB read operation needs a subsequent commit !
>
> -Yateen
> _____________________________________________
> From: Bhagat, Yateen (Yateen)
> Sent: Wednesday, August 28, 2013 1:03 PM
> To: 'Ilya Etingof'
> Cc: snm...@li...
> Subject: RE: snmpsim 0.2.4rc1 with mysql
>
>
> Hi Ilya,
>
> 1. I am running the simulator and MySql Server on WindowsXP with MySql Server version: 5.5.32 (MySQL Community Server GPL).
>
> 2. The db table schema is as under:
>
> mysql> describe maxnotifseqtable_87fa2144;
> +-----------+-------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +-----------+-------------+------+-----+---------+-------+
> | oid | text | YES | | NULL | |
> | tag | varchar(10) | YES | | NULL | |
> | value | varchar(30) | YES | | NULL | |
> | maxaccess | varchar(20) | YES | | NULL | |
> +-----------+-------------+------+-----+---------+-------+
> 4 rows in set (0.08 sec)
>
> The table contents are as under:
> ----------------------------------------------------------------------
> -------------------------------------------
> | 1. 3. 6. 1. 4. 1. 637. 74. 1. 2. 2. 1. 1. 2. 2. 4. 0 | 66 | 14 | read-write |
> ----------------------------------------------------------------------
> -------------------------------------------
> | 1. 3. 6. 1. 4. 1. 637. 74. 1. 2. 2. 1. 1. 2. 2. 5. 0 | 66 | 14 | read-write |
> ----------------------------------------------------------------------
> -------------------------------------------
>
>
> 3. No; I do not have duplicate entries for the OIDs in the table
>
> 4. I started the simulator in debug mode like this:
>
> D:\snmpsim-0.2.4rc1\scripts>snmpsimd.py --variation-modules-dir=D:\snmpsim-0.2.4
> rc1\variation --variation-module-options=sql:dbtype:mysql.connector,host:127.0.0
> .1,port:3306,user:snmpsim,password:snmpsim,database:snmpsim --agent-udpv4-endpoi
> nt=135.250.33.68 --v2c-arch --data-dir=\snmpsim-0.2.4rc1\1511
> --debug=dsp
>
> 5. Then I queried one of the OIDs in the table using snmpget from Manager.
> I got the oid value =13
> The output on simulator console was like this:
>
> Using \snmpsim-0.2.4rc1\1511\AdminAdmin123\1.3.6.1.6.1.1.0\135.250.18.151.snmpre
> c controller selected by candidate AdminAdmin123/1.3.6.1.6.1.1.0/135.250.18.151;
> transport ID 1.3.6.1.6.1.1.0, source address 135.250.18.151, community name "Ad
> minAdmin123"
>
> Opening \snmpsim-0.2.4rc1\1511\AdminAdmin123\1.3.6.1.6.1.1.0\135.250.18.151.snmp
> rec controller
>
> Request var-binds: 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.5.0=<>, flags: EXACT, GET
> Response var-binds: 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.5.0=<13>
>
> 6. Then I changed the OID value in the db table to '14' and queried the OID again using snmpget:
> The output is still shown as '13' instead of '14'
> The output on simulator console was like this:
>
> Using \snmpsim-0.2.4rc1\1511\AdminAdmin123\1.3.6.1.6.1.1.0\135.250.18.151.snmpre
> c controller selected by candidate AdminAdmin123/1.3.6.1.6.1.1.0/135.250.18.151;
> transport ID 1.3.6.1.6.1.1.0, source address 135.250.18.151, community name "Ad
> minAdmin123"
>
> Request var-binds: 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.5.0=<>, flags: EXACT, GET
> Response var-binds: 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.5.0=<13>
>
> Thanks
> Yateen
>
>
> -----Original Message-----
> From: Ilya Etingof [mailto:il...@gl...]
> Sent: Wednesday, August 28, 2013 3:45 AM
> To: Bhagat, Yateen (Yateen)
> Cc: snm...@li...
> Subject: Re: snmpsim 0.2.4rc1 with mysql
>
> Hi Yateen,
>
> No, that should not be a problem UNLESS you have duplicate (e.g. non
> unique) OIDs in the "oid" column. Could you check that?
>
> I've tried your setup at my Linux workstation and could not reproduce your issue -- simulator reported value does actually change! What OS you are using on your simulator and mysql hosts? What mysql version you are running?
>
> I don't see any caching in simulator code.
>
> If above does not help, could you add the
>
> --debug=dsp
>
> flag to snmpsimd.py command-line and send me console output for two queries before and after value change in the backend database?
>
> -ilya
>
> On 08/27/2013 03:49 PM, Bhagat, Yateen (Yateen) wrote:
> >
> > Hi Ilya
> >
> > I my mysql table, "oid" has not been defined as primary key, could
> > that be a problem?
> >
> > -Yateen
> >
> > *From:*Bhagat, Yateen (Yateen)
> > *Sent:* Tuesday, August 27, 2013 12:27 PM
> > *To:* 'Ilya Etingof'
> > *Cc:* snm...@li...
> > *Subject:* RE: snmpsim 0.2.4rc1 with mysql
> >
> > Hi Ilya,
> >
> > 1.I tried mysql commit, even then there is no success.
> >
> > 2.Format of the OID is correct (with padding spaces)
> >
> > 3.I tried querying the snmpsim with standard snmpget command, even
> > this does not show updated OID value, old initial value is shown.
> >
> > 4.After updating the OID value (by changing the referred mysql table
> > row) if I restart the snmpsim, then the updated value of the OID is
> > visible.
> >
> > My suspect is somewhere snmpsim is caching the mysql referred
> > values, and the cache is not updated.
> >
> > Please help !
> >
> > Regards
> >
> > Yateen
> >
> > *From:*Ilya Etingof [mailto:il...@gl...]
> > *Sent:* Monday, August 26, 2013 7:27 PM
> > *To:* Bhagat, Yateen (Yateen)
> > *Cc:* snm...@li...
> > <mailto:snm...@li...>
> > *Subject:* Re: snmpsim 0.2.4rc1 with mysql
> >
> > Hi Yateen,
> >
> > Neither snmpsim nor SQL module does any caching of the values read
> > from the database. So I suggest checking the following:
> >
> > 1. You do SQL commit upon value change (if applicable)
> >
> > 2. You read the same OID you modify. Note the format of the OID used
> > by snmpsim includes padding spaces.
> >
> > 3. Your snmp manager does not do any caching by its own means.
> >
> > Let me know in case of further problems.
> >
> > -ilya
> >
> >
> > On Aug 26, 2013, at 12:49, "Bhagat, Yateen (Yateen)"
> > <yat...@al...
> > <mailto:yat...@al...>> wrote:
> >
> > Hi Ilya,
> >
> > I have found an issue with 0.2.4rc1 (with mysql DB )
> >
> > My snmprec file has two oid's referring to two rows in one
> > single mysql table as given below:
> >
> > - - - - - - -
> >
> > - - - - - - -
> >
> > 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.2.0|66|10
> >
> > 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.3.0|2|1
> >
> >
> > *1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.4.0|:sql|maxNotifSeqTable_87fa2144
> > *
> >
> >
> > *1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.5.0|:sql|maxNotifSeqTable_87fa2144
> > *
> >
> > 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.6.0|66|2944
> >
> > 1.3.6.1.4.1.637.74.1.2.2.1.1.2.2.7.0|66|8017
> >
> > - - - - -
> >
> > - - - - - -
> >
> > The values for these two OIDs are being continuously changed every
> > 1 sec ; by some script that modifies the "value" column in the in
> > the mysql table.
> >
> > We have observed that when our snmp Manager queries these OID
> > using "snmpget", snmpsim always returns only the initial OID
> > values that were present in the DB table at the startup of
> > snmpsim. However, I could see the OID values getting changed in
> > the backend DB, when queried using sql command.
> >
> > Please help
> >
> > *From:*Bhagat, Yateen (Yateen)
> > *Sent:* Thursday, August 22, 2013 3:22 PM
> > *To:* 'Ilya Etingof'
> > *Cc:* Bhagat, Yateen (Yateen)
> > *Subject:* RE: snmpsim with mysql
> >
> > Hi Ilya
> >
> > This issue is resolved, I realized later that another snmp daemon
> > was already running on port 161.
> >
> > I have another issue, but before I report that just need quick info.
> >
> > I assume that in even in version 0.2.4rc1 (with mysql ) snmprec
> > file can be hybrid, meaning some OIDs being static and other
> > being referred from mysql tables.
> >
> > Thanks
> >
> > Yateen
> >
> > *From:*Bhagat, Yateen (Yateen)
> > *Sent:* Tuesday, August 20, 2013 5:05 PM
> > *To:* 'Ilya Etingof'
> > *Subject:* snmpsim with mysql
> >
> > Hi Ilya
> >
> > I am trying to use snmpsim-0.2.4rc1 with mysql variation module,
> >
> > Getting following error:
> >
> > D:\snmpsim-0.2.4rc1\scripts>snmpsimd.py
> > --variation-module-options=sql:dbtype:my
> >
> >
> > sql.connector,host:127.0.0.1,port:3306,user:snmpsim,password:snmpsim
> > ,d
> > atabase:sn
> >
> > mpsim --agent-udpv4-endpoint=135.250.33.68 --v2c-arch
> >
> > ERROR: bind() failed: [Errno 10048] Only one usage of each socket
> > address (protocol/network address/port) is normally permitted
> >
> > Please help !
> >
> > Thanks
> >
> > Yateen ,
> >
|
