How can I create a JDBC connection to the Postgres database in Kubuntu?
1,113 views
Skip to first unread message
Alfred Albrecht
Feb 9, 2015, 4:32:23 AM2/9/15
to mayoca...@googlegroups.com
Dear Sir,
This idea of a open source marketplace is wonderful!
But please, how can I create a JDBC connection to the Postgres database in Kubuntu?
Sincerely yours.
This idea of a open source marketplace is wonderful!
But please, how can I create a JDBC connection to the Postgres database in Kubuntu?
Sincerely yours.
Jérôme Velociter
Feb 16, 2015, 8:48:48 AM2/16/15
to mayoca...@googlegroups.com
Hi Alfred,
I'm not sure I understand your question. You can configure the Postgresql connection in mayocat.yml (see the "configure the environment" section in http://www.mayocat.org/installation-guide). Does this help ?
Jérôme
Jack Saunders
Mar 1, 2015, 10:55:51 AM3/1/15
to mayoca...@googlegroups.com
Hello Jerome
Thanks for your answer. I have tried to install Mayocat under both Kubuntu 14.04.1 LTS as well as Debian Jessie. I am getting the same error message in both systems i.e. :
jack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)jack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDajack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)jack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Conn at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openCjack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Con at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openCjack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.ojack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61) at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openCjack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.ojack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:50)
... 7 more
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:50)
... 7 more
nectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.ojack@debian:~/mayocat-shop-distribution-0.30.1/bin$ ./migrate.sh
Exception in thread "main" com.googlecode.flyway.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1174)
at com.googlecode.flyway.core.Flyway.info(Flyway.java:981)
at org.mayocat.flyway.FlywayMigrateCommand.run(FlywayMigrateCommand.java:54)
at com.yammer.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:58)
at com.yammer.dropwizard.cli.Cli.run(Cli.java:53)
at com.yammer.dropwizard.Service.run(Service.java:61)
at org.mayocat.shop.application.MayocatShopService.main(MayocatShopService.java:50)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:50)
... 7 more
ection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:397)
at org.postgresql.Driver.connect(Driver.java:267)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:193)
at com.googlecode.flyway.core.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:161)
at com.googlecode.flyway.core.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:50)
... 7 more
The error is even longer.
Jérôme Velociter
Mar 1, 2015, 12:53:00 PM3/1/15
to mayoca...@googlegroups.com
Hi Jack,
From the logs, it seems the password you've provided in mayocat.yml does not match the password of the postgres user.
Can you verify you can connect to postgres with that user and password from CLI ?
Jerome
Jack Saunders
Mar 2, 2015, 7:48:41 AM3/2/15
to mayoca...@googlegroups.com
Hi Jerome,
Yes, the configuration file uses the appropriate password for the user postgres
I can use the start command "psql" while logged in as user postgres, so the password is OK.
Does the ./migrate.sh script need to be run as user postgres as well, or can I run that script as a normal user while logged on in the terminal to the downloaded Mayocat decompressed folder?
The first error shows up as a JDBC connection failure. Is there maybe a JDBC driver missing, or perhaps does this need to run as some sort of daemon right from boot-up time?
Jack
Jack Saunders
Mar 2, 2015, 1:00:37 PM3/2/15
to mayoca...@googlegroups.com
OK, seems to work now in Debian Jessie
The database password needed to be created before attempting to run the migrate.sh script. The password is created at the postgres # prompt using the postgresql command "\password"
There was also a second issue with the curl command for setting up the web login for the site - a rather long command string. I simply copied the command into an executable bash script text file and after several abortive attempts, it seemed to work. The curl command is included on the Mayocat installation instructions page.
Reply all
Reply to author
Forward
0 new messages