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

[ImportBot]

Originally Posted by diabolik1973*:

 

Hi I had a Procon layer rent and your plugin worked perfectly!

Now I have installed it on my server and the plugin don't work.

Code:

[16:12:05 50] BF3 Chat, GUID and Stats Logger Enabled
[16:12:05 50] BF3 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[16:12:07 52] Error: System.TypeInitializationException: L'inizializzatore di tipo di 'MySql.Data.MySqlClient.MySqlPoolManager' ha generato un'eccezione. ---> System.Security.SecurityException: Richiesta di autorizzazione di tipo 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' non soddisfatta.
   in MySql.Data.MySqlClient.MySqlPoolManager..cctor()
Azione non riuscita:
LinkDemand
Tipo della prima autorizzazione non riuscita:
System.Security.Permissions.SecurityPermission
Area dell'assembly con errori:
MyComputer
   --- Fine dell'analisi dello stack dell'eccezione interna ---
   in MySql.Data.MySqlClient.MySqlPoolManager.GetPool(MySqlConnectionStringBuilder settings)
   in MySql.Data.MySqlClient.MySqlConnection.Open()
   in PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[16:12:07 53] Error: System.NullReferenceException: Riferimento a un oggetto non impostato su un'istanza di oggetto.
   in PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

When i start procon it say me:

Code:

Battlelog Cache] EXCEPTION: Invalid value for MySQL Port: ''. Must be number between 1 and 65535!

I have now procon and mysql server in the same server; I tried to delete the database and recreate it but no way

Help me please

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

When i start procon it say me:

Code:

Battlelog Cache] EXCEPTION: Invalid value for MySQL Port: ''. Must be number between 1 and 65535!

I have now procon and mysql server in the same server; I tried to delete the database and recreate it but no way

Help me please

The best and probably most accurate guess is that you haven't entered a MySQL Port in the plugin's settings.

[ImportBot]

Originally Posted by XpKiller*:

 

@diabolik1973

 

turn off the sandbox or add you databasehost to the trusted hosts.

[ImportBot]

Originally Posted by maester*:

 

@Morpheus read your PM

 

My procon layer is hosted at gameservers.com

Website/Mysql with HostGator

 

I put in the

IP

Port

Database

User

Password

 

When enabling I receive this error

 

[13:53:51 40] Error in Tablebuilder:

[13:53:51 40] Message: Authentication method 'mysql_old_password' not supported by any of the available plugins.

[13:53:51 40] Native: -2147467259

[13:53:51 40] Source: MySql.Data

[13:53:51 40] 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.MySqlPool.CreateNewPooledCo nnection()

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.tablebuilder( )

[13:53:51 40] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

Also receiving this same error with Battlelog Cache. When contacting the provider they claim they are already running the new authentication. Any help or suggestions would be appreciated.

 

Things I have tried

Changing Password

New Database

Disabling Sandbox

[ImportBot]

Originally Posted by webster*:

 

@Morpheus read your PM

 

My procon layer is hosted at gameservers.com

Website/Mysql with HostGator

 

I put in the

IP

Port

Database

User

Password

 

When enabling I receive this error

 

 

 

Also receiving this same error with Battlelog Cache. When contacting the provider they claim they are already running the new authentication. Any help or suggestions would be appreciated.

 

Things I have tried

Changing Password

New Database

Disabling Sandbox

I dont suppose you have had any luck fixing this yet have you? I have tried everything to get it to work with hostgator but cant. I have even changed procon host 3 times and always the same error.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

I dont suppose you have had any luck fixing this yet have you? I have tried everything to get it to work with hostgator but cant. I have even changed procon host 3 times and always the same error.

That's because it's an error with the MySQL-databases hosted by Hostgator, not any Procon-related stuff. Hostgator is using databases with the old/obsolete authentification mechanism. Unless they update this for you, you will not be able to use their databases.

[ImportBot]

Originally Posted by diabolik1973*:

 

The best and probably most accurate guess is that you haven't entered a MySQL Port in the plugin's settings.

The plugin config is right, I just changed the ip adapting it to my private server. (127.0.0.1)

