Step 3: Installing Theatre Manager and connecting to the database (PC)

For reference, the list of steps are:

  1. the installation of the PostGres SQL server
  2. installing the demo database and the main TheatreManager User
  3. install Theatre Manager and connect to the database
  4. configuration of the server parameters for a production database
  5. creating a daily backup job in Windows Task Scheduler to run the backup

Now that the database server is setup and a sample database is imported, then we can install Theatre Manager on the machine

1. Download the TheatreManager PC installer if you have not done so. This link is supplied upon request
2. Run the TMSetup.exe program and click 'Next' to all prompts.
3.

After installation, look for TheatreManager on the desktop or in the Start Menu and open Theatre Manager

StartTM

4.

If you get asked for the database, enter the values below. Normally, you should not need to do this as the Demo database is always assumed to be on the local machine.

DatabaseLocation

If you cannot connect to the database, check the following settings:

  • make sure port 5432 is open on your machine
  • make sure that 'everyone' has access to all files in the 'C:\Program Files\Theatre Manager' directory
  • make sure that the demo database got installed by using PG admin III as per the section below... then come back and try connecting again.
5.

You will see a first time setup screen asking you for your company information. All fields except the second line of address and the web site are mandatory. After you put this in the first time, you will not see it again.

These fields are used during the demo to show how Theatre Manager verifies information for you. For example, the city, sate and country you enter becomes the default country for new patrons that you may add to the database. The area code for the phone number fields becomes the default for patron entry, etc.

Notice how Theatre Manager converts what ever you type into the proper case as it tries to assist in data entry.

FirstUse

6.

Then, if you are able to connect to the database and entry the company information, then you will see the login window below. The password for any of the users in the demo is 'master'

Logon

7.

In a production environment, once connected to the database in step 4, you can run this the TMSetup.exe file on any other machine in the network. After changing the pg_hba.conf file (next section), you should be able to connect to the database.

NOTE: you will need to use the IP address of the server to connect instead of 127.0.0.1

andif you cannot connect to the server,:

  • make sure port 5432 is open on the server
  • make sure that 'everyone' has access to all files in the 'C:\Program Files\Theatre Manager' directory
  • make sure that the real database is installed and setup using PG Admin III

Step 4: configuration of the server parameters for a production database