Jump to content

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

ImportBot

By ImportBot
in Plugins

Recommended Posts

ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Tomgun*:

 

in the other post it says

 

This is due to Connector/NET 6.6 dropping support for "old style" password authentication. Make sure your database password authentication is changed to not use old style authentication.

I asked the guy who deals with our website and he said the old style is not on and never was so it should be fine
* Restored post. It could be that the author is no longer active.
Link to comment
  • Replies 1.9k
  • Created
  • Last Reply

Top Posters In This Topic

  • ImportBot

    1934

Popular Days

Top Posters In This Topic

Popular Days

ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ty_ger07*:

 

in the other post it says

 

 

 

I asked the guy who deals with our website and he said the old style is not on and never was so it should be fine

Rather than saying it isn't or thinking it isn't, can you just have him run this query to make sure?

 

Code: 

SELECT @@session.old_passwords, @@global.old_passwords;
Just run it in phpMyAdmin while logged into that database. It's the best way to know for sure.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Tomgun*:

 

Rather than saying it isn't or thinking it isn't, can you just have him run this query to make sure?

 

Code: 

SELECT @@session.old_passwords, @@global.old_passwords;
Just run it in phpMyAdmin while logged into that database. It's the best way to know for sure.
ok will do cheers :ohmy:
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ty_ger07*:

 

ok will do cheers :ohmy:

Once you confirm that, I would make sure he tries to rehash the password. Even if the database is currently using new style password authentication, that doesn't mean that the password wasn't hashed using old style password authentication.

 

Code: 

SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');
Since you have already confirmed that the database is set up to use new style authentication by this point, setting the password again will rehash it and make sure that the password is hashed in the new authentication method.

 

And if that doesn't help, then you should look at verifying the correct username and password and verifying that the database is set up to allow external connections from IPs other than itself.

* Restored post. It could be that the author is no longer active.
Link to comment
  • 2 weeks later...
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ty_ger07*:

 

Is there any way to export the top 10 players to an HTML page?

I'd like to put that on our clan website but have no idea how to do it...

Not with HTML. HTML is static. You need something dynamic. Look at the link in my signature.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted (edited)

Here's my stats Page http://kackboon.org/top2.php

<_php
    include 'inc/dbconnect.php';

//Sort by
$stats = "Score";

$server= "1";
$limit = "250";

$count = 1;
$query = "select tbl_playerdata.SoldierName, tbl_playerstats.Score, tbl_playerstats.Kills, tbl_playerstats.Headshots, tbl_playerstats.Deaths, tbl_playerstats.Suicide, tbl_playerstats.TKs, tbl_playerstats.Rounds, tbl_playerstats.Killstreak, tbl_playerstats.Deathstreak, tbl_playerstats.Wins, tbl_playerstats.Losses, tbl_playerstats.HighScore, tbl_playerdata.CountryCode, tbl_server.ServerName
from tbl_playerstats, tbl_server_player, tbl_playerdata, tbl_server
where tbl_playerstats.StatsID = tbl_server_player.StatsID and tbl_playerdata.PlayerID = tbl_server_player.PlayerID and tbl_server_player.ServerID = tbl_server.ServerID and tbl_server.ServerID like '".$server."'
order by tbl_playerstats.".$stats." desc
limit ".$limit;

$result = mysql_query($query) or die(mysql_error())
_>
<!-- Query:
<_php echo $query; _>
-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Top <_php echo $limit_> Spieler</title>
<style>
    .headlines {
        text-decoration:underline;
    }
.tr {
        border-style:solid;
        border-width:1px;
        border-color:black;
    }
    .country {text-align:center;}
</style>
</head>

<body>
<h2 style="text-align:center; ">Top <_php echo $limit_> (ordered by <_php echo $stats; _>)</h2>

<table style="width:100%; ">
    <tr class="headlines"><td style="text-align:center;">#</td><td style='width:18px; text-align:center; '><img src="../img/globe.png" /></img></td><td>Name</td><td>Score</td><td>Kills</td><td>HeadShots</td><td>Deaths</td><td>Suicide</td><td>TeamKills</td><td>Rounds</td><td>Killstreak</td><td>Deathstreak</td><td>Wins</td><td>Losses</td></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<_php    while($row = mysql_fetch_assoc($result)) {

print "<tr class='tr' ";
if(($count%2) == "0") {print "style='background-color:white;'";} else {print "style='background-color:LightGray;'";};
print ">";

