Configuring the MYSQL for concrete5 CMS hosted on appfog

[sidharth madan]

Hey Guys

I am trying to host concrete5 CMS on appfog. I am able to run the app but unable to configure the mysql with it. As when I go the app url, it asks me to enter the mysql database details there. But appfog only provides an environment variable. How do I go about configuring concrete5 on appfog.

Regards

Sidharth

[Ernesto Celis]

On Tuesday, September 24, 2013 1:14:11 AM UTC-5, sidharth madan wrote:

I am trying to host concrete5 CMS on appfog. I am able to run the app but unable to configure the mysql with it. As when I go the app url, it asks me to enter the mysql database details there. But appfog only provides an environment variable. How do I go about configuring concrete5 on appfog.

You'll need to hack the concrete5 configuration file and type the environment variables as values where appropiate before pushing your app to Appfog. Appfog isn't a web hosting provider in the same way the concrete5 wizzard is designed to be run. 

 

Regards

Sidharth

[sidharth madan]

Thanks for the information Ernesto

Could you tell me which configuration files I would need to hack. 

Regards

Sidharth

[sidharth madan]

Just found out, 

/config
This directory contains “site.php,” the configuration file added by the Concrete5 installation program. This stores your database connection settings and some server-specific information. Additionally, this directory contains “site_theme_paths.php,” which allows a developer to manually specify certain themes for certain areas of a site. Click here for more information about site_theme_paths.php

Could you please tell me how I can find the template of the site.php. That should solve my problem. Thanks in advance.

On Wednesday, September 25, 2013 2:05:46 PM UTC+8, Ernesto Celis wrote:

[sidharth madan]

Okay, I found out a template of config/site.php. But how do I manually configure the password salt. Or I just leave that out and it would just appear on it's own.

<?php 

define('DB_SERVER', 'mysql.xxx.com');

define('DB_USERNAME', 'sidharthmadan');

define('DB_PASSWORD', 'thisIsThePass');

define('DB_DATABASE', 'c5db');

define('PASSWORD_SALT', 'bU6bD8HzNKv7lyX1p9rs24GTSuTR3jHX7kliqINGV6fP3UOlrqBcDmTDhTvAyEW3');

define('AVATAR_NONE', ASSETS_URL_IMAGES . '/spacer.gif');

--
You received this message because you are subscribed to a topic in the Google Groups "AppFog Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/appfog-users/XxwF3GvtPjc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to appfog-users...@googlegroups.com.
To post to this group, send email to appfog...@googlegroups.com.
Visit this group at http://groups.google.com/group/appfog-users.
For more options, visit https://groups.google.com/groups/opt_out.

[Ernesto Celis]

On Wednesday, September 25, 2013 11:22:06 AM UTC-5, sidharth madan wrote:

Okay, I found out a template of config/site.php. But how do I manually configure the password salt. Or I just leave that out and it would just appear on it's own.

The password salt is up to you and should be secret. it has nothing to do with configuring the CMS to run in AppFog. I advise you to read about secure password hashing.

Regarding the VCAP_SERVICES variable from appfog PHP environment, do something like the example here: https://docs.appfog.com/services/mysql#php

[sidharth madan]

Below is my config/site.php Do I have to configure any other file as well, or this should be enough?

[code]

<?php

$services_json = json_decode(getenv("VCAP_SERVICES"),true);

$mysql_config = $services_json["mysql-5.1"][0]["credentials"];

define('DB_SERVER', $mysql_config["hostname"];);

define('DB_USERNAME', $mysql_config["username"]);

define('DB_PASSWORD', $mysql_config["password"]);

define('DB_DATABASE', $mysql_config["name"];);

define('PASSWORD_SALT', 'bU6bD8HzNKv7lyX1p9rs24GTSuTR3');

define('AVATAR_NONE', ASSETS_URL_IMAGES . '/spacer.gif');

[/code]

Thanks for your help :)

[Ernesto Celis]

On Sat, Sep 28, 2013 at 2:02 AM, sidharth madan <sidhar...@gmail.com> wrote:

Below is my config/site.php Do I have to configure any other file as well, or this should be enough?

I don't know. I've never used Concrete5 myself, why you don't just try to see if it works now. Really it should be fairly easy to set up in appfog devoting some time to read appfog's documentation which is very good IMHO.

--
Saludos
Ernesto Celis (Usuario Linux #323140)
Google Voice: +1 678-632-2645
C*NET: 1-333-1106

[sidharth madan]

I just tried this but it did not work. Would someone more willing to try out and share the experience. The thing is that the concrete5 wizzard ( front end GUI setup) asks for a lot more information than that site.php includes.

[Ernesto Celis]

On Sun, Sep 29, 2013 at 12:16 PM, sidharth madan
<sidhar...@gmail.com> wrote:
> I just tried this but it did not work. Would someone more willing to try out
> and share the experience. The thing is that the concrete5 wizzard ( front
> end GUI setup) asks for a lot more information than that site.php includes.

Maybe if you tell us specifically which is this "lot more" information.

Ernesto Celis de la Fuente
http://expressit.celisdelafuente.net

[sidharth madan]

This is an article on concrete5 site I found on how to configure concrete5 through commandline. 

http://www.concrete5.org/documentation/how-tos/developers/install-concrete5-from-the-command-line/

This is the file - https://github.com/concrete5/concrete5-cli/blob/master/install-concrete5.php

and they say when I do this -

./install-concrete5.php 
    --db-server=localhost
    --db-username=cd_demo
    --db-password=mypassword
    --db-database=cd_demodb
    --admin-password=supersecr3t
    --admin-email=mye...@gmail.com
    --starting-point=standard
    --target=/home/cd_demo/public_html

concrete5 should be setup. I am going to try to use the environment variables for this. But I think that would not really work because concrete 5 would want to check the database before giving a pass.