[Epic Guide] Setting Up and Running an ArcEmu Server from Scratch!

[psychobandit]

Everything seems to be working fine, except I get this error..

Highlighted in Red.
[IMG]file:///C:/Users/ROBBYT%7E1/AppData/Local/Temp/moz-screenshot.png[/IMG]

Uhm, not to sure.
I'm running Windows Server 2008 SP2
Everything seems to be fine, until that part.
I checked the RemoteLogon and they are the same in World and Logon Configs.
Any suggestions?
Thanks in Advance!

Ya I agree with Suamere, it looks like you didn't start "logon.exe". Separate from that, it looks like your DB is either fubar, or you are using an outdated one (or an outdated server) because of all those sql failure messages about the "loot"s missing. So, What DB are you using?
.
.
.

[robbythedude]

From what I can see on THAT screen, you don't have your logon server open. That's why it is failing to connect to it. You should first open Logon.exe, then open World.exe.

But according to your previous post, your Logon server isn't working. And the image says Config.cpp line 282 is the problem.

I'm guessing your logon configuration isn't 100% proper. So post your logon config file contents (Not the note areas, just the used areas). Perhaps something can be caught in there.

Oh boy..
So I ran the Logon server, then the world.
That fixed it. Thank You!
haha
Now bout those SQL errors...


Edit 1:
Wait..
I've discovered my problem I think.
Using WhyDB, and in the table "db_version" under column "game_version" it says 3.3a.
The server is compiled for 3.2, so how do I get an older DB?
Or how do I work with it? lol

Edit 2:
Well that theory above was wrong.
I downloaded an older revision of WhyDB (94).
Ran and followed the on-screen instructions.
Deleted Old World DB - Uploaded New DB - and now it says in the table "db_version" under column "game_ version" 3.2a
Ran the Logon.exe and World.exe... Got same exact SQL error.
Any Solutions would be nice.
Thanks in Advance.
Bed time, stressed out.

[solariis]

Just as a nub suggestion... You might have to run as administrator if you are running in Vista. Also, this often happens because a step was missed where you have to copy over the config files to the proper folders, or other copying over files between folders. Just nub suggestion, I don't really know, lol.

Yeah, it's W7 and its on admin account so no need to run as admin. All config files were brought over and redone 2x :-( Should I post my configs? Maybe there's something I missed or just don't understand. I can admit I'm walking into this quite blindly.

[psychobandit]

Yeah, it's W7 and its on admin account so no need to run as admin. All config files were brought over and redone 2x :-( Should I post my configs? Maybe there's something I missed or just don't understand. I can admit I'm walking into this quite blindly.

Well I know nothing of Win7, but I DO know in Vista, even when you re logged in under Admin, you STILL have to right click the .exe's & tell it to run as administrator....So you may want to try it just for shits & giggles.
I just went back & read your original post, The (current_variable ! = "") message I believe is caused by, In your configs (world or optional I believe) there are places that say things like "blocked channels name" etc. that don't have any name in them right now, they just have the "" symbols. To solve it, put something between them. I can't tell you what to put because there are a few of them & you have to read what the variable is for & decide what to put. For the other error (access denied to localhost), Either your password was never set in MySQL, OR, it's because you have to do the "run as admin." mentioned above.
Posting your configs will be a last resort because they take up SSSOOOO much space.
.
.
.

[psychobandit]

Oh boy..
So I ran the Logon server, then the world.
That fixed it. Thank You!
haha
Now bout those SQL errors...


Edit 1:
Wait..
I've discovered my problem I think.
Using WhyDB, and in the table "db_version" under column "game_version" it says 3.3a.
The server is compiled for 3.2, so how do I get an older DB?
Or how do I work with it? lol

Edit 2:
Well that theory above was wrong.
I downloaded an older revision of WhyDB (94).
Ran and followed the on-screen instructions.
Deleted Old World DB - Uploaded New DB - and now it says in the table "db_version" under column "game_ version" 3.2a
Ran the Logon.exe and World.exe... Got same exact SQL error.
Any Solutions would be nice.
Thanks in Advance.
Bed time, stressed out.

Edit one is the correct DB, all that 3.3a part means is the DB has some items/NPC's/etc. from the newer game but it is still the DB for 3.2.2a.

