Using mydb.ics.purdue.edu (MySQL database) from Zope

Purpose

This document describes how to set up a database connection, in Zope, to the MySQL database provided by ITaP running on mydb.ics.purdue.edu.

Procedure

• If you have not already done so, set up your MySQL account following the instructions on ITaP's MySQL Account FAQ page.
• From your personal People folder, create a new Z MySQL Database Connection.
• The connection string should be username@proxy:3307 username password. (Replace username with your username and password with your MySQL password.)
• Click the add button.
• When creating Z SQL methods, select your MySQL Database Connection as the database to use when connecting.

Notes

You may have confusion about the hostname and port number to use when connecting to the database. You must set the hostname and port as in the example in order to connect to the database. The reason for this is that the Zope servers are behind a firewall, and connections to outside machines is not permitted.

If there are problems

If you are experiencing problems connecting to the database, first make sure that you have followed ITaP's MySQL Account FAQ page. If you continue to have problems, please submit a Trouble Report to the Help Desk.