[HowTo] Run a PRoCon Layer (1.4.0.6) with Linux+mono

[ImportBot]

Originally Posted by XpKiller*:

 

Yea probably, its why it doesnt works for me .

I have this when I launch procon.console.exe

 

 

 

And I cant connect to the layer, procon says target computer has refused the connection...

I think you have missed something in step 6.

You should review that.

[ImportBot]

Originally Posted by JoseyWales*:

 

Hi,

I've moved a already set up instance from windows to a Debian vps, and all is well except for the BC2 chat/stats logger. I was hoping someone can shed some light on what is going on here...

 

I seem to be stuck in some kind of charset hell when it comes to using BC2 chat & statslogger

I'm using Debian stable (squeeze) on a vps, with mono 2.6.7 connector 2.1.11 (tried .8 .9 as well) & MySQL 5.1 on the same box.

 

At first, if I enabled the logger, the chat entries got filled with ____________________________________?

So, assuming defaults were already Latin1, I tried setting all charsets to UTF8 in my.conf with

 

/snip

[client]

default-character-set=utf8

 

/snip

[mysqld]

default-character-set=utf8

collation-server=utf8_general_ci

init-connect='SET NAMES utf8'

character-set-server=utf8

skip-character-set-client-handshake

 

/snip

[mysql]

default-character-set=utf8

------------------

I made a fresh db, started logging again, still the same.

so just pulling at strings really, I changed all references of Latin1 in CchatGUIDstatsLogger.cs to UTF8

This got me long strings of Asian/Chinese chars instead

 

 

So, what is going wrong here? Am i overlooking something silly? How to go about correcting this?

Thanks for any insight...

[ImportBot]

Originally Posted by TheHardest*:

 

I managed to get the Layer to run. And I can connect to it. But when I try to make it run as a service with the startup.sh nothing works.

It has to be something with the "mono-service2 -l:./proconservice.lock PRoCon.Service.exe".

 

 

I have:

CentOS 5.8

Mono JIT compiler version 2.10.8

Downloaded procon from the website today.

[ImportBot]

Originally Posted by XpKiller*:

 

could you post the contents of your procon directory

[ImportBot]

Originally Posted by TheHardest*:

 

These are the contents:

 

Configs

docs_licenses

GeoIP.dat

Ionic.Zip.Reduced.dll

Localization

Logs

Media

Plugins

procon_1.3.0.0.zip

PRoCon.Console.exe

PRoCon.Console.pdb

PRoCon.Core.dll

PRoCon.Core.pdb

PRoCon.exe

PRoCon.pdb

PRoCon.Service.exe

PRoCon.Service.pdb

PRoConUpdater.exe

PRoConUpdater.pdb

shutdown.sh

startup.sh

usage.xml

[ImportBot]

Originally Posted by XpKiller*:

 

With file permissions and groups please.

[ImportBot]

Originally Posted by TheHardest*:

 

I gave them 777 to see if it would work. But nothing.

 

 

EDIT 1

I added --debug to the startup.sh

 

Unhandled Exception: System.TypeInitializationException: An exception was thrown by the type initializer for Mono.Unix.Native.Syscall ---> System.DllNotFoundExc eption: libMonoPosixHelper.so

at (wrapper managed-to-native) Mono.Unix.Native.Syscall:_L_ctermid ()

at Mono.Unix.Native.Syscall..cctor () [0x00000] in :0

--- End of inner exception stack trace ---

at MonoServiceRunner.Main (System.String[] args) [0x00000] in :0

[ERROR] FATAL UNHANDLED EXCEPTION: System.TypeInitializationException: An except ion was thrown by the type initializer for Mono.Unix.Native.Syscall ---> System. DllNotFoundException: libMonoPosixHelper.so

at (wrapper managed-to-native) Mono.Unix.Native.Syscall:_L_ctermid ()

at Mono.Unix.Native.Syscall..cctor () [0x00000] in :0

--- End of inner exception stack trace ---

at MonoServiceRunner.Main (System.String[] args) [0x00000] in :0

Thats what it returns. Sorry for bugging you. It's the first time I use Mono. And I have no idea what I have to do.

 

