EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   COMPLETE PUBLIC SERVER SETUP - Jan-2011 (https://www.eqemulator.org/forums/showthread.php?t=32980)

lerxst2112 09-02-2011 11:40 AM

Make sure you're installing the 32 or 64 bit version to match your OS. You should see the Tortoise SVN Menu on any folder you right-click on. If not it's either installed incorrectly or there's something else wrong with your computer.

keglo 09-02-2011 01:17 PM

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

werebat 09-02-2011 01:40 PM

Quote:

Originally Posted by keglo (Post 202729)
Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

keglo 09-02-2011 03:50 PM

Quote:

Originally Posted by werebat (Post 202730)
Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

Yes. Installing 64 bit did work for me. Thanks for the help. Now I'm having anew problem at step 9 when I do the "Build">"Build Solution" I get the following:

Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped

I have tried it twice with the same results. Any ideas?

lerxst2112 09-02-2011 04:11 PM

You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.

keglo 09-02-2011 05:18 PM

Never mind this post

keglo 09-02-2011 06:09 PM

Quote:

Originally Posted by lerxst2112 (Post 202735)
You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.

How do I post the errors without posting the whole huge log file? Id id double check my include/library directories and they where correct. I re-installed Mysql to make sure I followed all the steps. I still get the 3 succeed 2 fail.

lerxst2112 09-02-2011 08:14 PM

How many errors are there? The only way you will get help is to post them, otherwise we have no idea what they are. I would make a new thread for it.

keglo 09-02-2011 08:40 PM

Quote:

Originally Posted by lerxst2112 (Post 202740)
How many errors are there? The only way you will get help is to post them, otherwise we have no idea what they are. I would make a new thread for it.

Well the log file says I didn't have "errors"

0 error(s), 324 warning(s)

but I keep getting the following

3 succeeded, 2 failed, 0 skipped

I do not know how to post them or I already would have. I'm not sure what you want me to post. I tried pasting my entire log file in a new thread but it wouldn't let me. Sorry for being such a newb, but......

keglo 09-02-2011 09:46 PM

Ok lerxst2112. I found a post from you a couple of pages back.

Quote:

Originally Posted by lerxst2112 (Post 202392)
Find the two lines in the source code that look like this:

Code:

#pragma comment(lib, "perl510.lib")
Change the 510 to whatever version of perl you are using, like 512.

What are the errors you get with Strawberry perl? What version were you trying to use?

I tried that solution for myself and it worked like a charm! Thank you!!

keglo 09-02-2011 10:30 PM

Now I have a new problem. I am on step 11 where I need to download the maps and quest. The problem is that all the folders already have a green check on them, therefore I can't choose "SVN Checkout". I seen this same problem asked about a few pages back, but didn't really see a clear answer to the problem. Someone mentioned downloading the .rar map files and extracting to the map folder, but that doesn't explain what to do about the quest folder.

lerxst2112 09-02-2011 11:38 PM

If you're following the guide properly, the server folder should be separate from the source and database folders that are under SVN control.

Check again that you followed step 7 properly.

keglo 09-03-2011 09:08 AM

Quote:

Originally Posted by lerxst2112 (Post 202744)
If you're following the guide properly, the server folder should be separate from the source and database folders that are under SVN control.

Check again that you followed step 7 properly.

Yes I checked and followed the steps properly. The problem is that when I did step 8 and downloaded all the source files, it put a green check on nearly everything inside. Including the maps and quest folder in /source/trunk/EQEmuServer/utils/defaults. So when I do the following part in step 10

"Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn"


it carried over the green checks from the source folder into the server folder. So with the green checks already there it will not let me SVN Checkout.

sorvani 09-03-2011 12:49 PM

You failed to NOT copy the .svn folders from your source to server folders when you copied your stuff over.
If you don't see them, change your folder setting to show hidden files and folders etc.

keglo 09-03-2011 01:44 PM

Quote:

Originally Posted by sorvani (Post 202746)
You failed to NOT copy the .svn folders from your source to server folders when you copied your stuff over.
If you don't see them, change your folder setting to show hidden files and folders etc.

Ok the instructions are

Next, In /source/trunk/EQEmuServer/utils/defaults folder -

Copy ALL the folders and files inside this folder. EVERYTHING !!!! and put them in your
server folder also.YOU DON'T need the folder called .svn


It says "YOU DON"T need the folder (singular) called .svn." There is a .svn folder in /source/trunk/EQEmuServer/utils/defaults. I did not copy that file over. I assumed by the way the instructions are worded that it was that singular file that it was refering to. There are other .svn folders within each of the other files located in the /default folder. Are you telling me that I need to go through all of these folders and delete the .svn folder from each one before I copy the folders over?

UPDATE:
I tried doing just that, deleting all the .svn files from each folder before copying them over and it seems to be working. I am updating the quest folder per the instructions as I type this. Thanks for the help!

keglo 09-03-2011 06:17 PM

Now at step 13

So NOW, you can download and source in the database (and updates needed)

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

I'm lost here. Where does this file, peqdb_rev175.sql.gz, come from? I haven't seen it mentioned elsewhere in the instructions so I assumed that it would be downloaded into the peqdb folder in step 13, but it isn't there. Where do I find it please?

blackdragonsdg 09-03-2011 07:37 PM

The database revision has changed since any of the guides were written. Look for database_incremental.zip instead of peqdb_rev1751.sql.gz.

keglo 09-03-2011 09:23 PM

Quote:

Originally Posted by blackdragonsdg (Post 202767)
The database revision has changed since any of the guides were written. Look for database_incremental.zip instead of peqdb_rev1751.sql.gz.

Thank you!! That worked. Now...

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.


I tried removing the first line but I still get a failure with 1711_account_restricted_aa.sql.

Any ideas?

blackdragonsdg 09-03-2011 10:01 PM

That update should already be in your database. Just skip that part and keep going.

keglo 09-04-2011 09:33 AM

[Debug] Starting Log: logs/eqemu_debug_4000.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server localhost:9000 failed: TCPConnection::Connect<>: connect<> failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect<> FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...


This is all I get after using my start.bat to begin my server

Apoc.Index 09-04-2011 12:35 PM

Double check your eqemu_config.XML file in your eqemu folder. It looks as if its not connecting properly. You can follow this post if you dont know what parts to check/edit.


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

If that is in order, double check any port fowarding on your router (if you have one). The same post on the bottom will teach you about port forwarding.

Rhodan 09-18-2011 10:48 AM

installing Mysql just about drove me up the wall. I made a mistake and uninstalled/reinstalled but it kept acting like there was already a password after a reinstall.

Well it took a while to find it but mysql (at least the 5.1 version) does not delete its databases when it uninstalls. On windows 7 the database is in a hidden directory called AppData and the Mysql dir in AppData has to be erased to remove the "old" password. Of course, if someone wants to keep a database and wants to only reset the password they'll have to hit google.

Baruuk 09-19-2011 10:12 PM

Login account question
 
Hi fellas - been away from the EMU for about a year and thought I'd give it another whirl. Thanks for this great guide. Overall it was pretty easy to follow and helped a bunch. One question however... Everything compiled and is configured fine it seems - i get no errors when launching WORLD.EXE, etc - it looks happy. I even see my new server listed in the public login server list. However, when I go to click on it (my client is an SoD build and eqhost.txt configured with port 5999), it never displays a character select screen. It simply hangs. Below is the error I'm getting in my world window. It looks like my login server account simply doesnt exist on the world server and it chokes - and since I'm not running a private login server, it dies. However, I'm not sure. How do accounts get created on the server? (BTW - IP and login account have been replaced below) Thanks in advance.

[Debug] [WORLD__CLIENT] New connection from x.x.x.x:57859
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2792
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2ec9
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x4dd0
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_world, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x7213
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_zone, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x6c3c
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x737e
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode matched 0xff4 and
length matched 464
[Debug] [NET__IDENTIFY] Identified stream x.x.x.x:57859 with signature So
D_world
[Debug] [WORLD__CLIENT] Checking inbound connection x.x.x.x against Banne
dIPs table
[Debug] [WORLD__CLIENT] Connection x.x.x.x PASSED banned IPs check. Processing connection.
Account Attempting to be created:myaccount 0
Error in CreateAccount query 'INSERT INTO account SET name='myaccount', status=0,
lsaccount_id=175494, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'myaccount', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '175494'

sorvani 09-19-2011 11:16 PM

drop and resource your DB with the latest db_incremetnal or whatever it is called form the database SVN. Then source in every SQL file in the server SVN SQL sub folder > 1900 that does not have the word optional in it.

Baruuk 09-19-2011 11:17 PM

Quote:

Originally Posted by Baruuk (Post 203299)
Hi fellas - been away from the EMU for about a year and thought I'd give it another whirl. Thanks for this great guide. Overall it was pretty easy to follow and helped a bunch. One question however... Everything compiled and is configured fine it seems - i get no errors when launching WORLD.EXE, etc - it looks happy. I even see my new server listed in the public login server list. However, when I go to click on it (my client is an SoD build and eqhost.txt configured with port 5999), it never displays a character select screen. It simply hangs. Below is the error I'm getting in my world window. It looks like my login server account simply doesnt exist on the world server and it chokes - and since I'm not running a private login server, it dies. However, I'm not sure. How do accounts get created on the server? (BTW - IP and login account have been replaced below) Thanks in advance.

[Debug] [WORLD__CLIENT] New connection from x.x.x.x:57859
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2792
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x2ec9
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch 6.2_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x4dd0
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_world, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x7213
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch Titanium_zone, and
it did not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x6c3c
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_world, and it d
id not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode 0xff4 did not matc
h expected 0x737e
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: Tried patch SoF_zone, and it di
d not match.
[Debug] [NET__IDENT_TRACE] x.x.x.x:57859: First opcode matched 0xff4 and
length matched 464
[Debug] [NET__IDENTIFY] Identified stream x.x.x.x:57859 with signature So
D_world
[Debug] [WORLD__CLIENT] Checking inbound connection x.x.x.x against Banne
dIPs table
[Debug] [WORLD__CLIENT] Connection x.x.x.x PASSED banned IPs check. Processing connection.
Account Attempting to be created:myaccount 0
Error in CreateAccount query 'INSERT INTO account SET name='myaccount', status=0,
lsaccount_id=175494, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'myaccount', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '175494'

EDIT: I figured this out - I needed to add a column to the account table. I was able to get to the Character Select screen and create a toon :) The only hangup I have now is the ability to actually get into a zone. I created a Vah Shir and selected Shar'Vahl - but it disconnected me. My suspicion is it's my client maybe - I'll work on it tomorrow.

