My shard is shown as offline

ntony · Post by **ntony** » Thu May 13, 2010 9:59 am

It is a RunUO 2.0 Final shard

I can grep the connection log from UOGateway

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

ntony · Post by **ntony** » Thu May 13, 2010 10:00 am

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

Red Squirrel · Post by **Red Squirrel** » Thu May 13, 2010 11:17 am

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

ntony · Post by **ntony** » Thu May 13, 2010 11:20 pm

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

Red Squirrel · Post by **Red Squirrel** » Thu May 13, 2010 11:38 pm

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

ntony · Post by **ntony** » Fri May 14, 2010 12:50 am

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

Red Squirrel · Post by **Red Squirrel** » Fri May 14, 2010 10:27 am

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

ntony · Post by **ntony** » Sat May 15, 2010 2:04 am

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

ntony · Post by **ntony** » Mon May 17, 2010 5:21 am

OK, Sir/Lady Red Squirrel.

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

Red Squirrel · Post by **Red Squirrel** » Mon May 17, 2010 8:36 am

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

ntony · Post by **ntony** » Mon May 17, 2010 10:10 am

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

ntony · Post by **ntony** » Wed May 19, 2010 5:07 am

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

Red Squirrel · Post by **Red Squirrel** » Wed May 19, 2010 6:17 pm

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

ntony · Post by **ntony** » Thu May 20, 2010 1:57 am

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

Red Squirrel · Post by **Red Squirrel** » Thu May 20, 2010 3:33 pm

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

ntony · Post by **ntony** » Thu May 20, 2010 10:42 pm

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

Red Squirrel · Post by **Red Squirrel** » Fri May 21, 2010 12:28 pm

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

ntony · Post by **ntony** » Fri May 21, 2010 10:39 pm

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

Red Squirrel · Post by **Red Squirrel** » Fri May 21, 2010 10:56 pm

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

ntony · Post by **ntony** » Fri May 21, 2010 11:08 pm

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

Red Squirrel · Post by **Red Squirrel** » Sun May 23, 2010 12:54 am

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

ntony · Post by **ntony** » Wed May 26, 2010 11:52 pm

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

Red Squirrel · Post by **Red Squirrel** » Thu May 27, 2010 1:26 am

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