EDIT 2

 

So while I was waiting... And reading the error response over and over again.

Looking on various website. Untill I saw System.DllNotFoundException: libMonoPosixHelper.so

Googled that and found:

http://stackoverflow.com/questions/3...rvice-on-linux

 

So now my startup.sh looks like this:

#!/bin/csh

setenv LD_LIBRARY_PATH .:/usr/local/lib

cd /home/PRoCon-1.2.0.0

mono-service2 -l:./proconservice.lock PRoCon.Service.exe

[ImportBot]

Originally Posted by XpKiller*:

 

you may using the wrong lib folder because you have centos and not debian.

 

try /usr/lib

or

/usr/lib64

 

also check if your mono install is complete

[ImportBot]

Originally Posted by TheHardest*:

 

Everything is working fine now with this in the startup.sh.

 

#!/bin/csh

setenv LD_LIBRARY_PATH .:/usr/local/lib

cd /home/PRoCon-1.2.0.0

mono-service2 -l:./proconservice.lock PRoCon.Service.exe

Thanks for the assistance.

[ImportBot]

Originally Posted by demetrope*:

 

Hello,

Sorry for my English which is not terrible,

The installation goes without procon server problem in Ubuntu

It works very well with procon 1.3.0.0 but does not work with 1.3.0.1 oddly

By not run against ODBC plugin:

BF3-Chat-GUID-Stats-and-logger MapStats

I did not really find a tutorial for installing ODBC

I managed to install it but it does not work, could you help me

[ImportBot]

Originally Posted by demetrope*:

 

then a putty, my odbc connection works, but I receive side procon:

 

[16:01:18 59] BF3 Chat, GUID and Stats Logger Enabled

[16:01:18 60] BF3 Chat, GUID and Stats Logger: Floodprotection set to 32 Request per Round for each Player

[16:01:20 98] Error in Tablebuilder:

[16:01:20 98] Index #0

[16:01:20 98] Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

[16:01:20 99] Native: 0

[16:01:20 99] Source:

[16:01:20 99] SQL: IM002

[16:01:20 99] Error: System.NullReferenceException: Object reference not set to an instance of an object

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder () [0x00000] in :0

[16:01:26 93] [xVotemap] Info: Estimated voting start in 2 hours, 42 minutes, 39 seconds @ 12:44:05

[16:01:28 62] Error in Tablebuilder:

[16:01:28 62] Index #0

[16:01:28 63] Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

[16:01:28 63] Native: 0

[16:01:28 63] Source:

[16:01:28 63] SQL: IM002

[16:01:28 63] Error: System.NullReferenceException: Object reference not set to an instance of an object

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder () [0x00000] in :0

[16:01:28 63] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified

at System.Data.Odbc.OdbcConnection.Open () [0x00000] in :0

[ImportBot]

Originally Posted by alexrayden*:

 

then a putty, my odbc connection works, but I receive side procon:

 

[16:01:18 59] BF3 Chat, GUID and Stats Logger Enabled

[16:01:18 60] BF3 Chat, GUID and Stats Logger: Floodprotection set to 32 Request per Round for each Player

[16:01:20 98] Error in Tablebuilder:

[16:01:20 98] Index #0

[16:01:20 98] Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

[16:01:20 99] Native: 0

[16:01:20 99] Source:

[16:01:20 99] SQL: IM002

[16:01:20 99] Error: System.NullReferenceException: Object reference not set to an instance of an object

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder () [0x00000] in :0

[16:01:26 93] [xVotemap] Info: Estimated voting start in 2 hours, 42 minutes, 39 seconds @ 12:44:05

[16:01:28 62] Error in Tablebuilder:

[16:01:28 62] Index #0

[16:01:28 63] Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

[16:01:28 63] Native: 0

[16:01:28 63] Source:

[16:01:28 63] SQL: IM002

[16:01:28 63] Error: System.NullReferenceException: Object reference not set to an instance of an object

at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder () [0x00000] in :0

