Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by mc-kay*:

 

I don't changed it, that's the default one.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

  mc-kay* said:

I don't changed it, that's the default one.

My previous comments still apply.

Changing anything within the settings of your local Procon instance doesn't change the same settings at your Procon layer. You'll have to ask your Procon host do to this.

[ImportBot]

Originally Posted by XpKiller*:

 

As an alternative you add the database host to the trusted Hosts as i said in a previous post.

[ImportBot]

Originally Posted by GerWonder*:

 

hello again,

 

I am at the same hoster. I wrote with the support of them and they told me that the sandbox should be deactivated by default. Is there somewhere an information where I can see that this is true?

 

I allready looked in the procon.cfg and there i found that: procon.private.options.runPluginsInSandbox True

 

This means that the sandbox isn´t deactivated?

[ImportBot]

Originally Posted by mc-kay*:

 

I have the same in the procon.cfg.

Wrote the support today but no response yet...

[ImportBot]

Originally Posted by XpKiller*:

 

  GerWonder* said:

hello again,

 

I am at the same hoster. I wrote with the support of them and they told me that the sandbox should be deactivated by default. Is there somewhere an information where I can see that this is true?

 

I allready looked in the procon.cfg and there i found that: procon.private.options.runPluginsInSandbox True

 

This means that the sandbox isn´t deactivated?

Correct the sandbox is enabled.

[ImportBot]

Originally Posted by GeorgH*:

 

hello

i have updated the plugin today and now it isn't working any more.

It is only saveing the mapstats and the server table.

Log:

  Quote

[19:42:33 34] Trace: OnListPlayers Player: has 1 deaths; correcting to 0 deaths now

[19:45:48 07] Trace: getUpdateServerID

[19:46:46 65] Trace: playerLeftServer: EAGUID: EA?

[19:46:46 65] Trace: playerLeftServer: not in session dic

[19:46:48 92] Trace: getUpdateServerID

[19:47:49 74] Trace: getUpdateServerID

[19:47:56 74] Trace: playerLeftServer: EAGUID: EA?

[19:47:56 74] Trace: playerLeftServer: not in session dic

[19:48:04 72] Trace: playerLeftServer: EAGUID: EA?

[19:48:04 72] Trace: playerLeftServer: not in session dic

[19:48:10 96] Trace: OnRoundOver: TeamId -> 1

[19:48:10 97] Trace: OnRoundOverPlayers Event

[19:48:27 59] Trace: playerLeftServer: EAGUID: EA?

[19:48:27 59] Trace: playerLeftServer: not in session dic

[19:48:50 58] Trace: getUpdateServerID

[19:49:24 92] Info: OnLevelLoaded: XP1_002 Gamemode: TeamDeathMatch0 Round: 1/1

[19:49:24 92] Info: update sql server

[19:49:24 92] Info: Started streaming to the DB-Server

[19:49:24 93] Trace: Mapstats Write querys

[19:49:24 96] Trace: PlayerStats Write querys

[19:49:24 96] Trace: Adding EAGUID EA? to searchlist

[19:49:24 96] Trace: Adding EAGUID EA? to searchlist

[19:49:24 96] Trace: Adding EAGUID EA? to searchlist

[19:49:24 96] Trace: Adding EAGUID EA? to searchlist

[19:49:24 96] Trace: Adding EAGUID EA? to searchlist

[19:49:24 96] Trace: Adding EAGUID EA? to searchlist

[19:49:24 98] Trace: Insert for Player MarkusWME

[19:49:24 98] Trace: ClanTag

[19:49:24 98] Trace: SoldierName

[19:49:24 98] Trace: PBGUID

[19:49:24 98] Trace: EAGUID EA?

[19:49:24 98] Trace: IP_Address

[19:49:24 98] Trace: CountryCode at

[19:49:24 98] Trace: Insert for Player

[19:49:24 98] Trace: ClanTag

[19:49:24 98] Trace: SoldierName

[19:49:24 98] Trace: PBGUID

[19:49:24 98] Trace: EAGUID EA?

[19:49:24 98] Trace: IP_Address

[19:49:24 98] Trace: CountryCode at

[19:49:24 99] Error: Error in Startstreaming:

[19:49:24 99] Message: Duplicate entry 'EA_' for key 'UNIQUE_playerdata'

