EQEmulator Forums - EOC BETA Launch (Developer's Tool) EQEmu Operations Center

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- EQEmu Operations Center (https://www.eqemulator.org/forums/forumdisplay.php?f=679)

- - EOC BETA Launch (Developer's Tool) EQEmu Operations Center (https://www.eqemulator.org/forums/showthread.php?t=36662)

Quote:

Originally Posted by atrayas (Post 255098)

Its quite simple, forward port 3306, run the sql query with the proper db user/password inserted and thats about it. Log in with the correct credentials after you run the query and your set.

It should be a fast $20 lmk bro lol I sat here for like 3 hours.

Sooo anyone want to do this team viewer style for me ??
$$$$$$$

It isnt hard set up and i never used team viewer i only used VNC

If you still need this done dude, I'll do it for you, hit me up.

Quote:

Does anyone know why port 3306 is still closed after all my attempts to open it?

I've manually went to my router's IP address and gone to the port forwarding section and added 3306, protocol set to BOTH, but when using a port checker it says closed. The address is the IPv4 address of my computer. I've tried it using my IPv4 address, my ip from whatismyip and also the default gateway, but nothing works.

https://imgur.com/OWc3OIU
https://imgur.com/kITQSSB

Problem solved. Apparently my firewall didn't save the rule I had implemented earlier and I just didn't double check.

Quote:

Originally Posted by Akkadius (Post 219580)

Creating a MySQL user: (By JSR)
If using Navicat;
- Click 'User' on the main ribbon
- Right click 'root@localhost'
- Choose 'duplicate user'
- In the username field, change it to something preferable to root_Copy (or keep it if you think it has a nice ring to it)
- In the host field, replace 'localhost' with '69.168.254.244'
- In the password/confirm password fields, enter a secure password. Note: A long password (e.g. dogsandcatslikerawfishfordinner) is exponentially more secure than one with uppercase, lowercase, numbers, and symbols while also being much easier to remember
- Under the advanced tab, change 'max user connections' to 1
- Under the server privileges tab, uncheck the privileges 'File', 'Process', 'Drop', 'Shutdown', 'Super', and 'Create user' (there may be others worth disabling)
- Click Save

I got a question about this part - how do you do it with HeidiSQl that now comes with server automatic install?

Thank You ;)

Hello,

The EOC suite of tools are all functional for my recent install, but PEQ Rev 501 & 460 are only partially functional...

I can see correct data under 'Players' and 'Accounts', but anything referencing a zones in a drop-down menu shows the Zone's short zone name along with (0).

Any chance this can be fixed? Perhaps some sort of header issue, or missing reference with the latest Windows Server Repack?

Thank you!

Quote:

Originally Posted by Nydosa (Post 258307)

PEQ Rev 501 & 460 are only partially functional...

Are you talking about old, obsolete and outdated versions of the database ?

PEQ Editor Rev 501 in the EoC suite of tools. It looks like it was last updated in May 2016. Some of the functionality still works, but it looks like there is a disconnect in its ability to read Zones correctly.

I got GeorgeS's zone editor tool working, so that'll suffice, I just like the fact that i don't have to install anything to use Akkadius' tool on other laptops.

Oh ok, sorry, I only logged onto that EOC once in the past and discovered I didn't need it, but use
George's tools as well, along with an item editor tool, etc. Does the trick for me.

Pretty sure I have done everything needed to connect to eoc, but still getting the same 2 error messages when trying to log onto eoc

made a new user with a password, changed it from localhost to all, and has permissions for all database (and peq database)

added a rule in my firewall to allow port 3306 through

someone said something about fowarding a port on my router? but when i login to my router, i dont see any such option to do that.

if anyone could help it would be awesome, thanks a ton

Quote:

Originally Posted by tako_EQ (Post 260564)

When you go to your router page it's usually under the "Advanced" settings, sometimes under a subsection called "Port Forwarding". Some routers give you the option to only do UDP or TCP, some give the option to do both.

If you still can't find it you can download Simple Port Forwarding here and just select your router model and put in your username/password, then input the port you want to forward and it'll do it automatically.

Additionally, to check if your ports are actually open, you can check here

If you open port 3306 on your firewall and router and it still doesn't work, most likely your database permissions are wrong. Try running the command below, where "username" is the username you want and "password" is the password you want

Code:

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password';

I'm trying to use the Zone Copy tool to copy a zone from one database to another but when I get to the 'Database Connection to Import Content from ' section, the dropdown says 'select' and that is all - any tips on getting this to work?