IL2ClodCommander Server Manager
 

All -

Attached is an initial release of the IL2ClodCommander program I've been working on. It is pretty raw at the moment, but does manage mission rotation and has a working stats part.

It works by using Scripting in the Mission.cs file to pass data to a program with keeps tabs on things and links to a database. A lot of it could have been done in the scripts itself, but I wanted it separate from the Dedicated Server.

Right now it only has Count Objectives working. Which means that to determine if a mission has been one, you designate a certain amount of an object type to be destroyed for that objective to be complete. (i.e. 5 Tanks, 3 ships, etc)

There is a readme.txt file which goes over the basic installation and running.

There is still a bit of work to do and I would be interested in any offers of assistance.

Some things that I plan on updating in the immediate future:

Keep sortie information for 5 minutes after a sortie ends (Or until the mission ends) before writing the data out to the database. With Clod your kills may not show up right away or if you bail out it takes time for the parachute to land, etc.

Other things that need to be done:
Add tracking of Parachute results. It currently captures when you parachute out, but does not track if you land in your chute or are killed in your parachute.

Figure out how to gather Bullets/bombs/rockets info from the server for inclusion in stats.

Add Trigger support (Like Target Objectives) to allow missions to be won by mission triggers.

Figure out what weapon loadouts taken at the Sortie start.

Update the GUI to show the pilots list (Currently does not work)

Add more user/Admin commands.

Anyhow this is a start,

RAF238thWildWillie


P.S. Just realized this site does not allow 7z attachments. Need to compress in another format before uploading.

Great stuff Willie!

What have you been doing about the null errors? One thing we have to do is restart the server every so often or some people will be locked out. Might not be a bad idea to add something like that in between the rotation piece. With all the steam errors, it's very frustrating keeping a server up (automatically).

Thanks!

What do you mean by "null errors" ? Like this one:
I started our server last night at 9:30 and it is still running without problem.
I have 4 missions in rotation and the Dedicated server uses between 700mb and 950mb of memory.

I just found one issue I have been tracking where the player is not removed after they have disconnected. Which is why you see 85 players ingame on our stats page when it actually is only 1.

Attached is the new exe for that fix.

Also you will need to download the latest GeoCityLite.dat file from http://www.maxmind.com/app/geolitecity and unzip it to the IL2ClodCommander folder.

Willie

That error message, is sadly normal (currently). What I'm talking about is the steam stats tracker in my sig. Sometimes you'll see a player labeled as (null). This is a player that attempted to join the server yet failed authorization. So this (null) will stay on the on the steam stats and the player will not be able to join until the server is completely restarted. So if you have a null in your listing and kept your server up 24/7 that particular player can never join again. This extra player does not show up in the console, so it's not like you could kick him out either. They are just stuck failing auth. So if you had 25 players according to steam and 1 of those being a null, your in-game server will only show 24.

That's why we restart the server at the end of each mission. We used to rotate missions, but found leaving the server up will significantly increase the amount of players that can't join (nulls) to well in the 20's in a 24 hour window. And this null thing is completely random. It's happened to the majority of players I've talked to at least 1 time. :(

Another reason why we really need dedi files for the server.

Excellant, thanks WW!

Thanks for the explanation Bliss. I myself was having trouble connecting to our server one time and that sounds like exactly what you described.

We had a new guy try to join earlier this week but kept failing authentication. Finally last night he was able to join.

I have been restarting my server a couple times a day when I am coding and updating things, but other than that I try and leave it alone. I will keep a better watch on it now though.

One thing I do seem to be having trouble with is the Server losing connection to Steam. I will notice that the server does not show up in the client list. I go to the server and see a little message box that steam has disconnected. At that point I try and shut everything down and restart but Steam says it is trying to sync. It may stay that way for 5 minutes or 2 hours before I am finally able to get the server back online. Any Ideas what that might be ?

Thanks,

WildWillie

@ wildwillie
Thank you for sharing! Do you plan to share the source code? Small_Bee is working on server commander and stat too (screenshots of commander and stat ). I think it would be efficient if you join efforts if it is possible.

Not exactly random. There are at lease two cases which you can reproduce to get this error.
1) Click Cancel while connecting to a server.
2) Chose to disconnect from a server when it is in lag.

Then when trying to connect you get "Server failed authentication" error but you can see your name in the server browser list of players present at the server. Thus I think kick <name> (or maybe kick null) command should work but I never tested it.

Try setting the server to autorestart when it happens as described here http://forum.1cpublishing.eu/showthread.php?t=25429

Ataros -

Source code (Visual Studio project) is provided in the download.



WW

