|
|
| Line 1: |
Line 1: |
| − | == Linux == | + | == Driver == |
| | + | The PostgreSQL PHP driver should be available in your package manager, or downloadable from php pecl. |
| | | | |
| − | # [[DreamFactory/Installation#Linux|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>~/df/</code> with its PHP installed in <code>~/df/php/</code>.)
| + | For example if you are following the [[../../../APT/Ubuntu_16.04/Modules/PostgreSQL| Ubuntu 16.04]] instructions, this package is named php7.1-pgsql. |
| − | # Check <code>~/df/php/etc/php.ini</code> to ensure the values <code>extension=pgsql.so</code> and <code>extension=pdo_pgsql.so</code> are present and uncommented. (In the Bitnami installer they already are.)
| + | |
| − | # Check <code>~/df/php/lib/php/extensions/</code> to ensure <code>pgsql.so</code> and <code>pdo_pgsql.so</code> are present. (These are included in the Bitnami package.)
| + | |
| − | # If you made any changes/additions in steps ii and iii, restart your Apache server.
| + | |
| − | # Login to your DreamFactory Admin Console and create a new service in the Services tab. Enter the following, then click Save at the bottom of the page.
| + | |
| − | #* Type: Remote SQL DB
| + | |
| − | #* Username and Password: valid credentials to your PostgreSQL DB
| + | |
| − | #* SQL Vendor: PostgreSQL
| + | |
| − | #* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
| + | |
| − | #* Database Name: name of the PostgreSQL DB
| + | |
| − | #* Connection String: if using a port other than the default (5432), add <code>;port=####</code> (where #### is the actual port number) to the end of your connection string
| + | |
| − | # Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
| + | |
| − | | + | |
| − | == Mac ==
| + | |
| − | | + | |
| − | # [[DreamFactory/Installation#Mac_OS_X|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>/Applications/df/</code> with its PHP installed in <code>/Applications/df/php/</code>.)
| + | |
| − | # Check <code>/Applications/df/php/etc/php.ini</code> to ensure the values <code>extension=pgsql.so</code> and <code>extension=pdo_pgsql.so</code> are present and uncommented. (In the Bitnami installer they already are.)
| + | |
| − | # Check <code>/Applications/df/php/lib/php/extensions/</code> to ensure <code>pgsql.so</code> and <code>pdo_pgsql.so</code> are present. (These are included in the Bitnami package.)
| + | |
| − | # If you made any changes/additions in steps ii and iii, restart your Apache server.
| + | |
| − | # Login to your DreamFactory Admin Console and create a new service in the Services tab. Enter the following, then click Save at the bottom of the page.
| + | |
| − | #* Type: Remote SQL DB
| + | |
| − | #* Username and Password: valid credentials to your PostgreSQL DB
| + | |
| − | #* SQL Vendor: PostgreSQL
| + | |
| − | #* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
| + | |
| − | #* Database Name: name of the PostgreSQL DB
| + | |
| − | #* Connection String: if using a port other than the default (5432), add <code>;port=####</code> (where #### is the actual port number) to the end of your connection string
| + | |
| − | # Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
| + | |
| − | | + | |
| − | == Windows ==
| + | |
| − | | + | |
| − | # [[DreamFactory/Installation#Windows_2|Install DreamFactory]]. (The below steps assume a DreamFactory install in <code>C:\df\</code> with its PHP installed in <code>C:\df\php\</code>.)
| + | |
| − | # Check <code>C:\df\php\php.ini</code> to ensure the value <code>extension=php_pdo_pgsql.dll</code> is present and uncommented. (In the Bitnami installer it already is.)
| + | |
| − | # Check <code>C:\df\php\ext\</code> to ensure <code>php_pdo_pgsql.dll</code> is present. (This is included in the Bitnami package.)
| + | |
| − | # If you made any changes/additions in steps ii and iii, restart your Apache server.
| + | |
| − | # Login to your DreamFactory Admin Console and create a new service in the Services tab. Enter the following, then click Save at the bottom of the page.
| + | |
| − | #* Type: Remote SQL DB
| + | |
| − | #* Username and Password: valid credentials to your PostgreSQL DB
| + | |
| − | #* SQL Vendor: PostgreSQL
| + | |
| − | #* Host: hostname or IP of your PostgreSQL server (localhost if appropriate)
| + | |
| − | #* Database Name: name of the PostgreSQL DB
| + | |
| − | #* Connection String: if using a port other than the default (5432), add <code>;port=####</code> (where #### is the actual port number) to the end of your connection string
| + | |
| − | # Click over to the “API Docs” tab, expand your new service, and perform a simple GET request to verify connectivity.
| + | |
