Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by XpKiller*:

 

Yea we running AdKats too.

 

But with the version 1.0.0.0 it runns without errors.

 

Greetings

 

reutnitzer

Thats strange because nothing adkats relevant had been change to version 1.0.0.1. But i guess i know how to fix that.

 

How critical is that bug? did the layer crash?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Thats strange because nothing adkats relevant had been change to version 1.0.0.1. But i guess i know how to fix that.

 

How critical is that bug? did the layer crash?

That error does not cause any crashes, it just spams the console. Apparently that variable isn't quite thread-safe.

[ImportBot]

Originally Posted by XpKiller*:

 

That error does not cause any crashes, it just spams the console. Apparently that variable isn't quite thread-safe.

yeah i would add a lock object for that function.

[ImportBot]

Originally Posted by reutnitzer*:

 

Thanks for the Informations, it runns Stable i only would know what kind of error it is also thx for your informations

 

Greetings

 

reutnitzer

[ImportBot]

Originally Posted by Kinsman*:

 

Thanks for the update, installing on all servers today. Just a couple of noob questions as been awhile sonce I used the BF3 version.

 

Send Stats to All players: does this give every player their stats at the end of each round?

Top10: I assume this also does a Top 10 display at the end of ever round?

 

Ingame Commands: Do these still need ! at the end, like stats!

 

Time Offset: I entered +10, it became 10, is that ok?

 

Overall Ranking: Is this additional to individual server ranking, and does it require our servers to be in groups, or do we need them in groups if this is activated to still get individual server stats?

 

Last but not least, I see 23 weapon names, is there a list somewhere that we need to add more?

 

Thanks again for the top plugin.

[ImportBot]

Originally Posted by ANKKA32*:

 

Is the database you are attempting to connect to configured to allow external connections? If not, it will ignore any connection attempts from other IPs.

How i get that then? Need asking server Offerings?

[ImportBot]

Originally Posted by Kinsman*:

 

Should I be concerned about this?

 

[statslogger]Warning: PrepareKeywordDic: Mainkey RPG-7 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/SCAR-H/SCAR-H not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey M27IAR not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey M16A4 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey AEK-971 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/C4/C4 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/Claymore/Claymore not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/KH2002/KH2002 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Knife/Knife not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MagpulPDR/MagpulPDR not found!

[21:29:36 42] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP412Rex/MP412REX not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!

