Problem with standalone loading!

[pythag]

Hi, new here but ok with the set up, followed the setup guide twice and end up by being able to hit the "login" button then it stops saying "logging in to server please wait" but nothing further, I did run the bat file first and have the 3 dos boxes appear with things happening - anyone point me the right way?

eqhost
[LoginServer]
Host=127.0.0.1:5999
eqemu_config
<?xml version="1.0"?>
<server>
<world>

<shortname>Promised</shortname>
<longname>The Promised Land</longname>


<!-- address has to be specified for minilogin to work -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>kiw9083wdfgesiwud</key>

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<!-- Database configuration, replaces db.ini -->
<database>

<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>mysqlpassword</password>
<db>peq</db>
</database>
</server>
LoginServer
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=promised
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

[Vexyl]

What does MiniLogin say when you start it up? Post its log if you can.

Did you make a MiniLogin account in the database? You should have set the account's minilogin_ip field to 127.0.0.1 as well.

[werebat]

Also make sure your logintype variable is set to minilogin

[pythag]

Also make sure your logintype variable is set to minilogin

update variables set value = "Minilogin" where varname = "LoginType";
and
Insert into account (name, password, status, minilogin_ip) values ("SuperGreg", "Numba#1!!", 250, "127.0.0.1");

Those parts went off with no errors if you mean that!

as for the command boxes see below
Loginserver.ini read
[status] loading opcodes..
server mode: minilogin
login server listening on port:5999
6437 New Server connection: 127.0.0.1 port 30483
0: E0 A0 e5 00 ......

Ok after the "e5 00" there are lots of lines of the same repeating themselves.

another contains this (only the top few lines shown as couldnt copy)
Failed to open log file: logs/eqemu_debug_world_2208.log
[Debug] [world_init] loading server configuration.
[Debug] [world_init] warning: unable to read log.in

and the other this (only the top few lines shown as couldnt copy)
Failed to open log file: logs/eqemu_debug_3968.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...
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_01,

[Noport]

Create a blank log.ini file put in c:\eqemu this is your server directory

might remove key you put in unless you added the key to peq database this would stop the world from loading
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>kiw9083wdfgesiwud</key>

your login.ini file needs world shortname and chataddress ip number
[ChatChannelServer]
worldshortname=Prom
chataddress=127.0.0.1
chatport=3018

This will auto load your server for you
Make a bat file serverstart.bat

@echo off
Echo Starting EQEmuLoginServer
c:
cd C:\eqemu
start eqemuloginserver.exe
echo
echo

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit

Make a bat file serverministart.bat

@echo off
Echo Starting MiniLogin Server
c:
cd c:\eqemu
start minilogin.exe
echo.
echo.

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit

The cause for error "logging in to server please wait" tells me your login opcodes are not setup right.
make sure your login opcodes read
patch_sod.conf,patch_underfoot.conf,patch_hot.conf ,opcodes.conf,login_opcodes_sod.conf read
#Login opcodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0022
OP_ChatMessage=0x0017
OP_LoginAccepted=0x0018
OP_ServerListResponse=0x0019
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011
make sure your Login opcodes read
for all others patch_Titanium.conf,patch_6.2.conf,patch_SoF.conf, login_opcodes.conf
#Login opcodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0021
OP_ChatMessage=0x0016
OP_LoginAccepted=0x0017
OP_ServerListResponse=0x0018
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011
note: opcodes.conf depends on the client you want to run so it may very for your client setup use settings login ports listed above for Sod Client or higher.

[pythag]

Ok tried this over several times now and the source files have changed, is there an upto date guide to this as I have just pulled down rev2100 and mysql it reports errors - so either I am missing something or the guides are way out of date?
I think I need a fresh start but looking for a little guidance.

[Noport]

1. Just Download the files Don't install until after you followed every step in the Guide
Download mysql-essential-5.1.59-win32 http://ftp.sunet.se/pub/databases/relational/mysql/Downloads/MySQL-5.1/mysql-essential-5.1.59-win32.msi
Download activeperl-5.10.0.1004-mswin32-x86-287188 http://www.4shared.com/file/NZcfI0Ec/ActivePerl-51001004-MSWin32-x8.html
Download Navicat 8.xx http://www.navicat.com/download/navicat8_mysql_en.exe
Download npp.5.9.8.Installer http://notepad-plus-plus.org/download/v5.9.8.html
Download TortoiseSVN-1.7.4.22459-win32-svn-1.7.2 http://tortoisesvn.net/downloads.html
Download peqdatabaseRev2001 http://projecteqdb.googlecode.com/svn/trunk/peqdatabase/
Download ServerRev2001 http://projecteqemu.googlecode.com/svn/
Download Quest http://projecteqquests.googlecode.com/svn/trunk/quests

