COmanage Registry is tested against PostgreSQL and MySQL, but should work against any database supported by CakePHP.
If you are using MySQL, use the InnoDB storage engine, not MyISAM. To set this as the default storage engine on a Unix-like system, add the following to
(You can also set the storage engine on a per-session or per-table basis, see the MySQL documentation for details.) |
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.
Copy the file registry-source/app/Config/database.php.default
to registry-source/app/Config/database.php
.
Edit this file with your database connection information, including the password needed to connect to the database.
Currently, the |
var $default = array( 'driver' => 'Database/Mysql', 'persistent' => false, 'host' => 'localhost', 'login' => 'registry_user', 'password' => 'a good password goes here', 'database' => 'registry', 'prefix' => 'cm_', ); |
var $default = array( 'driver' => 'Database/Postgres', 'persistent' => false, 'host' => 'localhost', 'login' => 'registry_user', 'password' => 'a good password goes here', 'database' => 'registry', 'prefix' => 'cm_', ); |
Set up the database schema.
$ cd app $ ./Console/cake database [...] Database schema update successful |
This error indicates the command line |