Last step, Dédalo installation

TCR

Hi,

I would like to ask for your help with the following problem. I installed Dédalov6 on Ubuntu 22.04. I had some problems with Apache, but Alex's help and reinstalling Ubuntu solved them. Then I followed the directions to install v6 on the computer, everything went great until I got to the next step:
Rename sample.config.php to config.php.
and its continuation.

How can I change the name of the files once I have created the database, the user, and the password?
I'm sure it's a simple step, but I can't see the way to do it.
Thank you for your help.
Regards
Tomás

Alex

Hi TCR

To rename files you can use the mv command:
mv sample.config.php config.php

As the installation page say.

Optional. if you want copy the sample.xxx files to preserve the originals as reference you can use cpcommand:
cp sample.config.php config.php

with cp you will have two files, sample.config.php and config.php

Best

TCR

Thank you very much for your help Alex, I will try it and let you know how it worked out.
However, I also wanted to share with you a copy of the problems I had before submitting my query. I think it might be of help to everyone.
Regards!

root@arqueoserver:/var/www/html# su - postgres
psql
postgres@arqueoserver:~$ CREATE USER dedalo_user PASSWORD 'serverxxx';
CREATE: orden no encontrada
postgres@arqueoserver:~$ dedalo_user PASSWORD 'serverxxx';
dedalo_user: orden no encontrada
postgres@arqueoserver:~$ CREATE USER dedalo_user PASSWORD 'serverxxx';
CREATE: orden no encontrada
postgres@arqueoserver:~$ sudo -u postgres psql
postgres no está en el archivo sudoers. Se informará de este incidente.
postgres@arqueoserver:~$ su - postgres
psql
Contraseña:
su: Fallo de autenticación
psql (15.3 (Ubuntu 15.3-1.pgdg22.04+1))
Digite «help» para obtener ayuda.

postgres=# psql
postgres-# CREATE USER dedalo_user PASSWORD 'serverxxx';
ERROR: error de sintaxis en o cerca de «psql»
LÍNEA 1: psql
^
postgres=# CREATE USER dedalo_user PASSWORD 'serverxxx';
CREATE ROLE
postgres=# CREATE DATABASE dedalo_arqueoserver
WITH ENCODING='UTF8'
OWNER=dedalo_user
CONNECTION LIMIT=-1
TABLESPACE=pg_default;

COMMENT ON DATABASE dedalo_arqueoserver
IS 'Dédalo: Cultural Heritage and Memory management system';
CREATE DATABASE
COMMENT
postgres=# cd [...]/dedalo/config/
mv sample.config.php config.php
postgres-# status
postgres-#

Alex

TCR

Hi TCR

Seem that commands was not done correctly.

I can see in the first 3 commands:

root@arqueoserver:/var/www/html# su - postgres psql postgres@arqueoserver:

that psql command was not execute, and only the first command was done. So, the next lines was not done because you are not in psql console.

Well, step by step:

1 You need to test if your PostgreSQL is running:

systemctl status postgresql

If PostgreSQL is running you can go to next command, if not, review the PostgreSQL installation.

2 copy the command 1 to 1 and ensure that every command was executed.
first:

su - postgres

you will need to show that the terminal change the user as postgres@arqueoserver:
when you are with postgres user, enter the psql command

psql

you will see that the terminal was changed to postgres=# then, copy the SQL commands to create user and database.

CREATE USER dedalo_user PASSWORD 'My_super_Secret_pw';

CREATE DATABASE dedalo_xxx
WITH ENCODING='UTF8'
OWNER=dedalo_user
CONNECTION LIMIT=-1
TABLESPACE=pg_default;

COMMENT ON DATABASE dedalo_xxx
IS 'Dédalo: Cultural Heritage and Memory management system';

Then and before rename the config files you will need to exit from psql and postgres user.
cd, mv or cp commands are NOT SQL commands!

So, you can exit from psql with:

\q

and you can exit from postgres user with:

exit

Then you will need to see that the terminal back to root@arqueoserver: user before enter the shell bash commands

Notes:
In any action you must READ what the terminal say.
I recommend you to read the oficial bash documentation
I recommend you to see the oficial postgreSQL documentation about psql

And final note: I recommend you to get help for someone with server experience. Using the terminal could be dangerous if you don't have control about it.

Best