EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Newb setting up Private LAN Server (https://www.eqemulator.org/forums/showthread.php?t=38618)

mercdady4965 08-15-2014 12:45 PM

Newb setting up Private LAN Server
 
Hello. I will begin by saying I have been all over these forums correcting problems with my server. Great Job! You guys are great.

My intentions are to have a Private LAN Server for three computers. The desktop I am working on and two laptops.

I have followed this guide. http://wiki.eqemulator.org/p?Complet...Guide&frm=Main. Very helpful.

Also this one for Private server. http://wiki.eqemulator.org/p?Windows...Guide&frm=Main.

After running my Start.bat I get 5 cmd prompt windows.

1. EQEmu login server - No errors. Last line states Server Started.
2. World.exe - No errors. using database 'peq' at 127.0.0.1
3. Queryserv.exe - No errors. using database 'peq' at 127.0.0.1
4. Ucs.exe - No errors. using database 'peq' at 127.0.0.1
5. EQLaunch.exe - No text.

At this point I have assumed that everything is working correctly. I have no true idea of what I am looking for. I also have XAMPP Control panel(running Mysql) and HeidiSQL running.

I am using Everquest Titanium. When I start my EQ shortcut( pointing to eqgame.exe"patchme -w) I am allowed to enter a username and password, but they are rejected as incorrect.

Here is my Login.ini:

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

[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


Here is my EQEmu-config.xml:

<?xml version="1.0"?>
<server>
<world>
<shortname>Dragon</shortname>
<longname>Dragon's Rest</longname>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>root</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>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>192.168.1.3</host>
<port>10234</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>192.168.1.3</host>
<port>10234</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>root</username>
<password>****</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>****</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>


Is there any other info I can give?

Thank you.


I decided to try making another account to try using this method.

Step 5: Create a login account.
You now have the required database tables, but they are empty and so no one will be able to log in yet. Open up either HeidiSQL or just do this in the mysql prompt:-
?
1
2
INSERT INTO tblloginserveraccounts (AccountName,AccountPassword,AccountEmail,LastIPAd dress,LastLoginDate)
VALUES ('your_account_name',sha('your_password'),'me@me.c om','127.0.0.1','2014-01-01 00:00:01');
Changing 'your_account_nam'e to the name of the account you wish to create, 'your_password' to the password you want to use. Of course, you can create as many accounts as you like this way.
I get an error saying peq.tblloginserveraccounts doesn't exist.

Thank you again.

mercdady4965 08-15-2014 05:11 PM

I managed to repair my problems. I am able to login to my server now. No servers in server window tho. And I get a 0 of 0 expansions note.

Uleat 08-15-2014 05:31 PM

Do you have any messages/logs with world/zone server connectivity issues or getting the two laptops to connect to your login server?

mercdady4965 08-15-2014 06:00 PM

I have found these in a crash_shared_memory log

[08.15. - 18:00:33] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 758E338A)
[08.15. - 18:00:33] 758E338A (kernel32): (filename not available): BaseThreadInitThunk
[08.15. - 18:00:33] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77EA9F72)
[08.15. - 18:00:33] 77EA9F72 (ntdll): (filename not available): RtlInitializeExceptionChain
[08.15. - 18:00:33] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77EA9F45)
[08.15. - 18:00:33] 77EA9F45 (ntdll): (filename not available): RtlInitializeExceptionChain

I'll continue to look for world or zone logs. i just wanted to respond fast.

mercdady4965 08-15-2014 07:24 PM

It was a no go on the 1st laptop ("a connection to the server could not be reached"). I'm not sure I have the eqhost pointing to the right place. 127.0.0.1:5998?
I haven't tried the 2nd.

Thank you for the response.


CORRECTION: The 1st laptop now navigates to the server list which is still blank and shows a "0 of 0 expansions owned."

lerxst2112 08-16-2014 03:29 PM

127.0.0.1 means the current machine.

You want to use the real ip address, probably 192.168.1.something.

mercdady4965 08-16-2014 06:12 PM

Thank you for the info on changing the laptop eqhost. If I decide to log on from the desktop that holds the server, pointing to 127.0.0.1 would be correct?

Desktop holds server and client. Looks to itself(127.0.0.1) to play.

Laptops hold client only and look to desktop(192.168.1.something) to play.

mercdady4965 08-16-2014 06:42 PM

I found this error in the Logs. Something to do with spells i think.

