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

[ImportBot]

Originally Posted by BLAZE*:

 

Since the R20 update I'm not connecting to my DB anymore. My webstats page still is so I know its not my DB. But I get no errors. I'm also running a BC2 server with this Procon with the database on the same server with no problems. I have updated to 1.0.0.4 but it still things I'm new and says I have to play one round when I @stats in game. Any Ideas?

[ImportBot]

Originally Posted by XpKiller*:

 

@EBastard

Good find

On my list.

I placed the duration at the wrong place

 

@Blaze

There are no changes made from Version 1.0.0.3 to 1.0.0.4 how the plugin uses the db.

 

Pls turn on trace and post the logs here.

[ImportBot]

Originally Posted by ty_ger07*:

 

I finally updated this plugin.

 

I was scared to do it before because of some minor issues in some earlier versions and I felt that I had found a perfectly good version. Well, I finally updated because I wanted to try out the newer faster version.

 

Now I have an error:

 

[22:59:42 33] Error: Error in UpdateRanking:

[22:59:42 35] Index #0

[22:59:42 35] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.0.92-log]Table 'bf3serverstats.tbl_playerrank' doesn't exist

[22:59:42 35] Native: 1146

[22:59:42 35] Source: myodbc5.dll

[22:59:42 35] SQL: 42S02

Now, I know you don't recommend using table suffixes, but I am. It appears that your rank query is not adding the table suffix to the table name. The table name should be tbl_playerrank_32 not tbl_playerrank.

 

I will try fixing the problem for myself in a bit.

 

 

EDIT: The fix.

 

Line 5825

Used to read: string sqlInsert = @"INSERT INTO tbl_playerrank (PlayerID, ServerGroup)

Now reads: string sqlInsert = @"INSERT INTO " + this.tbl_playerrank + @" (PlayerID, ServerGroup)

[ImportBot]

Originally Posted by ty_ger07*:

 

Here is another ugly error, but it seems to be completely harmless.

 

[23:56:20 35] Error: Error in Startstreaming: System.InvalidOperationException: ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.

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

This error appears when the server ends warm-up. When the warm-up time ends, the round sort of restarts (but not a real restart), and your plugin complains.

 

I think it is completely harmless.

[ImportBot]

Originally Posted by ty_ger07*:

 

My PRoCon layer was randomly hanging at least once a day. Disabling chat logging seems to have fixed that problem.

 

I assume that the server where my database is hosted wasn't liking so much constant activity. Either that, or too much activity from your plugin causes the layer to hang. I assume it is my web server though.

[ImportBot]

Originally Posted by XpKiller*:

 

@ty_ger07 thanks for those reports.

 

In general the lastest version is the most stable version, due i solved those layer crashed cause be odbc errors.

 

Those layer hangs you are talking about.

The layer is still up you cant connect to right?

This is a common error in PRoCon, which is not related to any plugin. Nobody knows what causes this so far i know.

[ImportBot]

Originally Posted by ty_ger07*:

 

Those layer hangs you are talking about.

The layer is still up you cant connect to right?

This is a common error in PRoCon, which is not related to any plugin. Nobody knows what causes this so far i know.

Yes, that was the behavior.

 

After I disabled chat logging, the layer didn't misbehave for over a day. But maybe it was just a coincidence.

[ImportBot]

Originally Posted by XpKiller*:

 

you will get this error even on mono with no plugins installed its just a matter of time.

[ImportBot]

Originally Posted by Flaxe*:

 

Tried this plugin some weeks ago but couldn't get it to work, probably me just failing with the settings

 

I would need to know where to find a good database to connect the plugin to. Is there any way to use any free host database or do the database itself need ODBC installed, from what I can see with most hosts, ODBC is not installed.

Our Procon Layer is hosted together with our BF3 Servers by Fragnet, so it's nothing we're hosting by ourselves.

 

Would appreciate any help!

[ImportBot]

Originally Posted by XpKiller*:

 

@Flaxe

The ODBC Driver needs to be installed on the PRoCon Host and not on the Database.

The Database must just be connect-able for plugin.

[ImportBot]

Originally Posted by Panther*:

 

If i start Procon normal, i have no problems. I tried it as windows service and i get these Errors. Any idea?

 

Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[11:07:42] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben

bei System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

bei System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

bei System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConn ection outerConnection, OdbcConnectionString connectionOptions)

bei System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

bei System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

bei System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

bei System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

bei System.Data.Odbc.OdbcConnection.Open()

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@Panther

Do you have created a UserDSN or SystemDSN.

 

To solve this Problem create a SystemDSN or change the user with which the service is running.

In my howto the the Service is running under the Systemuser.

[ImportBot]

Originally Posted by Panther*:

 

Thanks,

service is running as Systemuser. I am not sure yet what UserDSN/SystemDSN is and where to change it. I guess this is something i have to do in the ODBC driver settings? At this moment System and User DSN is completely empty. There is nothing written in this fields.

 

I tried to enter the database into SystemDSN and i was able to press test and it wrote "Connected".

 

 

