EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=586)
-   -   Database confusion (https://www.eqemulator.org/forums/showthread.php?t=37678)

Havok2all 12-31-2013 12:07 AM

Database confusion
 
So I am trying to create my server. I am on my second attempt due to first attempt having DB issues. I am pretty sure it stems from what I am sourcing into my DB. I am confused as to what should or shouldn't go into it when I am building.

The walkthrough says I need to source the SVN and then it says to source load_player. Now I understand I need to be getting the new DB from the new location and I successfully sourced the peqbeta file on my first try, but it had errors.

Restarted and decided to get ask for specifics. Obviously I need to source peqbeta. I would assume I need to source in the source views and user tables as well. I am getting confused at the original walkthrough as it stated I needed to source in a load_player file, but I do not see that file option from the peqbeta zip file.

Can someone tell which files I need to be sourcing to build my database? A list would greatly appreciated. Also, I would like to have bots. Do i need to worry about that now, or can I wait till I get just a basic server going first and come back to that later?

Thank you for your time and assistance.

drakelord 12-31-2013 09:54 AM

Let's start without bots, since adding bots with PEQ is actually harder than it sounds.

Download the latest PEQ database.

Source the peq_2013xxxxx.sql first. Then user_tablesxxxx, and finally source_views.sql.

This will get you a basic server running without bots and mercs. Bots and mercs are disabled on PEQ though, so if you want them, you are gonna have to do some extra work. If you want to go through the trouble, I'll refer you to this post: http://www.eqemulator.org/forums/sho...d.php?p=226602

Havok2all 12-31-2013 04:45 PM

Thanks for the response. I sourced in the files you stated. I also have a sql file called drop_system that was included in the peqbeta zip. Do I need to source that one too?

Havok2all 12-31-2013 07:39 PM

Disregard this post. I solved the issue. Stupidity strikes again.

Havok2all 12-31-2013 08:18 PM

Lol, well I ended up with a crap load of errors. I don't even know where to begin. I am sure my issue lies with building the PEQ database. I used the files suggested in a previous post, but I am concerned that those three aren't enough. I feel like I am missing something that needs to be added to my DB. Every other step I have checked, double checked and then went back and checked again. I followed it step by step exactly until I get to the create the DB step and that's when things get all disjointed.

I don't know what to do from here. Trying to solve all the errors would take longer than starting over, but I probably would end up right where I am again hehe.

joligario 12-31-2013 08:37 PM

The above post looks incorrect/confusing. load_player is now the user_tables. drop_system is used when you want to update the database with a new peqbeta. To do that after you already have a working database, you would source drop_system and then peqbeta. You only use user_tables to start a new database.

To start fresh, use an empty database. Source user_tables_date-time.sql. Then source peqbeta_date-time.sql. Finally, source source_views.sql. If you want to use bots, that is when you would source the bot sql files.

Uleat 12-31-2013 08:43 PM

I just build a new database using those three sql's and haven't seen any issues as yet.

Havok2all 12-31-2013 09:10 PM

Thanks guys for the replies. I'll start a fresh DB tomorrow. Gotta go do that new years thing now. I don't drink anymore, so I should be physically able to give a try tomorrow :)

joligario 12-31-2013 09:28 PM

Quote:

Originally Posted by Uleat (Post 227247)
I just build a new database using those three sql's and haven't seen any issues as yet.

I didn't say there was. Just easiest to follow that order based on the old walk-thru to attempt a match.

Uleat 12-31-2013 10:10 PM

oh, I was agreeing with you :)

Havok2all 01-01-2014 06:58 PM

Ok, so I started from scratch and rebuilt everything just in case. I sourced my PEQ just as joligario stated and it appears from memory to have the same exact errors I had before. It would appear that I am doing the DB correctly, but something else is incorrect.

According to the logs I am getting there are 9 variations of errors, with 4 of the variations having multiple instances.

First error is: crash_world_12764

Next error is: eqemu_debug_zone_1504 (there are about 20 of these with the last 4 digits having different numeric sequences)