I think it's really great that you include the source code.

Thank you very much. I looked into the wrong archive initially.

Huzzah!

Not really had a chance to dig into it yet! But it looks great! :-P

Im currently trying to install this on our server. Its a bit out of my depth. Ive downloaded the clodcammander beta, the fix and SQL. (Created a system restore point :-P )



I can't find the download link for apache.

Does the forum where statistics are shown have to be on the same machine or LAN?

If yes, is there a way to retrieve stats a different way?

Farber -

The Web server where you show the statistics can be on any machine. As long as that server can talk to the MySQL database to get the data.

The way I have things setup, I have one Server in a New York Data center that runs:

CloD server
MySQL Database
IL2ClodCommander

A web server that is supported by another of my admins is located in California somewhere. It talks to the MySQL server over the net.

You can see our stats at this link: http://www.warbirdsofprey.org/index.php?page=codstats



If you need the Apache server it can be downloaded from :http://httpd.apache.org/download.cgi#apache22 Then you will need the PHP module found on this site http://windows.php.net/ Setting everything up is a bit out of my expertise, but as I recall it was not too difficult. They both come with windows installers if you are installing on a Windows platform. There are also numerious places to get the Unix downloads if you use Unix.

I have some more updates on the software I will post later this week. Once you have the basics installed, updating is pretty easy.

WildWillie

WOOooo Slow down :-P

I am on step one.

Farber -

Step 1 - Install and get Cliffs of Dover dedicated server running. (I am assuming you have that going so far)

Step 2 - Install the MySQL Database You can download the 64bit or 32bit from this link http://dev.mysql.com/downloads/mysql/ depending on your server. Use the MSI installer version as it is simple.

Step 3 - Install the MySQL Workbench from here http://dev.mysql.com/downloads/workbench/5.2.html This is a 32bit only. It may ask for the MS C++ distribution that you will have to install too.


Those are the 1st few steps.

Hello WildWillie,
Thx for your fantastic work, but i have a problem to connect stats and CloDcommander to my SQL-Server.
I think the main problem is that the SQL-Server is running on port 3307 instead of 3306.
If i try it on my local machine with 3306 all connected fine, but on our server is SQL running on 3307. I edited by hand the include files in stats folder and setup the Clodcommander to port 3307. Stats seems to running fine then, but Clodcommander gives me an error and the Game objectives are not shown in it. Are you able to test your fantastic tool on port 3307 ?
All is running on the same server machine, MySQL=5.5.20
Maybee some problems with mysqlconnect and mysqliconnect.

Is it possible to realise some checkboxes for autostart DBconn autostart serverconn and autostart missions ?
Would be helpful for autostart server and commander by scheduler.

Another Question is, where are to post CloDcommander bugs ? Here or on warbirdsofprey ?

D_F_C -

I found your problem. There was another Database connection that got called within the program that I forgot to add the port to. It defaulted to 3306. I will fix it for the next release.

You can post Bugs on the Warbirds Site under the Cliffs of Dover section. If there is not already a post there, start one with "IL2ClodCommander Bug List" in the Subject Line.

I've added a good bit, and am currently incorporating Triggers so you can incorporate Target objectives based on Triggers.

Also I've included a lot more game Objects and Column definitions.

WildWillie

Im in a real mess trying to do this.

I think ive made the 2 accounts for SQL but there is two places to make them. So Im not sure if thats right. One in new model and another in administration - which is now giving the error 10061

How do you actually connect the sql to clodcommander and vice versa?

What do I do wrong?

=================================================
System.ApplicationException: Mission: Mission not loaded.
at 4YQguDGg7WLABsU9pm3.T8Lw4SGw95gwTxUSs13.33FmYeNKML (Double )
at 4YQguDGg7WLABsU9pm3.T8Lw4SGw95gwTxUSs13.VTImZIPK7F ()
at 8X159no07oYg2yu2OBK.qUomqVoaDQ8DB34Ln6w.BattleStar t()
at 2pcDPOMCAn8BIb8ysUA.NFCE7DMiT9FpQagZIAw.WvUJ1RctUF o(XmqEBtXtZdpequkcc65 )
at 2pcDPOMCAn8BIb8ysUA.NFCE7DMiT9FpQagZIAw.JOI5uWMWD0 5biIQlYbj.rwaLkRrjM6Oq5MvTByqt(Object , Object )
at 2pcDPOMCAn8BIb8ysUA.NFCE7DMiT9FpQagZIAw.JOI5uWMWD0 5biIQlYbj.k1qJ1Nv9g1f(XmqEBtXtZdpequkcc65 )
at 2pcDPOMCAn8BIb8ysUA.NFCE7DMiT9FpQagZIAw.7fe3ucrM9s rvuSl8w3rN(Object , Object )
at 2pcDPOMCAn8BIb8ysUA.NFCE7DMiT9FpQagZIAw.consoleInp ut(String )
at g4BSxWxGHPiUmyukbWN.fkOxIox8BMeA3dnwncV.xGBJnZ5yoG x(String )
at UpAEiymMcHSymg6iQ8F.piGitLmFeMHcV8v0vFY.kVJsYKH8qD WAAr8D9efd(Object , Object )
at UpAEiymMcHSymg6iQ8F.piGitLmFeMHcV8v0vFY.VJbwtGAVpT r(String , uvqhOPmcF0pgjZduJO1 )
=================================================


