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

[thug123]

wtf on me it says execute SQL file and when i done it and this

<ArcEmu Source>/trunk/sql/ and find the database structure for the corresponding database. Now go to <ArcEmu Source>/trunk/sql/utilities and open ArcEmu DB Updater.bat, for this you will need to type in, localhost, 3306, root, <pass>(your password), logon, char, world. Now you will need to type a and press enter.

i dont got Arcemu updater.bat :S

[mrbob]

If you look at the older revisions with Turtlesvn its commented they took it out.

I just spent 13 hours trying and trying again to get this to work without an luck, tried just about every guide on here none seem to work atm or be in date?

Even the AD map extractor fails every time on several different wow installs I have on different HD's.

Closest I got to workign was a MaNGOS repack but thats a repack and well not what Im after ^-^

[psychobandit]

If you look at the older revisions with Turtlesvn its commented they took it out.

I just spent 13 hours trying and trying again to get this to work without an luck, tried just about every guide on here none seem to work atm or be in date?

Even the AD map extractor fails every time on several different wow installs I have on different HD's.

Closest I got to workign was a MaNGOS repack but thats a repack and well not what Im after ^-^

What you'd need to do to use this guide, is read through all the pages looking for my posts. I have posted lots of corrections throughout this thread. A BETTER way to at least learn how to set-up & compile ArcEMU, is to go to their wiki page and follow it's instructions (though it has flaws too :laff.
Here's the link-->Arc Wiki. Start @ the "getting started" section.

I feel I must point out, ArcEMU is NOT "newbie" friendly. They assume you already have knowledge on how to set-up/compile your own server & of course, common sense (which I don't believe there IS such a thing )

And again, since we are on a new page, All credit for this guide goes to Apple Pi. It is NOT my guide, I am just here to help where I can
.
.
.

[mrbob]

What you'd need to do to use this guide, is read through all the pages looking for my posts. I have posted lots of corrections throughout this thread. A BETTER way to at least learn how to set-up & compile ArcEMU, is to go to their wiki page and follow it's instructions (though it has flaws too :laff.
Here's the link-->Arc Wiki. Start @ the "getting started" section.

I feel I must point out, ArcEMU is NOT "newbie" friendly. They assume you already have knowledge on how to set-up/compile your own server & of course, common sense (which I don't believe there IS such a thing )

And again, since we are on a new page, All credit for this guide goes to Apple Pi. It is NOT my guide, I am just here to help where I can
.
.
.

The guide is great but as you say not for some one who has never done this before ofc it is nice to see effort from ppl helping didnt mean to bash the work, but unless you know how to fix the little things (And there are lots!) it wont work.

I did go through the wikki a few times even joined the ArcEmu forums and read for a couple of hours or so, and the guide I even got the mrs to make sure I was following it as it instructs on the 4th atempt ^-^

Still in the end I got my head around it all I managed at about 3am to get a bastardised database that worked from a repack and the sql server stuff was easy, seems the hard part is getting a database that works? setting the core up was the easy bit funny enough.

[THemeet]

I have a problem i od not know how work tool.bat
MySQL address : ??
MySQL Username : Root?
MySQL Password : ******?
World Database : ??????

[THemeet]

And How to get updater.bat ???

[johnyelland1234]

I have a problem i od not know how work tool.bat
MySQL address : ??
MySQL Username : Root?
MySQL Password : ******?
World Database : ??????

The SQL address (if your running on the same machine) should be

localhost
SQL username is: root (all lowercase)

password should be: ascent
and for the world database it should be: world


Give that a whirl! so to clarify:

SQL address: localhost
Username: root
Password: ascent (if you followed this guide, change it after your finished setting up your server).
world database: world

-----------

Also, you dont need the updator tool for your character databases.

Take a look here:
http://www.arcemu.info/wiki/index.ph...Database_setup

[psychobandit]

The guide is great but as you say not for some one who has never done this before ofc it is nice to see effort from ppl helping didnt mean to bash the work, but unless you know how to fix the little things (And there are lots!) it wont work.

I did go through the wikki a few times even joined the ArcEmu forums and read for a couple of hours or so, and the guide I even got the mrs to make sure I was following it as it instructs on the 4th atempt ^-^

Still in the end I got my head around it all I managed at about 3am to get a bastardised database that worked from a repack and the sql server stuff was easy, seems the hard part is getting a database that works? setting the core up was the easy bit funny enough.

hehheh, no worries. I didn't think you were bashing the work I was just making sure I was clear about this guide NOT being up to date and that there are lots of corrections throughout the thread
Did you try WhyDB for the world database? WhyDB is the only one specifically written for ArcEMU. It DOES have lots of flaws, but they are all in-game. Setting it up should net you no errors/alarms as long as you use the most current ArcEMU & the most current WhyDB
.
.
.

[THemeet]

Yea lol i have Two arcemuVC90 - All Projects
1 : arcemuVC90 - All Projects
2 : arcemuVC90 - All Projects no scripts
Wich one is good

[THemeet]

And the last problem arcemu-world.exe and arcemu-logonserver,exe dont work it say : the part LIBEAY32.dll is missing

WTF is this?

[psychobandit]

And the last problem arcemu-world.exe and arcemu-logonserver,exe dont work it say : the part LIBEAY32.dll is missing

WTF is this?

......oooo...kkkkk.....I wrote a reply to this 2 days ago......where did it go????
well, let's see if I can replicate it shall we? though I'll be nicer today. I was in a really bad mood when I wrote it before so:

I KNOW I have answered this before in this thread, more than once I'm pretty sure....remember people, the search button is your friend!
Anywho, You need to go to the folder at "arcemu\trunk\extras\arcemu-windows-libraries\DLL Files" and copy the files "libeay32.dll" & "libmySQL.dll" & then paste them inside you server folder.

As for the "arcemuVC90 - All Projects" & "arcemuVC90 - All Projects no scripts", Use the first one if you want to use/enable the scripts & LUA files (which you have to turn on in one of the configs & copy the LUA files to your server folder). Use the 2nd one if you DON'T want to use/enable the scripts & LUA files.
.
.
.

[Desiderium]

I am getting an error:

1045 - access denied for user 'root'@localhost' (using password: yes)

When i get to THIS point in the guide

B) Setting Up The Database

Now It's time to set up the database. Open up navicat create a new connection and under pass put the <pass> I told you we would need later. Then press OK. After that open the connection by double clicking on localhost, then right click localhost and click new database, you will be making 3, one named world, one named char and, one named logon. Go to the folder where you downloaded WhyDB, there should be a file called tool.bat. Right click it and press edit. Change WhyDB_world to world. then save and close it. Now open tool.bat, it will ask you for you information, the first will be root the second will be your <pass>. Then type i and press enter. Now you need to go back to navicat and double click char and logon. After you have done so you will need to right click them and choose execute batch file,Now go to <ArcEmu Source>/trunk/sql/ and find the database structure for the corresponding database. Now go to <ArcEmu Source>/trunk/sql/utilities and open ArcEmu DB Updater.bat, for this you will need to type in, localhost, 3306, root, <pass>(your password), logon, char, world. Now you will need to type a and press enter.

I did try to setup a private server sometime ago, so I imagine that is causing me some issues here, but I do not know how to work around it, can anyone offer me some advice?


Oops, I had the wrong section of guide copy/pasted, edited now




second edit:


OK so, I can't seem to setup a password with either MySQl or the Navicat, or it can't connect, but does connect otherwise, any suggestions?

Also, I cannot find the word WhyDB_World in the tool.bat file to change it as he mentions in the guide, any suggestions? Thanks for the help everyone.

[psychobandit]

I am getting an error:

1045 - access denied for user 'root'@localhost' (using password: yes)

When i get to THIS point in the guide

B) Setting Up The Database

Now It's time to set up the database. Open up navicat create a new connection and under pass put the <pass> I told you we would need later. Then press OK. After that open the connection by double clicking on localhost, then right click localhost and click new database, you will be making 3, one named world, one named char and, one named logon. Go to the folder where you downloaded WhyDB, there should be a file called tool.bat. Right click it and press edit. Change WhyDB_world to world. then save and close it. Now open tool.bat, it will ask you for you information, the first will be root the second will be your <pass>. Then type i and press enter. Now you need to go back to navicat and double click char and logon. After you have done so you will need to right click them and choose execute batch file,Now go to <ArcEmu Source>/trunk/sql/ and find the database structure for the corresponding database. Now go to <ArcEmu Source>/trunk/sql/utilities and open ArcEmu DB Updater.bat, for this you will need to type in, localhost, 3306, root, <pass>(your password), logon, char, world. Now you will need to type a and press enter.

I did try to setup a private server sometime ago, so I imagine that is causing me some issues here, but I do not know how to work around it, can anyone offer me some advice?


Oops, I had the wrong section of guide copy/pasted, edited now

Are you having problems with that whole section you copied? because some of those things I have written corrections to on 1 or 2 pages back.
As for the "access denied" part. I'd need more info to track down the actual cause, But I will try with what I THINK the problem is. In the guide, it tells you not to put a password in when setting up MySQL, I totally disagree with that part, especially because in this section it says "under pass put the <pass> I told you we would need later". I just read the whole guide again & NO where, does it tell you what the password you need later should be. In fact it never talks about the password at all between MySQL and this part.
Because of that I am assuming the password "yes" is wrong because you never put "yes" into MySQL.
So, going on the assumption you never put in a password, 1st try not putting anything in for password when the tool.bat asks for one. IF that doesn't work, you need to go to folder "C:\Program Files\MySQL\MySQL Server 5.1\bin" and dbl click "MySQLInstanceConfig.exe" and follow what it says (should be similar to the guide though the 1st few pages/pop-ups are new). When it gets to the page about putting in a password, actually do it!
Once that is done, restart the computer, then continue with the guide.
.
.
.

[Desiderium]

well of one note, i'm using mySQl 5.5

However - yes, that is the issue I'm having with passwords, its never letting me set one up.

So, if i go and do what you just said, on MYSQl first, then i'll have to reconnect (and it will work?) via navicat using the password for the connection? Is there anywhere else I will have to update?

I have kinda skipped ahead to close to setting the server up and didn't use a password for now, but on that note, I'm getting an issue where it says connection failed due to unknown mysql server host 'world' (11001) or something like that, is there a way to get around this?

[atomikgodz]

i made my own server long time ago well mabye 1 year ago or lil more.... ima try it again since i ahve some time to put into it and have a goal to acomplish... i have a new gaming computer but its win 7 home prem version and x64 system

im near the beginning and im at the release folder part the release_x64 is that what i would use and if so wha ti need to do as the reg release ahs more stuff in it then the x64 would ? so what would i do i like ur gudie and so far i read threw it and looks simple jsut need some lil help plz thanks