trouble with postgres DB

[maibarr...@yahoo.com.mx]

Hello

My name is Martin Ibarra Romero from CDMX and Estado de Mexico of Mexico Country

 

I hope use CMS system for  2 state contest..

 

But, I can not install cms site.

 

The cmsIntDB script show this message " Operational error while talking to the DB. Is the connection string in cms.conf correct?" I replaced the password in cms.conf int this line "database": "postgresql+psycopg2://cmsuser:your_password_here@localhost:5432/cmsdb", what can I do?

 

 

I am  waiting for news

 

Martin Ibarra Romero

Olipic

 

[Cristian Consonni]

Hi,

On 18/9/20 23:32, maibarraromero via Contest Management System (support)
wrote:

> The cmsIntDB script show this message " Operational error while talking
> to the DB. Is the connection string in cms.conf correct?" I replaced the
> password in cms.conf int this line "database":
> "postgresql+psycopg2://cmsuser:your_password_here@localhost:5432/cmsdb",
> what can I do?

Assuming that you have a standard installation of PostgreSQL on your
machine (localhost, port 5432), you need to create a database called
"cmsdb" and a database user called "cmsuser" and grant permissions to
this users on this database:
```
GRANT ALL PRIVILEGES ON DATABASE "cmsdb" to "cmsuser";
```

Then you can test that the connection to the database is working with:
```
psql -U cmsuser -d cmsdb
```

At that point you can issue the command `cmsInitDB`.

Best,

Cristian