Updated Windows Server Setup Guide - Page 6

Whoopee · #76 10-06-2009, 12:26 AM

As explained above in Step 2, create a new folder and name it something easy to remember like EQEmu Server Files or something.
Right-click that folder, and paste in the SVN address: http://projecteqemu.googlecode.com/svn.

create this folder where?

daryl · #77 10-18-2009, 07:14 AM

Download Revision 774 with Bots here. that link on first page dont work

TG1969 · #78 11-06-2009, 09:59 PM

Has the bots have a new link?

OpIeWoRkS · #79 11-09-2009, 07:09 AM

I am trying this install but am stuck on step 4. When I try to source the database I get:
ERROR:
Failed to open file 'peqdb_rev1038.sql' , error: 2

Read in the post where someone was having same issue and figured it out but unfortunately didn't say what to do to fix problem. If anyone can help me I would really appreciate it.

OpIeWoRkS · #80 11-09-2009, 07:18 AM

You can get the server pack from:
http://code.google.com/p/projecteqemu/downloads/list
hope that helps

**trevius** · #81 11-09-2009, 08:27 AM

In order to be able to source those files, make sure you are in the same folder as those files are located before you log into the mysql server. Or, if you have Navicat or something, you can just run them from the GUI.

**Shin Noir** · #82 11-09-2009, 09:17 AM

someone should write a "SQL security for dummies using EQEMU" wiki and all wiki setup guides reference to it.

bthomsen0312 · #83 11-10-2009, 12:40 AM

so the multitude of guides on thie site confuse me, as it seems like all of them tie together in some weird way, however i followed the steps on this guide and ended up with the error perl58.dll is missing.. i tried searching was there something i missed? the only thing im seeing is that i should have the other used version of perl but i followed this guide

Oogbar · #84 11-10-2009, 05:04 AM

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 · #85 11-10-2009, 06:16 AM

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 · #86 11-10-2009, 06:49 PM

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 · #87 11-20-2009, 12:10 AM

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

Code:

<?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 · #88 11-24-2009, 08:48 PM

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 · #89 11-25-2009, 12:10 AM

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

Kobaz · #90 11-25-2009, 02:57 AM

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

Code:

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

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

You can then run the client, where you

Code:

use mysql;

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