COMPLETE PUBLIC SERVER SETUP - Jan-2011

[lerxst2112]

Looks like Trevius beat me to the punch, but maybe this will help anyway.

You can do everything you need to from the command prompt and not have to worry about using a different tool to create the database. I remember when I originally tried to use SQLyog to source load_player.sql it failed because it doesn't set the current directory to where the file you're importing is so it couldn't find the player_tables directory.

I also show deleting the existing database just to be sure you are starting from scratch. It sounds like, from the issues you posted, that you may have had something leftover there causing a conflict.

Substitute whatever directory you have the peq files in for the first command. The blue text is what I typed. I didn't include all of the spam the source commands generate because it wouldn't be helpful. If you want to save all of the output to a file you can type tee output.txt as the first command at the mysql> prompt. The file will be saved in the directory you started MySQL from.

If you are not using bots then skip the source load_bots.sql command.

C:\>cd EQEmu\Database\peqdatabase

C:\EQEmu\Database\peqdatabase>dir
 Volume in drive C has no label.
 Volume Serial Number is 4A57-06FC

 Directory of C:\EQEmu\Database\peqdatabase

12/06/2011  03:11 AM    <DIR>          .
12/06/2011  03:11 AM    <DIR>          ..
10/04/2010  10:20 PM               564 drop_bots.sql
12/05/2011  07:55 PM             2,566 drop_player.sql
12/05/2011  07:55 PM             2,752 drop_system.sql
10/04/2010  10:20 PM               276 load_bots.sql
12/05/2011  07:55 PM             2,659 load_player.sql
12/05/2011  02:02 AM       169,453,496 peqdb_rev2083.sql
12/05/2011  07:55 PM        22,451,506 peqdb_rev2083.sql.gz
12/05/2011  07:55 PM    <DIR>          player_tables
10/04/2010  10:20 PM             1,586 readme.txt
12/05/2011  07:55 PM    <DIR>          updates
               8 File(s)    191,915,405 bytes
               4 Dir(s)  495,992,610,816 bytes free

C:\EQEmu\Database\peqdatabase>mysql -uroot -p
Enter password: *****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.91-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database peq;
Query OK, 151 rows affected (2.15 sec)

mysql> create database peq;
Query OK, 1 row affected (0.00 sec)

mysql> use peq
Database changed

mysql> source peqdb_rev2083.sql
mysql> source load_player.sql
mysql> source load_bots.sql
mysql> quit

[pepsiphreak79]

yes i was using an ax repack and its still in another dir and working if i shut mine off and turn it on but its not working how i want a server to if that explains anything...

My first attempt was so use there portable mysql ect... since it was all ready to go with eqemu but each attempt failed

I have switched to a but naked uniserv
Apache 2.2.21
MySQL 5.5.18-community
PHP 5.3.8
perl 5.10

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

I believe this part was what had me from my understanding of what was written in tutorial was that this was to be the db stored files and so to copy your newly downloaded sql to it but since my portable doesnt work like others stuff it was my issue
i was copying the sql to the peq dir from the mysql and it looks like that was what botched it.... and yes up above i said thats what i did so instead i just resourced and i stoped getting the frustrating errors i still have no clue why it errord with the sql file in the db dir but oh well thats beyond my understanding. i got past it. just now

so im going to try the rest off the installs

is it ok to populate my naked login database using the login DB from a repack??

[pepsiphreak79]

and i just saw your posts lol thank you

[pepsiphreak79]

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.

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

[trevius]

Originally Posted by pepsiphreak79

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.

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.

Originally Posted by pepsiphreak79

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]

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]

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]

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]

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]

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]

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]

Originally Posted by pepsiphreak79

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

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]

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]

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]

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.