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

[ImportBot]

Originally Posted by staazvaind*:

 

  MorpheusX(AUT)* said:

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

told them that. they said "they let everything through".

...

 

redit everything, complete procon install the third time .- error remains

 

my database is definitely working...

[ImportBot]

Originally Posted by ty_ger07*:

 

  staazvaind* said:

told them that. they said "they let everything through".

...

 

redit everything, complete procon install the third time .- error remains

They let everything through? I doubt that from a security standpoint.

 

Anyway, regardless of what they let through, PRoCon will not let everything through unless specifically authorized. The procon.cfg file on the layer host needs to be edited to specifically allow a connection. So regardless of what theor servers security settings are, procon.cfg needs to be properly edited.

[ImportBot]

Originally Posted by staazvaind*:

 

  ty_ger07* said:

They let everything through? I doubt that from a security standpoint.

i doubt that too

 

ok, exact quote was: "we dont block any of your connections to your database"

 

 

how would the procon.cfg entry look like exactly for xxx.xxx.xxx.xxx:3306 ?

p.s. when i use the search function i get on an older phogue.net version and every hit is not linked to the new version of the forums.

[ImportBot]

Originally Posted by ty_ger07*:

 

  staazvaind* said:

i doubt that too

 

ok, exact quote was: "we dont block any of your connections to your database"

 

 

how would the procon.cfg entry look like exactly for xxx.xxx.xxx.xxx:3306 ?

p.s. when i use the search function i get on an older phogue.net version and every hit is not linked to the new version of the forums.

You need to stop the layer server first, then edit procon.cfg.

 

It would look like this:

  Quote

procon.private.options.trustedHostDomainsPorts xxx.xxx.xxx.xxx 3306

Note: No colon ( : ) between the IP and port.

 

Also, may not be required for this plugin, but is sometimes required for other plugins:

 

Disable sandbox:

  Quote

procon.private.options.runPluginsInSandbox False

Save the file, and start the layer again.

 

Hope that helps.

[ImportBot]

Originally Posted by staazvaind*:

 

thank you !

 

i will forward it

[ImportBot]

Originally Posted by staazvaind*:

 

their answer was "we wont disable the sandbox. it would be a too high security risk"...

 

no word about letting through the ip :tongue:ort... ... -.-

 

i think i read in here that game!d was sucha good provider for procon? ... damn

[ImportBot]

Originally Posted by ty_ger07*:

 

What the!?

 

Can't you just do it yourself? I thought most hosts let you edit procon.cfg via the host's web control panel or FTP account.

[ImportBot]

Originally Posted by XpKiller*:

 

add the host/ip and port to the thrusted hosts would be enough. The sandbox dont need to be disabled.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

  ty_ger07* said:

What the!?

 

Can't you just do it yourself? I thought most hosts let you edit procon.cfg via the host's web control panel or FTP account.

This would allow adding more servers too. Most of the large hosters I know of either don't allow you to modify that file at all, or just via webinterface/custom editor or support.

 

EDIT: as XpKiller said: ask them to add your database host + port to the trusted hosts (or do it yourself, not 100% sure if they allow editing the file anymore)

[ImportBot]

Originally Posted by XpKiller*:

 

so far i know you have no access to the procon.cfg file at gamed. So you need to ask the support. Anyway it is ridiculous that they offer you a database you cant use because they are not willing to add their OWN host to the trusted hosts.

[ImportBot]

Originally Posted by dyfuzor*:

 

  Quote

Error: getUpdateServerID1: System.OverflowException: Arithmetic operation resulted in an overflow.

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)

hello what I need improve?

[ImportBot]

Originally Posted by ty_ger07*:

 

Have you verified that the MySQL database password is set up to use new password encryption? Old password encryption is deprecated and is one of the things which will cause an "Arithmetic operation resulted in an overflow." error.

[ImportBot]

Originally Posted by dyfuzor*:

 

and how to check it out because I'm completely green

[ImportBot]

Originally Posted by Hondo*:

 

Hi Guys,

 

I just got this setup but having some issues. Rank or Stats command doesnt seem to work at all, I keep getting the message that stats aren't available. Wait for the end of the round. I also get the following error time to time.

 

