Local Server issues

[blackde]

ok status update

I have two dos windows up atm. One is EQEmu Login Server Which has many differant prompts with no errors and the last saying Server Started. The other window is the eqlaunch.exe with nothing in it. I think the server is running atm lol.

I have HeidiSQL 9.1.0.4867 running. I'm trying to make accounts but i'm having trouble where to do this. On the guide it shows what info must be placed but where on Heidi do i do this. There are 8 databases in Heidi

Thanks

[epilz]

what accounts are you trying to make? You should see 4 windows, not 2. Should see World.exe, queryserv.exe, ucs.exe, and eqlaunch.exe. Are you using a batch file to lauch them?

[blackde]

Yes a .bat file like the one setting up a local server guide.

The accounts are for player accounts. I know I can make them in a prompt window or heidi. The prompt version I'm not sure exactly what to put. The guide shows the info but I just don't want to f it up. I did a google search on creating eqemu accounts with heidi but the folder I don't see on the heidi window.

[epilz]

go to your folder where your world.exe file is located. You will have to unlock your server and login your accounts. Type world flag XXXX 250 the XXXX is your account name you want to flag. Lock your server and reboot, and then you can login while its locked

[blackde]

ok thanks i will try that. here is the log From Eqemuserver file

[Debug] [02.10.15 - 22:12:25] Logging System Init.
[Debug] [02.10.15 - 22:12:25] Config System Init.
[Debug] [02.10.15 - 22:12:25] MySQL Database Init.
[Debug] [02.10.15 - 22:12:25] Encryption Initialize.
[Debug] [02.10.15 - 22:12:25] Encryption Loaded Successfully.
[Debug] [02.10.15 - 22:12:25] Server Manager Initialize.
[Network] [02.10.15 - 22:12:25] ServerManager listening on port 5998
[Debug] [02.10.15 - 22:12:25] Client Manager Initialize.
[Network] [02.10.15 - 22:12:25] ClientManager listening on Titanium stream.
[Network] [02.10.15 - 22:12:25] ClientManager listening on SoD stream.
[Debug] [02.10.15 - 22:12:25] Server Started.

I copied all files into EQ\EQEmuServer that end with pdb. Per the guide its for logs to check world,ect. When i try to open these files with any program i get a working hour glass and it won't open.

below is the part confusing me

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');

These files already exist in my EQ\SQL folder. When i click on the file it opens Heidi program but just the generic log in screen is there with no options.

[blackde]

so i looked at examples of others config.xml file and made some changes there

so now i have 5 windows open world.exe, login server, ucs.exe, eqluanch.exe, queryserver.exe

i coped and pasted this from the world.exe

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.0.0
[World Server] Added loginserver 127.0.0.1:5998
[World Server] Connecting to MySQL...
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
Pulling down automatic database upgrade script...
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
Warning: Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 1: Table 'peq.db_version' doesn't exist
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Table 'db_version' does not exists.... Creating...

Warning: Using a password on the command line interface can be insecure.
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\xampp\mysql\bin/mysql
================================================== ==========
Binary Database Version: (9075)
Local Database Version: (1000)

Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
db_update_manifest.txt
Saved: db_update/db_update_manifest.txt
You have missing database updates, type 1 or 2 to backup your database before ru
nning them as recommended...

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

> 1)
Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

> 1
Can't open perl script "db_dumper.pl": No such file or directory
db_dumper.pl not found... retrieving...

URL: https://raw.githubusercontent.com/EQ...ter/utils/scri
pts/db_dumper.pl
Saved: db_dumper.pl
Performing database backup....
Warning: Using a password on the command line interface can be insecure.

Todays Date: 02-11-2015
Operating System is: MSWin32
Database is peq
Backup Directory: backups
Directory does NOT exist! Creating...

Backing up Database peq...

--- CMD ---
mysqldump -uroot --host 127.0.0.1 --max_allowed_packet=512M --password="*******"
peq > "backups\peq 02-11-2015.sql"
---------------------------------------

Backup DONE... DB Backup File Size '212432598' (202.59 MiB)

Final file located: backups\

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

I did a backup to database but not sure where to move forward now. It said something about missing an update or something.

thanks

[blackde]

sorry more info coming in...

[Debug] [02.11.15 - 22:47:11] Logging System Init.
[Debug] [02.11.15 - 22:47:11] Config System Init.
[Debug] [02.11.15 - 22:47:11] MySQL Database Init.
[Debug] [02.11.15 - 22:47:11] Encryption Initialize.
[Debug] [02.11.15 - 22:47:11] Encryption Loaded Successfully.
[Debug] [02.11.15 - 22:47:11] Server Manager Initialize.
[Network] [02.11.15 - 22:47:11] ServerManager listening on port 5998
[Debug] [02.11.15 - 22:47:11] Client Manager Initialize.
[Network] [02.11.15 - 22:47:11] ClientManager listening on Titanium stream.
[Network] [02.11.15 - 22:47:11] ClientManager listening on SoD stream.
[Debug] [02.11.15 - 22:47:11] Server Started.
[Network] [02.12.15 - 00:11:47] New world server connection from 127.0.0.1:50206
[Network Error] [02.12.15 - 00:11:47] Handle_NewLSInfo error, remote address was null, defaulting to stream address 127.0.0.1.
[Database] [02.12.15 - 00:11:47] Mysql query failed: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'setme'
[World] [02.12.15 - 00:11:47] Server I Forgot To Edit My Config(setme) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Database] [02.12.15 - 00:11:47] Mysql query failed: SELECT max(ServerID) FROM tblWorldServerRegistration
[Database] [02.12.15 - 00:11:47] Mysql query failed: UPDATE tblWorldServerRegistration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1', ServerLongName = 'I Forgot To Edit My Config' WHERE ServerID = 0