2. Install activeperl-5.10.0.1004-mswin32-x86-287188
Type yes to everything BUT There will be
one question that has C:\Perl in it. That question requires you to enter
that path as the answer. So just type c:\perl (YOU HAVE TO REBOOT FOR NEXT STEP)
After you rebooted, open command prompt and type the following (one at a time and
wait for it to finish): Type in Run Command or dos prompt
ppm install DBI
ppm install IO-stringy
Reboot Computer

3.Now install mysql-essential-5.1.59-win32 (this will be installed to C:\mysql)
When you first start up the install, make sure you choose CUSTOM install.
IMPORTANT: after clicking "next" this is where you change the install
path to "C:\mysql
On that same menu, make sure ALL options are installed.
After clicking "next", on that menu, choose Detailed Configuration.
After clicking "next" again, choose Server Machine.
After clicking "next" again, choose Multifunctional Database
On the next menu, there is nothing to change, click "next" again.
On that menu, choose Online Transaction Processing (OLTP)
Then click "next". UNCHECK the strict mode option, and make sure that the
TCP/IP Networking is checked ENABLE and at port 3306.
After clicking "next" again, Choose Best Support for Multilingualism.
After clicking "next" again, make sure BOTH of the following are checked:
Install As Windows Service and Include Bin Directory in Windows Path
After clicking "next" again, you will be prompted for a password.
(This password is what goes with your SQL database username)
Your SQL username is automatically set as "root"
After you click "next" again, you will get a menu with "Execute" on it.
Just click that and wait, as it installs and finishes. Reboot Computer.

4.Now we install Microsoft Visual C++ 2008 Express Edition vcsetup.exe
You can just install this with all the default installation. Nothing to
do until after installation is complete. But once it is done;
Open up the program and on the menu at top, click on "Tools"
From that menu choose "Options" and then you will see a menu list with
"Projects and Solutions" with a little "+" sign to expand that menu.
You will see "VC++ Directories" to click on and change the menu to the right.
On the top right of the menu you will see "Show directories for" and under
that, by default, it will show "Executable files".
First you need to change that to "Include files" from the drop down menu.
You will also see a little yellow folder icon under that drop down menu.
This is to "add a new line". After you click on that and see a new line,
you will see a grey icon to the right of that line with 3 dots [...]
Click on that to browse for the following: You will repeat this for all 3
new lines.***NOTE** the following are FOLDERS, not files.

INCLUDE:

C:\mysql\include
C:\perl\lib\CORE
C:\zlib\include

Now after those 3, change the "Show directories for" to Library files and
repeat the steps for the following 3: (notice, a couple are different)

LIBRARY:
C:\mysql\lib\opt
C:\perl\lib\CORE
C:\zlib\lib

OK, Your done with installing the C++ program.

5. Now you can install TortoiseSVN, Navicat and Notepad++ using defaults
(click yes or next to everything)
6. Install Navicat 8.xxx
7. Install npp.5.9.8.Installer
8. Install TortoiseSVN-1.7.4.22459-win64-svn-1.7.2
REBOOT COMPUTER

OK, now you have all the basic programs installed

Here is how i sourced my server files

copy peqdb_rev2100.sql (without the .gz) extract the file before copying to C:\MySQL\bin Directory using winzip or rar
copy player_tables directory
copy updates directory
copy load_player.sql

Copy all Files and Folders too C:\MySQL\bin Directory


15. NOW, you need to go in to a command prompt and navigate to the C:\MySQL\bin Directory

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the C:\MySQL\bin Directory

Then type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:

source peqdb_rev2100.sql (when this is done, you will be back at the mysql>_ prompt)

Then type in the following:

source load_player.sql (this will load fast)
Done.

[Noport]

Steps for removal of old database before adding the newer serverfiles.

copy peqdb_rev2100.sql (without the .gz) extract the file before copying to C:\MySQL\bin Directory using winzip or rar
copy player_tables directory
copy updates directory
copy load_player.sql

Copy all Files and Folders too C:\MySQL\bin Directory

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the C:\MySQL\bin Directory

Then type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:
type drop_bots.sql if loaded
type drop_player.sql
type drop_system.sql

next step soucing in new database
type source peqdb_rev2100.sql
then type source load_player.sql
Done I'm sure this is what you was looking for instead of reloading the whole server.

[joligario]

If you add the bin folder to your ENV variables, you don't have to copy the SQL files to the bin folder.