I`am kind of messed up with port configuration... not sure why:

my confs.ini

[NET]
serverName=Dedicated Server
serverDescription=IL-2 Sturmovik: Cliffs of Dover
speed=100000
localPort=27005
maxPlayers=16
serverInfo1=
serverInfo2=
serverInfo3=
serverInfo4=
VAC=1
tryDirectConnect=1

[Console]
IP=20011
IPS=127.0.0.1, localhost, 192.168.1.11
LOG=0
LOGTIME=0
LOGFILE=logs.txt
HISTORY=128
HISTORYCMD=128
WRAP=1
PAUSE=1
PAGE=20
LOGKEEP=1
__________________________________________________ ______


my Il2 commander set like that:

database connection: IP 127.0.0.1 ....

server connection info: IP: 192.168.1.11
stats port : 20005
console port: 20011

__________________________________________________ ______

thats from mission script base

private static Int32 serverPort = 20005;

how do I actualy edit base file, not sure where to put mission strings, would u give example pleas??

confs.ini
[NET]
localPort=27016

[Console]
IP=20016
IPS=127.0.0.1, localhost, xx.xx.xx.xx (dediserverIP)
LOG=1
LOGTIME=0
LOGFILE=logs.txt

Clodcommander:
database
localhost
3306

Server
IP127.0.0.1
Port27016
Consoleport20016

Basescript:
private static Int32 serverPort = 27016

Thats my running settings. Database, clodcommander, dediserver on same machine.

thanks, would You be able to drop me a mission script and .mis file example pleas I am just getting confused here....

After working around .cs and .mis files I can't get it to work for some reason. Mission is still not loading. Everything seems to be working fine database connected with server, ports are set proper way. Getting same error all over again. Would anybody wise me how to edit mission base script? Maybe I do something wrong in there. Example of .cs file would be perfect...

P.S
After couple of days playing with that tool I realised how muchh possibility it has. Thanks for all Your hard coding guys...

Script examples http://forum.1cpublishing.eu/showthread.php?t=26523
Tutorials http://forum.1cpublishing.eu/forumdisplay.php?f=203

Make sure you script and mission work without the Commander first. If your script has errors they will show in the game console. You can also open FMB >> Open your mission with a script >> Script menu >> Script tab >> RMB click >> Compile. This will give you list of errors if any. See Tutorials for details.

Simple missions work without scripts at all, .cs file is not necessary for them.

Hello 79_dev

did you copy the Clod Server dll into the right folder ?

c:\Steam\SteamApps\common\il-2 sturmovik cliffs of dover\IL2ClodCommanderStats.dll

I did that

My scripts are running no problem without commander, buy I never did it through FMB... I will have a look at this...


Also would You guys pleas send me example of script .cs added inside "mission script base" from commander. maybe I am deleting to many brackets or something...

Here is a simple mission, you have to edit the .cs, confs.ini, commanderConfig to your machine.
It runs on mine fine.

Cheers D_F_C I`ll check it when I get home later on. Thank You

Hi All -

Just a quick update.

I've just added support for Target Objectives. It is currently being tested on the WoP server.

You can create Target Area or Target Group Triggers in FMB and IL2ClodCommander will read them in and create mission Objectives for each.

Hope to post the updated files this weekend.

WildWillie

Finally got it working ... Waiting for update... Thanks for that lovely soft Willie.

