Topic: SGO6 status

[Bonk]

Well, whoever ordered the unthrottle of the webserver had to have a damned good reason for it. The meat and bones of this place is the server. And frucking up the DB is just damned stupid as hell...

How will the DB fair later on? Can we still clean it or are we looking at an articfire meltdown later down the road?

Wrong. It was ordered that the webserver be unthrottled with the reason being the expectation that it would speed up the kills page. (Totally wrong, see kills page load time thread). Leadership was misguided by users. Nobody actually believed me that the kills page was slow because it was loading the 1.4 MB flatfile db. I have since modified the kills page so that it no longer reads the flatfile db to get the server name and stardate. It will be considerably faster. (totally unrelated to any throttling of the webserver)

DarkElf's cleaner seems to still work fine so we should be OK, just no edits unless Dave can figure out how our db got screwed up. (objects seem to be split up now...).

I am going to ban Yahoo's spider from our site, as it has been what has been saturating our assigned bandwidth for the last few days. Hardly anybody uses Yahoo's search engine anyway, so we stand to lose nothing from banning it in my opinion.

[Bonk]

I just banned Yahoo's too greedy spider from our site in the robots.txt file:

User-agent: Slurp
Disallow: /

http://www.dynaverse.net/robots.txt

However, my remote desktop sessions have been slower than normal lately (not throttled) which indicates a larger bandwidth issue. Which I have observerd lately to be more of an issue during the day. Perhaps our cable TV thiefs are getting a lttle better at coax connections and are getting wise to schedules.

Also note lately that the ICQ status icons seem to be lagging the forums considerably. I have recently added the icq sites to my hosts file to avoid this for my browsing experience here.

127.0.0.1   web.icq.com
127.0.0.1   status.icq.com

[NuclearWessels]

Clearly we need more info before proceeding...

Also, there's a mission that starts you out 45k away from your enemy... Way too unfair for plasma captains... Minimum start distance should be 90k.

Got a mission name diz?  Manually eyeballing my way through a couple of hundred maps trying to spot a misplaced G or W isn't too reliable

thanks!
dave

Found the mission in question - looks like it was one of the maps on 17PatrolEnemy

EDIT: the updated DB editor is now posted Bonk, looks like we're still good to go!

dave

[Bonk]

EDIT: the updated DB editor is now posted Bonk, looks like we're still good to go!

Excellent! You da man! 

[Bonk]

Server is down for edits right now. Should have them done soon.

[Bonk]

Edits done. Server is back up.

Dave, I found some quirks about ship assignments though....
- I found I was unable to assign ships from a foreign race it would tell me the ship was not found, though I know it is there. I tried changing the characters race to the the race I desired to get the ship from but that did not seem to do it either.
- I also found it told me that the ship was not found if I tried to replace a second ship for the character, even though the ship was the same as the first that replaced sucessfully.
- I tried making token changes to other parts of the character first and that seemed to help, I think I came across a case of where if I did not edit something else like PP for the character first it would tell me that the ship I wanted to assign was not found.

It will take some more screwing around to figure this out I think, I can provide more detail if needed, (the db, the shiplist, the ships and characters involved...)

Otherwise, it seemed to work fine, cleaned and edited stuff without getting upset. Again, great work man!

[Bonk]

The webmap is down for now. I should have it back up shortly. I discovered that the webserver was getting the Dynaverse server database file over the WAN instead of the LAN as I was referrring to the Dynaverse server by name, which used to resolve to its LAN IP address first, but network restructuring has changed that. (this would explain some of the slowness of the webserver lately and the webmap pages in particular - as this would be consuming way too much bandwidth on the WAN when it could all be done on the LAN.) I have reconfigured the webmap to connect to the LAN IP Address of the dynaverse server directly but the permissions are not quite right for that it seems, I'll just have to fart with it a bit and should have it working again shortly.

[Hexx]

