EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   LAN Connect? (https://www.eqemulator.org/forums/showthread.php?t=39483)

Humon 03-18-2015 07:40 AM

LAN Connect?
 
OK im kinda new at the build your own server idea so im trying a LAN only one to start with. So my question is, how do i connect to my server without internet connection? I'm in a place where i don't have access to the internet while i'm working on my server and want to see my mods as i make them.

Any help?

vsab 03-18-2015 11:03 AM

You will need to compile a login server (not sure if Akka's repack has a login server), and point your server to the local login server rather than the default eqemulator one.

Luckily, the login server hardly changes so you can compile the login server and use it with the repack. (I'd recommend using the repack where you can unless you're a developer).

Wiki page for compiling (ignore if the repack has a login server with it)
http://wiki.eqemulator.org/p?Complet...Guide&frm=Main

Wiki page for setting up your config:-
http://wiki.eqemulator.org/p?eqemu_config.xml&frm=Main


Wiki page for setting up the local login server:-

http://wiki.eqemulator.org/p?Windows...Guide&frm=Main

Humon 03-18-2015 11:42 AM

Ok I have done all of that, now my EQ isn't connecting to my server. I got all 4 windows up on the server, is there something I'm missing, how does my EQ program find my server?

vsab 03-18-2015 11:50 AM

Have you changed your eqhost.txt file to point to 127.0.0.1?

Humon 03-18-2015 11:56 AM

Yep, with port 5998.

Humon 03-18-2015 12:04 PM

Of note when i get to the EQ login and put in my account name and password i get, (Error - A timeout occurred). I hope this helps you help me.

vsab 03-18-2015 12:12 PM

Are you using a Titanium client ?

Post your eqemuconfig file with the passwords redacted. Does the login server window show anything of note?

Humon 03-18-2015 12:25 PM

<?xml version="1.0"?>
<server>
<world>
<shortname>EverCrack</shortname>
<longname>ILoveEverCrack</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>127.0.0.1</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="127.0.0.1" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>dasher20nova50timberwolf75warhawk85</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>7778</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>127.0.0.1</host>
<port>3306</port>
<username>Redacted</username>
<password>Redacted</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>Redacted</username>
<password>Redacted</password>
<db>peq</db>
</qsdatabase>

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

Humon 03-18-2015 12:27 PM

As a note just makeing sure, I got world.exe window, queryserv.exe window, ucs.exe window, and eqlaunch.exe window for my server.

vsab 03-18-2015 12:29 PM

you also need a loginserver.exe window ;)

Humon 03-18-2015 12:43 PM

Well the start.bat has loginserver.exe in it and i have the loginserver.exe and .pdb in my EQEmuServer folder. Every time i try to start the loginserver.exe it has 3 items on it and then closes, is that the problem?

Uleat 03-18-2015 08:12 PM

You posted your emu_config.xml file contents..what's in your login.ini?

Humon 03-18-2015 11:06 PM

[database]
host = localhost
port = 3306
db = beq
user = root
password = REDACTED
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.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

Yes i know that i have database set as beq, all instances of my database were changed to beq, would that make a difference.

Humon 03-18-2015 11:09 PM

So i ran the command program and tryed the loginserver.exe just like you say to try the world.exe if your having problems and this is what i got.

c:\EQ\EQEmuServer>loginserver.exe
[Debug] [03.18.15 - 21:00:23] Logging System Init.
[Debug] [03.18.15 - 21:00:23] Config System Init.
[Debug] [03.18.15 - 21:00:23] MySQL Database Init.
[Database] [03.18.15 - 21:00:24] Failed to connect to MySQL database. Error:

This is followed by a lot of vertical lines along the entire page.

I'm going to make a guess and say this is my problem and my question is what did i mess up?

vsab 03-19-2015 03:16 AM

Code:

[Database] [03.18.15 - 21:00:24] Failed to connect to MySQL database. Error:
So...

Code:

[database]
host = localhost
port = 3306
db = beq
user = root
password = REDACTED
subsystem = MySQL

is your database called "peq" (like in your server config) or "beq" (like in your login server config)?

If changing them to match doesn't work, sometimes there are issues with using localhost - try 127.0.0.1 like in the server config file.

Humon 03-19-2015 05:26 AM

Its all beq. Had a problem with the first attempt in building the server and had to start over, and to be on the safe side i changed the database name.

Uleat 03-19-2015 08:26 PM

Yes, what vsab said.

Using 'localhost' in the eqemu_config.xml file doesn't seem to cause issues.

Using that alias in 'login.ini' always seems to cause issues..use '127.0.0.1'

It really hasn't been addressed because so few people use their own login servers and there is no real need for mainstream users.

vsab 03-20-2015 03:07 AM

Quote:

Originally Posted by Uleat (Post 238792)
It really hasn't been addressed because so few people use their own login servers and there is no real need for mainstream users.

I actually suspect that is not true, it seems to be a fairly common use case. When I get time (how many times have I said that? :P ) I will set it up on my laptop and then post a full working set of configs on the wiki.

Humon 03-20-2015 04:01 AM

OK good news. The problem is fixed by changing my login.ini host to 127.0.0.1 and changing the EQEmuAuthCrypto.dll to the x86 version. SO now the log in server stays on and seems to be working fine, it even tells me when im trying to log in once i launch the game, and thats my next problem.

Ok i have followed the guide on the self server and created a few accounts, in the tblloginserveraccounts.frm, even figered out the HidiSql (a lot easier btw) all seems good. Type in user name and password and get hit by User Name/Password not valid. Login Server seems to be working and shows that the User that i logged in as but the next line has Hash: and a long string of numbers and letters. Then it shows that i have disconnected when i close the game.

So what am i doing wrong now?

Uleat 03-20-2015 08:50 PM

The long string is probably a hex dump..been a while since I've seen it..so, not 100% on that.

When you made your accounts, did you manually enter the passwords into the fields?

Humon 03-21-2015 06:06 AM

The first account i made i use MySQL command and typed it the long and hard way (INSERT INTO tblloginserveraccount (etc,etc)), followed by (VALUES (etc,etc)). Then i figered out how to use HidiSQL and made 3 more accounts that way.

Uleat 03-21-2015 01:19 PM

Make sure that your passwords are security hashed..otherwise, the passwords will not match when a login is attempted.

Humon 03-21-2015 02:23 PM

Ok i'm sorry to say I'm not sure what you mean by hashed. I have copied the account name with caps and numbers and password with the same.

So far one thing i have been able to figure out is that the account names are correct so its just the passwords. When i type a account name that's not in my tblloginaccounts table the EQEmu Login Server window gives a [Client Error] of no account.

Any thoughts on that?

Humon 03-21-2015 02:54 PM

Good news I did figure out what you meant by hash. Is there an easier way to know what hash a chosen password will have?

Uleat 03-21-2015 03:18 PM

Ha ha! I don't think I've got the patience to work out a hash manually.

Use this query, replacing name with the Account Name:
Code:

UPDATE `tblloginserveraccounts` SET `AccountPassword` = SHA(`AccountPassword`) WHERE `AccountName` = 'name'
If, for some reason, your passwords were already hashed..you'll need to re-enter them again. That query will "re-hash"
an existing hashed password and make them unusable again.


If you want to play around with the security hash function, use this query:
Code:

SELECT SHA('text');

Humon 03-21-2015 05:10 PM

Cool, you guys helped allot and thanks for the help. Now if only i could figure out why it crashes every time i try to play it. Ill look around and see if anyone has a fix for that or start a new thread.

Thanks again.


All times are GMT -4. The time now is 02:44 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.