MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides

Homepage Register FAQ Members Mark Forums Read Advertise Marketplace FPSowned


Go Back   MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides > WoW Emulator Server > Emulator Server Guides
Reload this Page Mysql errors for howling repack( very detailed)
Emulator Server Guides Guides for working with World of Warcraft Emulator servers. Learn how to create a WoW Server here.
[NO QUESTIONS HERE]

Reply
 
LinkBack Thread Tools
Mysql errors for howling repack( very detailed)
(#1)
Old
snowbird's Avatar
snowbird is Offline
Master Sergeant
Rep Power: 1
Reputation: 15
snowbird is on a distinguished road
 
Posts: 121
Join Date: May 2008
Location: Toledo Ohio
Legendary Mysql errors for howling repack( very detailed) - 07-11-2008

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
Reply With Quote

Donate to remove ads.
Reply

Donate to remove ads.

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On



Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344