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)

trevius 12-06-2011 08:07 AM

Quote:

Originally Posted by pepsiphreak79 (Post 205127)
This is unclear especially since the rev is now 2027 on the db does this mean i need to install update from the 1667 till 2068 line still or is the 2068 db updated? i am afraid to screw it up again so im just going to ask for clarification first.

Code:


The reason your doing this, is because, even after a new database revision is out, all
the updates developed after that, need to be sourced in. In this case, when the rev1751
was sent out, (after the 1667), not all updates were applied to the release.
I know it leaves more work for us "end users", but what the heck, it's free


That depends on what binaries you are using. It sounds like you are running Rev2068 binaries and Rev2027 of the PEQ DB. If that is true, you just need to source in any updates between 2027 and 2068 seen here:

http://code.google.com/p/projecteqem...ls%2Fsql%2Fsvn

In your case, that should be the following files:

2057_required_discovered_items.sql
2058_optional_rule_discovered_items.sql
2062_required_version_changes.sql

And then your DB and Binaries should be matching and set to go.


Quote:

Originally Posted by pepsiphreak79 (Post 205125)
is it ok to populate my naked login database using the login DB from a repack??

I would not recommend mixing and matching with the Repack and normal install.

You should be able to just follow steps 9, 10, 11, 12, and 13 from the guide here:
http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ

pepsiphreak79 12-06-2011 08:37 AM

ok ty i was just curious cause of how it was worded it was confusing i ziped up my server incase i screw it up again cause as far as i know so far its going ok this time its hard to focus on all the walkthroughs so many diff ones keeping track of it can be difficult..
All this to play a game i loved for years since it came out till pop lol and since im moving out to where theres no real internet i wanted to get a hold of a working recient stable server that supported the latest client i had in my possession lol

pepsiphreak79 12-06-2011 09:40 AM

Wow ok that helped straighten things out now im almost up just some config isses i have to find where i messed up the settings that keep it from connecting
Thank you for pointing me in the right places there is just so much its very hard to track down what you specifically need

pepsiphreak79 12-06-2011 10:52 AM

up and created a drakkin and eq client crashed on login dont know what caused it yet but up to the char creation everything ran like a live server even the descriptions were there.
reinstalling sof fresh i know following some guides it said to alter some of my sof files and somthing tells me i shouldnt have

OK so my tip for server setups do not have your rev*.sql in the same dir as your database when you source them cause it really goes crazy

i only realized that was my issue when it wouldnt let me remove the peq db and recreate

And mmm what else heidi wont always tell you if you have a bug.. :( and i like my heidi so sweet and gentil

trevius 12-06-2011 11:22 AM

If your zone is crashing when you log in, it is normally due to missing a required SQL update. You can normally check your logs and see if they have any useful information. If not, you can run a debug, but that might be a bit too complicated for you as it requires compiling your own source.

pepsiphreak79 12-06-2011 12:34 PM

Server up and working after a bunch of minor config file changes

thank you for helping clarify the information in here to get this up

I would be happy to upload this preconfigured server for dummies as soon as i make sure its fully working it wont have anything custom or altered from the peq 2068
I know things are missing from it and itll never be perfect but the way eqemu is setup i can add content easily when not having internet

as for the booting thing it looked like it is the tutorial b thing but when i come back in i start in tutb anyway so im not gonna disable it

i may instead try and write the story for tutorial a zone 188 as is was on live last i recall and then alter the tutb to tut a starting and see if that resolves the whole char creation into tutorial issue

Tested server on Titanium and SOf both working on port 5999
no changing anything needed
multiple char creations and a little travel tested

pepsiphreak79 12-07-2011 03:41 AM

Its up everything works pretty good Unaltered from what the peq 2068 db and core files
worked on tit and sof ;)

runs right out of an unzip once your maps are placed in


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

Secrets 12-07-2011 04:38 AM

Quote:

Originally Posted by pepsiphreak79 (Post 205149)
Its up everything works pretty good Unaltered from what the peq 2068 db and core files
worked on tit and sof ;)

Code:



If anyone wants it heres the torrent mag link:

magnet:?xt=urn:btih:021F89236BF6412818998701FF93645C02617864&dn=eqemu-rev2068-wbots-wcore-wdb-wquests_unmodified_repack_nomaps.zip&tr=udp%3a//tracker.openbittorrent.com%3a80


