Is this happening for everyone? [Archive]

View Full Version : Is this happening for everyone?

solid11

03-08-2006, 06:49 PM

I got the newest release of emu and tried to start it up. This is the first update I've done since 6.2. with 6.2 working fine. The problem is that world.exe closes as soon as it opens up. Anyone else have this problem? Thanks all...

cavedude

03-09-2006, 01:33 AM

Try opening world from a command prompt and see if it spits out an error. However, it's probably a problem with your configuration file somehwere. Make sure your brackets are all closed, are in the right place/format, and watch what you use to edit the file. Use notepad if you can as that adds no additional format marks and such. If you're under Linux, doesn't use gedit ;) I learned that myself.

I would start with a fresh config file from the wiki and slowly edit it, starting world with every change until you are through.

sesmar

03-09-2006, 01:42 AM

Something that I also noticed, when first setting up the new config file, is that if you try opening the file up in Internet Explorer and there are any errors in the file IE will most likely catch them giving you some kind of idea about where the problem is. If the file opens up just fine in IE then you "should" be good to go.

On a side note, I use Textpad instead of notepad you may wish to look into this as it offers a little bit more then notepad does and does not mess with the formating of the file.

tallerin

03-09-2006, 03:41 AM

World did that to me at first also. You should be able to look into the Log folder in eqemu and there should be an error file for world. Mine did it because i had some info wrong in the config.xml file for the database. So when i would start it it poped up and the promptly closed leaveing a world error file in logs.
Also it did it when i was messing with the ips so just look in your log folder and see what is causing it. It sounds like world is not connecting to your DB for some reason and if it can not connect world will promplty close

So I would clear out my log folder in eqemu and then try starting eqemu when it closes out read the new loggs it will give you the reason why it closed out in one of the 2 new files created then just edit that area of the config.xml.

Also if IE won't open the .xml file add a ? mark to the end of this
<?xml version="1.0"> so it is like this <?xml version="1.0"?> it is the only error i had in the xml file that came with eqemu.

solid11

03-09-2006, 09:10 AM

New config file??? I looked in the wiki and don't see any info on setting up the server with these new files. Anyone have a link to an example of a set up file and is the eqemu_config.xml file the only one you need to set up? Thanks all for the info.

ylosh

03-09-2006, 09:19 AM

http://www.eqemulator.net/wiki/wikka.php?wakka=Dev065Release
http://www.eqemulator.net/wiki/wikka.php?wakka=ServerConfiguration

should list everything you need to know to get 0.6.5 up and running.

solid11

03-09-2006, 03:05 PM

Thanks for those links ylosh. I transferred my .ini settings to the xml file but it says it needs to connect to a database/mysql, but my settings are right, or the same anyway as my old .ini files. Here they are, and trying to use minilogon also btw.

<?xml version="1.0">
<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>






<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>






<tcp ip="localhost" port="9000" telnet="disable"/>


<key>some long random string</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>127.0.0.1</host>
<port>5999</port>
<username>myname</username>
<password>mypw</password>
<db>luclin</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Here is the error log...

---------------------------------------------
[03.09. - 22:00:55] Starting Log: logs/eqemu_error_world_4024.log
[03.09. - 22:00:55] Failed to connect to database: Error: #2003: Can't connect to MySQL server on '127.0.0.1' (10061)

---------------------------------------------
[03.09. - 22:00:54] Starting Log: logs/eqemu_debug_world_4024.log
[03.09. - 22:00:54] [WORLD__INIT] Loading server configuration..
[03.09. - 22:00:54] [WORLD__INIT] Log settings loaded from log.ini
[03.09. - 22:00:54] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.6.5
[03.09. - 22:00:54] [WORLD__INIT] Connecting to MySQL...
[03.09. - 22:00:55] [WORLD__INIT_ERR] Cannot continue without a database connection.

Thanks for the help guys.

tallerin

03-09-2006, 03:35 PM

you need to specify the world address

change this 
to this <address>localhost</address>

you have to remove  so it works right

also try putting the DB port back to 3306 not 5999

those are the only 2 things i saw different in your file from mine and mine works great with these 2 settings

solid11

03-09-2006, 07:17 PM

