Simple question

[ouchyfish]

I am new here. I apologize profusely if I am going against any rule for asking here but...

Is there any chance at all for a complete idiots guide of step by step instructions, and I mean i-d-i-o-t-s guide, to setting up a simple little server.

basically all i want is for my wife and I to relive our old fun of playing together. I Just want to be able to play on a server, just she and i with preferably accelerated xp (300-400%). We are not looking for pvp or the griefers it brings, just a little simple server for us two to run around on.

I can't find any idiots guides out there anywhere. Anyone know of any? please?

we both already have the retail copies of the files so no, we aren't asking for those.

Thank you so very much if anyone can help me. I'm really lost here. I installed mysql, the eqemu folder, the perl walkthrough but I cant get anything working even remotely close.

Thanks all. Once again i sincerely apologize if this is wrong. =(

[GeorgeS]

Ok there's a guide from my site. I also have Techguy's excellent guide but I don't have his permission to host it. Look at my site for misc info..

Also run Cavedudes installer 3.6, and after it finishes running, refer to my site for the sql required for current schema 0.7.9xx

If you use Cavedudes installer, you must you the mysql 4.0.x from my site. Any new version won't install!
also, you start.bat file must be changed to
@echo off
start minilogin.exe
start world.exe
echo Waiting for World to finish before starting Zone...
sleep 20
start eqlaunch.exe zones

GeorgeS

[Ryori]

You know, several existing servers offer the experience you are looking for and with the dramatically lower population and increased GM oversight Griefers and PvPers do not last long in our worlds. It's pretty easy to play in a world built for 2,000 that only has 30-100 people in it and never run into the other people. When you do, you can be sure they don't want to do something that will get them /banned, and there's a greater sense of community so they are usually quite nice.

One note is that I'd make sure to pick an established server that will be around a while.

If you want an original EQ experience, join PEQ or Legacy of the Rathe. If you want to try something with GM Powers where you can be 70 in a day, try Krushers. If you want to loot your epic 60 seconds after you log in, try KMRA. If you want accelerated XP and Loot, try Jest3.

Those are the only ones I've played on that have always been around. I'm sure there are other stable servers out there as well, but before I started playing on those 5 I tried playing on 3-4 others that went *poof*, so I'd rather play on one of the ones I listed here

Good luck whatever you decide to do

[ouchyfish]

Thank you so much for all of the help. I think I might just have everything set up right. i tried to follow everything in the guide.

The only problem that I am running into right now is this:



I run boot5zones, world, then attempt to launch eq (patchme etc) and no matter what i try to login with, it stays at the login screen saying "Establishing connection with login server" but nothing ever happens. I am attempting to run my own server, etc.

here's some of my setup files:

eqemu_config:

<?xml version="1.0">
<server>
<world>
<shortname>For Dani</shortname>
<longname>Rhayneal</longname>

<!-- Only specify these two if you really think you need to. -->
<!--<address>Serving Machines IP</address>-->
<!--<localaddress>127.0.0.1</localaddress>-->

<!-- Loginserver information. -->
<loginserver>
<host>eqlogin1.eqemu.net</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

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

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

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

and

eqhost says

[Registration Servers]
{
"localhost:3306"
}
[Login Servers]
{
"localhost:3306"
}




Thanks for any and all help!!!!

[ouchyfish]

Oh--BTW--The "Establishing connection with login server" message happens even if I try to connect to a proven eqemu server using their setup. Am I SOL?

[Sakrateri]

This is set to connect to eqemulator server

<!-- Loginserver information. -->
<loginserver>
<host>eqlogin1.eqemu.net</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

While your host here

eqhost says

[Registration Servers]
{
"localhost:3306"
}
[Login Servers]
{
"localhost:3306"
}

Is trying to connect to your computer.

Try this in your eqhost.txt

[Registration Servers]
{
"127.0.0.1:5998"
}
[Login Servers]
{
"127.0.0.1:5998"
}

And this in your set up

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

[ouchyfish]

Hi! Thanks for the reply!!! =)

Tried your solutions but same result =(

Any other suggestions?

[ouchyfish]

hey!! i think that I'm making progress!!!



Still sits there saying attempting connection to the login server though =(

[Congdar]

One thing I noticed is that your rule set is not getting loaded. For some reason the default setting for the rule_sets table has ruleset_id set to 2 when it should be set to 0 to match the ruleset_id in the rule_values table. I pm'd Cavedude on this but he didn't reply.

This doesn't solve your problem though. It seems you still have something wrong with the settings in the eqemu_config.xml or the loginserver.ini file.

[Sakrateri]

Are you starting up a minilogin to connect too??

[cavedude]

Originally Posted by Congdar

One thing I noticed is that your rule set is not getting loaded. For some reason the default setting for the rule_sets table has ruleset_id set to 2 when it should be set to 0 to match the ruleset_id in the rule_values table. I pm'd Cavedude on this but he didn't reply.

Sorry, I don't remember that PM. But, if you have data in either rule_sets or or rule_values, then you aren't using a supported version of PEQ. Both releases and CVS have blank tables for both.

[Congdar]

ahh yes, the rule_sets rule_values must have come from the old CVS address that you were using in July 2007? I'm guessing the drop_system.sql doesn't drop the old stuff when upgrading to your new releases.

-- MySQL dump 10.11
--
-- Host: localhost    Database: PEQ_CVS
-- ------------------------------------------------------
-- Server version	5.0.38-Ubuntu_0ubuntu1-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `rule_sets`
--

DROP TABLE IF EXISTS `rule_sets`;
CREATE TABLE `rule_sets` (
  `ruleset_id` tinyint(3) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ruleset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rule_sets`
--

LOCK TABLES `rule_sets` WRITE;
/*!40000 ALTER TABLE `rule_sets` DISABLE KEYS */;
INSERT INTO `rule_sets` VALUES (2,'default');
/*!40000 ALTER TABLE `rule_sets` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-07-27 20:48:25

Anyways... ouchyfish,

"Sakrateri: Are you starting up a minilogin to connect too?? "

try these links for the minilogin stuff:
http://easynews.dl.sourceforge.net/s...niLogin6.2.zip
http://www.eqemulator.net/wiki/wikka...MiniLoginSetup

[cavedude]

It does, but only the system tables. Rules are considered player tables, so you'd need to use drop_player.sql for that, of course that wipes account and toon info as well. Basically, any table that is commonly changed by server ops we consider user, the actual content of the db are all found within system.