cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
811
Views
0
Helpful
2
Replies

UT doesnt show username

Jacob Gwangwa
Level 1
Level 1

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.

2 Replies 2

Michel Hegeraat
Level 7
Level 7

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

Hi Michel

Yes i do have Hostnames, Mac, IPs, Switchnames in the reports.

Thanks for your response

Regards,

Jacob

Review Cisco Networking for a $25 gift card