Nibor the guides are just that guides they are not perfect. The step you are stuck at probably needs to be cleaned up a bit. Try this, create a folder called peqdatabase on your C: drive. Then repeat this part:
When you do that it should download the entire database. After that completes navigate to the C:\peqdatabase\ directory and unzip the file called peqdb_rev1589.sql to your C: drive.

Open up the mysql command line utility and login then type the following lines pressing enter after each one.

CREATE DATABASE peq;
use peq
source C:/peqdb_rev1589.sql

If you did everything correctly you will see a whole bunch of text scrolling down the mysql window. After that finishes navigate to the C:\peqdatabase directory and locate the files named load_player.sql and bots.sql

You will need to open both files with notepad and complete the file paths contained within. By default load_player.sql will look something like this.

source player_tables/aa_timers.sql;
source player_tables/account.sql;
source player_tables/account_ip.sql;

You will need to modify it to look something like this

source C:/peqdatabase/player_tables/aa_timers.sql;
source C:/peqdatabase/player_tables/account.sql;
source C:/peqdatabase/player_tables/account_ip.sql;

Then do the same thing with the bots.sql file.

Afterwards you need to source both files into mysql. Login to mysql and type

source C:/peqdatabase/load_player.sql

then press enter...after that finishes repeat the process for load_bots.sql

Now after that your database should be loaded.

thanks
 

I figured it out and get up to step 7 with no problems at all but then it gets a bit sketchy since I couldn't find the file eqemulogin.ini anywhere but did find a file login.ini .. used that and edited it when i got to step 13..

[database]
host = localhost
port = 3306
db = peq
user = root
password = square
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = true
dump_packets_in = True
dump_packets_out = True
listen_port = 5998
local_network = 192.168.2.4

anyway I went on and followed the rest of the guide to step 12 with no problems where i get lost again because I have no idea what my dyndns address is , where or how that info, any suggestions?

anyway I went ahead and finished the guide without that info and in the end when i run my startup.bat i get connecting to the server failed error 10061
launcher error world server connect Failed

When the guide refers to server.dyndns.org it is a website or service people use to simplify configuring ip addresses. If you know the ip address of your modem then use it as it will accomplish the same thing.

Ok, I feel a little dumb for even asking this, but I have set up my server with no problems at all. Everything works as it should, except I don't have GM privileges in the game. I have tried changing the ServerAdminID variable from 1 to match my loginid, but it doesn't work. Any help would be appreciated.

Assuming your account is the first one, you can do this from a mysql prompt:
UPDATE account SET status = 250 WHERE id = 1;

Thank you, that worked a treat.

Ok, so I have everything working perfectly on my local lan, but I told my brother about eqemu who lives across the country from me and now he wants to play with me on my server. I looked up a bunch of stuff on this site, but am still having problems. Here are the steps I took:

-I went to dyndns.org and made a free dyndns server pointing to my ip.

-I went to my router and used its dyndns settings to connect it to the dyndns server. (It told me Update OK when I checked the status)

-I went into the equemuconfig.xml and changed address and loginserver.host to the new dyndns server.

-I went into eqhost file and changed it to point to dyndns server.

I ran my server and everything seems to run normally, except the login server. I could not log in from my client. I do not know if this is significant, but when I changed my eqhost back to my local ip I could login, but could not see the server. Any help or ideas would be appreciated.

EDIT: Found an error message in my world.exe window saying could not connect to login server: censored.dydns.org:5998

Did you change your windows host file to point your dyndns to your computer holding your server?

how do I go about doing that? I found the windows host file, but I'm not sure what to put... do I put my local ip 192.168.1.1 then censored.dyndns.org? Sorry for all the questions, I haven't worked with servers at all before this.

Ok, I found a post on how to do that, but it still doesn't work. My world.exe window still says it cannot connect to my login server at censored.dyndns.org any other ideas?

I finally gave in and hosted it on eqemu, it seems to work fine now. No clue what the issue was. Thank you for all the help :)

