Guild of Writers

Posted: **Tue Dec 01, 2009 2:21 pm**

kaelisebonrai wrote:Blast. That means I have the wrong version on there. If anyone still has it, then, I'll fix that slight oversight.

Just grab a hex editor and replace all insances of "auth.plasma.corelands.com" and "/info" with 0x00. It's a really handy trick.

(RIP 666 Posts)

Posted: **Wed Dec 02, 2009 12:31 am**

And then it will fall back to the local auth database accessed via mySQL? Wow, that's indeed simpler than writing a new PHP auth gateway

Posted: **Wed Dec 09, 2009 6:14 pm**

Indeed... The only reason the PHP auth gateway was used after the discovery of this trick was to use a form of dual-authentication -- that is, use accounts already available on Cyan's Global Auth Server (CGAS) as well as the local database. After CGAS got shut down, the more efficient and easier option is just to use the pure local auth with no proxy.

Posted: **Thu Dec 10, 2009 3:32 am**

okay, I've attempted to hex edit this properly, so, in the same directory as before, there should be a .7z file with the suffix -hexed, can someone check that I did this correctly? I have a tendency to screw up hex editing.

Posted: **Thu Dec 10, 2009 3:08 pm**

Like Atrion, I am also trying to set up an UU server, even if just for the sake of doing it. I have managed to get an Alcugs server running, but UU has proved to be much more difficult. I think I am almost set now. I do not know much about MySQL so I have followed UU server installation instructions found on the web in order to know what entries to make. However, I could not find info on creating the user in the local auth database. What entries need to be made for that?

Posted: **Fri Dec 11, 2009 4:57 pm**

An example for inserting a new user:

Code: Select all

INSERT INTO Accounts (AcctName, HashedPassword, IsActive, AcctUUID) VALUES ('Nadnerb','463418FA8261503A2B70C403F7DFBB34',1,'7FB62651-3E81-11DD-AE16-0800200C9A6A');

Note that HashedPassword is a hex digest of an MD5 hash of the password, using all capital letters, AcctUUID is a GUID for the player, which you should generate, and AcctName and IsActive should be self explanatory. The rest of the columns will be filled in automatically if you don't specify values.

Edit: D'oh, read your post again and realized you were just asking for the part about adding users. former first half of post below <_<

Show Spoiler

I seem to recall the authserver creating the auth tables automatically once started, and it only needed filling in, but I may be misremembering.

Either way, you need the following tables in your auth database:

Code: Select all
CREATE TABLE Accounts (
  Idx int(10) unsigned NOT NULL auto_increment,
  AutoTime timestamp(14) NOT NULL,
  AcctName varchar(32) NOT NULL default '',
  AcctType int(11) NOT NULL default '0',
  Password varchar(32) NOT NULL default '',
  HashedPassword varchar(32) NOT NULL default '',
  IsActive int(11) NOT NULL default '0',
  CreatedOn datetime NOT NULL default '0000-00-00 00:00:00',
  ExpiresOn datetime NOT NULL default '0000-00-00 00:00:00',
  NeverExpires int(11) NOT NULL default '0',
  BillingIdx int(10) unsigned NOT NULL default '0',
  AcctUUID varchar(40) NOT NULL default '',
  PRIMARY KEY  (Idx),
  UNIQUE KEY NamePasswdUnique (AcctName,Password),
  KEY AcctName (AcctName)
);

CREATE TABLE DatabaseVersion (
  DatabaseVersionNumber int(11) NOT NULL default '0',
  PRIMARY KEY  (DatabaseVersionNumber)
);

CREATE TABLE Permissions (
  AcctName varchar(32) NOT NULL default '',
  AcctStatus enum('KLINE','PRIVATE','ADMIN') default NULL,
  UNIQUE KEY AcctName (AcctName)
);

CREATE TABLE TableVersions (
  Idx int(10) unsigned NOT NULL auto_increment,
  TableName varchar(64) NOT NULL default '',
  TableVersion int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (Idx),
  UNIQUE KEY TableName (TableName)
);

Posted: **Sat Dec 12, 2009 7:47 am**

You can get the all-capital MD5 hash-sum of your password with the following command on Linux:

Code: Select all

echo -n "account pasword" | md5sum | tr [:lower:] [:upper:]

The GUID must not only be well-formed (all upper-case and with the dashes at the right position and the correct length) has to be unique as in no two accounts on the same database may have the same (since it's only a local auth database, clashes with other databases don't matter).

Posted: **Sat Dec 12, 2009 5:36 pm**

You can actually do the password hashing entirely within MySQL... If you're using an old version (4.0 or earlier), you can use:

Code: Select all

INSERT INTO Accounts (AcctName, HashedPassword, IsActive, AcctUUID) VALUES
    ('acct name', UPPER(MD5('password')), 1, 'some externally generated uuid');

However, in newer versions, you need to convert the MD5() result to a non-binary string:

Code: Select all

INSERT INTO Accounts (AcctName, HashedPassword, IsActive, AcctUUID) VALUES
    ('acct name', UPPER(CONVERT(MD5('password') USING latin1)), 1, UPPER(UUID()));

Note also that in MySQL 4.1+, you can use the server itself to generate UUIDs (the UUID() call).

Posted: **Sat Dec 12, 2009 9:25 pm**

Thank you all for the info. That was what I needed. I knew how to do it in Alcugs, but there were a few differences with this.

I now have the user created. However, I am stuck at "Fetching Player". As far as I can tell, everything is configured as it should be so I do not know the cause. Perhaps I need to use a different MySQL version? I am using 4.0.25 on FC2. I have had a hard time finding older (4.0) versions on the web. I have tried 4.0.24 and a couple newer versions, but they did not work properly with UU. The version I use now has given me the best results so far (but perhaps not good enough).

EDIT: Problem solved! The problem was apparently with the GUID. Thanks again for the help.

Posted: **Sun Dec 13, 2009 8:43 am**

Thanks for these commands, Zrax, I will add them to the Alcugs instructions

Guild of Writers

Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.

Re: Until URU Setup Question.