using peqdb_rev1549.sql with EQEmuLoginServer

[eski2]

Is the EQEmuLoginServer and EQEmu-Rev1535.zip you download from http://code.google.com/p/projecteqemu/downloads/list compatible with peqdb_rev1549.sql (which from memory i got by following the wiki) or should i dump that database and use another one (but i can't see another to use?)

I am starting again with a clean system, when i sourced the db it didn't give me any errors and i'm getting up to the point of creating a new character with my Sof client. I'm just worried about the log below; it looks like the items are wrong for some reason.


[Debug] Starting Log: logs/eqemu_debug_world_2204.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver 127.0.0.1:5998
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_2204.log
[Status] Using database 'peq' at 127.0.0.1:3306
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=83375
[Error] Starting Log: logs/eqemu_error_world_2204.log
[Error] DBLoadItems query 'select source,`itemclass`,`name`,`lore`,`idfile`,`id`
,`weight`,`norent`,`nodrop`,`size`,`slots`,`price` ,`icon`,`UNK012`,`UNK013`,`ben
efitflag`,`tradeskills`,`cr`,`dr`,`pr`,`mr`,`fr`,` astr`,`asta`,`aagi`,`adex`,`ac
ha`,`aint`,`awis`,`hp`,`mana`,`ac`,`deity`,`skillm odvalue`,`UNK033`,`skillmodtyp
e`,`banedmgrace`,`banedmgamt`,`banedmgbody`,`magic `,`casttime_`,`reqlevel`,`bard
type`,`bardvalue`,`light`,`delay`,`reclevel`,`recs kill`,`elemdmgtype`,`elemdmgam
t`,`range`,`damage`,`color`,`classes`,`races`,`UNK 054`,`maxcharges`,`itemtype`,`
material`,`sellrate`,`UNK059`,`casttime`,`UNK061`, `procrate`,`combateffects`,`sh
ielding`,`stunresist`,`strikethrough`,`extradmgski ll`,`extradmgamt`,`spellshield
`,`avoidance`,`accuracy`,`charmfileid`,`factionmod 1`,`factionmod2`,`factionmod3`
,`factionmod4`,`factionamt1`,`factionamt2`,`factio namt3`,`factionamt4`,`charmfil
e`,`augtype`,`augslot1type`,`augslot1visible`,`aug slot2type`,`augslot2visible`,`
augslot3type`,`augslot3visible`,`augslot4type`,`au gslot4visible`,`augslot5type`,
`augslot5visible`,`ldontheme`,`ldonprice`,`ldonsol d`,`bagtype`,`bagslots`,`bagsi
ze`,`bagwr`,`book`,`booktype`,`filename`,`banedmgr aceamt`,`augrestrict`,`loregro
up`,`pendingloreflag`,`artifactflag`,`summonedflag `,`favor`,`fvnodrop`,`endur`,`
dotshielding`,`attack`,`regen`,`manaregen`,`endura nceregen`,`haste`,`damageshiel
d`,`recastdelay`,`recasttype`,`guildfavor`,`augdis tiller`,`UNK123`,`UNK124`,`att
uneable`,`nopet`,`UNK127`,`pointtype`,`potionbelt` ,`potionbeltslots`,`stacksize`
,`notransfer`,`stackable`,`UNK134`,`clickeffect`,` clicktype`,`clicklevel`,`click
level2`,`proceffect`,`proctype`,`proclevel`,`procl evel2`,`worneffect`,`worntype`
,`wornlevel`,`wornlevel2`,`focuseffect`,`focustype `,`focuslevel`,`focuslevel2`,`
scrolleffect`,`scrolltype`,`scrolllevel`,`scrollle vel2`,`svcorruption`,`purity`,
`backstabdmg`,`dsmitigation`,`heroic_str`,`heroic_ int`,`heroic_wis`,`heroic_agi`
,`heroic_dex`,`heroic_sta`,`heroic_cha`,`heroic_mr `,`heroic_fr`,`heroic_cr`,`her
oic_dr`,`heroic_pr`,`heroic_svcorrup`,`healamt`,`s pelldmg`,updated from items or
der by id', #1054: Unknown column 'UNK061' in 'field list'
[Error] If you got boat loads of errors, make sure you sourced all sql updates!

Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Debug] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading EQ time of day..
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Loading adventures...
[Debug] [WORLD__INIT] Purging expired instances
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server: 127.0.0.1:5998
[Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5998
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1132
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1132
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.

[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.

[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)

[joligario]

http://code.google.com/p/projecteqdb/downloads/detail?name=peqdatabase-Rev1535.zip

[eski2]

Not Found
The requested URL /p/projecteqdb/downloads/detail?name=peqdatabase-Rev1535.zip was not found on this server.

[eski2]

maybe it was removed accidentally or someone thought the EQEmu-Rev you download is more recent than it is?

[joligario]

Ah, you're right. He deletes the zip files. Looks like you're better off compiling your own then.

[eski2]

ah no!! I couldn't get it working even this far when i did that :(

[joligario]

Well, its either that or modify your database to revert 1542 and 1548

[eski2]

(*sobs quietly*) but when i built my own, they wouldn't even talk to each other! (*parp*). I'm using the same xml and ini files as before (ok, i changed the world name) but back then i was getting this http://www.eqemulator.org/forums/showthread.php?t=31529

I don't suppose you can post a working build that you know works with that db?

[eski2]

he said redundantly, ah well, better get sleep, 3.13 am

[Tharkun]

there are some pre-packed binaries and DB's floating around. AX Classic come to mind. You may want to see if that has what your looking for.

[eski2]

My understanding of the axclassic is that it doesn't support that db, and that the db for axclassic is focused on classic zones only, but if i can't get this sorted out soon i'll have to use that anyway. I'd love to use the current peq db, the changes sound very exciting. I'll have another go with the files i compiled before.

[trevius]

Compiling your binaries isn't too bad and we have a decent guide for it here:

http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008

[eski2]

I followed that guide before and found the executables weren't connecting to the database. At the time i thought it must be my ini or xml files, but they were working with the downloaded binaries fine.

Using the compiled binaries, i get[Debug] [06.28.10 - 19:10:48] Logging System Init.
[Debug] [06.28.10 - 19:10:48] Config System Init.
[Debug] [06.28.10 - 19:10:48] MySQL Database Init.
[Debug] [06.28.10 - 19:10:48] Encryption Initialize.
[Debug] [06.28.10 - 19:10:48] Encryption Loaded Successfully.
[Debug] [06.28.10 - 19:10:48] Server Manager Initialize.
[Network] [06.28.10 - 19:10:48] ServerManager listening on port 5998
[Debug] [06.28.10 - 19:10:48] Client Manager Initialize.
[Network] [06.28.10 - 19:10:48] ClientManager listening on Titanium stream.
[Network] [06.28.10 - 19:10:48] ClientManager listening on SoD stream.
[Debug] [06.28.10 - 19:10:48] Server Started.
[Network] [06.28.10 - 19:10:55] New world server connection from 127.0.0.1:1283
[Database] [06.28.10 - 19:10:55] Mysql query failed: SELECT WSR.ServerID, WSR.Se
rverTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeD
escription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblSer
verListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.Serv
erLongName = 'soloman' AND WSR.ServerShortName = 'soloman'
[World] [06.28.10 - 19:10:55] Server soloman(soloman) attempted to log in but da
tabase couldn't find an entry but unregistered servers are allowed.
[Database] [06.28.10 - 19:10:55] Mysql query failed: SELECT max(ServerID) FROM t
blWorldServerRegistration
[Database] [06.28.10 - 19:10:55] Mysql query failed: UPDATE tblWorldServerRegist
ration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where Ser
verID = 0
[Network] [06.28.10 - 19:11:58] New Titanium client connection from 127.0.0.1:12
95
[Network] [06.28.10 - 19:11:58] Application packet recieved from client (size 14
)
[Network] [06.28.10 - 19:11:58] Session ready recieved from client.
[Network] [06.28.10 - 19:11:59] Application packet recieved from client (size 28
)
[Network] [06.28.10 - 19:11:59] Login recieved from client.
[Client] [06.28.10 - 19:11:59] User: Eski
[Client] [06.28.10 - 19:11:59] Hash: bdf454a5f43b1ef5751a6a56f615f59a2868d110
[Database] [06.28.10 - 19:11:59] Mysql query failed: SELECT LoginServerID, Accou
ntPassword FROM tblLoginServerAccounts WHERE AccountName = 'Eski'
[Client Error] [06.28.10 - 19:11:59] Error logging in, user Eski does not exist
in the database.
[Network] [06.28.10 - 19:12:06] Client disconnected from the server, removing cl
ient.
[Network] [06.28.10 - 19:12:06] New Titanium client connection from 127.0.0.1:12
96
[Network] [06.28.10 - 19:12:06] Application packet recieved from client (size 14
)
[Network] [06.28.10 - 19:12:06] Session ready recieved from client.
[Network] [06.28.10 - 19:12:07] Application packet recieved from client (size 28
)
[Network] [06.28.10 - 19:12:07] Login recieved from client.
[Client] [06.28.10 - 19:12:07] User: Eski
[Client] [06.28.10 - 19:12:07] Hash: bdf454a5f43b1ef5751a6a56f615f59a2868d110
[Database] [06.28.10 - 19:12:07] Mysql query failed: SELECT LoginServerID, Accou
ntPassword FROM tblLoginServerAccounts WHERE AccountName = 'Eski'
[Client Error] [06.28.10 - 19:12:07] Error logging in, user Eski does not exist
in the database.
[Network] [06.28.10 - 19:12:08] Client disconnected from the server, removing cl
ient.


I don't know why it seems blind to the server name and to the account names.

[eski2]

Oh well, been working on this for a while and i'm going in circles, time to give up and move on. One suggestion might be to make a bundled package with everything in it, including a generator for the ini files, so that there's no fiddling with the passwords or world names or port numbers or what have you, i can kind of see how to do it in vb.net except for the encryption bit that is used to insert a password into tblloginserveraccounts.

Thanks for your help guys and good luck with this project!

[trevius]

Oh well, been working on this for a while and i'm going in circles, time to give up and move on. One suggestion might be to make a bundled package with everything in it, including a generator for the ini files, so that there's no fiddling with the passwords or world names or port numbers or what have you, i can kind of see how to do it in vb.net except for the encryption bit that is used to insert a password into tblloginserveraccounts.

Thanks for your help guys and good luck with this project!

You mean like this?:

http://www.eqemulator.org/forums/showthread.php?t=28190

[eski2]

Pretty much, except a version which works with the peq db, whereas that one doesn't as far as i can see, can't find the url right now but i did read that it was incompatible with the current peq db without recompiling.

If I was a better programmer i could probably do it myself, but i'm just a novice vb.net guy, green enough to disappear when i lie on a lawn :)

[GeorgeS]

I have a database rev_1496 that works with binaries from 1316_BOTS for SOF
If you want that for testing then I'll upload it later today.
It has all tables for SOD, and is about 99% ready for SOD, but like I said, works well with SOF. Comes with accounts and characters
Use account id# 999 that has account name eq, password eq

GeorgeS

[eski2]

That sounds great GeorgeS, i really better do some work for the next few days but i will gladly take you up on that offer! Would that be on your website when it's uploaded?

btw, quick question, does your diablo thingie work with the AX Classic db package or is that incompatible? I am not sure how everything works yet :P

Thanks for your help!!

[naveed]

i guess i ran into the same issue and was using the same emu, db and i logged into my server with no items. SO i guess this DB rev 1496 would fix the items not loading with 1549 client?

[GeorgeS]

A database for SOF - all ready to source and play

Ok Ive saved the sql now and added the 1316 binaries along with the ini files prefilled in - just about everything except the maps and quests stuff. In essence everything needed to get SOF going (use eq/eq account when login in the client to play):D

It's uploaded to Rogeans FTP site -
http://www.georgestools.eqemulator.net/
on top of page--


I'll make you all a deal - if you get it working with SOD, then you should save the db as I have and make it available for others along with the loginserver Binary and associated .ini files as I have. The goal would be to deliver this as a complete SOD package..

Regarding anyone trying to get SOD with this db
It has the tables for SOD prefilled so the loginserver connects, but I could never get passed the SOD authentication step.

The password for my SOD account is administrator/administrator and for SOF, it's eq/eq

GeorgeS

[eski2]

I'm not going to get time to test this properly for a few days at least but just to check, the plugins don't have to be updated with files from the svn?

I was thinking maybe i should setup a torrent?

I suspect I'm out of my depth with getting it to work with SoD if it's stymied you but will do my best.

[eski2]

I saw some error messages but they scrolled off screen, and HeidiSQL complained about an improperly formed foreign key. Does the peq db or any other db need to exist first for this script to work? Is there a log file somewhere so I can find exactly what the error was?

Last errors were:

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1146 (42S02): Table 'peq_1496.botgroup' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1449 (HY000): There is no 'eq'@'%' registered
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.03 sec)

ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of '
NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of
'NULL'
Query OK, 0 rows affected (0.00 sec)

ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of
'NULL'
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of
'NULL'
mysql>

[eski2]

rats, getting
[Debug] Starting Log: logs/eqemu_debug_3224.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1
:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

I've tried with firewall and without.

[robinreg]

I think I have a copy of peqdb-rev1535. I have a bunch of archived compiled emu and db in my backup folder in case I need to revert back. I could send the copy of it through the email. You can send me a pm on where you want me to send the copy to.

[naveed]

i found a DB rev 1265 that works with this 1549 client, would be better to get this rev 1535db out though....why it is not more easy to find is baffling to me.
Thanks robin!

[joligario]

If you still need updated binaries, I have the latest (r1580). Be warned, I use Perl 5.10.1. If you still want to try, you can download 1580 binaries (http://jeremiah.oligario.us/uploads/eqemu_1580_binaries.rar). Notice I also included the required sql (1562.sql) that will need to be applied to the 1549 database. I will leave the files on the site for a couple of days.

[GeorgeS]

Ok I reuploaded the entire pack again, but this time using ansi sql, so it will definitely work as I just tried it.

Here's how to source the database
(0) Extract the RAR to a folder - say on desktop called eqemu
(1) Find your mysql user and password (mine was eq/eq) when you set up mysql
(2) in your new folder called eqemu, edit the LOAD.BAT, and enter your mysql credentials (mine is eq/eq)
-u is the user name, and -p is the password. Save the file
(3) Execute load.bat. This opens a DOS like mysql box and sources the database. It takes a while (~10mins). Wait till the box disappears.
(4) Your new database is now called "peq_1496" and you can now enter your mysql credentials at the bottom of the file:eqemu_config.xml file
i.e replace eq/eq with your info - see the example below. Save the file

<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>peq_1496</db>
</database>


(5) run START.BAT to begin loading the minilogin server. Hopefully it works and loads correctly.

This is for loading the server. For starting the game, I presume you know the next steps. When you start the client, everquest asks for a user name. I used the same login eq/eq just to make it simple. There it will load in my characters..

Let me know if you have problems sourcing now

[eski2]

well, if i load heidisql I can see the database peq_1496 and i'm not seeing any errors from the server command windows eqlaunch and zone but when the SoF client runs it can login but there's no server listed? looking at the ini and xml, it should see the georges server, I'm not sure what's missing.
LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
110438 New client from ip: 192.168.89.128 port: 1555
192594 New client from ip: 127.0.0.1 port: 1562

[GeorgeS]

When that happens, try to shut down eqgame.exe and restart it with the start.bat file. Sometimes that helps.

Your configs "eqemu_config.xml" should have your database login as mentioned in me previous post step 4 as well.
When you start the server, 3 DOS windows pop up?

GeorgeS

[eski2]

looks like there was a typo in the string i'd used as the password in the config.xml, sorry been packing to move, only just found it.

I can see th elist of chars, using SoF client, will test things out.

[eski2]

I noticed on your web page, it says
"For SOF but SOD tables sources (SOD account = administrator/administrator)
"
I'm not sure what you mean here?

[GeorgeS]

SOD accounts use eqemuloginserver.exe and have a login info in a table in the database. I never got the SOD login/server to work.


GeorgeS

[eski2]

I've noticed when i try to create a bot, i get the message "The name (X) is already being used. Please choose a different name."

Any X chosen as a name gets the same result, and i can see http://www.eqemulator.org/forums/showthread.php?t=30452
says this means bots.sql hasn't been sourced, was it working for you?