Log in

View Full Version : Friends can't connect to my server


moltke24
04-21-2014, 09:39 PM
I was at my parents house and all my friends were able to connect to my server through the internet while i was at the house, however now that I'm at my place they cannot connect. I use hamachi and run a minecraft server which they were all able to connect to as well at both locations but can only connect to everquest when in the same place.

i also took down the minecraft server to make sure it wasn't interfering.

moltke24
04-21-2014, 09:41 PM
<?xml version="1.0">
<server>
<world>
<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>Moltke</shortname>
<longname>Moltke's World</longname>

<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<!-- <address>do.not.edit</address> -->
<!-- <localaddress>do.not.edit</localaddress> -->

<!-- Loginserver information. DO NOT EDIT -->
<loginserver>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></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>somelongrandomstring12345</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>25.46.53.180</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>
<host>25.46.53.180</host>
<port>7778</port>
</mailserver>

<zones>
<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>200</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>(edited these out)</username>
<password>(edited these out)</password>
<db>peq</db>
</database>
<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>(edited these out)</username>
<password>(edited these out)</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>

Esildor
04-21-2014, 09:58 PM
Have the ports open on your router?

moltke24
04-21-2014, 10:07 PM
Have the ports open on your router?

They can see my server, but when they try to connect their game stops responding and goes back to the log in screen.

I use a mac router and I'm using hamachi, so I've tried port forwarding before, and I've been able to get to my modem and everything was opened at least i thought so since I followed their directions. But don't really know if that's the issue, since they can connect to my minecraft server...

moltke24
04-21-2014, 10:25 PM
https://www.youtube.com/watch?v=tDhKBsHctYg

I went through this video, for my airport extreme and opened port 7778 is that the one that needs to be opened or others?

Tabaluga_Dragon
04-21-2014, 11:01 PM
that is the chat and mail server port

Tabaluga_Dragon
04-21-2014, 11:03 PM
port forward this range 7000 to 7100 and 9000 try that.

moltke24
04-21-2014, 11:36 PM
My friend says that they are getting error 1017 and says to rerun the update...

Esildor
04-21-2014, 11:55 PM
I think if you get error's connecting to an EQ server on emu it's just throwing a generic EQ error that would mean something on Sony servers(?)

Sounds like a port forwarding issue to me. If you can connect no problem from your comp and they're unable to.

moltke24
04-22-2014, 02:36 PM
Should i be placing the port numbers in both the private and public udp and tcp ports?

moltke24
04-22-2014, 04:46 PM
so i still cant get my friends to connect, I'm running hamachi so they can connect to my minecraft server. does hamachi interfere with my everquest server? can i use hamachi so they can connect to my everquest server?

moltke24
04-22-2014, 05:30 PM
I bought a port forwarding program, i had the program open all ports that you guys said to, 7000-7100, 9000, 3306 and 7778. I have abandoned using my mac router and am directly connected to the modem.

Does logmein hamachi cause interference?

is there something else that isn't ports?

Everyone can connect to my minecraft server no matter where i am

Everyone can connect to my everquest server only when we are in the same building

they can currently see my server in the listing but when they try to connect their game freezes and takes them back to the log in screen.

moltke24
04-22-2014, 06:00 PM
in my config file does my host ip need to be my external or internal ip cuz both are different as seen here?

<!-- Chatserver (channels) information. DO NOT EDIT -->
<chatserver>
<host>(does this need to be internal or external ip?)</host>
<port>7778</port>
</chatserver>

I have two IPv4 internal addresses one external ip address and 1 router ip address, i can connect with both internal ip addresses, but have no tried the external ip address

anyone else want to try to connect? my server's name is Moltke's world. I'm leaving the server up incase someone wants to try and see if it works.

Uleat
04-22-2014, 06:16 PM
Someone had a vid-streaming app that also used port 9000 that was causing issues...

Make sure that nothing else is attached to the required ports.


(You are using the EQEmu login server explicitly, correct?)

moltke24
04-22-2014, 06:42 PM
Yes i am using the eqemu login and i told them to make sure theirs were updated

here are my ports:
first image http://imgur.com/m9OOyU1
second image http://imgur.com/vsB7Lje
3rd image http://imgur.com/cyH2HFP
4th image http://imgur.com/FJH10BI

moltke24
04-24-2014, 08:48 PM
So i installed everquest on the computer next to me and i can connect... anyone have any idea?

Uleat
04-24-2014, 10:58 PM
Can your friends connect when you are connected on this computer next to you?

What do your world logs indicate? Are there any login attempts shown?

moltke24
04-25-2014, 09:48 AM
Can your friends connect when you are connected on this computer next to you?