print "<td style='text-align:center;'>";
print $count;
print "</td>";

print "<td class='country' style='width:18px; text-align:center; '>";
print "<img src='img/flag/".$row[CountryCode].".gif'></img>";
print "</td>";

print "<td>";
print "$row[SoldierName]";
print "</td>";    

print "<td>";
print "$row[Score]";
print "</td>";

print "<td>";
print "$row[Kills]";
print "</td>";

print "<td>";
print "$row[Headshots]";
print "</td>";

print "<td>";
print "$row[Deaths]";
print "</td>";

print "<td>";
print "$row[Suicide]";
print "</td>";

print "<td>";
print "$row[TKs]";
print "</td>";

print "<td>";
print "$row[Rounds]";
print "</td>";

print "<td>";
print "$row[Killstreak]";
print "</td>";

print "<td>";
print "$row[Deathstreak]";
print "</td>";

print "<td>";
print "$row[Wins]";
print "</td>";

print "<td>";
print "$row[Losses]";
print "</td>";

//print "<td>";
//print "$row[ServerName]";
//print "</td>";

$count++;
}
_>
</table>
</body>
</html>

Fell free to copy / modify it

Edited by maxdralle
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Salzstange*:

 

Hey guys, how can i realize that a message appears in the chat at the beginning of every new round:

 

Type !rank for your rank

Type !top10 for the top ten of the server

 

for example. Is there any option? Sorry but my English isnt very good :sad:

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by rasvib*:

 

Hello

I have this error , can you help me ?

 

Code: 

Error: SQLQuery:
[23:02:42 91] Message: Unable to connect to any of the specified MySQL hosts.
[23:02:42 91] Native: -2147467259
[23:02:42 91] Source: MySql.Data
[23:02:42 91] StackTrace:    à MySql.Data.MySqlClient.NativeDriver.Open()
   à MySql.Data.MySqlClient.Driver.Open()
   à MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   à MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   à MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   à MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   à MySql.Data.MySqlClient.MySqlPool.GetConnection()
   à MySql.Data.MySqlClient.MySqlConnection.Open()
   à System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   à System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   à System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   à System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   à PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySqlCommand selectQuery)
[23:02:42 91] InnerException: System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu 54.215.148.52:3306
   à System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
   à MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   à MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   à MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   à MySql.Data.MySqlClient.NativeDriver.Open()
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Xia0_Xia0*:

 

So I was trying to install this addon today and it went smooth.. sort of

23 tables were made in my database but not all of the got updated.

 

the only 2 tables that got some sort of records are chatlog and playerdata

 

then I got an error in procon saying this:

 

[01:04:14 36] Error: Error in Startstreaming:

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

[01:04:14 36] Native: -2147467259

[01:04:14 36] Source: MySql.Data

[01:04:14 36] 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()

[01:04:14 37] Error: Error in UpdateRanking: 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.UpdateRanking ()

[01:04:15 29] 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()

stats logging is on and chat logging is on

am I missing anything?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Prophet731*:

 

Hello

I have this error , can you help me ?

 

Code: 

Error: SQLQuery:
[23:02:42 91] Message: Unable to connect to any of the specified MySQL hosts.
[23:02:42 91] Native: -2147467259
[23:02:42 91] Source: MySql.Data
[23:02:42 91] StackTrace:    à MySql.Data.MySqlClient.NativeDriver.Open()
   à MySql.Data.MySqlClient.Driver.Open()
   à MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   à MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   à MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   à MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   à MySql.Data.MySqlClient.MySqlPool.GetConnection()
   à MySql.Data.MySqlClient.MySqlConnection.Open()
   à System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   à System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   à System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   à System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   à PRoConEvents.CChatGUIDStatsLoggerBF3.SQLquery(MySqlCommand selectQuery)
[23:02:42 91] InnerException: System.Net.Sockets.SocketException: Une tentative de connexion a échoué car le parti connecté n'a pas répondu convenablement au-delà d'une certaine durée ou une connexion établie a échoué car l'hôte de connexion n'a pas répondu 54.215.148.52:3306
   à System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
   à MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   à MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   à MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   à MySql.Data.MySqlClient.NativeDriver.Open()
That error is saying it couldn't connect to your database. Check your database settings to make sure they are correct.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Prophet731*:

 

So I was trying to install this addon today and it went smooth.. sort of

23 tables were made in my database but not all of the got updated.

 

the only 2 tables that got some sort of records are chatlog and playerdata

 