Next error is: eqemu_error_world_6928
and eqemu_error_world_12764

Next error is: eqemu_queryserv_14508

Next error is: eqemu_quest_zone_4072 (again there are about 20 of these with the last 4 digits having different numeric sequences)

Next error is: eqemu_shared_memory_16268

Next error is: eqemu_ucs_17956

Next error is: eqemu_zone_1504 (again there are about 20 of these with the last 4 digits having different numeric sequences)

Next error is: zone-dynamic_01 (again there are about 20 of these with the last 2 digits having different numeric sequences)

I am guessing this is all cause from a singular mistake I am making in walkthrough that is in relation to a change of the files locations, but what i am not sure. Any thoughts would greatly be appreciated.

joligario 01-01-2014 07:26 PM

My thought is, what errors? You are going to have several log files with debug messages - that doesn't make them errors.

demonstar55 01-01-2014 07:53 PM

Those are just the logs, are you sure they're giving any meaningful errors in them? (as in not actually critical errors)

Havok2all 01-01-2014 07:54 PM

Ok, I can accept that.

But during the part of the start.bat section of the walkthrough, it says I should see the following windows once I click Start.bat:

C:\EQ\EQEmuServer\world.exe should appear.
C:\EQ\EQEmuServer\eqlaunch.exe
C:\EQ\EQEmuServer\queryserv.exe
C:\EQ\EQEmuServer\ucs.exe

Instead of getting the C:\EQ\EQEmuServer\eqlaunch.exe window I get a:
0: sleeping

And then nothing happens.

Havok2all 01-01-2014 07:57 PM

Quote:

Originally Posted by demonstar55 (Post 227275)
Those are just the logs, are you sure they're giving any meaningful errors in them? (as in not actually critical errors)

Honestly, I am not sure. I really don't know what any of the information is telling me. Looks like a bunch of gobbledigoop to me :P here is a copy and paste from the crash_world_12764 error:

