[Guide]Easy Server Creation/Makeing Public.

[revid]

where do i find root @ localhost?

[litoaznboi]

Okay when I try to SQL dump import it says this error message:
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:52:07
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:52:55
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:53:07
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:53:11
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

[litoaznboi]

Scratch that, got past that part. Okay Now I'm on Hamachi and set everything to my Hamachi IP everything looks good. The logonserver.exe working fine and the antrix.exe working perfect. I go to WoW and I type in information that I wanted on the SQLyog and then it connects then stops on Handshaking. Any help would be appreciated for this issue.

[Knightsend]

well i got everyhing nice and working except 1 thing, when i go to run Antrix.exe it says
Loading conf files
>> antrix.conf: Ok!
>> realms.conf: Unterminated Block.
Fail.


what do i do to change that?

[DarkFever]

well i got everyhing nice and working except 1 thing, when i go to run Antrix.exe it says
Loading conf files
>> antrix.conf: Ok!
>> realms.conf: Unterminated Block.
Fail.


what do i do to change that?

You put a "/" somwhere in the folder like your server name or somthing
If its just for you not public

put this in there...just change the stuff in red

#######################################################################
# Antrix 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 (#).                                         *
 ********************************************************************************/
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
#    Address:
#        The address (no port) of the server.
#
#    Port:
#        The port on which the logon server listens. (*** NOT 3724 ***)
#
#    Name:
#        Not really relavant, but name the logon.
#
#    RealmCount:
#        The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<LogonServer Address = "127.0.0.1"
             Port = "8093"
             Name = "Default Logon"
             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 = "Your Realm Name Here"
        Address = "127.0.0.1:8129"
        Icon = "PVP"
        Colour = "1"
        Population = "1.0"
        TimeZone = "1">

If its for public change the stuff in Blue

#######################################################################
# Antrix 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 (#).                                         *
 ********************************************************************************/
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
#    Address:
#        The address (no port) of the server.
#
#    Port:
#        The port on which the logon server listens. (*** NOT 3724 ***)
#
#    Name:
#        Not really relavant, but name the logon.
#
#    RealmCount:
#        The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<LogonServer Address = "Hamachi Ip Here"
             Port = "8093"
             Name = "Default Logon"
             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 = "Your Realm Name Here"
        Address = "Hamachi Ip Here:8129"
        Icon = "PVP"
        Colour = "1"
        Population = "1.0"
        TimeZone = "1">

If its still not working copy one of these and just change the stuff between them

[DarkFever]

Okay when I try to SQL dump import it says this error message:
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:52:07
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:52:55
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:53:07
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-18 21:53:11
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Reload the DB by right clicking it and then click drop it then make a new one name it Antrix and re exacute

[DarkFever]

hope everyone enjoys my repack and the server party like hell


remeber if you cant make your own you can still play on mine

Master Outcast

[PyroManiac606]

Great Guide, ive had my server up for a wile and i noticed that there are alot of items missing. like swords,staffs,ect any patch for that or what should i do?

[Mitchy]

I know it says I am a Site n00b, im not a noob, just new to mmowned.com

I have created the server, everything correct, hamachi up BUT
with hamachi in none of the guides nobody says where to find the "hamachi IP"
is it the big one at the top of the hamachi box? or it is external IP? internal IP?

great guide btw, whish I could give you rep, imworking on getting our of lazy leachers group

thanks, jsut one simple question. =)

[DarkFever]

I know it says I am a Site n00b, im not a noob, just new to mmowned.com

I have created the server, everything correct, hamachi up BUT
with hamachi in none of the guides nobody says where to find the "hamachi IP"
is it the big one at the top of the hamachi box? or it is external IP? internal IP?

great guide btw, whish I could give you rep, imworking on getting our of lazy leachers group

thanks, jsut one simple question. =)

When ya open Hamachi then IP is the numbers on top of the

[elmador]

I alwase have this kinda trouble when im making a server ><

When im trying to start antrix.exe it opens and then it says:

Loading Config Files...
>> antrix.conf :: ok!
>> realms.conf :: Unterminated Block.
Fail.


and then the program closes

Edit: I messed a bit with the realm file and got overthat part.. but now i got the same problem as Gprime10

I got the same problem but my logonserver.exe doesn't work either I get his message.

>> Starting: thread manager...sql: Logon database parameters not found.

[pavis]

work with 2.3?

[jarryd1171]

well i've used nearly all guides on ascent/mangos so im trying yours, looks easy to understand D/loading the stuff now, hope i can +Rep yea

[jarryd1171]

OK, now ive came up with my first problem.... its the same thing itoaznboi had, but i dunno how to get past it .... its Sez SQL Dump import error and then this appears Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-25 09:16:29
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-25 09:16:34
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-25 09:17:11
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-25 09:17:29
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-25 09:17:49
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-11-25 09:20:42
Line no.:26
Error Code: 1050 - Table 'accounts' already exists


Please help me

[funkygorilla]

I got everything but it just stays on success! when i enter everytihing?!?