Hi,
I've recently got the Wireless module running on our installation of ONP 8.1.3. there seems to be a problem inserting wireless sessions (between station and access point) into the database. Event log errors appear every minute or so, I can see its reading some of the information, alot is missing as you can see:
Error Updating Updating an objects Status. Detail-Syntax error converting from a character string to uniqueidentifier. Update Command-UPDATE WirelessSessions SET SSID = '', IPAddress = '10.200.136.86', ReverseDNS = '10.200.136.86', LastUpdate = GETDATE(), ClientUpTime = 16401704, ClientRole = 'sta', ClientDeviceType = '0', ClientRadioType = '0', WEPEnabled = 0, DataRates = '0', SoftwareVersion = '0', ClientName = '', AssociatedState = '0', PowerSaveMode = 0, TxRate = '0', SignalStrength = 0, SignalQuality = 27, TotalPacketsRx = 60836, TotalPacketsTx = 59455, TotalBytesRx = 19400148, TotalBytesTx = 19671244, CurrentRxBPS = 1103.89473521927, CurrentTxBPS = 1093.23938063221 Where (NodeID = 578) AND (InterfaceID = 735) AND (ClientMACAddress = '') AND (SessionID = '')
I ran this query through the SQL syntax checker on our server, the only thing it throws up is a problem with the SessionID.
I get "Syntax error converting from a character string to uniqueidentifier". The column type for WirelessSessions.SessionID is uniqueidentifier and the default value is newID() - this function will create a new globally unique ID from the MAC and System time of the SQL server in the abscense of a value.
In this case ' ' is provided which is an character empty character string - in keeping with the error above.
The question is then when a session is started why isnt it being inserted into the sessions table and a unique ID returned for later inserts like the one above?
Access points are:
Proxim AP4000, v3.1.0 using SNMPv 2c they appear as "Agere Systems Inc" "Sys ObjectID 1.3.6.1.4.1.11898.2.4.12"
Can anyone assist in troubleshooting the wireless client history?
Many thanks
Craig
