Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by SinBad-OTF*:

 

Where would I be able to find a listing/manage the PBGUID bans from Procon?

 

XPKiller, what's the chance of getting the EAGUID data sent to the MySQL database.

 

Thanks,

Sinbad

[ImportBot]

Originally Posted by LumpyNtZ*:

 

Any advice what should i do with this:

 

Code:

Error in SQLQuery: System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   at System.Security.PermissionSet.Demand()
   at System.Data.Common.DbConnectionOptions.DemandPermission()
   at System.Data.Odbc.OdbcConnection.PermissionDemand()
   at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)
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

Have been trying and trying to fix this, but cant do nothing...

[ImportBot]

Originally Posted by XpKiller*:

 

Have you added your mysql server to the allowed odbc list?

[ImportBot]

Originally Posted by LumpyNtZ*:

 

So, im not a techhead, so if u just could explain me a little of that ODBC. Where to add that ODBC thingy :_: I have added IP´s in my remotesql list and things- :?

[ImportBot]

Originally Posted by Phogue*:

 

So, im not a techhead, so if u just could explain me a little of that ODBC. Where to add that ODBC thingy :_: I have added IP´s in my remotesql list and things- :?

In procon go to Tools -> Options -> Plugins. Enable outgoing ODBC connections

[ImportBot]

Originally Posted by PaprTargt*:

 

How do you get access to the logs? does the plugin have a viewer to look at them? I think it would be great to store the logs, and I'm looking at renting a mysql database hosting so I can do this. But I need to know how to access them so I can view the logs and read them easily.

[ImportBot]

Originally Posted by LumpyNtZ*:

 

So, im not a techhead, so if u just could explain me a little of that ODBC. Where to add that ODBC thingy :_: I have added IP´s in my remotesql list and things- :?

In procon go to Tools -> Options -> Plugins. Enable outgoing ODBC connections

Ok now i got all of these done, and still getting exactly same error. After getting this error 2times in a row it crashes my whole Procon Layer. More advices?

 

And it doesnt create any tables in my database :_:

 

Edit: So, primarytarget.com is hosting my layer, and im not sure if they have ODBC allowed so maybe im gonna confirm that before we continue this :mad:ops:

Any guys there who knows that do they allow it or not?

[ImportBot]

Originally Posted by XpKiller*:

 

How do you get access to the logs? does the plugin have a viewer to look at them? I think it would be great to store the logs, and I'm looking at renting a mysql database hosting so I can do this. But I need to know how to access them so I can view the logs and read them easily.

you could use phpmyadmin or mysqlworkbench

[ImportBot]

Originally Posted by Garak*:

 

So, im not a techhead, so if u just could explain me a little of that ODBC. Where to add that ODBC thingy :_: I have added IP´s in my remotesql list and things- :?

In procon go to Tools -> Options -> Plugins. Enable outgoing ODBC connections

Ok now i got all of these done, and still getting exactly same error. After getting this error 2times in a row it crashes my whole Procon Layer. More advices?

 

And it doesnt create any tables in my database :_:

 

Edit: So, primarytarget.com is hosting my layer, and im not sure if they have ODBC allowed so maybe im gonna confirm that before we continue this :mad:ops:

Any guys there who knows that do they allow it or not?

I am wondering the same thing, we were moved from PHS (where we had a database) to Primary Target who do not provide this service, so I got our web server setup via our GSP Hypernia using phpMyadmin to carry out this function.

 

I setup the MySQL database and followed the steps but I have run into the same error as LumpyNtZ, kinda miffed tbh if it is Primary Target preventing the connection... let me know if you find out.

[ImportBot]

Originally Posted by cruz777*:

 

I am running mySql at freesqldatabase.com

Host: freesqldatabase.com

Port: 3306

I installed the 5.1 connector on my remote computer where Procon is

 

I get the following error

Error in SQLQuery: System.Data.Odbc.OdbcException

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

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

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

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

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

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

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

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

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

[ImportBot]

Originally Posted by XpKiller*:

 

Hi

I never saw this error message make sure that your connectiondata to the Database server is correct I also try to investigate what this problem causes.

[ImportBot]

Originally Posted by PaprTargt*:

 

I'm getting a weird problem/bug. when I run the plugin and the map changes, it crashes sorta. My procon on MY computer logs out of all the servers we run and won't come back up for at least 30 seconds. If i turn off the plugin it works fine. When I turn it off I get this

 

CChatGUIDStatsLogger.DisablePlugin(): Object reference not set to an instance of an object.

 

So what do ya'll think is going on?

[ImportBot]

Originally Posted by XpKiller*:

 

Hello

I think I know this bug but I can't fix it because all my critical code parts are in try and catch blocks like all database operations.

