Central Database

When Cassiopeia is started for the first time with unchanged default settings (see Connection pane of the preferences panel) a database Cassioepia is created and setup automatically on localhost. This is convenient for a single user setup. A multi user setup requires only a few extra steps. This tutorial explains how to setup a central database on a remote host and how to configure Cassiopeia on each client to access the central database instead of the (default) local one.

Cassiopeia is a MacOSX application, thus MacOSX is required for the clients. However, FrontBase is available for a bunch of other platforms as well and since FrontBase is all that is needed for the central host you could also host the central database on a Solaris or Linux box.

Make sure FrontBase is installed on the machine you intend to run the central database on. See http://www.frontbase.com for a binary of FrontBase for your operating system. In case of MacOSX simply install the FrontBae binary from our essentials package on the central host as well.

Now start FrontBaseManager.app (part of the FrontBase installation) on one of your MacOSX clients


and click on New to create a new database. On the New Database panel specify the ipaddress of the remote host you want to run the database on


and a database name (Cassiopeia in this example but any name will do). You might also want to check Start database when computer starts. Click on Create.

You will now have a file Cassiopeia.fb in /Library/FrontBase/Databases on the remote host (/opt/FrontBase/Databases in case of Linux or Solaris). Doubleclick on the tableview entry in order to establish a connection to the newly created database


and login as _SYSTEM (the only available account so far).


Note that the database contains the default schema _SYSTEM only and no tables so far. Open Cassiopeia.app on any client and choose the Connection pane of the preferences panel.


Click on Set and enter the ipaddress of the remote host in the Host name field.


Press Return to add this ipaddress to the list of monitored hosts. Then click on the new entry to see all available databases on this host.

Select the database you created with FrontBaseManager.app and click on Select. The Connection pane of the Cassiopeia preferences panel should now look similar to the following.


Choose Database - Log On from the Cassiopeia menu and log in as ROOT with no password.


Cassiopeia realizes that you are connecting to a new database and automatically sets up the schema. You will be asked for permission to execute SQL statements four times. Allow the modifications. You should end up with the Object Browser Window indicating that the setup procedure completed successfully.


You might want to reconnect to the remote database with FrontBaseManager.app and verify that a schema ROOT with a few dozen tables has beend created.


You can now change the connection settings in the Cassiopeia preferences panel on all other MacOSX client machines accordingly and thus make sure they connect to the remote host as well. Please read Account Management to learn how to setup user accounts in the database. Read License Management to learn how to register a group license in the database. Group licenses can be requested here. You might also want to check out Scheduling Backups in order to learn how to create backups in regular intervalls.

Don't hesitate to contact us at support@advanced-science.com if you have trouble with this guide or encounter any problems during the setup. Our support team will be happy to assist you in getting your central database correctly setup and running.

Advanced Science          Terms and Conditions          © Acrux GmbH 2013