[16:01:28 63] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [iM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified

at System.Data.Odbc.OdbcConnection.Open () [0x00000] in :0

I hope this can help you:

 

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry7856

 

attention: with the 64-bit version of the OS I'm having a series of problems to use this plug-in, especially problems of "Memory allocation error" and problems in integrating data in tables (inserts in each cell a 0 instead of data correct)

[ImportBot]

Originally Posted by demetrope*:

 

Thank you for your help in this work, the tables are set up,

by cons I have a memory problem as you had said, how can I fix it_:

 

[18:28:26 94] Error: SQLQuery:

[18:28:26 94] Index #0

[18:28:26 94] Message: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Memory allocation error

[18:28:26 94] Native: 4001

[18:28:26 95] Source: libmyodbc5.so

[18:28:26 95] SQL: HY001

[18:28:26 96] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY001] [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Memory allocation error

at System.Data.Odbc.OdbcCommand.ExecSQL (CommandBehavior behavior, Boolean createReader, System.String sql) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery (System.String method, CommandBehavior behavior, Boolean createReader) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery () [0x00000] in :0

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID (PRoCon.Core.CServerInfo csiServerInfo) [0x00000] in :0

 

I can not find anything about this problem on the net

[ImportBot]

Originally Posted by alexrayden*:

 

Thank you for your help in this work, the tables are set up,

by cons I have a memory problem as you had said, how can I fix it_:

 

[18:28:26 94] Error: SQLQuery:

[18:28:26 94] Index #0

[18:28:26 94] Message: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Memory allocation error

[18:28:26 94] Native: 4001

[18:28:26 95] Source: libmyodbc5.so

[18:28:26 95] SQL: HY001

[18:28:26 96] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY001] [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Memory allocation error

at System.Data.Odbc.OdbcCommand.ExecSQL (CommandBehavior behavior, Boolean createReader, System.String sql) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery (System.String method, CommandBehavior behavior, Boolean createReader) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery () [0x00000] in :0

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID (PRoCon.Core.CServerInfo csiServerInfo) [0x00000] in :0

 

I can not find anything about this problem on the net

Same problem for me. I'm reading that you are on squeeze, then you are on debian. For the 64 bit OS's, there is exactly this problem. I'm fighting with this from september, till now.

 

I used debian 6 (squeeze) 64bit, and now ubuntu 12 64bit.

 

With Ubuntu 10.04 32bit, there was no problem with that config.

[ImportBot]

Originally Posted by demetrope*:

 

hello,

 

That's all I started with debian 6 32bit and now I receive this message:

 

[08:39:00 61] BF3 Chat, GUID and Stats Logger Enabled

[08:39:00 62] BF3 Chat, GUID and Stats Logger: Floodprotection set to 32 Request per Round for each Player

[08:39:19 70] Error: SQLQuery:

[08:39:19 70] Index #0

[08:39:19 70] Message: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

[08:39:19 70] Native: 1267

[08:39:19 70] Source: libmyodbc5.so

[08:39:19 70] SQL: HY000

[08:39:19 71] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [23000] [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Duplicate entry '_________' for key 'IP_Address_UNIQUE'

at System.Data.Odbc.OdbcCommand.ExecSQL (CommandBehavior behavior, Boolean createReader, System.String sql) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery (System.String method, CommandBehavior behavior, Boolean createReader) [0x00000] in :0

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery () [0x00000] in :0

at (wrapper remoting-invoke-with-check) System.Data.Odbc.OdbcCommand:ExecuteNonQuery ()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID (PRoCon.Core.CServerInfo csiServerInfo) [0x00000] in :0

[ImportBot]

Originally Posted by demetrope*:

 

good, I found just install the tables on a database utf8-general will to remove this problem and the problem now against q'au few hours it crashes and returns me as a message:

 

Executing procon...

Running... (Press any key to shutdown)

Segmentation fault

 

 

___?

[ImportBot]

Originally Posted by XpKiller*:

 

you shouldnt use the console under linux. Its better to run the procon.service.exe

[ImportBot]

Originally Posted by demetrope*:

 

yes I know but I wanted to see it planted if there was an error message

[ImportBot]

Originally Posted by demetrope*:

 

So now everything works ok except that my startup.sh not working anymore, I run the command:

 

./startup.sh

 

it returns me no error:

bob@ks00000 :/home/procon#./startup.sh

bob@ks00000 :/home/procon#

 

and there is the procon does not start.

 

my startup.sh:

 

#/bin/bash

cd/home/procon/

mono-service2-l./proconservice.lock PRoCon.Service.exe

[ImportBot]

Originally Posted by XpKiller*:

 

Please keep in mind the the service runs in background.

Use ps -ef ¦ grep PRoCon

[ImportBot]

Originally Posted by demetrope*:

 

this is the right response to the order, what should I do now?

thank you for the time you take to help me.

 

bob@ks00000 :/home/procon# ps -ef | grep procon

bob 13001 7782 0 18:44 pts/2 00:00:00 grep procon

[ImportBot]

Originally Posted by XpKiller*:

 

take a look what is written to the logs.

[ImportBot]

Originally Posted by demetrope*:

 

thank you,

 

actually in user.log there to the line:

 

November 13 6:48:53 p.m. ks3000429 mono: PRoCon.Service.exe: Lock file already exists. / Proconservice.lock

 

so if I'm not mistaken there a procon running in the background but how to cut?

 

if I do:

 

bob @ ks00000 :/ home / procon #. / shutdown.sh

 

Server replied:

 

. / shutdown.sh: line 5: kill: (11982) - No such process

 

--------------------------------

In a second step the CChatGUIDStatsLoggerBF3 plugin does not return any game when I type rank or top10 ingame, it also bug level web:

 

http://lcsw.fr/bf3stats/weapons.php

 

And told me that the server is offline, an idea in passing.

 

And finally a weird thing in my sql stock it in Chinese, see below

 

http://img15.hostingpics.net/pics/847708bug.png

 

-------------

xpkiller finally, I have it in my side procon plugin in the console below:

 

[01:07:16 45] Info: Prevented double creation of columns for weapon: MP443

[01:07:16 45] Trace: Tablecheck Weapons

[01:07:16 47] Info: The table tbl_weapons_shotgun is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 47] Trace: Tablecheck Weapons

[01:07:16 49] Info: The table tbl_weapons_assaultrifle is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 49] Trace: Tablecheck Weapons

[01:07:16 52] Info: The table tbl_weapons_smg is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 52] Trace: Tablecheck Weapons

[01:07:16 53] Info: The table tbl_weapons_suicide is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 53] Trace: Tablecheck Weapons

[01:07:16 55] Info: The table tbl_weapons_none is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 55] Trace: Tablecheck Weapons

[01:07:16 56] Info: The table tbl_weapons_melee is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 56] Trace: Tablecheck Weapons

[01:07:16 58] Info: The table tbl_weapons_projectileexplosive is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 58] Trace: Tablecheck Weapons

[01:07:16 60] Info: The table tbl_weapons_handgun is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 60] Trace: Tablecheck Weapons

[01:07:16 62] Info: The table tbl_weapons_sniperrifle is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 62] Trace: Tablecheck Weapons

[01:07:16 64] Info: The table tbl_weapons_lmg is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 64] Trace: Tablecheck Weapons

[01:07:16 65] Info: The table tbl_weapons_explosive is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 66] Trace: Tablecheck Weapons

[01:07:16 67] Info: The table tbl_weapons_nonlethal is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls

[01:07:16 67] Trace: Tablecheck playerstats

[01:07:16 68] Trace: Tablecheck tbl_server

 

I just put the parties or there were problems, thank you for your support

[ImportBot]

Originally Posted by demetrope*:

 

Hello,

I redo a complete installation, first start I could use startup.sh, after some hours the procon had planted, and strangely it is impossible to restart the startup.sh, it starts only with

mono ProCon.Console.exe,

I really do not understand what bug, then at that time can not I start another way_, more stats plugin always communicate in Chinese with my tables, table issues must be utf 8 or Latin?

[ImportBot]

Originally Posted by XpKiller*:

 

You need to delete the Proconservice.lock file.

It prevents the start. on a normal stop it would be deleted.

 

Unfortunately i cant help you with you database problem.

I guess that the mysql server is forcing a specific char set.