My mysql database user has the proper permissions on the local machine

The plugin worked perfectly on the Procon layer that I had for rent

[ImportBot]

Originally Posted by diabolik1973*:

 

@diabolik1973

 

turn off the sandbox or add you databasehost to the trusted hosts.

I have add my databasehost to the trusted hosts (127.0.0.1)

[ImportBot]

Originally Posted by XpKiller*:

 

@Webster

You could use the Version 1.0.1.0. That Version still uses the ODBC Driver, which is supporting the old Password mechanism.

 

Changes in MySQL Connector/Net 6.6.3 (2012-09-28)

[ImportBot]

Originally Posted by maester*:

 

HostGator wants info on how this plugin works

 

"Hello,

 

We are happy to assist you with your request today.

 

I would suggest contacting the software developers for support as they are likely familiar with common issues.

 

If you would like to provide us with the steps you are taking that generate the error we would be happy to take a closer look. We need to be able to produce the error for troubleshooting purposes.

 

Include any relevant URL's, username's and password along with detailed directions of what steps we need to take to produce the error. This will help us expedite your request.

 

Thanks"

What should I tell them?

[ImportBot]

Originally Posted by maester*:

 

HostGator has refused to fix the issue.

 

Hi Wayne,

 

Our servers are, indeed, configured to use mysql's old authentication hashes:

 

old_passwords=1

 

Unfortunately, this is not something that we can change on our shared server environment since doing so would affect other users. Can the developer use a different mysql connector to connect to the server?

[ImportBot]

Originally Posted by XpKiller*:

 

i cant switch it out. Its not im my hands because the connector is embedded into procon.

So you need to stay on the odbc version of the plugin.

[ImportBot]

Originally Posted by maester*:

 

Sounds good. But does that mean GameServers (Hosting Layer) would have to be using the ODBC?

[ImportBot]

Originally Posted by ty_ger07*:

 

Sounds good. But does that mean GameServers (Hosting Layer) would have to be using the ODBC?

Yes.

 

:S

 

You are between a rock and a hard place.

[ImportBot]

Originally Posted by ty_ger07*:

 

HostGator has refused to fix the issue.

Perhaps you should try to present it to them as a disservice to their customers for them to not be concerned about the security of their customers. There has to be a very good reason why the password encryption algorithm has been changed to be made more secure.

 

Also, the sooner they get it over with, the better. The longer they wait, assuming that their customer base is increasing and not decreasing, the harder it will be for them to change the password encryption method. Since this is an issue with the .NET connector requiring the new password encryption method, it is an "issue" which cannot be "fixed" for any .NET applications. Your database host just needs to catch up with the evolution or be left behind.

 

What they should do:

Change the password encryption method from the old method to the new method and send an email to every customer telling them that they need to reset their password.

[ImportBot]

Originally Posted by maester*:

 

Perhaps you should try to present it to them as a disservice to their customers for them to not be concerned about the security of their customers. There has to be a very good reason why the password encryption algorithm has been changed to be made more secure.

 

Also, the sooner they get it over with, the better. The longer they wait, assuming that their customer base is increasing and not decreasing, the harder it will be for them to change the password encryption method. Since this is an issue with the .NET connector requiring the new password encryption method, it is an "issue" which cannot be "fixed" for any .NET applications. Your database host just needs to catch up with the evolution or be left behind.

 

What they should do:

Change the password encryption method from the old method to the new method and send an email to every customer telling them that they need to reset their password.

I did exactly this today and there response

 

Hello,

 

I apologize for the inconvenience. It is something that we are considering but we are unable to provide a time line of when the changes will be made.

 

We do offer VPS and dedicated servers that can be setup to have this feature disabled if you are interested in them

[ImportBot]

Originally Posted by TimSad*:

 

Hey, as you know there is this ongoing PB issue. Right now I have a few of my servers set to unranked and PB disabled but the stats aren't recording. It gets new content for the playerdata table but for some reason playerstats aren't recording. Is this something to do with running unranked? If so, how would I make it to where it starts recording stats?

[ImportBot]

