Mysql errors for howling repack( very detailed)

[snowbird]

one of the errors you might recive is that there is a port already running on 3306
this is a very easy error how fix

first go to your repack folder
there should be 3 files
*ascent
*server
*stuff

go into the server folder there should be files like

*cysystem(file)
*xxamp(file)
*apache_start
*apache_stop
*mysql
*mysql_stop.bat

open the cysystem folder
there should be another file in there called
*mysql
open that up

then there are 5 more files in there
*backup
*data
*tmp
*bin
*share

open the bin folder
there are many files in there called but you only need one
the mysql configuration file

when you open that up it will look like this

[client]
port = 3306
socket = mysql
[mysqld]
basedir="cystem\mysql"
tmpdir="../tmp"
datadir="data"
port = 3306
socket = mysql
old-passwords

max_connections=100
thread_concurrency = 8
skip-locking
skip-external-locking
default_table_type=InnoDB
key_buffer = 20M
max_allowed_packet = 25M
table_cache = 800
sort_buffer_size = 1024K
net_buffer_length = 512K
read_buffer_size = 1024K
read_rnd_buffer_size = 1024K
myisam_sort_buffer_size = 8M
set-variable = max_connections=300
set-variable = max_connect_errors=65535
set-variable = max_user_connections=350
set-variable = table_cache=800
set-variable = sort_buffer=2M
set-variable = join_buffer_size=1M
set-variable = record_buffer=2M
set-variable = myisam_sort_buffer_size=8M
set-variable = wait_timeout=14400
set-variable = thread_cache_size=1024
set-variable = back_log=512
set-variable = connect_timeout=30
set-variable = tmp_table_size=10M
set-variable = query_cache_size=16M
set-variable = max_allowed_packet=32M
set-variable = innodb_file_io_threads=4
default-character-set=utf8
#default-collation=utf8_czech_ci
max_heap_table_size = 96000000
long-query-time = 1
innodb_file_per_table
innodb_thread_concurrency=8
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size = 10M
innodb_additional_mem_pool_size = 20M
innodb_autoextend_increment = 8
innodb_log_buffer_size = 10M
innodb_log_file_size=10M
innodb_open_files = 500
innodb_table_locks=0
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#innodb_flush_method=O_DSYNC

[mysqld_safe]
open-files-limit=7000

[mysql]
no-auto-rehash

[mysqldump]
quick
max_allowed_packet = 64M

[isamchk]
key_buffer = 16M
sort_buffer_size = 16M
read_buffer = 6M
write_buffer = 6M

[myisamchk]
key_buffer = 16M
sort_buffer_size = 16M
read_buffer = 6M
write_buffer = 6M

[mysqlhotcopy]
interactive-timeout

notice how the ports are set to 3306 we neeed to change that to 4337 it is done like this


[client]
port = 3306
socket = mysql
[mysqld]
basedir="cystem\mysql"
tmpdir="../tmp"
datadir="data" <---------Before
port = 3306
socket = mysql
old-passwords




[client]
port = 4337
socket = mysql
[mysqld]
basedir="cystem\mysql"
tmpdir="../tmp" <-------After
datadir="data"
port = 4337
socket = mysql
old-passwords

ok once you have done that
close out of that and save it and remeber to save it

once you have saved it go back to all your original files the
ascent
stuff
server

then open up ascent and open up the file
*ascent-logonserver.config

it should look like this

#######################################################################
# 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 = "1.111.11.1" (ones are just an example)
Username = "root"
Password = "ascent"
Name = "logon"
Port = "3306"
Type = "1">


that is wat it looks like now we have to change the port

#######################################################################
# 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 = "5.223.27.88"
Username = "root"
Password = "ascent"
Name = "logon"
Port = "4337"
Type = "1">


once you have changed that save that and go back to the repack

open up
*ascent-world.config
it should look like this

#######################################################################
# Ascent Configuration File
# Last Update: $Id: ascent-world.conf 4090 2008-03-03 16:22:26Z emsy $
#######################################################################

/********************************************************************************
* 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 = "5.223.27.88" Username = "root" Password = "ascent" Name = "fun" Port = "6221" Type = "1">
<CharacterDatabase Hostname = "5.223.27.88" Username = "root" Password = "ascent" Name = "logon" Port = "6221" Type = "1">


see the ports and the addresses
change the ports to 4337 like this

#######################################################################
# Ascent Configuration File
# Last Update: $Id: ascent-world.conf 4090 2008-03-03 16:22:26Z emsy $
#######################################################################

/********************************************************************************
* 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 = "5.223.27.88" Username = "root" Password = "ascent" Name = "fun" Port = "4337" Type = "1">
<CharacterDatabase Hostname = "5.223.27.88" Username = "root" Password = "ascent" Name = "logon" Port = "4337" Type = "1">

once you have done that save that then open the run files in this order

mysql
ascent logonserver
ascent world


Here is another error you might get
you dont have permission to get into mysql
you have to enter you DB and make an account for you

enter you DB then click on the tab that says add account or something like that
enter your info
then give you all the stuff
then save
and then try mysql should work then

if you need more help just leave a comment saying wats wrong and i will help as much as possible