XML parsing error

[Cynnar]

It has been a long time since I have had any issues with minilogin, but it might be that you do not have a world account setup in the loging db. I was just fixing to start a fresh server install including minilogin to work on a guide for the wiki. I know that there are some mysql queries for account and registering world that need to be added along with some other stuff.

Also a logfile for both world and minilogin would help out a lot. Should be a log dir where the exe files are located.

[Skywalker646]

Here is some info

LoginServer

*****### --- This file tells world.exe what loginserver to connect to.
### --- Change the account and password fields to the information you used when you created your SERVER account.

### --- NOTE: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=127.0.0.1
loginport=9100
worldname=Name
worldaddress=192.168.*.*
#internalworldaddress=192.168.*.*
worldport=9000
locked=false
account=Account
password=Password
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=True
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9104

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

****


Login_db

****
# READ README.TXT!

[Database]
host=127.0.0.1
user=root
password=eqemu
database=eq2world


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

***


EQ2 World Log

****

13:48:55 I Init: Starting EQ2Emulator WorldServer...
13:48:55 I DB: Using database 'eq2world' at 127.0.0.1
13:48:55 I Patcher: Connecting to DB PatchServer...
13:48:55 I Patcher: Connected to patch server at updates.eq2emulator.net:9104
13:48:55 I Patcher: Server is up to date
13:48:55 I World: Loading System Data...
13:48:56 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
13:48:56 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
13:48:56 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
13:48:56 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
13:48:56 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
13:48:56 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
13:48:56 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
13:48:57 I World: Loaded System Data (took 2 seconds)
13:48:57 W Threaded: Using Threaded loading of static data...
13:48:57 I Guilds: Loading Guilds...
13:48:57 W Thread: Item Loading Thread started.
13:48:57 W Thread: Spell Loading Thread started.
13:48:57 I Guilds: Loaded 0 Guild(s)
13:48:57 I Recipes: Loading Recipe Books...
13:48:57 I Recipes: Loading Recipes...
13:48:57 I DB: Using database 'eq2world' at 127.0.0.1
13:48:57 I DB: Using database 'eq2world' at 127.0.0.1
13:48:57 I Tradeskills: Loading Tradeskill Events...
13:48:57 I Items: Loading Items...
13:48:57 I AA: Loading Alternate Advancements...
13:48:57 I Spells: Loading Spells...
13:48:57 I AA: Loaded 0 Alternate Advancement(s)
13:48:57 I AA: Loading AA Tree Nodes...
13:48:57 I AA: Loaded 0 AA Tree Nodes
13:48:57 I Titles: Loading Titles...
13:48:57 I Languages: Loading Languages...
13:48:57 I Chat: Loading channels...
13:48:57 I LUA: Loading Spawn Scripts...
13:48:57 I LUA: Loading Zone Scripts...
13:48:57 I World: Loading House Zone Data...
13:48:57 I World: Loading Heroic OP Data...
13:48:57 I World: Loading Race Types Data...
13:48:57 I World: - Loaded 0 Race Types
13:48:57 I World: Waiting for load threads to finish.
13:48:57 I Items: Loaded 0 Total Items (took 0 seconds)
13:48:57 I Collect: Loading Collections...
13:48:57 I Merchants: Loading Merchants...
13:48:57 I Quests: Loading Quests...
13:48:57 W Thread: Item Loading Thread completed.
13:48:57 I Spells: Loaded 0 Spells (took 0 seconds)
13:48:57 I Spells: Loading Spell Errors...
13:48:57 I Traits: Loading Traits...
13:48:57 I Traits: Loaded 0 Trait(s)
13:48:57 W Thread: Spell Loading Thread completed.
13:48:57 I World: Load threads finished.
13:48:57 I World: Total World startup time: 2 seconds.
13:48:57 I Net: World server listening on: 192.168.*.*:9000
13:48:57 I Zone: Starting static zones...
13:48:57 I IRC: Starting global IRC server...
13:48:57 I Console: Type 'help' or '?' and press enter for menu options.
13:48:58 E World: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error: 10061'


****


As for a minilogin log, I'm not finding one. I am not sure if i am supposed to run the minilogin as well as the eq2 world server, bit if i am supposed to, i get this message.

Opcode OP_LSRequestPlayerDescMsg is missing from opcode configuration.

[Cynnar]

lol well I have been focused on minilogin today, and I thought I read where you were using it but you did say eq2emulator login. My bad. You don't need minilogin if you are using eq2emulator login just so you will know.

