Database

From CSCWiki
Revision as of 13:44, 1 October 2017 by Ztseguin (talk | contribs) (Initial commute: WIP on database documentation)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

IMPORTANT NOTE: This documentation is currently under development. Please see MySQL for current database information.

The CSC provides MySQL and Postgres databases to members.

If you want to run something different (e.g., MongoDB), you can compile/run it yourself. Please stay up to date with security updates and DO NOT run it on a port open to the internet (see Firewall).

Database services are provided on coffee.

Servers

MySQL

Postgres

Connecting

MySQL

PHP

To connect to MySQL from PHP, you need to specify the SSL Cipher of 'DHE-RSA-AES256-SHA:AES128-SHA'. For PHP PDO:

 $pdo = new PDO('mysql:host=coffee.csclub.uwaterloo.ca;dbname=DBNAME', 'USERNAME', 'PASSWORD', [
   PDO::MYSQL_ATTR_SSL_CIPHER => 'DHE-RSA-AES256-SHA:AES128-SHA'         
 ]);                                                                      
 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);