[Guide] set up your server with Spartansp Repack V3 (public)

[Stagrad]

It says

Cannot Create windows service for mySQL.Error 0

[mcguff]

mine stays at handshaking then after a while it d/c's and the ascent-realmserver doesnt work heres the error sql:connection failed. reason was "Acess Denied for user moocow@localhost using password: YES

[hlk2005]

I am not sure what it is that I have dont wrong. But i keep getting stuck at handshaking.. and i have no idea what the problem is. I followed the guide correctly. maybe I am just over looking something, if you or anyone could help me. Thanks..
Reason1908 @yahoo.com
Lee

[cartle020989]

ok i got almost all the way done before i got extremely confused with this part "After done with that go into your C:/Windows/system32/drivers/etc/ folder and open with notepad the file named hosts and add the following" then from there on im stuck

[Djfrederick]

Hey i willy need some help. I dunno if its my computer there is something wrong with, or if its me there have done anything totally wrong..

Every time i download MySQL and i go to the 'MySQL Server Instance Config Wizard' and do all the steps. Then i come to the 'Execute' thing. Then it say this:

Quote------------------------------------------------------------------------------------------------------------------------------
The Security settings could not be applied to the database
because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: YES)

If a personal firewall is running on your machine, please make
sure you have opened the TCP port 3306 for connections.
Otherwise no client appliction can connect to the server.
After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server plase note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now
and re-run the Configuration Wizard for the start menu.
------------------------------------------------------------------------------------------------------------------------------------------

I have tryed to re-installe it 100 of times now. and i am sure i have done the other thing to..
I dont know what i shall do, but i am sure you have been out for this some time before.
Please answer me on this: Thanks!

[Lukas 45]

Hey i willy need some help. I dunno if its my computer there is something wrong with, or if its me there have done anything totally wrong..

Every time i download MySQL and i go to the 'MySQL Server Instance Config Wizard' and do all the steps. Then i come to the 'Execute' thing. Then it say this:

Quote------------------------------------------------------------------------------------------------------------------------------
The Security settings could not be applied to the database
because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: YES)

If a personal firewall is running on your machine, please make
sure you have opened the TCP port 3306 for connections.
Otherwise no client appliction can connect to the server.
After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server plase note that the data directory was not removed automatically.
Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now
and re-run the Configuration Wizard for the start menu.
------------------------------------------------------------------------------------------------------------------------------------------

I have tryed to re-installe it 100 of times now. and i am sure i have done the other thing to..
I dont know what i shall do, but i am sure you have been out for this some time before.
Please answer me on this: Thanks!

First uninstall MySQL 5.0. Now go to Programs/Program Files\MySQL\ and delete everything inside there.
2: Install MySQL again, and when you shall configure you server try this:
[Code]
First MySQL Server Instance Config Wizard and sey Remove Instance. Now reinstall MySQL 5.0.
Then after install, configure your MySQL server, Standart Configuretion. Now. Try call the MySQL box to something else. There are: MySQL, MySQL 4, MySQL 4.1, MySQL 5 and MySQL 5,1. If it fail with MySQL try a other one, after remove instance.

[Djfrederick]

Okay, i will try that

Are you going to stay online for awhile. So i maybe could get in contact with you?

[Lukas 45]

Okay, i will try that

Are you going to stay online for awhile. So i maybe could get in contact with you?

oki
I will be online for some time

[Djfrederick]

I just need some help, are you there?

[Djfrederick]

Is it a 2.4.3 server?
And what shall i do when i keep standing at 'Handshaking'

[Lukas 45]

Is it a 2.4.3 server?
And what shall i do when i keep standing at 'Handshaking'

If your are stuck at Handshaking its means there is something wrong with the server. The CONF files i think. Please send your config(CONF) files is a code here. But i can hear you got your MySQL working Do you got Executed Batch File world.sql to Navicat/SQLyog? and have you start ArcEmu World and ArcEmu Logonserver. Remeber to start Logonserver first, and wait to it says: success! Reade for connection. And make sure that ArcEmu World says at the last: Registread realm 1 "<Your realm name here>"

[mrnicknily]

How i download this repack???????????????????????????????????????????????????????????????????

[mrnicknily]

i can find Mysql to run

[Djfrederick]

Okay i will send them to you Lukas-45

[Djfrederick]

If your are stuck at Handshaking its means there is something wrong with the server. The CONF files i think. Please send your config(CONF) files is a code here. But i can hear you got your MySQL working Do you got Executed Batch File world.sql to Navicat/SQLyog? and have you start ArcEmu World and ArcEmu Logonserver. Remeber to start Logonserver first, and wait to it says: success! Reade for connection. And make sure that ArcEmu World says at the last: Registread realm 1 "<Your realm name here>"

Okay ill try send the CONF to you her:

LOGONSERVER.CONF:

#######################################################################
# Ascent Realms Configuration File
# Last updated at revision 446 by Burlex
#######################################################################

/********************************************************************************
* How to use this config file: *
* Config files are in a block->variable->setting format. *
* A < signifies the opening of a block, the block name is expected after that. *
* After the block name, a space and then the settings sperated by = / ' '. *
* *
* e.g. *
* <block setting="0" someval = "1"> *
* *
* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
* of the line, or in shell format (#). *
********************************************************************************/

# LogonDatabase Section
#
# These directives are the location of the `realms` and `accounts`
# tables.
#
# LogonDatabase.Host - The hostname that the database is located on
# LogonDatabase.Username - The username used for the mysql connection
# LogonDatabase.Password - The password used for the mysql connection
# LogonDatabase.Name - The database name
# LogonDatabase.Port - Port that MySQL listens on. Usually 3306.
# LogonDatabase.Type - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#

<LogonDatabase Hostname = "127.0.0.1"
Username = "root"
Password = "root"
Name = "spdb"
Port = "3306"
Type = "1">

# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#

<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">

# Server console logging level
#
# This directive controls how much output the server will
# display in it's console. Set to 0 for none.
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#

<LogLevel Screen = "0"
File = "-1">

# Account Refresh Time
#
# This controls on which time interval accounts gets
# refreshed. (In seconds)
# Default = 600
#

<Rates AccountRefresh = "600">

# Accepted Build Range Setup
#
# These two directives set up which clients will be
# allowed to authenticate with the realm list.
#
# Set these to the same builds that the server was
# compiled for.
#
# As of the last update, version 2.1.1 was build 6739.
#

<Client MinBuild = "6739"
MaxBuild = "9999">

# WorldServer Setup
#
# This directive controls the password used to authenticate with the worldserver.
# It must be the same between the two configs. If it is not, your server will
# not register.
#
# Default: "change_me_logon"
#

<LogonServer RemotePassword = "logon">

THE REALM.CONF:

#######################################################################

/********************************************************************************
* How to use this config file: *
* Config files are in a block->variable->setting format. *
* A < signifies the opening of a block, the block name is expected after that. *
* After the block name, a space and then the settings sperated by = / ' '. *
* *
* e.g. *
* <block setting="0" someval = "1"> *
* *
* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
* of the line, or in shell format (#). *
********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
# Address:
# The address (no port) of the server.
#
# Port:
# The port on which the logon server listens. (*** NOT 3724 ***)
#
# Name:
# Not really relavant, but name the logon.
#
# RealmCount:
# The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer Address = "127.0.0.1"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
# Name:
# The name of the realm.
#
# Address:
# The address (and port) of that realm.
#
# Icon:
# The type of realm (PVP, Normal, RPPVP, RP)
#
# Colour:
# Realm colour in realm list display.
#
# TimeZone:
# Time zone the realm is in.
#
# Population:
# (0 = low, 1 = medium, 2 = high)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "WoWGeek PVP"
Address = "127.0.0.1:8129"
Icon = "Normal"
Colour = "1"
Population = "1.0"
TimeZone = "1">

THE WORLD.CONF:

#######################################################################
# Ascent Configuration File
# Last Update: $Id: ascent-world.conf 3549 2008-01-28 15:30:08Z burlex $
#######################################################################

/********************************************************************************
* How to use this config file: *
* Config files are in a block->variable->setting format. *
* A < signifies the opening of a block, the block name is expected after that. *
* After the block name, a space and then the settings sperated by = / ' '. *
* *
* e.g. *
* <block setting="0" someval = "1"> *
* *
* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
* of the line, or in shell format (#). *
********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
# Database.Host - The hostname that the database is located on
# Database.Username - The username used for the mysql connection
# Database.Password - The password used for the mysql connection
# Database.Name - The database name
# Database.Port - Port that MySQL listens on. Usually 3306.
# Database.Type - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "127.0.0.1"
Username = "root"
Password = "root"
Name = "spdb"
Port = "3306"
Type = "1">

<CharacterDatabase Hostname = "127.0.0.1"
Username = "root"
Password = "root"
Name = "spdb"
Port = "3306"
Type = "1">>


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
# Host
# This is the address that the server will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# WorldServerPort
# This is the port that the world server listens on.
# It has to be the same as what is specified in the
# realms table in the LogonDatabase.
# Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
WorldServerPort = "8129">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#


There you go Good luck!