Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2015, 11:54 PM
blackde
Fire Beetle
 
Join Date: Feb 2015
Posts: 13
Default

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
Reply With Quote
  #2  
Old 02-12-2015, 01:13 AM
blackde
Fire Beetle
 
Join Date: Feb 2015
Posts: 13
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:15 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3