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.

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...

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:

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!

There was absolutely no need to start over. I linked you the guide so you could follow the few simple steps to letting you use eqemuloginserver on your own machine. Nothing else needed to change from Huppy's guide at all, and since it is more recent it was probably a bit easier to follow.

You are fighting too many differnt things at one time.

I would personally go back to huppy's guide.

Skip the step about downloading zlib, it is in the SVN now.

When you set up your include directories, obviously set the zlib includes to the SVN copy since you no longer need to download it independently.

Change the 2 Perl510 references to Per512 as you have obviously been doing.

Do not uncheck QueryServ it builds just fine now, and is actually used for the Looking for Guild tool recently implemented.

Build your start.bat file and edit your eqemu_config.xml to point to the public login server.

Port forward your router, or temporarily put your PC in your router's DMZ.

Launch your server, make sure it shows up in the list, and that you can log in to it.

At this point you have a public working server. Now go follow the link lerxst2112 referenced to you and set up your own eqemuloginserver.

Real quick..the file that you renamed is the problem with the startup. Executable files (*.exe, *.com, etc...) are files that have been compiled from source code (text files) into a binary executable. The file that you renamed is actually a *.manifest file created by VC and not a compiled binary nor a source code file. Delete the file that you renamed from the source file directory and then come back to the parent source file directory and right-click it, then select SVN Update to ensure that no needed files were deleted.

If you had 5 successfully build, you should have 5 files to copy in your /build/ directory..At least all of mine are there in the Win32 build. Each file will be named based on the name of each project in the Server.sln. I actually have 6 builds using VC9.0 and Win32, but I know there are differences that I haven't played with yet.

Again, you should be using the <eqemu_config.xml> and <login.ini> versions that I post earlier. If you choose to use 192.168.1.50 address for everything, you must use 127.0.0.1 for the database settings in each file or the server programs won't be able to locate it..unless you set up your mysql server to run at 192.168.1.50:3306..but let's not even go there. (Using your network address will work, but adds a tiny bit of not-needed overhead for every packet sent and received, and you could run into the firewall issues Cilraaz alluded to.)

Checklist still inc..

ok thanks a bunch for the help guys. You have all been very helpful and patient with me. I really do appreciate it.

After listening to Uleat, Sorvani, and Lerxst2112, I think I've gotten my files MOSTLY straightened out. I think I'm very close to being up and running.

When I start my batch file, I get three windows up and the 5 zones running with no errors that I can see.

When I log into my Titanium client, I immediately get an "invalid username/password" message. So I obviously have something wrong.

Uleat, I believe I have my files set the way you described in your other post. But to be sure, I'll post them here. If anyone can take a look and possibly tell me why I'm getting the invalid username/password message when logging in, that would be great. I have a feeling my error is being narrowed down to something in one of these files. if not, maybe you guys can point me to where it will be:

EQEmu_Config.xml


login.ini

eqhost.txt
[LoginServer]
Host=127.0.0.1:5998

Did you create a 'tblLoginServerAccounts' entry? This is the actual eq client account user/password that you will use to log into the game with. The password needs to be security hashed as well and can't (to my knowledge) be hashed by simply changing it in Navicat. You can check to see if it is hashed in Navicat by looking at the data field. If you can see the actual password, or don't have an entry in this table at all, you will need to use one of the following:

--If you have already created a login account, but need to hash the password--

UPDATE tblLoginServerAccounts SET tblLoginServerAccounts.AccountPassword = sha('password') WHERE tblLoginServerAccounts.AccountName = 'yourloginname'

password = your password, yourloginname = your login name =)

These must be enclosed by the single quotes ' '

--If you need to add a new user account to the login table--

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES ('yourloginname', sha('password'), 'fakeemailaddress', now(), '127.0.0.1')

Everything in the VALUES section is enclosed in ' ' because it is an actual value with the exception of now(). That is because it is a mysql command that inserts a current timestamp into its place. You could manually put a date/time in single quotes if you know the format it uses.

(You can 'Run' these as a 'Query' in Navicat/HeidiSQL or use it from the MySQL command line tool. Just make sure to add a semi-colon ( ; ) to the end of the line if you use the MySQL command line. If you forget and you wind up with a new line (->), just type a semi-colon on this line and hit enter again. And again, don't forget to 'Use peq' first.)

Under eqemu_config, you might change the tcpip = "localhost" to "127.0.0.1" as well. Not sure if that would keep you from logging in, but it keeps everything "neat."

What revision of EQEmuLoginServer did you finally end up using? Now that you have a "configured" |login.ini| file, if you change the revision that you use, you will just need to make sure that instead of those 5 files, you copy over the 4 remaining files. If you copy |login.ini| again, it will overwrite your configured version with a non-configured version.

Also, I'm not sure if the database name is case-sensitive, but you could verify what Navicat indicates it to be and then ensure both files use the same.

Everything else in your configs looks right for a local/solo setup.

If this works, let us know..if not, we'll see what we need to do next.

Checklist on hold..back to working on something better!

you tell me what you would like to use jshows1:
minilogin.exe & eq_crypto.dll for personal use or private
eqemulogin.exe for personal use or private so you and your friends can login to your server
eqemulogin.exe for public so any one from eqemulator.org an or your friends can login to your server

5.10 perl use with vs2008 only
5.12 perl use with vs2010 only

follow:

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

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

you'll have to excuse Akkadius he just recalled the name of the program he used or is using in school HookedOnPhonics
you'll have to excuse chrsschb who just learned something new about eqemulogin and fliped his desk when he found out we wasn't using eqemulator.net server.

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

Ok I'm VERY CLOSE! At least I can login now. But when I do, there are no servers listed! lol

I know this is not a unique problem. I remember response about this same issue here:
http://www.eqemulator.org/forums/showthread.php?t=35222

So I followed his steps:

eqemu_config.xml
login.ini
eqhost.txt
[LoginServer]
Host=127.0.0.1:5998

I also noticed that I had to configure a couple of other things, so here are the database commands I used(yes I did use Admin/Password just for ease):

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

tblworldserverregistration
INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'World of Jermanfu', 'Ding!', 'Jermanfu', '2', NULL, NULL, '1', NULL);


So, looking at this information, is there anything I missed or typed wrong? Also, is there another file I'm forgetting to adjust? Again, everything seems to work fine except there is no server listed on the server screen.
EDIT: Uleat, to answer your question, I ended up using the eqemuloginserver.exe rev1765. I also made sure to copy all of the required files from that particular download so I wouldn't be mixing files.

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.

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! :)

Oh great..another evercrack addict...

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

Congrats man!

Where can i fetch EQEmuAuthCrypto.dll ?

anyone can post one? millions of thanks

my email address is samlin010@163.com