Databases

You are here: Administrators Reference > Server and Customer Administration > Server Administration Left Panel > Configuration > Databases

Databases

All CommonSpot content, formatting, and security permissions are stored in a set of relational databases created as a prerequisite to CommonSpot installation using your site's database management software. This database set comprises CommonSpot's data sources, the names and locations supplied to ColdFusion for storing and retrieving CommonSpot information. By default, installing CommonSpot Server defines three data sources:

commonspot-sites: Maintains configuration data for all CommonSpot sites created and managed on this server.
commonspot-users: Maintains profile information for authenticating users and groups. Your installation can share a single Users database across multiple CommonSpot sites or restrict association to a single site.
commonspot-site-[your_site_name]: For each CommonSpot top-level site, stores site-specific data.

The Databases dialog identifies the CommonSpot data sources defined during installation and gives you options for setting the default database type for new sites. See the Configure Databases section of the CommonSpot Installation Guide

Sites Data Source: Displays the name of the data source defined during installation for maintaining all CommonSpot sites on this server
Users Data Source: Displays the name of the data source defined during installation for maintaining all CommonSpot user and group profiles.

The Databases dialog also displays the Default database type for new sites. This field is required; use it to display or change the default database type for new CommonSpot sites on this server. The default is the type defined at installation. You can reset it to CommonSpot compatible types: SQL Server, MySQL, or Oracle.

Related Links

You can download PDF versions of the Content Contributor's, Administrator's, and Elements Reference documents from the support section of paperthin.com (requires login).

The following guides are available from the support site and are in the /docs/directory of your CommonSpot Server:

You can also download these other guides from the support section of paperthin.com (with login):

For technical support:

http://www.paperthin.com/support/