EOC connection issue
 

I am trying to get eoc to connect to my Akkadius repack but I cant seem to get it to connect... any help would be great. I have port 3306 open, I created a new user, ran the query and changed it to the user name and pw of the data base but it still says connection failed

any help? I would like to be able to edit my server again. Maybe I did not set up the user correctly in Heidi sql? can someone walk me through this process again ?

If I understand EoC correctly, it connects to your database server and reads/writes to an EQEmu database over a network device. With that in mind, the only way anyone can help is for you to provide additional information.

How are you using EoC? Are you using it remotely (e.g., connecting from http://eoc.akkadius.com/EOC2/login.php) or locally (e.g., downloading the EoC source and running it remotely, so it connects over LAN/localhost)?

Along with the above information, please also provide the host (IP address) and port that you've set EoC to connect to (if you'd rather not, simply make sure it's your external IP address if it's a remote connection, internal (LAN) IP address if over LAN, and localhost if on the same computer). If connecting remotely, forwarding the port on your router will be necessary. Remotely or not, check your firewall and make sure the port is allowed to have incoming traffic.

I assume the database credentials you're using are correct as you set that up yourself (do not post this information as that would be a huge security risk).

After that, kindly allow some time before posting again since everyone here has other things in life that must take priority over EQEmu support.

If I'm way off on understanding the situation feel free to say so.

what is eoc? So you have a server up and running and can't connect with your client or what?

edit: ah ok well I have no experience with that so I can't help.

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

tcp and udp? just DMZ your server kiddo.

I don't know what DMZ is honestly

DMZ = Demilitarized zone

Basically, it exposes your computer directly to the Internet. You get no firewall protection, but you don't need to port forward. It's a bad solution to your problem, imo.

I just want to be able to edit my server again. doesn't work since I switch to the Akkadia repack

Open a command prompt and run this command:
..and report back the entries ending with :3306.

Like forwarding SQL is any less dangerous?

If you have any know-how of networking (even entry level) you can easily have a secure dmz.

I am not a networking guru. However, based on the OP's question and replies, I don't think he or she has much knowledge of networking (even entry level).

You used the word "again". Does this mean your ports were open before and you were able to connect no problem ?
(Just trying to understand this).

I'm not sure what the installer's default is..but, he probably needs to bind his db to the computer's LAN address rather than localhost.


EDIT: https://mariadb.com/kb/en/mariadb/co...client-access/

Throw up teamviewer and drop $100 into my paypal.

Leave a note on the desktop with domain credentials (if you're using AD) for an admin account (and router details) and it'll be done in 30 minutes. Or, I can send you a WebEx. /shrug

Usually my consulting fee is quite higher, but for the EQEmu community, I'll be lenient.

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)?

I think I saw an ad like that on backpage ? hahaha :P

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

Thanks again ;)

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

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

That's definitely localhost...

And EoC requires an external connection?

so what are you suggesting?

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.

Did you grant privs to the user on a specific IP?

or did you wildcard?

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 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.

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

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