COMPLETE PUBLIC SERVER SETUP - Jan-2011

[lerxst2112]

My server works perfectly since I followed a guide very similar to this one. I didn't know how MySQL worked or what sourcing files was when I started, but by reading and following the instructions I worked it out.

Lashing out at everyone that has tried to help you really isn't going to make them or anyone else want to try and help you. You might consider being polite and rational about it since you're the one that needs help, not me.

Yes, this guide is not the only way to setup a server, but this way has worked for many people and it could work for you too. Perhaps if you follow this guide to setup a non-portable server you will be able to take that experience and be able to figure out how to make the portable server you want.

Good luck.

[pepsiphreak79]

Again not helpfull at all

So i was able to find the peq datadir ill attempt this sorcing thing If anyone else has issues because there not setup the same your dirs for the sql may be located in \mysql\data\peq
and not in the c:\peqdb dir as some may have it no offense to the writer of the first page walkthrough its great you did that

mine happens to be
C:\eqemu\UniServer\usr\local\mysql\data\peq

Now i am starting with a naked Database
i have the standard structure of
DB information_schema - Standard mysql initial stuff unsure if anything needs altering
DB login - utf8 - bin Completly naked i assume i needed it so i created it
DB mysql - filled with the standard stuff for all my sql
DB peq - utf8 - bin format and completly empty (completly empty mind u)
DB performance_schema - again standard sql stuff
DB phpmyadmin - Standard stuff again and not relivant to eqemu

i went to the peq dir i did sorce it started importing and a bunch of errors like



Query OK, 0 rows affected (0.00 sec)

ERROR 1050 (42S01): Table '`peq`.`ground_spawns`' already exists
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'peq.ground_spawns' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

in that order and alot more than that but it wont save that far up in the cmd window

i checked back and they really were missing after the import so what thats telling me is the .SQL file is telling mysql to create if not there before its telling mysql to delete it

so this whole time its not my importing through heidisql its the SQL itsself that is not working correctly

Its creating the table thats missing then deleting it then its unable to run the insert commands because the table is missing...

i appear to have a bad SQL db as i assumed... is there a 2068 DB around anywhere that is uncustomized? since the 2027 db im using is not allowing a full source

I did not run any updates because the initial sourcing failed and alot of stuff is not included anyway

what i came out with is a peqdb that was missing some tables
and not sure how to pupulate the login db so i will just copy another one into that one

i found the 2083 i will clear and try that one instead
http://code.google.com/p/projecteqdb/downloads/list
is where the 2083 db is

[trevius]

As has already been said, your attitude is not likely to get you much assistance with your issues. The community is often likely to help people when they can, but no one is getting paid to do so, so being rude is more likely to result in no responses. You have started off rude in this thread and every post since then has followed that same overall feeling.

Regardless of what you may think, lerxst2112 is one of the more active, more knowledgeable and more helpful people in the EQEmu community right now. You are working against yourself to be rude to him like that. I won't tolerate disrespect to top notch community members, so please stop it.

First of all, from all of your posts, it looks like you are not following the guide exactly. You are trying to take short cuts or use other tools/procedures you have used for setting up your WoW emu server. If you knew exactly what you were doing and if you were able to get your server setup by doing things differently than the guide says, then that would be good. Unfortunately, that isn't working out so well for you. My suggestion would be to follow the guide exactly. If you can get the server working by following the guide exactly, then you can start doing your other stuff.

Yes, the EQEmu guides could probably be made better. Part of the problem is that there are many different Operating Systems that can run EQEmu and setting it up on each one can be slightly different. So, it does require a bit of knowledge here and there and is not for everyone out there. Though, there have been hundreds of servers created over the years using similar guides, so it isn't as hard as you make it out to be.

If you are having this much trouble just getting the server running, you are really probably going to have a hard time getting your Login Server or MiniLogin working. Both of those can be kinda tough to get working initially without a little bit of knowledge on what you need to do. The guides help, but many people have issues with it. Getting a public server running that uses the public EQEmu Login Server is much easier and most people do it that way for that reason.

Your posts on the issue seem to be all over the place. You mentioned AX classic repack, and that isn't supported here. You might try their website to see if there is better info there for it. From what I have heard of it, that is about as easy as it gets.

Your problems could be any number of things, and you may not even have the right versions of perl or mysql installed, which is only going to add to your issues.

Good luck with getting it all running. If the negative attitude keeps up, you will be temp banned to let you hopefully cool off.