What do your world logs indicate? Are there any login attempts shown?

i have logs from my computer next to me when it logs in, and i had logs when people tried to connect when we were in the same room at my parents.

they say they can connect to all the servers but mine, i get no attempts to log into my server when they try to log in now.

they said their computer just freezes and goes back to the log in screen when they try to connect to my server.

moltke24
04-25-2014, 01:51 PM
it has to be something really simple, i know its going to be like one thing blocking or timing out their connections to my server that prevents them from logging in outside of LAN

Noport
04-25-2014, 02:54 PM
moltke24: make sure your server is setup as a public server under variables in your peq database. the error it's given tells me their ip address needs updated in the data base.

requires TCP port 7000 open to connect - verify that your firewall has it open
game requires UDP 1024-65535 to be open outbound, verify
Read: http://www.eqemulator.org/forums/showthread.php?t=35057

moltke24
04-25-2014, 04:59 PM
moltke24: make sure your server is setup as a public server under variables in your peq database. the error it's given tells me their ip address needs updated in the data base.

requires TCP port 7000 open to connect - verify that your firewall has it open
game requires UDP 1024-65535 to be open outbound, verify
Read: http://www.eqemulator.org/forums/showthread.php?t=35057



Here is my EQ config file


<?xml version="1.0">
<server>
<world>
<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>Moltke</shortname>
<longname>Moltke's World</longname>

<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<!-- <address>do.not.edit</address> -->
<!-- <localaddress>do.not.edit</localaddress> -->

<!-- Loginserver information. DO NOT EDIT -->
<loginserver>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></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>somelongrandomstring12345</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>25.46.53.1xx</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>
<host>25.46.53.1xx</host>
<port>7778</port>
</mailserver>

<zones>
<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>200</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>root</username>
<password>stumpy24</password>
<db>peq</db>
</database>
<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>stumpy24</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>


and here are my IP addresses, which ones do i need to switch?

INTERNAL IP address: 192.168.x.x
INTERNAL IP address: 25.46.53.1xx
ROUTERS IP Address: 192.168.x.x
EXTERNAL IP address: 75.114.228.xx


And this is from my database, so i think ive made it public?

/* EQEMu: Everquest Server Emulator
Copyright (C) 2001-2010 EQEMu Development Team (http://eqemulator.net)

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; version 2 of the License.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY except by those people which sell it, which
are required to give you total support for your newly bought product;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR
A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
#ifndef EQEMU_DATABASEMYSQL_H
#define EQEMU_DATABASEMYSQL_H

#include "Database.h"
#ifdef EQEMU_MYSQL_ENABLED

#include <string>
#include <sstream>
#include <stdlib.h>
#include <mysql.h>

/**
* Mysql Database class
*/
class DatabaseMySQL : public Database
{
public:
/**
* Constructor, sets our database to null.
*/
DatabaseMySQL() { db = nullptr; }

/**
* Constructor, tries to set our database to connect to the supplied options.
*/
DatabaseMySQL(std::string user, std::string pass, std::string host, std::string port, std::string name);

/**
* Destructor, frees our database if needed.
*/
virtual ~DatabaseMySQL();

/**
* @return Returns true if the database successfully connected.
*/
virtual bool IsConnected() { return (db != nullptr); }

/**
* Retrieves the login data (password hash and account id) from the account name provided
* Needed for client login procedure.
* Returns true if the record was found, false otherwise.
*/
virtual bool GetLoginDataFromAccountName(std::string name, std::string &password, unsigned int &id);

/**
* Retrieves the world registration from the long and short names provided.
* Needed for world login procedure.
* Returns true if the record was found, false otherwise.
*/
virtual bool GetWorldRegistration(std::string long_name, std::string short_name, unsigned int &id, std::string &desc, unsigned int &list_id,
unsigned int &trusted, std::string &list_desc, std::string &account, std::string &password);

/**
* Updates the ip address of the client with account id = id
*/
virtual void UpdateLSAccountData(unsigned int id, std::string ip_address);

/**
* Updates or creates the login server account with info from world server
*/
virtual void UpdateLSAccountInfo(unsigned int id, std::string name, std::string password, std::string email);

/**
* Updates the ip address of the world with account id = id
*/
virtual void UpdateWorldRegistration(unsigned int id, std::string long_name, std::string ip_address);

/**
* Creates new world registration for unregistered servers and returns new id
*/
virtual bool CreateWorldRegistration(std::string long_name, std::string short_name, unsigned int &id);
protected:
std::string user, pass, host, port, name;
MYSQL *db;
};

#endif
#endif



or do i need to change something in here to make it public?