Originally Posted by XpKiller*:

 

I'm aware of that. I can post some code to fix that.

[ImportBot]

Originally Posted by TimSad*:

 

If it is something of a quick and easy fix for you, sure. Otherwise, it's nothing to worry about too much. It can definitely wait until PB/Ranked is restored.

[ImportBot]

Originally Posted by ty_ger07*:

 

Is it only the newest versions of this plugin which have this unranked stats recording issue? The reason I ask is because this stats plugin is recording unranked stats just fine for me. But I am using a modified version of version 1.0.1.0 due to my ongoing concerns with the native ADO MySQL Connector in the newer versions.

[ImportBot]

Originally Posted by ty_ger07*:

 

BTW, it looks like PB enabled BF3 servers may be allowing connections again.

[ImportBot]

Originally Posted by ronin*:

 

so if i use this ver CChatGUIDStatsLoggerBF3[1.0.1.0] it should work with the old auth ver still ? .

[ImportBot]

Originally Posted by ty_ger07*:

 

Version 1.0.1.0 uses the old ODBC connector method which requires that the ODBC driver be installed on the PRoCon layer server.

 

I found that version more stable than version 1.1.0.0. But I am scared and haven't tested version 1.1.0.1 which includes stability improvements for the new DB connector.

 

Like I said, version 1.0.1.0 is allowing unranked stats logging for me whereas it sounds like the newer versions may not. But, it sounds like XpKiller is going to solve that issue shortly so it may be a mute point.

 

If you do use version 1.0.1.0, the current players in the server will not be saved to the database unless you modify that version to include that functionality. See: myrcon.net/...chat-guid-stats-and-mapstats-logger#entry8081

[ImportBot]

Originally Posted by XpKiller*:

 

if 1.0.1.0 is working 1.1.0.0 and 1.1.0.1 should work as well. The relevant code is nearly the same.

[ImportBot]

Originally Posted by ty_ger07*:

 

I could be entirely wrong. I am pretty sure unranked stats is working for me. But someone else should verify on their servers since our unranked server is currently empty.

[ImportBot]

Originally Posted by ronin*:

 

After talking to hostgator they told me that unless the persons ip is added the the whitelist then you would get the errors so my advice is either add the persons ip or % and this should work altho i have not had a chance to test this on mine yet as my server is down .

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

After talking to hostgator they told me that unless the persons ip is added the the whitelist then you would get the errors so my advice is either add the persons ip or % and this should work altho i have not had a chance to test this on mine yet as my server is down .

Wait, this is getting confusing, since you're splitting it into two threads... Are you still talking about this problem: myrcon.net/...server-stats-page-for-xpkillers-bf3-chat-guid-stats-and-mapstats-logger#entry23373

 

If yes: from the screenshot I guess you are using cPanel to manage your databases. If I recall correctly, there's an option for "remote MySQL Databases" or something, which allows you to add IPs to a whitelist, which then have permission to access your MySQL-Database. You would probably have to add the IPs of your procon-layer-servers to this whitelist in order to allow plugins to write to it. If you're also hosting the server stats page, you will have to add the IPs of the webservers running this one too (which can get problematic if your customers are hosting them on their own server).

[ImportBot]

Originally Posted by ronin*:

 

I thort they related basicly to the same problem if not my bad . I am using hostgator and after opening up the whitelist its all working good now as far as i can tell .

[ImportBot]

Originally Posted by maester*:

 

I thort they related basicly to the same problem if not my bad . I am using hostgator and after opening up the whitelist its all working good now as far as i can tell .

Which version are you using ronin? I can't get the newest to work because of the authentication password issue.

[ImportBot]

Originally Posted by ronin*:

 

Well i thort i had it fixed turns out i was wrong im now getting this error

 

Code:

[10:41:27 19] Error in Tablebuilder: 
[10:41:27 19] Index #0
[10:41:27 19] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[10:41:27 19] Native: 0
[10:41:27 19] Source: 
[10:41:27 19] SQL: IM002
[10:41:27 19] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

Is IM002 meaning the odbc deiver is not install properly ?

 

Thanks Wayne