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

[ImportBot]

Originally Posted by Frakkas*:

 

I am getting a lot of uninitialized RoundStart and RoundEnd times in my tbl_mapstats, and my session time always starts out negative. I am using a server offset of -2, and it's always close to -116 minutes or something like that, so perhaps one time is initialized with the offset and the other is not.

Any ideas what this problem might be? (apologies for posting three issues in one post earlier, here there are just the two ;-) )

 

And by a lot, I mean effectively all the end times, and a few start times. Most of the map load times seem valid.

[ImportBot]

Originally Posted by XpKiller*:

 

I will check this time issue. I think your guess is right.

[ImportBot]

Originally Posted by kycu*:

 

hello,

 

I have error, what's that mean?

 

Error: 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.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

I have using linux hosting, that's good ?

[ImportBot]

Originally Posted by CptChaos*:

 

hello,

 

I have error, what's that mean?

 

 

 

I have using linux hosting, that's good ?

As far as I can see you're MySQL-server does not allow remote host to put things into a database. Change your MySQL config, so that it isn't bound to connections from 127.0.0.1 / localhost, usually found in my.cnf.

 

This can be done in two ways: you add the remote host as a trusted host or you open MySQL for all external connections (when you're behind a NAT and rerouted port 3306 this could be a security issue, otherwise it wouldn't hurt much.

[ImportBot]

Originally Posted by Geordie_Ben*:

 

hi guys,

 

has anyone got this error?

 

[18:36:54 55] Error in Tablebuilder:

[18:36:54 55] Index #0

[18:36:54 55] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[18:36:54 55] Native: 0

[18:36:54 55] Source:

[18:36:54 55] SQL: IM002

 

My host allows remote connections as far as im aware, what am i missing?

 

Regards,

Geordie

[ImportBot]

Originally Posted by XpKiller*:

 

@kycu

Your procon sandbox is enabled and blocking you outgoing connections.

Go Tools --> Options --> Plugins --> Databases --> Allow outgoing connections or disable the sandbox.

If you dont have access to your procon layer server you need to ask you hoster.

 

@CptChaos

his error is not a SQL error. It is an error of the sandbox. Plugin tries to connect to the db which is not allowed by default.

 

@Geordie_Ben

And again this issue has been asked countless times...

You ODBC Driver on the procon host is missing/not configured.

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

 

The chapter: MySQL Connector/ODBC Installation and Configuration

[ImportBot]

Originally Posted by Geordie_Ben*:

 

Hey XPKiller,

 

I have just asked my host to set this up, he said everything was tested successfully with the settings i ave him to my remote mysql, but i still seem to be having the exact same error. Only this time the weapon list loads, where as before it didn't

[ImportBot]

Originally Posted by Frastatic*:

 

Hey, I'm new to these stuff. I've followed the instructions, I do get no error messages ect. But when I do !Rank for example nothing shows up at all.

[ImportBot]

Originally Posted by beantje*:

 

@lupri

you need a mysql database to run this plugin.

 

@beantje

if you webspace contains a mysqldb (in most cases it will) you can run this plugin if the mysql server allows external connections.

 

@Frakkas

The FAMAS is in the lastest bf3.def, which comes with procon (version 1.1.3.1)

You procon layer properly has an old version of the bf3.def file.

it hase a mysqldb but how do i check if it allows external connections ?

 

thx

[ImportBot]

Originally Posted by beantje*:

 

it hase a mysqldb but how do i check if it allows external connections ?

 

thx

i tryed and i get this

 

[20:16:38 59] BF3 Chat, GUID and Stats Logger Enabled

[20:16:38 59] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[20:16:50 77] Error in Tablebuilder:

[20:16:50 77] Index #0

[20:16:50 77] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[20:16:50 77] Native: 0

[20:16:50 78] Source:

[20:16:50 78] SQL: IM002

[ImportBot]

Originally Posted by XpKiller*:

 

@beantje

You ODBC Driver is not installed or not configured.

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

 

The chapter: MySQL Connector/ODBC Installation and Configuration

[ImportBot]

Originally Posted by beantje*:

 

@beantje

You ODBC Driver is not installed or not configured.

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

 

The chapter: MySQL Connector/ODBC Installation and Configuration

it wont work with mine, i rent a website and that hase directadmin en phpmyadmin, ...

[ImportBot]

Originally Posted by ty_ger07*:

 

it wont work with mine, i rent a website and that hase directadmin en phpmyadmin, ...

Ask your server host to do it.

[ImportBot]

Originally Posted by GitSum*:

 

it wont work with mine, i rent a website and that hase directadmin en phpmyadmin, ...

usually you have to allow external connections if you web site has it's own phpmyadmin. Look for something like "remote mysql"

[ImportBot]

Originally Posted by Kretius*:

 

it wont work with mine, i rent a website and that hase directadmin en phpmyadmin, ...

You set up remote connetcions in direct admin:

MySQL Management > Click ont the databasename

At the bottom you can add new hosts that you allow to connect to the database.

Either add the IP of your ProCon-host or use % to allow all remote connections.

[ImportBot]

Originally Posted by beantje*:

 

You set up remote connetcions in direct admin:

MySQL Management > Click ont the databasename

At the bottom you can add new hosts that you allow to connect to the database.

Either add the IP of your ProCon-host or use % to allow all remote connections.

thx i just done this so now i need to MySQL Connector/ODBC Installation and Configuration hope this works

[ImportBot]

Originally Posted by beantje*:

 

first problem, this wont work

 

if i want to connect i get an error connection failed

[ImportBot]

Originally Posted by XpKiller*:

 

first problem, this wont work

 

if i want to connect i get an error connection failed

http://www.phogue.net/forumvb/showth...ll=1#post36544*

 

Btw phpmyadmin is no remote sql connection.

[ImportBot]

Originally Posted by GitSum*:

 

It sounds like he has a regular host for a web site - and it comes with phpmyadmin, etc.

 

If it is one of the bigger hosting companies, he should have a control panel entry for remote connections - I am thinking that is his problem

[ImportBot]

Originally Posted by Kretius*:

 

it wont work with mine, i rent a website and that hase directadmin en phpmyadmin, ...

DirectAdmin is probably the control panel he uses.

I've already posted how to set up remote connection in it.

[ImportBot]

Originally Posted by CptChaos*:

 

@Beantje:

If the host allows it you can set a trusted remote host with DirectAdmin. I am not familiar enough with it to tell you how to do it.

If it doesn't succeed, ask your hoster to set a trusted remote host for you.

 

@Beantje:

Ik vermoed dat je een Nederlander bent, dus doe bovenstaande ook even in het Nederlands, is vast makkelijker voor je wellicht?

Je kan als het goed is via DirectAdmin een remote host instellen voor MySQL, probeer dus even in de MySQL instellingen te kijken van DirectAdmin. Mocht het niet lukken, neem dan even contact op met de hoster.

[ImportBot]

Originally Posted by Froz3nTundra*:

 

Hi, I'm starting out as a new server admin in BF3, I've since set up the database, installed the driver and have all the appropriate settings in options set, but I get this error:

 

[16:29:34 87] Error in Tablebuilder:

[16:29:34 87] Index #0

[16:29:34 87] Message: [MySQL][ODBC 5.1 Driver]Unknown MySQL server host 'gng.site.nfoservers.com' (2)

[16:29:34 87] Native: 2005

[16:29:34 87] Source:

[16:29:34 87] SQL: HY000

[16:29:34 87] Index #1

[16:29:34 87] Message: [MySQL][ODBC 5.1 Driver]Unknown MySQL server host 'gng.site.nfoservers.com' (2)

[16:29:34 87] Native: 2005

[16:29:34 87] Source:

[16:29:34 88] SQL: HY000

[ImportBot]

Originally Posted by GitSum*:

 

are you allowing external connections to your database (it looks like it is at NFO - and they have an option you have to check)

[ImportBot]

Originally Posted by Froz3nTundra*:

 

are you allowing external connections to your database (it looks like it is at NFO - and they have an option you have to check)

Yes but I've since found out I used wrong host, I'm using "hosted2.nfoservers.com" and it now seems to work with no apparent errors.

[ImportBot]

Originally Posted by beantje*:

 

hi,

 

i asked my host to do it and they did but now wen i type !rank nothing happens ?

[ImportBot]

Originally Posted by XpKiller*:

 

Do you have any logs ? Otherwise I can't help you. Also a screenshot of your settings would be helpful too. Remember to blackout you Password before posting.

[ImportBot]

Originally Posted by ToM666*:

 

Does this mysql database need to be online?

I've installed the connector on my hard drive but cant seem to do anything with it?

[ImportBot]

Originally Posted by GitSum*:

 

Does this mysql database need to be online?

I've installed the connector on my hard drive but cant seem to do anything with it?

Yes

 

Some game servers also come with free web space - that will usually work

 

There are some free web development program that would let you host the database on your own computer if you wanted to, but the database needs to have internet access

 

Take a look at >>> The Uniform Server

[ImportBot]

Originally Posted by XpKiller*:

 

Does this mysql database need to be online?

I've installed the connector on my hard drive but cant seem to do anything with it?

you could install a local mysql server.

[ImportBot]

Originally Posted by ToM666*:

 

you could install a local mysql server.

Cool, I have just been onto our website provider and apparently I have unlimited databases.

 

Now all I have to do is figure out what to do with them.

 

I'm looking at them now in the host control panel.