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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2012, 05:58 PM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,742
Default

Huppy's guide is designed for you to use the public loginserver so your server appears on the list of all the other servers here.

The guide I posted a link to is designed to allow you to use eqemuloginserver locally.

Minilogin is old, you should use eqemuloginserver is you can. The guide I linked is not difficult to follow, it's only a few steps and you're done.
Reply With Quote
  #2  
Old 04-25-2012, 06:04 PM
jshows1
Sarnak
 
Join Date: Jun 2009
Location: Baton Rouge,LA
Posts: 79
Default

Quote:
Originally Posted by lerxst2112 View Post
Huppy's guide is designed for you to use the public loginserver so your server appears on the list of all the other servers here.

The guide I posted a link to is designed to allow you to use eqemuloginserver locally.

Minilogin is old, you should use eqemuloginserver is you can. The guide I linked is not difficult to follow, it's only a few steps and you're done.
Ok I'll go back and uninstall everything and try again wih Kavren's guide. I was using his, but got stuck on the portion where it tells you to look at the info in tblworldserverregistration and tblLoginServerAccounts. For some reason, they don't show up in the tables of my peq database, so I was stuck at that point.

I'll delete my peq database and all of my Eqemu files (in my root folder) and start over.

I'll post here later if I am still having problems. Hopefully by deleting the peq database and redoing everything, the tbl tables will show up. Thanks, Lerx.
Reply With Quote
  #3  
Old 04-25-2012, 08:48 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

EQEmuLoginServer uses an account/password scheme for logging onto the server, where Minilogin uses IP address verification. I agree with lerxst on this and you should be using the eqemulogin.

If you happen to download the rev2098.rar file, there was a file called ServerStart.bat, which starts all of the required programs.

If not, open Notepad (don't create a new text document and open it or you'll be stuck with a file called ServerStart.bat.txt, which won't work and is a pain to rename in Windows if you don't know how..) and copy this into it:


@echo off
Echo Starting EQEmuLoginServer

cd C:\eqemu
start eqemuloginserver.exe
echo
echo

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit


Now, click save and called it ServerStart.bat and that should work for your server starter.

As far as Navicat (or HeidiSQL), it is not required to make the server run. It's only there to make editing your database easier.

MySQL is your database server and is where your World and Login server's go to set and retrieve information. The name 'PEQ' is the name you gave to the particular database for use with this world server.

In Huppy's instructions where it say to create a new session, you are creating a Navicat-unique identifier called 'PEQLoginDB' which is only a tag that identifies this particular MySQL server.

When you log into Navicat (Navigate Catalogue, I presume) you will actually see four (4) databases: MySQL, PEQ, Test, and something else..I'm not on my server computer and can't get the exact names, but you get the gist.

When you set the database in the config files, that tells the server programs to use a particular database from your MySQL database server..and that happens to be 'PEQ.' All of the tables that you need will be under the PEQ tree.

I'll continue in a little bit, but want to get this post up first...
Reply With Quote
  #4  
Old 04-25-2012, 09:52 PM
jshows1
Sarnak
 
Join Date: Jun 2009
Location: Baton Rouge,LA
Posts: 79
Default

Thanks for the info Uleat.

I seriously can’t figure out what I’m doing wrong. SO, I’ll post my step by step process to see if you guys can pick up on my error(s). You know how it is, after hours of staring at something; it helps to get some different eyes to look at your work.

So to start, I’m using Kavren’s guide found here:
http://www.eqemulator.org/forums/showthread.php?t=31783

Phase 1: Install and Gather Starting Supplies:
I’m using Perl 5.12 (32 bit), MySQL 5.1.54 (32 bit), a demo version of Navicat, TortoiseSVN 1.7.6 (64 bit), Microsoft Visual C++ 2008, Zlib.

I installed all of the above programs first.

Next I created a folder called “EQEmuSVNFiles” in my C:\ drive (all of the file locations I will use going forward in this post will be based on exactly where Kavren says to do it in his guide).

I then created a subfolder in that folder called “EQEmu”.

I then right clicked on EQEmu and went to SVN checkout with http://projecteqemu.googlecode.com/svn/
Next I created a subfolder called DB and did an SVN checkout with
http://projecteqdb.googlecode.com/svn/trunk

