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. [...]
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
-- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Member at The Apache Software Foundation Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail http://home.apache.org/~ilgrosso/
