Amazon RDS MySql Server

RentProperty

Hi There

We are trying to deploy a runtime for one of our clients in the Amazon hosting environment. They have an application server Running windows, and then another Cloud server (Amazon RDS) running on Linux with My SQL. When trying to connect the Application to the Database server we are getting the following error message:

Support said that the issue is related to the user privileges of the application server, and that it is not related to the packet size.

However, the RDS server is set up so that it has the following permissions:

create, drop, references, event, alter, delete, index, insert, select, update, create temporary tables, lock tables, trigger, create view, show view, alter routine, create routine, execute, trigger, create user, process, show databases, grant option.

Still doesn't work though.

Is there anybody else who successfully run the Database on an AMazon RDS environment. I know the EC2 works but RDS offers some other benefits that we need.

Any response would be highly appreciated.

Kindest Regards

Hein

Rennur

Might be obvious and you are probable aware of this, but the AwareIM server attempts to set the value for database 'max_allowed_packet' on startup.

This is from my server start-up log:

The setting for database 'max_allowed_packet' variable is not sufficient. Setting the value to 16M

Initialising LDAP Persister
LDAP SEARCH LIMIT value is null

The setting for database 'max_allowed_packet' variable is not sufficient. Setting the value to 16M

Initialising LDAP Persister
LDAP SEARCH LIMIT value is null

Although the RDS server permissions for the database are set up, there might be insufficient user login rights to edit the external file (possibly mysql's my.ini file) where the max_allowed_packet' setting is.

Cheers

kklosson

Reading this with interest while considering the option to put my DB on Amazon RDS. I know on my database server, I have to set max_allowed_packets to 128MB. I can't determine whether or not the administrator has sufficient ability to manage database variables like this on RDS. Do we know? If you have made progress on this, please update the crew.

aware_support

If you see this error message you need to set the value of max_allowed_packet manually and restart Aware IM.

To do this open any MySQL tool that allows entering SQL commands and has sufficient privileges and enter the following command:

SET @@global.max_allowed_packet=16776192

If you are not allowed this then ask the system admin. to issue this command.