I tried the changes you suggested but it still says it cannot continue without a database connection(as the error log says above) even though i can access the DB easily with navicat or mysql front, which tells me the grant options are fine in the DB. There is something wrong in the xml is the only thing i can think of. Also, with this new setup, is the start up routine world.exe, eqlaunch.exe, zone.exe? Is that right? and where does minilogin come into play now? I like the fact that all the .ini files are combined now, just figuring out how to do the initial configuration is the problem, thanks all.

cavedude

03-10-2006, 12:51 AM

Trying using the local IP instead of 127.0.0.1. As long as the user and pass are OK you should be cool.

TheClaus

03-10-2006, 01:46 AM

Another way to test is to try and log into the db from a command prompt.

That would be the following.

mysql -u username -p dbname

It will then prompt you for a password. Put that password in and if you can get in then it is something else with the XML file.

solid11

03-10-2006, 03:28 AM

First, TheClaus, yes I was able to log into the DB fine from a command prompt. Second, Cave, local IP as in what? Using "localhost" or 192.168.1.100? or something else? Where are you saying to put this? In world? loginserver? ect... I really figured if you have 127.0.0.1 or localhost or what ever on your original .ini files the dev's wouldn't have changed it when they combined them in this xml file.
I have condensed my xml file for ease of view purposes for the moment. Here is what I have that keeps telling me that it's not connecting to the DB so far, and for everything else you don't see assume it is default that comes with the xml.full file because I haven't touched it from what I posted above.

Also, this new setup doesn't assume you have mysql installed on "C:\mysql" does it? When trying to make the connection? Because I have it installed on my second drive as "F:\Mysql"

<?xml version="1.0">
<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>


<address>localhost</address>
<localaddress>192.168.1.100</localaddress>


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


<database>
<host>127.0.0.1</host>
<port>5999</port>
<username>MYUSERNAME</username>
<password>MYPASSWORD</password>
<db>eq</db>
</database>

cavedude

03-10-2006, 04:36 AM

Change the db port to default which is 3306, you are using 5999 which is the minilogin server port. So basically, change this:

<database>
<host>127.0.0.1</host>
<port>5999</port>
<username>MYUSERNAME</username>
<password>MYPASSWORD</password>
<db>eq</db>
</database>

To this:

<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>MYUSERNAME</username>
<password>MYPASSWORD</password>
<db>eq</db>
</database>

That's your problem. However, if it still doesn't work, change 127.0.0.1 to 192.168.1.100 or whatever your local IP is.

tallerin

03-10-2006, 06:12 AM

Also, this new setup doesn't assume you have mysql installed on "C:\mysql" does it? When trying to make the connection? Because I have it installed on my second drive as "F:\Mysql"

I don't think it matters were it is installed as long as you point the eqemu server to the right port Mysql is listening on it should connect to your DB.

Also as mentioned before by cavedude and I ( cavedude was more clear then i) use port 3306 not 5999 for your database. I changed the port on my .xml and i get the same error as you so i believe if that port was changed your world would connect to your Database.

with this new setup, is the start up routine world.exe, eqlaunch.exe, zone.exe? Is that right? and where does minilogin come into play now?

This is my server startup sequence (note i don't use the launcher yet) minilogin world.exe zone.exe so i guess if you have the launcher set up to load say 20 static zones you would go minilogin World.exe Launcher.exe

solid11

03-10-2006, 09:53 AM

Well changing that port seemed to work, but I think minilogin isn't working, because it stalls at the login screen after trying to log in. Well here is some logs from the boot up in case it helps others or you all might know what's going on.

<From minilogin startup>

Couldn't open the LoginServer.ini file.
Server mode: MiniLogin
Login server listening on port:5999
13407 New Server connection: 127.0.0.1 port: 19204
0: 65 72 61 74 01 00 00 00 | erat....
0: 00 00 00 00 53 75 6E 20 - 4D 61 72 20 20 35 20 30 | ....Sun Mar 5 0
16: 30 3A 34 35 3A 33 35 20 - 32 30 30 36 00 01 00 00 | 0:45:35 2006....
32: 00 | .
109047 New client from ip: 127.0.0.1 port: 1102
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0001 () Size=13]
00000: 00 02 00 00 00 00 00 00 - 00 00 00 08 00 | .............

Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 () Size=11]
00000: 00 03 00 00 00 00 00 00 - 00 00 00 | ...........

161250 New client from ip: 127.0.0.1 port: 1103
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0001 () Size=13]
00000: 00 02 00 00 00 00 00 00 - 00 00 00 08 00 | .............

Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 () Size=11]
00000: 00 03 00 00 00 00 00 00 - 00 00 00 | ...........

