COMPLETE PUBLIC SERVER SETUP - Jan-2011 - Page 13

Apoc.Index · #**181** 09-04-2011, 12:35 PM

Double check your eqemu_config.XML file in your eqemu folder. It looks as if its not connecting properly. You can follow this post if you dont know what parts to check/edit.

http://eqemulator.org/forums/showthread.php?t=32980

If that is in order, double check any port fowarding on your router (if you have one). The same post on the bottom will teach you about port forwarding.

Rhodan · #**182** 09-18-2011, 10:48 AM

installing Mysql just about drove me up the wall. I made a mistake and uninstalled/reinstalled but it kept acting like there was already a password after a reinstall.

Well it took a while to find it but mysql (at least the 5.1 version) does not delete its databases when it uninstalls. On windows 7 the database is in a hidden directory called AppData and the Mysql dir in AppData has to be erased to remove the "old" password. Of course, if someone wants to keep a database and wants to only reset the password they'll have to hit google.

Baruuk · #**183** 09-19-2011, 10:12 PM

Hi fellas - been away from the EMU for about a year and thought I'd give it another whirl. Thanks for this great guide. Overall it was pretty easy to follow and helped a bunch. One question however... Everything compiled and is configured fine it seems - i get no errors when launching WORLD.EXE, etc - it looks happy. I even see my new server listed in the public login server list. However, when I go to click on it (my client is an SoD build and eqhost.txt configured with port 5999), it never displays a character select screen. It simply hangs. Below is the error I'm getting in my world window. It looks like my login server account simply doesnt exist on the world server and it chokes - and since I'm not running a private login server, it dies. However, I'm not sure. How do accounts get created on the server? (BTW - IP and login account have been replaced below) Thanks in advance.

[Debug] [WORLD__CLIENT] New connection from x.x.x.x:57859
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2792
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2ec9
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x4dd0
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_world, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x7213
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_zone, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x6c3c
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x737e
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode matched 0xff4 and
length matched 464
[Debug] [NET__IDENTIFY] Identified stream x.x.x.x:57859 with signature So
D_world
[Debug] [WORLD__CLIENT] Checking inbound connection x.x.x.x against Banne
dIPs table
[Debug] [WORLD__CLIENT] Connection x.x.x.x PASSED banned IPs check. Processing connection.
Account Attempting to be created:myaccount 0
Error in CreateAccount query 'INSERT INTO account SET name='myaccount', status=0,
lsaccount_id=175494, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'myaccount', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '175494'

sorvani · #**184** 09-19-2011, 11:16 PM

drop and resource your DB with the latest db_incremetnal or whatever it is called form the database SVN. Then source in every SQL file in the server SVN SQL sub folder > 1900 that does not have the word optional in it.

Baruuk · #**185** 09-19-2011, 11:17 PM

Quote:

Originally Posted by Baruuk

Hi fellas - been away from the EMU for about a year and thought I'd give it another whirl. Thanks for this great guide. Overall it was pretty easy to follow and helped a bunch. One question however... Everything compiled and is configured fine it seems - i get no errors when launching WORLD.EXE, etc - it looks happy. I even see my new server listed in the public login server list. However, when I go to click on it (my client is an SoD build and eqhost.txt configured with port 5999), it never displays a character select screen. It simply hangs. Below is the error I'm getting in my world window. It looks like my login server account simply doesnt exist on the world server and it chokes - and since I'm not running a private login server, it dies. However, I'm not sure. How do accounts get created on the server? (BTW - IP and login account have been replaced below) Thanks in advance.

[Debug] [WORLD__CLIENT] New connection from x.x.x.x:57859
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2792
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2ec9
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x4dd0
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_world, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x7213
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_zone, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x6c3c
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x737e
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode matched 0xff4 and
length matched 464
[Debug] [NET__IDENTIFY] Identified stream x.x.x.x:57859 with signature So
D_world
[Debug] [WORLD__CLIENT] Checking inbound connection x.x.x.x against Banne
dIPs table
[Debug] [WORLD__CLIENT] Connection x.x.x.x PASSED banned IPs check. Processing connection.
Account Attempting to be created:myaccount 0
Error in CreateAccount query 'INSERT INTO account SET name='myaccount', status=0,
lsaccount_id=175494, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'myaccount', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '175494'

EDIT: I figured this out - I needed to add a column to the account table. I was able to get to the Character Select screen and create a toon

The only hangup I have now is the ability to actually get into a zone. I created a Vah Shir and selected Shar'Vahl - but it disconnected me. My suspicion is it's my client maybe - I'll work on it tomorrow.

Thanks anyways!

Lazzeraith · #**186** 10-02-2011, 03:16 AM

For Perl, go here - (I use 5.1 - 1007 version)
http://www.activestate.com/activeperl/downloads

Where can I get this version, that link is no good for it anymore, just have 5.12 and 5.14. I am trying, without any success, to setup a server. The guides are great but still leave people, in the dark without a clue as to how to do this, short. I tried using strawberry perl 5.10.1.5, but when I issue the ppm install DBI and ppm install IO-stringy commands, I get error installing package 'dbi': could not locate a PPD file for package dbi and same for IO-stringy. Any help would be great, I really miss playing this game.

Lazzeraith · #**187** 10-02-2011, 04:52 AM

I am trying with Perl 5.12. Another problem popped up, when added the settings to Visual C++ 2008....

C:\mysql\include <------- I do not have the include folder
C:\perl\lib\CORE
C:\zlib\include

and

LIBRARY:
C:\mysql\lib\opt <------ I do not have this one either, under the mysql folder
C:\perl\lib\CORE
C:\zlib\lib

lerxst2112 · #**188** 10-02-2011, 06:04 AM

If you don't have the correct MySQL directories then you don't have it installed properly or you don't have the proper version of MySQL. I use 5.0, but I've heard 5.1 works fine as well. You want the 32-bit version with the installer.

http://downloads.mysql.com/archives....sql-5.0&o=-win

If you use Perl 5.12 you will need to change these lines to "perl512.lib"

trunk\EQEmuServer\world\EQWParser.cpp(35):#pragma comment(lib, "perl510.lib")
trunk\EQEmuServer\zone\embperl.cpp(26):#pragma comment(lib, "perl510.lib")

Lazzeraith · #**189** 10-04-2011, 02:28 PM

Thank you, that got that fixed. Now though I am having a problem with this:

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

When I right click on the folder the SVN Checkout option is not there anymore, it has SVN Update, SVN Commit..., and the TortoiseSVN options. I cannot seem to find a way to paste the addy.

Aeryn · #**190** 10-04-2011, 02:49 PM

You already have a URL associated with that folder

To check or change it
go into the tortoise options and choose "Relocate"
that will show the url currently associated with the folder, change it there if it's wrong

Lazzeraith · #**191** 10-04-2011, 04:15 PM

Did that and got a TortoiseSVN error box.

The repository at 'http://projecteqquests.googlecode.com/svn/trunk/quests' has uuid '858f6fc0-2484-11de-a087-198e6c7179d9', but the WC has 1db01234-8a6e-11dd-8937-b3a0fbe'

Lazzeraith · #**192** 10-04-2011, 04:39 PM

Also when I opened the relocate option it had this URL http://projecteqemu.googlecode.com/s...efaults/quests, I replaced it with the one from the guide http://projecteqquests.googlecode.com/svn/trunk/quests and got the error from the above post. Is it possible to manually download these files and put them in the folder or is there a needed purpose for using SVN?

Lazzeraith · #**193** 10-05-2011, 03:51 PM

Ok I cheated, made same named folders on different drive pasted links then copied them to server directory.

Lazzeraith · #**194** 10-05-2011, 04:59 PM

You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.

Hello,

I am using rev_2022.sql, when I did the above set I get the following error.

[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
[Err] 1060 - Duplicate column name 'time_creation'
[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Msg] Finished - Unsuccessfully
-------------------------------------------------

Also in using rev_2022, this means I will have execute all the files higher than 1711 ?

**joligario** · #**195** 10-05-2011, 07:26 PM

with 2022 all updates are already applied and current to 2022