EQEmulator Forums - EOC not working?

Page 1 of 2

Show 40 post(s) from this thread on one page

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

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - EOC not working? (https://www.eqemulator.org/forums/showthread.php?t=41760)

ionhsmith

02-11-2018 07:51 PM

EOC not working?

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

02-11-2018 09:01 PM

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

http://wiki.eqemulator.org/p?EQEmu_O...-database-user

ionhsmith

02-12-2018 08:56 PM

I did follow it exactly and thats issue i got

ionhsmith

02-12-2018 09:01 PM

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

ionhsmith

02-14-2018 02:01 PM

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

02-14-2018 02:26 PM

Quote:

Originally Posted by ionhsmith (Post 257615)

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

02-14-2018 04:35 PM

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

02-14-2018 07:24 PM

Quote:

Originally Posted by ionhsmith (Post 257619)

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

ionhsmith

02-15-2018 07:18 PM

my outside ip address

kalarcana

02-16-2018 02:12 PM

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

02-16-2018 04:44 PM

Quote:

Originally Posted by ionhsmith (Post 257634)

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

02-16-2018 08:54 PM

Quote:

Originally Posted by Maze_EQ (Post 257648)

You cannot resolve an external IP Address internally.

Probably better to say that "most" routers don't allow loopback inherently.

Akkadius

02-17-2018 08:37 PM

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

02-19-2018 09:05 PM

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

02-20-2018 12:17 PM

Code:

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

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

Then

Code:

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

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

All times are GMT -4. The time now is 08:00 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page