I am getting stuck on the following, highlighted in bold. What file is this and where is it found? I admit my naivete but I appear to be so close :D

11.) Setting up the world server. Here's the sql file to make the world server entry.

Again, the red text is what you want to modify with your server name.
NameOfServer is the actual name of the server.
ShortNameOfServer is the shortname for client files in your game directory (i.e. UI_Soandso_ShortNameOfServer.ini).
ServerTagDescription is what you will see in parenthesis after the server's name - i.e. NameOfServer(Come and have fun!)
The green number 2 signifies what kind of server it is. 1 = Legends, 2 = Preferred, 3 = Standard.

The .ini files that show up in your EQ directory won't show up until you have logged in with a character. If you know what name you are going to use, you can copy/rename a different .ini file to keep the same UI and settings. There are two files.

Capheus_PEQTGC.ini
UI_Capheus_PEQTGC.ini

The PEQTGC represents the short name of the server. So if my short name was Myworld, I would copy/rename the files as:

Capheus_Myworld.ini
UI_Capheus_Myworld.ini

When I looged into my new server, or any server depending on how you/they named it, I would have the same setup as I did for the PEQ server.

I am guessing you setup your database to use PEQLoginDB for your database name. If you want to easily see the contents, I would suggest getting Navicat lite or HeidiSQL to see the contents.

Thanks Capheus!

Now, unfortunately, I am being plagued with a perl510.dll error :rolleyes:

One day I'll figure all of this out :D

You are gonna want to get ActivePerl 5.10.0.1007.

I know this was posted a year ago, but what was your solution to number 2? Or anyone else know how to solve it? I am having the same problem with error 1017.

Timp - for part #2 - how are you trying to host the server to be seen on the internet?

Im going to assume a router is in the whole setup, what kind of router do you have?

Sometimes routers have a NAT filter setup (Network allocation table) - so it makes all computers on that routers LAN pretty much invisible for a lot of applications. Essentially. I dont know if you have solved this yet, but whats an update?

Anyhow, my problem im having is.. is getting microsoft visual C++ 2008 AND 2010 (Express) to actually work with compiling the source code. So many errors, ahhg. I have spent countless hours tracking down the error, fixing it,and another one pops up. Rinse and repeat. Does anybody have any other programs they can recommend?

First, stick with 2008. It works, and 2010 may not.

Second, follow all of the steps carefully for setting up the include and library directories, and make sure you use the proper versions of Perl and MySQL, and you shouldn't have to fix any errors, it just works.

Without you telling us what errors you're seeing we'd be guessing at any problems you might have. My advice is go back and double check all of the settings first, try and compile, and if you still have trouble post the actual errors you are getting.

