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

[ImportBot]

Originally Posted by Fynn13*:

 

Hi, I already found the table creation scripts but I'm getting confused with some of the variables used, could you pls provide a "create table" scripts for web hosting install?

[ImportBot]

Originally Posted by XpKiller*:

 

@Fynn13

The plugin create the tables by itself so no need for a table script.

 

@dyfuzor

so far i know gameserver.com dont install this ODBC Driver so you not able to use this plugin.

 

@Matt-One

 

I have an idea what could cause such an error atm im trying to reproduce it.

[ImportBot]

Originally Posted by Matt-One*:

 

@Matt-One

 

I have an idea what could cause such an error atm im trying to reproduce it.

Well thank u...if u need something just ask me and i will try it

[ImportBot]

Originally Posted by Vetula*:

 

hey

 

Hab mal eine frage , und zwar auf deiner ToDo Liste steht :

 

new features (LiveView)

 

Was meinst du denn damit genau ? welche Spieler gerade on sind wieviele Points ?

[ImportBot]

Originally Posted by gabipaci*:

 

XpKiller, have u any idea, log to database the players, who try start our server?

Log players, and play time, whos join to server until start the logger plugin (we have set player request 4 atm)

 

Regards

[ImportBot]

Originally Posted by Athlon*:

 

Is it possible to merge 2 databases from the same month? (I have direct access to the Mysql).

 

I didn't realize the plugin kept them apart automatically, so I created two databases, one for each of our servers.

[ImportBot]

Originally Posted by Athlon*:

 

I'm seeing an error:

 

Code:

[13:01:55 98] BF3 Chat, GUID and Stats Logger Disabled
[13:02:04 55] BF3 Chat, GUID and Stats Logger Enabled
[13:02:04 55] BF3 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[13:02:06 64] Error in Tablebuilder: 
[13:02:06 64] Index #0
[13:02:06 65] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]ALTER command denied to user 'xxx'@'localhost' for table 'tbl_playerstats'
[13:02:06 65] Native: 1142
[13:02:06 65] Source: myodbc5.dll
[13:02:06 65] SQL: HY000

Other than this error the plugin seems to be working fine. Should I be concerned? (I replaced the actual user name with 'xxx'.)

[ImportBot]

Originally Posted by Matt-One*:

 

I'm seeing an error:

 

Code:

[13:01:55 98] BF3 Chat, GUID and Stats Logger Disabled
[13:02:04 55] BF3 Chat, GUID and Stats Logger Enabled
[13:02:04 55] BF3 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[13:02:06 64] Error in Tablebuilder: 
[13:02:06 64] Index #0
[13:02:06 65] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]ALTER command denied to user 'xxx'@'localhost' for table 'tbl_playerstats'
[13:02:06 65] Native: 1142
[13:02:06 65] Source: myodbc5.dll
[13:02:06 65] SQL: HY000

Other than this error the plugin seems to be working fine. Should I be concerned? (I replaced the actual user name with 'xxx'.)

it seems the user xxx doesn't have all the permission...is he admin?

[ImportBot]

Originally Posted by Athlon*:

 

it seems the user xxx doesn't have all the permission...is he admin?

Yes, and the plugin is working fine otherwise. This error shows one time when I first activate the plugin.

[ImportBot]

Originally Posted by Athlon*:

 

Whoops - I just checked. It may not be working. Let me test some more and report back here.......

[ImportBot]

Originally Posted by gabipaci*:

 

XpKiller, can u check the CountryCode column?

Some missing. Can u fix it please?

 

Attached Files:

• database.jpg

[ImportBot]

Originally Posted by krov7*:

 

Hi, I would like for my PlayerMessage line for when someone types !stats to read this: John is rank 4 of 9001 and taken 5 dogtags. This is the code I have right now, but it obviously doesn't work because that's not the right code.

%playerName% is rank %playerRank% of %allRanks% and taken %Weapon% dogtags

 

in game, if I type !stats melee , then I can get a separate line for melee to show up but I can't get it to work in the PlayerMessage because I don't know (if it exists) the command that would show melee stats, something like %WeaponMelee%