then I got an error in procon saying this:

 

 

 

stats logging is on and chat logging is on

am I missing anything?

It looks like when the plugin created the tables some of them weren't fully setup. If you don't have any data or very little I suggest you delete all those tables and run the plugin again to create the tables again. That should possibly fix your problem.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by rasvib*:

 

That error is saying it couldn't connect to your database. Check your database settings to make sure they are correct.

Hello,

I checked and stats are uploaded to db, but since last night i get this message from time to time.

 

 

Sent from my iPhone using Tapatalk

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Prophet731*:

 

Hello,

I checked and stats are uploaded to db, but since last night i get this message from time to time.

 

 

Sent from my iPhone using Tapatalk

Then the plugin must be losing connection with the mysql server. Thats what the error is telling you. If its happening on occasion.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by rasvib*:

 

Hello,

I made a request here showthread....ed-to-mysql-db*

Hope i'm in the good thread for asking this.

Do you think its possible to add a feature that reserve slots for a TopX player depending on a sql request, and add the option of time/day when the plugin should update the reserved slots.

And a list for admin.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by 24Flat*:

 

Hi xp I have been running your plugin for quite a while with no issues, I implemented [bF3] Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger' Everything works great but the page does not show when people are in the server.

 

ty_ger07 replied

Do you have XpKiller's PRoCon stats plugin set to update current players data? It's an option in his plugin, which if disabled, won't save current players to the database.

I don't see this setting in your Stats.. Logger. I'm running 1.0.1.0 any help would be greatly appreciated
* Restored post. It could be that the author is no longer active.
Link to comment
  • 4 weeks later...
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Hutchew*:

 

It doesn't work. Been there, tried that. It's got to be a bug with the way the plugin checks for the CountryCode and submits it to MySQL. I don't have the resources to go through all 8500 lines of code and decipher someone else's coding. Maybe the devs can step in and shed some light on a fix.

 

I've even tried increasing the VARCHAR character limit to 5 on the table structure to allow for the "N/A" to be inserted but it still throws an error and crashes.

 

Edit:

 

Ok, so the fix is to set both the table playerdata and currentplayers CountryCode VARCHAR limit to 7+. What happens when a player is not in the GeoIP.dat file, is the plugin logs the CountryCode as unknown. Obviously originally setting the field to allow only 5 chars didn't work because the word unknown has 7 letters therefore causing the plugin to throw the error. See here:

 

http://i.imgur.com/J4uuC7G.jpg

 

Hope this helps.

Just bringing this back to the top of the pile. Had this issue again when torture testing ADKATS on a fresh DB, causing our layers to crash. ADKATS was not the cause of our problems; since applying this fix, layers are now stable.

 

Hutchew

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ColColonCleaner*:

 

Just bringing this back to the top of the pile. Had this issue again when torture testing ADKATS on a fresh DB, causing our layers to crash. ADKATS was not the cause of our problems; since applying this fix, layers are now stable.

 

Hutchew

If the underlying issue wasn't AdKats could you please reply in that thread saying such? Thanks :smile:
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ColColonCleaner*:

 

Hey killer, suggesting a 4 line addition to your plugin. Simply to add a registered name with procon so other plugins can know if stat logger is installed and running on the current layer. I am currently using the connected database to get this information, but having another layer of confirmation would be nice.

 

private MatchCommand LoggerAvailableIndicator;

this.LoggerAvailableIndicator= new MatchCommand("BF3ChatGUIDStatsandMapstatsLogger", "NoCallableMethod", new List(), "BF3ChatGUIDStatsandMapstatsLogger_NoCallableMetho d", new List(), new ExecutionRequirements(ExecutionScope.None), "Useable by other plugins to determine whether this logger is installed and enabled.");

 

//Register a command to indicate availibility to other plugins on enable

this.RegisterCommand(this.LoggerAvailableIndicator );

 

//Unregister command on disable

this.UnregisterCommand(this.LoggerAvailableIndicat or);

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by ty_ger07*:

 

Hi xp I have been running your plugin for quite a while with no issues, I implemented [bF3] Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger' Everything works great but the page does not show when people are in the server.

 

ty_ger07 replied

 

I don't see this setting in your Stats.. Logger. I'm running 1.0.1.0 any help would be greatly appreciated

BTW, he found out that the problem was that he was using an old plugin version.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Shakal-hh*:

 

can someone help?

 

[18:36:04 27] BF3 Chat, GUID and Stats Logger Enabled

