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

[ImportBot]

Originally Posted by dyn*:

 

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

happening here too. I host the layer on a dedicated box and had a layer shutdown too. Though I've only seen one thus far it does make sense that the only one to shut down was the layer hosting the stats logger.

[ImportBot]

Originally Posted by HexaCanon*:

 

happening here too. I host the layer on a dedicated box and had a layer shutdown too. Though I've only seen one thus far it does make sense that the only one to shut down was the layer hosting the stats logger.

so far when the connection pooling is off i did not have any issue, but i do agree that my crash was actually the layer going off and the status of the layer was "stopped".

 

if it happens again i will be sure to report.

[ImportBot]

Originally Posted by HexaCanon*:

 

sorry for double post,

 

no sign of layer going down but this is the three error messages, i started getting them again

 

Code:

[03:15:59 58] Error: Error in UpdateCurrentPlayerTable: 
[03:15:59 58] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[03:15:59 58] Native: -2147467259
[03:15:59 58] Source: MySql.Data
[03:15:59 58] 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.UpdateCurrentPlayerTable(List`1 lstPlayers)
[03:15:59 58] InnerException: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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)
[03:16:12 84] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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)
   --- End of inner exception stack trace ---
   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.getUpdateServerID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by russel5*:

 

Hello, my errors. Pool on/off, but no result

Code:

[06:08:53] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   --- End of inner exception stack trace ---
   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()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLevel iso)
   at MySql.Data.MySqlClient.MySqlConnection.BeginTransaction()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)
[06:10:28] Error: Error in UpdateCurrentPlayerTable: 
[06:10:28] Message: Unable to connect to any of the specified MySQL hosts.
[06:10:28] Native: -2147467259
[06:10:28] Source: MySql.Data
[06:10:28] StackTrace:    at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.UpdateCurrentPlayerTable(List`1 lstPlayers)
[06:11:56] Error: SQLQuery:System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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(MySqlCommand selectQuery)
[06:11:56] Error: System.IndexOutOfRangeException: Cannot find column 0.
   at System.Data.DataColumnCollection.get_Item(Int32 index)
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[06:11:56] Error: System.InvalidOperationException: Transaction has already been rolled back or is not pending
   at MySql.Data.MySqlClient.MySqlTransaction.Rollback()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[06:15:21] Error: getUpdateServerID1: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)
[06:18:16] Error: SQLQuery:
[06:18:16] Message: Fatal error encountered during command execution.
[06:18:16] Native: -2147467259
[06:18:16] Source: MySql.Data
[06:18:16] StackTrace:    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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(MySqlCommand selectQuery)
[06:18:16] InnerException: MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   --- End of inner exception stack trace ---
   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()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
[06:18:16] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   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 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()
   --- End of inner exception stack trace ---
   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()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLevel iso)
   at MySql.Data.MySqlClient.MySqlConnection.BeginTransaction()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)
