Working Lan Server Working Smoothly

[Umlaut]

Now go back one folder (get out of BUILD), and copy changelog.txt to eqemu folder
IN that same folder is another folder called eqlaunch. Inside there is a folder called
Realease. In that folder is a file to copy eqlaunch.exe to your eqemu folder.
Now go back one folder (/trunk/EQEmuServer) and you will see utils folder.
Inside there, is 8 files you need. - mail_opcodes.conf, opcodes.conf, patch_6.2.conf,
patch_Anniversary.conf, patch_Live.conf, patch_SoD.conf, and patch_Titanium.conf

Stuck on step 13.
Found the changelog.txt and moved it.
Then it says to go into the eqlaunch folder.
Ok, found that.
The it says that in that folder is another folder called Release.
I don't see a release folder in C:\EQEmuSource\trunk\EQEmuServer\eqlaunch
I do see one in C:\EQEmuSource\trunk\EQEmuServer\Build\eqlaunch, but you told us to get out of the Build folder.
Plus, in that Release folder I don't see a file that is going to copy the eqlaunch.exe file to my eqemu folder.

The build has probably changed since the instructions were written, so any help here would be nice.

Thanks for the great guide so far!

[joligario]

I consolidated the build locations together a while ago for common sense so you don't have to look all over for your builds.

[Umlaut]

Ok, got through the guide.
Got past the 10061 error I was getting.
I can log in, but like Banderas on the bottom of the first page, I have no servers listed.

I guess I'll start digging through the forums.

Thanks!

[Umlaut]

Ok, got the server to be listed.
Now getting the infamous 1017 error.
I am just trying to set this up as a private LAN server.
It is a virtual 2003 server running on a Windows 2008R2 server.
Nothing connecting from outside, and the only thing between my client computer and the server is a netgear prosafe gs116 switch.

With the same client, if I adjust the eqhosts file, I can successfully connect to the Project 1999 server.

I even just did a complete uninstall and re-install of EQ with my Titanium Discs.

I've been digging through the forums, but so far all I am seeing is people with routers having problems.

I'll keep digging, but if anyone has any ideas, I would appreciate it.
Thanks!

[eviakhan]

Thanks for putting this guide together Huppy, I really appreciate you taking the time to document all these steps, extremely helpful.

I finally got my lan server up and running successfully thanks to this guide and a few other helpful folks on these forums. I wanted to share my findings in setting this up in hope that someone can use my experience. Since my server setup was a while after this guide was written some things have changed slightly or were not exactly clear to me, so here are some my notes that may help others:

Setup date: 9/22/2011
EqEmu revision: 2018
Database revision: 1900 -- but this is no longer clear, the latest database updates are not labeled clearly like "peqdb_Rev1667.sql" but instead simply, "db_dump.sql" this is the file you need to setup the database.

1) After you get your database setup You need to run all the sql files in the following directory (if you setup as Huppy suggested):
C:\eqemusource\EQEmuServer\utils\sql\svn
any file that is after your database revision, 1900, so starting with file 1908_required_npc_types_definitions.sql up through
2004_charges_alt_currency.sql, you do not need to run the "optional" files.

2) There are a couple of sql update files that break the above rule, you need to run these two file even though they are less than 1900:
1711_account_restricted_aa.sql -- this fixed my login problems
1723_required_sql_corruption.sql -- you need this if you want BOTS
-- note we do not need the last line of 1723, it must have been added previously

3) eqemulogin.ini does not exist anymore, use login.ini instead populate like this:
[database]
host = localhost
port = 3306
db = PEQLoginDB
user = root
password = <yourpassword>
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = FALSE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.0.100


4) eqemu_config.xml
Mine needed to be set up slightly differently than in the guide:
note replace 192.168.9.999 with your ip:

