Can see on server list but goes back to Login after trying to connect.

[GLGanjika]

Activepearl 5.10.1 build 1007
mysql 5.1
i followed THIS guide [CLICK HERE TO SEE GUIDE I USED] to the T. it worked for me once before but this time i s 3307 ihave another mysql going on this same pc but on the actual os (this eq serveris being set up on a vmware installation.) i have the one on win 7 set to to port 3306 and the one for eqemu on win xp to 3307. the port checker says 3307 is closed but i have it open ine very way, is there something im doing wrong or might this have something to do with it?
DEBUG

---------------------------------------------
[06.08. - 16:11:38] Starting Log: logs/eqemu_debug_1448.log
[06.08. - 16:11:38] [LAUNCHER__INIT] Loading server configuration..
[06.08. - 16:11:38] [LAUNCHER__INIT] Starting main loop...
[06.08. - 16:11:38] [NET__WORLD] Connected to World: localhost:9000
[06.08. - 16:11:43] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[06.08. - 16:11:43] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[06.08. - 16:11:43] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[06.08. - 16:11:43] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[06.08. - 16:11:43] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[06.08. - 16:11:43] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[06.08. - 16:11:43] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[06.08. - 16:11:43] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[06.08. - 16:11:43] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[06.08. - 16:11:43] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.
[06.08. - 16:11:43] [LAUNCHER__STATUS] Starting zone dynamic_01
[06.08. - 16:11:43] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[06.08. - 16:11:43] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[06.08. - 16:12:03] [LAUNCHER__STATUS] Starting zone dynamic_02
[06.08. - 16:12:03] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[06.08. - 16:12:03] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[06.08. - 16:12:05] [LAUNCHER__STATUS] Starting zone dynamic_03
[06.08. - 16:12:06] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[06.08. - 16:12:06] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[06.08. - 16:12:08] [LAUNCHER__STATUS] Starting zone dynamic_04
[06.08. - 16:12:08] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[06.08. - 16:12:08] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[06.08. - 16:12:10] [LAUNCHER__STATUS] Starting zone dynamic_05
[06.08. - 16:12:10] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[06.08. - 16:12:10] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.

ERROR-WORLD

---------------------------------------------
[06.08. - 16:12:04] Starting Log: logs/eqemu_debug_zone_1172.log
[06.08. - 16:12:04] [ZONE__INIT] Loading server configuration..
[06.08. - 16:12:04] [ZONE__INIT] Log settings loaded from log.ini
[06.08. - 16:12:04] [ZONE__INIT] Connecting to MySQL...
[06.08. - 16:12:04] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEmulator 0.8.0
[06.08. - 16:12:04] [ZONE__INIT] Log settings loaded from ./log.ini
[06.08. - 16:12:04] [ZONE__INIT] Mapping Incoming Opcodes
[06.08. - 16:12:04] [ZONE__INIT] Loading Variables
[06.08. - 16:12:04] [ZONE__INIT] Loading zone names
[06.08. - 16:12:04] [ZONE__INIT] Loading items
[06.08. - 16:12:04] [ZONE__INIT] Loading npc faction lists
[06.08. - 16:12:04] [ZONE__INIT] Loading loot tables
[06.08. - 16:12:04] [ZONE__INIT] Loading skill caps
[06.08. - 16:12:04] [ZONE__INIT] Loading spells
[06.08. - 16:12:04] [ZONE__INIT] Loading guilds
[06.08. - 16:12:04] [ZONE__INIT] Loading factions
[06.08. - 16:12:04] [ZONE__INIT] Loading titles
[06.08. - 16:12:04] [ZONE__INIT] Loading AA effects
[06.08. - 16:12:04] [ZONE__INIT] Loading tributes
[06.08. - 16:12:04] [ZONE__INIT] Loading corpse timers
[06.08. - 16:12:04] [ZONE__INIT] Loading commands
[06.08. - 16:12:04] command_init(): - Command 'acceptrules' set to access level 0.
[06.08. - 16:12:04] command_init(): - Command 'advnpcspawn' set to access level 150.
[06.08. - 16:12:04] command_init(): - Command 'aggro' set to access level 80.
[06.08. - 16:12:04] command_init(): - Command 'aggrozone' set to access level 100.
[06.08. - 16:12:04] command_init(): - Command 'ai' set to access level 100.
[06.08. - 16:12:04] command_init(): - Command 'altactivate' set to access level 0.
[06.08. - 16:12:04] command_init(): - Command 'appearance' set to access level 150.
[06.08. - 16:12:04] command_init(): - Command 'attack' set to access level 150.
[06.08. - 16:12:04] command_init(): - Command 'ban' set to access level 150.
[06.08. - 16:12:04] command_init(): - Command 'bestz' set to access level 0.
[06.08. - 16:12:04] command_init(): - Command 'bind' set to access level 200.
[06.08. - 16:12:04] command_init(): - Command 'bot' set to access level 0.

