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

[ImportBot]

Originally Posted by XpKiller*:

 

If you want to be 100% sure dump you DB first.

Anyway the plugin converts the tables automatically without any data loss.

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Hi,

Could post the error message ?

Please turn on the plugin log in procon. The plugin should write the error message there.

Without this error message it is hard to just guess what causes the problem.

I could image that the odbc driver is not installed or configured.

================================================== ======================================

Message: [MySQL][PBDC 5.1 Driver]Unknown MySQL server host' db405413498.db.1and1.com'(2)

 

I am a little confused as it was working before but not on this host.

 

Thanks

 

Andy

[ImportBot]

Originally Posted by XpKiller*:

 

your dns not correct.

 

I checked it with nslookup

Code:

nslookup db405413498.db.1and1.com
Server:         192.168.178.1
Address:        192.168.178.1#53

** server can't find db405413498.db.1and1.com: NXDOMAIN

How a vaild DNS looks like:

Code:

nslookup www.phogue.net
Server:         192.168.178.1
Address:        192.168.178.1#53

Non-authoritative answer:
www.phogue.net  canonical name = phogue.net.
Name:   phogue.net
Address: 184.173.9.38

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Hi,

 

I have sent you a message with the latest information.

Any advice is very much appreciated.

 

Strat

[ImportBot]

Originally Posted by Large_Pudding*:

 

================================================== ======================================

Message: [MySQL][PBDC 5.1 Driver]Unknown MySQL server host' db405413498.db.1and1.com'(2)

 

I am a little confused as it was working before but not on this host.

 

Thanks

 

Andy

1&1 doesn't allow odbc mate as their db's are behind a firewall.. explains in their faq's. I had to run a localhost wamp to get around this

Hope this helps

 

Regards

Pudd

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

1&1 doesn't allow odbc mate as their db's are behind a firewall.. explains in their faq's. I had to run a localhost wamp to get around this

Hope this helps

 

Regards

Pudd

Hi Pudding,

 

I found that out yesterday so I am now on a new host who does support it. www.generation-hosting.com

The error I get now is the connection is refused because of my username/IP Access Denied.. Has to be server side?

 

Losing the will to live now, over 40 hours trying so I give up.

 

I had it working on our old host without a single problem, so I don't know what to do now apart from give up.

 

Thanks for the advice but I don't want to run it from my own system as it does not run 24/7.

 

Kind Regards.

 

Strat

[ImportBot]

Originally Posted by XpKiller*:

 

Check if you password and user are correct.

Also your procon host address must be added to the allows hosts of the MySQL server.

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Check if you password and user are correct.

Also your procon host address must be added to the allows hosts of the MySQL server.

Can I ask how I can find the Procon host address? Or do you mean the machine or pc it is running on?

They have added my IP to their whitelist if this is what you mean?

 

Strat

[ImportBot]

Originally Posted by XpKiller*:

 

the mysql server a own whitelist foreach user too.

Also make sure that you dont have " or ' in your password

 

http://dev.mysql.com/doc/refman/5.1/...ing-users.html

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

the mysql server a own whitelist foreach user too.

Also make sure that you dont have " or ' in your password

 

http://dev.mysql.com/doc/refman/5.1/...ing-users.html

Thanks for the information, I have passed it to the host so that they can add the address to the white list.

 

Fingers crossed we can get this working....

 

Thanks

 

Strat

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Check if you password and user are correct.

Also your procon host address must be added to the allows hosts of the MySQL server.

I have just had an email from my host.

This is what they have said.

 

"I have allowed your IP both through our firewall and to our MySQL Database, given you the database information and host name, and created the database connection string for the PHP script, and wrote a custom php.ini for you. I am sorry, but troubleshooting the plugin is going to have be done with the plugin developers. There is nothing more I can do for you."

 

I don't think they know what they are doing so I have no idea what to do now?

 

Thanks

 

Strat

[ImportBot]

Originally Posted by XpKiller*:

 

Hello Strat,

 

a mysql user consists out of 3 things:

username

password

location

 

Your error message says that the connection is refused because of you credentials so the ODBC Drive is working correctly.

So the reason why you cant connect must be in the mysql server. A firewall would bring such an error.

On Pluginside: The only thing i could image would be that your password contains special chars.

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

Hello Strat,

 

a mysql user consists out of 3 things:

username

password

location

 

Your error message says that the connection is refused because of you credentials so the ODBC Drive is working correctly.

So the reason why you cant connect must be in the mysql server. A firewall would bring such an error.

On Pluginside: The only thing i could image would be that your password contains special chars.

Thanks for the information.

 

I spoke to the host and I have asked them to contact you directly.

From what I can make out they have added the Procon address, My IP so nothing should prevent the conection.

I just get the same error, telling me that the 5.1 ODBC can't connect.

 

It's not rocket science I am sure so with luck the host will get in touch and you can educate them on how to provide what they said was 100% available to provide. So far they have failed

 

Fingers crossed you can explain the simple logic to how the plugin works..

 

Cheers

 

Strat

[ImportBot]

Originally Posted by Matt-One*:

 

hello i installed the plugin but it seem to do nothing...in the console i got no errors only :

 

[01:35:07 43] BF3 Chat, GUID and Stats Logger Enabled

[01:35:07 43] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

 

the plugin created the table into mysql but when i join i don't receive any message or if i write command like !stats !rank etc. nothing happen..

 

I got my procon on Branzone and mysql on gameservers (with the free http give with the game server) i think GS got ODBC enabled or i think the table doesn't created, right?

 

I need to enable sandbox-mode? i only enable ODBC and put the server in the trusted line....Thank u for the help

[ImportBot]

Originally Posted by GitSum*:

 

1&1 doesn't allow odbc mate as their db's are behind a firewall.. explains in their faq's. I had to run a localhost wamp to get around this

Hope this helps

 

Regards

Pudd

I do not know anything about 1&1 hosting, but a quick google search on "Remote access to my SQL" turned up a FAQ on how to set it up. Looks like it may take some work, but it should work

As default, 1&1 dedicated Root servers come with the MySQL remote access disabled, this is for

security reasons, as it can be a security risk for the Server. If you would like to enable this

access it is done at your own risk and 1&1 take no responsibility for any damage cause as a result

of enabling this access.

>>> http://faq.1and1.co.uk/server/root_server/conf/10.html

[ImportBot]

Originally Posted by Matt-One*:

 

hello i installed the plugin but it seem to do nothing...in the console i got no errors only :

 

[01:35:07 43] BF3 Chat, GUID and Stats Logger Enabled

[01:35:07 43] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

 

the plugin created the table into mysql but when i join i don't receive any message or if i write command like !stats !rank etc. nothing happen..

 

I got my procon on Branzone and mysql on gameservers (with the free http give with the game server) i think GS got ODBC enabled or i think the table doesn't created, right?

 

I need to enable sandbox-mode? i only enable ODBC and put the server in the trusted line....Thank u for the help

 

EDIT : I did it..uploading a backup file i forget to put again the server into the trusted line in procon.cfg

[ImportBot]

Originally Posted by GitSum*:

 

hello i installed the plugin but it seem to do nothing...in the console i got no errors only :

 

[01:35:07 43] BF3 Chat, GUID and Stats Logger Enabled

[01:35:07 43] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

 

the plugin created the table into mysql but when i join i don't receive any message or if i write command like !stats !rank etc. nothing happen..

 

I got my procon on Branzone and mysql on gameservers (with the free http give with the game server) i think GS got ODBC enabled or i think the table doesn't created, right?

 

I need to enable sandbox-mode? i only enable ODBC and put the server in the trusted line....Thank u for the help

It usually takes until the end of a round for the actual stats to be available

 

Your procon is being hosted at Branzone - you should not have to change anything - they are already setup with ODBC. Just make sure your database is enabled for outside connections or sometimes called remote connections

[ImportBot]

Originally Posted by Matt-One*:

 

It usually takes until the end of a round for the actual stats to be available

 

Your procon is being hosted at Branzone - you should not have to change anything - they are already setup with ODBC. Just make sure your database is enabled for outside connections or sometimes called remote connections

You have been very quickly in your answer because i edited my post when u was writing to me eheheheh

 

However, thank u

[ImportBot]

Originally Posted by Matt-One*:

 

What kind of error is this? My server is crashed and return me this error in procon...

 

[20:07:03 74] Error: Error in Startstreaming: System.InvalidOperationException: OdbcConnection does not support parallel transactions.

at System.Data.Odbc.OdbcConnection.Open_BeginTransact ion(IsolationLevel isolevel)

at System.Data.Odbc.OdbcConnectionOpen.BeginTransacti on(IsolationLevel isolevel)

at System.Data.Odbc.OdbcConnection.BeginTransaction(I solationLevel isolevel)

at System.Data.Odbc.OdbcConnection.BeginTransaction()

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[20:07:03 96] Error: Error in Startstreaming: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

at System.Data.Odbc.OdbcConnection.SetStateExecuting( String method, OdbcTransaction transaction)

at System.Data.Odbc.OdbcCommand.ValidateConnectionAnd Transaction(String method)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[ImportBot]

Originally Posted by Neliscornelis*:

 

Hi,

 

I installed this plugin yesterday or something and it works great.. Just 1 thing.. The serverstats played time is on +-1500 days and the rounds are incorrect to.. I changed them manually but no avail. After the round is finished they go back to old stats.

 

So sumPlaytime and sumRounds are incorrect.. Maby more but that i dont know for sure...

 

Table: tbl_server_stats

1, 1146, 5596848, 4883.81, 21555, 18.8089, 4832, 4.2164, 21829, 19.048, 124, 0.108202, 50, 0.04363, 4337808, 3785.17, 2262, 1.97382

[ImportBot]

Originally Posted by chickenlips*:

 

OK, I'm obviously a complete noob, tried setting this up.. but getting errors which is crashing my procon.

 

I have a free website with GS, that has Innod access etc.

 

Ive followed the instructions but im getting crashes to procon ... Any help lol

[ImportBot]

Originally Posted by leibhold*:

 

It would crash if the database information is incorrect.

 

You need to check the access to the database from the system running procon.

 

More detail on your setup would be helpfull

[ImportBot]

Originally Posted by Matt-One*:

 

Nobody can help me with this? myrcon.net/...chat-guid-stats-and-mapstats-logger#entry7339

[ImportBot]

Originally Posted by dyfuzor*:

 

Hi since I'm a real noob at this, could someone tell me what to do with the farther

 

[13:53:58 81] Error in Tablebuilder:

[13:53:58 81] Index #0

[13:53:58 81] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[13:53:58 81] Native: 0

[13:53:58 81] Source:

[13:53:58 81] SQL: IM002

[ImportBot]

Originally Posted by XpKiller*:

 

@Matt-One

I need more informations about your procon setup.

It is could be a possible bug in the plugin. How often did you get this error?

 

@dyfuzor

You need to install an configure the Mysql ODBC Driver.

 

@chickenlips

More Infos please any error messages?

 

@Neliscornelis

Those all values are based on all players who were on you server.

Thats the reason why you having this high values.

[ImportBot]

Originally Posted by dyfuzor*:

 

where should I install?

[ImportBot]

Originally Posted by XpKiller*:

 

The ODBC Driver must be install and configured on the host which runs PRoCon.

www.phogue.net/forumvb/showth...-Configuration*

[ImportBot]

Originally Posted by Matt-One*:

 

@Matt-One

I need more informations about your procon setup.

It is could be a possible bug in the plugin. How often did you get this error?

I take my layer on Branzone (as u if i remember well), i don't know what kind of setup do u mean, i think the procon.cfg?

However, my game server crashed yesterday and the day before yesterday one time per day.

 

Code:

/////////////////////////////////////////////
// This config will be overwritten by procon.
/////////////////////////////////////////////
procon.private.window.position Normal 0 0 1024 768
procon.private.options.setLanguage "au.loc"
procon.private.options.chatLogging True
procon.private.options.consoleLogging True
procon.private.options.eventsLogging True
procon.private.options.pluginLogging True
procon.private.options.autoCheckDownloadUpdates True
procon.private.options.autoApplyUpdates True
procon.private.options.showtrayicon True
procon.private.options.minimizetotray False
procon.private.options.closetotray False
procon.private.options.allowanonymoususagedata False
procon.private.options.runPluginsInSandbox False
procon.private.options.allowAllODBCConnections True
procon.private.options.allowAllSmtpConnections False
procon.private.options.adminMoveMessage True
procon.private.options.chatDisplayAdminName True
procon.private.options.layerHideLocalPlugins True
procon.private.options.layerHideLocalAccounts True
procon.private.options.ShowRoundTimerConstantly True
procon.private.httpWebServer.enable False 27360 "0.0.0.0"
procon.private.options.trustedHostDomainsPorts http://grev.clanservers.com 3306
procon.private.servers.add "95.xxx.xxx.xxx" "xxxx" "xxxxx"
procon.private.servers.autoconnect "95.xxx.xxx.xxx" "xxxx"
procon.private.tcadmin.enableLayer "95.xxx.xxx.xxx" "xxxxx" "procon.branzone.com" "xxxxx" "PRoCon[%servername%]"
procon.private.tcadmin.setPrivileges "95.XXX.XXX.xxx" "xxxx" "XXXXX" xx7x7xx

Here u can find more info about the error :

 

[13:07:03] Error: Error in Startstreaming: System.InvalidOperationException: OdbcConnection does not support parallel transactions.

at System.Data.Odbc.OdbcConnection.Open_BeginTransact ion(IsolationLevel isolevel)

at System.Data.Odbc.OdbcConnectionOpen.BeginTransacti on(IsolationLevel isolevel)

at System.Data.Odbc.OdbcConnection.BeginTransaction(I solationLevel isolevel)

at System.Data.Odbc.OdbcConnection.BeginTransaction()

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

 

[13:07:03] Error: Error in Startstreaming: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

at System.Data.Odbc.OdbcConnection.SetStateExecuting( String method, OdbcTransaction transaction)

at System.Data.Odbc.OdbcCommand.ValidateConnectionAnd Transaction(String method)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreamin g()

[ImportBot]

Originally Posted by dyfuzor*:

 

and can get around it somehow, "The ODBC driver must be install and configured on the host Which runs ProCon." Gameservers.com inadvertently cause even the install

[ImportBot]

Originally Posted by Fynn13*:

 

how do I install the database_, I already have a webhost. I want my database to accessed 24/7, coz i dont want it to be hosted in my pc.