Someing with the odbc driver conf or the mysql serevr could be wrong.

[ImportBot]

Originally Posted by demetrope*:

 

thank you to walk it but once, procon turns off after about 30 minutes and it does not restart after:

 

bob@ks3000000:/home/procon2# ./startup.sh

bob@ks3000000:/home/procon2# ps -ef | grep mono

bob 18206 1 51 23:34 pts/0 00:00:02 /usr/bin/mono /usr/lib/mono/2.0/mono-service.exe ./PRoCon.Service.exe

bob 18226 3726 0 23:34 pts/0 00:00:00 grep mono

 

after 30 minutes

 

bob@ks3000000:/home/procon2# ps -ef | grep mono

bob 20942 3726 0 00:09 pts/0 00:00:00 grep mono

bob@ks3000000:/home/procon2# ./startup.sh

bob@ks3000000:/home/procon2# ps -ef | grep mono

bob 21018 3726 0 00:09 pts/0 00:00:00 grep mono

[ImportBot]

Originally Posted by demetrope*:

 

Everything works ok, I redid a clean install, mysql, odbc and mono latest version

Here is a script I made to start, stop the server reboot is,

It is placed in /etc/init.d:

 

 

### BEGIN INIT INFO

# Provides: Procon Server Installation

# Required-Start: $local_fs $network

# Required-Stop: $local_fs $remote_fs

# Default-Start: 2 3 4 5

# Default-Stop: 0 1 6

# Short-Description: Procon Service

# Description: Procon is an administration software for gamers Battlefield3

### END INIT INFO

#! /bin/sh

# /etc/init.d/procon

#!/bin/bash

 

### Nom de ce script ###

NAME=procon

 

### Chemin répertoire de ce fichier ###

SCRIPTNAME=/etc/init.d/$NAME

 

### Répertoire logiciel de procon avec le "/" ###

HOME=/home/procon2/

 

### User to launch favorite Procon, I not recommend your ROOT ###

USER=root

 

### Description This short script ###

DESC="Procon Frostbite"

 

do_start()

{

su $USER -c "cd $HOME; mono-service2 -l:./proconservice.lock PRoCon.Service.exe"

}

do_stop()

{

su $USER -c "kill `cat $HOME./proconservice.lock`"

}

 

case "$1" in

start)

if [ $USER = "root" ]; then

echo WARNING ! As a safety: DO NOT THROW YOUR SERVER IN PROCON .ROOT.

c=1

while [ "$c" -le 10 ]; do

echo -n "!"

sleep 1

c=$((++c))

done

echo "!"

fi

echo "Starting $DESC"

do_start

;;

stop)

echo "Stopping $DESC"

do_stop

;;

restart)

echo "Stopping $DESC"

do_stop

sleep 3

echo "Starting $DESC"

do_start

;;

*)

echo "Usage: $SCRIPTNAME {start|stop|restart}"

esac

exit 0

 

You just need to change the account name to start (I put root in the example, not recommended), and the location of procon in bold in the example,

start command will be home:

./procon start ,or ./restart procon ,or ./procon stop

 

Made in the plugin stats on bf3 still works in Chinese, is it possible to have the sources to try to adapt it please XpKiller, thinks.

[ImportBot]

Originally Posted by fabnay*:

 

Hi,

 

I have recently installed procon layer 1.4.0.2 under linux. All works fine. But i m not sure how to update procon layer and i didn't find solution under the forum or doc.

 

How to update procon layer 1.4.0.2 to 1.4.0.4 under linux ?

If i unzip and load all files in the current folder, will i lose plugins settings ?

 

or may i use ?

procon.private.options.autoCheckDownloadUpdates True

procon.private.options.autoApplyUpdates True

[ImportBot]

Originally Posted by Phil_K*:

 

Hi.

 

One way is to unzip Procon into that folder and make sure it integrates existing files.

All Procon main files (main folder) can be overwritten, but make sure not to delete your Configs files.

 

I haven't tested the auto download under mono.

 

Greets

Phil.

[ImportBot]

Originally Posted by fabnay*:

 

Ty Phil_K

 

unzip and upload files works well. Configs files are safe.

I didn't test autodownload.