Ascent 2.3.3+ Server Setup With Pics

[Hess]

but how and where can i update it there are no files included for it and please poeple dont use MySQL 5.0 use MySQL 4.1 is better mayby a little old but it still works better than MySQL 5.0 is full of bugs and unfinished stuff

[Spartansp]

well there ARE updates included they are (already told before like 10000000000000000000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000) times before that they are in

Ascent3353/SQL/

please before typing something make 100% you are sure... cause this proves me that you didnt read all pages of this guide...

[Hess]

yes i believe you but still ik get the error the first that whas the mailbox now this so i will look for it

[Hess]

still i get the error from banned_names still dont no how to fix it i tryed what you said spartansp but still dont work

[wondoman]

Great guide Victory...a pointer for your next guides
(for your images) when you Ctr+V them into paint
size em down so you dont have the big white part on it.
other than that awsome!

[Magerockslol]

AH! Whenever I open logonserver.exe it shows an error then closes in 0.05 milliseconds lol. Ascent.exe is ok but the logonserver is screwed.

Logonserver

********************************************************************************/

# 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 = "root"
Name = "ascentlogon""
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 = "6739"
MaxBuild = "9999">

# 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">

This is my ascent thing if you need that too

<WorldDatabase Hostname = "127.0.0.1" Username = "root" Password = "root" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "root" Name = "ascentlogon" Port = "3306" Type = "1">

AND realms

<LogonServer Address = "127.0.0.1"
Port = "8093"
Name = "ascentlogon"
RealmCount = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
# Name:
# The name of the realm.
#
# Address:
# The address (and port) of that realm.
#
# Icon:
# The type of realm (PVP, Normal, RPPVP, RP)
#
# Colour:
# Realm colour in realm list display.
#
# TimeZone:
# Time zone the realm is in.
#
# Population:
# (0 = low, 1 = medium, 2 = high)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "(My wow server name)"
Address = "127.0.0.1:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

can anyone help?

[Nallman]

This database is not uploading into the sql properly, it gets to about 60kb then it quits... does anyone else have this problem?

[redhat]

i load the things up all fine i pick the realm but then it stays at connected and does not go into the realm i get this Sql query failed due to [Table 'ascentlogon.mailbox_insert_queue' doesn't exist], query: [SELECT * FROM mailbox_insert_queue]

[Spartansp]

yes i believe you but still ik get the error the first that whas the mailbox now this so i will look for it

its on the SQL folder... DAMN NOW IM SO PISSED OF here is a F*** link to the SQL Download it on atachment 1

still i get the error from banned_names still dont no how to fix it i tryed what you said spartansp but still dont work

DAMN ANOTHER SQL MORE....attachment 2

AH! Whenever I open logonserver.exe it shows an error then closes in 0.05 milliseconds lol.

already replied in the other thread

This database is not uploading into the sql properly, it gets to about 60kb then it quits... does anyone else have this problem?

No no one having this problem you should check your database manager...

i load the things up all fine i pick the realm but then it stays at connected and does not go into the realm i get this Sql query failed due to [Table 'ascentlogon.mailbox_insert_queue' doesn't exist], query: [SELECT * FROM mailbox_insert_queue]

DAMN 1 MORE TIME JUST EXECUTE BATCH FILE OF THIS!!!!
atachment1

[Joker zero]

When I do step 9 it says this

[Err] 1050 - Table 'account_data' already exists
[Err] -- ----------------------------
-- Table structure for account_data
-- ----------------------------
CREATE TABLE `account_data` (
  `acct` int(30) NOT NULL,
  `uiconfig0` blob,
  `uiconfig1` blob,
  `uiconfig2` blob,
  `uiconfig3` blob,
  `uiconfig4` blob,
  `uiconfig5` blob,
  `uiconfig6` blob,
  `uiconfig7` blob,
  `uiconfig8` blob,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `a` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Cun]

Awesome, how do I get this online?

[Spartansp]

to make it online first you must forward ports, then you need to go into dyndns or no-ip.com and make a dynamic ip there... after done with that you need to go into your windows/drivers/etc folder and edit with notepad the file named hosts and add the following
127.0.0.1 localhost
publicip Dynamicdns
to get public ip type on google whats my ip and the one that appears is your publicip ta da
configure realms.conf so it connects you to your dyndns and youre ready

[Cun]

Ok, I have a no-ip account
I've done the windows/drivers/etc thing
How do I configue realms.conf?

[Spartansp]

<Realm1 Name = "SPDB"
Address = "YourDNS:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

[nether drake]

Great , good job