[ASCENT] New Error

[CorpDraco]

Hey guys,

I need some help.
This error has been popping up alot lately on all the cores and databases I have gotten.
I have gotten exactly 9 cores and databases and they all have the same error.

I need some help on how to fix this, and quickly please?
I appreciate everyone who helps me fix this error once and for all.
It is really starting to make me mad, lol.

Also, the MYSQL server is fine. It is up and running when this error occurs. I need some help bad.

The picture of the console is attached.

Thanks.

 

[mrNickname]

Report your Ascent, NCDB and mysql versions, lets see if i can figure something out. I have no problems lately except the bad sql comes with datapack.

 

[CorpDraco]

Ascent - 4084
NCDB - 1128
MySQL - 5.0

There ya go.

 

[mrNickname]

Hmm......... Np for MySQL version

Why not try upgrade to Ascent4109, NCDB1145? Remember to backup your accountDB.

EDIT: The error on pic seems like something is causing disconnection to mysql.. hmm..

 

[CorpDraco]

I dont know if you caught this, but I have changed cores and databases a whole lot.
I've gotten the new revisions already, same error.

Its really frustrating...

 

[CorpDraco]

No, the internet I have is really nice, high speed T1.
I dont see how it could lose a connection, everything is fine when the error occurs.

 

[mrNickname]

Have you tried network diagnostic? ping ms sorts? RUnning Firewall, AV?

Well best if you run both gameserver and mysql together on same LAN network, i don't know your recent network setup is. :juggle:

 

[CorpDraco]

I run the gameserver & MySQL server on the same computer.
There is no firewall on it, the required ports are open on the router.

 

[mrNickname]

It looks like your Server is connecting to WAN mysql...

 

[CorpDraco]

How can that be?

 

[mrNickname]

I don't know what's your IP is but when you read the error, and if i'm not wrong:
[Translate]
"Ascent Core cannot re-connect to Database because MySQL is not on IP : 24.176.120.83 that Ascent Core trying to connect to"

And there's an error code behind which can be a reference to google to see wtf is it. Which i'm checking now as well..

Update: After read another forum it seems like you mysql sockconnector have problem.. I don't know the little hotfix but maybe a fresh reinstall mysql may fix it.

Update: Another reading give me an idea that if your MySQL runs for first time, does it still running when you get this error? Or it shutdown or crashed without notice?

 

[CorpDraco]

I've already reinstalled Mysql, twice.

The MySQL server is still up and running when this occurs, which is weird.

 

[mrNickname]

Yes very, i started run out of ideas how it would occur. That is because i know what i'm doing on mine but not sure what you did on yours.

Look back to the IP agian.. what's that 24.176.120.83 is? Is that your's WAN IP?

 

[CorpDraco]

Yes, that is my WAN IP.

 

[mrNickname]

mysql should connect to 127.0.0.1 if you run server and mysql on same computer. You double checked all .conf files?

 

[WiKKiD]

As stated there is no reason whatsoever to use your external IP for Msql.

Change everything outside of ascent-realms.conf to localhost, it'll work fine.

If by fluke, that doesn't work. See if/what software is using the same port as Mysql. You've probably got something else binding to that port.

 

[CorpDraco]

Thanks guys!

The error has now been resolved, it turns out that it was in the configuration, like you guys said.