Error when trying to use the DB migration command

[RonRe]

Hi.
No that I've completed all the steps for deploying signal server V3.21, when I try to run the first command to migrate the DB as in step 12 of the guide, I hit this error, regarding "signal" db.
I don't remember any place in the guide that instructed to create such a DB. Here is a paste of the error. Please help:

java -jar service/target/TextSecureServer-3.21.jar abusedb migrate service/config/config.yml

ERROR [2021-03-03 14:58:02,295] org.apache.tomcat.jdbc.pool.ConnectionPool: Unable to create initial connections of pool.
! org.postgresql.util.PSQLException: FATAL: database "signal" does not exist
! at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:684)
! at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:199)
! at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
! at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:127)
! at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:29)
! at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:21)
! at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:41)
! at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)
! at org.postgresql.Driver.makeConnection(Driver.java:414)
! at org.postgresql.Driver.connect(Driver.java:282)
! at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319)
! at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:744)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:676)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:483)
! at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:154)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
! at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
! at org.whispersystems.textsecuregcm.liquibase.CloseableLiquibase.(CloseableLiquibase.java:20)
! at org.whispersystems.textsecuregcm.liquibase.AbstractLiquibaseCommand.openLiquibase(AbstractLiquibaseCommand.java:58)
! at org.whispersystems.textsecuregcm.liquibase.AbstractLiquibaseCommand.run(AbstractLiquibaseCommand.java:46)
! at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:87)
! at io.dropwizard.cli.Cli.run(Cli.java:78)
! at io.dropwizard.Application.run(Application.java:94)
! at org.whispersystems.textsecuregcm.WhisperServerService.main(WhisperServerService.java:406)
org.postgresql.util.PSQLException: FATAL: database "signal" does not exist
at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:684)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:199)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:127)
at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:41)
at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:414)
at org.postgresql.Driver.connect(Driver.java:282)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:744)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:676)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:483)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:154)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at org.whispersystems.textsecuregcm.liquibase.CloseableLiquibase.(CloseableLiquibase.java:20)
at org.whispersystems.textsecuregcm.liquibase.AbstractLiquibaseCommand.openLiquibase(AbstractLiquibaseCommand.java:58)
at org.whispersystems.textsecuregcm.liquibase.AbstractLiquibaseCommand.run(AbstractLiquibaseCommand.java:46)
at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:87)
at io.dropwizard.cli.Cli.run(Cli.java:78)
at io.dropwizard.Application.run(Application.java:94)
at org.whispersystems.textsecuregcm.WhisperServerService.main(WhisperServerService.java:406)

[madeindra]

@RonRe Unable to create initial connections of pool. means it unable to connect to the database.
You can see the message FATAL: database "signal" does not exist, means your database is not there, please config your database according to your postgres setup.

[RonRe]

@madeindra
Thanks for the reply.
I'm new to dockers. I though that if I do docker-compose up as stated, it will start all the required DB's and once I run the script, it will populate the information. I'm unclear a bit as to which data (or where) I need to change.
Can you elaborate a bit more on this?

[madeindra]

@RonRe Can you show me your docker-compose & config.yml, but please don't include the username & password

[Rahmaditha]

@madeindra where do i put this bash script to create the database?
https://github.com/madeindra/signal-setup-guide/tree/master/signal-docker/pg-init-scripts

[madeindra]

Fixed it. Sorry about that, it suppose to be run automatically by docker.

It need to stay right where it right now, inside pg-init-scripts directory of the docker directory. Just clone the repo, and run docker-compose up inside signal-docker directory.

[Rahmaditha]

i've already created the folder pg-init-scripts, add the volumes. and run the docker-compose. but still no database created.

[madeindra]

have you allow the script to be executable using chmod?

[Rahmaditha]

yes. chmod +x namefile.sh

i see the docker logs and there is no error

do i have to run this command?

what if i create the database manually in psql.

does the create user value the same as postgres_user or we create different user for each database.