Are you using the "tool.bat" to create your World DB? because if not, it will cut off part of the DB. Assuming you are doing it correctly, Look in your world DB, are there 6 loot_"something" in there?
.
.
.

[robbythedude]

I'm running the "Tool.bat", and here it is even importing six "loot" tables.



Then I look in Navicat, and it even says their are six "Loot" tables.



Still getting the same exact error.
I'm missing the "prospecting", "milling" , and "disenchanting" loot tables.

WhyDB showed no signs of it even importing those three tables...

Edit 1:
I updated WhyDB back to revision 100, and still getting the same error after dumping the old tables and executing the new.

[psychobandit]

I'm running the "Tool.bat", and here it is even importing six "loot" tables.

Then I look in Navicat, and it even says their are six "Loot" tables.

Still getting the same exact error.
I'm missing the "prospecting", "milling" , and "disenchanting" loot tables.

WhyDB showed no signs of it even importing those three tables...

Edit 1:
I updated WhyDB back to revision 100, and still getting the same error after dumping the old tables and executing the new.

O.k. o.k. o.k.....I missed that. There ARE no loot tables for prospecting, milling, or Disenchanting! So, it is core related & NOT DB related.. Milling & prospecting were implemented in game version 3.3.0 so you are using the wrong core, THAT is the problem! How exactly to fix it, I am not sure because I never figured out how to compile older revisions. I'll tell you this though. I BELIEVE you can still play the game even with those alarm messages. So, try to log in to the game and play around a bit & see if it works properly. If not, I'll do some research & figure out how to compile for older game versions (Or you could update your game to 3.3.x, but THAT will be really buggy since Arc just started supporting it).
.
.
.

[robbythedude]

O.k. o.k. o.k.....I missed that. There ARE no loot tables for prospecting, milling, or Disenchanting! So, it is core related & NOT DB related.. Milling & prospecting were implemented in game version 3.3.0 so you are using the wrong core, THAT is the problem! How exactly to fix it, I am not sure because I never figured out how to compile older revisions. I'll tell you this though. I BELIEVE you can still play the game even with those alarm messages. So, try to log in to the game and play around a bit & see if it works properly. If not, I'll do some research & figure out how to compile for older game versions (Or you could update your game to 3.3.x, but THAT will be really buggy since Arc just started supporting it).
.
.
.

Alright I left it running and tried connecting through world of warcraft client.
I get, "Login Server Down".

Uhm, Screenshot time.


^Right-Click View Image for a better view^

I got firewalls turned off completely on each computer.
Logon server is running, and I think it's running fine.
World server is fine, except for the SQL errors.
I got my realmlist set to 127.0.0.1 (Above in Screen Shot)
I'm running through a 24 port switch that has both computers directly connected, and I'm pretty sure there is no security on the Switch.
(I host lans with all 24 people connected to the switch with no problem. No need to port forward, or mess with anything on the Switch)
Uhm Suggestions now?

I'd rather stay at 3.2.2a cause it is less buggy.

[solariis]

Hey Psycho, I tried to PM you but my msg count isn't up high enough. :-( Is there any way I can speak with you in private?

[Zorlan]

Hey i like the guide, but you write that i have to change the Whydb_World to world? But when i got tool.bat and open up edit, i cant find "whydb_world? Where is it?

[psychobandit]

Hey i like the guide, but you write that i have to change the Whydb_World to world? But when i got tool.bat and open up edit, i cant find "whydb_world? Where is it?

I said it before & I'll say it again. Read through the thread! That issue has been answered repeatedly. I believe in the last few pages.

[psychobandit]

Alright I left it running and tried connecting through world of warcraft client.
I get, "Login Server Down".

Uhm, Screenshot time.

I got firewalls turned off completely on each computer.
Logon server is running, and I think it's running fine.
World server is fine, except for the SQL errors.
I got my realmlist set to 127.0.0.1 (Above in Screen Shot)
I'm running through a 24 port switch that has both computers directly connected, and I'm pretty sure there is no security on the Switch.
(I host lans with all 24 people connected to the switch with no problem. No need to port forward, or mess with anything on the Switch)
Uhm Suggestions now?

I'd rather stay at 3.2.2a cause it is less buggy.

Well let's see...I've never tried a hook up like that so I have no suggestions for multi computer connections. Until it's working, only try & logon with the computer that actually has the server on it K? Now, I did some minor research last night & it seems you can't connect a 3.2.2 game to the 3.3.X server So what we got to do is figure out how to compile the last "3.2.2a" server version. After I am done here, I am going to go find out how to do that & I'll edit in the info. If you read this before I get back, I want you to try 2 things. 1st, go in to the "realmlist.wtf" and put a pound sign before everything but the set realmlist line.

like this:

set realmlist 127.0.0.1
#set patchlist us.version.worldofwarcraft.com
#set realmlistbn ""
#set portal us

and 2nd, when you compiled the server, it told you to only move the arcemu-logonserver.exe & arcemu-world.exe to your sever folder. I want you to go back to that folder (arcemu\trunk\bin\Release) & also move these files to your server folder: arcemu-logonserver.exp, arcemu-logonserver.lib, arcemu-logonserver.pdb, arcemu-world.exp, arcemu-world.lib, arcemu-world.pdb, collision.exp & collision.lib. Even when I get the info on compiling a lower rev, I am still going to have you do these 2 things O.K.?

*edit* To revert the SVN, Right click on the ArcEMU folder in your SVN folder, go to "tortoiseSVN" on the drop down menu & then to "Update To Revision" on the sub-menu & click it. On the window that pops up, tick the circle next to "Revision" & in the box next to it type "3150", Then click "ok". That will open the update window, when it's done, you will have been reverted to version 3150 (last rev before 3.3.2 changes). Now, compile the server like you did before remembering to do the 2 changes I said above this & see if that will finally let you go in. I have also done this & am re-compiling myself so if I hit any snags, I'll write them here.
.
.
.

[psychobandit]

Hey Psycho, I tried to PM you but my msg count isn't up high enough. :-( Is there any way I can speak with you in private?

I'll send you a PM in a minute, then I gotta log off. But see if you can do a reply to my PM.

[solariis]

I'll send you a PM in a minute, then I gotta log off. But see if you can do a reply to my PM.

No dice. Would you mind terribly if we chatted through email? Send me yours through PM?

Thanks :-) Crystal

[robbythedude]

Well let's see...I've never tried a hook up like that so I have no suggestions for multi computer connections. Until it's working, only try & logon with the computer that actually has the server on it K? Now, I did some minor research last night & it seems you can't connect a 3.2.2 game to the 3.3.X server So what we got to do is figure out how to compile the last "3.2.2a" server version. After I am done here, I am going to go find out how to do that & I'll edit in the info. If you read this before I get back, I want you to try 2 things. 1st, go in to the "realmlist.wtf" and put a pound sign before everything but the set realmlist line.

like this:

set realmlist 127.0.0.1
#set patchlist us.version.worldofwarcraft.com
#set realmlistbn ""
#set portal us

and 2nd, when you compiled the server, it told you to only move the arcemu-logonserver.exe & arcemu-world.exe to your sever folder. I want you to go back to that folder (arcemu\trunk\bin\Release) & also move these files to your server folder: arcemu-logonserver.exp, arcemu-logonserver.lib, arcemu-logonserver.pdb, arcemu-world.exp, arcemu-world.lib, arcemu-world.pdb, collision.exp & collision.lib. Even when I get the info on compiling a lower rev, I am still going to have you do these 2 things O.K.?

*edit* To revert the SVN, Right click on the ArcEMU folder in your SVN folder, go to "tortoiseSVN" on the drop down menu & then to "Update To Revision" on the sub-menu & click it. On the window that pops up, tick the circle next to "Revision" & in the box next to it type "3150", Then click "ok". That will open the update window, when it's done, you will have been reverted to version 3150 (last rev before 3.3.2 changes). Now, compile the server like you did before remembering to do the 2 changes I said above this & see if that will finally let you go in. I have also done this & am re-compiling myself so if I hit any snags, I'll write them here.
.
.
.

Alright, I understand.
I'll try it out when I got the chance!
Working non-stop lately...
Love McDonalds!!
I'll hit you up with results when I can. Tomm most likely!

Thanks for all the help btw <3