[Guide] Setting up a Arcemu server from the scratch

[forces]

Great guide, honestly. Nice effort. +Rep

[Erase]

I get it all failed at 1.4 Compiling Arcemu.
I will +Rep if you help me!

[Chocoboeater]

I kinda got the same problem

1>------ Build started: Project: arcemu-shared, Configuration: Release Win32 ------
1>Extracting SVN revision...
1>SVN Revision Extractor
1>Written by Burlex, 2008/02/20
1>Branch: TRUNK
1>Revision found: 706
1>Opening existing file...
1>Revisions match exiting file. Skipping.
1>Compiling...
1>CreateInterface.cpp
1>c:\documents and settings\eigenaar\bureaublad\ascent\src\arcemu-shared\database\MySQLDatabase.h(7) : fatal error C1083: Cannot open include file: 'mysql/mysql.h': No such file or directory
1>WowCrypt.cpp
1>c:\Documents and Settings\Eigenaar\Bureaublad\Ascent\src\arcemu-shared\Auth/Sha1.h(25) : fatal error C1083: Cannot open include file: 'openssl/sha.h': No such file or directory
1>Sha1.cpp
1>c:\documents and settings\eigenaar\bureaublad\ascent\src\arcemu-shared\auth\Sha1.h(25) : fatal error C1083: Cannot open include file: 'openssl/sha.h': No such file or directory
1>MD5.cpp
1>c:\documents and settings\eigenaar\bureaublad\ascent\src\arcemu-shared\auth\MD5.h(24) : fatal error C1083: Cannot open include file: 'openssl/md5.h': No such file or directory
1>BigNumber.cpp
1>..\..\src\arcemu-shared\Auth\BigNumber.cpp(21) : fatal error C1083: Cannot open include file: 'openssl/bn.h': No such file or directory
1>MySQLDatabase.cpp
1>c:\documents and settings\eigenaar\bureaublad\ascent\src\arcemu-shared\database\MySQLDatabase.h(7) : fatal error C1083: Cannot open include file: 'mysql/mysql.h': No such file or directory
1>Build log was saved at "file://c:\Documents and Settings\Eigenaar\Bureaublad\Ascent\win\VC90\arcemu-shared___Win32_Release\BuildLog.htm"
1>arcemu-shared - 6 error(s), 0 warning(s)
2>------ Build started: Project: arcemu-world, Configuration: Release Win32 ------
3>------ Build started: Project: arcemu-logonserver, Configuration: Release Win32 ------
3>Compiling...
3>LogonStdAfx.cpp
2>Compiling...
2>StdAfx.cpp
3>c:\documents and settings\eigenaar\bureaublad\ascent\src\arcemu-logonserver\LogonStdAfx.h(36) : fatal error C1083: Cannot open include file: 'zlib.h': No such file or directory
2>c:\documents and settings\eigenaar\bureaublad\ascent\src\arcemu-world\StdAfx.h(51) : fatal error C1083: Cannot open include file: 'zlib.h': No such file or directory
3>Build log was saved at "file://c:\Documents and Settings\Eigenaar\Bureaublad\Ascent\win\VC90\arcemu-logonserver___Win32_Release\BuildLog.htm"
3>arcemu-logonserver - 1 error(s), 0 warning(s)
2>Build log was saved at "file://c:\Documents and Settings\Eigenaar\Bureaublad\Ascent\win\VC90\arcemu-world___Win32_Release\BuildLog.htm"
2>arcemu-world - 1 error(s), 0 warning(s)
========== Build: 0 succeeded, 3 failed, 0 up-to-date, 0 skipped ==========

This is what I get at step 1.4. Could anybody help me and tell me what I am doing wrong here?

[forces]

You might have better success using my guide here -

[LostprophetVII]

Hi, need help. I get an error while trying to restore from sql dump.

Open SQLyog and put in the information like this picture (your password is the one you set before):




and click connect when you have done that.

Now right click your accounts database and go to "Restore From SQL Dump".






Navigate to your ascent folder and go to ascentsql and select the logon_structure.sql then click execute.




Do the same for character_structure.sql in that folder.

I do exactly what it says, choose the same path, but I get some weird error.

There was an error while executing a query.
The query and the error message has been logged at:
C:UsersAlecAppDataRoamingSQLyogsqlyog.err.
Please click on "Open Error File..." to open the error file.

Open the error:

Query:
CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
  `login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username',
  `password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password',
  `encrypted_password` varchar(42) collate utf8_unicode_ci NOT NULL default '',
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions',
  `banned` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Account Standing',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Last remote address',
  `email` varchar(64) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Contact e-mail address',
  `flags` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Client flags',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) NOT NULL default '0',
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information'


Error occured at:2008-08-19 19:59:26
Line no.:20
Error Code: 1050 - Table 'accounts' already exists

Have no idea what to do..plz help!

[dajesse]

coo, ive heard that arc-emu pwnz lol

[forces]

Hi, need help. I get an error while trying to restore from sql dump.




I do exactly what it says, choose the same path, but I get some weird error.

There was an error while executing a query.
The query and the error message has been logged at:
C:UsersAlecAppDataRoamingSQLyogsqlyog.err.
Please click on "Open Error File..." to open the error file.

Open the error:

Query:
CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
  `login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username',
  `password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password',
  `encrypted_password` varchar(42) collate utf8_unicode_ci NOT NULL default '',
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions',
  `banned` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Account Standing',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Last remote address',
  `email` varchar(64) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Contact e-mail address',
  `flags` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Client flags',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) NOT NULL default '0',
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information'


Error occured at:2008-08-19 19:59:26
Line no.:20
Error Code: 1050 - Table 'accounts' already exists

Have no idea what to do..plz help!

Delete the Accounts table and execute the query.

[LostprophetVII]

Ok now I have another problem, but its my last. When I run enUs.cmd in the Data\enUS folder, it extracts like it says it does, but no dbc folder is created. What gives?

[Wolverine77]

great guide but had trouble with this part cause you dont say what it is to right clik!

" Right click it, and select edit and open it in notepad. Now edit it like in the picture
below then save and close.

[joshd35171]

Someone75, your not the maker of this guide! Jargs is.

[strov3]

i can compile only 2 ot of 3 file here ... anyone know how i can solve this problem ?

------ Build started: Project: arcemu-world, Configuration: Release Win32 ------
Linking...
fatal error C1047: The object or library file '.\arcemu-shared___win32_release\shared.lib' was created with an older compiler than other objects; rebuild old objects and libraries
LINK : fatal error LNK1257: code generation failed
Build log was saved at "file://c:\Documents and Settings\HP_Administrateur\Bureau\arcemu\trunk\win\VC90\arcemu-world___Win32_Release\BuildLog.htm"
arcemu-world - 1 error(s), 0 warning(s)
========== Build: 0 succeeded, 1 failed, 2 up-to-date, 0 skipped ==========

[TelepathicIndian]

:S I had it working for about a week, sticking my computer on hibernate every night, but damn Microsoft Updates just restarted...
How do I start it up again with the same databases as last time? if I just run arcemmu-world.exe and arcemu-logonserver.exe then it says that I'm unable to connect to the database. On all my old servers, it usually runs a third one that's ran before those 2 which allows them to connect, if it exists in this one, where is it? if not then what should I do? coz last time I tried running it back up, I tried using MySQL to create new DB's which overwrote the old ones :S

[strov3]

thanks a lot for the help ....

[TelepathicIndian]

strov3, I've forgotten what I did but in one of the downloads, there's a readme which has a step that wasn't that clear in the guide, have a go at following it and if you have anymore probs post it again

[TelepathicIndian]

in step 1.3, I used the readme in that, and once I did it worked
it also became obvious in the guide xD