[Noport]

That is the way i thought myself when learning to source them It works for me 80)

[pythag]

Thanks for the input, not got it straight yet due to time however already the mysql parts are happening without errors and I can see things beginning to fall into place - I think I will do a fresh install as I managed to mess a few parts up (my fault)
But again thanks.

[pythag]

Ok did a full reinstall, I am able to type in username and password but then it cant find account, the bat server file says unable to find user or pass within accounts table, the bat server file when run also cant find world. Checked within heidisql (what i use) under the tbl I can see the login details - next post shows how I got there maybe you can see a glaring error!
Many thanks for looking

[pythag]

Installed programs
Mysql
Perl 5.1
Tortoisesvn
Heidisql

Navigated to c:\mysql\bin – right click use http://projecteqdb.googlecode.com/svn/trunk - downloads peqdatabase into bin folder.
Find c:\mysql\bin\peqdatabase\peqdb_Rev2100.sql.gz file and extract it to same folder so you have c:\mysql\bin\peqdatabase\peqdb_rev2100.sql file available.
Start\run\command
Cd msysql\bin\peqdatabase to locate directory
Problem – unable to cd to peqdatabase as name to long so renamed to peqdb, Cd msysql\bin\peqdb
Once at correct point type mysql –u root –p, then enter password.
Then create database peq;
Use peq;
source peqdb_rev2100.sql;
source load_player.sql;
source load_bots.sql;

Create a folder called c:\eqemufiles for storage.
Create a folder called c:\eqemuserver – to place extracted server files
Download eqemuloginserver.rar to c:\eqemufiles – then extract all of that to c:\eqemuserver
Create subfolder c:\eqemufiles\server files, then right click and svn http://projecteqemu.googlecode.com/svn
Navigate to folder c:\eqemufiles\server files\trunk\EQEmuServer\EQEmuLoginServer\login_uti l.
Copy eqemulogin.ini, login_opcodes.conf to c:\eqemuserver folder
Problem eqemulogin.ini doesn’t exist however forums says use login.ini also several opcodes
Navigate further to …login_utl\ms\debug.
Copy EQEmuAuthCrypto.dll to c:\eqemuserver folder
Using Heidi create new database peqlogin – then highlight it
Import sql, navigate to c:\eqemufiles\server files\trunk\EQEmuServer\EQEmuLoginServer\login_uti l
Choose file EQEmuLoginServerDBInstall.sql then F9 to execute
Create two text files ending in .sql using format all files with:
File1- Insert into tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) values ('myaccout', sha('mypassword'), 'admin@somewhere.com', now(), '127.0.0.1');
File2 - INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'MYLAND', 'MINE', 'LAND', '2', NULL, NULL, '1', NULL);

Back to Heidi with peqlogin selected – import file1, f9 to execute – import file2, f9 to execute – exit heidi

Find eqemu_config.xml within c:\eqemuserver and edit.
Problem it is not there – copied it from a previous version I found??
<world>
<shortname>MINE</shortname>
<longname>MYLAND</longname>
<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>localhost</address>
<localaddress>localhost</localaddress>
<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>localhost</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver> <!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>mysqlPassword</password>
<db>peq</db>
</database>

Create bat file
@echo off
start EQEmuLoginServer.exe
start world
echo waiting for the world to finish before starting zone...
sleep 10

For now left maps and quests out as also in the server folder the directories do not exist but can copy/paste later

[werebat]

<longname>MYLAND</longname>

For some reason, I thought this had to be more than 10 chars.
Try something like 'This Is My Land'

[Noport]

I forgot to add

Download Maps http://eqemumaps.googlecode.com/svn/trunk/Maps
Download Zlib http://sourceforge.net/projects/libpng/files/zlib/1.2.3/zlib123-dll.zip/download

eqemu_config.xml

<loginserver>
<host>localhost</host>
<port>5999</port>
<account>root</account>
<password>xxxxx</password>

@echo off
Echo Starting minilogin

cd C:\eqemu
start minilogin.exe
echo
echo

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit

[pythag]

Still couldnt log in as connnection failure so started again however with with latest download (2101) I get fails on compile with MSvisc++2008 there were 5 files now there are 6, back to the drawing board.

[pythag]

Well managed to reset up hashes several guides together - got to the server select but cant see any so that the next step forward.

[pythag]

Dead end looking for more help !!
Used Vales guide with the peqlogindb, checked with Heidisql and I have both an entry in tblloginserveraccount and tblworldserverreg that all look good – using eqemulogin not minilogin.

I am attempting to play on own pc not connecting online, filled out as much as I can using the variety of guides.
I intend on writing a “dummy” manual for this, as that would be me, but need to iron out some issues.
No problems with the server.bat file world, eqemulogin all start and appear to be ok - but not sure what I am looking for there.
I am able to get to server select but its now blank – no servers listed
Frustrated – a little!

Eqhost
[LoginServer]
Host=localhost:5999

Eqemu_config
<?xml version="1.0"?>
<server>
<world>
<shortname>Promised</shortname>
<longname>The Promised Land</longname>

<!-- address has to be specified for minilogin to work -->
<address>localhost</address>
<localaddress>localhost</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>localhost</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>makeupsomerandomstringofcharactershere</key>

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<!-- Database configuration, replaces db.ini -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>mysqlpass</password>
<db>peq</db>
</database>
</server>

Login.ini
[database]
host = localhost
port = 3306
db = peqlogindb
user = root
password = mysqlpass
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

I have altered the opcodes as per instructions

[pythag]

Still no server showing in server select!!
Eqemu login server
[Debug] [02.18.12 - 12:51:08] Logging System Init.
[Debug] [02.18.12 - 12:51:08] Config System Init.
[Debug] [02.18.12 - 12:51:08] MySQL Database Init.
[Debug] [02.18.12 - 12:51:08] Encryption Initialize.
[Debug] [02.18.12 - 12:51:08] Encryption Loaded Successfully.
[Debug] [02.18.12 - 12:51:08] Server Manager Initialize.
[Network] [02.18.12 - 12:51:08] ServerManager listening on port 5999
[Debug] [02.18.12 - 12:51:08] Client Manager Initialize.
[Network] [02.18.12 - 12:51:08] ClientManager listening on Titanium stream.
[Network] [02.18.12 - 12:51:08] ClientManager listening on SoD stream.
[Debug] [02.18.12 - 12:51:08] Server Started.
[Network] [02.18.12 - 12:51:15] New world server connection from 127.0.0.1:1570
[World] [02.18.12 - 12:51:15] Server the promised land(promised) did not attempt
to log in but this server requires a password.
[Network] [02.18.12 - 12:51:34] New SoD client connection from 127.0.0.1:1573
[Network] [02.18.12 - 12:51:34] Application packet recieved from client (size 14)
[Network] [02.18.12 - 12:51:34] Session ready recieved from client.
[Network] [02.18.12 - 12:51:34] Application packet recieved from client (size 36)
[Network] [02.18.12 - 12:51:34] Login recieved from client.
[Client] [02.18.12 - 12:51:34] User: pythag1
[Client] [02.18.12 - 12:51:34] Hash: 6dffaaad0af66b18dc53187109db000d06d40c90
[Network] [02.18.12 - 12:51:34] Application packet recieved from client (size 12)
[Network] [02.18.12 - 12:51:34] Server list request recieved from client.

