Updated Windows Server Setup Guide

[Oogbar]

While going through your Server Setup Guide, i ran into a major problem after completing the first part of step 3. Tried both command line, and query browser. Command line read something about an error, but disappeared instantly. Tried the Query Browser... had Server Host: 127.0.0.1 Port 3306, name: root, password: oogbar *Worked up until i tried utilizing the walkthrough step 3, for some reason*. Hit connect... aaaannnd... "Could not connect to the specified instance. *2 lines down* MySQL Error Number 2003 *next line down* Can't Connect to MySQL server on '127.0.0.1' (10061) *2 lines down* If you want to check the network connection, please click the Ping button." *Press Ping* "Pinging 127.0.0.1 *Line down* Reply from 127.0.0.1: Time = 0ms TTL = 128" any ideas on what went post-nuclear hari-kari?

[Oogbar]

While going through your Server Setup Guide, i ran into a major problem after completing the first part of step 3. Tried both command line, and query browser. Command line read something about an error, but disappeared instantly. Tried the Query Browser... had Server Host: 127.0.0.1 Port 3306, name: root, password: oogbar *Worked up until i tried utilizing the walkthrough step 3, for some reason*. Hit connect... aaaannnd... "Could not connect to the specified instance. *2 lines down* MySQL Error Number 2003 *next line down* Can't Connect to MySQL server on '127.0.0.1' (10061) *2 lines down* If you want to check the network connection, please click the Ping button." *Press Ping* "Pinging 127.0.0.1 *Line down* Reply from 127.0.0.1: Time = 0ms TTL = 128" any ideas on what went post-nuclear hari-kari?

[Oogbar]

Tried "mysql -root -p" from RUN.
Enter password: *enters any of a giant plethora of passwords*
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) *Same as the last trillion messages, but at least the stupid RUN command box doesn't instantly disappear after i enter the password!!* ;shoots his compuker! *Oogbar shoots his compuker!*

[fantum409]

Thanks Vales, great guide. I followed the guide exactly, except as follows:
Use ActivePerl-5.8.9.826-MSWin32-x86-290470.msi instead of the 5.10xxxx version. The 5.8.8 version will not work either.

Additionally, I changed the eqemu_config.xml as I want this to work on a private LAN without setting up a public IP or port forwarding, etc to allow access from outside. Here is my eqemu_config.xml file, v1. All seems to work for me now. so far...

<?xml version="1.0">
<server>
	<world>
		<shortname>Virgilhome</shortname>
		<longname>EQ@Virgilhome</longname>
                <address>172.16.0.25</address>
                <localaddress>172.16.0.25</localaddress>
                <loginserver>
                        <host>172.16.0.25</host>
                        <port>5998</port>
                        <account></account>
                        <password></password>
                </loginserver>
		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>putsomethingorotherinhere</key>
	</world>
	<database>
		<host>localhost</host>
		<port>3306</port>
		<username>root</username>
		<password>mypassword</password>
		<db>peq</db>
	</database>
</server>

[Oogbar]

Ok... the magical solution for if you dont know your MySQL root password! *Though its a bit painful* Un-install all MySQL, Go to your compuker's search option, search for MySQL *Because uninstall leaves some stuff*, and delete the leftovers. Found this out by getting severely irritated with the program, and went on a deleting spree.

[pfyon]

I think the default WAMP install uses the username 'root' and no password.

[Kobaz]

You can reset the root password for mysql by stopping mysql and restarting it using the following command:

mysqld --skip-grant-tables --skip-networking

This starts mysql without any security, hence disabling networking support.

You can then run the client, where you

use mysql;

and use standard SQL commands to reset your root password. Then stop mysql, and restart it normally.

[everlastnmn]

I'm using rev1052 and the login server .bat file errors out - windows could not find 'world' or 'eqlaunch'... frustrating..

[WkimWes]

Originally Posted by everlastnmn

I'm using rev1052 and the login server .bat file errors out - windows could not find 'world' or 'eqlaunch'... frustrating..

I think you are missing the statement

c:
CD c:\[folder] the folder name will be where those files are located.

[everlastnmn]

Seriously, can someone update this ? I have followed this word for word and it dosen't work. Specifically the .bat file. I tried the change directory as suggested above and still no dice.

[mastajon]

this guide is missing alot of stuff. the one on the wikki is your best bet.

[mastajon]

once you extract the files you have to take all the sql files and put them in just the bin folder, they cant be in any sub directories. try that out

[threeflies]

Fantastic mastajon ! worked like a charm

Now why on earth couldn't Vales server set-up guide explain that , I can't be the only person to trip-up on this bit

Thanks again !


Thanks also to Vales , whom without the guide we would'nt even know where to start

[Frumph]

Server runs great, it compiles, database appears to be working can play online and all that jazz but the LDoN (after doing the quest) and all that, the adventure recruiter still doesnt bring up any adventures, I noticed the Debug zone log file has this in it: Client::SendAdventureSelection(): NPC had no template id

This is using the latest PEQ database from the repository and I looked up the NPC and it's true all of the npc's have 0 set as template id ..

How are people getting the LDoN's working?

[Derision]

I don't know a lot about LDoN, but I believe the only ones currently implemented in the PEQ database are Mistmoore Catacombs. Those are available from Xyzelauna_Tu`Valzir in Butcherblock.

She is the only NPC with an Adventure_Template > 0 in my (few weeks old) copy of the database.