Connection with the Database

Connection with the Database#

There are some corner cases in which a database becomes inaccessible, a situation that is marked by a message in the log file similar to:

... ERROR [main] [] extensions - SQL [ CREATE SCHEMA IF NOT EXISTS CORE]; ERROR: permission denied for database core

Here the database named core can not be read, causing SQL commands to fail. This kind of error happens whenever a database has the wrong owner. On Carbonio, the name of the user owning one of the databases listed in Table 11 must coincide with the database’s name.

Table 11 Excerpt of PostgreSQL databases list and their owner.#
Name	Owner
abq	abq
activesync	activesync
auth	auth
carbonio-docs-connector-db	carbonio-docs-connector-db
carbonio-files-db	carbonio-files-db
carbonio_adm	carbonio_adm
core	core
ha	ha
powerstore	powerstore

Whenever the owner of any of these database is wrong, you can fix the error by executing as the postgres user the command

$ psql -c "ALTER DATABASE core OWNER TO core;"
replace core with the name of database that caused the error.

After you issued the command, you can check that the database has the correct owner using command

$ psql -c "\l core"