[01.01. - 17:42:01] Starting Log: logs/crash_world_12764.log
[01.01. - 17:42:01] EXCEPTION_BREAKPOINT
[01.01. - 17:42:01] 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: 'XXXX XXXX'
[01.01. - 17:42:01] OS-Version: 6.1.7601 (Service Pack 1) 0x300-0x1
[01.01. - 17:42:02] c:\EQ\EQEmuServer\world.exe:world.exe (01360000), size: 7208960 (result: 0), SymType: 'PDB', PDB: 'c:\EQ\EQEmuServer\world.exe'
[01.01. - 17:42:02] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (77580000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.18247
[01.01. - 17:42:02] C:\Windows\syswow64\kernel32.dll:kernel32.dll (75770000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.18229
[01.01. - 17:42:02] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (75FC0000), size: 290816 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.18229
[01.01. - 17:42:02] C:\Program Files (x86)\Norton 360\NortonData\21.1.0.18\Definitions\BASHDefs\2013 1203.001\UMEngx86.dll:UMEngx86.dll (70A70000), size: 221184 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Norton 360\NortonData\21.1.0.18\Definitions\BASHDefs\2013 1203.001\UMEngx86.dll', fileVersion: 8.1.0.17
[01.01. - 17:42:02] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.3.1204
[01.01. - 17:42:02] C:\Windows\syswow64\USER32.dll:USER32.dll (75550000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514
[01.01. - 17:42:02] C:\Windows\syswow64\GDI32.dll:GDI32.dll (75A90000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.18275
[01.01. - 17:42:02] C:\Windows\syswow64\LPK.dll:LPK.dll (754A0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7601.18177
[01.01. - 17:42:02] C:\Windows\syswow64\USP10.dll:USP10.dll (75260000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.18009
[01.01. - 17:42:02] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (76DA0000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7601.17744
[01.01. - 17:42:02] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (76C70000), size: 655360 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.18247
[01.01. - 17:42:02] C:\Windows\SysWOW64\sechost.dll:sechost.dll (76E90000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (77090000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.18205
[01.01. - 17:42:02] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (74FA0000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.18270
[01.01. - 17:42:02] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (74F90000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_ec8 0f00e8593ece5\COMCTL32.dll:COMCTL32.dll (745F0000), size: 540672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_ec8 0f00e8593ece5\COMCTL32.dll', fileVersion: 5.82.7601.18201
[01.01. - 17:42:02] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (75220000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514
[01.01. - 17:42:02] C:\Windows\syswow64\NSI.dll:NSI.dll (77550000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\VERSION.dll:VERSION.dll (74EC0000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\IMM32.DLL:IMM32.DLL (75880000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514
[01.01. - 17:42:02] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (75B70000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\NLAapi.dll:NLAapi.dll (74AB0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.17761
[01.01. - 17:42:02] C:\Windows\system32\napinsp.dll:napinsp.dll (74AA0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (74A80000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\System32\mswsock.dll:mswsock.dll (74CE0000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.18254
[01.01. - 17:42:02] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (74C40000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17570
[01.01. - 17:42:02] C:\Windows\System32\winrnr.dll:winrnr.dll (74A70000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Program Files (x86)\Bonjour\mdnsNSP.dll:mdnsNSP.dll (16080000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Bonjour\mdnsNSP.dll', fileVersion: 1.0.3.1
[01.01. - 17:42:02] C:\Windows\system32\Iphlpapi.DLL:Iphlpapi.DLL (74D30000), size: 114688 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\Iphlpapi.DLL', fileVersion: 6.1.7601.17514
[01.01. - 17:42:02] C:\Windows\system32\WINNSI.DLL:WINNSI.DLL (74D20000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\WINNSI.DLL', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (74B00000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (74CD0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\uxtheme.dll:uxtheme.dll (70CF0000), size: 524288 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\uxtheme.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\dwmapi.dll:dwmapi.dll (70E30000), size: 77824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dwmapi.dll', fileVersion: 6.1.7600.16385
[01.01. - 17:42:02] C:\Windows\system32\ole32.dll:ole32.dll (75310000), size: 1425408 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\ole32.dll', fileVersion: 6.1.7601.17514
[01.01. - 17:42:02] C:\Windows\syswow64\CLBCatQ.DLL:CLBCatQ.DLL (75CC0000), size: 536576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CLBCatQ.DLL', fileVersion: 2001.12.8530.16385
[01.01. - 17:42:02] C:\Windows\syswow64\OLEAUT32.dll:OLEAUT32.dll (754C0000), size: 585728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\OLEAUT32.dll', fileVersion: 6.1.7601.17676
[01.01. - 17:42:02] C:\Windows\system32\dbghelp.dll:dbghelp.dll (747A0000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514
[01.01. - 17:42:02] f:\dd\vctools\crt_bld\self_x86\crt\src\close.c (47): _close
[01.01. - 17:42:02] c:\eq\source\common\eqstreamfactory.cpp (96): EQStreamFactory::Open
[01.01. - 17:42:02] c:\eq\source\world\net.cpp (365): main
[01.01. - 17:42:02] f:\dd\vctools\crt_bld\self_x86\crt\src\crt0.c (240): __tmainCRTStartup
[01.01. - 17:42:02] f:\dd\vctools\crt_bld\self_x86\crt\src\crt0.c (164): mainCRTStartup
[01.01. - 17:42:02] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 7578336A)
[01.01. - 17:42:02] 7578336A (kernel32): (filename not available): BaseThreadInitThunk
[01.01. - 17:42:02] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 775B9F72)
[01.01. - 17:42:02] 775B9F72 (ntdll): (filename not available): RtlInitializeExceptionChain
[01.01. - 17:42:02] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 775B9F45)
[01.01. - 17:42:02] 775B9F45 (ntdll): (filename not available): RtlInitializeExceptionChain


Lol, none of that means anything to me.


All times are GMT -4. The time now is 09:56 AM.

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