ERROR-WORLD

---------------------------------------------
[06.08. - 16:12:10] Starting Log: logs/eqemu_quest_zone_2712.log
[06.08. - 16:12:10] Tying perl output to eqemu logs
[06.08. - 16:12:10] Creating EQEmuIO=HASH(0x9586f7c)
[06.08. - 16:12:10] Creating EQEmuIO=HASH(0x957882c)
[06.08. - 16:12:10] Loading perlemb plugins.
[06.08. - 16:12:10] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[06.08. - 16:12:10] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[06.08. - 16:12:10] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[06.08. - 16:12:10] Loading perl commands...

QUEST-ZONE

---------------------------------------------
[06.08. - 16:12:08] Starting Log: logs/eqemu_quest_zone_3728.log
[06.08. - 16:12:08] Tying perl output to eqemu logs
[06.08. - 16:12:08] Creating EQEmuIO=HASH(0x9586f7c)
[06.08. - 16:12:08] Creating EQEmuIO=HASH(0x957882c)
[06.08. - 16:12:08] Loading perlemb plugins.
[06.08. - 16:12:08] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[06.08. - 16:12:08] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[06.08. - 16:12:08] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[06.08. - 16:12:08] Loading perl commands...

EQEMU ZONE (yes im using port 3307 since i have a mysql goign on 3306 on another pc on this connection.)

---------------------------------------------
[06.08. - 16:12:06] Starting Log: logs/eqemu_zone_0956.log
[06.08. - 16:12:06] Using database 'peq' at localhost:3307
[06.08. - 16:12:06] EMuShareMem loaded

ERROR-WORLD

---------------------------------------------
[06.08. - 16:11:36] Starting Log: logs/eqemu_error_world_1176.log
[06.08. - 16:11:36] Could not load EQTime file eqtime.cfg

[Vexyl]

Was there an actual question asked?
Maybe I just don't understand the problem.

[GLGanjika]

I think i figured it out, I was trying to start the server from another pc, i can get to character select/creation screen and am trying to sign in at the moment, everything appears to be fine, i will follow up if i can't get in. sorry to be a bother :P, but at the same time maybe this will just get sucked into google and help some other newbie start a server. i guess eqemu just wants the first client to attach to me a local one. :S

[GLGanjika]

Upon retrospect and testing of the server - The only issue i have is that I can't sign in outside of the windows xp installation without it going back to the login screen but if i use a client thats in the same installation of windows as the server it works fine, any ideas? Again, this is for setting up a PUBLIC server - i got the
template for this config from the guide i used to make this server. (note: yes i did google and search and see the other posts, none of them could help me on this though - i might have missed something but any feedback is always appreciated. =])

eqemu config file :

<?xml version="1.0">
<server>
	<world>
		<shortname>EsoEQ</shortname>
		<longname>EsoEQ: Casual EQ Titanium Server.</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<!-- <address>some.server.com</address> -->
		<!-- <localaddress>192.168.0.5</localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>eqemulator.net</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>some long random string</key>
		
		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>channels.eqemulator.net</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>channels.eqemulator.net</host>
		<port>7779</port>
	</mailserver>

	<zones>
		<defaultstatus>20</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>localhost</host>
		<port>3307</port>
		<username>root</username>
		<password>PASSWORDREMOVED</password>
		<db>peq</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

[Vexyl]

Check if a firewall is blocking the connection and be sure to forward the correct ports.
The world server uses port 9000 and zone starts at 7000 incrementing by one for each additional zone server.

[GLGanjika]

Originally Posted by Vexyl

Check if a firewall is blocking the connection and be sure to forward the correct ports.
The world server uses port 9000 and zone starts at 7000 incrementing by one for each additional zone server.

I'll try this, at the moment its running off of a vmware windows xp professional SP3 installation (32 bit) - the vmware is running inside of a windows 7 home premium installation, which firewalls do i need to check on the OS side? do i need to set windows 7 too?

edit: just opened the ports on router and firewall , my friend rob tried to connect but couldnt get through either (same error)
but i can connect through the server os installation. i have a router with ports forwarded as well. any ideas? I'm fairly certain your on
the right path and I'm fairly certain its a port issue as well, I'm not at a dorm or anything like that so thats not the issue.

[GLGanjika]

:bump: see the post above this one.

still no luck, opened all the ports i been told to on windows xp (where server is installed via vmware) and windows 7 (where vmware is). still no luck, again : I myself can connect on host os but not on any other pc or os.

here is config:

<?xml version="1.0">
<server>
	<world>
		<shortname>EsoEQ</shortname>
		<longname>EsoEQ: Casual EQ Titanium Server.</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<!-- <address>some.server.com</address> -->
		<!-- <localaddress>192.168.0.5</localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>eqemulator.net</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>some long random string</key>
		
		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>channels.eqemulator.net</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>channels.eqemulator.net</host>
		<port>7779</port>
	</mailserver>

	<zones>
		<defaultstatus>20</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>localhost</host>
		<port>3307</port>
		<username>root</username>
		<password>censored</password>
		<db>peq</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

here is start.bat (although im sure this start.bat is fine)

@echo off
start world.exe
echo waiting for the world to finish before starting zone...
ping -n 10 127.0.0.1 > nul
start eqlaunch.exe zone
exit

[Vexyl]

How is the VM's network configured? Check for a firewall on both the guest and host OS.
If it's bridged then you can simply configure your router to forward the ports to the guest's IP, otherwise you will have to read the vmware manual on forwarding packets to the guest OS.

Edit: Why are you running the server in a WinXP guest if you have Win7?

[GLGanjika]

Originally Posted by Vexyl

How is the VM's network configured? Check for a firewall on both the guest and host OS.
If it's bridged then you can simply configure your router to forward the ports to the guest's IP, otherwise you will have to read the vmware manual on forwarding packets to the guest OS.

Edit: Why are you running the server in a WinXP guest if you have Win7?

I couldnt get it to run alongside with the appserv-mysql i am also using for the forum/website, this is wy i am trying vmware based approach - Overall, how can i check how the connections are treated between vmware and the pc? (ie; how can i find out if its bridged, etc).

[Vexyl]

You will have to check with the vmware documentation.

You should really focus on getting the server to work with "appserv-mysql" instead of setting up vmware.
If it just incorporates mysql then I don't see why you would have a problem.
You may also want to take a look at XAMPP, a nice alternative available in many languages.

[GLGanjika]

Originally Posted by Vexyl

You will have to check with the vmware documentation.

You should really focus on getting the server to work with "appserv-mysql" instead of setting up vmware.
If it just incorporates mysql then I don't see why you would have a problem.
You may also want to take a look at XAMPP, a nice alternative available in many languages.

You mean run it alongside the mysql or just use appserv? In any case, is either or possible ? (if i wanted to install a second instance of mysql - could i? would that take any other configuration other than setting up server? - i might have messed up before. )

[Vexyl]

You could have a second installation of mysql running side by side, though that would be unnecessary.
You would also need to change the port for the second one; they can't both use the same port.

I was suggesting that you setup the EQEmu server on Win7 (not using vmware) to use appserv-mysql.
That way you have one mysql installation. No need for vmware.

[GLGanjika]

I have potentially 64 bit versions of mysql and/or perl on win 7, also i have heard stories of certain versions of mysql/perl not working with eqemu - i am fairly certain i have some of the newest versions of appserv and perl on my pc - would this effect anything? i will find out the versions right now and post them here. also - if i do start over on win 7 does the server just use 3306 and if i use 3307 ever is there anything i need to do to open it? port check always says 3307 is shut but 3306 is open even after i 'opened' it? sorry about 345345 questions but im still sorta a newb at running the server atm.

Appserv 2.5.10

i guess i didnt have perl on this pc.


how would i install using appserv and/or just a parellell mysql installation utilizing this guide (ie; what steps would change in the guide vs the guide how it tells me to do it.)

since im unsure about the newer versions of the software i have it might be preferable to install a parellell mysql and use a different port (like 3307 or some alternate port for the new mysql).

[Vexyl]

AFAIK: If you don't compile EQEmu for 64-bit Windows then you will need the 32-bit version of the Perl and MySQL libraries.
The 32-bit version of EQEmu server will still be able to connect to a 64-bit version of the MySQL server, it just can't load 64-bit libraries.

Unless you are connecting to the database remotely then EQEmu should be connecting via localhost; you do not need to forward port 3306. If you mean "open" as in you can connect to it locally then that just means the MySQL server is running.

[GLGanjika]

Originally Posted by Vexyl

AFAIK: If you don't compile EQEmu for 64-bit Windows then you will need the 32-bit version of the Perl and MySQL libraries.
The 32-bit version of EQEmu server will still be able to connect to a 64-bit version of the MySQL server, it just can't load 64-bit libraries.

Unless you are remotely connecting to the database then EQEmu should be connecting via localhost; you do not need to forward port 3306. If you mean "open" as in you can connect to it locally then that just means the MySQL server is running.

is port 3307 appropriate for a second mysql server? it wont step on any fingers with the first one if its on the same machine?
I'm going to try dual mysql servers.