Windows Private Login Server

[Uleat]

Are you manually typing the log entry lines, or copying them?


EDIT:

Here is my working copy for a localhost server:
(minus the username/password)

<?xml version="1.0"?>
<server>
	<world>
		<shortname>Wonderland</shortname>
		<longname>The Rabbit Hole</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>127.0.0.1</host>
			<port>5998</port>
			<account>***</account>
			<password>***</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="127.0.0.1" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>DrinkMeEatMe</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>7778</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>***</username>
		<password>***</password>
		<db>peq</db>
	</database>

	<qsdatabase>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>***</username>
		<password>***</password>
		<db>peq</db>
	</qsdatabase>

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

[Adcid]

I coped your EQEMU config file and adjusted for my database. I was allowed into the server and able to even create a character. It seems im still missing parts of my database so ill likely go through one by one and see if i can resolve the other issues.

currently under the world.exe

Account Attempting to be created:admin 0
Error in Log IP query 'INSERT INTO account_ip SET accid=1, ip'127.0.0.1' ON DUMP LICATE KEY UPDATE count=count+1, lastused=now()' #1146: Table 'peq.account_ip' doesn;t exist
Error in CheckNameFilter query 'SELECT name FROM name_filter' #1146: Table 'peq.name_filter' doesnt exist
[Status] Start zone query:SELECT x, y, z, heading, zone_id, bind_id, FROM start_zone WHERE player_choice = 9 AND player_class = 8 and player_diery = 396 and player_race = 4

by my count in this, im missing Account_ip, name_filter, & inventory.sql

of course having followed the directions previously with loading the database makes me wonder with all the difficulties ive had if i obtained a corrupted copy of the files.

[c0ncrete]

to expand upon uleat's inquiry...

does your error log really say "ON DUMP LICATE KEY UPDATE", have a semicolon instead of an apostrophe in one instance of the word "doesn't" followed by no punctuation at all in the second instance, and then misspell the word deity as "diery"?

[Adcid]

[Status] Using database 'peq' at 127.0.0.1:3306
Perl Version is 5.12.3
============================================================
           EQEmu: Automatic Database Upgrade Check
============================================================
        Operating System is: MSWin32
        (Windows) MySQL is in system path
        Path = C:\xampp\mysql\bin/mysql
============================================================
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
        Binary Database Version: (9057)
        Local Database Version: (9057)

        Database up to Date: Continuing World Bootup...
============================================================
[Error] GetInventory query 'SELECT slotid, itemid, charges, color, augslot1, aug
slot2, augslot3, augslot4, augslot5, instnodrop, custom_data FROM inventory INNE
R JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Oldsong' AND ch.acco
unt_id = 2 ORDER BY slotid' #1146: Table 'peq.inventory' doesn't exist
[Error] If you got an error related to the 'instnodrop' field, run the following
 SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;

Error loading inventory for Oldsong
Error in Log IP query 'INSERT INTO account_ip SET accid=2, ip='127.0.0.1' ON DUP
LICATE KEY UPDATE count=count+1, lastused=now()' #1146: Table 'peq.account_ip' d
oesn't exist
[Error] GetInventory query 'SELECT slotid, itemid, charges, color, augslot1, aug
slot2, augslot3, augslot4, augslot5, instnodrop, custom_data FROM inventory INNE
R JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Oldsong' AND ch.acco
unt_id = 2 ORDER BY slotid' #1146: Table 'peq.inventory' doesn't exist
[Error] If you got an error related to the 'instnodrop' field, run the following
 SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;

Error loading inventory for Oldsong

I am able to create a character, in this example a character named "Oldsong". I am not able to log into the character. I unable start i seem to be missing inventory from my database. Ive looked in everything ive downloaded and while Ive found updates and changes to an existing inventory within my database, nothing that says, "CREATE TABLE INVENTORY"

[Adcid]

resolved my missing Inventory table in my database. Found that the most recent player_tables_2014-10-11-02_01.sql file did not contain the needed inventory tables required to finish server. I was however able to download the previous version "player_tables_2014-09-25-02_01.sql" that had the inventory tables for the server.

I hope anyone trying to start a Windows based server will read this and save themselves a bit of frustration.