Did you register your server? In Account Management Login (or create an account) and fill in the information in the My Servers tab after clicking the create server button. Once this is done, or if you have already registered a server, be sure to include all of that information in your LoginServer.ini Should look something like this...

Code: Select all

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=The Nameless
worldaddress=Not Your Local IP Address
#internalworldaddress=INTERNAL_IP_HERE (If used, otherwise blank)
worldport=9000
locked=false
account=World Account here
password=Password here
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=false
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9104

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

What you have is pointing to local address

loginserver=127.0.0.1

This should be eq2emulator.net. It is the loginserver ip address you want to connect to.

The worldname=Name Is where you will put the name of your world when you created it in the My Servers tab of the Account Management page
Note mine is worldname=The Nameless

The worldaddress=192.168.*.* you have pointing to your local network and I don't think you can use that. I really cannot help much past this point except that it will probably need to be your real IP to connect from the outside world. Like if anyone wants to connect to your server. With you using eq2emulator login it will make your connection an outside connection as well and you will not be able to log on to your server. Port Forwarding will paly a big part here, but I have never set up my personal pc to allow connections. Maybe [mention]Jabantiz[/mention] or [mention]tyrbo[/mention] can help with this part if you need it?

[Skywalker646]

sorry for any confusion. I was trying to set up the minilogin. I was able to run it fine with using the eq2emulator login but the message i get is when trying to set up the minilogin.

[Cynnar]

ah ok then. Yeah I am all over the place today.

Did you register your server in you minilogin db? You will need to do that then the LoginServer.ini should look like this...

Code: Select all

[LoginServer]
loginserver=127.0.0.1
loginport=9100
worldname=Kithicor Forest
worldaddress=127.0.0.1
# internalworldaddress=
worldport=9000
locked=false
account=Cynnar
password=minilogin
autotableupdates=never
autotableverbose=false
autotabledata=false

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9104

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

it might be that your worldaddress needs to be 127.0.0.1 or localhost and not your lan ip

[Skywalker646]

i switched over to the 127.... sequence and used the same world info from the world i created in the login_worldservers.

is that what you were referring to?

[Cynnar]

yes that is correct.

Edit: I am going to be afk for a few hours. If that didn't fix it, and [mention]Jabantiz[/mention] doesn't jump in to save me, then when I get back on we will continue trying to slove this problem.

[Skywalker646]

sadly the same result

[Jabantiz]

Quick google search for tcp error 10061 returns this

Error # 10061 indicates no connection could be made because the target computer actively refused it.

So based off of this my best guess would be a firewall issue and the port is blocked.

[Skywalker646]

i tried shutting off the firewall to test it out but no success. i'll keep poking around on my end and thanks for all the help

[Cynnar]

The only thing I can think of is to delete the row in the login_worldservers for the loginserver and insert it again. Something to keep in mind is that if you just put in the password without encrypting it then it will not work. The sql query should look something like this...

Code: Select all

insert into account set name='thename',passwd=md5('thepasswd');

Then make sure the password is in plain text in your LoginServer.ini

Edit: Also make sure you have the latest version of MiniLogin (v1.04) SVN Folder
SVN Username: anonymous (no password required)

[Skywalker646]

Should EQ2Minilogin_x64 be running along with EQ2World_x64? If so, i get this message


18:27:14 E DBCore : #1146: Table 'eq2world.login_config' doesn't exist
Query:
UPDATE login_config SET config_value = 1544408834 WHERE config_name = 'login_heartbeat'

[Cynnar]

EQ2Minilogin_x64 or EQ2Minilogin either one needs to be running, but doesn't matter what one. I use EQ2Minilogin.exe with my EQ2World_x64.exe with no problems.

Table 'eq2world.login_config' doesn't exist

Means you do not have a login_config table in the eq2world database.

UPDATE login_config SET config_value = 1544408834 WHERE config_name = 'login_heartbeat'

Is the query that it was trying to execute.

[Skywalker646]

is there a way i can set this up? specific columns or info i need to add?

[Jabantiz]

Code: Select all

DROP TABLE IF EXISTS `login_config`;
CREATE TABLE IF NOT EXISTS `login_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `config_name` varchar(64) NOT NULL DEFAULT '',
  `config_value` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='moving some hard-coded values out of Login source to this ta';

INSERT INTO `login_config` (`id`, `config_name`, `config_value`) VALUES
	(1, 'login_heartbeat', '1534108089'),
	(2, 'max_server_offline_age', '2592000');

Here is that table from my DB.