<?xml version="1.0">
<server>
<world>
<shortname>Huppys</shortname>
<longname>Huppys Little Norrath</longname>
<localaddress>192.168.9.999</localaddress>

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>192.168.9.999</host>
<port>5998</port>
<account>Admin</account>
<password>Password</password>
</loginserver>

... the rest of the eqemu_config.xml file is as Huppy set up.

Thats all for now, have fun seting up =)

[joligario]

FYI, there was a new database update a few hours ago with the former naming convention.

[lerxst2112]

Originally Posted by joligario

FYI, there was a new database update a few hours ago with the former naming convention.

lol, once again proving that as soon as a guide is written it's out of date.

[sorvani]

guides need to be on the wiki so they can be updated, and the wiki needs redone so that you can actually easily find said guides.

but then again as a programmer i find documentation ummm annoying to do :P need to hire a secretary!

[Lazzeraith]

We're going to make two seperate .sql files here.
First, copy and paste this text into notepad:

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('huppyname', sha('huppypassword'), 'fakename@hotmail.com', now(), '192.168.1.103');

This is going to create a login account for you to login with your client (or anyone else)
You need to edit a few things. AFTER THE WORD VALUES (nothing before that)
huppyname to whatever you want. huppy password to whatever.
fakename@hotmail to whatever ( I left mine like that). and finally the IP address of your lan
computer that this user will log in from. 192.168.1.xxx
You can save this file as accounts.sql (make sure it has a .sql extention.

The second file, copy and paste the following in to notepad as well:

INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'Huppys Little Norrath', 'ServerTagDescription', 'Huppys', '2', NULL, NULL, '1', NULL);

DO NOT GIVE YOUR SERVER A NAME with the word SERVER in it. That will get added on automatically.
You just need to change the 2 things here Huppys Little Norrath to what you want and the short name of huppys.

What name do you use to save the second .sql file?

And I am guessing these files are saved in the EQEMU folder.

[lerxst2112]

Those are commands you need to execute on your database. You can do it by pasting them into the query window in whatever sql tool you use and executing them, or you can save the files and source them like you did the other sql files. The names aren't important as long as you source whatever you save them to.

[Lazzeraith]

Originally Posted by lerxst2112

Those are commands you need to execute on your database. You can do it by pasting them into the query window in whatever sql tool you use and executing them, or you can save the files and source them like you did the other sql files. The names aren't important as long as you source whatever you save them to.

Oh, that went over my head completely. What query window? How do you execute these? Yes I am an idiot when it comes to this stuff.

[Lazzeraith]

Now open up a command prompt and you need to navgigate to c:\peqdb if you don't know how
to do this, just type cd c:\peqdb
Now type the following: mysql -uroot -p(password) -b (the -b disables error beeps)
The passowrd you use in that line is whatever you entered when installing MySQL.
DO NOT USE THE (.....), with your password. And NO space between the -p and your password.
After you hit Enter, you will see a command prompt like this C:\mysql>

First type this: use peq (then hit enter and you will see "database changed")
Then type this: source peqdb_rev1667.sql (hit enter again and wait for it to finish)
Also type this: source load_player.sql (press enter)

So I would take the 2 files I created and do the steps above.
It would be: source accounts.sql ?????

[Lazzeraith]

Can anyone helpout with this?

[Lazzeraith]

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');

after editing the values I get this error:

C:\eqemusource\trunk\EQEmuServer\EQEmuLoginServer\ login_util>INSERT INTO tblLogi
nServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, Last
IPAddress) VALUES('******', sha('******'), 'fakename@hotmail.com', now(),
'192.168.0.12');
'INSERT' is not recognized as an internal or external command,
operable program or batch file.

[Derision]

You need to paste the command into a MySQL command prompt:

C:\> mysql -u root -p peq
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 159
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, Last
IPAddress) VALUES('******', sha('******'), 'fakename@hotmail.com', now(),
'192.168.0.12');

I am assuming you called your database 'peq'. If not, change peq to whatever your database is called on the mysql command line.