Herleybob - Ascent 2.3.0 Server Setup

[sadgonewild]

hi guys, my server is running perfectly, but two races are missing, the bottom ones on the alliance and horde, any help would be appriciated

when you make your account in the database,

go into ur accouts table and set the flag to " 8"

that will fix it.

that there allows burning crusade.

[ChaosTheoryX]

thank you so much

[monabrine]

i am haveing a bit of a problem with the loging in part i went and made the account on mysql-accounts-accounts and i tried to log in and it said wrong user name and or password can anyone help me?

[monabrine]

ok now when i try to log on it stops at authenticating or disconnected from server

[spelly]

I`ve got a tiny little problem with my database.
When i add the database names Accounts, i cant find it again, when i try to make a new one, a error message comes that showes: The account database already exist.
What can i do to find mah account database ?

/bump

This is the only problem i got, and the only thing that is holding me back from getting the server up.


/thanks

[Mahona]

Quote:
Originally Posted by Mahona
It doesnt work!!!!!!!!!!!! sorry for dbl pst.... help!

there is a typo in guide here is fix :
logonserver.conf :
<LogonDatabase Hostname = "127.0.0.1"
Username = "root"
Password = "password"
Name = "accounts"
Port = "3306"
Type = "1">

that's it, change password part and server works! i am IMBA

lol thanks a lot... just hope it works this time!!!!

[shane306]

does anyone have any guides on how to make your server good and make a mall and all that?

[Soccerfool54]

Hey. I really liked your guide. It seemed really easy for me to follow but i also have expoerience with the MaNGOS as well and i like this one better so far becasue the updates are better and their are less programs to download and run. All i need is a guide to make it run constantly from a seperate comp so i can make a reall server and one thats not just my comp network but a public server that i can let others join by using a web site. I dont know if ive seen a guide to do this but i would enjoy it alot. So once again more plainly i just need a guide that says how to set your server up to be public for others, how to make a website, and send the data to your server to make other peoples accounts like the sites from top 100 wow server place. Thank you. I look forward to playing you online

[Soccerfool54]

Hey. I really liked your guide. It seemed really easy for me to follow but i also have expoerience with the MaNGOS as well and i like this one better so far becasue the updates are better and their are less programs to download and run. All i need is a guide to make it run constantly from a seperate comp so i can make a reall server and one thats not just my comp network but a public server that i can let others join by using a web site. I dont know if ive seen a guide to do this but i would enjoy it alot. So once again more plainly i just need a guide that says how to set your server up to be public for others, how to make a website, and send the data to your server to make other peoples accounts like the sites from top 100 wow server place. Thank you. I look forward to playing you online

[Verious]

GREAT REPACK!!! works good, thanks!

[monabrine]

hey im haveing problems loging in it either says wrong pass or name or it says ive been disconnected from server and sometimes it just freezes at authenticating please help me

[mantorkel]

error 1007
cant create databse "ascent" already exists :S

[monabrine]

ok i started logonserver and ascent and the logon server looks like this:

Hooking signals...
Authentication request from 127.0.0.1, result OK.
Key: 8B3598E6126C72C880D2F44DA10CFE0773804591
Registering realm `hellsnightmare` under ID 1.
10:57 D ThreadPool: IntegrityCheck: (gobbled < 0) Spawning 6 threads.
10:57 D ThreadPool: Thread 4852 entered the free pool.
10:57 D ThreadPool: Thread 5616 entered the free pool.
10:57 D ThreadPool: Thread 5652 entered the free pool.
10:57 D ThreadPool: Thread 4636 entered the free pool.
10:57 D ThreadPool: Thread 4272 entered the free pool.
10:57 D ThreadPool: Thread 4868 entered the free pool.
10:59 D ThreadPool: Killing 1 excess threads.
10:59 D ThreadPool: IntegrityCheck: (gobbled > 5) Killing 1 threads.
10:59 D ThreadPool: Thread 4852 exiting.
11:01 D ThreadPool: IntegrityCheck: Perfect!
11:03 D ThreadPool: IntegrityCheck: Perfect!
Sql query failed due to [Table 'ascent.accounts' doesn't exist], Query: [SELECT
acct, login, password, gm, flags, banned, forceLanguage FROM accounts]
Sql query failed due to [Table 'ascent.ipbans' doesn't exist], Query: [SELECT ip
, expire FROM ipbans]
11:05 D ThreadPool: IntegrityCheck: Perfect!
11:08 D ThreadPool: IntegrityCheck: Perfect!
11:11 D ThreadPool: IntegrityCheck: Perfect!
11:14 D ThreadPool: IntegrityCheck: Perfect!
Sql query failed due to [Table 'ascent.accounts' doesn't exist], Query: [SELECT
acct, login, password, gm, flags, banned, forceLanguage FROM accounts]
Sql query failed due to [Table 'ascent.ipbans' doesn't exist], Query: [SELECT ip
, expire FROM ipbans]
11:17 D ThreadPool: IntegrityCheck: Perfect!
11:20 D ThreadPool: IntegrityCheck: Perfect!
11:23 D ThreadPool: IntegrityCheck: Perfect!
Sql query failed due to [Table 'ascent.accounts' doesn't exist], Query: [SELECT
acct, login, password, gm, flags, banned, forceLanguage FROM accounts]
Sql query failed due to [Table 'ascent.ipbans' doesn't exist], Query: [SELECT ip
, expire FROM ipbans]
11:26 D ThreadPool: IntegrityCheck: Perfect!
11:28 D ThreadPool: IntegrityCheck: Perfect!
11:30 D ThreadPool: IntegrityCheck: Perfect!
11:32 D ThreadPool: IntegrityCheck: Perfect!
11:35 D ThreadPool: IntegrityCheck: Perfect!
Sql query failed due to [Table 'ascent.accounts' doesn't exist], Query: [SELECT
acct, login, password, gm, flags, banned, forceLanguage FROM accounts]
Sql query failed due to [Table 'ascent.ipbans' doesn't exist], Query: [SELECT ip
, expire FROM ipbans]

and my ascent program looks like this
Server is ready for connections. Startup time: 29515ms
10:56 N LogonCommClient: Attempting to connect to logon server...
10:56 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
10:56 N LogonCommClient: Authenticating...
10:56 N LogonCommClient: Authentication succeeded.
10:56 N LogonCommClient: Registering Realms...
10:56 N LogonCommClient: Realm `hellsnightmare` registered as realm 1.
Sql query failed due to [Table 'ascent.characters' doesn't exist], Query: [SELEC
T acct FROM characters]
10:56 N LogonCommClient: Logonserver latency is 0ms.
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_honor_update_time", 1196268974)]
Sql query failed due to [Table 'ascent.server_settings' doesn't exist], Query: [
REPLACE INTO server_settings VALUES("last_arena_update_time", 1196268974)]

but it will stick at authenticating or say disconnected from server

[mantorkel]

aha.. now i did everything and when ascent.exe is running.. it keeps saying authenticating.... authenticating failed..

and so on ..

if i try to log on it says the info i entered is not right etc (have changed my realmlist)

[stevewg95]

I got that too go to your ascent.conf file and make sure it is like this but with your password.

<WorldDatabase Hostname = "127.0.0.1" Username = "root" Password = "Yourpass" Name = "Ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "Yourpass" Name = "Accounts" Port = "3306" Type = "1">

and in your logonserver.conf make sure it is like this with your password

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

I think that may fix it if not well at least I tried