16-Jan-2018 06:07:52.635 INFO [http-nio-8080-exec-3] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/ecb-webapp.war] has finished in [155,043] ms
2018-01-16 06:08:48,916 [http-nio-8080-exec-7] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Connections could not be acquired from the underlying database!
that’s from the server logs. the credentials i provided was correct, so i don’tknow what am missing here. Any assistance?
Hee Myankey,
U need to set the properties of the database. U can find it in: /WEB-INF/classes/application.properties
db.default.dialect = org.hibernate.dialect.PostgreSQLDialect
db.default.driver = org.postgresql.Driver
db.default.ddl = update
#db.default.url = jdbc:postgresql://localhost:5432/axelor-business-suite
db.default.url = jdbc:postgresql://postgres:5432/erp
db.default.user = “username”
db.default.password = “password”
that’s how i set it, kindly check if i missed anything
So your sql server is named postgres ? the database is erp, user is username and password is password ?
check all is right with psql -h postgres erp username
just to clear some doubt, I have ubuntu installed with the postgres installed on it.
so the sql server name mentioned will be the localhost?
i changed localhost to postgres when as a way to troubleshoot the connection issue.
Yes and try it first what buess also says.
psql -h myhost -d mydb -U myuser -W
In your case: psql -h localhost -d erp -U username -W
Then hostname is localhost
Did you issue createdb & createuser to create your database and user?
@itvix i tried the localhost configuration and i still had the same error.
@beuss i did issue the same command createdb and createuser . the DB and the user were different names. could that be the issue? will purge the postgres sql and start the configure all over.
Did you try the psql command line example we gave you ? You’ll have a more meaningful error message and could test quickly (instead of modifying & restarting)
@beuss i tried the "psql -h localhost -d erp -U username -W " and it worked.
reconfigured the application.properties, run ./gradlew war, deployed on the tomcat webserver and i got same error.
Can you paste the 3 or 4 lines related to db configuration?
this is the db config
db.default.dialect = org.hibernate.dialect.PostgreSQLDialect
db.default.driver = org.postgresql.Driver
db.default.ddl = update
db.default.url = jdbc:postgresql://localhost:5432/axelor-business-suite
db.default.user = serverdb
db.default.password = server
If psql -h localhost -d erp -U username -W then url should end with erp (jdbc:postgresql://localhost:5432/erp) and user should be username
yeah @beuss, it worked. thanks soo much.
any idea on how to get this threading issue solved?
Type Exception Report
Message Work already begun on this thread. Looks like you have called UnitOfWork.begin() twice without a balancing call to end() in between.
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
When does this occur?
when i run it in two concurrent instance.
Never hit that. You mean you’re deploying it twice on the same server?
ok, thanks. it wasn’t loading fully, but i loads all good.
any material to explain the modules, models, objects, permissions etc… and how i can fully configure them all?
User guide is planned to be delivered along with v5
You’ll find technical documentation here http://docs.axelor.com/adk/latest/welcome/index.html
Remainder is on the forum 