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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide