using peqdb_rev1549.sql with EQEmuLoginServer

[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)

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