Adding new database to cyclos 4.5.1

Any issue about installation and configuration of the Cyclos 4 version

Moderators: hugo, alexandre, rmvanarkel

Post Reply
percyvel
Posts: 1
Joined: Wed Apr 20, 2016 2:02 pm

Adding new database to cyclos 4.5.1

Post by percyvel »

I had a working cyclos version 4.5.1 under localhost.

Then I wanted to add a new database with a new database name and password.

So I followed the steps to install a new database under PostgreSql.

Database:
CREATE USER percy WITH PASSWORD 'percy';
CREATE DATABASE percy ENCODING 'UTF-8' TEMPLATE template0;
GRANT ALL PRIVILEGES ON DATABASE percy to cyclos;
\c percy
create extension cube;
create extension earthdistance;
create extension postgis;
create extension unaccent;

New database percy was successfully created under cyclos (please find attached the screenshot).

Root page change:

The root of the server was changed from
C:\apache-tomcat-7.0.65\tomcat home\webapps\cyclos
to
C:\apache-tomcat-7.0.65\tomcat home\webapps\percy

Cyclos properties changes:
C:\apache-tomcat-7.0.65\tomcat home\webapps\percy\WEB-INF\classes

The cyclos properties were changed from
cyclos.datasource.jdbcUrl = jdbc:postgresql://localhost/cyclos4
cyclos.datasource.user = cyclos
cyclos.datasource.password = cyclos

to
cyclos.datasource.jdbcUrl = jdbc:postgresql://localhost/percy
cyclos.datasource.user = percy
cyclos.datasource.password = percy

But when I tried to login with the new database admin name and password, it didn’t accept the new username and password and also the old username and password of cyclos4.

I would like to know whether there could be a conflict between the database admin username and password of cyclos4 and the admin username and password of new database percy. If that is the case, what are the best solutions available for me?

1. Is there another way of solving this problem?

2. Can I solve this problem by resetting the admin password as explain in this webpage below
http://www.jvmhost.com/articles/reset-cyclos-4-admin-password.

I really appreciate your help. Thank you very much in advance.

Best Regards,
Percy
Attachments
print screen fo the Username and password incorrect
print screen fo the Username and password incorrect
connextionFailure.jpeg (109.76 KiB) Viewed 2248 times
print sceen of the structure of the database
print sceen of the structure of the database
structureDb.jpeg (250.86 KiB) Viewed 2248 times

Post Reply