Media fire link
http://www.mediafire.com/file/ka04ae5m5yu07av/eqemu-rev2068-wbots-wcore-wdb-wquests_unmodified_repack_nomaps.zip


One post is enough. I advise people to compile from source themselves unless you want a potential trojan. The only official repack is the one on google code.

rullare 12-10-2011 05:34 PM

hi^^

i just wondering way can't u write that we can have skype open when we are starting the server?????????

i get stack for i diden't know that^^ but i try to closed it and it's work^^ plz implument it its very importent.

wolfwalkereci 12-10-2011 08:04 PM

https://support.skype.com/en-us/faq/...n-to-use-Skype
Never had this issue myself and the above link doesnt show ports that would conflict but double check your settings.

werebat 12-27-2011 04:49 PM

I followed the guide except for the LoginServer part, I use Minilogin instead since its easier to set up. Anyways here is the combination of software I used.

Win XP 32bit
MySQL 5.1.60 Essentials
Perl 5.12 (I had to change the two pragma lines that said perl510.lib to perl512.lib)
Zlib 1.2.5

Any other working combinations would be appreciated. I have not tried MySQL 5.5 or Perl 5.14 on 32bit yet.

gr1m.a1ch3m157 12-29-2011 07:07 PM

I having trouble with the C++ Rebuild part of the tutorial... I have followed this tutorial to the absolute T and I get 3 success and 2 failed every time.. why is this? I have windows 7 64bit. Any help would be awesome. Cleaning it I get 5 success and 0 failed though. I went to the build log and found the 2 errors.

EQWParser.cpp
.\EQWParser.cpp(116) : error C2106: '=' : left operand must be l-value
.\EQWParser.cpp(123) : error C2106: '=' : left operand must be l-value

What do I do?

werebat 12-29-2011 08:54 PM

I had those same errors before and it was perl related. I dropped back from 5.14 to 5.12 and then it worked. There is another thread specifically for x64 compiles, check there.

gr1m.a1ch3m157 12-29-2011 09:36 PM

Same trouble.
 
I changed the Perl version but still nothing, any other ideas?

Malpercio 12-31-2011 01:53 PM

So i started following the tutorial today, and, using all the links/programs listed in the first post, it can't compile because it can't find zlib.lib. I checked in the folders and it doesn't exist, so I'm wondering if it's supposed to point at zdll.lib or zlib.def, or if I really am missing a file

werebat 12-31-2011 02:20 PM

Make sure you have the VC++ directories in the exact order as shown in the guide. If you are using XP 32 bit then you can use the programs I listed above, I know that combination works.

Malpercio 12-31-2011 07:03 PM

The problem is that it's looking for, but not finding, a file called zlib.lib (which makes perfect sense, as that file doesn't exist, and isn't supposed to, as it's not in either 1.2.3 or 1.2.5)
Example build log, using world specifically: http://dl.dropbox.com/u/9192467/BuildLog.htm

lerxst2112 12-31-2011 09:24 PM

Change the projects to link zdll.lib, or rename the file.

Malpercio 01-01-2012 03:16 AM

http://dl.dropbox.com/u/9192467/BuildLog.htm Same general problem, different specific error.

joligario 01-03-2012 12:39 AM

Are you using MySQL 5.5 lib/includes to compile? You should be able to get 5.1 folders for the compile while still running 5.5.

Malpercio 01-03-2012 02:32 AM

no, I'm using MySQL 5.1 (the full complete pack, not just essentials) and ActivePerl 5.10 build 1007, VC++ 2008 express edition.

werebat 01-03-2012 09:55 AM

You should not have to rename the file. My is zlib1.dll and works perfectly. Make sure a copy of it is in the system32 directory. I am usng zlib125-dll.zip from the zlib site. www.zlib.net

Malpercio 01-03-2012 02:47 PM

Okay, I have no explanation for this whatsoever, but renaming the file back to zdll.lib fixed everything.
Originally, it failed looking for zlib.lib
Then, giving it a zlib.lib to find caused collisons and broke stuff.
Then, giving it zdll.lib back somehow worked.
¯\_(ツ)_/¯

lerxst2112 01-03-2012 04:03 PM

Because it's finding zlib.lib in your mysql directory.

helman 01-08-2012 12:41 AM

