Database confusion

[Havok2all]

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]

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/showthread.php?p=226602

[Havok2all]

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]

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

[Havok2all]

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]

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]

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

[Havok2all]

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]

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]

oh, I was agreeing with you :)

[Havok2all]

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]

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

[demonstar55]

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

[Havok2all]

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]

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.

[demonstar55]

To make stuff less mystical, zone-dynamic_##.log are from each dynamic zone (sounds like you have about 20 of them, you can change this in the DB, testing wise you won't need more than 5, actually server you might need more)

The rest of the numbers are PIDs

eqemu_<executable>_<PID>.log are the logs for that executable (zone, world, ucs, etc)

eqemu_quest_zone_<PID>.log is for that zone's quests

eqemu_debug_zone_<PID>.log are just debug statements, this is mostly to help you debug whats going on.

eqemu_error_<executable>_<PID>.log is error messages from the executable, these can sometimes be fatal or not.

crash_ etc is from a crash.

So I guess look at the crash and error files to see whats going on, you might need to reference one of the other logs to get the full picture.

[Havok2all]

Ok, so I went through all of the files and it appears many of them are just detailing in the logs what is occuring during start up, and are not really errors. I guess I made too much of an assumption in reading the walkthrough that it was logging only errors. My mistake.

I did find a couple of the logs stating:

Could not load EQTime file eqtime.cfg

These are found in the eqemu_error_world logs. Any idea what is causing this?

[demonstar55]

You need to move the eqtime.cfg form the DB archive into the root server folder.

[Havok2all]

Ok, thanks demonstar55, that corrected that error, but I am still getting the same end result. When I do the start.bat, the 4th window just states 0:sleeping and nothing happens. All the other windows state:

Using database 'peq' at 127.0.0.1:3306

0:sleeping window is all blank.

[joligario]

What are you expecting to see that you aren't?

[Havok2all]

According to the walkthrough, I should see 4 windows after clicking start.bat:

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

I have all of them except C:\EQ\EQEmuServer\eqlaunch.exe. Instead the 4th window says 0: sleeping. I guess i am expecting to see the fourth window say C:\EQ\EQEmuServer\eqlaunch.exe?

[Uleat]

'0: sleeping' is eqlaunch. It 'silently' starts/stops zone processes based on settings.

Have you tried to actually log in yet?

It's not uncommon to see 'errors' in the logs due to the way messages are generated and the level of client version support.

[Havok2all]

I'm sorry Uleat, I stepped away a bit. First time I started the server I didn't see my server, but tried again and it was there. Think I just missed it the first time I looked. Then I created a character and started trying things and forgot to come back and update.


Thanks so much to everyone who helped me get this working. You guys rock!

[Havok2all]

Ok, so I got my server working and so far everything seems to be working ok.

I wanted to get bots working on my server. I have attempted to use the walkthrough from here http://www.eqemulator.org/forums/showthread.php?t=37295 , but it is not working for me.

When I attempt to use the commands in Mysql like:

UPDATE `npc_types` SET `class` = 71 WHERE `lastname` LIKE '%Mercenary Liaison%';

DELETE FROM `rule_values` WHERE `rule_name` LIKE '%bot%';

UPDATE `rule_values` SET `rule_value` = 'true' WHERE `rule_name` = 'Mercs:AllowMercs';

Mysql tells me unknown column in where clause for bots and mercs. I am not really concerned about mercs, but would like to get bots working. Any help would be appreciated.

[drakelord]

Probably a silly question, but did you remember to set your database before you ran the query? (IE: use peq; )

If it's still not working, you can use a program like HeidiSQL to pull up the database and run the query from there. If it still doesn't work, well, someone would probably actually need to see your database structures.

[Havok2all]

I think i got them working, although I did not use UPDATE or DELETE commands. So far, so good. They seem to be working correctly.