Page 1 of 1

My shard is shown as offline

Posted: Thu May 13, 2010 9:59 am
by ntony
It is a RunUO 2.0 Final shard

I can grep the connection log from UOGateway

Code: Select all

Client: 67.19.158.242: Connected. [21 Online]
Client: 67.19.158.242: Disconnected. [20 Online]
Client: 67.19.158.242: Connected. [21 Online]
Client: 67.19.158.242: Disconnected. [20 Online]
Client: 67.19.158.242: Connected. [22 Online]
Client: 67.19.158.242: Disconnected. [21 Online]
Client: 67.19.158.242: Connected. [22 Online]
Client: 67.19.158.242: Disconnected. [21 Online]
Client: 67.19.158.242: Connected. [21 Online]
Client: 67.19.158.242: Disconnected. [20 Online]
Client: 67.19.158.242: Connected. [21 Online]
Client: 67.19.158.242: Disconnected. [20 Online]
Client: 67.19.158.242: Connected. [21 Online]
Client: 67.19.158.242: Disconnected. [20 Online]
Is there any problem on my shard?

Archived topic from AOV, old topic ID:5106, old post ID:32999

My shard is shown as offline

Posted: Thu May 13, 2010 10:00 am
by ntony
The UOGateway URL for my shard

http://www.uogateway.com/shard.php?id=320&act=view


Thanks!

Archived topic from AOV, old topic ID:5106, old post ID:33000

My shard is shown as offline

Posted: Thu May 13, 2010 11:17 am
by Red Squirrel
That is odd. I will check the uog log when I get home. Unless final does not support the same packet uog uses or something.

Archived topic from AOV, old topic ID:5106, old post ID:33001

My shard is shown as offline

Posted: Thu May 13, 2010 11:20 pm
by ntony
My shard is not using auto account creation. I have account registration web page for it. Is that the reason? If so, should I create an account for UOGateway?

More information, my shard is running on Linux platform using Mono runtime.

Archived topic from AOV, old topic ID:5106, old post ID:33002

My shard is shown as offline

Posted: Thu May 13, 2010 11:38 pm
by Red Squirrel
That should not make a difference, at least I can't see why it would. I just posted a sticky on how UOG works.

Also this is a log entry from the poller:

Code: Select all

[May-13-2010 05:08:23am] Connecting to HKUO Hardcore [server.hkuoshard.com:2594] (Attempt 1)

[May-13-2010 05:08:24am] Connected, sending stats packet...

[May-13-2010 05:08:36am] Time out exceeded while waiting for response

[May-13-2010 05:08:36am] Connecting to HKUO Hardcore [server.hkuoshard.com:2594] (Attempt 2)

[May-13-2010 05:08:36am] Connected, sending stats packet...

[May-13-2010 05:08:48am] Time out exceeded while waiting for response

[May-13-2010 05:08:48am] Connecting to HKUO Hardcore [server.hkuoshard.com:2594] (Attempt 3)

[May-13-2010 05:08:48am] Connected, sending stats packet...

[May-13-2010 05:09:00am] Time out exceeded while waiting for response

[May-13-2010 05:09:02am] Updating graphs for HKUO Hardcore
It seems your shard is not sending a response, or maybe even dropping the connection when it receives the stats packet. Did this work before with your shard? Where is it hosted? Wondering if it takes too long to respond and the poller times out.

Archived topic from AOV, old topic ID:5106, old post ID:33004

My shard is shown as offline

Posted: Fri May 14, 2010 12:50 am
by ntony
I have removed the item stat and online players count in "player login welcome messsage". Would it be the reason?

Archived topic from AOV, old topic ID:5106, old post ID:33005

My shard is shown as offline

Posted: Fri May 14, 2010 10:27 am
by Red Squirrel
Hmm maybe it controls that packet too, try adding it back to see if it does anything. I don't think so though.

Archived topic from AOV, old topic ID:5106, old post ID:33006

My shard is shown as offline

Posted: Sat May 15, 2010 2:04 am
by ntony
Red Squirrel wrote:Hmm maybe it controls that packet too, try adding it back to see if it does anything. I don't think so though.
If your engine is using specific packet replied by RunUO, I think it's not the cause.

Archived topic from AOV, old topic ID:5106, old post ID:33007

My shard is shown as offline

Posted: Mon May 17, 2010 5:21 am
by ntony
OK, Sir/Lady Red Squirrel. :P

I have read your sticky and checked my Network.cs
It seems that the standard authenicate command packet on RunUO 2.0 Final is 0x02

and the packets sent by your poller are:

Code: Select all

tcpquery.WriteInt8(0x7f);
tcpquery.WriteInt16(0x00);
tcpquery.WriteInt8(0x7f);
tcpquery.WriteInt8(0xf1);
tcpquery.WriteInt8(0x00);
tcpquery.WriteInt8(0x04);
tcpquery.WriteInt8(0xff); 
And my shard is using web account registration instead of auto account registration. May I know the username and password which UOG is using as shard info polling? So that I can create one for UOG. Thanks again!

Archived topic from AOV, old topic ID:5106, old post ID:33009

My shard is shown as offline

Posted: Mon May 17, 2010 8:36 am
by Red Squirrel
It actually does not use an account. Guess RunUO went and changed the other packet on me. I'll have check that out.

Archived topic from AOV, old topic ID:5106, old post ID:33010

My shard is shown as offline

Posted: Mon May 17, 2010 10:10 am
by ntony
Thanks!

I've found the command packets sent by ConnectUO in their forum

Code: Select all

0xF1 0x00 0x04 0xFF
Archived topic from AOV, old topic ID:5106, old post ID:33011

My shard is shown as offline

Posted: Wed May 19, 2010 5:07 am
by ntony
I tried to write my poller and turned to find that it is the problem of Linux Mono. I will apply a workaround to bypass this problem. Thanks!

Archived topic from AOV, old topic ID:5106, old post ID:33012

My shard is shown as offline

Posted: Wed May 19, 2010 6:17 pm
by Red Squirrel
Interesting, let me know what the outcome is! Odd that it would mess up like that though.

I actually tried to run my shard on Mono but found it too buggy... well not really buggy, just, there was like a billion compile errors I was not ready to go through LOL.

Archived topic from AOV, old topic ID:5106, old post ID:33013

My shard is shown as offline

Posted: Thu May 20, 2010 1:57 am
by ntony
Red Squirrel wrote:Interesting, let me know what the outcome is! Odd that it would mess up like that though.

I actually tried to run my shard on Mono but found it too buggy... well not really buggy, just, there was like a billion compile errors I was not ready to go through LOL.
It depends on the Linux distro and Mono version you are using.
I have two shards running on Mono. One of it has been up for 1.5 years without any problem. Of course, I did many tests and customization on it. It was from the SVN 301 trunk.
Another shard I'm running is RunUO Final 2.0. It has been 1.5 month without any problem.

Maybe we can discuss about running a shard on Mono. Add me into your contact if you use MSN (ntonywork [at] gmail [dot] com)


Is there a way for me to reset my shard stat on UOGateway? My shard was not responding data to your poller. And it's now being fixed. Thanks!

Archived topic from AOV, old topic ID:5106, old post ID:33014

My shard is shown as offline

Posted: Thu May 20, 2010 3:33 pm
by Red Squirrel
It can't be reset, but if you want I can always do it manually, or you can delete and readd.

For now we will continue to run the shard on windoze as we have done too many major changes but eventually maybe we'll try to convert.

Archived topic from AOV, old topic ID:5106, old post ID:33015

My shard is shown as offline

Posted: Thu May 20, 2010 10:42 pm
by ntony
Red Squirrel wrote:It can't be reset, but if you want I can always do it manually, or you can delete and readd.

For now we will continue to run the shard on windoze as we have done too many major changes but eventually maybe we'll try to convert.
any core modification? but it can still be done easily.

Archived topic from AOV, old topic ID:5106, old post ID:33016

My shard is shown as offline

Posted: Fri May 21, 2010 12:28 pm
by Red Squirrel
Yeah the core is quite modified, though I will be simplifying it soon. Going to convert the SQL to a custom DBMS so I wont have to worry about the mysql library. Probably part of all the errors. We are running an older version of RunUO but it has tons of fixes and stuff applied, but I do know the older versions did not compile with mono out of the box so it will take some work if I want to make it work, but it's doable.

Archived topic from AOV, old topic ID:5106, old post ID:33017

My shard is shown as offline

Posted: Fri May 21, 2010 10:39 pm
by ntony
Red Squirrel wrote:Yeah the core is quite modified, though I will be simplifying it soon. Going to convert the SQL to a custom DBMS so I wont have to worry about the mysql library. Probably part of all the errors. We are running an older version of RunUO but it has tons of fixes and stuff applied, but I do know the older versions did not compile with mono out of the box so it will take some work if I want to make it work, but it's doable.
How do you replace serialization with DBMS?


p.s. I've [deleted] my shard and register again with the same username. The new shard information is not yet listed for a day.

Archived topic from AOV, old topic ID:5106, old post ID:33018

My shard is shown as offline

Posted: Fri May 21, 2010 10:56 pm
by Red Squirrel
Oh it's a big project. It sorta uses serialization, but now it only updates items that change, and it's a bit more realtime. I've run into performance issues as serialized binary data is not really well fit for a typical DBMS so I am coding a custom DBMS app that will handle this data. There will be no halting saves.

As for your shard not showing up, I'll have to test with the latest RunUO then, see if they changed that packet. If the shard registers as offline right off the bat, then it will not show up until the first time it registers online.

Archived topic from AOV, old topic ID:5106, old post ID:33019

My shard is shown as offline

Posted: Fri May 21, 2010 11:08 pm
by ntony
Red Squirrel wrote:Oh it's a big project. It sorta uses serialization, but now it only updates items that change, and it's a bit more realtime. I've run into performance issues as serialized binary data is not really well fit for a typical DBMS so I am coding a custom DBMS app that will handle this data. There will be no halting saves.

As for your shard not showing up, I'll have to test with the latest RunUO then, see if they changed that packet. If the shard registers as offline right off the bat, then it will not show up until the first time it registers online.
I have planned to do such a mod of RunUO as well. I think a generic serialize-able interface/class should be designed. And members could be saved separately and flexibly.


My shard is here: http://www.uogateway.com/shard.php?id=324&act=view

I've fixed everything and should be able to reply with proper packets, but it's not shown as online.

Archived topic from AOV, old topic ID:5106, old post ID:33020

My shard is shown as offline

Posted: Sun May 23, 2010 12:54 am
by Red Squirrel
Looks like it's showing now. Guess it just took a bit before it kicked in.

Archived topic from AOV, old topic ID:5106, old post ID:33021

My shard is shown as offline

Posted: Wed May 26, 2010 11:52 pm
by ntony
yea!
thanks a lot!

and maybe we can discuss how to replace serialization with RDBMS.
got MSN or AIM?
my AIM contact is ntonyworkshop [at] gmail (dot) com

Archived topic from AOV, old topic ID:5106, old post ID:33036

My shard is shown as offline

Posted: Thu May 27, 2010 1:26 am
by Red Squirrel
I get people ask me often actually, one of these days I should probably write a guide. I did post some stuff on the Runuo site at some point but most people have just shot down the idea.

I'm actually in the middle of changing things around and using a custom DBMS so I might post something about that at some point.

The serialization is actually still there, it's just saved differently. If I was to design a shard server from scratch I'd use a well structured DB though, but think the reason they went with serialization is that it's faster then read/write to a DB in real time. I'm sure if done properly it could work though, may just need to cache lot of data in memory, but no need to load every single object.

Archived topic from AOV, old topic ID:5106, old post ID:33037