Ok, this was just for EMuShareMem, the others had many fun returns as well.
--- Edit - Perhaps its because I am using DEV-CPP version of unistd.h? It aparently doesnt come stock with any of the referenced files from the guide. Its acting as if its not native to my system with the files needed that I downloaded from the guide too :( ---

1>------ Build started: Project: EMuShareMem, Configuration: Release Win32 ------
1>Embedding manifest...
1>Project : error PRJ0003 : Error spawning 'mt.exe'.
1>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\EMu ShareMem\Release\BuildLog.htm"
1>EMuShareMem - 1 error(s), 0 warning(s)
2>------ Build started: Project: World, Configuration: Release Win32 ------
2>Compiling...
2>packet_functions.cpp
2>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
2>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
2>misc.cpp
2>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
2>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
2>client.cpp
2>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
2>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
2>Generating Code...
2>Creating browse information file...
2>Microsoft Browse Information Maintenance Utility Version 9.00.30729
2>Copyright (C) Microsoft Corporation. All rights reserved.
2>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\Wor ld\Release\BuildLog.htm"
2>World - 6 error(s), 0 warning(s)
3>------ Build started: Project: Zone, Configuration: Release Win32 ------
3>Compiling...
3>packet_functions.cpp
3>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
3>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
3>misc.cpp
3>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
3>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
3>client_process.cpp
3>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
3>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
3>client_packet.cpp
3>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
3>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
3>Generating Code...
3>Creating browse information file...
3>Microsoft Browse Information Maintenance Utility Version 9.00.30729
3>Copyright (C) Microsoft Corporation. All rights reserved.
3>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\Zon e\Release\BuildLog.htm"
3>Zone - 8 error(s), 0 warning(s)
4>------ Build started: Project: eqlaunch, Configuration: Release Win32 ------
4>Compiling...
4>packet_functions.cpp
4>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
4>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
4>misc.cpp
4>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
4>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
4>Generating Code...
4>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\eql aunch\Release\BuildLog.htm"
4>eqlaunch - 4 error(s), 0 warning(s)
5>------ Build started: Project: ucs, Configuration: Release Win32 ------
5>Compiling...
5>packet_functions.cpp
5>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
5>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
5>misc.cpp
5>C:\Dev-Cpp\include\unistd.h(24) : error C2144: syntax error : 'int' should be preceded by ';'
5>C:\Dev-Cpp\include\unistd.h(24) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
5>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\ucs \Release\BuildLog.htm"
5>ucs - 4 error(s), 0 warning(s)
========== Build: 0 succeeded, 5 failed, 0 up-to-date, 0 skipped ==========

ok,i edited unistd.h. it DID show this:
int ftruncate(int, off_t);
__CRT_INLINE int ftruncate(int __fd, off_t __length)

So i took out the space to...:
(int__fd,...)

and that error didnt come up, but i got:

1>------ Rebuild All started: Project: EMuShareMem, Configuration: Release Win32 ------
1>Deleting intermediate and output files for project 'EMuShareMem', configuration 'Release|Win32'
1>Compiling...
1>timer.cpp
1>SharedLibrary.cpp
1>Mutex.cpp
1>debug.cpp
1>Spells.cpp
1>SkillCaps.cpp
1>Opcodes.cpp
1>NPCTypes.cpp
1>NPCFactionLists.cpp
1>MMF.cpp
1>.\MMF.cpp(325) : warning C4532: 'return' : jump out of __finally block has undefined behavior during termination handling
1>Loot.cpp
1>Items.cpp
1>Doors.cpp
1>DLLMain.cpp
1>Generating Code...
1>Linking...
1> Creating library .\../Build/EMuShareMem/EMuShareMem.lib and object .\../Build/EMuShareMem/EMuShareMem.exp
1>Embedding manifest...
1>Project : error PRJ0003 : Error spawning 'mt.exe'.
1>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\EMu ShareMem\Release\BuildLog.htm"
1>EMuShareMem - 1 error(s), 1 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========

--- Yet, another EDIT - OK! I found mt.exe in the microsoft SDK Files, which was NOT referenced in the Executable Files section in my config. Behold:
1>------ Rebuild All started: Project: EMuShareMem, Configuration: Release Win32 ------
1>Deleting intermediate and output files for project 'EMuShareMem', configuration 'Release|Win32'
1>Compiling...
1>timer.cpp
1>SharedLibrary.cpp
1>Mutex.cpp
1>debug.cpp
1>Spells.cpp
1>SkillCaps.cpp
1>Opcodes.cpp
1>NPCTypes.cpp
1>NPCFactionLists.cpp
1>MMF.cpp
1>.\MMF.cpp(325) : warning C4532: 'return' : jump out of __finally block has undefined behavior during termination handling
1>Loot.cpp
1>Items.cpp
1>Doors.cpp
1>DLLMain.cpp
1>Generating Code...
1>Linking...
1> Creating library .\../Build/EMuShareMem/EMuShareMem.lib and object .\../Build/EMuShareMem/EMuShareMem.exp
1>Embedding manifest...
1>Build log was saved at "file://c:\EQEMUSVNFILES\EQemu\trunk\EQEmuServer\Build\EMu ShareMem\Release\BuildLog.htm"
1>EMuShareMem - 0 error(s), 1 warning(s)
========== Rebuild All: 1 succeeded, 0 failed, 0 skipped ==========

Lets hope I can get this ball rolling. Hopefully this process gives others insight if they have similar problems!

Why would you be using any files from dev-cpp? It will compile with a completely standard Visual C++ installation as long as you set the include paths for Perl and MySQL properly.

Ahh yeah, I guess it was a little off thinking to try using that one when it was with dev-cpp. Anyhow, well, I can honestly say I was a stickler for following the guide - so just for kicks, where SHOULD I be able to locate unistd.h?

I'm really not sure why you think you need that file. It isn't necessary to compile on Windows, only Linux.

If you use Visual Studio 2008 (or possibly 2010), open the solution, and hit compile it should just work as long as you have set up the additional include/library directories for MySQL and Perl.

Aggh
 

So, I put together one of my old XP machines, downloaded everything, and its all going smoothly. Im going to poke at my Vista machine, maybe even just finally upgrade to 7 on it. Lots of junk in there anyhow. Ill turn this XP machine into a dedicated server too, i think it will work better that way :) Ty for your help!


