Need some advice.. PLEASE

rixcraven · #1 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>


<shortname>chess</shortname>
<longname>ChessBoard2</longname>


<address>otherworld.myvnc.com</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>

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

</loginserver>






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


<key>XXXXXXXXXXXXXX</key>


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

</world>


<chatserver>

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

</chatserver>


<mailserver>

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

</mailserver>

<zones>


<defaultstatus>0</defaultstatus>


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

</zones>


<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>






</launcher>


<files>






</files>

<directories>





</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** · #2 10-14-2013, 11:47 AM

Quote:

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

Quote:

<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 · #3 10-14-2013, 01:13 PM

Code:

<!-- 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 · #4 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>

<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 · #5 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 · #6 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 · #7 10-14-2013, 03:34 PM

Quote:

Originally Posted by Vexyl

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 · #8 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 · #9 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 10-14-2013, 04:37 PM

Quote:

Originally Posted by Vexyl

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 · #11 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** · #12 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)