[06:18:17] Error: Error in UpdateCurrentPlayerTable: 
[06:18:17] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[06:18:17] Native: -2147467259
[06:18:17] Source: MySql.Data
[06:18:17] 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 MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.UpdateCurrentPlayerTable(List`1 lstPlayers)
[06:18:17] InnerException: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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)
[06:19:23] Error: getUpdateServerID1: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)
[06:26:50] Error: getUpdateServerID1: System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   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.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServerID(CServerInfo csiServerInfo)

After this errors, procon layer not response. I can't connect to layer, and i need to restart server

[ImportBot]

Originally Posted by XpKiller*:

 

@russel5 it seems that your MySQL host is not reachable.

[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.

I "rolled back" to previous version (1.0.1.0) and no error messages.

[ImportBot]

Originally Posted by russel5*:

 

@russel5 it seems that your MySQL host is not reachable.

Very helpful info But why all day i don't have this errors, this errors only a night when my BF3 server empty.

Why my procon layer not response? Because MySQL host not reacheble? Or this version have bug

[ImportBot]

Originally Posted by Phil_K*:

 

this errors only a night when my BF3 server empty.

Can you check the default "wait_timeout" on your mysql server?

 

Seems a bit like a typical "gone away" problem.

( http://dev.mysql.com/doc/refman/5.1/en/gone-away.html )

 

Greets

Phil.

[ImportBot]

Originally Posted by XpKiller*:

 

i guess i found the issues what causes those problem at least 95% of them.

 

If someone is willing to test. please sent me a pm. Please only sent me a pm if had problems with the latest version! Icant reproduce that issues because it is a server load issues e.g. the database server is slow.

[ImportBot]

Originally Posted by russel5*:

 

Hi, very strange, but tonight I did not have any problems with your plugin 1.1.0.0. No errors, everything works as it should. But yesterday I made a small change in the MySQL server and the plug-in. In MySQL, I run the following script SET wait_timeout = 43200 (12 hours), in the plugin i changed Failed transaction -- 1 and High perfomance mode -- off.

Today i installed a test version and High perfomance mode -- on. Tomorrow post here how this test version works.

My pooling connection is allways OFF

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller, going back to version 1.0.1.0 is still serving me well.

 

Is there anything wrong with this code to get the currentplayers table working in version 1.0.1.0?

Code:

private void UpdateCurrentPlayerTable(List<CPlayerInfo> lstPlayers)
        {
            this.DebugInfo("Trace", "UpdateCurrentPlayerTable");
            bool success = false;
            int attemptCount = 0;
            using (System.Data.Odbc.OdbcConnection DBConnection = new System.Data.Odbc.OdbcConnection(this.DBConnectionStringBuilder()))
            {
                string deleteSQL = "DELETE FROM " + this.tbl_currentplayers + " WHERE ServerID = _";
                StringBuilder InsertSQL = new StringBuilder("INSERT INTO " + this.tbl_currentplayers + " (ServerID, SoldierName, EA_GUID, PB_GUID, Score, Kills, Deaths, Headshots, PlayerJoined, TeamID, SquadID, CountryCode) VALUES ");
                System.Data.Odbc.OdbcTransaction Tx = null;
                try
                {
                    DBConnection.Open();
                    while (!success)
                    {
                        attemptCount++;
                        try
                        {
                            //Start of the Transaction
                            Tx = DBConnection.BeginTransaction();

                            using (OdbcCommand OdbcCom = new OdbcCommand(deleteSQL, DBConnection, Tx))
                            {
                                OdbcCom.Parameters.AddWithValue("@pr", this.ServerID);
                                OdbcCom.ExecuteNonQuery();
                            }
                            if (lstPlayers.Count > 0)
                            {
                                foreach (CPlayerInfo cpiPlayer in lstPlayers)
                                {
                                    InsertSQL.Append("( _,_,_,_,_,_,_,_,_,_,_,_),");
                                }
                                InsertSQL.Length = InsertSQL.Length - 1;
                                using (OdbcCommand OdbcCom = new OdbcCommand(InsertSQL.ToString(), DBConnection, Tx))
                                {
                                    foreach (CPlayerInfo cpiPlayer in lstPlayers)
                                    {
                                        OdbcCom.Parameters.AddWithValue("@pr", this.ServerID);
                                        OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.SoldierName);
                                        OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.GUID);
                                        if (this.StatsTracker.ContainsKey(cpiPlayer.SoldierName) == true)
                                        {
                                            OdbcCom.Parameters.AddWithValue("@pr", this.StatsTracker[cpiPlayer.SoldierName].Guid);
                                        }
                                        else
                                        {
                                            OdbcCom.Parameters.AddWithValue("@pr", ""); //placeholder
                                        }
                                        OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.Score);
                                        OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.Kills);
                                        OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.Deaths);
                                        if (this.StatsTracker.ContainsKey(cpiPlayer.SoldierName) == true)
                                        {
                                            OdbcCom.Parameters.AddWithValue("@pr", this.StatsTracker[cpiPlayer.SoldierName].Headshots);
                                            OdbcCom.Parameters.AddWithValue("@pr", this.StatsTracker[cpiPlayer.SoldierName].Playerjoined);
                                        }
                                        else
                                        {
                                            OdbcCom.Parameters.AddWithValue("@pr", 0); //Headshot placeholder
                                            OdbcCom.Parameters.AddWithValue("@pr", MyDateTime.Now);
                                        }
                                        OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.TeamID);
										OdbcCom.Parameters.AddWithValue("@pr", cpiPlayer.SquadID);
										if (this.StatsTracker.ContainsKey(cpiPlayer.SoldierName) == true)
                                        {
                                            OdbcCom.Parameters.AddWithValue("@pr", this.StatsTracker[cpiPlayer.SoldierName].PlayerCountryCode);
                                        }
                                        else
                                        {
                                            OdbcCom.Parameters.AddWithValue("@pr", ""); //Country placeholder
                                        }
                                    }
                                    OdbcCom.ExecuteNonQuery();
                                }
                            }
                            Tx.Commit();
                            success = true;
                        }
                        catch (OdbcException ex)
                        {
                            switch (ex.Errors[0].NativeError)
                            {
                                case 1205: //(ER_LOCK_WAIT_TIMEOUT) Lock wait timeout exceeded
                                case 1213: //(ER_LOCK_DEADLOCK) Deadlock found when trying to get lock
                                    if (attemptCount < this.TransactionRetryCount)
                                    {
                                        this.DebugInfo("Warning", "Warning in UpdateCurrentPlayerTable: Locktimeout or Deadlock occured restarting Transaction(delete und Insert). Attempt: " + attemptCount);
                                        try
                                        {
                                            Tx.Rollback();
                                        }
                                        catch { }
                                        Thread.Sleep(attemptCount * 1000);
                                    }
                                    else
                                    {
                                        this.DebugInfo("Error", "Error in UpdateCurrentPlayerTable: Maximum number of " + this.TransactionRetryCount + " transaction retrys exceeded (Transaction delete und Insert)");
                                        throw;
                                    }
                                    break;
                                default:
                                    throw; //Other exceptions
                            }
                        }
                    }
                    //Reset bool and counter
                    attemptCount = 0;
                    success = false;



                }
                catch (OdbcException oe)
                {
                    this.DebugInfo("Error", "Error in UpdateCurrentPlayerTable: ");
                    this.DisplayOdbcErrorCollection(oe);
                }
                catch (Exception c)
                {
                    this.DebugInfo("Error", "Error in UpdateCurrentPlayerTable: " + c.ToString());
                }
            }
        }

I realize that the option to enable it still needs to be defined at the top of the code. I have made the necessary changes and am using this code without issue currently. I just wanted to know if there is anything I am doing wrong or overlooked which could cause problems in the future as this programming language is not my specialty.

 

I realize some items are missing such as suicides and IP address, but I don't really care about those values for this purpose.

 

EDIT: Sorry for the thread hijack. You would probably prefer if I tested your new plugin revision rather than modifying the old version.

 

Will your upcoming revision include the current ticket count in the server table?

[ImportBot]

Originally Posted by russel5*:

 

@XpKiller, everything fine, no errors, beta test 2

Settings

Connection pooling -- on

Min -- 0

Max -- 10

Retry attemps -- 3

All another settings set -- Yes

[ImportBot]

Originally Posted by HexaCanon*:

 

i have just started the test 2, so give me 1 day at least xD

[ImportBot]

Originally Posted by russel5*:

 

Hi, @XpKiller, two days passed and no errors with beta_3 version. Thanks

[ImportBot]

Originally Posted by staazvaind*:

 

need help

 

"Unknown column 'IP_Address' in 'where clause'"

 

the ip adress is correct tho what does it mean ?

 

[20:11:07 73] 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.ExecuteDbDataR eader(CommandBehavior behavior)

bei System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)

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.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

[20:11:07 75] Error: SQLQuery OuterException:System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

bei PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySq lCommand selectQuery)

[20:11:07 76] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unknown column 'IP_Address' in 'where clause'

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

/edit:

 

ok, deleted the db and reinstalled a new one w/o suffixes.

error msg gone, chat logs, stats not

then i turned on map stuff and got the following msg:

 

] Error: Error in Startstreaming:

[21:10:14 68] Message: Cannot add or update a child row: a foreign key constraint fails (`player_stats`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[21:10:14 68] Native: -2147467259

[21:10:14 68] Source: MySql.Data

[21:10:14 68] 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()

[21:10:14 85] 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()

[21:10:26 93] 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)

[ImportBot]

Originally Posted by XpKiller*:

 

stop the plugin.

recreate the database/drop all table belog to the plugin.

dont use suffix

start the plugin.

Some users have problems with connection pooling so may you need to disable it.

[ImportBot]

Originally Posted by KillaKali*:

 

hey guys, updated to newest version of both procon, battlelog cache and stats logger. all load fine, but dont do anything. only "cheat detector" is finding web stats. BC and BF3 stats just sit idle, with no errors/ exceptions. my other procon server works fine with these using ODBC, the new versions seem like they arent getting triggered to search webstats or database... any ideas?

 

proconconfig.png

 

proconbf3stats.png

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 1.1.0.1

 

This release is mainly a bugfix release to solve the timeout issues, which have been reported by several users.

 

Changelog:

 

1.1.0.1

Some changes to fix the timeout issues.

Thanks to russel5 & HexaCanon for Testing!

New Defaults for connection pooling --> min poolsize = 0 and max poolsize = 10

If you still have problems try to disable connection pooling or increase the max connectionpoolsize.

 

@KillaKalli

 

do you have set a password for you db user?

[ImportBot]

Originally Posted by russel5*:

 

@XpKiller, thanks for new version

Tell this version = beta 3 version?

or i need install new version

[ImportBot]

Originally Posted by XpKiller*:

 

@russel5 yes it the same.

[ImportBot]

Originally Posted by HexaCanon*:

 

is the last version the test 3 one ?

[ImportBot]

Originally Posted by ty_ger07*:

 

is the last version the test 3 one ?

-->

 

@XpKiller, thanks for new version

Tell this version = beta 3 version?

or i need install new version

@russel5 yes it the same.

[ImportBot]

Originally Posted by staazvaind*:

 

ok, thx - had it working but i changed my server to a new provider (game!d)

and now i get this:

 

- made a new db with a new user, no entries.

 

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.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

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

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

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.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[ImportBot]

Originally Posted by KillaKali*:

 

Yes, just whited them out for forum purposes. I have a single layer server with all the same settings but an earlier version and it communicates fine. Want to work out the kinks in the new multilayer server before migrating my main BF3 server over. This was one of a few kinks that presented itself. Will try the new version when I get back into town.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

ok, thx - had it working but i changed my server to a new provider (game!d)

and now i get this:

 

- made a new db with a new user, no entries.

You layer lacks a proper configuration of the sandbox. You will need to add your database-hostname and database-port to the list of allowed hosts (or have the support do that).

[ImportBot]

Originally Posted by USP00P*:

 

I've read this forum through and through. Tried every option possible and still can't figure out what any of these error messeges mean. We use the current plugin, 1.1.0.1

 

Below is all the errors we get.

 

[14:34:13 55] Error in Tablebuilder:

[14:34:13 55] Message: Authentication method 'mysql_old_password' not supported by any of the available plugins.

[14:34:13 55] Native: -2147467259

[14:34:13 55] Source: MySql.Data

[14:34:13 55] StackTrace: at MySql.Data.MySqlClient.Authentication.Authenticati onPluginManager.GetPlugin(String method)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.GetPlugin(String method, NativeDriver driver, Byte[] authData)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)

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

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

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.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[14:34:13 55] 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:34:13 61] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication method 'mysql_old_password' not supported by any of the available plugins.

at MySql.Data.MySqlClient.Authentication.Authenticati onPluginManager.GetPlugin(String method)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.GetPlugin(String method, NativeDriver driver, Byte[] authData)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)

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

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

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.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by ty_ger07*:

 

Have you asked your database host to update mysql authentication method to new password authentication? Old password authentication has been deprecated due to security issues.

[ImportBot]

Originally Posted by USP00P*:

 

I actually just sent my web hosting company a support ticket asking that same very question. Then I refresh this forum to see your post.....LoL Thanks ty_ger07........ I'll report back with the end result.

[ImportBot]

Originally Posted by ty_ger07*:

 

I'm not educated with any of this but figure out what I can figure out. I think it is just a simple command they can run which tells it to set the password using new authentication where password is whatever using old authentication. I believe it just uses a more secure encryption algorithm.

 

I don't know if it is something you could do yourself in phpMyAdmin or something they need to do.

[ImportBot]

Originally Posted by XpKiller*:

 

Try to change your password. Otherwise you need to contact the server owner. To disable old_password auth.

The 6.6 .net connector had drop the support for it because it was deprecated.