Topic: Gravity Well back up on QNX MySQL db

[Bonk]

I've pretty much finished the switchover to a Linux MySQL db (have yet to move the chat server over too).
It looks as stable as it was on a local db (hopefully more). I had to reset the db (sorry) due to some different behaviour of the db on Linux - its for the good of the game...  I have a thread going in the admin forums but I thought I should let people know here.

(The Race is still burping like RDSL did however, I'm thinking of giving it up and putting the stable SFB-OP server back up, because The Race wont work out well as the intended test of hex flipping if it keeps dying and I wasn't willing to put that much effort into it... Thoughts?)

So if you're itching waiting for LB5, give the new db on the Gravity Well a whirl and let me know if you see any quirkiness...

(The webmap shipyard is temporarily disabled until I finish accounting for the differences of running it all on Linux - won't be long till its working again...)

And yes WaterTiger, we know what you think of this. Keep that $100 ready just in case! 

[Bonk]

The servers have been stable (with no load) on the Linux MySQL db but...
I've decided I'm not happy with the overall performance of Fedora Core 2 (the Linux distribution I'm using - should have gone with SlackWare...), being a sucker for punishment I'm going to try QNX 6.2.1, the servers and webmaps will be down for a bit while I get the QNX setup up and running over the next couple of days....

[Bonk]

Servers and webmaps are back up on the QNX MySQL db. So far it looks good but I still need to do some more tweaking, let me know if you see any weirdness, thanks.

In my opinion QNX beats Fedora hands down, though trickier to install and configure and has a more limited selection of applications. (though many Linux binaries can run and other apps need minimal modification before compliling)  QNX 6.2.1 can be obtained by registering at www.openqnx.com to get access to their downloads. Version 6.3 can be obtained at www.qnx.com by registering - v6.3 comes bundled with the Momentics development suite which expires after 30 days leaving you with just the non-commercial OS.

[FireSoul]

I'm a Linux debian guy, myself.

[Bonk]

Good to know, it seems to be rated up there with slackware, I've been going over the reviews now like I guess I should have done before starting this project.

[drb]

Hoi Folks,

 Just off the cuff, I would be willing to Put my $0.25 US to Have a "red phone" so that FireSoul and Bonk could share SFB-OP ideas. Hummm... many others others come to mind who should have "red phone" access as well...
  drb wakes up from the nightmare; he says under his breath,"Thank goodness it lives on at dynaverse. net."
 Dressed and making a pot of coffee he wonders where he can find a copy of the fabled "old forums."
  Thanks to all who were envolved in the project that has kept this game going.

drb

[FireSoul]

You're probably right...


.. Bonk, look at my user's profile for ICQ and MSN entries. Perhaps you can add me to your list and vice-versa?

[Bonk]

Good plan and done! ..drb... eminently sensible...

[Bonk]

I had the server down for a while... she's back up again... lol..

I got Apache 2.0.50 and PHP 5.0.0 compiled and running on ONX 6.3.0!!! 
Check it out: Gravity Well

The D2 Server is connected to MySQL's 4.0.18-max binary distribution for QNX 6.2.1 (running on QNX 6.3).

I'm stewing on what to do with SFB-OP at Green's suggestion.

[Strafer]

well, Convoy Escort bugged out on the report at 7,11. Wiped the opposition without 1 loss with the help of AI reinforcements and got a 0 PP defeat out of it.

[Bonk]

Thanks for checking it out Strafer (and the feedback), much appreciated! I only ran one mission on it last night and have been making up a sleep defecit all day today...   I just woke up... yawn... need coffee... bad!

The recent battles script on the webpage indicates a DV shift but no PP award, which makes it look like it reported ok. I'll take a look at the db to see if I see anything funny, I suspect the mission(?). I'll try a couple convoy escorts and other missions to see... after I get my coffee.

(db looks ok - it seems the mission gave you a defeat but a positive DV shift, odd I must try a few out and see...)

[Bonk]

I just ran a couple missions - one convoy escort, all went fine.
I had a hard time on the convoy escort I drew 2 x K-F5Ds vs my one GSC,
needed the help of the reinforcements to get em - no losses, got 500pp
and the DV shift. I'll try a few more to see if we see this again...

It took a while though, and I think all the freighters got off the map,
were there any freighters left on the map in the convoy escort you ran?

edit: here's the current stats (nothing looks untoward except the 7 aborted connects which I think are from my errors during initial setup, but I'm going to keep a close eye on all these numbers...)

Code: [Select]

+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| Aborted_clients          | 0         |
| Aborted_connects         | 7         |
| Bytes_received           | 9316116   |
| Bytes_sent               | 201296296 |
| Com_admin_commands       | 0         |
| Com_alter_table          | 0         |
| Com_analyze              | 0         |
| Com_backup_table         | 0         |
| Com_begin                | 0         |
| Com_change_db            | 285       |
| Com_change_master        | 0         |
| Com_check                | 0         |
| Com_commit               | 0         |
| Com_create_db            | 4         |
| Com_create_function      | 0         |
| Com_create_index         | 0         |
| Com_create_table         | 36        |
| Com_delete               | 3646      |
| Com_delete_multi         | 0         |
| Com_drop_db              | 2         |
| Com_drop_function        | 0         |
| Com_drop_index           | 0         |
| Com_drop_table           | 0         |
| Com_flush                | 0         |
| Com_grant                | 3         |
| Com_ha_close             | 0         |
| Com_ha_open              | 0         |
| Com_ha_read              | 0         |
| Com_insert               | 4779      |
| Com_insert_select        | 0         |
| Com_kill                 | 0         |
| Com_load                 | 0         |
| Com_load_master_data     | 0         |
| Com_load_master_table    | 0         |
| Com_lock_tables          | 0         |
| Com_optimize             | 0         |
| Com_purge                | 0         |
| Com_rename_table         | 0         |
| Com_repair               | 0         |
| Com_replace              | 0         |
| Com_replace_select       | 0         |
| Com_reset                | 0         |
| Com_restore_table        | 0         |
| Com_revoke               | 0         |
| Com_rollback             | 0         |
| Com_savepoint            | 0         |
| Com_select               | 1643      |
| Com_set_option           | 22        |
| Com_show_binlog_events   | 0         |
| Com_show_binlogs         | 0         |
| Com_show_create          | 0         |
| Com_show_databases       | 14        |
| Com_show_fields          | 148       |
| Com_show_grants          | 3         |
| Com_show_keys            | 0         |
| Com_show_logs            | 0         |
| Com_show_master_status   | 0         |
| Com_show_new_master      | 0         |
| Com_show_open_tables     | 0         |
| Com_show_processlist     | 2         |
| Com_show_slave_hosts     | 0         |
| Com_show_slave_status    | 0         |
| Com_show_status          | 137       |
| Com_show_innodb_status   | 2         |
| Com_show_tables          | 40        |
| Com_show_variables       | 4         |
| Com_slave_start          | 0         |
| Com_slave_stop           | 0         |
| Com_truncate             | 0         |
| Com_unlock_tables        | 0         |
| Com_update               | 1168      |
| Connections              | 272       |
| Created_tmp_disk_tables  | 0         |
| Created_tmp_tables       | 0         |
| Created_tmp_files        | 0         |
| Delayed_insert_threads   | 0         |
| Delayed_writes           | 0         |
| Delayed_errors           | 0         |
| Flush_commands           | 1         |
| Handler_commit           | 0         |
| Handler_delete           | 3646      |
| Handler_read_first       | 496       |
| Handler_read_key         | 7155      |
| Handler_read_next        | 1141      |
| Handler_read_prev        | 0         |
| Handler_read_rnd         | 7295      |
| Handler_read_rnd_next    | 39042     |
| Handler_rollback         | 3         |
| Handler_update           | 2699      |
| Handler_write            | 4782      |
| Key_blocks_used          | 44        |
| Key_read_requests        | 29043     |
| Key_reads                | 1         |
| Key_write_requests       | 10607     |
| Key_writes               | 9915      |
| Max_used_connections     | 2         |
| Not_flushed_key_blocks   | 0         |
| Not_flushed_delayed_rows | 0         |
| Open_tables              | 27        |
| Open_files               | 53        |
| Open_streams             | 0         |
| Opened_tables            | 69        |
| Questions                | 82128     |
| Qcache_queries_in_cache  | 30        |
| Qcache_inserts           | 1629      |
| Qcache_hits              | 70062     |
| Qcache_lowmem_prunes     | 0         |
| Qcache_not_cached        | 14        |
| Qcache_free_memory       | 33460256  |
| Qcache_free_blocks       | 18        |
| Qcache_total_blocks      | 89        |
| Rpl_status               | NULL      |
| Select_full_join         | 0         |
| Select_full_range_join   | 0         |
| Select_range             | 597       |
| Select_range_check       | 0         |
| Select_scan              | 491       |
| Slave_open_temp_tables   | 0         |
| Slave_running            | OFF       |
| Slow_launch_threads      | 0         |
| Slow_queries             | 0         |
| Sort_merge_passes        | 0         |
| Sort_range               | 0         |
| Sort_rows                | 7295      |
| Sort_scan                | 50        |
| Table_locks_immediate    | 11296     |
| Table_locks_waited       | 0         |
| Threads_cached           | 0         |
| Threads_created          | 271       |
| Threads_connected        | 3         |
| Threads_running          | 1         |
| Uptime                   | 157237    |
+--------------------------+-----------+


...seems the code tag here does not use a fixed width font... unfortunate

[Bonk]

Ran a couple more missions, including another convoy escort, all went normally. I'm stumped as to what happened to your convoy escort. Lets see if anything odd happens to any other players on the other side of the router...

[Strafer]

It took a while though, and I think all the freighters got off the map,
were there any freighters left on the map in the convoy escort you ran?

I believe all were still on the map, the two agressors were dealt with in 5:00 or so.

It reported defeat with a none survivied/dark day message, gave me the sad music, gave me no cash, and shifted the DV positively...

[Bonk]

That is odd, the last convoy escort I ran, the freighters were still on the map when I destroyed the enemy ships and finished the mission, all reported as it should... thanks for the additional info. I'll keep an eye on this, perhaps it is related to my gf settings?

[Strafer]

That is odd, the last convoy escort I ran, the freighters were still on the map when I destroyed the enemy ships and finished the mission, all reported as it should... thanks for the additional info. I'll keep an eye on this, perhaps it is related to my gf settings?

Did it again, this time in 3:57 with no reinforcements. The freighters were definitely still within sensor range.

[Bonk]

Definitely something up there, what are you drawing for enemy AI?  I'm consistently drawing 2xF5Ds vs my GSC... I'm thinking this might be a gf setting... (the db looks fine)

I'm using the following:

in Score.gf:
[Hex]
WinThreshold         =0.02

in MetaMap.gf:
[Battle]
MinVictoryPointsForPlayerVictory=0.02
MinVictoryPointsForAIVictory=0.01
HexHealthResetRatio=0.02
FriendlyPassThroughHex=3
AllowAIToTakeHexes=0

[VictoryPointModifier]
Easy=1
Med=1
Hard=1
PureAI=0.2

I'm thinking the values used might be just on the cusp for the matchup you're getting... these gf values have always been a bit mysterious to me, particularly:
MinVictoryPointsForPlayerVictory=0.02
MinVictoryPointsForAIVictory=0.01
The kit seems upset if you set them equal which they should be in my mind, the kit likes to see the AI value lower than the player value and neither greater than the winthreshold, this may explain what is happeneing. Though I seem to recall Jeff and Fluf using equal values sucessfully.

Other missions are normal?

(I just saw the report on your mission at 11,13 - (base defese?) 1000pp awarded but no DV shift... lol, seems you can one or the other - that's no good. Your first mission was normal... hmmm it like theres something different about the Klinks... let me examine this... I'm going out for drinks shortly and have to work tomorrow   , but I'll do my best to figure out what's going on here...

[Strafer]

Definitely something up there, what are you drawing for enemy AI? 
Other missions are normal?

On the two C.E.s I had a F-DD and F-CL.
Other missions are reporting victories. Last one was fleet action with 2 DD left on the board against myself and a D7. No contest but still. Maybe Karnak set in a default win check if there's no chance in hell?..

[Strafer]

Hm, Klingons really aren't loved!
Convoy RAID this time. Dispatched 2 escorts and started to plot my course towards the freighters some 20K away. Got mission complete and a defeat. Didn't even get a chance to take a shot at the ships. They were nowhere near a border.

[kbf-jd]

Hm, Klingons really aren't loved!
Convoy RAID this time. Dispatched 2 escorts and started to plot my course towards the freighters some 20K away. Got mission complete and a defeat. Didn't even get a chance to take a shot at the ships. They were nowhere near a border.

could it be the alliances?  Maybe you are drawing allied freighters(even if they do not show up that way).  You kill the escorts, no enemy left so mission ends, but you have killed no freighters?

Just a thought...

jd