[19:49:24 99] Native: -2147467259

[19:49:24 99] Source: MySql.Data

[19:49:24 99] StackTrace: bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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

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

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[19:49:24 99] Info: Connection MySqlConn closed

[19:49:34 91] Trace: OnRoundOver: TeamId -> 0

[19:49:34 91] Trace: OnRoundOverPlayers Event

[19:49:37 35] Trace: Added Player: to welcomestatslist

[19:49:51 45] Trace: getUpdateServerID

[19:49:51 45] Error: getUpdateServerID1: System.InvalidOperationException: Nested transactions are not supported.

bei MySql.Data.MySqlClient.ExceptionInterceptor.Throw( Exception exception)

bei MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction(IsolationLevel iso)

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[19:49:51 51] Error: Error in Startstreaming OuterException: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

thanks for your help

[ImportBot]

Originally Posted by XpKiller*:

 

Which mysql server version do you run?

Try to disable connection pooling if enabled.

[ImportBot]

Originally Posted by Legate*:

 

New version, new issue:

 

Code:

[14:56:27 57] Error: Error in UpdateRanking: 
[14:56:27 57] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[14:56:27 57] Native: -2147467259
[14:56:27 59] Source: MySql.Data
[14:56:27 60] StackTrace:    at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
   at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
   at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.UpdateRanking()
[14:56:27 62] InnerException: System.TimeoutException: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder ---> System.IO.IOException: Unable to read data from the transport connection: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder. ---> System.Net.Sockets.SocketException: Se produjo un error durante el intento de conexión ya que la parte conectada no respondió adecuadamente tras un periodo de tiempo, o bien se produjo un error en la conexión establecida ya que el host conectado no ha podido responder
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& 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)

No sandbox, DB (MySql 5.5.13) on the same PC than Procon.

[ImportBot]

Originally Posted by GerWonder*:

 

  mc-kay* said:

I have the same in the procon.cfg.

Wrote the support today but no response yet...

for me its working now. the support edit the procon.cfg manually and all is perfect.

 

 

ps in german: mckay kennen wir uns auf BF oder gar von W:ET?

[ImportBot]

Originally Posted by GeorgH*:

 

  XpKiller* said:

Which mysql server version do you run?

Try to disable connection pooling if enabled.

Using MySQL Server V5.5.15.

Its working now. Thanks!

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller,

 

For some reason, my PRoCon layer stopped itself 4 times in one day. The layer host doesn't know how PRoCon could stop itself, but did note that your plugin was causing it to use approximately 5 times the normal amount of memory at some periods in time.

 

Do you have any idea what is going on?

 

I disabled all extras like welcome messages, top 10, player of the week, instant chat logging, etc. I also tried with and without connection pooling. Still the server was lagging and stopped itself eventually.

 

It's weird because I didn't have any problems before. And now all the sudden I had all sorts of problems in one day without changing anything.

 

If you don't have any ideas, I will try reverting back to 1.0.1.0 and try again.

[ImportBot]

Originally Posted by XpKiller*:

 

hmm i didnt notice such a thing yet. Any erorrs in the log?

[ImportBot]

Originally Posted by Enco86*:

 

I have an annoying problem that i cannot connect to my database i'm totally new to this mysql thing.

Btw i ordered a free mysql from 00webhost.com maybe that is the problem.I don't know any other free or premium mysql hosting i will be glad if you suggest one.

 

Here is the error log:

 

Error in Tablebuilder:

[14:21:25 87] Message: Unable to connect to any of the specified MySQL hosts.

[14:21:25 87] Native: -2147467259

[14:21:25 87] Source: MySql.Data