when the round end the write back to the database starts.

I guess this is a problem caused by procon. I noticed this since version 4. 1. 8.

The only thing you can do is check your database connection and user.

[ImportBot]

Originally Posted by micovery*:

 

This is all just guessing.

 

Maybe it is that when the Plugin crashes, the object instance (actual memory allocated for the object with "new") is lost instead of going through the normal garbage collection process. After this happens, PRoCon probably still holds an object reference pointing to that now invalid memory location . When you click on disable, PRoCon still thinks the plugin is running just normally, and calls the "DisablePlugin" method of the object (through the invalid reference). However, the object is not actually there anymore. (looks similar to a SEGV in C).

 

If there is an exception thrown, it would be easy to safeguard that section of the code with try-catch, and avoid PRoCon crash.

[ImportBot]

Originally Posted by XpKiller*:

 

CChatGUIDStatsLogger.DisablePlugin(): Object reference not set to an instance of an object.

 

This Error is fixed in next Version BUT it does not cause the crash of procon.

 

All critical Sections are in try-catch-finally( like the DB Actions)

[ImportBot]

Originally Posted by Feltz*:

 

We enable the ODBC on request. It is not activated by default. If we can find a template way of making this plugin work we will be able to put it into our knowledgebase to assist other customers on trying to get this plugin working.

 

I do know we have installed the Connector and to this point thats it.

[ImportBot]

Originally Posted by PaprTargt*:

 

With Feltz help and some judicious switching of things. I have finally gotten one of my servers on this plugin. I'll have to as Primary Target tomorrow if they have to setup each layer or if they are all run from one. Because the other two won't load up the database.

 

And the way I finally got it to work was to add the hostname and the IP address to the list.

[ImportBot]

Originally Posted by Garak*:

 

We enable the ODBC on request. It is not activated by default. If we can find a template way of making this plugin work we will be able to put it into our knowledgebase to assist other customers on trying to get this plugin working.

 

I do know we have installed the Connector and to this point thats it.

Thanks for the info

[ImportBot]

Originally Posted by PaprTargt*:

 

Okay, It had been working fine for some time. We had someone leave the clan and I had to change the database user password. Ever since then I'm getting this error and its not storing stuff in the database all the time.

 

 

Error in SQLQuery: System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' 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.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

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

 

 

Any ideas_?

[ImportBot]

Originally Posted by XpKiller*:

 

Looks like ODBC Permissions in ProCon are wrong

or the Password.

But i think it is the first one.

[ImportBot]

Originally Posted by PaprTargt*:

 

Thanks XpKiller, got it taken care of it was the permissions like you said.

[ImportBot]

Originally Posted by Repoman1*:

 

Started getting this error after the Ver. 0.6.0.6

 

Code:

[20:17:30 04] Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver]User ragining_21st already has more than 'max_user_connections' active connections
ERROR [HY000] [MySQL][ODBC 5.1 Driver]User ragining_21st already has more than 'max_user_connections' active connections
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)
[20:17:30 07] Error GetID: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at PRoConEvents.CChatGUIDStatsLogger.GetID(String strSoldierName)

[ImportBot]

Originally Posted by XpKiller*:

 

As phogue said plugins will break from a update to 6.0.6.0.

I'm currently on the way to work so I will be back home in about 9 hours.

[ImportBot]

Originally Posted by EBassie*:

 

As phogue said plugins will break from a update to 6.0.6.0.

I'm currently on the way to work so I will be back home in about 9 hours.

I think your plugin still works without a problem... at least I got no troubles...

 

I think there lies you problem:

User ragining_21st already has more than 'max_user_connections' active connections

[ImportBot]

Originally Posted by Repoman1*:

 

I has been working fine until the update.

[ImportBot]

Originally Posted by XpKiller*:

 

I test my plugin on the new Procon and i have no errors.

 

Where do you have you DB?

 

I think you hoster just lowered the number of allowed connections.

[ImportBot]

Originally Posted by Phogue*:

 

No changes have been made to the way procon handles plugins from 0.5 to 0.6.0.6, aside from backing up settings if a plugin fails to compile. The expected plugin changes will occur in 0.6.1.

[ImportBot]

Originally Posted by Zaeed*:

 

a) how many servers are you logging with this plugin?

[ImportBot]

Originally Posted by Coldgas*:

 

I don't know if this is a known "bug" but some entries in my db have no "LastSeenOnServer" data. Someone else already had that problem?

 

Everything else works fine!

[ImportBot]

Originally Posted by XpKiller*:

 

Hi

I know this issue it is already fix in my beta version.

At the moment i improve the useage the dbconnect to need lesser connections to the db server.

Also a new feature will added called dogtag tracking which allows the player to see from which players and how many dogtags he collected on the server.