Thanks anyways!

Lazzeraith 10-02-2011 03:16 AM

Perl 5.10.0.1007
 
For Perl, go here - (I use 5.1 - 1007 version)
http://www.activestate.com/activeperl/downloads



Where can I get this version, that link is no good for it anymore, just have 5.12 and 5.14. I am trying, without any success, to setup a server. The guides are great but still leave people, in the dark without a clue as to how to do this, short. I tried using strawberry perl 5.10.1.5, but when I issue the ppm install DBI and ppm install IO-stringy commands, I get error installing package 'dbi': could not locate a PPD file for package dbi and same for IO-stringy. Any help would be great, I really miss playing this game.

Lazzeraith 10-02-2011 04:52 AM

V C++
 
I am trying with Perl 5.12. Another problem popped up, when added the settings to Visual C++ 2008....

C:\mysql\include <------- I do not have the include folder
C:\perl\lib\CORE
C:\zlib\include

and

LIBRARY:
C:\mysql\lib\opt <------ I do not have this one either, under the mysql folder
C:\perl\lib\CORE
C:\zlib\lib

lerxst2112 10-02-2011 06:04 AM

If you don't have the correct MySQL directories then you don't have it installed properly or you don't have the proper version of MySQL. I use 5.0, but I've heard 5.1 works fine as well. You want the 32-bit version with the installer.