---------------------------------------------
[08.16. - 18:38:18] Starting Log: logs/crash_shared_memory_28420.log
[08.16. - 18:38:18] EXCEPTION_ACCESS_VIOLATION
[08.16. - 18:38:18] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEmuServer;C:\EQ\EQEmuServer;C:\Windows; C:\Windows\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Melinda'
[08.16. - 18:38:18] OS-Version: 6.1.7601 (Service Pack 1) 0x300-0x1
[08.16. - 18:38:19] C:\EQ\EQEmuServer\shared_memory.exe:shared_memory. exe (00300000), size: 4894720 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\shared_memory.exe'
[08.16. - 18:38:19] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (77E70000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.18247
[08.16. - 18:38:19] C:\Windows\syswow64\kernel32.dll:kernel32.dll (758D0000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.18409
[08.16. - 18:38:19] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (75BA0000), size: 290816 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.18409
[08.16. - 18:38:19] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (77390000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514
[08.16. - 18:38:19] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (774F0000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7601.17744
[08.16. - 18:38:19] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (777C0000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.18532
[08.16. - 18:38:19] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (75870000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.18496
[08.16. - 18:38:19] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (75860000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\SysWOW64\sechost.dll:sechost.dll (762C0000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\syswow64\NSI.dll:NSI.dll (76110000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\system32\VERSION.dll:VERSION.dll (75740000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\syswow64\USER32.dll:USER32.dll (76190000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514
[08.16. - 18:38:19] C:\Windows\syswow64\GDI32.dll:GDI32.dll (77460000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.18539
[08.16. - 18:38:19] C:\Windows\syswow64\LPK.dll:LPK.dll (76120000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7601.18177
[08.16. - 18:38:19] C:\Windows\syswow64\USP10.dll:USP10.dll (76690000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.18454
[08.16. - 18:38:19] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (76070000), size: 655360 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.18247
[08.16. - 18:38:19] C:\Windows\system32\IMM32.DLL:IMM32.DLL (776C0000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514
[08.16. - 18:38:19] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (75DB0000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\system32\NLAapi.dll:NLAapi.dll (71190000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.17761
[08.16. - 18:38:19] C:\Windows\system32\napinsp.dll:napinsp.dll (70FB0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (70F60000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\System32\mswsock.dll:mswsock.dll (710E0000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.18254
[08.16. - 18:38:19] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (74990000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17570
[08.16. - 18:38:19] C:\Windows\System32\winrnr.dll:winrnr.dll (70F50000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL:WLIDNSP.DLL (70FD0000), size: 147456 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL', fileVersion: 6.500.3165.0
[08.16. - 18:38:19] C:\Windows\syswow64\PSAPI.DLL:PSAPI.DLL (75B90000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\PSAPI.DLL', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\syswow64\SHLWAPI.dll:SHLWAPI.dll (76600000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHLWAPI.dll', fileVersion: 6.1.7601.17514
[08.16. - 18:38:19] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (70FC0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (710D0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385
[08.16. - 18:38:19] C:\Windows\system32\dbghelp.dll:dbghelp.dll (6FDE0000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514
[08.16. - 18:38:19] f:\dd\vctools\crt\crtw32\convert\atof.c (59): _atof_l
[08.16. - 18:38:19] f:\dd\vctools\crt\crtw32\convert\atof.c (71): atof
[08.16. - 18:38:19] c:\eq\source\common\shareddb.cpp (1760): SharedDatabase::LoadSpells
[08.16. - 18:38:19] c:\eq\source\shared_memory\spells.cpp (41): LoadSpells
[08.16. - 18:38:19] c:\eq\source\shared_memory\main.cpp (154): main
[08.16. - 18:38:19] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup
[08.16. - 18:38:19] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup
[08.16. - 18:38:19] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 758E338A)
[08.16. - 18:38:19] 758E338A (kernel32): (filename not available): BaseThreadInitThunk
[08.16. - 18:38:19] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77EA9F72)
[08.16. - 18:38:19] 77EA9F72 (ntdll): (filename not available): RtlInitializeExceptionChain
[08.16. - 18:38:19] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77EA9F45)
[08.16. - 18:38:19] 77EA9F45 (ntdll): (filename not available): RtlInitializeExceptionChain

Scorpious2k 08-16-2014 09:21 PM

Wild guess here, but I think your shared memory step in your batch file is failing because of a problem with your spells table in your DB.

Try running JUST shared_memory.exe in a command prompt (in your server directory). See what it says.

mercdady4965 08-16-2014 10:35 PM

The crash starts after [Status] Loading spells...

[Crash] Starting Log: logs/crash_shared_memory_31292.log

Then gives what appears to be the same above error.

Scorpious2k 08-16-2014 11:19 PM

So we have an empty spells table or it isn't compatible with the version of the server you are running. Check to see if it is empty. If it isn't we need to check which version it is compared to the server version.

mercdady4965 08-17-2014 11:41 AM

I'm not sure how to check for an empty spells table or my current version atm. I'll search for some info and get back to you. Thank you.


NOTE: After some digging in HeidiSQL under my peq database I find 2 entries for spells.

Name Rows Size Created Updated Engine Type

1: spells_new 28,275 13.5 MiB 2014-08-14 21:22:57 2014-08-14 22:38:56 MyISAM Table
2: spells_globals 0 1.0 KiB 2014-08-14 21:24:16 2014-08-14 21:24:16 MyISAM Table

Does this indicate the tables I'm looking for? The "globals" doesn't seem to be very large. Could this be an issue? I'm really fumbling in the dark here. I take direction pretty well tho. lol

Scorpious2k 08-17-2014 01:45 PM

spells_new would be the one we are interested in.

mercdady4965 08-17-2014 02:06 PM

How can I help?

Scorpious2k 08-17-2014 05:32 PM

I don't know how well you know HeidiSQL... in the left column click the table named spells_new (you may have to expand the DB first)

Select the tab named Query at the top. and enter
Code:

select count(id) from spells_new;
in the top text box. In the toolbar above it you will see a "play" icon which says Execute SQL when you hold the cursor over it.

click it. The number of rows in the spells_new table will appear in the text box beneath it.

mercdady4965 08-17-2014 06:02 PM

It shows 28275.

FYI I can follow instructions. I do not "know" HeidiSQL. lol
Thank you.

Scorpious2k 08-17-2014 07:53 PM

Well, I didn't want to be insulting by giving too detailed instructions.

I'd say that's greater than zero... so it's probably a compatibility problem. What date did you download the source code you compiled and what is the date on the DB you downloaded?

mercdady4965 08-17-2014 08:20 PM

Downloaded on 8-15 2014.

This is the download peqbeta_2014-08-11-02-01.tar.gz
I had downloaded an earlier version 1st. Had issues and thought "resourcing" the new one might work. I'm not positive on the terminology. Sorry I haven't thought to mention this yet. It's been a very confusing week with little sleep. heh.

Scorpious2k 08-17-2014 10:14 PM

From the change log:

Code:

== 08/02/2014 ==
Kayen: Implemented spell_news fields
- npc_no_los (check if LOS is required for spells)
- InCombat, OutofCombat - Used together to restrict spells to only be cast while
in/out of combat (beneficial) or if target is in/out of combat (detrimental).
-min_dist, min_dist_mod, max_dist, max_dist_mod - Scales spell power based on targets distance from caster.
*This will require further work to fully implement but will work with 90% of live spells as is.
*If making custom spells do not include effects that can't be scaled (like a spell trigger)
- min_rage sets minimum distance range that must be away from target.

Required SQL: utils/sql/git/required/2014_08_02_spells_new.sql

So find the file utils/sql/git/required/2014_08_02_spells_new.sql, source it in , and see if that fixes it.

mercdady4965 08-17-2014 10:56 PM

Awesome! That fixed that. Now I see
3 windows now show "using database 'peq' at 127.0.0.1:3306". world.exe, queryserv.exe and ucs.exe.
1 window shows 0: sleeping.
I tried to log on with this and another comp and got "A connection to the server could not be reached".

Thank You! You have been a huge help.

EDIT: I found a eqemuauthcrypto error. A missing dll I think. Installing that in the right place solved the above problem.

Now I see 5 windows:

Login Server - Server started
World.exe - using database peq
Queryserv.exe - using database peq
ucs.exe - using database peq
0: Sleeping

I can login to the server screen, but there are no servers seen. "0 of 0 expansions owned" message.

mercdady4965 08-18-2014 01:36 AM

Searching through the logs I have found this:
[Debug] [08.18.14 - 01:37:48] Logging System Init.
[Debug] [08.18.14 - 01:37:48] Config System Init.
[Debug] [08.18.14 - 01:37:48] MySQL Database Init.
[Debug] [08.18.14 - 01:37:48] Encryption Initialize.
[Debug] [08.18.14 - 01:37:48] Encryption Loaded Successfully.
[Debug] [08.18.14 - 01:37:48] Server Manager Initialize.
[Network] [08.18.14 - 01:37:48] ServerManager listening on port 5998
[Debug] [08.18.14 - 01:37:48] Client Manager Initialize.
[Network] [08.18.14 - 01:37:48] ClientManager listening on Titanium stream.
[Network] [08.18.14 - 01:37:48] ClientManager listening on SoD stream.
[Debug] [08.18.14 - 01:37:48] Server Started.
[Network] [08.18.14 - 01:37:48] New world server connection from 127.0.0.1:50171
[Network Error] [08.18.14 - 01:37:48] Handle_NewLSInfo error, remote address was null, defaulting to stream address 127.0.0.1.
[Database] [08.18.14 - 01:37:48] Mysql query returned no result: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Dragon'
[World] [08.18.14 - 01:37:48] Server Dragon's Rest(Dragon) attempted to log in but database couldn't find an entry and only registered servers are allowed.

I think we are real close on this one. : )

mercdady4965 08-18-2014 09:00 AM

I found some lines in eqemu_config.xml that needed to be uncommented.

I believe this is correct now:

<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>


And here's my example of "Go home and do it again"... :)

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

I have now moved on to another error:
Mysql query returned no results:

Server Dragon's Rest(Dragon) attempted to login but database couldn't find an entry and only registered servers are allowed.
World server disconnected from the server, removing server and freeing connection.

mercdady4965 08-18-2014 10:42 AM

I have changed this:

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>root</account>
<password>****</password>
</loginserver>

to this:

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

I took out a account and password that shouldn't have been there.

I can now log onto my server, but there are no NPCs around.

mercdady4965 08-18-2014 12:04 PM

I found my NPC solution here:

http://www.eqemulator.org/forums/sho...ighlight=zones

Now on to my laptops. I'm getting a 1017 error when connecting to server. "cannot login to the everquest server. You need to re-run the update patch.

This is the coolest thing ever.

Scorpious2k 08-18-2014 02:12 PM

Quote:

Originally Posted by mercdady4965 (Post 233059)
I found my NPC solution here:

http://www.eqemulator.org/forums/sho...ighlight=zones

Now on to my laptops. I'm getting a 1017 error when connecting to server. "cannot login to the everquest server. You need to re-run the update patch.

This is the coolest thing ever.

You've made a lot of progress on your own. This one seems to be a step backwards. Did you change something besides the SQL fix for the NPC problem? Port forward change? Has it only worked on the same computer that the server is running on?

Uleat 08-18-2014 02:42 PM

Lerxst posted here.. http://www.eqemulator.org/forums/sho...01&postcount=6

..about your ip address..though, there were probably enough other issues that it was missed or misunderstood.


For a solo machine, meaning ALL activities occur on the one computer, "127.0.0.1" is fine to use.


If you intend to allow any outside connections, you will need to use the address of your NIC card.

It is best to ensure that the computer 'hosting' the server is set to a 'static' address and not a DHCP one, or the host will be on a different address
every time it, or the network, is rebooted.

Even better, if your router allows you to reserve a single IP address for the MAC address of your NIC card, do this and you can leave the assignment
protocol alone.


In changing your config files...

If your database is on the same computer as your server, then leave it set to "127.0.0.1"

Otherwise, all settings that reflect "127.0.0.1" will need to be changed to that of your NIC's IP address (as lerxst stated, "192.168.x.x")

Your [Login.ini][options] local_network will also need to be updated ("192.168.x.")


For eqhost.txt...

All connecting clients will need to change their host address to the new address..including the one running on the host server.


Lastly...

Instead of trying to fix everything that I just broke, it would probably be a good idea to make backups of the two config files before starting :)

mercdady4965 08-18-2014 03:00 PM

At the moment I have 3 accounts that can log in, create a character and level. 2 are flagged GM, the other not. This is all done from the "server" desktop. On the laptop I see the server, but get this patch message.

The EQEmu Login Server shows a Network Error - Recieved unhandled application packet from the client: [OpCode OP_Unknown (0x0012) Size=10].

mercdady4965 08-18-2014 04:42 PM

Thank you, Uleat! I appreciate the help. Definitely have my head spinning. I will try to implement it and get back to you.

By the by, your avatar was kinda creepy to begin with, but after seeing it a few dozen time I think you just need some sleep. lol

mercdady4965 08-20-2014 09:15 AM

Could this be a casr of something important(EQ) not being shared on my network? I'm on the server, but my other comps on LAN can't connect.

Uleat 08-20-2014 05:57 PM

Repost your config files and let's see where I led you astray :)


Have they ever connected and just can't now, or still a no-go from the start?


EDIT: You did create accounts for them, right?

mercdady4965 08-22-2014 09:24 AM

UPDATE: Everything is working Great! 2 laptops and 1 desktop playing EQ at once. You obviously led me down the correct path. Thank you both for all the help.

Scorpious2k 08-22-2014 10:17 AM

You're welcome and glad to know all is well.


All times are GMT -4. The time now is 11:06 PM.

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