EOC wont connect

[knight-mare]

cant get EOC to connect....
ive run GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
to my sure sql accepts root

i have eoc user listed as a user in my db

but when i go to eoc it says Cannot connect to server!
Cannot connect to database peq

mysql is not normal install in running uniserver (for other databases too) server works fine and people can log in etc

any ideas please?

[epilz]

I have not been able to connect to EOC today either. Did you read the WIKI....

Did you grant access like the instruction state?


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

[knight-mare]

yep i did all that but it just refuses to connect to database PEQ

[dagulus2]

It does seem very, very slow over the last couple of days, but I don't know if that is due to issues my end or theirs.

[markusdabrave]

It's working fine for me. Are you forwarding port 3306 to your server?

[knight-mare]

yep ports and everything are set it just tells me its can not connect to databse peq

[epilz]

Eoc works fine for me. I think my issue was ip change that screwed it up. Use a port checker to verify that port can be seen externally.

[knight-mare]

Ports are fine as i said before server works fine... i also host websites off the same machine and they work fine.... i believe its some issue with EOC speaking to my server ... just cant get my finger on it

[knight-mare]

p.s mail server i host also works fine... only issue i have is eoc :/

[Akkadius]

What you can try to do if the bottleneck is your MySQL server responding poorly is in your MySQL config make sure you have --skip-name-resolve in the config

http://www.vionblog.com/skip-name-resolve-to-speed-up-mysql-and-avoid-problems/

If a lot of people have recently noticed slower issues I will not rule that out.

Another thing is, if your IP did change and EOC is trying to connect to it, you will ultimately need to delete that connection in EoC and create another.

And in terms of MySQL being able to be seen (knight-mare), make sure you troubleshoot all basic visibilities (port, MySQL access).

http://wiki.eqemulator.org/p?EQEmu_Operations_Center_for_Development#eqemu-operations-center-eoc-20

[knight-mare]

aka i cant get my head round this ..... 1 minute it only loads for a set or too next minute it loads for awhile but all ways the same issue cant connect to DB... do you have any logs on ur end?

[knight-mare]

this issue is something with uniform server

installed mysql apache and php (normal way) and all is good