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, FrontBae is installed automatically when you start Cassiopeia for the first time.

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 ip address 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 ip address of the remote host in the Host name field.

Press Return to add this ip address 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 realises 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.


Cassiopeia can be made to automatically login with a default user whenever the app is started. You can do so by setting up a file .cassiopeia_autologin (note the leading dot) in your home directory containing a username and a password separated by a comma. As long as we use the default account ROOT with no password the contents of this file should be: "ROOT," You can set this file up by executing "pico .cassiopeia_autologin" in a terminal session. Enter "ROOT," without the quotation marks and press Ctrl-x y to save and exit. Cassiopeia will login automatically using the account given in .cassiopeia_autologin when relaunched. The document Account Management explains in detail how to create user accounts and assign access privileges to groups and users. If you had created a database account paul with password 1234 you would want to setup a .cassiopeia_autologin file in your home directory with the contents "paul, 1234" (without the quotation marks).
Advanced Science          Terms and Conditions          © Smartsoft GmbH 2015