[18:36:04 27] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[18:36:07 19] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:07 19] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:10 94] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:10 94] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:10 95] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[18:36:20 94] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:20 94] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[18:36:20 95] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

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

System.Security.Permissions.SecurityPermission

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

MyComputer

--- Ende der internen Ausnahmestapelüberwachung ---

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

EDIT:

done. have tested the "beta" version and it works

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by _lecro_*:

 

Anyone know how i can work out maximum number of queries to our SQL server the plugin requires at any one time ?

is it dependant on the number of players or is it just one for the whole plugin and just reading/writing when it needs to.

 

The reason i ask is every few days we are getting errors

after flushing hosts all is good for a few days then they come back again.

 

For E.G

 

16:29:30 66] Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Host '81.**.***.**' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

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

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.CreateNewPooledCo nnection()

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

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

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

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
  • Author
Posted

Originally Posted by Porthos1973*:

 

Does anyone know of a host that offers this set up with the hosting? I use to use www.rconhostingservices.net but it looks like the site is being maintained anymore and now response letting them the order page isn't working. They offered the layer and set this plugin up as well as the stats page so made it real easy.

* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing


  • Our picks

    • EZRCON Update (9/4/2021)

      Prophet731 posted a topic in News,

      Game Server Hosting:

      We're happy to announce that EZRCON will branch out into the game server provider scene. This is a big step for us so please having patience if something doesn't go right in this area. Now, what makes us different compared to other providers? Well, we're going with the idea of having a scaleable server hosting and providing more control in how you set up your server. For example, in Minecraft, you have the ability to control how many CPU cores you wish your server to have access to, how much RAM you want to use, how much disk space you want to use. This type of control can't be offered in a single service package so you're able to configure a custom package the way you want it.

      You can see all the available games here. Currently, we have the following games available.

      Valheim (From $1.50 USD)


      Rust (From $3.20 USD)


      Minecraft (Basic) (From $4.00 USD)


      Call of Duty 4X (From $7.00 USD)


      OpenTTD (From $4.00 USD)


      Squad (From $9.00 USD)


      Insurgency: Sandstorm (From $6.40 USD)


      Changes to US-East:

      Starting in January 2022, we will be moving to a different provider that has better support, better infrastructure, and better connectivity. We've noticed that the connection/routes to this location are not ideal and it's been hard getting support to correct this. Our contract for our two servers ends in March/April respectively. If you currently have servers in this location you will be migrated over to the new provider. We'll have more details when the time comes closer to January. The new location for this change will be based out of Atlanta, GA. If you have any questions/concerns please open a ticket and we'll do our best to answer them.
      • 5 replies
      Prophet731

      Picked By

      Prophet731,

    • EZRCON Update 5/13/2021

      Prophet731 posted a topic in News,

      Hello All,

      I wanted to give an update to how EZRCON is doing. As of today we have 56 active customers using the services offered. I'm glad its doing so well and it hasn't been 1 year yet. To those that have services with EZRCON, I hope the service is doing well and if not please let us know so that we can improve it where possible. We've done quite a few changes behind the scenes to improve the performance hopefully. 

      We'll be launching a new location for hosting procon layers in either Los Angeles, USA or Chicago, IL. Still being decided on where the placement should be but these two locations are not set in stone yet. We would like to get feedback on where we should have a new location for hosting the Procon Layers, which you can do by replying to this topic. A poll will be created where people can vote on which location they would like to see.

      We're also looking for some suggestions on what else you would like to see for hosting provider options. So please let us know your thoughts on this matter.
      • 4 replies
      Prophet731

      Picked By

      Prophet731,

    • Procon Version 1.5.3.5 Released

      Prophet731 posted a topic in News,

      Added ability to disable the new API check for player country info


      Updated GeoIP database file


      Removed usage sending stats


      Added EZRCON ad banner



      If you are upgrading then you may need to add these two lines to your existing installation in the file procon.cfg. To enable these options just change False to True.

      procon.private.options.UseGeoIpFileOnly False
      procon.private.options.BlockRssFeedNews False



       
      • 2 replies
      Prophet731

      Picked By

      Prophet731,

    • Procon, Database & BFACP Hosting

      Prophet731 posted a topic in News,

      I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 11 replies
      Prophet731

      Picked By

      Prophet731,

    • Procon Version 1.5.3.4 Released

      Prophet731 posted a topic in News,

      I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 9 replies
      Prophet731

      Picked By

      Prophet731,
    View All
×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.