Question - Making own server

[fleqfan]

Good luck. That seems much harder than just installing the server on a windows PC. With the Windows install you get Spire by default which is well worth it. PEQ Editor still has its uses but it's outdated by Spire.

I got Spire up and working, cannot get PEQ editor to load for some reason mysqli in PHP is not loading no matter what I do. So far Spire and just manually changing things in the DB have worked and I have been keeping a SQL update record of changes I have made to save if they get over written by a new db update. So far very cool having ones own server.

 

[Schuckenstein]

Search for eqemu EOC and the dev has a hosted version of peq editor. All you need to do is connect it to your database and have web access. You can do alot with Heidi, spire and EOC tools.

 

[fleqfan]

Search for eqemu EOC and the dev has a hosted version of peq editor. All you need to do is connect it to your database and have web access. You can do alot with Heidi, spire and EOC tools.

Thanks! I will probably need to have my server not at work so I can open up the ports needed for EoC. Got everything else working but cannot connect to the internal ip without the port being forwarded I am thinking.

 

[mitrestre]

Thanks! I will probably need to have my server not at work so I can open up the ports needed for EoC. Got everything else working but cannot connect to the internal ip without the port being forwarded I am thinking.

If you are outside your network, you will have to forward your ports. Port forwarding is not needed if connecting on the same LAN.

 

[fleqfan]

If you are outside your network, you will have to forward your ports. Port forwarding is not needed if connecting on the same LAN.

Yeah pretty sure that is the case with EoC 2.0.

 

[mitrestre]

I am trying to edit stack counts and some items show up in my peq sql editor, others do not. If i use Spire, I can find all the items but some of them will not let me edit them. It just times out while others have no problems. I figured I would try using EoC 2.0 to see how it works but when I try to create the user using HeidiSQL I get a popup that says access denied. has anyone had this same problem and was able to figure it ou?

 

[fleqfan]

I was getting that issue too and had to create a root level user for my DB and it took me awhile to figure it out and now I cannot remember which way worked as I tried like 15 different ways until I got a write-up that actually worked with the version of PHP and HeidiSQL I was using.

 

[Schuckenstein]

I am trying to edit stack counts and some items show up in my peq sql editor, others do not. If i use Spire, I can find all the items but some of them will not let me edit them. It just times out while others have no problems. I figured I would try using EoC 2.0 to see how it works but when I try to create the user using HeidiSQL I get a popup that says access denied. has anyone had this same problem and was able to figure it ou?

Windows server? open up MySql Client and then type in the following:

CREATE USER 'eoc_database_user'@'192.99.119.164' IDENTIFIED BY 'eoc_database_password';
GRANT GRANT OPTION ON *.* TO 'eoc_database_user'@'192.99.119.164';
GRANT ALL ON *.* TO 'eoc_database_user'@'192.99.119.164';

 

[matthew8732]

Windows server? open up MySql Client and then type in the following:

CREATE USER 'eoc_database_user'@'192.99.119.164' IDENTIFIED BY 'eoc_database_password';
GRANT GRANT OPTION ON *.* TO 'eoc_database_user'@'192.99.119.164';
GRANT ALL ON *.* TO 'eoc_database_user'@'192.99.119.164';

If you are going to use the public EoC this step is important. Please don’t open your root user to the internet with the default password.

Seen it done a few times over the years.

 

[Schuckenstein]

If you are going to use the public EoC this step is important. Please don’t open your root user to the internet with the default password.

Seen it done a few times over the years.

Yeah change out the info, that wasn't like a copy-and-paste solution. I guess it came off that way, just relaying what the Eqemu devs have posted.

 

[matthew8732]

Yeah change out the info, that wasn't like a copy-and-paste solution. I guess it came off that way, just relaying what the Eqemu devs have posted.

It would be fine as a copy paste solution actually because you aren’t just opening it to the entire internet.. even if people know the password it won’t matter because they would only be able to connect from 192.99.119.164 (Akka’s eoc host ip).

By default the root user starts out as restricted to 127.0.01 (localhost) but i’ve seen people be lazy and smack a % on there without even changing the password which opens it up to be able to utilize any IP address. In order for literally anyone to do any number of malicious things they would simply need the ip of your server which is easily found the second you log into it with various ways.

You should still put a strong password on your eoc user but just the IP restriction will stop little Timmy from stealing and then deleting your database. Really for the best security you should be hosting your own on the same box the server is being hosted from and just shut it off from the internet entirely (by closing port 3306). Akkadius is trustworthy but allowing db access to entities you don’t own or 100% control is generally bad practice.

In my opinion the only tools really worth using are the item editor on EoC if you want to just make a single item real quick and the spell editor on the PEQ editor if you want to edit / make a spell real fast. For most heavy work simply using Navicat (or Heidisql I guess but I can’t stand it) and queries will be so much faster. Once you learn to do a few simple queries (mainly just selects / updates) you will be much faster than using any of the editors (that’s all they are doing in the background anyway) they are a good starting point for someone with no SQL knowledge though.

 

[keiferoni78]

I am thinking about making my own server, so I can ride the current ban wave. I have tried going through the steps to start but cannot get my client to connect. Does anyone have a good write up on how to start one? The one I found is years old and I figured it was out of date. Also, what client do I need to use to be able to use MQ? are there different versions for different clients available? Thank you

Or you could come play with me and a few others who now play on Project Lazarus! Its an MQ friendly Emu server that already exists and has custom content. You can use these coins to buy decent gear and everyone there uses the software. There's lots to do and custom things like a bracer that any class can use to coth. Hardcore zones, epics are out there. I know its not the same as live but its very friendly. People have time to talk because of MQ. Its awesome! Your characters auto follow you after you zone and such. DBG seems serious about getting rid of us. When you play on project Lazarus you realize why they are dumb and MQ solved alot of problems that made the game fun.

 

[matthew8732]

Or you could come play with me and a few others who now play on Project Lazarus! Its an MQ friendly Emu server that already exists and has custom content. You can use these coins to buy decent gear and everyone there uses the software. There's lots to do and custom things like a bracer that any class can use to coth. Hardcore zones, epics are out there. I know its not the same as live but its very friendly. People have time to talk because of MQ. Its awesome! Your characters auto follow you after you zone and such. DBG seems serious about getting rid of us. When you play on project Lazarus you realize why they are dumb and MQ solved alot of problems that made the game fun.

To add on a bit to this,

Dhaymion (the server operator for Lazarus) is a great dude and listens to player feedback. A lot of people who want to run servers in the emulator community have always gotten hung up on trying to make gimmicky changes or thinking they need to be some programming god. I’ve always said that rather than focusing your time on trying to recreate the wheel you should simply focus on making simple, fun, and engaging content. He and his server have been proof of that sentiment for years now.

When Dhaymion started he had basically zero programming experience and has ran one of the most successful custom-ish servers ever just focusing on those fundamentals. By engaging in his community and providing valid feedback you truly have the chance to have somewhat of a voice in the direction of the server.

Been friends with him for years so maybe I’m a bit biased but thought I’d add my 2 cents!