[14:21:25 87] StackTrace: 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..ctor(MySqlConnec tionStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[14:21:25 87] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[14:21:40 87] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.

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..ctor(MySqlConnec tionStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@Enco86

 

it seems that your Mysql Server host address is not correct. could you post the setting without user and password please.

[ImportBot]

Originally Posted by Enco86*:

 

  XpKiller* said:

@Enco86

 

it seems that your Mysql Server host address is not correct. could you post the setting without user and password please.

I solved the problem at last it works like a charm but everything is posted with the yell tag.I want only welcome stats to be posted with yell but can't find a way with ''say''.

 

Forexample : [yell,2]Serverstats for %playerName% i change this command to [say,2]xxxx doesn't work.

I comletely removed the [yell] part it doesn't work again.

I tried to mix up yell with say and it completely failed. [say,yell,3]xxxx

 

What should i do ?

[ImportBot]

Originally Posted by ty_ger07*:

 

  XpKiller* said:

hmm i didnt notice such a thing yet. Any erorrs in the log?

Yes, I periodically got the errors Enco86 posted. But only every now and then.

 

These are the errors I get from time to time:

 

(the one Enco posted) Every now and then not able to connect to specified hosts.

  Quote

[12:05:39 34] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.

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.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

Frequently pool size maxed.

  Quote

[11:52:27 42] Error: SQLQuery:

[11:52:27 42] Message: error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

[11:52:27 42] Native: -2147467259

[11:52:27 42] Source: MySql.Data

[11:52:27 42] StackTrace: at MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

[11:52:27 42] Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

[11:52:27 42] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[11:52:27 43] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

And this caused by the other errors?

  Quote

[11:52:11 69] Error: SQLQuery:System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

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

at System.Data.Common.DbConnectionStringBuilder.get_C onnectionString()

at PRoConEvents.CChatGUIDStatsLoggerBF3.DBConnectionS tringBuilder()

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

I have 7 servers on the same layer. Do I need to increase the max connection pool size to compensate? Are all the servers using the same pool?

[ImportBot]

Originally Posted by XpKiller*:

 

@Enco

just use [say] The say command has no display duration.

 

@ty_ger07

it could be a networkproblem.

could you post you settings your connection.

Try to use an ip address instead of dns name.

It seems that the odbc drive behave different.

[ImportBot]

Originally Posted by ty_ger07*:

 

  XpKiller* said:

@ty_ger07

it could be a networkproblem.

could you post you settings your connection.

Try to use an ip address instead of dns name.

It seems that the odbc drive behave different.

I updated my error messages above.

 

Here is my actual error message instead of the copied version Enco posted:

  Quote

[12:05:39 34] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.

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.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

I hadn't changed my network settings and it used to work fine.

 

  Quote

Host: 50.63.244.114

Port: 3306

Database Name: secret

User Name: secret

Password: secret

Connection Pooling: On

Min Connection Pool Size: 2

Max Connection Pool Size: 10 (used to be the default 5 until I started getting these errors)

Failed Transaction Retry Attempts: 2

Minimum Time (sec) between ServerInfo Updates: 60

And procon.cfg of the layer server:

  Quote

/////////////////////////////////////////////

// This config will be overwritten by procon.

/////////////////////////////////////////////

procon.private.window.position Normal 30 33 1024 780

procon.private.options.setLanguage "au.loc"

procon.private.options.chatLogging False

procon.private.options.consoleLogging False

procon.private.options.eventsLogging False

procon.private.options.pluginLogging False

procon.private.options.autoCheckDownloadUpdates False

procon.private.options.autoApplyUpdates False

procon.private.options.autoCheckGameConfigsForUpda tes True

procon.private.options.showtrayicon False

procon.private.options.minimizetotray False

procon.private.options.closetotray False

procon.private.options.allowanonymoususagedata False

procon.private.options.runPluginsInSandbox False

procon.private.options.allowAllODBCConnections False

procon.private.options.allowAllSmtpConnections False

procon.private.options.adminMoveMessage True

procon.private.options.chatDisplayAdminName False

procon.private.options.EnableAdminReason False

procon.private.options.layerHideLocalPlugins True

procon.private.options.layerHideLocalAccounts True

procon.private.options.ShowRoundTimerConstantly False

procon.private.options.ShowCfmMsgRoundRestartNext True

procon.private.options.ShowDICESpecialOptions False

procon.private.httpWebServer.enable False 27360 "0.0.0.0"

procon.private.options.trustedHostDomainsPorts "50.63.244.114" 3306

procon.private.options.statsLinkNameUrl Metabans http://metabans.com/search/%player_name%

procon.private.options.pluginMaxRuntime 0 59

procon.private.options.UsePluginOldStyleLoad False

...

Maybe the webserver where the database is hosted is being slow or a node in between?

[ImportBot]

Originally Posted by ty_ger07*:

 

Again, XpKiller, here is another error similar my other errors above.

 

  Quote

[12:20:53 54] Error: SQLQuery:

[12:20:53 54] Message: Unable to connect to any of the specified MySQL hosts.

[12:20:53 55] Native: -2147467259

[12:20:53 55] Source: MySql.Data

[12:20:53 55] StackTrace: 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 System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState& originalState)

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

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

[12:20:53 55] Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

But here is some more data for you:

 

This error is also happening on servers with no players in it. So, this means that in this particular instance, the error occurred while updating the current player list and server info after a ServerInfo update.

 

I don't know if that helps you or not. It probably still means that there is nothing wrong with your plugin and something wrong with my network.

[ImportBot]

Originally Posted by XpKiller*:

 

Please disable connection pooling for all layers. It could be that connection pooling causes that.

For me it looks like network issues. on the other hand i dont have much experience with the native .net driver. also you seems the first one have this problem.

[ImportBot]

Originally Posted by ty_ger07*:

 

Ok, I will try tomorrow. I am trying a few changes at a time so I can see what does what. I am also experiencing an issue where the layer stops itself and don't know if it is related. Having 7 servers on the same layer may be part of the issue causing the high memory usage and network issues. I don't know.

 

I did notice though that if connection pooling is disabled, it isn't possible to disable "no connection limits". You used to be able to set that to no. Now it is reverted back to yes after each server restart.

[ImportBot]

Originally Posted by ty_ger07*:

 

I am going to try going back to 1.0.1.0. I am still having a lot of layer issues with it stopping itself and errors from this plugin with version 1.1.0.0. I will see if 1.0.1.0 is stable again like it used to be or if there is something else going on.

[ImportBot]

Originally Posted by HexaCanon*:

 

how is chat logging handled if i connect all of my layers into the same database ? will they be separated ?

[ImportBot]

Originally Posted by EBassie*:

 

  HexaCanon* said:

how is chat logging handled if i connect all of my layers into the same database ? will they be separated ?

Then there is ONE chatlog table where the chatlog-entries have a serverID.

[ImportBot]

Originally Posted by ty_ger07*:

 

  ty_ger07* said:

I am going to try going back to 1.0.1.0. I am still having a lot of layer issues with it stopping itself and errors from this plugin with version 1.1.0.0. I will see if 1.0.1.0 is stable again like it used to be or if there is something else going on.

After reverting, no layer crashes or errors so far. I miss the current players table though. Perhaps I can cobble it in.

[ImportBot]

Originally Posted by HexaCanon*:

 

i had layer crash and error messages with connection pooling on, i turned it off and no errors since then, hopefully it stays stable.

 

i have no idea what connection pooling is lol

[ImportBot]

Originally Posted by XpKiller*:

 

do you have the error message for me?

 

it seems the odbc solution more stable. anyway i personalty had no crash until now.

[ImportBot]

Originally Posted by HexaCanon*:

 

  XpKiller* said:

do you have the error message for me?

 

it seems the odbc solution more stable. anyway i personalty had no crash until now.

sorry i dont, they were 3 error messages that kept repeating till i turned that loop thingy off.

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller, I updated my post regarding layer issues:

www.phogue.net/forumvb/showth...e-stops-itself*

 

  ty_ger07* said:

I believe the problem is solved.

 

It appears that the native DB connector used in PRoCon version 1.4.0.5 and higher (my layer is using v 1.4.0.6) was causing the PRoCon service on the layer to stop for whatever reason. I don't think it is necessarily a problem with PRoCon version 1.4.0.5 and higher but more a problem of using that DB connector which is available. As long as you don't use that native DB connector, it seems fine.

 

When using XpKiller's "BF3 Chat, GUID, Stats and Mapstats Logger" version 1.1.0.0 which uses the native "ADO MySql Connector", the PRoCon service on the layer randomly stopped. When reverting back to XpKiller's "BF3 Chat, GUID, Stats and Mapstats Logger" version 1.0.1.0 which uses the ODBC connector instead of the native ADO connector, the PRoCon service on the layer no longer stops. The layer is still using PRoCon version 1.4.0.6 and is stable as long as I don't use a plugin which uses the native ADO connector.

 

Hope that helps someone!

I was able to get some of your currentPlayers table code working in version 1.0.1.0. I saw that you already had a headstart on the code in that version.