http://downloads.mysql.com/archives....sql-5.0&o=-win

If you use Perl 5.12 you will need to change these lines to "perl512.lib"

trunk\EQEmuServer\world\EQWParser.cpp(35):#pragma comment(lib, "perl510.lib")
trunk\EQEmuServer\zone\embperl.cpp(26):#pragma comment(lib, "perl510.lib")

Lazzeraith 10-04-2011 02:28 PM

Thanks
 
Thank you, that got that fixed. Now though I am having a problem with this:

In your server folder, right click on the quests folder and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqquests.googlecode.com/svn/trunk/quests (Then click on OK)

When I right click on the folder the SVN Checkout option is not there anymore, it has SVN Update, SVN Commit..., and the TortoiseSVN options. I cannot seem to find a way to paste the addy.

Aeryn 10-04-2011 02:49 PM

You already have a URL associated with that folder

To check or change it
go into the tortoise options and choose "Relocate"
that will show the url currently associated with the folder, change it there if it's wrong

Lazzeraith 10-04-2011 04:15 PM

Svn
 
Did that and got a TortoiseSVN error box.

The repository at 'http://projecteqquests.googlecode.com/svn/trunk/quests' has uuid '858f6fc0-2484-11de-a087-198e6c7179d9', but the WC has 1db01234-8a6e-11dd-8937-b3a0fbe'