The webmap is down for now. I should have it back up shortly. I discovered that the webserver was getting the file over the WAN instead of the LAN as I was referrring to the Dynaverse server by name, which used to resolve to its LAN IP address first, but network restructuring has changed that. (this would explain some of the slowness of the webserver lately and the webmap pages in particular - as this would be consuming way too much bandwidth on the WAN when it could all be done on the LAN.) I have reconfigured the webmap to connect to the LAN IP Address of the dynaverse server directly but the permissions are not quite right, for that it seems, I'll jsut have to fart with it a bit and should have it working again shortly.

Thanks Bonk.

If I may request a small favour though. Could you keep your explanations a bit shorter?
" webmap is down" would be fine.
No offence, but I find the longer your posts, the stupider I feel.

[Bonk]

If I may request a small favour though. Could you keep your explanations a bit shorter?
" webmap is down" would be fine.
No offence, but I find the longer your posts, the stupider I feel.

Lol. Sorry, I was afraid of that. Sometimes I can take a simple message and complicate it way beyond what is necessary. I often have a hard time with the concept of "too much information".

[NuclearWessels]

Edits done. Server is back up.

Dave, I found some quirks about ship assignments though....
- I found I was unable to assign ships from a foreign race it would tell me the ship was not found, though I know it is there. I tried changing the characters race to the the race I desired to get the ship from but that did not seem to do it either.
- I also found it told me that the ship was not found if I tried to replace a second ship for the character, even though the ship was the same as the first that replaced sucessfully.
- I tried making token changes to other parts of the character first and that seemed to help, I think I came across a case of where if I did not edit something else like PP for the character first it would tell me that the ship I wanted to assign was not found.

It will take some more screwing around to figure this out I think, I can provide more detail if needed, (the db, the shiplist, the ships and characters involved...)

Otherwise, it seemed to work fine, cleaned and edited stuff without getting upset. Again, great work man!

Thanks Bonk,

it doesn't terribly surprise me - IIRC when I first glommed some of the code together I was amazed it worked at all

I'll certainly have a look to see what's up though.   
One fine day I may even clean up my code.  <ignores remarks about pigs flying>

dave

[Bonk]

Cool, just let me know if you need more info on it.

The webmap is back up.

(extra info: it was already getting the db over the LAN - it would have been impossible for it to get it over the WAN because of the way we have things setup - no filesharing on the WAN of course... Duh!  [Bonk gets to know nbtstat...] I did however limit the php code to only read the first ~800KB of the database to optimise its function, as that is all that it is currently decoding anyway, up to the end of the political tensions matrix...)

[FSD-Merlin_XC]

The mission Met_ED10PatrolEnemy only drafts 2 players

[Dizzy]

Well, it drafted u2 but not me.

[NuclearWessels]

Edits done. Server is back up.

Dave, I found some quirks about ship assignments though....
- I found I was unable to assign ships from a foreign race it would tell me the ship was not found, though I know it is there. I tried changing the characters race to the the race I desired to get the ship from but that did not seem to do it either.
- I also found it told me that the ship was not found if I tried to replace a second ship for the character, even though the ship was the same as the first that replaced sucessfully.
- I tried making token changes to other parts of the character first and that seemed to help, I think I came across a case of where if I did not edit something else like PP for the character first it would tell me that the ship I wanted to assign was not found.

It will take some more screwing around to figure this out I think, I can provide more detail if needed, (the db, the shiplist, the ships and characters involved...)

Otherwise, it seemed to work fine, cleaned and edited stuff without getting upset. Again, great work man!

OK, there were a bunch of little things tangling each other up here.

It should correctly find and assign ships now, same race or not, and should work ok for 2nd/3rd ships of a player

dave

[Bonk]

Whoohooo! I'll try assigning a captured ship on the next db clean in the morning. Thanks Dave!

[Bonk]

I'm taking the server down for morning maintenance in a few minutes...

[Bonk]

Maintenance complete. Server is back up.

