Log in

View Full Version : Need some advice.. PLEASE

rixcraven
10-14-2013, 08:57 AM
Hello!
I followed the Feb 2013 setup guide, and have got everything running, (at least everything starts with no errors!!.
The issue I have is that no-one, either from LAN or WAN, can connect to the server. All everyone gets is the "A connection to the server could not be made" etc.

I am running the server on a Win 2k8 R2 Dell, and since it gives no errors whilst its running, I imagine its my eqconfig, login ini's that are all messed up??, Please help me!.

this is my login ini :-
[database]
host = 127.0.0.1
port = 3306
db = login
user = xxx
password = xxxxx
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = TRUE
dump_packets_out = TRUE
DatabaseServerName=127.0.0.1
DatabaseCatalogName=login
DatabaseUserName=xxxxxx
DatabaseUserPassword=xxxxxxxx
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

I do have an admin account set in the DB.

and this is my eqemu_config :-

<?xml version="1.0">
<server>

<world>

<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>chess</shortname>
<longname>ChessBoard2</longname>



<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<address>otherworld.myvnc.com</address>
<localaddress>127.0.0.1</localaddress>


<!-- Loginserver information. DO NOT EDIT -->
<loginserver>

<host>127.0.0.1</host>
<port>5998</port>
<account>XXXXXX</account>
<password>XXXXXX</password>

</loginserver>


<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!--<locked/>-->
<!-- <unlocked/> -->



<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
<tcp ip="127.0.0.1" port="9000" telnet="disable"/>



<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>XXXXXXXXXXXXXX</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. DO NOT EDIT -->
<chatserver>

<host>192.168.1.85</host>
<port>7779</port>

</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>

<host>192.168.1.85</host>
<port>7779</port>

</mailserver>

<zones>

<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>0</defaultstatus>



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

</zones>

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>

<host>127.0.0.1</host>
<port>3306</port>
<username>XXXXXXXX</username>
<password>XXXXXXXX</password>
<db>peq</db>

</database>
<qsdatabase>

<host>127.0.0.1</host>
<port>3306</port>
<username>XXXXXXXXX</username>
<password>XXXXXXXXX</password>
<db>peq</db>

</qsdatabase>

<!-- Launcher Configuration DO NOT EDIT-->
<launcher>

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

</launcher>

<!-- File locations. DO NOT EDIT -->
<files>

<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->

</files>
<!-- Directory locations. DO NOT EDIT -->
<directories>

<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->

</directories></server>

my firewalls are configured, and the router IS forwarding the required ports.
I am at a total loss, and have searched the forums for 4 days now without any clue. If anyone could point me at anything to help I would be very very grateful.
Many Thanks
NatedogEZ
10-14-2013, 11:47 AM
this is my login ini :-
[database]
host = 127.0.0.1
port = 3306
db = login
user = xxx
password = xxxxx
subsystem = MySQL






<host>127.0.0.1</host>
<port>3306</port>
<username>XXXXXXXX</username>
<password>XXXXXXXX</password>
<db>peq</db>




Your database names don't match if you are trying to use your own login server. Unless you have the login server on a separate database I guess.
Vexyl
10-14-2013, 01:13 PM
<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<address>otherworld.myvnc.com</address>
<localaddress>127.0.0.1</localaddress>


I don't think that those need to be set. In fact, they are usually commented out.
rencro
10-14-2013, 01:49 PM
Comment out the address and localaddress as suggested by Vexyl, then put the real ip of the login server you are using in:

<!-- Loginserver information. DO NOT EDIT -->
<loginserver>

<host>127.0.0.1</host>
<port>5998</port>
<account>XXXXXX</account>
<password>XXXXXX</password>

</loginserver>

change that to your ip of your actual login server, ie 192.168.1.85 or otherworld.myvnc.com, ie the same ip you set your clients eqhost info too..

that is if you are using your own login server...
rixcraven
10-14-2013, 03:29 PM
you made a real difference...
I altered things to the way you all advised, now I can get players from inside the lan perfectly :) :).

from WAN, still getting the "failed connection", can you give a bit more advice on this?.. we are SOOOO close :)
Is it because I remmed out the <address>otherworld.myvnc.com</address>
<localaddress>127.0.0.1</localaddress> ??

again, many many thanks for your time :)
Vexyl
10-14-2013, 03:31 PM
Which required ports are forwarded on the router? You should have the ports forwarded for the login server, world server, and zone server(s).
rixcraven
10-14-2013, 03:34 PM
Which required ports are forwarded on the router? You should have the ports forwarded for the login server, world server, and zone server(s).

yes... got 9000 7000-7100, 3306 (for remote admin), 5998,5999,6000,7779, 9080

which port does the login server use? did I miss it????
rencro
10-14-2013, 03:37 PM
If you are using your own login server AND ypu want to enable outside connections, then the ip needs to be an INTERNET reachable ip, via dyn dns, a static ip from your isp ect.., Im assuming you set to 192.168.1.85, thats a private ip and only your lan can see that..

Try going to whats my ip site and putting that ip in if the domain name does not work as a test..
Vexyl
10-14-2013, 03:58 PM
Yes, 5998 and 5999 are for the login server, 9000 for world server, 7000-7100 are for up to 101 zone servers, but the others aren't necessary. I don't know what 6000 and 7779 are for (chat/mail server?), and 9080 is for the http web interface, which you probably don't need.

As rencro has said, be sure that the clients connecting from WAN are set to use the login server at your external IP address (http://www.whatismyip.com to find out what it is). In other words, be sure their eqhost.txt is configured properly to connect to your login server over the internet.
rixcraven
10-14-2013, 04:37 PM
Yes, 5998 and 5999 are for the login server, 9000 for world server, 7000-7100 are for up to 101 zone servers, but the others aren't necessary. I don't know what 6000 and 7779 are for (chat/mail server?), and 9080 is for the http web interface, which you probably don't need.

As rencro has said, be sure that the clients connecting from WAN are set to use the login server at your external IP address (http://www.whatismyip.com to find out what it is). In other words, be sure their eqhost.txt is configured properly to connect to your login server over the internet.

Yes, I use otherworld.myvnc.com (its a No-IP addy), which resolves to my external IP, (then gets routed of course), you have all made TERRIFIC contributions, and I am very grateful!..
(and yes, 6000 I saw mentioned (somewhere, as the port for SOD, 7779 is the mail/chat)
again, thanks for the help.. couldn't figure it out myself.
Setting the Host=87.115.109.249
but still not getting through from outside the LAN.
Vexyl
10-14-2013, 04:50 PM
Double check firewall settings, and check if the login server port from login.ini matches the port set in eqhost.txt.


Some ISPs do not allow servers to be hosted, and may block incoming connections.
Uleat
10-14-2013, 06:02 PM
(I think this is true, but someone double-check me...)

I don't know what all you have changed since the first post, but generally you only want to use '127.0.0.1' for things on your computer
that connect to your computer (i.e., MySQL database.)

Everything else should be your local IP address of '192.168.1.85'..otherwise you would need another translator to forward from
192.168.1.85 to 127.0.0.1, and visa-versa. (192.168.1.85 != 127.0.0.1)