IL2ClodCommander Server Manager

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