lundi 30 mars 2015

Magento not connected to AWS MYSQL RDS instance?

I tried to connect my magento application to AWS RDS instance but instead it connects to localhost MYSQL.


But in phpMyAdmin it is connected to rds instance.


Here are the steps that i did:



  1. Created RDS instance with required settings.

  2. In Magento directory i.e app/etc/local.xml i changed hostname as RDS endpoint with port 3306. With correct database user, password and database name.





<host>
<![CDATA[XXXX.XXXXXXXXXXX.us-east-1.rds.amazonaws.com:3306]]></host>
<username><![CDATA[noones]]></username>
<password><![CDATA[admin1234]]></password>
<dbname><![CDATA[noones]]></dbname>
<initStatements><![CDATA[SET NAMES utf8]]></initStatements>
<model><![CDATA[mysql4]]></model>
<type><![CDATA[pdo_mysql]]></type>
<pdoType><![CDATA[]]></pdoType>
<active>1</active>


I used Bitnami Magento Stack for magento installation, Is there any other files/configurations i need to change so that the magento points to RDS instance instead of localhost mysql.


Thanks





Aucun commentaire:

Enregistrer un commentaire