Error in database internal command about freya HOT 9 CLOSED

I'll take a look tonight and check it out and send you a PR.

from freya.

Hi,

I assume you're using the latest build? Could you share your characters table?

As for

the Cabal client try to connect in the internal ip address of GameServer and not the address set in the configuration.

This is because of d164582 which allows to connect locally and remotely. I might make this configurable.

from freya.

@ubis the word "rank" it's reserved word in sql, change the column name

from freya.

@artem-alekseev can you also reproduce this?

It seems rank is reserved keyword since MySQL 8.0.2, probably because of RANK() function. I guess adding backticks might help.

Though it's weird, I don't get this on my dev server on macOS with MariaDB 11.2.2 nor on my test server on FreeBSD with MariaDB 10.11.5

from freya.

@ubis yep u right, it's error only in mysql, mariadb don't have this problem

from freya.

Aha, that's the first difference I've heard between MariaDB and MySQL. Any reason you guys are using MySQL over MariaDB? IMO MySQL is slowly being killed by Oracle.

Anyway, we should still fix this. @artem-alekseev if you have MySQL installed, could you check with backticks?

from freya.

Another issue with this deployment type is after login, the Cabal client try to connect in the internal ip address of GameServer and not the address set in the configuration. I changed the container interface to be the same of the host and works.

Fixed this with 28e99bd. Now this behaviour is disabled by default, you can still enable it with use_local_ip=1 in gameserver conf.

from freya.

@ubis the word "rank" it's reserved word in sql, change the column name

@ubis Fixed in #10

I would like to help you, do some simple things, can you tell me where to start?

from freya.

@casmssm everything should be fixed in fb5bbcc or newer revision.

@artem-alekseev we should chat about this in Discord or so, let's not pollute this issue.

from freya.