Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #16  
Old 03-20-2017, 08:35 PM
ghanja's Avatar
ghanja
Dragon
 
Join Date: Aug 2012
Location: Hershey, PA
Posts: 499
Default

Quote:
Originally Posted by ionhsmith View Post
this is what it is saying...
Cannot connect to server!
Cannot connect to database peq

i do a port checker for 3306 and it says its blocked... i have it port forwarded and allowed in windows firewall. still not sure what to do to get it working again
The port (3306) in Windows Firewall were likely tied to a different .exe location. Either way, it's typically best to just remove the rules and then implement them again. I've noticed for whatever reason (likely a corruption of Window$ DB), that this often helps regardless of the situation.

I say the above on the assumption that the computer you're attempting to get this working on is the same computer as EQEMU was working on before (somewhere up there you said "again" as Grumpy pointed out). And that said computer has the same static IP address it had before (because I further assume you're running at least a consumer grade "router"/NAT).

Then also, did you repeat the process of making a SQL account for the EoC/editor (assuming you aren't using root - which just isnt the best practice)?
Reply With Quote
  #17  
Old 03-20-2017, 08:36 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Quote:
Originally Posted by Maze_EQ View Post
Throw up teamviewer and drop $100 into my paypal.
I think I saw an ad like that on backpage ? hahaha :P
Reply With Quote
  #18  
Old 03-20-2017, 10:42 PM
rhyotte
Hill Giant
 
Join Date: Jul 2012
Location: Oklahoma
Posts: 222
Default

I will say... Maze_EQ helped me get my router settings fixed.

Thanks again
Reply With Quote
  #19  
Old 03-20-2017, 10:43 PM
ionhsmith
Discordant
 
Join Date: Jun 2014
Posts: 284
Default

Uleat:

TCP [::1]:51066 [::1]:3306 ESTABLISHED
TCP [::1]:51067 [::1]:3306 ESTABLISHED
TCP [::1]:51068 [::1]:3306 ESTABLISHED
TCP [::1]:51069 [::1]:3306 ESTABLISHED
TCP [::1]:51070 [::1]:3306 ESTABLISHED
TCP [::1]:51071 [::1]:3306 ESTABLISHED
TCP [::1]:51072 [::1]:3306 ESTABLISHED
TCP [::1]:51073 [::1]:3306 ESTABLISHED
TCP [::1]:51074 [::1]:3306 ESTABLISHED
TCP [::1]:51075 [::1]:3306 ESTABLISHED
TCP [::1]:51076 [::1]:3306 ESTABLISHED
TCP [::1]:51077 [::1]:3306 ESTABLISHED
TCP [::1]:51078 [::1]:3306 ESTABLISHED
TCP [::1]:51079 [::1]:3306 ESTABLISHED
TCP [::1]:51080 [::1]:3306 ESTABLISHED
TCP [::1]:51081 [::1]:3306 ESTABLISHED
TCP [::1]:51082 [::1]:3306 ESTABLISHED
TCP [::1]:51083 [::1]:3306 ESTABLISHED
TCP [::1]:51084 [::1]:3306 ESTABLISHED
TCP [::1]:51085 [::1]:3306 ESTABLISHED
TCP [::1]:51086 [::1]:3306 ESTABLISHED
TCP [::1]:51087 [::1]:3306 ESTABLISHED
TCP [::1]:51088 [::1]:3306 ESTABLISHED
TCP [::1]:51089 [::1]:3306 ESTABLISHED
TCP [::1]:51090 [::1]:3306 ESTABLISHED
TCP [::1]:51091 [::1]:3306 ESTABLISHED
TCP [::1]:51092 [::1]:3306 ESTABLISHED
TCP [::1]:51093 [::1]:3306 ESTABLISHED
TCP [::1]:51094 [::1]:3306 ESTABLISHED
TCP [::1]:51095 [::1]:3306 ESTABLISHED
TCP [::1]:51096 [::1]:3306 ESTABLISHED
TCP [::1]:51097 [::1]:3306 ESTABLISHED
TCP [::1]:51099 [::1]:3306 ESTABLISHED
TCP [::1]:51100 [::1]:3306 ESTABLISHED
TCP [::1]:51101 [::1]:3306 ESTABLISHED
TCP [::1]:51102 [::1]:3306 ESTABLISHED
TCP [::1]:51103 [::1]:3306 ESTABLISHED
TCP [::1]:51104 [::1]:3306 ESTABLISHED
TCP [::1]:51105 [::1]:3306 ESTABLISHED
TCP [::1]:51106 [::1]:3306 ESTABLISHED
TCP [::1]:51107 [::1]:3306 ESTABLISHED
TCP [::1]:51108 [::1]:3306 ESTABLISHED
TCP [::1]:51109 [::1]:3306 ESTABLISHED
TCP [::1]:51110 [::1]:3306 ESTABLISHED
TCP [::1]:51111 [::1]:3306 ESTABLISHED
TCP [::1]:51112 [::1]:3306 ESTABLISHED
TCP [::1]:51113 [::1]:3306 ESTABLISHED
TCP [::1]:51114 [::1]:3306 ESTABLISHED
TCP [::1]:51115 [::1]:3306 ESTABLISHED
TCP [::1]:51116 [::1]:3306 ESTABLISHED
TCP [::1]:51117 [::1]:3306 ESTABLISHED
TCP [::1]:51118 [::1]:3306 ESTABLISHED
TCP [::1]:51119 [::1]:3306 ESTABLISHED
TCP [::1]:51120 [::1]:3306 ESTABLISHED
TCP [::1]:51121 [::1]:3306 ESTABLISHED
TCP [::1]:51122 [::1]:3306 ESTABLISHED
TCP [::1]:51123 [::1]:3306 ESTABLISHED
TCP [::1]:51124 [::1]:3306 ESTABLISHED
TCP [::1]:51125 [::1]:3306 ESTABLISHED
TCP [::1]:51126 [::1]:3306 ESTABLISHED
TCP [::1]:51127 [::1]:3306 ESTABLISHED
TCP [::1]:51129 [::1]:3306 ESTABLISHED

Grumpy: Yes my ports where open before when I built a server from scratch. I got a new pc to use as a server so I decided to try the repack instead this time. I also got a new router but I copied my port forwarding exactly like my old one was. So really its an all new setup
Reply With Quote
  #20  
Old 03-20-2017, 10:46 PM
ionhsmith
Discordant
 
Join Date: Jun 2014
Posts: 284
Default

ghanja: I am using the same pc that has the eqemu server on it yes. The ip address changed from my old set up when I got a new router I ran the script in MySQL to set up the new user instead of using root but I don't know how to test it so see if I did it correctly
Reply With Quote
  #21  
Old 03-20-2017, 11:05 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

That's definitely localhost...

And EoC requires an external connection?
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #22  
Old 03-21-2017, 09:44 PM
ionhsmith
Discordant
 
Join Date: Jun 2014
Posts: 284
Default

so what are you suggesting?
Reply With Quote
  #23  
Old 03-22-2017, 03:51 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I can't go beyond that because I don't use EoC.

Someone else may have more knowledge on this issue. All I would be doing is guessing at this point.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #24  
Old 03-22-2017, 10:53 AM
Maze_EQ
Demi-God
 
Join Date: Mar 2012
Posts: 1,106
Default

Quote:
Originally Posted by ionhsmith View Post
ghanja: I am using the same pc that has the eqemu server on it yes. The ip address changed from my old set up when I got a new router I ran the script in MySQL to set up the new user instead of using root but I don't know how to test it so see if I did it correctly
Did you grant privs to the user on a specific IP?

or did you wildcard?

Code:
GRANT ALL ON *.* TO 'Maze'@'localhost';
GRANT ALL ON *.* TO 'Maze'@'%';
What does http://www.yougetsignal.com/tools/open-ports/ say when you test 3306 to your external IP?

Take a screen capture of your port forward screen on your router.


Make sure the router firewall has pass-through on 3306.

Forward port 3389 to your server host and see if you can check ports on 3389, or simply RDP(Remote Desktop Protocol) to the machine from an outside device (Tablet, cell phone, etc)

If it is a Linux machine, forward port 22, and test SSH using your preferred client (putty for beginners)

Add a firewall exception for 3306, stop mysqld/mysql, telnet from a local machine to the server using port 3306
Code:
telnet 192.168.10.268 3306
If this works, your server's firewall is not the issue for incoming connections.

I mean, troubleshooting a network based issue is difficult when you don't know the user's environment.
__________________
"No, thanks, man. I don't want you fucking up my life, too."

Skype:
Comerian1
Reply With Quote
  #25  
Old 03-23-2017, 09:03 PM
ionhsmith
Discordant
 
Join Date: Jun 2014
Posts: 284
Default

I did the grant all like in your code. I cannot log into my Heidi sql with my newly create user name and pw though. I took the screen shot of router settings but I cant seem to upload the pic here. its asking for a url... I did the port test and it says my port 3306 is open. I do have the firewall exceptions for 3306 in mysqld/MySQL... not sure what telnet is

edit:

I didn't do anything different but it is now working and logging in... thanks for the help but not sure what the fix was
Reply With Quote
  #26  
Old 03-23-2017, 09:52 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Quote:
Originally Posted by ionhsmith View Post
cant seem to upload the pic here.
Grab a free photobucket account, upload pics to there. Copy the url it provides and post that where needed.
Reply With Quote
  #27  
Old 03-24-2017, 09:52 AM
Maze_EQ
Demi-God
 
Join Date: Mar 2012
Posts: 1,106
Default

Quote:
Originally Posted by GRUMPY View Post
Grab a free photobucket account, upload pics to there. Copy the url it provides and post that where needed.
Photobucket is junk, use GreenShot with IMGUR extension
__________________
"No, thanks, man. I don't want you fucking up my life, too."

Skype:
Comerian1
Reply With Quote
Reply

Thread Tools
Display Modes

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 08:14 PM.


 

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