[ImportBot]

Originally Posted by XpKiller*:

 

@gabipaci

"--" is the code for unknown.

This means procon could not find the country related to the ip address in the geoip.dat file.

So this is no error ofd the plugin.

 

@krov7

atm this is not possible but its a good point for the to do list theoretical it is possible.

[ImportBot]

Originally Posted by Matt-One*:

 

ehy XpKiller any news about this : My Problem * ? Could this problem be associed to a crash of the server or a mass kick of PB to all the players? Or it's a bug? Thank u..

[ImportBot]

Originally Posted by XpKiller*:

 

@Matt-One

Basically your problem can occure if the endofround event is fired twice by procon.

I will change a few thing which properly avoid such problems.

[ImportBot]

Originally Posted by Athlon*:

 

it seems the user xxx doesn't have all the permission...is he admin?

That was it. Someone inadvertently changed something.

 

Thank you.

[ImportBot]

Originally Posted by gabipaci*:

 

@gabipaci

"--" is the code for unknown.

This means procon could not find the country related to the ip address in the geoip.dat file.

So this is no error ofd the plugin.

If i change the original GeoIp.dat for newer, will be ok?

[ImportBot]

Originally Posted by Matt-One*:

 

@Matt-One

Basically your problem can occure if the endofround event is fired twice by procon.

I will change a few thing which properly avoid such problems.

THank u so much, i will wait for a new version, i use ultimate map manager so if other people that doesn't use UMM don't have the crash problem so i think my problem is UMM

[ImportBot]

Originally Posted by Neliscornelis*:

 

sometimes i have this in my procon log:

 

[04:00:54 99] Error: SQLQuery:

[04:00:55 01] Index #0

[04:00:55 02] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10048)

[04:00:55 02] Native: 2003

[04:00:55 02] Source:

[04:00:55 02] SQL: HY000

[04:00:55 04] Index #1

[04:00:55 04] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10048)

[04:00:55 04] Native: 2003

[04:00:55 04] Source:

[04:00:55 06] SQL: HY000

 

 

Found some info on this:

 

Code:

When connecting to a MySQL database through ODBC the following error is generated:

    ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10048)

The precise presentation of this error may vary according to the software used, this wording was generated from an ASP.NET application.

Other symptoms:

    The application has previously been able to successfully connect to the database.
    Waiting a minute or so, and the application can connect again without the error.
    The error seems to manifest itself under "stress" conditions, when lots of connections are being made opened and closed in a short space of time (minutes).

These notes only apply to the error above when the "other symptoms" are present.
Cause

The error is caused not by MySQL or the MySQL ODBC driver, but by the behaviour of Windows. For performance reasons Windows maintains a connection on a TCP port after it is closed for (by default) 4 minutes. The advantage of this is that if the connection needs to be reopened it can be done at a lower cost. The trouble is that under heavy load when lots of connections are opened and closed to the database, the system can hit a limit on the maximum number of connections allowed (even though as far as the application is concerned these connections have been closed).
Resolution

    To decrease the delay before Windows releases an open TCP connection, use regedit to edit the following registry value of:

    HKLM\
      SYSTEM\
        CurrentControLSet\
          Services\
           Tcpip\
            Parameters\
              TcpTimedWaitDelay

    This value does not exist by default and will need to be created. It should be a DWORD. The valid range is 0x1E - 0x12C (30seconds to 300 seconds), the default is 0xF0 (240 seconds).

    Decreasing the value of TcpTimedWaitDelay should help, but is unlikely to permanently solve the problem for a busy system (because if the system is busy the limits will still be hit).
    Consider whether it is possible to modify the application to re-use database connections instead of closing and reopening them.

    In theory enabling connection pooling would address this problem. For more information about connection pooling see http://support.microsoft.com/default.aspx_scid=kb;EN-US;q169470. To enable connection pooling for the MySQL driver:
        Start > Control Panel > Administrative Tools > Data Sources (ODBC).
        This will open up the "ODBC Data Source Administrator".
        On the "Connection Pooling" tab, double click the ODBC Driver you are using to connect to MySQL.
        This will open up the "Set Connection Pooling Attributes" dialog.
        To enable pooling select "Pool Connections to this driver"

 

 