/* EQEMu: Everquest Server Emulator
Copyright (C) 2001-2010 EQEMu Development Team (http://eqemulator.net)

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; version 2 of the License.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY except by those people which sell it, which
are required to give you total support for your newly bought product;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR
A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
#ifndef EQEMU_DATABASE_H
#define EQEMU_DATABASE_H

#include <string>

#define EQEMU_MYSQL_ENABLED
//#define EQEMU_POSTGRESQL_ENABLED

/**
* Base database class, intended to be extended.
*/
class Database
{
public:
Database() : user(""), pass(""), host(""), port(""), name("") { }
virtual ~Database() { }

/**
* Returns true if the database successfully connected.
*/
virtual bool IsConnected() { return false; }

/**
* Retrieves the login data (password hash and account id) from the account name provided
* Needed for client login procedure.
* Returns true if the record was found, false otherwise.
*/
virtual bool GetLoginDataFromAccountName(std::string name, std::string &password, unsigned int &id) { return false; }

/**
* Retrieves the world registration from the long and short names provided.
* Needed for world login procedure.
* Returns true if the record was found, false otherwise.
*/
virtual bool GetWorldRegistration(std::string long_name, std::string short_name, unsigned int &id, std::string &desc, unsigned int &list_id,
unsigned int &trusted, std::string &list_desc, std::string &account, std::string &password) { return false; }

/**
* Updates the ip address of the client with account id = id
*/
virtual void UpdateLSAccountData(unsigned int id, std::string ip_address) { }

/**
* Updates or creates the login server account with info from world server
*/
virtual void UpdateLSAccountInfo(unsigned int id, std::string name, std::string password, std::string email) { }

/**
* Updates the ip address of the world with account id = id
*/
virtual void UpdateWorldRegistration(unsigned int id, std::string long_name, std::string ip_address) { }

/**
* Creates new world registration for unregistered servers and returns new id
*/
virtual bool CreateWorldRegistration(std::string long_name, std::string short_name, unsigned int &id) { return false; }
protected:
std::string user, pass, host, port, name;
};

#endif



I'm sorry im pretty clueless on most of this, I'm in med school and like to dabble in this kind of stuff but i dont really have a good understanding of it since i spend most of my time in non computer related things

moltke24
04-26-2014, 06:48 PM
moltke24: make sure your server is setup as a public server under variables in your peq database. the error it's given tells me their ip address needs updated in the data base.

requires TCP port 7000 open to connect - verify that your firewall has it open
game requires UDP 1024-65535 to be open outbound, verify
Read: http://www.eqemulator.org/forums/showthread.php?t=35057

where do i put their ip addresses so they can connect?

could you copy and paste something so i can see where id put the IPs in at?

moltke24
04-26-2014, 07:05 PM
I had them go to the eqhost.txt file and change the host name from login.eqemulator.net to my ip address and they still can't connect.

I've been spending hours doing things and i feel like anything that i do could just mess it up more and i literally could be one step off from them connecting...

Noport
04-27-2014, 05:54 AM
moltke24 make sure your eqemulogin.ini files looks just like this
replace the xxxxx and type in your password
what I think is happening your using the wrong login and your trying to use a newer client then Sof

Port=5999
DumpPacketsIn=false
DumpPacketsOut=false
Trace=false
DatabaseServerName=localhost
DatabaseCatalogName=peqlogindb
DatabaseUserName=root
DatabaseUserPassword=xxxxxxxxxx
OPCodePathAndFileName=login_opcodes_SoD.conf

moltke24
04-27-2014, 02:09 PM
moltke24 make sure your eqemulogin.ini files looks just like this
replace the xxxxx and type in your password
what I think is happening your using the wrong login and your trying to use a newer client then Sof

Port=5999
DumpPacketsIn=false
DumpPacketsOut=false
Trace=false
DatabaseServerName=localhost
DatabaseCatalogName=peqlogindb
DatabaseUserName=root
DatabaseUserPassword=xxxxxxxxxx
OPCodePathAndFileName=login_opcodes_SoD.conf

I looked around and searched for eqemulogin.ini and nothing was found

I searched DumpPacketsIn nothing was found
I searched all of the words in the file you linked and nothing was found. So, i don't think I have this file?

i did find a login.ini that looks like

[database]
host = localhost
port = 3306
db = eqemu
user = user
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.16x.x.

[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

Noport
04-29-2014, 02:25 AM
moltke24
eqemulogin.ini
make sure your DatabaseCatalogName matchs your db = eqemu name in your login.ini

DatabaseCatalogName=eqemu

note: make sure listen_port=5999 same as eqemulogin.ini leave your setting alone in eqemu_config.xml

moltke24
05-28-2014, 12:13 AM
I gave up on this.