Anyone knows why I`am getting this error:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.IOException: The operation is not allowed on non-connected sockets.
at System.Net.Sockets.NetworkStream.InitNetworkStream (Socket socket, FileAccess Access)
at System.Net.Sockets.NetworkStream..ctor(Socket socket)
at IL2CloDCommander.ServerConsoleConnection.SendConso leMessage(String msg)
at IL2CloDCommander.Form1.buttonBattleStart_Click(Obj ect sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Looks like you clicked on the Battle Start button before IL2ClodCommander was connected to the server. There was no Socket connection setup yet so the command failed.

WildWillie

server is running no prob, i can load any miision I want on plain server , when i go to Il2 stats commander set ports connect database, connect server and start mission everything looks good until I press Start battle...also when I try Send Console button I got message No Stats Socet Connection...strange all the files looks configurated properly...?


this is from .cs file

private static string serverName = "Cliffs of Dover";
private static string serverIP = "127.0.0.1";

// Password is not used currently
private static string serverPassword = "password";
private static Int32 serverPort = 27016;

this from confs.ini

serverName=Dedicated Server
serverDescription=IL-2 Sturmovik: Cliffs of Dover
speed=100000
localPort=27016
maxPlayers=4
serverInfo1=
serverInfo2=
serverInfo3=
serverInfo4=
VAC=1
tryDirectConnect=1

[Console]
IP=20016
IPS=127.0.0.1, localhost, 89.101.25.220
LOG=1
LOGTIME=0

79_dev -

I see the problem. When you start IL2 Clod Commander, once you click "Database", "Server", "Start Mission" it will automatically start the battle. Those buttons were left over from initial testing, and should not be used. I have removed them from my next release (Which I have done, just need to put into a package to distribute)

WildWillie

I have noticed that server is running just that error is a bit curious thing. Now how about "Send Console" button, why will ports not match or be in use? I am trying to send anything to Console even when mission is not running yet and got that" No Stats Socet connection" error...curious again

The release you are using has a lot of testing stuff build in(That will be removed or worked into functional stuff later). The send console button being one of them.

I understand now thank You for quick reply, if You need any help with testing or scripting send me p.m

~S~
I kind of worked out my socket problem. I can't get it to work only under win xp sp3 for some reason. I have created virtual win7 under Oracle Virtual Box and it's working fine with the same settings on the same computer. I am using XAMPP and maybe it has some problem with ports throug firewall or something...

P.S Any chance for update Willy? I can Imagine You are busy man but I can't wait until next release ...

Willie,
I can get a green DB connectuion, green Server connection, & green Start missions. First mission in cycle runs OK. After time expires, I get 4 consecutive error dialogs saying "No Stats Socket Connection" with just the OK button, which seem to coincide with the 'Chat: Server: Next mission start in 30 seconds' console call. Clicking through these steps to the next mission in the cycle which starts OK, then same error dialogs at the end of the second mission in cycle.

I don't see any in-game pilots in the commander pilot list or in the stats webpage, but mission coundown, mission name etc appear OK in commander & on webpage. Any ideas?

For me missions runs ok in the cycle with no errors. Don't know what may cause error message. I had that problem with sockets ealier on but I was running it under win xp, upgrading to win 7 cleared this issue. Still working on it anyway. About web page, if You are using .php files attached by Will You have to edit few files like config.php, header.inc, footer.Inc from web page folder ...

Thanks 79_Dev, I am already operating win7 & am familiar with running FBDj stats webpages & have edited the conf.ini to include the correct DB connect info. SQL Admin reports cloduser & clodadmin are connected to the DB & in sleep mode.

In all missions.cs files are setup the correct IP and port ?
You need for each mission in cycle the base mission script with your machine settings in region Stats Initialization

Hi Wild Willi thx for sharing :)
how can i make that the server shows from whitch country the players are ?
now the server scrives (player) from unknown and that is wrong

Hi wildwillie

first sorry for english, i use google traslator:(.

There is my cuestión.
When i use il2 commander the planes create by a time tiggers or army air no start on the server.

How can i solve it.

THX

after read a lot off post, i add this to bose scrip, and now work fine

Sorry, no work bery fine.
The works only the first time.
But the trigger TPassThrogh it only works once,but I need is that every time you activate work.
¿how can i solve it?

NOw work. only need change false for true.
Thx all

Just had similar problem today, it turned to be lack of { in .cs file... did You sort it out?

I've got Willie's commander working (sort of!). The web stats-page shows mission details correctly. Three questions though:

1. [edit: SOLVED] Player country flags come up as a white square with a question mark. Yes, I have geocitylite.dat in the clod commander root directory.
2. Active players show up OK, but a player is not removed from the list when they leave the server. ie. The mysql clodstats.activeplayers table is not updated for some reason.
3. I'm using commander ver 1.0 beta, is there a more up-to-date version?

Bump ...

I would PM WW or DFC if I was you Salmo, WW works out of town allot and I havent seen DFC for some time.

http://forum.1cpublishing.eu/showthread.php?t=30853 is a newer version of CloD Commander salmo