Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

how to install Limesurvey on Openshift?

More
5 years 11 months ago #206410 by limesurvey_asker
Hello,

I want to use Limesurvey on Openshift. Am I asking at the right place or should I ask at an openshift forum?

I found a short answer* on this forum, but replies are locked.
How do I " - create your Openshift builds with the config.php" ?


thanks in advance,
limesurvey_asker

*https://forums.limesurvey.org/forum/installation-a-update-issues/107828-deployment-on-openshift
The topic has been locked.
More
5 years 7 months ago #211637 by garywong-bc
I did it this way (with help from others in this forum).. adding these lines at the start:
Code:
$dbhost = getenv('POSTGRESQL_DB_HOST'); $dbport = getenv('POSTGRESQL_PORT'); $dbname = getenv('POSTGRESQL_DB_NAME'); $dbusername = getenv('POSTGRESQL_USERNAME'); $dbpassword = getenv('POSTGRESQL_PASSWORD'); $connectstring = "pgsql:host=".$dbhost.";port=".$dbport.";dbname=".$dbname;

And then referencing these in the DB connection:
Code:
'components' => array( 'db' => array( 'connectionString' => $connectstring, 'emulatePrepare' => true, 'username' => $dbusername, 'password' => $dbpassword, 'charset' => 'utf8', 'tablePrefix' => 'lime_', ),

This is assuming PostgreSQL but MySQL/MariaDB is similar.. I've done it on OpenShiftV3 and OpenShiftV4 - both work. HTH Gary
The following user(s) said Thank You: cdorin
The topic has been locked.
More
5 years 7 months ago #211639 by garywong-bc
... and here's the MySQL version
Code:
$dbhost = getenv('MYSQL_DB_HOST'); $dbport = getenv('MYSQL_PORT'); $dbname = getenv('MYSQL_DB_NAME'); $dbusername = getenv('MYSQL_USERNAME'); $dbpassword = getenv('MYSQL_PASSWORD'); $connectstring = "mysql:host=".$dbhost.";port=".$dbport.";dbname=".$dbname;
The following user(s) said Thank You: cdorin
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose