Newb setting up Private LAN Server

[mercdady4965]

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]

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]

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

[mercdady4965]

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]

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]

127.0.0.1 means the current machine.

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

[mercdady4965]

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]

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.dllNSAPI.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]

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]

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]

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]

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]

spells_new would be the one we are interested in.

[mercdady4965]

How can I help?

[Scorpious2k]

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

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.