But still, i get the errors.

[ImportBot]

Originally Posted by XpKiller*:

 

i setup a user and system DSN.

I have no such errors. Do entered it in the 32bit version of the ODBC datasource administrator?

[ImportBot]

Originally Posted by Panther*:

 

hm, good queation, i used the one undet start-admin tools. i ll have to check it later. The name of the databaseconecter is not inportant or is it? i just entered anything

[ImportBot]

Originally Posted by XpKiller*:

 

the name should be unimportant.

If go start-admin tool you will get the 64bit version

[ImportBot]

Originally Posted by ty_ger07*:

 

Xpkiller, i see it is just the nature of the beast.

 

Thank you!

[ImportBot]

Originally Posted by Panther*:

 

Hey, i have found the 32bit Version under sysWOW64. I have edited this one too.

Strange thing, if i open the SystemDSN it tells me i have no Adminrights and that i cant modify SystemDNS.

But i still can add one. This happend to me also when i tried to edit the 64bit version.

 

But at the 32bit version, there are alot more drivers i can use to connect to a database. Which is the correct one?

 

EDIT:

I have allways till now only udpated the 64bit version, because my server is a 64bit. After you telling me, that i should edit the odbc32bit i realized, that there is only the odbc driver 3.1

 

I installed the 5.1 odbc 32bit driver and was able to choose this driver in SystemDSN and UserDSN of the 32bit admintool.

 

Long story short, it is working now .

[ImportBot]

Originally Posted by XpKiller*:

 

PRoCon needs the 32bit version i think because it is a 32bit.

I hate this odbc thing anyway i which i could use the native mysql connector.

[ImportBot]

Originally Posted by Panther*:

 

Just in case if ppl get the same error as i did. Tell em that they need to update the 32bit version of ODBC to 5.1 and use this configurator:

%systemdrive%\Windows\SysWoW64\Odbcad32.exe

Not the one used under Start -> Admintools -> Data..(ODBC)

[ImportBot]

Originally Posted by Kinsman*:

 

Just thought people might like a good laugh.

 

So I setup this plugin, got lots of errors about having no INNODB, reconfigured mysql server to include INNODB, started over and it all just seemed to work, bit surprising for me really.

 

So imagine my consternation when I log into phpmyadmin, and I can't see any tables, what the_?

 

So I start over fresh, join the server, fiddle about abit, still no tables. Mmm, ok turn TRACE on, thats odd, it says all the tables are fine?

 

recheck myphpadmin, hey, wait a minute, theres a PAGE 2!!!!, and there are all the tables!!!!

 

In my defence I did ask for a prefix of "bf3", but they are all called table? so were on the second page.

 

Is it odd the prefix bit didnt work, or wont it matter?

[ImportBot]

Originally Posted by ammoniak007*:

 

Congratulations to all around for this plugin

 

This plugin interests me greatly but I understand nothing has are installation and configuration ...

I have though managed to install it on Procon, but I block level configuration and MySQL plugin

 

I have a MySQL database with a maximum size of 50MB.

Server version: 5.1.49-3

 

with the InnoDB Plugin

 

Can you help me to complete the installation?

 

Thank you for your help

 

PS: I work with Google traductor, thank you for forgiving

[ImportBot]

Originally Posted by XpKiller*:

 

@ammoniak007 pls write me a pm.

[ImportBot]

Originally Posted by Flo670*:

 

Hi

since a few days i get this error but i don't know how to fix it.

 

Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.6.4-m7-log]Lock wait timeout exceeded; try restarting transaction

bei System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

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

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@Flo670

Known Problem hopefully fixed in next release.

Reason for this error is one long transaction which block other transactions.

This transaction will be split up in next release.

 

The reason why the error appears is that the DB gets slower when is populated.

[ImportBot]

Originally Posted by Kinsman*:

 

Just curious, what was the reason behind not uising the MyIsam engine?

[ImportBot]

Originally Posted by XpKiller*:

 

Innodb is the new default engine since MySQL 5.5.

Myisam don't support transactions and foreign key constains.

Table joins are faster on innodb.

Myisam is not good for workloads with many update.

Myisam locks the whole table, innodb do rowlocking which allows a better performance with multiply server in the same DB.

 

The only real disadvantage of innodb in my opinion is that it needs more space on the HDD that myisam. But can compress the tablespace.

[ImportBot]

Originally Posted by Kinsman*:

 

thanks for the explanation, I'm a bit behind the times, but INNODB seems to be working well since I activated it.

 

btw could I grab a copy of your improved files for the webscript at all?

[ImportBot]

Originally Posted by derspeckle*:

 

thank you for your plugin I just started developing a nice stats and assignment page for my large server

http://bf3.ngz-server.de/

people love it. I already made 5 assignments, more to come!

[ImportBot]

Originally Posted by Flaxe*:

 

thank you for your plugin I just started developing a nice stats and assignment page for my large server

http://bf3.ngz-server.de/

people love it. I already made 5 assignments, more to come!

That site looks truly awesome. I suppose you won't release that one for the public?