Hi Craig,
Il 07/08/2018 08:30, Francesco Chicchiriccò ha scritto:
On 07/08/2018 00:03, craig wrote:
I am setting up syncope in Kubernetes. I will be happy to
contribute my
yamls once I get it running as it doesn't seem to be a common setup for
Syncope.
This sounds great, it would be a great addition, maybe to place right
after
https://syncope.apache.org/docs/getting-started.html#docker-compose-samples
I am new to Syncope and I am having some issues.
I was able to get the docker-compose examples working just fine but
having
connectivity issues when running in K8s. Without knowing Syncope
(or even
postgres) that well I am struggling on where to start.
Issue: Syncope cannot connect to postgres:5432
20:49:13.640 ERROR
org.flowable.common.engine.impl.AbstractEngineConfiguration - Exception
while initializing Database connection
org.postgresql.util.PSQLException: Connection to postgres:5432 refused.
Check that the hostname and port are correct and that the postmaster is
accepting TCP/IP connections.
[...]
Did you set a password for the user "syncope" like explained at [1]?
Is connectivity on protocol TCP allowed on your postgres instance?
BTW I found something (maybe) useful for you at [2].
Were the Syncope tables (SyncopeUser, for example) created, in the
database? Were the Flowable (e.g. ACT_*) and Quartz (e.g. QRTZ_*)
created as well?
Did you setup any connection control on the postgresql container?
Things that I did:
1) Connect to database directly from postgres container command line
"psql
-U syncope"
2) Connect to database from syncope container command line "psql -U
syncope
-h postgres"
Since this works, I cannot figure out why you get the exception above...
3) Confirm that the port 5432 is open by running the command "telnet
postgres 5432" and it was open
4) Confirm that both a database named "syncope" and user named
"syncope"
exist in the postgres database
5) Confirmed the configuration of K8s looks correct. The port
appears to
be up, the replica sets look correct
Any help or guidance on things to look at would be helpful.
Craig
HTH,
Andrea
[1] https://syncope.apache.org/docs/reference-guide.html#postgresql
[2]
https://blog.bigbinary.com/2016/01/23/configure-postgresql-to-allow-remote-connection.html
--
Dott. Andrea Patricelli
Tel. +39 3204524292
Developer @ Tirasa S.r.l.
Viale D'Annunzio 267 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PMC Member
