Can't use Amazon RDS endpoint to conect to mysql

[AngelRO]

I am doing some tests with Amazon RDS and when I change sql.db_hostname with the Amazon RDS endpoint, I get the following error:

 

: Unknown MySQL server host 'angelro.xxxxxxx.sa-east-1.' (0)
[Debug]: at ipban_sql.c:79

 

The endpoint of the database is: angelro.xxxxxxx.sa-east-1.rds.amazonaws.com

 

sql.db_hostname: angelro.xxxxxxx.sa-east-1.rds.amazonaws.com

 

Only parts of the endpoint is being read.

 

When I use the private IP or the public IP that the endpoint is directing to, I get no erros, the problem is that every time I reboot my RDS instance, the IP will change, so I really need to assign the IP with the exact endpoint: angelro.xxxxxxx.sa-east-1.rds.amazonaws.com

 

For more information on Amazon RDS, click here.

 

Edit:

I'm trying to increase the size of hostname variables, and it looks like it will work.

Edited August 23, 2013 by AngelRO

[AngelRO]

Yeah...

 

I had some troubles to make it work, the char-server was crashing (buff overflow), so I decided to set up a CNAME record poiting to my RDS instance DNS name and it is working now. ^^

 

Thanks

Edited August 21, 2013 by AngelRO

[Brian]

You're right, it seems like rAthena is truncating the hostname to 32 chars (31 + \0).

trunk/src/login/account_sql.c

	// local sql settings
	char   db_hostname[32];

It looks like your Amazon RDS instance is working fine because port 3306 is open.