Too Many Users Auto-Added

Too Many Users Auto-Added (Full Version)

All Forums >> [Web & Mail Security] >> GFI MailSecurity

Message

bmcclurg2 -> Too Many Users Auto-Added (26.May2009 11:46:46 AM)
Hello- I'm having a problem with false users being auto-added to the user list thereby causing a 'License expired- too many users' message. This is happening to both Mail Security and Mail Essentials. The added names are nonsense 'names', and this problem just started recently. So every day I have to go through the user list and delete all the fake users, and it's getting old. Any idea what's causing this or how to troubleshoot it? Thanks.

benvincenti -> RE: Too Many Users Auto-Added (28.May2009 8:20:27 AM)
bmcclurg2, Kindly go to the GFI\MailEssentials\DebugLogs directory and paste an extract of the usercntado.txt which shows which users are being retrieved and counted. Regards, Ben Vincenti GFI Software - www.gfi.com Web & Mail Security, Archiving & Fax, Networking & Security Tel: +44 (0) 1784 448 838

bmcclurg2 -> RE: Too Many Users Auto-Added (28.May2009 5:49:23 PM)
Okay, here are a few extracts from usrlkado.txt: Known good user (me): 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","CGFIUserDB::FindUsers(4, bmcclurg@calvaryphx.com, 0x134F114)" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","CGFIUserDB::CreateSearchString(4, bmcclurg@calvaryphx.com)" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","Search String: SELECT ID FROM UserTable WHERE mail ='bmcclurg@calvaryphx.com'" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","CGFIUserDB::CreateSearchString returned: SELECT ID FROM UserTable WHERE mail ='bmcclurg@calvaryphx.com'" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","RecordSet Opened" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","We have results" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","enumeration Initialized" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","CEnumUO: movefirst" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","CEnumUO: sID: fe66bafa-c9bb-46ba-acce-8967a18c0fe4" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","SetupUser: ID: fe66bafa-c9bb-46ba-acce-8967a18c0fe4" 2009-05-27,19:20:22,540,3,"#00000564","#00000e0c","info ","USRLKADO","CGFIUserDB::FindUser OK" These are not users, but still end up in user list: 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","CGFIUserDB::FindUsers(4, babiryeaudley@calvaryphx.com, 0xFBAF110)" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","CGFIUserDB::CreateSearchString(4, babiryeaudley@calvaryphx.com)" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","Search String: SELECT ID FROM UserTable WHERE mail ='babiryeaudley@calvaryphx.com'" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","CGFIUserDB::CreateSearchString returned: SELECT ID FROM UserTable WHERE mail ='babiryeaudley@calvaryphx.com'" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","RecordSet Opened" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","No users found!" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","enumeration Initialized" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","CEnumUO: movefirst" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","CEnumUO: EOF (0x800A0BCD)" 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","Failed to get ID of user." 2009-05-28,11:07:40,888,3,"#00000564","#00000358","info ","USRLKADO","CGFIUserDB::FindUser OK" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","CGFIUserDB::FindUsers(4, adhiamboarthur@calvaryphx.com, 0xAE5F114)" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","CGFIUserDB::CreateSearchString(4, adhiamboarthur@calvaryphx.com)" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","Search String: SELECT ID FROM UserTable WHERE mail ='adhiamboarthur@calvaryphx.com'" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","CGFIUserDB::CreateSearchString returned: SELECT ID FROM UserTable WHERE mail ='adhiamboarthur@calvaryphx.com'" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","RecordSet Opened" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","No users found!" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","enumeration Initialized" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","CEnumUO: movefirst" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","CEnumUO: EOF (0x800A0BCD)" 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","Failed to get ID of user." 2009-05-27,00:08:27,233,3,"#00000564","#0000010c","info ","USRLKADO","CGFIUserDB::FindUser OK" And these are from usercntado.txt: 2009-05-27,22:22:39,714,3,"#000004d4","#000004f4","info ","USERCNTADO","Instructed to count" 2009-05-27,22:22:39,714,3,"#000004d4","#000004f4","info ","USERCNTADO","Connect string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GFI\MailEssentials\userlist.mdb" 2009-05-27,22:22:39,714,3,"#000004d4","#000004f4","info ","USERCNTADO","Counted 87 users in ADO database" 2009-05-27,22:45:39,721,3,"#000004d4","#000004f4","info ","USERCNTADO","Instructed to count" 2009-05-27,22:45:39,721,3,"#000004d4","#000004f4","info ","USERCNTADO","Connect string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GFI\MailEssentials\userlist.mdb" 2009-05-27,22:45:39,721,3,"#000004d4","#000004f4","info ","USERCNTADO","Counted 87 users in ADO database" 2009-05-27,23:08:39,712,3,"#000004d4","#000004f4","info ","USERCNTADO","Instructed to count" 2009-05-27,23:08:39,712,3,"#000004d4","#000004f4","info ","USERCNTADO","Connect string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GFI\MailEssentials\userlist.mdb" 2009-05-27,23:08:39,712,3,"#000004d4","#000004f4","info ","USERCNTADO","Counted 87 users in ADO database" 2009-05-27,23:31:39,709,3,"#000004d4","#000004f4","info ","USERCNTADO","Instructed to count" 2009-05-27,23:31:39,709,3,"#000004d4","#000004f4","info ","USERCNTADO","Connect string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GFI\MailEssentials\userlist.mdb" 2009-05-27,23:31:39,709,3,"#000004d4","#000004f4","info ","USERCNTADO","Counted 88 users in ADO database" 2009-05-27,23:54:39,701,3,"#000004d4","#000004f4","info ","USERCNTADO","Instructed to count" 2009-05-27,23:54:39,701,3,"#000004d4","#000004f4","info ","USERCNTADO","Connect string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GFI\MailEssentials\userlist.mdb" 2009-05-27,23:54:39,701,3,"#000004d4","#000004f4","info ","USERCNTADO","Counted 88 users in ADO database" 2009-05-28,00:17:39,692,3,"#000004d4","#000004f4","info ","USERCNTADO","Instructed to count"

benvincenti -> RE: Too Many Users Auto-Added (29.May2009 4:17:50 AM)
bmcclurg2, Kindly compact and repair your userlist.mdb database and restart the IIS Admin and GFI MailEssentials services and see if the problem persists. Regards, Ben Vincenti GFI Software - www.gfi.com Web & Mail Security, Archiving & Fax, Networking & Security Tel: +44 (0) 1784 448 838

bmcclurg2 -> RE: Too Many Users Auto-Added (1.Jun.2009 12:46:50 PM)
After compacting and repairing userlist.mdb for both ME and MS this past Saturday, the file sizes went way down. However, there are new 'fake' users Monday morning. What I don't understand is why some users that come back as 'unknown' (as shown in the above USRLKADO posting) are still being added to the userlists.

Page: [1]