[23:37:51 41] Message: Cannot add or update a child row: a foreign key constraint fails (`clansod0_serverstats`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[23:37:51 41] Native: -2147467259

[23:37:51 41] Source: MySql.Data

[23:37:51 42] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[23:37:56 42] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLoggerBF3.DisplayMySqlE rrorCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

 

 

Can anyone please help.

 

Thanks

[ImportBot]

Originally Posted by XpKiller*:

 

@Hondo

Which MySQL version?

 

Do you using a suffix?

[ImportBot]

Originally Posted by arunas*:

 

do we need suffix?

[ImportBot]

Originally Posted by arunas*:

 

im getting the same error

[ImportBot]

Originally Posted by XpKiller*:

 

no please dont use a suffix

[ImportBot]

Originally Posted by arunas*:

 

but how to fix this thing...

[20:17:24 62] Error: Error in Startstreaming:

[20:17:24 62] Message: Cannot add or update a child row: a foreign key constraint fails (`sid84669_1`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_playerdata` FOREIGN KEY (`PlayerID`) REFERENCES `tbl_playerdata` (`PlayerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[20:17:24 62] Native: -2147467259

[20:17:24 62] Source: MySql.Data

[20:17:24 62] 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()

[ImportBot]

Originally Posted by Hondo*:

 

  XpKiller* said:

@Hondo

Which MySQL version?

 

Do you using a suffix?

Hi Mate,

 

I logged on cpanel and it it says Server version: 5.5.28-29.3-log (MySQL)

 

I'm not sure what you mean by suffix though mate.

 

Thanks,

Hondo

[ImportBot]

Originally Posted by arunas*:

 

so anyone knows how to fix this thing, i tried alot ways to fix but it seems i dont know how, tried clean installiation of plugin and diferent mysql`s and it same everywhere... it worked yesterday, it happened today ...

[ImportBot]

Originally Posted by ty_ger07*:

 

To me, it looks like some necessary data was changed / deleted in your database or was corrupted and is causing a foreign key constraint error. You may want to try creating a new empty database and if that works, consider abanodoning your old database and forgetting about retreiving your old data. :S

[ImportBot]

Originally Posted by arunas*:

 

i deleted all data in mysql, dropped eeverything, then script added new database, and im getting same error as he cant add server to the database... so realy dont know whats wrong

[ImportBot]

Originally Posted by ty_ger07*:

 

  arunas* said:

i deleted all data in mysql, dropped eeverything, then script added new database, and im getting same error as he cant add server to the database... so realy dont know whats wrong

Try this:

1) Disable the BF3 BF3 Chat, GUID, Stats and Mapstats Logger plugin.

2) Stop the PRoCon layer (if you use one) or close your local PRoCon client program.

3) Create a new database.

4) Start PRoCon layer (if you use one) or open your local PRoCon client.

5) Do not enable BF3 BF3 Chat, GUID, Stats and Mapstats Logger plugin yet.

6) Make sure that the BF3 BF3 Chat, GUID, Stats and Mapstats Logger plugin settings are correct for the new database before starting the plugin.

7) Start the BF3 BF3 Chat, GUID, Stats and Mapstats Logger plugin.

 

I'm not claiming to be as knowledgeable as XpKiller since it is his plugin, but I think you should try this in a thorough manner for troubleshooting purposes.

 

I personally have noticed that if I change database data with the plugin disabled, and then enable the plugin, the database table builder does not seem to function correctly. It seems that stopping the running PRoCon process completely is required prior to changing to a new database or clearing out your current database data. Otherwise, the table builder does not seem to function correctly which can lead to foreign key constraint issues.

[ImportBot]

Originally Posted by arunas*:

 

everything is working i fixed the problem, the problem was when creating a database need to make sure you create new database in utf8, problem solved!

 

http://stats.wfan.lt works like harm!

[ImportBot]

Originally Posted by Hondo*:

 

  arunas* said:

everything is working i fixed the problem, the problem was when creating a database need to make sure you create new database in utf8, problem solved!

 

http://stats.wfan.lt works like harm!

Can you please tell me where exactly you change this setting?

 

in PHPMyAdmin it says my SQL Server Collation is already set to utf8_general_ci

 

I'm not sure how to check if individual databases have the correct collation set.

[ImportBot]

Originally Posted by webster*:

 

Been having a nightmare the last few days trying to get this to work I hope someone can help, I have been trying to connect to my db on Hostgator hosting but keep getting an authentication error. When I spoke to their support I was told that MySQL ODBC Driver is not supported on their shared hosting.

 

I saw a couple of posts on this thread where people are using hostgator so do they no a work around for this? Or does anyone know of any shared hosting companies that do support this feature?

 

Thanks

[ImportBot]

Originally Posted by ty_ger07*:

 

The MySql ODBC connector driver used to be required on the machine where PRoCon was running from. It had nothing to do with the database host. It isn't even needed anymore with the last couple versions of this plugin.

 

What sort of issues are you having?

[ImportBot]

Originally Posted by webster*:

 

  ty_ger07* said:

The MySql ODBC connector driver used to be required on the machine where PRoCon was running from. It had nothing to do with the database host. It isn't even needed anymore with the last couple versions of this plugin.

 

What sort of issues are you having?

Oh really? I dont have a clue why its not working then, I have spent an hour with support and they couldn't figure it out and my procon host branzone.com says there isnt anything blocking it from their side.

 

This is the error i get

 

[17:48:18 59] Error in Tablebuilder:

[17:48:18 59] Message: Authentication method 'mysql_old_password' not supported by any of the available plugins.

[17:48:18 59] Native: -2147467259

[17:48:18 59] Source: MySql.Data

[17:48:18 59] 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( )

 

I know it says mysql_old_password but hostgator says they are using the new type.

[ImportBot]

Originally Posted by maester*:

 

HostGator is who I am using also receiving the same error. They are claiming it has something to do with the plugin and not them. Tried deleting the database and making a new one still receiving an issue.