========== Rebuild All: 5 succeeded, 0 failed, 0 skipped ==========

Stuck Newb.
 

Ok, another total Emu newb here.
Trying to follow the guide on the wiki, but it seems to be a little outdated.
This is going to sound completely nitpicky, but when I am trying to follow a guide to do something I know nothing about, I need total Captain Dummy instructions.
You know, type this, change to this directory, type this, move this file to this directory, etc, etc...
That said, I thank you for all the time and trouble you have gone through to write this guide up for everyone.


The first thing I noticed different is when I download the latest rev, EQEmu-Rev1874-Bots.zip, it didn't have a Build folder in it, just files, and a sql_updates folder.
Not a problem, I unpacked it into a seperate folder.
Next, got tortoise svn installed.
Rightclicked on the c:\mysql\bin folder and did the svn checkout step.
Put the correct url in the top line for the repository.
Then the next line was a little unclear: "The line under that where it says Checkout directory: is the location of the folder you are downloading it to - keep an eye on that to make sure it's the correct folder."
I was unsure what this meant, and how was I supposed to know if it was the correct folder or not?
Was it supposed to checkout to \mysql\bin, or was I supposed to leave the default folder in the line: C:\MySQL\bin\projecteqdb ?
I tried leaving it the default, and also tried changing it to download to just: C:\MySQL\bin.
Ok, the next step is where I am stopped.
I started mysql command line.
Created the database.
Use peq.
Then when I tried to enter the next command, source peqdb_rev1751.sql , I get:
ERROR:
Failed to open file 'peqdb_rev1751.sql', error: 2

I noticed that if I moved to .sql files to the bin folder, the command worked, but is that what I am supposed to do?

Thanks!

Ok, had the time to read back through the other 10 pages, and found the answer on page 8 on how to use the source command and use the path to the file.
Sorry, had no idea.
I will continue on again.
Thanks!

Yeah i find that "build" folder worrying as i am supposed to "Copy the EQEMuLoginServer.exe to your server folder. " and i'm thinking, well, without a "build" folder, will the folder created by extraction (C:\eq\EQEmu-Rev1874-Bots(1)) do?

You should be able to run it right out of the extraction folder. You'll of course need things like the map files, quest files, etc, but everything you need to run the server should be included in the zip files, including sql updates. I'll take a look at the guide and reconcile that with the windows builds from the downloads directory. I create them so I guess I should at least make the guide correct.

No peqdb_Rev781.sql.gz
 

I have done all and did the DLs and i yet to see peqdb_Rev781.sql.gz at all the only thing i got is db_dump to use with winrar and help to getting this would be great thx

I had the same issue. I was told to make sure the file extensions are shown. While in that folder, go into your Tools, Folder Options, View and make sure Hide File extensions is unchecked.

You can check it again later.

This will show your .sql file (db_dump.sql) and that is what you use.

Login Server errors
 

Upon launching the login server, at the end, i get:

[Database] [1.11.12 - 00:31:38] Mysql query failed: SELECT max(ServerID) FROM tblworldserverregisteration
[Database] [1.11.12 - 00:31:38] Mysql query failed: UPDATE tblworldserverregisteration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where ServerID = 0

Where would be a good place to start looking? I checked out login.ini and eqemulogin.ini so far both look perfect...

**UPDATE** Fixed it myself =)

Step 10.) I'm very frustrated because now I have a .SQL file sitting on my desktop and still no way to either log in or create an account. Some instruction on how you can possibly use a rogue .SQL or what the heck it's for would be excellent.

I've been gone for about 2/3 years and so much has changed, this used to be incredibly easy.

Assuming you're using HeidiSQL as instructed in the guide it is the same as the part of step 9 concerning importing a sql file.

Make sure the peqlogindb is the active database and import the file. You'll probably want to edit the username/password/e-mail from the default before you do so. Step 11 is the same, you want to save that to a file with your information in it and then import it.

There's probably a way to just paste it into a query window in HeidiSQL and execute it, but as I don't use that program I'm not sure what the exact steps would be.

Edi: Attempting

If you don't have a Ls account please get one or more if needed! Goto http://www.eqemulator.org/forums/pro...do=loginserver Note: you should see a numbers all numbers xxxxxx wright it down so you can remember them. Goto peq database account under the users name you'll see Isaccount_Id put in the xxxxxxx numbers from eqemulogin server Change veriables in database to Public Must use EQEmuLoginServer.exe for this to work online. Look for your Server to be listed at http://www.eqemulator.org/index.php?pageid=serverlist Login using your client change your eqhost.txt eqemulator.net:5998 put in your lsaccount you just created username and password into client and login so you can see all the other servers on the list and you should see your server online. Download Navicat 8.xx http://www.navicat.com/download/navicat8_mysql_en.exe Navicat is used for editing your peq database the softwear your talking about is old out dated use Navicat 80)

The Wright brothers used softwear on the wings of their plane.

Let me send my Me109 over

I want to make a lan server for only the first 10 expansions (titanium edition) will this guide work for that? i noticed it was talking about keeping quests and such updated with tortoisesvn. i just like the old school expansions =) thanks in advance

If other people outside of your LAN are trying to connect, their eqhost.txt file should read:
Quote:
[LoginServer]
Host=server.dyndns.org:5998
server.dyndns.org should be the name of your dyndns service.

ive been trying to get my friends to connect to my server.

they can connect when they are in my house. they cannot when they are their houses

they get disconnected back to the log in screen when they are trying to connect.

here are my IPs
INTERNAL IP address: 192.168.x.x
INTERNAL IP address: 25.46.53.1xx
ROUTERS IP Address: 192.168.x.x
EXTERNAL IP address: 75.114.228.xx

do i have them type in one of my IPs like you said here?

If other people outside of your LAN are trying to connect, their eqhost.txt file should read:
Quote:
[LoginServer]
Host=server.dyndns.org:5998
server.dyndns.org should be the name of your dyndns service.

so should their thing say

Host=25.46.53.1xx ?

This thread is over 2 years old... MANY things have changed since this was active.

The 'Host=server.dyndns.org:5998' reference is set to indicate that you are running a private login server AND are using a url translation service to
provide a stable address for your dynamic isp address.


The only way an external computer will be able to communicate with your internal one is if THEY use the EXTERNAL IP address: 75.114.228.xx. Just
make sure that your full address is filled in for the clients.

You will need to use the LAN address for the computer that is running the server. 192.168.xx.xx is the appropriate ip..not the router's, but the computer's.

You will also need to ensure that port-forwarding is enabled on the router so that packets received at 75.114.228.xx will be 'forwarded' through the NAT
and received at 192.168.xx.xx.

The proper addressing and port-forwarding is necessary regardless of whether running a private login server or not.


IF you are not running a private server, then the clients need to point their logins to the EQEmu login server..but, your server still needs to be setup to
receive packets from the outside..from both the eqemu login server and the clients. Port-forwarding and configuration are the keys here.