I don't know if this has been said and i don't want to look through 18 pages to see. But instead of WinRAR how about 7zip? Its free and can open ever thing. Just a suggestion.

Valdis01 01-09-2012 03:47 AM

Hey guys, I had a quick question, so when doing the said updates using Navicat, the current DB that's out (As of... 10:25 PST January, 08 -2012) is, peqdb_rev2092... So, when opening the command prompt, and type 'source peqdb_rev2092.sql - it goes through all of it's files (Records, Query's etc) all of it's okay, gives me NO errors, at all... same with source load_player.sql (No errors) as well as the bots....

But then I get to the next part, where I have to update them through Navi, Since the PEQ DB is 2092... Wouldn't I need a higher one then 1711? At least, I thought that, but since the highest one there is 2087, I just clicked 1711 anyway... It gave me this,

[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`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I followed the guide to a T, went over it 30 times + to make sure everything was right... and I got nothing... Help?

lerxst2112 01-09-2012 04:01 AM

You only apply updates newer than your database version, so unless there are updates named 2093+ then you don't need to apply any.

Keep in mind this guide was written a long time ago, so you may have to use some common sense about a few things, like the updates.

Valdis01 01-09-2012 04:22 AM

I just realized that when I read on further and actually READ what the hell it said... That there was a duplicate detected, there for, the DB already had it made, my apologies, it's like, 2 AM, and I'm a bit tired... Heh, THANKS FOR THE GUIDE IT WORKS WONDERS! Now to edit everything =)..

By the way, Solo progression server (2 bots allowed and 2 box total) is up. =) Come have some fun.

Oaric 01-10-2012 11:25 AM

idk why but i just can't get my server to work. Every time i try to do the build after clean solution it always ends up with 4 fails. Any ideas?

lerxst2112 01-10-2012 03:06 PM

Quote:

Originally Posted by Oaric (Post 205806)
idk why but i just can't get my server to work. Every time i try to do the build after clean solution it always ends up with 4 fails. Any ideas?

Without any information on why it fails, like the actual error messages, no we have no ideas.

smcallister88 01-11-2012 05:35 PM

EQEmu Login Server issue
 
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...

smcallister88 01-11-2012 07:11 PM

**UPDATE** Fixed it myself =)

FirestormXL 01-16-2012 09:22 PM

Quote:

Originally Posted by Oaric (Post 205806)
idk why but i just can't get my server to work. Every time i try to do the build after clean solution it always ends up with 4 fails. Any ideas?

Ha, I'm getting the exact same thing. I'm going to look for a guide that doesn't involve Mucking around in C++, seems like a recipe for failure to me.

lerxst2112 01-16-2012 09:39 PM

Posting you have 4 that failed to build means you that you missed one or more steps in the guide. Posting the exact errors you receive means someone can tell you exactly what you did wrong and how to fix it. You pick which one helps you best.

FirestormXL 01-17-2012 01:07 AM

Got it down to two by doing everything over again with different version of Visual...

left operand must be l-value Are the only two errors i know of.

in EQWParser.cpp

lerxst2112 01-17-2012 05:15 AM

If you're using Visual Studio 2010 then install Perl 5.14.

If you're using Visual Studio 2008 install Perl 5.10 or 5.12.

If you install Perl 5.12 you'll need to find the two places in the code that reference perl510.lib and change them to perl512.lib.

FirestormXL 01-17-2012 05:26 AM

You got me there, now I got it all compiled and after a few hours managed to get the login server to actually be logged into by World.exe ... now the problem is I have no idea how to make ana ccount I tried typing one manually in with navicat by entering a name and apssword but nothing appears int he database according to login.

Valdis01 01-23-2012 06:22 PM

So, I can't figure out why quests/hails aren't working. I've done everything three times on three different computers to test maybe it was something with my OS or what not, and no, nothing seems to work... Any help would be great.

joligario 01-23-2012 07:56 PM

Maps in the correct folder (server/Maps)? Quests in the right folder (server/quests/zonename/npcname.pl)?

Valdis01 01-23-2012 08:26 PM

C:\eqemu\Maps\eqemu-maps is my map folder (Where it defaulted during install..)

C:\eqemu\quests\quests is my quest folder (Where it defaulted during install..)


All times are GMT -4. The time now is 05:24 PM.

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