Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #16  
Old 05-21-2011, 11:09 PM
Umlaut
Fire Beetle
 
Join Date: Jan 2011
Posts: 10
Question

Quote:
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!
Reply With Quote
  #17  
Old 05-22-2011, 12:01 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

I consolidated the build locations together a while ago for common sense so you don't have to look all over for your builds.
Reply With Quote
  #18  
Old 05-22-2011, 09:43 PM
Umlaut
Fire Beetle
 
Join Date: Jan 2011
Posts: 10
Question

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!
Reply With Quote
  #19  
Old 05-23-2011, 09:19 PM
Umlaut
Fire Beetle
 
Join Date: Jan 2011
Posts: 10
Exclamation

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!
Reply With Quote
  #20  
Old 09-28-2011, 09:20 PM
eviakhan
Fire Beetle
 
Join Date: Sep 2009
Posts: 9
Smile Thanks for guide Huppy

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 =)
Reply With Quote
  #21  
Old 09-28-2011, 09:29 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

FYI, there was a new database update a few hours ago with the former naming convention.
Reply With Quote
  #22  
Old 09-28-2011, 10:16 PM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,743
Default

Quote:
Originally Posted by joligario View Post
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.
Reply With Quote
  #23  
Old 09-29-2011, 10:12 AM
sorvani
Dragon
 
Join Date: May 2010
Posts: 966
Default

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!
Reply With Quote
  #24  
Old 10-09-2011, 06:14 PM
Lazzeraith
Sarnak
 
Join Date: May 2011
Location: MS
Posts: 32
Default

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.
Reply With Quote
  #25  
Old 10-10-2011, 01:13 AM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,743
Default

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.
Reply With Quote
  #26  
Old 10-10-2011, 12:18 PM
Lazzeraith
Sarnak
 
Join Date: May 2011
Location: MS
Posts: 32
Default

Quote:
Originally Posted by lerxst2112 View Post
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.
Reply With Quote
  #27  
Old 10-11-2011, 02:52 PM
Lazzeraith
Sarnak
 
Join Date: May 2011
Location: MS
Posts: 32
Default

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 ?????
Reply With Quote
  #28  
Old 10-12-2011, 03:00 PM
Lazzeraith
Sarnak
 
Join Date: May 2011
Location: MS
Posts: 32
Default

Can anyone helpout with this?
Reply With Quote
  #29  
Old 10-13-2011, 04:42 AM
Lazzeraith
Sarnak
 
Join Date: May 2011
Location: MS
Posts: 32
Default

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.
Reply With Quote
  #30  
Old 10-13-2011, 03:01 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

You need to paste the command into a MySQL command prompt:
Code:
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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:42 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3