EDIT: I did above and will wait for the results.. I let you know.

 

All is hosted on (procon and mysql) localhost. Also, when i join i see my welcome stats.. but if other ppl join that were before on server i dont see there welcome stats.. Sometimes i see them but most of the time not.. Is it just showing the first 10 players or something?

[ImportBot]

Originally Posted by XpKiller*:

 

@Neliscornelis

 

i cant believe that you hit some kind of connection limit because than all those PRoCon hoster would have Trouble too.

 

I think it is much more realistic that you mysql server just was not running/or too busy ( You got erorrcode 2003)

http://dev.mysql.com/doc/refman/5.5/...to-server.html

 

Enable the Connection Pool should solve the Windows connection handling.

[ImportBot]

Originally Posted by greybl00d*:

 

@XpKiller

 

i set up database etc and when i turn on plugin i get the following error

 

Error: System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b7[-----]089' failed.

at System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.PermissionSet.Demand()

at System.Data.Common.DbConnectionOptions.DemandPermi ssion()

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

at System.Data.Odbc.OdbcConnectionFactory.PermissionD emand(DbConnection outerConnection)

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

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

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

The action that failed was:

Demand

The type of the first permission that failed was:

System.Data.Odbc.OdbcPermission

The Zone of the assembly that failed was:

MyComputer

 

is this a firewall issue at the procon hoster side ? I allready raised ticket ot make sure ODBCDriver is installed

 

 

thx in advance

 

grey

[ImportBot]

Originally Posted by darkeingel*:

 

Hello all,

 

It is possible to install and get this working on a procon layer that is hosted on gameservers.com?

 

Thanks,

Alex.

[ImportBot]

Originally Posted by Matt-One*:

 

Hello all,

 

It is possible to install and get this working on a procon layer that is hosted on gameservers.com?

 

Thanks,

Alex.

No u can't because they doesn't got ODBC Driver installed on their layer

[ImportBot]

Originally Posted by Quax*:

 

Since the last version I have this error:

 

[00:30:46 82] Error: Error in Startstreaming:

[00:30:46 84] Index #0

[00:30:46 85] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.18]Out of range value for column 'Playtime' at row 1

[00:30:46 85] Native: 1264

[00:30:46 86] Source: myodbc5.dll

[00:30:46 86] SQL: HY000

 

 

I'll set the plugin on TRACE mode just to give you more info. Maybe tomorrow....

[ImportBot]

Originally Posted by XpKiller*:

 

No trace needed the error clear enough.

Is sessions on ? And the option to save them to DB.

Also please check which datatype this column has in your DB.(tbl_playerstats)

Do have a player account on your server which just idle on it .

[ImportBot]

Originally Posted by Quax*:

 

No trace needed the error clear enough.

Is sessions on ? And the option to save them to DB.

Also please check which datatype this column has in your DB.(tbl_playerstats)

Do have a player account on your server which just idle on it .

[ImportBot]

Originally Posted by Quax*:

 

So I have testet some settings (within the plugin & the DB) but nothing changed.

After I have found the Versio 1.0.0.1 and reinstalled it on our layer, anything ist working correctly.

Unfortunatly it is definetiv a bug of the current version (1.0.0.3).

 

Regards Quax

[ImportBot]

Originally Posted by XpKiller*:

 

If there would be a bug in Version 1.0.0.3 it would be 1.0.0.1 too because the streaming hasnt changed.

The only thing could be the the plugin try to insert a negative value.

Also you are the only one who has such an error yet.

[ImportBot]

Originally Posted by Quax*:

 

Of course it tries to insert negative values for the playtime.

But I don't know why? I saw it in the trace mode....

[ImportBot]

Originally Posted by Quax*:

 

Of course it tries to insert negative values for the playtime.

But I don't know why? I saw it in the trace mode....