[21:29:36 43] [statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!

[21:29:39 46] [statslogger]Warning: PrepareKeywordDic: Mainkey RPG-7 not found!

[21:29:39 46] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/SCAR-H/SCAR-H not found!

[21:29:39 46] [statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!

[21:29:39 46] [statslogger]Warning: PrepareKeywordDic: Mainkey M27IAR not found!

[21:29:39 46] [statslogger]Warning: PrepareKeywordDic: Mainkey M16A4 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey AEK-971 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/C4/C4 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/Claymore/Claymore not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/KH2002/KH2002 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Knife/Knife not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MagpulPDR/MagpulPDR not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP412Rex/MP412REX not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!

[21:29:39 47] [statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!

[ImportBot]

Originally Posted by iMGAnderson*:

 

Hi, i need help.. i never set mysql.. i take 1 from altervista.. but now i dont know nothink,,,,

have you some video tutorial or text tutorial for setting mysql?

thanks too mutch

iMG Anderson

[ImportBot]

Originally Posted by XpKiller*:

 

Thanks for the update, installing on all servers today. Just a couple of noob questions as been awhile sonce I used the BF3 version.

 

Send Stats to All players: does this give every player their stats at the end of each round?

Toggles if a stats request will be displayed to all player or just to the player who requested.

 

Top10: I assume this also does a Top 10 display at the end of ever round?

There are several top10 related option which one do you mean exactly?

 

Ingame Commands: Do these still need ! at the end, like stats!

Yes they still require !,@ or \. But could be a feature request right?

Time Offset: I entered +10, it became 10, is that ok?

Is needed if the time of the proconlayer is not matching your local. Could be obsolete, since procon has it own time offset function(but not 100% sure)

 

Overall Ranking: Is this additional to individual server ranking, and does it require our servers to be in groups, or do we need them in groups if this is activated to still get individual server stats?

Yes it is additional to the individual ranking. the rank command will displayer the overall rank (of a servergroup) instead of the individual one.

This only make sense if you had more than 2 server in a group. If not keep it disabled.

 

Last but not least, I see 23 weapon names, is there a list somewhere that we need to add more?

 

Thanks again for the top plugin.

 

All weaponnames are retrieved from procon. Procon reads its bf4.def, which contains all known weapons so far.

You only need an updated bf4.def file.

 

The list you mentioned is for alternative weaponsalias for ingame commands. The tbl_weapons contains a column friendlyname which reflex the ingame alias name.

[ImportBot]

Originally Posted by Balu00*:

 

So hi i have a problem to connect to my own database from Procon. The database is also accessible from the outside. But I always get this error:

 

 

 

[23:50:19 13] Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=XXXXXXXXXXX".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

bei MySql.Data.MySqlClient.NativeDriver.Open()

bei MySql.Data.MySqlClient.Driver.Open()

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Net.SocketPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

[23:50:19 13] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

 

I honestly do not continue: (

What do I do the wrong I see something?

[ImportBot]

Originally Posted by XpKiller*:

 

@Balu00

Which version procon do you run?

 

You need to allow database connections and add your databasehost to the trusted outgoing connections or disable the sandbox.

Both settings require a restart of the layer server.

[ImportBot]

Originally Posted by Kinsman*:

 

Thanks for the detailed replies XP, the top ten i meant is Top Ten Ingame. I guess theres an ingame command like topten! and it displays when players call it?

 

Also do these matter, or just that bf4.def isn't perfect yet?

 

[11:30:58 48] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!

[11:30:58 48] [statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!

[11:30:58 48] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!

[11:30:58 49] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!

[11:30:58 49] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!

[11:30:58 49] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!

[11:30:58 49] [statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!

[ImportBot]

Originally Posted by jking54*:

 

Got this error I've never seen before, was quick and haven't seen it since:

 

[21:26:57 11] [statslogger]Error: Error in RegisterAllCommands: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

at System.Collections.Generic.Dictionary`2.Enumerator .MoveNext()

at PRoConEvents.CChatGUIDStatsLogger.RegisterAllComma nds()

[ImportBot]

Originally Posted by Balu00*:

 

@Balu00

Which version procon do you run?

 

You need to allow database connections and add your databasehost to the trusted outgoing connections or disable the sandbox.

Both settings require a restart of the layer server.

Hey XPKiller I use the PROCON version 1.4.1.2 I have also registered the website as trustworthy. But I get over and over again this error message. If you have time vll times you can watch your time watching? TeamSpeak or TeamViewer?

[ImportBot]

Originally Posted by reutnitzer*:

 

Hey All,

 

We have a another Problem with the stats logger and Adkats.

 

We got many Errors that the maximum of connections at my Database are reached. We have tryed much stuff to fix it but nothing works.

 

This fault overload the Procon and it would be very unstable and the Layers crashes oftener that normaly.

 

[12:12:59 75] [AdKats] Attempting database connection. Attempt 1 of 5.

[12:12:59 77] [AdKats] SUCCESS: Database connection open.

[12:13:00 17] [AdKats] SUCCESS: Database confirmed functional for AdKats use.

[12:13:00 44] [AdKats] SUCCESS: Database Server Info Fetched. Server ID is 1!

[12:13:03 28] [AdKats] ERROR: Database timeout detected. This is timeout 1. Critical disconnect at 3.

[12:13:03 50] [AdKats] Enabled! Version: 3.7.0.1

[12:13:03 50] [AdKats] WARNING: Preparing to queue procon bans for import. Please wait.

[12:13:03 68] [AdKats] ERROR: Database timeout detected. This is timeout 2. Critical disconnect at 3.

[12:13:04 17] [AdKats] ERROR: Database timeout detected. This is timeout 3. Critical disconnect at 3.

[12:13:04 17] [AdKats] ERROR: Database connection in critial failure state. Disabling Stat Logger and putting AdKats in Backup Mode.

[12:13:04 18] PRoCon Chat, GUID and Stats Logger Disabled

[12:13:14 25] [AdKats] SUCCESS: Database connection restored, re-enabling Stat Logger and returning AdKats to Normal Mode.

[12:13:14 25] PRoCon Chat, GUID and Stats Logger Enabled

[12:13:14 25] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[12:13:14 51] [AdKats] SUCCESS: Exiting Critical Disconnect Handler.

[12:13:14 51] [AdKats] 0 procon bans queued for import. Import might take several minutes if you have many bans!

[12:13:21 30] [statslogger]Error: SQLQuery:

 

After that comes the Database name the passwort mode and this :User ... already has more than 'max_user_connections' active connections

 

[12:13:21 30] Source: MySql.Data

[12:13:21 30] StackTrace: bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

bei MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)

bei MySql.Data.MySqlClient.NativeDriver.Open()

bei MySql.Data.MySqlClient.Driver.Open()

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState& originalState)

bei System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[12:13:21 30] InnerException: MySql.Data.MySqlClient.MySqlException: User ... already has more than 'max_user_connections' active connections

bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.ReadPacket()

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

[12:13:32 11] PRoCon Chat, GUID and Stats Logger Disabled

[12:13:32 93] [AdKats] AdKats 3.7.0.1 Disabled! =(

 

 

So i hope some one can help use to fix it fast.

 

 

Greetings

 

reutnitzer

[ImportBot]

Originally Posted by XpKiller*:

 

Hey All,

 

We have a another Problem with the stats logger and Adkats.

 

We got many Errors that the maximum of connections at my Database are reached. We have tryed much stuff to fix it but nothing works.

 

This fault overload the Procon and it would be very unstable and the Layers crashes oftener that normaly.

 

[12:12:59 75] [AdKats] Attempting database connection. Attempt 1 of 5.

[12:12:59 77] [AdKats] SUCCESS: Database connection open.

[12:13:00 17] [AdKats] SUCCESS: Database confirmed functional for AdKats use.

[12:13:00 44] [AdKats] SUCCESS: Database Server Info Fetched. Server ID is 1!

[12:13:03 28] [AdKats] ERROR: Database timeout detected. This is timeout 1. Critical disconnect at 3.

[12:13:03 50] [AdKats] Enabled! Version: 3.7.0.1

[12:13:03 50] [AdKats] WARNING: Preparing to queue procon bans for import. Please wait.

[12:13:03 68] [AdKats] ERROR: Database timeout detected. This is timeout 2. Critical disconnect at 3.

[12:13:04 17] [AdKats] ERROR: Database timeout detected. This is timeout 3. Critical disconnect at 3.

[12:13:04 17] [AdKats] ERROR: Database connection in critial failure state. Disabling Stat Logger and putting AdKats in Backup Mode.

[12:13:04 18] PRoCon Chat, GUID and Stats Logger Disabled

[12:13:14 25] [AdKats] SUCCESS: Database connection restored, re-enabling Stat Logger and returning AdKats to Normal Mode.

[12:13:14 25] PRoCon Chat, GUID and Stats Logger Enabled

[12:13:14 25] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[12:13:14 51] [AdKats] SUCCESS: Exiting Critical Disconnect Handler.

[12:13:14 51] [AdKats] 0 procon bans queued for import. Import might take several minutes if you have many bans!

[12:13:21 30] [statslogger]Error: SQLQuery:

 

After that comes the Database name the passwort mode and this :User ... already has more than 'max_user_connections' active connections

 

[12:13:21 30] Source: MySql.Data

[12:13:21 30] StackTrace: bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

bei MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)

bei MySql.Data.MySqlClient.NativeDriver.Open()

bei MySql.Data.MySqlClient.Driver.Open()

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState& originalState)

bei System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

bei PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCo mmand selectQuery)

[12:13:21 30] InnerException: MySql.Data.MySqlClient.MySqlException: User ... already has more than 'max_user_connections' active connections

bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

bei MySql.Data.MySqlClient.NativeDriver.ReadPacket()

bei MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

[12:13:32 11] PRoCon Chat, GUID and Stats Logger Disabled

[12:13:32 93] [AdKats] AdKats 3.7.0.1 Disabled! =(

 

 

So i hope some one can help use to fix it fast.

 

 

Greetings

 

reutnitzer

Could you post your plugin settings without your username and password.(a would screenshot be fine)

 

The statsplugin is using a connectionpool be default to prevent such errors. Maybe adkat dont use one. I dont know for sure.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

thx in advance xpkiller

 

settings2.jpg

[ImportBot]

Originally Posted by XpKiller*:

 

set:

min poolsize --> 0

max poolsize --> 5

 

Increase min time between server updates. --> to 60 sec

 

Also lower the connection pool of adkats.

Try the same values as for the stats plugin.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

done...without adkats connection pool .... no connection pooling available at adkats^^

 

no errors till now except the allready known bug which does not effect anythink*

 

error.png

 

THX A LOT

[ImportBot]

Originally Posted by XpKiller*:

 

those errors are caused by adkat. Will fix them in the next release.

 

the adkat poolsize is 0 - 20. I guess is a bit too high.

[ImportBot]

Originally Posted by reutnitzer*:

 

Thanks for you fast and good reply

 

You help us a lot .

 

Greetings

 

reutnitzer

[ImportBot]

Originally Posted by Pvtjohntowle*:

 

This is all I get , it's not working for me. I have set up MySQL through http://www.hourb.com/Signup1236645644.html

 

I don't know the port number because I cannot find it anywhere in the settings on their website. Is it possible for you to connect to my computer with TeamViewer and help me out?

Teamspeak bf4banditos.enjin.com

 

 

de=HostNotFound, ErrorCode=11001, NativeErrorCode=11001. ---> System.Net.Sockets.SocketException: No such host is known

at System.Net.Dns.GetAddrInfo(String name)

at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)

at System.Net.Dns.GetHostEntry(String hostNameOrAddress)

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

--- End of inner exception stack trace ---

at MySql.Data.Common.StreamCreator.GetDnsHostEntry(St ring hostname)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

at MySql.Data.MySqlClient.NativeDriver.Open()

--- End of inner exception stack trace ---

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

i think thats an error cause your database is not able to get incoming connections, thats why i rent a own server.

i dont think that a free database will have the perormance u need

the standard port number for sql is 3306

 

think about using a paid database hosting provider, not a free one

[ImportBot]

Originally Posted by Jamesonp*:

 

[15:20:02 21] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unknown column 'GameID' in 'field list'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Any ideas what is causing this?

[ImportBot]

Originally Posted by Mavy*:

 

Actually the error says exactly what is wrong: "No such host is known". The hostname you provided for you mysql server host are incorrect, or your layer cannot resolve it. Try changing it to the ip.

 

Other then that battleplay4u is right, free hosting often dont allow external connections. And even if they do it is often with very poor performance.

[ImportBot]

Originally Posted by XpKiller*:

 

@Jamesonp

 

did you run the bf3 version before?

[ImportBot]

Originally Posted by Jamesonp*:

 

@Jamesonp

 

did you run the bf3 version before?

Yep. I figured it was related to that. I ended up creating a new DB and importing Adkats tables into there. Seems to be resolved. Thanks for the reply.

[ImportBot]

Originally Posted by almaxkiller*:

 

Is chatlogging disabled? Every time I enable it it shuts off 1 min later. Everything else seems to work except for server stats shows total play time as 235 days when I just downloaded and installed this plugin today (and just created the DB today).

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Is chatlogging disabled? Every time I enable it it shuts off 1 min later. Everything else seems to work except for server stats shows total play time as 235 days when I just downloaded and installed this plugin today (and just created the DB today).

Please read the dependencies section when installing AdKats. This is not an issue, it is an orchestration by that plugin. (The chat logging "error" you mentioned, not the play time)

 

https://github.com/ColColonCleaner/A...-logger-plugin

[ImportBot]

Originally Posted by Hutchew*:

 

Looked back over last 5-6 pages and have kept up with this thread pretty well, but I haven't seen this one before:

 

[00:36:52 31] Error in Tablebuilder:

[00:36:52 31] Message: Duplicate entry '1-U_SCAR-H_M26_Buck' for key 'unique'

[00:36:52 32] Native: -2147467259

[00:36:52 47] Source: MySql.Data

[00:36:52 47] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[00:36:52 47] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

 

 

And the infamous:

 

[00:45:38 11] Error: Error in RegisterAllCommands: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

at System.Collections.Generic.Dictionary`2.Enumerator .MoveNext()

at PRoConEvents.CChatGUIDStatsLogger.RegisterAllComma nds()

 

 

Looks like something is eventually sending the chat logger into panic (or I have an admin with too much plugin access...lol), as all 7 layers had chat logger turned off tonight when I logged in.

 

Any ideas as to a fix? Is it something we can do ourselves?

 

Thanks, guys. I know you all do the best you can.

 

Hutchew