<From World.exe startup>

[Debug] Starting Log: logs/eqemu_debug_world_3788.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.6.5
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_3788.log
[Status] Using database 'luclin' at 127.0.0.1:3306
[Debug] [WORLD__INIT] Loading opcodes..
[Status] EMuShareMem loaded
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=46072
[Debug] [WORLD__INIT] Loading guild ranks..
[Debug] [WORLD__INIT] Loading guild link..
[Status] EMuShareMem loaded
[Status] Loading GuildList from database...
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Starting Log: logs/eqemu_error_world_3788.log
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Error] WorldDatabase::GetLauncherList: #1146: Table 'luclin.launcher' doesn't e
xist
[Debug] [WORLD__INIT] Reboot zone modes OFF
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Setting World to MiniLogin Server type
[Debug] [WORLD__LS] Connected to Loginserver: localhost:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1101
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1101
[Debug] [WORLD__ZONE] [1] Zone started with name . by launcher NONE
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use por
t 7000

<From Zone.exe startup>

[Debug] Starting Log: logs/eqemu_debug_zone_4080.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Log settings loaded from log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone_4080.log
[Status] Using database 'luclin' at 127.0.0.1:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.6.5
[Debug] [ZONE__INIT] Loading opcodes..
[Debug] [ZONE__INIT] Log settings loaded from ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
[Debug] [ZONE__INIT] Loading items
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading npc faction lists
[Status] EMuShareMem loaded
[Status] Loading NPC Faction Lists from database...
[Debug] [ZONE__INIT] Loading loot tables
[Status] Loading Loot tables from database...
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading guilds
[Debug] [ZONE__INIT] Loading guild list
[Status] EMuShareMem loaded
[Debug] [ZONE__INIT] Loading factions
[Debug] [ZONE__INIT] Loading titles
[Debug] [ZONE__INIT] Loading AA effects
[Debug] [ZONE__INIT] Loading swarm spells
[Debug] [ZONE__INIT] Loading tributes
[Debug] [ZONE__INIT] Loading corpse timers
[Debug] [ZONE__INIT] Loading commands
Error in GetCommands query 'SELECT command,access from commands' #1146: Table 'l
uclin.commands' doesn't exist
[Debug] [ZONE__INIT] 181 commands loaded
[Debug] [ZONE__INIT] Loading embedded perl XS
[Debug] [ZONE__INIT] Loading quests
[Quest] Starting Log: logs/eqemu_quest_zone_4080.log
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0x43d2b40)
[Quest] Creating EQEmuIO=HASH(0x43da8fc)
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Debug] [ZONE__INIT] Entering sleep mode
[Debug] [NET__WORLD] Connected to World: localhost:9000
[Debug] [ZONE__WORLD] World indicated port 7000 for this zone.
[Debug] [ZONE__INIT] Starting EQ Network server on port 7000

tallerin

03-10-2006, 10:29 AM

put the LoginServer.ini back in the eqemu folder. Minilogin still needs to use it for the login config

so make a Loginserver.ini file and put this in it
[LoginConfig]
ServerMode=minilogin
ServerPort=5999

that will fix the hanging up. I tryed it with out the .ini file with that info in it and i hang up but with it i log right in.

as for the launcher error i don't know about that as i have not tryed setting it up to use it.

solid11

03-10-2006, 02:04 PM

Ok, downloaded newest emu, even though that had no affect on gettin the server up, and just started over with the xml file. Made all sql changes in the change log to the Luclin DB and got no errors upon boot up. Got in game fine and character creation was flawless and got in game fine. Thanks for the new info all on this new setup. BTW, it's kind of pointless if minilogin is looking for the loginserver.ini files to boot up. Maybe minilogin will get updated soon. But all looks good Devs, rockin work you have done.

solid11

03-11-2006, 09:03 AM

One last thing. Since we don't use boot5 anymore how do you set the number of active zones to boot up? I get in game fine now but I can't zone through the zone lines. I keep getting warped back a few feet saying that the zone isn't ready, please try again in a few seconds, or something to that effect. But no matter how long you wait it keeps saying that. Kind of like if you set in boot5 that only 1 zone boots up instead of the default 5. So one isn't on the ready for you to zone into. Thanks and that should be it for a long while hehe.