Logon-Server Problem

[NonstopXtrmn8r]

Ok, so i have gotten everything to work with my server... except for the accounts, i try to log onto my server and, i start up wow, and then i type in the account info, press enter, and it says, you know, wrong account info, you know what i am talking about, anyways, i think that i have found the problem i will post a picture here, i think my logon-server.conf is wrong, it gives me this message when i run it,



it says something about an unknown column, i dont know what is going wrong, please help me. And when i try to reload the accounts from this cmd, it does the same thing, i will post the ascent-logonserver.conf here


#######################################################################
# 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 = "localhost"
Username = "root"
Password = "ascent"
Name = "ascent"
Port = "3306"
Type = "1">

# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#
<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">
# Server console logging level
#
# This directive controls how much output the server will
# display in it's console. Set to 0 for none.
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#
<LogLevel Screen = "0"
File = "-1">
# Account Refresh Time
#
# This controls on which time interval accounts gets
# refreshed. (In seconds)
# Default = 600
#
<Rates AccountRefresh = "600">
# Accepted Build Range Setup
#
# These two directives set up which clients will be
# allowed to authenticate with the realm list.
#
# Set these to the same builds that the server was
# compiled for.
#
# As of the last update, version 2.1.1 was build 6739.
#
<Client MinBuild = "8125"
MaxBuild = "8125">
# WorldServer Setup
#
# This directive controls the password used to authenticate with the worldserver.
# It must be the same between the two configs. If it is not, your server will
# not register.
#
# Default: "change_me_logon"
#
<LogonServer RemotePassword = "ascent">



what did i do wrong??? Please help me, thank you!

[CairiFEA]

Easy fix, I will assume you are using navicat since it's awesome.


1) Go into your Logon data base
2) right click on Accounts
3) Select 'Design Table'
4) Go down the the bottom of the list of entries, (`forced language`) Select it.
5) Press the DOWN arrow key, this will create a new entry.
6) Name it muted
7) Type = Int
Length = 30
9) Decimals = 0
10) Leave 'Allow Null" unchecked.

Default should be set to 0, click the X, save.

Hope this helps,
+Rep

[NonstopXtrmn8r]

what now? it didn't work, here is a pic




please help, i really need to get this server running

ps- was i supposed to disconnect from the navicat server, then re-connect so that the changes could take effect? Please help, thank you!

[CairiFEA]

lol, alright this is what it should look like.

You deleted the Forcedlang table when you created te Muted tables.






Cairi,

And no, you dont need to disconnect. Once you edit the table and save it, just restart your server to see the error disappear.

[CairiFEA]

Oh yeah and here is the info you put into the ForceLanguages table,

[NonstopXtrmn8r]

Oh yeah and here is the info you put into the ForceLanguages table,

Thank you sooooo much, also, i was wondering about the defaults and the other stuff, it works now, thank you, if i make anything in donations for this server, i will give you the first one, thank you!

[CairiFEA]

Just glad I could help

For now I wouldn't start messing with defaul values until you get more comfortable with your database and server.


But, a fun default value is always the Flags, put it to 8; that enables TBC for all accounts.

Cairi

[NonstopXtrmn8r]

Just glad I could help

For now I wouldn't start messing with defaul values until you get more comfortable with your database and server.


But, a fun default value is always the Flags, put it to 8; that enables TBC for all accounts.

Cairi

Look at my new topic, i need some more help, lol!

[latruwski]

just sideinfo: you should check the ascent SVN and revision updates... sometimes the DB structure needs updates (this problem was one of them)

[love236]

If someone really could help me i would be glad. Here's the problem i make a server and i make it online with hamachi everything works great but but buttttttt when someone try to log in with a char on my server they get dc only they but i dont get dc if i try do log in so please tell me the prob i really want this soooo much. :SSS

[love236]

If someone really could help me i would be glad. Here's the problem i make a server and i make it online with hamachi everything works great but but buttttttt when someone try to log in with a char on my server they get dc only they but i dont get dc if i try do log in so please tell me the prob i really want this soooo much. :SSSS

[TheSpidey]

It's a conf problem. Make a new topic, include your confs in code tags, and you'll be helped.

[Lich King]

Love236, stop posting that everywhere!! If you want help just make a thread

[love236]

If someone really could help me i would be glad. Here's the problem i make a server and i make it online with hamachi everything works great but but buttttttt when someone try to log in with a char on my server they get dc only they but i dont get dc if i try do log in so please tell me the prob i really want this soooo much. :SSS

[TheSpidey]

love236 - post on a new thread.