Lazzeraith 10-04-2011 04:39 PM

SVN error
 
Also when I opened the relocate option it had this URL http://projecteqemu.googlecode.com/s...efaults/quests, I replaced it with the one from the guide http://projecteqquests.googlecode.com/svn/trunk/quests and got the error from the above post. Is it possible to manually download these files and put them in the folder or is there a needed purpose for using SVN?

Lazzeraith 10-05-2011 03:51 PM

SVN folder stuff.
 
Ok I cheated, made same named folders on different drive pasted links then copied them to server directory.

Lazzeraith 10-05-2011 04:59 PM

Execute SQL
 
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.

Hello,

I am using rev_2022.sql, when I did the above set I get the following error.


[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
[Err] 1060 - Duplicate column name 'time_creation'
[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Msg] Finished - Unsuccessfully
-------------------------------------------------

Also in using rev_2022, this means I will have execute all the files higher than 1711 ?

joligario 10-05-2011 07:26 PM

with 2022 all updates are already applied and current to 2022

Lazzeraith 10-06-2011 03:59 AM

?
 
Quote:

Originally Posted by joligario (Post 203735)
with 2022 all updates are already applied and current to 2022

So you do not have to do this step then?

Sorry kind of confused now, the guide says..

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.
I CAN NOT help you with all the errors from the updates, but just search the forums for
any others.

lerxst2112 10-06-2011 04:53 AM

You should always apply any updates where the code is newer than your installed database version, but since they currently match there is no need to do so.

Lazzeraith 10-06-2011 11:55 AM

Sql files
 
Quote:

Originally Posted by lerxst2112 (Post 203741)
You should always apply any updates where the code is newer than your installed database version, but since they currently match there is no need to do so.

Ok thank you.

Lazzeraith 10-06-2011 12:44 PM

Ok I have these windows now, is this what I was suppose to be getting?

http://s1194.photobucket.com/albums/...t=eqemuser.jpg

Lazzeraith 10-06-2011 12:53 PM

If my server is up and running , how do I connect to it?


All times are GMT -4. The time now is 03:25 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.