Next, Kavren says to install Perl 5.10. I previously installed version 5.12 since I couldn’t seem to find an install version of 5.10 anywhere online. Other posts have mentioned that version 5.12 works with Microsoft Visual C++2008, so I’m going with that.

Next I installed MySQL 5.1.54 (I tried using 5.08 like he mentions in the guide, but I could never get the service to start at the end of the config). When the option came to configure, I chose detailed configuration>>server machine>>multifunctional database>>online transactional processing (OLTP)>>Unchecked Enable Strict Mode but enabled TCP/IP Networking (port 3306)>>best support for multilingualism>>checked both install as windows service and include bin directory windows PATH>> then put in a new password and hit execute.

I then started Microsoft Visual C++ 2008 and made sure I had the appropriate directories included:
Include files: C:\mysql\include
Include files: C:\perl\lib\CORE
Include files: C:\zlib\include
Library files: C:\mysql\lib\opt
Library files: C:\perl\lib\CORE
Library files: C:\zlib\lib
Phase 2: Compile
In Microsoft Visual C++ 2008 I went to file>>open>>project/solution and browsed to C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer and selected server.sln.

I then unloaded the queryserv so that I had only the 5 projects needed.

Next I hit build/clean solution and got 5 succeeded, 0 failed.

Then I went to the configuration manager and selected releasebots.

I then went into eqwparser.cpp as well as embperl.cpp and changed both instances of 510 to 512 (since I’m using version 5.12 of Perl).

Finally I went to build/build solution. After, I got the message of 5 succeeded 0 failed.
I then created a folder in my C:\ drive called EQEmu

I then copied the following files into my EQEmu folder:
Changelog.txt
Chatserver.exe, EMuShareMem.dll, World.exe, Zone.exe from the build directory.
Eqlaunch.exe from the EQlaunch\release directory (Interesting thing here: The file was named eqlaunch.exe.intermediate.manifest so I deleted everything behind the .exe hoping this is right!)
mail_opcodes.conf, opcodes.conf, patch_6.2.conf, patch_Anniversary.conf, patch_SoD.conf, patch_SoF.conf, patch_Titanium.conf from the Utils directory (It also asked to transfer patch_live.conf but there was NO file named this. Also what about patch_HoT.conf, patch_Underfoot.conf, and patch_VoA.conf? I know these expansions are newer than this guide. Will it mess me up if I transfer these over? What if I don’t? I didn’t because I’m going literally step by step on the guide).

I then copied ALL of the files from the default folder into my EQEmu folder.

Phase 3: Setup Databases, Adjust Server Settings and Gather More Files

Now time to source in my database. This is where I’m not sure if I did it exactly right or not. In the guide he talks about rev774. Obviously when I did it we were on rev2133.
I then navigated to C:\EQEmuSVNFiles\DB\peqdatabase and unzipped peqdb_2133.sql into the same folder.

I opened Navicat and made a new connection. I then double clicked on the connection, right clicked on it and made a new database called PEQ.

Next I opened a command prompt and navigated to the above mentioned folder.

I then ran these commands (replacing username/password with my info):
mysql -uUSERNAME -pPASSWORD PEQ < peqdb_Rev2133.sql
mysql -uUSERNAME -pPASSWORD PEQ < load_player.sql

Next Kavren says it’s time to install EQEmuLoginServer:
I extracted and copied EQEmuLoginServer.exe into my C:\EQEmu folder (NOTE: He did NOT say to copy anything else from the zip, so I didn’t).

He then says to navigate to C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer\EQEmuLogi nServer\login_util and copy the eqemulogin.ini and login_opcodes.conf to your server folder (C:\EQEmu). The problem is, there is NO eqemulogin.ini so I copied login.ini. Please let me know if this is wrong. I’m following this guide as literal as I can.

I then navigated to C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer\EQEmuLogi nServer\login_util\ms\debug and copied EQEmuAuthCrypto.dll to my server folder (C:\EQEmu)

Next was time to setup PEQLoginDB and Logins:
He says to right click on my connection in Navicat and create a new database called PEQLoginDB. I did that next.

Next I opened a command prompt, navigated to C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer\EQEmuLogi nServer\login_util and ran the following command:
mysql -uUSERNAME -pPASSWORD PEQLoginDB < EQEmuLoginServerDBInstall.sql (again replacing username/password with the one I had chosen for my database).

