Welcome to AC Web.
Results 1 to 7 of 7
  1. #1

    Exclamation Jeuties repack - SQL and startup errors


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    When i start MySQL Server it works fine. But when i open my authserver it says:

    2012-07-07 02:50:15 TrinityCore rev. 2012-06-28 22:37:43 -0700 (799b2c146ba5) (Win32, Release) (authserver)
    2012-07-07 02:50:15 <Ctrl-C> to stop.

    2012-07-07 02:50:15 Using configuration file authserver.conf.
    2012-07-07 02:50:15 Max allowed open files is 1024
    2012-07-07 02:50:15 ERROR: Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

    2012-07-07 02:50:15 ERROR: Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

    2012-07-07 02:50:15 ERROR: DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
    2012-07-07 02:50:15 ERROR: Cannot connect to database

    And the same happens to the worldserver:

    2012-07-07 03:04:35 http://TrinityCore.org \/__/

    2012-07-07 03:04:35 ERROR: Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

    2012-07-07 03:04:35 ERROR: Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

    2012-07-07 03:04:35 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
    2012-07-07 03:04:35 ERROR: Cannot connect to world database 127.0.0.1;3306;root;ascent;world

    And it tells me to check my SQLDriverLogFile, and in it it says:

    2012-07-06 22:13:49 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:02 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:02 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:03 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:03 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:03 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:03 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
    2012-07-06 22:14:04 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

    A loads of those is in it.
    I was wondering if anyone could help me to fix this so i could play on my very own (trinity) server

    Skype: emil.mahe (if you want to contact me on skype)

  2. #2
    emudevs.com

    Join Date
    Feb 2011
    Location
    C++ Developer
    Posts
    2,832
    Did you put in the right info in the config files for your mysql username and pass?

  3. #3
    maybe u did some changes in your worldserver.conf or did some changes in your database

  4. #4
    I just downloaded the repack, so i haven't touched anything :O

  5. #5


    Join Date
    Nov 2011
    Location
    Repack Developer, In-Game Builder, Lua Scripter, C++ Scripter
    Posts
    1,137
    user: root
    pass: ascent

    like this

    LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"
    and on world.config file this:

    LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"
    WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world"
    CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"

  6. #6
    Warfrost, i got both of them in the right place. This is what authserver says:

    MYSQL SETTINGS
    #
    # LoginDatabaseInfo
    # Description: Database connection settings for the realm server.
    # Example: "hostname;port;username;password;database"
    # ".;somenumber;username;password;database" - (Use named pipes on Windows
    # "enable-named-pipe" to [mysqld]
    # section my.ini)
    # ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
    # Unix/Linux)
    # Default: "127.0.0.1;3306;trinity;trinity;auth"

    LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"

    #
    # LoginDatabase.WorkerThreads
    # Description: The amount of worker threads spawned to handle asynchronous (delayed) MySQL
    # statements. Each worker thread is mirrored with its own connection to the
    # Default: 1

    And this is what the worldserver says:


    # LoginDatabaseInfo
    # WorldDatabaseInfo
    # CharacterDatabaseInfo
    # Description: Database connection settings for the world server.
    # Example: "hostname;port;username;password;database"
    # ".;somenumber;username;password;database" - (Use named pipes on Windows
    # "enable-named-pipe" to [mysqld]
    # section my.ini)
    # ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
    # Unix/Linux)
    # Default: "127.0.0.1;3306;trinity;trinity;auth" - (LoginDatabaseInfo)
    # "127.0.0.1;3306;trinity;trinity;world" - (WorldDatabaseInfo)
    # "127.0.0.1;3306;trinity;trinity;characters" - (CharacterDatabaseInfo)

    LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"
    WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world"
    CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"

    #
    # LoginDatabase.WorkerThreads
    # WorldDatabase.WorkerThreads
    # CharacterDatabase.WorkerThreads
    # Description: The amount of worker threads spawned to handle asynchronous (delayed) MySQL
    # statements. Each worker thread is mirrored with its own connection to the
    # MySQL server and their own thread on the MySQL server.
    # Default: 1 - (LoginDatabase.WorkerThreads)
    # 1 - (WorldDatabase.WorkerThreads)
    # 1 - (CharacterDatabase.WorkerThreads)

    LoginDatabase.WorkerThreads = 1
    WorldDatabase.WorkerThreads = 1
    CharacterDatabase.WorkerThreads = 1

    #
    # LoginDatabase.SynchThreads
    # WorldDatabase.SynchThreads
    # CharacterDatabase.SynchThreads
    # Description: The amount of MySQL connections spawned to handle.
    # Default: 1 - (LoginDatabase.WorkerThreads)
    # 1 - (WorldDatabase.WorkerThreads)
    # 2 - (CharacterDatabase.WorkerThreads)

    LoginDatabase.SynchThreads = 1
    WorldDatabase.SynchThreads = 1
    CharacterDatabase.SynchThreads = 2

    Just wondering if it is anything wrong in these two..

    I got my server up and running now This thread is closet.

  7. #7

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    how did you do it because i have same exact error and i cant evan Open heidsql

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •