IL2ClodCommander Server Manager

[Ataros]

Originally Posted by wildwillie

Ataros -

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



WW

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

[5./JG27.Farber]

Originally Posted by CaptainDoggles

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

Huzzah!

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

[5./JG27.Farber]

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 )



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?

[wildwillie]

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

[5./JG27.Farber]

WOOooo Slow down

I am on step one.

[wildwillie]

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.

[D_F_C]

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 ?

[wildwillie]

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

[5./JG27.Farber]

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?

[_79_dev]

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??