I then went into tblLoginServerAccounts and set user/pw to Admin/Password. He says to change 127.0.0.1 to the p address of the client machine I will be playing on. Does this mean the 192.168.1.xx? That’s what I changed it to.

Next I went into tblworldserverregistration and made the changes he suggested to make in there.
The next thing the guide says to do is to edit the eqemu_config.xml. Below is what my file looked like after I made the suggested changes:

Code:
<?xml version="1.0">
<server>
	<world>
		<shortname>Jermanfu</shortname>
		<longname>World of Jermanfu</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<address>192.168.1.50</address>
		<localaddress>192.168.1.50</localaddress>

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

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>some long random string</key>
		
		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>192.168.1.50</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>192.168.1.50</host>
		<port>7779</port>
	</mailserver>

	<zones>
		<defaultstatus>20</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>localhost</host>
		<port>3306</port>
		<username>root</username>
		<password>6harrier8z</password>
		<db>peq</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>
I then opened up eqemulogin.ini ( I assume since there was no file by that name I was to edit login.ini):
This is where things differ, his eqemulogin.ini is a bit different from the login.ini. From what I gathered from other posts, I made mine look like this:
[database]
host = localhost
port = 3306
db = PEQLoginDB
user = root
password = 6harrier8z
subsystem = MySQL

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

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

Next I setup my maps and Quest SVN Folders:
I went to my EQEmu folder and did an SVN checkout on the maps folder using this link:
http://eqemumaps.googlecode.com/svn/trunk/Maps

Next I did the same thing with my quest folder using this link:
http://projecteqquests.googlecode.com/svn/trunk/quests

I then copied the files from the quests\plugins folder to the EQEmu\plugins folder.

I then copied spells_en.txt and spells_us.txt from my Titanium EQ folder to the EQEmu parent folder.

I then made a batch file which says exactly this:

@echo off
Echo Starting EQEmuLoginServer

cd C:\eqemu
start eqemuloginserver.exe
echo
echo

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit


When I run start.bat I get an error that says this: "Unsupported 16 bit application. This program or feature "\??\C:\EQEmu\eqlaunch.exe cannot start or run due to incompatibility with 64-bit versions of Windows."

Well I'm omw to bed. Another LONG day of messing with this lol. But I am a patient man. I guess I have to be with all the mistakes I make. Anyway, Uleat or anyone else, if you guys can find my mistakes....PLEASE let me know what I need to change. Thanks!
Reply With Quote
  #5  
Old 04-26-2012, 09:15 AM
Cilraaz
Sarnak
 
Join Date: Mar 2010
Posts: 77
Default

Quote:
Originally Posted by lerxst2112 View Post
Minilogin is old, you should use eqemuloginserver is you can.
My bad on the old terminology. When I set up my first server years ago, minilogin was the standard. When I came back and set up a new server recently, I used the public login server. Sorry for any confusion that I caused.
Reply With Quote
  #6  
Old 04-26-2012, 10:05 AM
jshows1
Sarnak
 
Join Date: Jun 2009
Location: Baton Rouge,LA
Posts: 79
Default

Quote:
Originally Posted by Cilraaz View Post
My bad on the old terminology. When I set up my first server years ago, minilogin was the standard. When I came back and set up a new server recently, I used the public login server. Sorry for any confusion that I caused.
Hey! Don't worry about it. You were trying to help.

I really appreciate all the help this community has given me so far. Some places people are really rude and not very helpful towards newbies. But everyone here has been warm and welcoming as well as eager to help. I truly appreciate it.
Reply With Quote
  #7  
Old 04-26-2012, 01:19 PM
jshows1
Sarnak
 
Join Date: Jun 2009
Location: Baton Rouge,LA
Posts: 79
Default

Just wanted to update everyone who has been so great in helping me, I finally got my server up and running!!

Thanks to all of the wonderful help from Uleat, lerxst2112, and everyone else here who was so gracious in helping me. It was due to your patience and willingness to help that I was able to get it up and running.

I'll be sure to pass anything along if I see anyone else struggling like I was. Now....time to get lost in EQ....after all....I'm in MY world now!
Reply With Quote
  #8  
Old 04-26-2012, 09:11 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Oh great..another evercrack addict...

If we haven't heard from you in a week, we're doing an intervention!!

Congrats man!
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 07:57 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3