Mysql errors for howling repack( very detailed) menu

These ads disappear when you log in.

Results 1 to 1 of 1
  1. #1
    snowbird's Avatar Master Sergeant
    Reputation
    15
    Join Date
    May 2008
    Posts
    125
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Mysql errors for howling repack( very detailed)

    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

    These ads disappear when you log in.

Similar Threads

  1. [MySQL] a Server folder for my repack?
    By davidknag in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 03-14-2010, 11:39 AM
  2. MySQL Error for website
    By iterrorist in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 04-06-2009, 01:29 PM
  3. how to fix your mysql when it buges beyond no repair this covers all errors for mysql
    By project anthrax in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 07-15-2008, 11:55 PM
  4. Replies: 2
    Last Post: 11-14-2007, 08:20 PM
  5. Mysql error & Phpmyadmin
    By msnad9833 in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 10-02-2007, 08:17 PM
All times are GMT -5. The time now is 09:28 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search