09-08-2011 08:00 AM
I Have installed LMS 4.0.1 for my client. I have also installed UTLite script on the domain controller as per instruction from cisco. When i look at the utlite.log i'm seeing message displayed below:
Failed to create Tables. Transaction Rolled back
Failed to create Tables. Transaction Rolled back
: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -110: Item 'getAuthenticatedUsers_ACS' already exists
Intializing the Controler 9 = skt Pkg = com.cisco.nm.cm.ut.ctrlplane.ctrls.SocketCtrl
2011/08/25 14:59:14 main utlite INFO SocketListener: Socket Listener : Port : 16236
Started Socket Listener
2011/08/25 14:59:29 Thread-9 utlite DEBUG SocketListener: Packets received: 1
2011/08/25 14:59:30 Thread-4 utlite DEBUG UtliteDBConnectionThread: LogIn event is received for (DBID: 7240480263503872, MAC: 00:19:B9:2D:AE:1C, IP: 10.51.116.28, Username: jaky@bank.co.za ) 2011/08/25 14:59:30 Thread-4 utlite DEBUG UtliteDBConnectionThread: Login event was updated to DB [MAC:00:19:B9:2D:AE:1C,Num of rows affected:1] hence cache entry preserved to prevent flooding, the dbid is corrected to 7240480263503872
2011/08/25 14:59:41 Thread-9 utlite DEBUG SocketListener: Packets received: 2
2011/08/25 14:59:42 Thread-4 utlite DEBUG UtliteDBConnectionThread: LogIn event is received for (DBID: 22613105903730688, MAC: 00:50:56:80:00:A9, IP: 10.51.18.98, Username: percy@wesbank.co.za)
2011/08/25 14:59:42 Thread-4 utlite DEBUG UtliteDBConnectionThread: Login event was NOT updated to DB [MAC:00:50:56:80:00:A9] hence remove this entry from cache
2011/08/25 15:00:06 Thread-9 utlite DEBUG SocketListener: Packets received: 3
Any help to resolve this would be appreciated. My client would love to see as to who logged in/out of the network and time.
09-09-2011 01:02 PM
Its been ages (LMS2.5) since I used this, but I recall the the usernames are cherry on the pie. This is done in the last phase.
Do you alrady have mac ip hostname swtichname in the reports?
Cheers,
Michel
09-10-2011 03:37 AM
Hi Michel
Yes i do have Hostnames, Mac, IPs, Switchnames in the reports.
Thanks for your response
Regards,
Jacob
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: