CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Installing CiviCRM on Amazon RDS
Pages: [1]

Author Topic: Installing CiviCRM on Amazon RDS  (Read 1862 times)

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Installing CiviCRM on Amazon RDS
August 29, 2011, 12:59:59 pm
I've been playing around with CiviCRM on Amazon EC2 to take advantage of some ability to scale quickly when demand increases on our site.

I looked into hosting the database on an Amazon RDS, but ran into trouble because of the lack of Super User privilege on RDS and I couldn't seem to find a way around it when importing my civicrm db. I had no problems with the drupal db.

Anyone have any experience with CiviCRM on Amazon RDS?

Brian

alxgrlk

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.5.4
  • CMS version: WordPress
  • MySQL version: 5.6.19
  • PHP version: 5.6.6
Re: Installing CiviCRM on Amazon RDS
March 18, 2015, 09:39:41 pm
Bump.  I'm also looking into a CiviCRM with Amazon RDS deployment and running into problems.  I get the error: MySQL support not included in PHP.

This is on a WordPress install.
« Last Edit: March 18, 2015, 09:49:06 pm by alxgrlk »

alangallery

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.5.4
  • CMS version: 7.34
  • MySQL version: 5
  • PHP version: 5
Re: Installing CiviCRM on Amazon RDS
March 25, 2015, 10:36:15 am
The CiviCRM database SQL dump creates a function and we were not importing the database with the user that created the function. We found that editing function in the SQL dump and then importing worked for us.

Near top of the dump around line 27 :
CREATE DEFINER=`<sqlusername>`@`localhost` FUNCTION `civicrm_strip_non_numeric`...

We changed to :
CREATE DEFINER=`root`@`%` FUNCTION `civicrm_strip_non_numeric`...

Since we were importing as root on RDS.

alxgrlk

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.5.4
  • CMS version: WordPress
  • MySQL version: 5.6.19
  • PHP version: 5.6.6
Re: Installing CiviCRM on Amazon RDS
March 25, 2015, 11:23:06 am
It seems that at the core of the problem is the use of mysql_connect which is deprecated.  Because an additional complexity is that we are also using the official WordPress Docker, the container service did not support mysql_connect. RUN docker-php-ext-install mysql and this seemed to fix the issue.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Installing CiviCRM on Amazon RDS

This forum was archived on 2017-11-26.