Friend can't connect to the server

[Dothus]

So my friend was able to see my realm list, but he was stuck in a loop and couldn't connect (using default config). Here's the default config files: Pastebin. What exactly do I need to change, where do I put my external IP so he could connect? I think only 8080 port shows as closed on yougetsignal.com , others are open, don't know why.

edit: Used SQLyog to change the ip, but it doesn't save the changes for some reason.

[Harambeqt]

Had this issue along time ago, the issue is that he can connect to your server but not to the realm.
If i remember correctly it's the realmlist in the database that is messing things up, try putting your external ip in the database rl table.
But its been like 6+ years since I had this error myself so it's hard to remember without having all the stuff in front of me.

Try shutting everything down and edit the realmlist or use navicat. I have never had problems with being unable to save.

[Dothus]

Navicat seems to have done the trick, it saved. Hopefully it works now. Thanks.

[DoxramosPS]

I'd switch to HeidiSQL honestly. Navicat is known to have many issues. If you go to the TrinityCore site it even tells you not to use navicat. Not Trying to bash, but you can run into problems later on.