What's the reason for this?

[Deathtonoobs]

i get a crash on logonserver.exe and antrix.exe keeps looping on a failed connection.

*************logonserver.conf***************
LogonDatabase.Hostname = localhost
LogonDatabase.Username = root
LogonDatabase.Password = ********
LogonDatabase.Name = antrix
LogonDatabase.Port = 3306
LogonDatabase.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)
#

Host = localhost

**************Antrix.conf************
Database.Hostname = localhost
Database.Username = root
Database.Password = ************
Database.Name = antrix
Database.Port = 3306
Database.Type = 1


# Host Directive
#
# This is the address that the server will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#

Host = localhost

********realms.conf*******
LogonServerCount = 1

LogonServer1.Address = "127.0.0.1"
LogonServer1.Port = 8093
LogonServer1.Name = "Default Logon"

# Realm Setup
#
# This is the realms that will be added to the list for this instance
# of the server. You can have multiple realms (e.g. one for LAN, WAN).
#
# RealmCount = The number of servers.
# Realm[x].Name = The name of the realm.
# Realm[x].Address = The address (and port) of that realm.
# Realm[x].Icon = The type of realm (PVP, Normal, RPPVP, RP)
# Realm[x].Colour = Realm colour in realm list display.
# Realm[x].TimeZone = Time zone the realm is in.
# Realm[x].Population = (0 = low, 1 = medium, 2 = high)
#

RealmCount = 1

Realm1.Name = "Test Realm"
Realm1.Address = "127.0.0.1:8129"
Realm1.Icon = "PVP"
Realm1.Colour = 1
Realm1.Population = 1.0
Realm1.TimeZone = 1

are these settings right?

 

[stefoka]

same problem

 

[krankfl]

Maybe your "accounts" part of the database is corrupted? or it cant access them properly.

 

[Darkicon]

It's crashing while trying to cache the accounts, so something is wrong with your accounts table.

Post the dump from that crash. Maybe someone who has the right programs can figure it out.

 

[krankfl]

Try update it with this, be sure to make a backup of the old table if you want to keep old account data,
if you know how to import it, it will drop all accounts and have only 1 admin account preconfigured,
this dump was made with mysql:

DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` (
  `account_id` int(30) NOT NULL,
  `uiconfig0` longtext,
  `uiconfig1` longtext,
  `uiconfig2` longtext,
  `uiconfig3` longtext,
  `uiconfig4` longtext,
  `uiconfig5` longtext,
  `uiconfig6` longtext,
  `uiconfig7` longtext,
  `uiconfig8` longtext,
  PRIMARY KEY  (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_data`
--

/*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_data` ENABLE KEYS */;


--
-- Definition of table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `acct` int(20) unsigned NOT NULL auto_increment,
  `login` varchar(16) NOT NULL default '',
  `password` varchar(16) default NULL,
  `gm` varchar(10) default '0',
  `banned` int(30) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `lastip` varchar(15) default NULL,
  `email` varchar(50) default NULL,
  `flags` int(11) NOT NULL default '0',
  PRIMARY KEY  (`login`),
  UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` (`acct`,`login`,`password`,`gm`,`banned`,`lastlogin`,`lastip`,`email`,`flags`) VALUES 
 (1,'admin','admin','az',0,'2007-06-08 10:18:11','127.0.0.1','[email protected]',8),
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;

 

[poemihai]

Hy there .. i am trying to solve this erorr for better than 3hours and still nothing. Please if you can help me post here. If i try to login using my game it works but i can't see no realm even if i have 2 one for local and one for internet. Here you have a print screen of my problem

To view the content, you need to sign in or register

PS: My acount is working ok . The server starts nicely only when it reaches to realms it goes crazy. lool x(

 

[krankfl]

Hy there .. i am trying to solve this erorr for better than 3hours and still nothing. Please if you can help me post here. If i try to login using my game it works but i can't see no realm even if i have 2 one for local and one for internet. Here you have a print screen of my problem

To view the content, you need to sign in or register

PS: My acount is working ok . The server starts nicely only when it reaches to realms it goes crazy. lool x(

First try this, just add this line on the end of all .conf files:
LogonServer.RemotePassword = yourpassword

Also have you opened up the ports correctly? on both firewall and router:
3724 (optional on router I think)
8093
8129

Can't think of anything else.

 

[poemihai]

LogonServer.RemotePassword = yourpassword

Damn .. nicely done . That worked. I wana' kiss you :jump1: !! Your the man . Thank!! Thank you again.


PSS: New problem : It stays at "Conected" part when i try to enter my game.

 

[krankfl]

Damn .. nicely done . That worked. I wana' kiss you :jump1: !! Your the man . Thank!! Thank you again.


PSS: New problem : It stays at "Conected" part when i try to enter my game.

The connected part should have something to do with ports not opened correctly, for example if I close port 8129, I will have the connected bar as well, if opened correctly I can get into the character screen no problem, took me a while before I figured this one out I hope this should help you as well.
If you need help forwarding ports on your router check out this site:

To view the content, you need to sign in or register

Make sure you forward it to your internal ip example 192.168.0.100 and set both the public and internal port to 8129, that should do the trick, do it with these three ports 3724, 8093, 8129

If using the windows firewall, you can add these to the firewall exceptions list manually, make sure they are open on both the windows firewall and router, if it doesn't work then I don't know what could be causing it.

Krank.

 

[FullMetal140]

Oh man, thanks krank, i was getting the "Connected" poo for a long time. Thanks for the info!

 

[krankfl]

Before I forget here is how I set up my configs:
antrix.conf - Host = 0.0.0.0
logonserver.conf - Host = 0.0.0.0
realms.conf - see below:

LogonServer1.Address = "71.226.35.123" <- my outside ip
LogonServer1.Port = 8093
LogonServer1.Name = "Default Logon"

Realm1.Name = "Test Server"
Realm1.Address = "71.226.35.123:8129"
Realm1.Icon = "PVP"
Realm1.Colour = 1
Realm1.Population = 1.0
Realm1.TimeZone = 1

And it works like a charm, at least for me

*EDIT*
Don't use: Host = localhost on antrix.conf and logonserver.conf
Simply keep it at 0.0.0.0

 

[poemihai]

The weapon master, the fishing master, the trainer for paladin won't teach you mail-plate and some other spells do not work

Ps: This are some off the bugs i found soo far.