Eqemu World.exe
Failed to open log file: logs/eqemu_debug_world_3692.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Warning: Unable to read log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver 127.0.0.1:5999
[Debug] [WORLD__INIT] Connecting to MySQL...
Failed to open log file: logs/eqemu_world_3692.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=92475
[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..
Failed to open log file: logs/eqemu_error_world_3692.log
[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] Loading char create info...
[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 Underfoot
[Debug] [WORLD__LS] Connecting to login server: 127.0.0.1:5999
[Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1569
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1569
[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__ZONE] New TCP connection from 127.0.0.1:1572
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1572
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zone
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7000
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1575
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:1575
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zone
[Debug] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use port 7001
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1577
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:1577
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zone
[Debug] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use port 7002
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1579
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:1579
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_04 by launcher zone
[Debug] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use port 7003
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1581
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:1581
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zone
[Debug] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use port 7004

The other box – that says sleeping
Failed to open log file: logs/eqemu_debug_4012.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [LAUNCHER__INIT] Starting main loop...
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_01
[Debug] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_02
[Debug] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_03
[Debug] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.

[lerxst2112]

[World] [02.18.12 - 12:51:15] Server the promised land(promised) did not attempt
to log in but this server requires a password.


Either fix the account/password in eqemu_config.xml, or make sure you have unregistered_allowed = TRUE in login.ini

[pythag]

eqemu_login - root and mysqlpassword are same as to login to mysql
<?xml version="1.0"?>
<server>
<world>
<shortname>promised</shortname>
<longname>the promised land</longname>

<!-- address has to be specified for minilogin to work -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>someoddkey</key>

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<!-- Database configuration, replaces db.ini -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>mysqlpassword</password>
<db>peq</db>
</database>
</server>


login.ini - was already set to true
[database]
host = localhost
port = 3306
db = peqlogindb
user = root
password = mysqlpassword
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5999
local_network = 127.0.0.1

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

[lerxst2112]

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


What's missing?

[pythag]

put in my mysql as suggested - still didnt work
<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>root</account>
<password>mysqlpassword</password>
</loginserver>

So tried my login name and password - that doesnt work either

[lerxst2112]

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

Look at the 'Setup PEQLoginDB DB and Logins' section. The account/password are what you put in your peq login database.

[Noport]

Sever Database Settings
Peq
[Table] variables
LoginType Minilogin
-------------
[Table] account
Id # 2
Name
Charname
Sharedplat
Password
Status 250
Isaccound_id ######
revoked 0
karma 0
minilogin 127.0.0.1
hideme 0
rulesflag 0
Suspendeduntil
Time_Creation
--------------
[Table] account_ip
accid # 1
ip 127.0.0.1
count
lastused date
--------------
[Table] zone_server
Name zone
address 127.0.0.1
port 9000
player_count 0
last_alive date
rain 0
-------------
Server Database Settings
peqlogindb

Peqlogindb
[Table] tbloginserveraccounts
LoginServerID # 1
AccountName
AccountPassword
AccountCreatedDate
AccountEmail
LastLoginDate
LastIpAddress 127.0.0.1
-------------
[Table] tblserveradminregistration
ServerAdminID 1
AccountName
AccountPassword
FirstName who
LastName cares
Email who@cares.com
RegistrationDate
RegistrationIPAddr 127.0.0.1
--------------
[Table] tblworldserverregistration
ServerID # 1
ServerLongName One Great Server
ServerDescription One Great Server
ServerShortName OGTS
ServerListTypeID # 2
ServerLastLoginDate
ServerLastIpaddr 127.0.0.1
ServerAdminId # 1
ServerTrusted 0

[pythag]

Lerst2112
I followed that guide to the letter several times
insert into tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) values('Admin', sha('Password'), 'admin@somewhere.com', now(), '127.0.0.1');
That imported fine - obviously used my own details - that part all went well

Noport
Not using minilogin as using eqemuserver as all the threads suggest to so:
the peq parts are empty however the peqlogindb are correct

anyhow reran everything and
Build: 4 succeeded, 2 failed, 0 up-to-date, 0 skipped
it says revert to 2099 but unable to find that - now lost in the wilderness

[Noport]

How i went to the url location start at the homepage http://www.eqemulator.org/, on the uper left hand side of the browser is » Source Code (SVN) click on that. you should now be at url: http://code.google.com/p/projecteqemu/source/checkout you should have Source marked click on browse you should now be at url: http://code.google.com/p/projecteqemu/source/browse/. on the uper right hand side of the browser you should see rev numbers click on the rev number that you need now download using TortoiseSVN program i posted url below. i'm telling you so you can beaware how to get back there if needed at anytime.

Download: http://code.google.com/p/projecteqemu/source/browse/?r=2099

[Noport]

It continues to load as if it's working properly, but my server screen is blank so I can't select it.

If I select Quick Connect at login screen (I named my private server the same as my public one), it hangs on a black screen and I get this message in my World.exe window: [Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '2'

This is my new config:
<?xml version="1.0">
<server>
<world>
<shortname>clmty</shortname>
<longname>Calamity</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>clmtyserver.dnsalias.com</address>
<localaddress>192.168.x.xxx</localaddress>

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>clmtyserver.dnsalias.com</host>
<port>5998</port>
<account>MyAdminAccountName</account>
<password>MyAdminAccountPassword</password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="localhost" port="9000" telnet="enable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>ALongRandomKeyIGenerated</key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>MyMySQLLogin</username>
<password>MyMySQLPassword</password>
<db>peq</db>
</database>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>

Please note that I can log into my public server just fine and don't get a blank server screen

[pythag]

http://code.google.com/p/projecteqem...browse/?r=2099

I can see the page through explorer but that will not download in tortoise - just throws errors up.

[lerxst2112]

Right-click code folder -> TortoiseSVN -> Update to revision... -> type number in box.

[pythag]

Going to pick this up tommorow but:

Thank you lerxst2112 - 5 builds no fails :)

Noport thank you too - question?
<!-- Loginserver information. Defaults shown -->

Is that relating to table tblserveradministration or tblloginerveraccount
I havent altered tblserveradministration as I dont recall it asking me to and there is some default value in there?
Again thanks

[Noport]

For security purposes, you can delete the Admin account that's entered by default in tlbloginserveraccounts table tblserveradministration
your answer is table tblserveradministration Requires user name and password put into eqemu_config

This is my eqemu_config

<?xml version="1.0">
<server>
<world>
<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>VoA</shortname>
<longname>Veil of Alaris</longname>

<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<address>192.168.0.10</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. DO NOT EDIT -->
<loginserver>
<host>192.168.0.10</host>
<port>5999</port>
<account>Admin</account>
<password>xxxxxxxxxx</password>
</loginserver>

<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>xxxxxxxxxxxxxxxxxxxxxxxxxxxxx</key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. DO NOT EDIT -->
<chatserver>
<host>192.168.0.10</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>
<host>192.168.0.10</host>
<port>7779</port>
</mailserver>

<zones>
<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
<ports low="7000" high="7100"/>
</zones>

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>xxxxxxxxxxxxx</password>
<db>peq</db>
</database>

<!-- Launcher Configuration DO NOT EDIT-->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. DO NOT EDIT -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. DO NOT EDIT -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>

This is my login.ini


[database]
host = localhost
port = 3306
db = peqlogindb
user = root
password = xxxxxxxxxxx
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5999
local_network = 192.168.0.10

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf


[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType



[Debug] [02.20.12 - 15:39:27] Logging System Init.
[Debug] [02.20.12 - 15:39:27] Config System Init.
[Debug] [02.20.12 - 15:39:27] MySQL Database Init.
[Debug] [02.20.12 - 15:39:27] Encryption Initialize.
[Debug] [02.20.12 - 15:39:27] Encryption Loaded Successfully.
[Debug] [02.20.12 - 15:39:27] Server Manager Initialize.
[Network] [02.20.12 - 15:39:27] ServerManager listening on port 5999
[Debug] [02.20.12 - 15:39:27] Client Manager Initialize.
[Network] [02.20.12 - 15:39:27] ClientManager listening on Titanium stream.
[Network] [02.20.12 - 15:39:27] ClientManager listening on SoD stream.
[Debug] [02.20.12 - 15:39:27] Server Started.
[Network] [02.20.12 - 15:40:00] New world server connection from 192.168.0.10:63486
[World] [02.20.12 - 15:40:00] Server Veil of Alaris(VoA) successfully logged in.

[pythag]

Hi again, never got this working and had to go on an overseas tour and looking for further assistance - help would be appreciated.
I have started fresh and the latest source (2171) this fails on the compile however 2099 does not,
first part, how do I check which server and database revisions work with each other, its not clear to me?
I will be working with source 2099 and I am trying to make sure I get the correct server revision.
Thanks in advance

[Uleat]

You should be able to use the current SVN for both the server code and the database with no foreseeable issues.

Occasionally, a bug will slip in, but that is not the intended design...


In starting a new server with the current revisions (eqemu 2171 and 63 for peqdb) you just need to make sure that
you have all of the sql updates applied.

Note that the name of the peqdb is called peqdb_rev2142.sql and this was updated from peqdb_rev2133.sql in peqdb
revision 62.

The name of the database sql file ONLY reflects the cumulative changes to the database to match the eqemulator
revision and not the peqdb revision itself.


To keep current, you need to not only source in the database, but also ANY patches that equal or exceed the server
revision that you plan to run.


If you look in two places, you will find sql update files that need to be sourced in as well.

First, look in your peqdatabase (source) directory and you will see a folder called updates. Inside of this is a file called
rev2142.sql. This is a patch from the PEQ people that needs to be sourced in after the base peqdb_rev2142.sql file.

Once a new peqdb is released, you no longer have to apply anything older than the revision in the db filename.

Second, look in your eqemuserver\utils\sql\svn (source) directory. In here you will see several sql files that are
higher than the peqdb base file. You will need to source these in as well.

If you are running a revision that is less than the some of the sql updates, you may or may not run into issues by
sourcing in higher files than your server revision, so I'd only recommend sourcing in up to or equal to your actual eqemu
revision. Saying which server revisions work with what peqdb revisions is not exactly easy to say.

(If you're going to use server rev 2099, you should probably revert your peqdb back to something 2099 or less as well
and source in any updates to match. Thing is, you'll miss anything that has been updated/fixed since then if you go that
route.)


In regards to your issue with compiling, you will need to provide more information. I use both VS 2008 and VS 2010,
both in 32-bit compile on a 32-bit OS and have compiled most revisions since 2142 with no problems. There's any number
of things that could be causing the failure and there's not enough information in your post to say what the problem is...

[pythag]

Can anyone see issues with these files assuming the following:

shortname = short, long name = short name
tblserveradminregistration have accountname = admin, password = random
tblloginserveraccounts have accountname = admin, password = random
mysql user = root, password = password

Login.ini
[database]
host = 127.0.0.1
port = 3306
db = peqlogindb
user = root
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5999
local_network = 127.0.0.1

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

eqemu_config.xml
<?xml version="1.0">
<server>
<world>
<shortname>Short</shortname>
<longname>Short Name</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>127.0.0.1</address> -->
<!-- <localaddress>127.0.0.1</localaddress> -->

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>192.168.0.10</host>
<port>5999</port>
<account>admin</account>
<password>random</password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key></key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>127.0.0.1</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>127.0.0.1</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>password</password>
<db>peq</db>
</database>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>

[Uleat]

I played this game once! I could never find that 13th bear though...

[pythag]

I played this game once! I could never find that 13th bear though...


mmmm is that a random statement

[lerxst2112]

Well, the thing is, posting a config without telling us what the issue might be is also sort of random.

You do have the address and localaddress commented out, which might be fine, but since you did change them perhaps you were thinking it would do something but as it sits right now it won't.

[pythag]

Ahh ok
World.exe is giving this
[Debug] [NET__IDENTIFY] Registered patch Underfoot
[Debug] [WORLD__LS] Connecting to login server: 192.168.0.10:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1879
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1879
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] **WARNING** You have not configured a world shared
n your config file. You should add a <key>STRING</key> element to your <wor
lement to prevent unauthroized zone access.
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone

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

[Debug] [WORLD__LS_ERR] Could not connect to login server: 192.168.0.10:599
Connection::Connect(): connect() failed. Error: 10061
[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)

And the other does this

[Debug] Starting Log: logs/eqemu_debug_3320.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [LAUNCHER__INIT] Starting main loop...
[Debug] [NET__WORLD] Connected to World: localhost:9000
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is alre
ady running.

So getting back to where I left off, with the files as I have them I cant grasp the fault!

[blackdragonsdg]

In eqemu_config.xml you are missing a shared key. This line
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key></key>

Should look something like this

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>89234792837598273502</key>


Now the actually key that is used can be any random value.

[pythag]

I have entered that in before but just tried again, but still same errors.
Should that key be entered elsewhere aswell?

[blackdragonsdg]

I don't think that shared key is entered any where else. The only other thing that looks out of place is the ip address 192.168.0.10 in this section.
<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>192.168.0.10</host>
<port>5999</port>
<account>admin</account>
<password>random</password>
</loginserver>

The rest of the ip addresses in your config files are set to 127.0.0.1 but that one is different. Have you tried changing it to 127.0.0.1
I don't know that it will help but it just might.

[c0ncrete]

that's probably it, because 10061 is a standard windows socket error. it means the computer at the address responded, but refused the connection.

[pythag]

I have amended the address to 127.0.0.1, and no joy, just looking into the 10061 idea now..

from microsoft
WSAECONNREFUSED
10061
Connection refused.
No connection could be made because the target computer actively refused it. This usually results from trying to connect to a service that is inactive on the foreign host—that is, one with no server application running.


mmm

[c0ncrete]

where are your logs from EQEmuLoginServer?

[pythag]

The log.ini file remains empty,
The only feedback I get is as above
Assuming thats what you mean

[c0ncrete]

are you running EQEmuLoginServer? if so, your logs directory should have a file named something like login_1354312358.log. the contents of that file will likely tell you what is going on. if you are NOT running EQEmuLoginServer (or if it's closing due to an error), that's the problem. world is trying to connect to a login server that isn't running.

[pythag]

There is no login file but lots of zone/debug/world/quest zone picking a matching number
quest_zone
[11.29. - 22:17:42] Starting Log: logs/eqemu_quest_zone_5660.log
[11.29. - 22:17:42] Tying perl output to eqemu logs
[11.29. - 22:17:42] Creating EQEmuIO=HASH(0x99c6f3c)
[11.29. - 22:17:42] Creating EQEmuIO=HASH(0x99b984c)
[11.29. - 22:17:42] Loading perlemb plugins.
[11.29. - 22:17:42] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[11.29. - 22:17:42] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[11.29. - 22:17:42] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[11.29. - 22:17:43] Loading perl commands...
[11.29. - 22:18:08] Terminating on signal SIGHUP(1)
world
---------------------------------------------
[11.29. - 22:01:49] Starting Log: logs/eqemu_world_5068.log
[11.29. - 22:01:49] Using database 'peq' at localhost:3306
[11.29. - 22:01:49] EMuShareMem loaded
[11.29. - 22:01:50] Loading items from database: count=92475
zone
---------------------------------------------
[11.29. - 22:17:42] Starting Log: logs/eqemu_zone_5660.log
[11.29. - 22:17:42] Using database 'peq' at 127.0.0.1:3306
[11.29. - 22:17:42] EMuShareMem loaded
eqemu_error
[11.29. - 22:01:57] Starting Log: logs/eqemu_error_world_5068.log
[11.29. - 22:01:57] Could not load EQTime file eqtime.cfg

[c0ncrete]

i think you're missing a key point...

if you are NOT running EQEmuLoginServer (or if it's closing due to an error), that's the problem. world is trying to connect to a login server that isn't running.

if your world server isn't connecting to eqemulator.net to validate accounts, you will need to run your own login server (EQEmuLoginServer.exe). if the batch file you use to boot the emulator doesn't start the login server, that's where your problem is.

here's my startup.bat as an example:

@Echo Off

:start
CLS

Echo EQ Emulator Option Menu
Echo ============================
Echo = 1. Localnet Server =
Echo = 2. Localhost Server =
Echo = 3. Public Server =
Echo ============================
Echo Default to Localnet in 10s

Set /p ErrorLevel="Which configuration? "
If not '%ErrorLevel%' == '' set choice=%choice:~0,1%
If %ErrorLevel% == 1 Goto localnet
If %ErrorLevel% == 2 Goto localhost
If %ErrorLevel% == 3 Goto public
GoTo Start

:localnet
Copy eqemu_config-localnet.xml eqemu_config.xml
Goto runprivateemu

:localhost
Copy eqemu_config-localhost.xml eqemu_config.xml
Goto runprivateemu

:public
Copy eqemu_config-public.xml eqemu_config.xml
Goto runpublicemu

:runprivateemu
start EQEmuLoginServer.exe
ping localhost -n 10 >nul
start World.exe
ping localhost -n 20 >nul
start EQLaunch.exe zone
ping localhost -n 10 >nul
start ChatServer.exe
Goto end

:runpublicemu
start World.exe
ping localhost -n 10 >nul
start EQLaunch.exe zone
ping localhost -n 10 >nul
Goto end

:end

[pythag]

That's got me to login
Need to pick this up tomorrow thank you

[pythag]

Ok have found the server select and its blank, its a step forward
Log file is the following, and have attemted to re-install peqlogindb (Myplace and place are the server short and long name)
[Debug] [12.01.12 - 09:27:21] Logging System Init.
[Debug] [12.01.12 - 09:27:21] Config System Init.
[Debug] [12.01.12 - 09:27:21] MySQL Database Init.
[Debug] [12.01.12 - 09:27:21] Encryption Initialize.
[Debug] [12.01.12 - 09:27:21] Encryption Loaded Successfully.
[Debug] [12.01.12 - 09:27:21] Server Manager Initialize.
[Network] [12.01.12 - 09:27:21] ServerManager listening on port 5999
[Debug] [12.01.12 - 09:27:21] Client Manager Initialize.
[Network] [12.01.12 - 09:27:21] ClientManager listening on Titanium stream.
[Network] [12.01.12 - 09:27:21] ClientManager listening on SoD stream.
[Debug] [12.01.12 - 09:27:21] Server Started.
[Network] [12.01.12 - 09:27:27] New world server connection from 127.0.0.1:1270
[Network Error] [12.01.12 - 09:27:27] Handle_NewLSInfo error, remote address was
null, defaulting to stream address 127.0.0.1.
[World] [12.01.12 - 09:27:27] Server Myplace(place) attempted to log in but acco
unt and password did not match the entry in the database.

[lerxst2112]

http://www.eqemulator.org/forums/showthread.php?t=31783
Scroll down to "Setup PEQLoginDB DB and Logins" and follow the instructions to add your server entry.

-or-

You can try just removing the username/password from the loginserver section of your config file. You need to have "unregistered_allowed = TRUE" in login.ini for that to work.

[pythag]

Found it,
In my tblserveradminregistration there is a default user of Admin and Password
The sql files listed amend tblLoginServerAccounts and tblworldserverregistration

the tblserveradminregistration is not adjusted once I amended the eqemu_config to this it worked

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>Admin</account>
<password>Password</password>
</loginserver>

I may be wrong but this to me was not clear, but thank you to

lerkst2112,noport,c0ncrete,blackdragonsdg (and any one else I missed) you have all been very patient and helpful

Now on to figure out setting my game :)