Welcome, Guest. Please login or register.

Author Topic: DBD::mysql::db do failed: Unknown column '<SSID NAME>' in 'field list'  (Read 2845 times)

rick.crutzen

  • Guest
Hi All,

I just installed version 1.4, awesome software!!
But when i try to discover my cisco 1142 fat accesspoint i get errors.
When i do a debug i get the following:
Code: [Select]
CAPFwd ------------------------------------------------------------------------
SNMP:Connect 10.11.12.13 Private v2 Tout:2s MaxMS:1472 Retry:1 NB:0
CAPF:112233445566 on Do0 (1) SNR:33 SSID:ssid1
CAPF:aabbccddeeff on Do0 (1) SNR:32 SSID:ssid2
CAPF:11aa2bb33cc on Do0 (1) SNR:20 SSID:ssid2

Write Nodes ------------------------------------------------------------------
DBG :SELECT * FROM nodes WHERE mac='112233445566'
 $VAR1 = {
          '5435304de65b' => {
                              'noduser' => '',
                              'ifchanges' => '1',
                              'vlanid' => '31',
                              'ifname' => 'Do0',
                              'ifupdate' => '1424986201',
                              'metric' => 'SCCCC',
                              'firstseen' => '1424986201',
                              'device' => 'ricks_ap',
                              'oui' => 'Hon Hai Precision Ind. Co.,Ltd.',
                              'nodesc' => '',
                              'lastseen' => '1424989539',
                              'mac' => '112233445566'
                            }
        };

DBG :UPDATE nodes SET vlanid=ssid1,lastseen=1424990515,metric='RSCCCC',noduser='' WHERE mac='112233445566'
DBD::mysql::db do failed: Unknown column 'ssid1' in 'field list' at ./inc/libdb.pm line 1903.
DBD::mysql::db do failed: Unknown column 'ssid1' in 'field list' at ./inc/libdb.pm line 1903.
It seems that the update wants to set the ssid name (from CAPFwd ??) in the vlanid column from table nodes but the name isn't known (and the column for vlan is tinyint).
In older versions the ssid showed up as : SSID:2
my perl isn't just that, so, please help? 

Thanks in advance

migas62

  • Newbie
  • *
  • Posts: 11
    • View Profile
Hi All,

I just installed version 1.4, awesome software!!
But when i try to discover my cisco 1142 fat accesspoint i get errors.
When i do a debug i get the following:
Code: [Select]
CAPFwd ------------------------------------------------------------------------
SNMP:Connect 10.11.12.13 Private v2 Tout:2s MaxMS:1472 Retry:1 NB:0
CAPF:112233445566 on Do0 (1) SNR:33 SSID:ssid1
CAPF:aabbccddeeff on Do0 (1) SNR:32 SSID:ssid2
CAPF:11aa2bb33cc on Do0 (1) SNR:20 SSID:ssid2

Write Nodes ------------------------------------------------------------------
DBG :SELECT * FROM nodes WHERE mac='112233445566'
 $VAR1 = {
          '5435304de65b' => {
                              'noduser' => '',
                              'ifchanges' => '1',
                              'vlanid' => '31',
                              'ifname' => 'Do0',
                              'ifupdate' => '1424986201',
                              'metric' => 'SCCCC',
                              'firstseen' => '1424986201',
                              'device' => 'ricks_ap',
                              'oui' => 'Hon Hai Precision Ind. Co.,Ltd.',
                              'nodesc' => '',
                              'lastseen' => '1424989539',
                              'mac' => '112233445566'
                            }
        };

DBG :UPDATE nodes SET vlanid=ssid1,lastseen=1424990515,metric='RSCCCC',noduser='' WHERE mac='112233445566'
DBD::mysql::db do failed: Unknown column 'ssid1' in 'field list' at ./inc/libdb.pm line 1903.
DBD::mysql::db do failed: Unknown column 'ssid1' in 'field list' at ./inc/libdb.pm line 1903.
It seems that the update wants to set the ssid name (from CAPFwd ??) in the vlanid column from table nodes but the name isn't known (and the column for vlan is tinyint).
In older versions the ssid showed up as : SSID:2
my perl isn't just that, so, please help? 

Thanks in advance
I'm having the same problem with my Cisco Bridges

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2691
    • View Profile
    • NeDi
This has been fixed with patch3...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo