COMPLETE PUBLIC SERVER SETUP - Jan-2011

[keglo]

Now I have a new problem. I am on step 11 where I need to download the maps and quest. The problem is that all the folders already have a green check on them, therefore I can't choose "SVN Checkout". I seen this same problem asked about a few pages back, but didn't really see a clear answer to the problem. Someone mentioned downloading the .rar map files and extracting to the map folder, but that doesn't explain what to do about the quest folder.

[lerxst2112]

If you're following the guide properly, the server folder should be separate from the source and database folders that are under SVN control.

Check again that you followed step 7 properly.

[keglo]

Originally Posted by lerxst2112

If you're following the guide properly, the server folder should be separate from the source and database folders that are under SVN control.

Check again that you followed step 7 properly.

Yes I checked and followed the steps properly. The problem is that when I did step 8 and downloaded all the source files, it put a green check on nearly everything inside. Including the maps and quest folder in /source/trunk/EQEmuServer/utils/defaults. So when I do the following part in step 10

"Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn"

it carried over the green checks from the source folder into the server folder. So with the green checks already there it will not let me SVN Checkout.

[sorvani]

You failed to NOT copy the .svn folders from your source to server folders when you copied your stuff over.
If you don't see them, change your folder setting to show hidden files and folders etc.

[keglo]

Originally Posted by sorvani

You failed to NOT copy the .svn folders from your source to server folders when you copied your stuff over.
If you don't see them, change your folder setting to show hidden files and folders etc.

Ok the instructions are

Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn

It says "YOU DON"T need the folder (singular) called .svn." There is a .svn folder in /source/trunk/EQEmuServer/utils/defaults. I did not copy that file over. I assumed by the way the instructions are worded that it was that singular file that it was refering to. There are other .svn folders within each of the other files located in the /default folder. Are you telling me that I need to go through all of these folders and delete the .svn folder from each one before I copy the folders over?

UPDATE:
I tried doing just that, deleting all the .svn files from each folder before copying them over and it seems to be working. I am updating the quest folder per the instructions as I type this. Thanks for the help!

[keglo]

Now at step 13

So NOW, you can download and source in the database (and updates needed)

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

I'm lost here. Where does this file, peqdb_rev175.sql.gz, come from? I haven't seen it mentioned elsewhere in the instructions so I assumed that it would be downloaded into the peqdb folder in step 13, but it isn't there. Where do I find it please?

[blackdragonsdg]

The database revision has changed since any of the guides were written. Look for database_incremental.zip instead of peqdb_rev1751.sql.gz.

[keglo]

Originally Posted by blackdragonsdg

The database revision has changed since any of the guides were written. Look for database_incremental.zip instead of peqdb_rev1751.sql.gz.

Thank you!! That worked. Now...

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.

I tried removing the first line but I still get a failure with 1711_account_restricted_aa.sql.

Any ideas?

[Rhodan]

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]

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'

[Baruuk]

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!

[sorvani]

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.

[Lazzeraith]

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]

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]

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")