Dave, the ship assignment seemed to go OK this time, one possible quirk though, I edited only one ship for one character but it showed this on the console:

Q
Finished modifications to ship 1
================================
Finished modifications to ship 2
================================

Perhaps the character had two ships? Though I thought it would ask me about the next ship if there was one...

Another potential problem: Deadman seems to have lost three characters (or maybe just his memory?) I'm downloading some of the db backups for analysis now. But at first glance at the db in a hex editor on the server there appear to ships mixed in with characters in the character table? I'm not sure if they should be? If not, I don't know how they got there, whether the server or the editor is responsible... anyway, I'll collect more detail send Deadman his login info for all his accounts and get him to test them again then we can go from there...

[Bonk]

Dave, the ship assignment seemed to go OK this time, one possible quirk though, I edited only one ship for one character but it showed this on the console:

Q
Finished modifications to ship 1
================================
Finished modifications to ship 2
================================

Perhaps the character had two ships? Though I thought it would ask me about the next ship if there was one...

We'll see what happens, I asked Chuut to test the character I assigned the captured ship to. I did not change the race of the captured ship as leaving the ship race as is seems to work fine on the SQL db the way I was doing it on the OCI... we'll see what we get.

Another potential problem: Deadman seems to have lost three characters (or maybe just his memory?) I'm downloading some of the db backups for analysis now. But at first glance at the db in a hex editor on the server there appear to ships mixed in with characters in the character table? I'm not sure if they should be? If not, I don't know how they got there, whether the server or the editor is responsible... anyway, I'll collect more detail send Deadman his login info for all his accounts and get him to test them again then we can go from there...

I checked Deadman's characters in the db and all five of them are using the same e-mail address with different case changes, perhaps he has found the limits of the "change case" bug? I'll examine his characters further to see if any of them got flagged as AI somehow or something weird like that, but I suspect we may be dealing with forgotten e-mails or the limits of the "change case bug". I am also wondering that since the server is up to 240 characters now and is lagged on startup by my combined chat channels if perhaps all the characters were not published to the character relay on startup yesterday for some reason... but so far only deadman has reported missing characters.

I also had a look through the currrent SGO6 and older SGO6 databases as well as some databases from older servers where you editor was not used and a test version of the SGO6 server I ran at home that never saw a human login nor your editor or Darkelf's cleaner and the ship and character objects are interspersed in all the db's I checked... so I guess this is normal. I had always assumed they'd be ordered... silly me!    (though realising this will help me put together a roster for the flatfile webmap eventually... Its also got me thinking about all the extra data thats stored in the SQL db that does not appear to be sasved in the flatfile db... hmmmm some of this info that normally is resident in memory only when run on the flatfile might the the source of our problems when it is stored in the db on SQL  )

Sorry for the long-winded, complicated and convoluted explanations Hexx , but these posts are intended for Dave's perusal and to facilitate my own musings... writing stuff out helps me think. Though I am a poor multitasker I tend to think laterally anyway, which come to think of it explains a lot about me.

[NuclearWessels]

Heya Bonk!

Sorry about the extra "modifications completed" message -- left it outside the appropriate if statement

And yes, the ship and character objects are interleaved - they're ordered by their id (hence by creation date).   It starts getting really mixed as the server progresses, with people buying and selling ships and creating new characters, but that doesn't cause problems.

dave

[Bonk]

Sorry about the extra "modifications completed" message -- left it outside the appropriate if statement

Ah, no problem... I was just wondering if it had created an extra ship or something. Good to know it was just an extra message. I'm dying to hear Chuut's report on use of the assigned captured ship. This new and improved editor will be a real boon to future servers. Once again, excellent work!

And yes, the ship and character objects are interleaved - they're ordered by their id (hence by creation date).   It starts getting really mixed as the server progresses, with people buying and selling ships and creating new characters, but that doesn't cause problems.

That makes sense... hadn't occurred to me.