Panel | |
---|---|
|
Setup Database
COmanage Registry is tested against PostgreSQL and MySQL, but should work against any database supported by CakePHP.
...
title | Use InnoDB Storage Engine With MySQL |
---|
. It may work against other databases supported by CakePHP, but no other databases are regularly tested. Unless otherwise noted, any currently supported version of these databases may be used.
Create a new database for COmanage Registry. You can name the new database whatever you like since you will configure the Registry below with the name of the database.
MySQL / MariaDB Considerations
Deployments using MySQL/MariaDB should
...
use the InnoDB storage engine, not MyISAM.
To set this as the default storage engine on a Unix-like system, add the following to /etc/my.cnf
and restart
...
the database before setting up the database tables:
No Format |
---|
# Set default engine to InnoDB
default-storage-engine=InnoDB
|
(
...
The storage engine can also be set
...
on a per-session or per-table basis, see the MySQL documentation for details.)
...
Postgres Considerations
Due to issues with an older version of ADOdb, Registry v3.3.4 and earlier may encounter schema management problems when used with Postgres 12 or later. For these versions only, supported versions of Postgres 11 or earlier should be used.
Registry v4.0.0 or later use an updated version of ADOdb, and can be used with any supported version of PostgresCreate a new database for COmanage Registry. You can name the new database whatever you like since you will configure the Registry below with the name of the database.
Configure COmanage Registry
Copy the file registry-sourcecurrent/app/Config/database.php.default
to registry-sourcecurrent/local/Config/database.php
. (For versions prior to v1.0.0, copy the file to registry-current/app/Config/database.php
instead.)
Edit this file with your database connection information, including the password needed to connect to the database.
Note | ||
---|---|---|
| ||
Currently, the |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
var $default = array( 'driver' => 'Database/Mysql', 'persistent' => false, 'host' => 'localhost', 'login' => 'registry_user', 'password' => 'a good password goes here', 'database' => 'registry', 'prefix' => 'cm_', ); |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
var $default = array(
'driver' => 'Database/Postgres',
'persistent' => false,
'host' => 'localhost',
'login' => 'registry_user',
'password' => 'a good password goes here',
'database' => 'registry',
'prefix' => 'cm_',
);
|
Install Database Schema
Set up the database schema.
Note | ||
---|---|---|
| ||
If you plan to use Grouper as the group data store for Registry or you want to use Registry as a subject source with Grouper you must make configuration edits and execute some scripts now. Return here when finished configuring Registry integration with Grouper. |
Code Block |
---|
$ cd app
$ ./Console/cake database
[...]
Database schema update successful
|
...
Info |
---|
Set up the database schema.
Note |
---|
In order to avoid problems with file ownership, you should run console commands as the web server user. Otherwise, make sure the cache directory (wherever |
...
and |
...
may be in order after running console commands. |
Code Block |
---|
$ cd app
$ su -c "./Console/cake database" ${APACHE_USER}
[...]
Database schema update successful |
Note | ||
---|---|---|
| ||
This error indicates the command line |