Go Back   EQEmulator Home > EQEmulator Forums > Development > EQEmu Operations Center

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2018, 09:55 PM
serenity2017
Fire Beetle
 
Join Date: Nov 2017
Location: PA
Posts: 9
Default Having issues connecting

Hello,
Sorry to be a bother. I tried giving myself access again using eoc.akkadius.com instead of the previous IP address. Like it showed on the post on the homepage, after not being able to connect.

I cleared my cookies, used a few different browsers, and tried two other pcs before posting here. I can't seem to make a connection, I never had any issues connecting from either of the pc's previously.

I get the following:
Cannot connect to server!
Cannot connect to database peq


Thanks in advance for any assistance
Reply With Quote
  #2  
Old 01-03-2018, 10:20 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

(Actually, you said you did try that - disregard)
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #3  
Old 01-03-2018, 10:29 PM
Coenxai's Avatar
Coenxai
Hill Giant
 
Join Date: Dec 2013
Posts: 151
Default

Are you sure you properly gave the new host access? Firewall rule? MySQL?
__________________
"The true sign of intelligence is not knowledge but imagination."
Reply With Quote
  #4  
Old 01-03-2018, 11:00 PM
serenity2017
Fire Beetle
 
Join Date: Nov 2017
Location: PA
Posts: 9
Default

I think so... I'm getting this message when I do the localhost: testpeqdatabase option at eoc.

Could not connect: Access denied for user 'XXXXX'@'localhost' (using password: YES)
Reply With Quote
  #5  
Old 01-04-2018, 12:25 AM
serenity2017
Fire Beetle
 
Join Date: Nov 2017
Location: PA
Posts: 9
Default

I tried downloading google chrome to ensure no cookies or anything were saved. No luck. I also checked to make sure port 3306 was still open and it was.

I created and granted all permissions to another account just to ensure I didn't mess up the first time and still the same issue.

I setup the connection on a dedicated server, as I always have in the past. I've never had any issues connecting to EOC tools this way. Always got on first try.
Reply With Quote
  #6  
Old 01-04-2018, 12:32 AM
Coenxai's Avatar
Coenxai
Hill Giant
 
Join Date: Dec 2013
Posts: 151
Default

Flush privileges

(Edit: Will try to connect and see)
__________________
"The true sign of intelligence is not knowledge but imagination."
Reply With Quote
  #7  
Old 01-04-2018, 12:51 AM
Coenxai's Avatar
Coenxai
Hill Giant
 
Join Date: Dec 2013
Posts: 151
Default

In the hostname did you put 142.44.176.142?
__________________
"The true sign of intelligence is not knowledge but imagination."
Reply With Quote
  #8  
Old 01-04-2018, 01:30 AM
serenity2017
Fire Beetle
 
Join Date: Nov 2017
Location: PA
Posts: 9
Default

I'm not sure how to properly flush privileges. I'm using HediSQL. I opened HediSQL and done FLUSH PRIVILEGES; if I needed to follow granting all privileges with the flush then I done it incorrectly. I tried to connect after doing the flushing of privileges after reading the reply, but that didn't seem to help. But maybe I done it incorrectly. I'm still learning

this is what I am using to create my user account:
CREATE USER 'eocdev'@'eoc.akkadius.com' IDENTIFIED BY '********';

GRANT GRANT OPTION ON *.* TO 'eocdev'@'eoc.akkadius.com';

GRANT ALL ON *.* TO 'eocdev'@'eoc.akkadius.com';

Should I be using the suggest IP 142.44.176.142 instead of eoc.akkadius.com?

On the connection page http://eoc.akkadius.com/EOC2/login.php

I do my server IP address
database name: peq
username: eocdev
password: *******

Thanks for the help, I was working on spells and then lost connection *sigh*
Reply With Quote
  #9  
Old 01-04-2018, 02:06 AM
Coenxai's Avatar
Coenxai
Hill Giant
 
Join Date: Dec 2013
Posts: 151
Default

use the ip address and try
__________________
"The true sign of intelligence is not knowledge but imagination."
Reply With Quote
  #10  
Old 01-04-2018, 02:52 AM
serenity2017
Fire Beetle
 
Join Date: Nov 2017
Location: PA
Posts: 9
Default

That seems to have fixed the issue. Thanks very much for the assistance!
Reply With Quote
  #11  
Old 01-04-2018, 12:57 PM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

I seem to have similar problem:
Cannot connect to server!
Cannot connect to database peq

I made firewall rule
and made port forwarding in router open to 142.44.176.142 for port 3306

Any suggestions?

NM I got it working - the port opening has to be for my local PC
Reply With Quote
  #12  
Old 01-11-2018, 02:51 PM
mrhodes78
Fire Beetle
 
Join Date: Dec 2005
Posts: 2
Default

Hi all,

I'm having a similar problem, which I suspect has to do with my dynamic IP address...(forced to use AT&T U-Verse for my connection for now...oy.) I tried port forwarding on my router and my Windows firewall, using the direct IP address for setting up the mySQL user, and nothing seems to work. I'll keep trying but I'm running out of ideas.

My backup plan was to try to download a local copy of EOC to use directly on my machine here:

https://github.com/Akkadius/EQEmuEOC

Unfortunately, this download link:

http://wiki.eqemulator.org/eoc2_dev_debian_7_8.rar

Seems to be broken...is there a mirror anywhere?

Thanks a lot!

EDIT: Good lord. I tried for hours last night, but I just got it to connect via Akkadius' online tool. Was a stupid mistake...I did NOT have port forwarding on my router setup properly as I thought. I had to make sure that I had the port/allowable IP forwarded specifically for my desktop via the router. First time using this router...so I'll blame that. This thread was helpful. Thanks all.

Last edited by mrhodes78; 01-11-2018 at 02:59 PM.. Reason: Stupidity.
Reply With Quote
  #13  
Old 09-02-2018, 09:49 PM
Arune01
Fire Beetle
 
Join Date: Apr 2014
Posts: 3
Default

This link is still broken - any update?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:40 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3