EOC not working?

[ionhsmith]

Does EOC still work with the new servers? I followed the steps in the wiki, set up my user in mysql but it will not let me connect. Ports are open for 3306 , my outside ip is inputed, database name, username, and pw ... says
Cannot connect to server!
Cannot connect to database peq

[Akkadius]

It's working just fine, make sure to follow this guide:

http://wiki.eqemulator.org/p?EQEmu_Operations_Center_for_Development&frm=Main#create-your-database-user

[ionhsmith]

I did follow it exactly and thats issue i got

[ionhsmith]

well it verified connection but does nothing when i click the login button

[ionhsmith]

I got it to work on an outside connection but if I use a pc on the same network it will not connect. How do I fix that ?

[Maze_EQ]

I got it to work on an outside connection but if I use a pc on the same network it will not connect. How do I fix that ?

Is the account you are trying to use for the database login granted permissions from that host?

Are you trying to resolve an external ip/port locally? need moar detail kiddo.

[ionhsmith]

Not really sure what you asking.... I followed the guide on how to create the user and everything for EOC. I log onto in via my main pc at home and it will not let me connect. I take my laptop over to my dads house and it lets me connect just fine from his network. so for some reason I cannot connect from inside the same network the server is on

[Maze_EQ]

Not really sure what you asking.... I followed the guide on how to create the user and everything for EOC. I log onto in via my main pc at home and it will not let me connect. I take my laptop over to my dads house and it lets me connect just fine from his network. so for some reason I cannot connect from inside the same network the server is on

What IP address are you trying to connect to for EOC on your local network?

[ionhsmith]

my outside ip address

[kalarcana]

I'm having the same problem as ionhsmith. I've done 9 fresh installs in the past 2 days. Yes, that does mean on a fresh VM install each time. I can get my server up and running. I can set up GM accounts and play. I can even access the database via HeidiSQL. I've used Navicat and created a new user login. I simply can't get EOC to work. I keep getting the same error messages.

Cannot connect to server!
Cannot connect to database peq

I can't get it to work with either an inside or outside connection. I can't figure it out even though I've followed the instructions exactly. It's very irritating.


Rick

[Maze_EQ]

my outside ip address

You cannot resolve an external IP Address internally.

PM me (both of you) and I'll see if I can resolve it.

Works perfectly fine for me.

https://i.imgur.com/SfGndiv.png

[joligario]

You cannot resolve an external IP Address internally.
Probably better to say that "most" routers don't allow loopback inherently.

[Akkadius]

If you ran your user creation with the DNS name - some folks have been issues with that. So you may want to try re-creating the EOC user using the IP instructed in the Wiki guide

[ionhsmith]

i Can connect outside my network but not on any pc inside... do i have to create a user that allows network ips to connect ?

[Maze_EQ]

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
Then

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

[kalarcana]

Ok, using Navicat I'm still running into a problem. I created a new user using the example above. However, when I try to edit the user under that Advanced Tab I can't change the "Max User Connections" to 1. I keep getting the following error: "1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'mycreatedname' @ 'localhost' WITH MAX_USER_CONNECTIONS 1' at line 1"


Rick