Can't retrieve default tenant id
Bonita BPM Community 6.2.2 bundled with Tomcat
Feb 27, 2014 10:42:09 AM org.apache.naming.NamingContext lookup
WARNING: Unexpected exception resolving reference
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection is broken: "java.net.ConnectException: Connection refused: localhost:9091" [90067-170])
Further down in the log I find this;
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)<br />
at org.h2.message.DbException.get(DbException.java:158)<br />
at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:399)<br />
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:287)<br />
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:109)<br />
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:93)<br />
at org.h2.Driver.connect(Driver.java:72)
I have completely removed reference to the H2 listener from server.xml, following is the line I removed;
I'm connecting to a mysql database on an external server, I have updated bitronix-resources.properties to point to my sql server as shown;
resource.ds1.driverProperties.user=xxxx<br />
resource.ds1.driverProperties.password=xxxx<br />
resource.ds1.driverProperties.URL=jdbc:mysql://srvmysql:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8<br />
resource.ds1.driverProperties.testQuery=SELECT 1
And my bonita.xml been update;
type="javax.sql.DataSource"
maxActive="17"
minIdle="5"
maxWait="10000"
initialSize="3"
maxPoolSize="15"
minPoolSize="3"
maxConnectionAge="0"
maxIdleTime="1800"
maxIdleTimeExcessConnections="120"
idleConnectionTestPeriod="30"
acquireIncrement="3"
validationQuery="SELECT 1"
validationInterval="30000"
testConnectionOnCheckout="true"
removeAbandoned="true"
logAbandoned="true"
username="xxxxxx"
password="xxxxx"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://srvmysql:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8"/>
Finally setup the xetevn.sh with the proper database type; B_OPTS="-Dsysprop.bonita.db.vendor=mysql". Added mysql-connector-java-5.1.29-bin.jar to the /lib directory. I have went into platform-tenant-config.porperties and added the line platform.create=true.
What else am I missing? Happy to supply my log but like to know what is the best way to share it?
Thanks for your help.
I don't understand, I was postive I posted a solution to my issue, but now I don't see it. It would appear I owe you an apology. Want I found out in the inst. located here http://documentation.bonitasoft.com/tomcat-bundle was to add the following line
Note: add to the appropriate section in the file bitronix-resources.properties
Found the issue with my setup, under the setup insturcations there is this
Note: add to the appropriate section in the file bitronix-resources.properties
Tested the user and password set in bonita by logging into the mysql database from the bonita server. I was able to login with the designated user, create tables. I did have to issue command "use BonitaV6" before I could create a table. How does this user know which database to use or is it expected that this user be able to create the database?
Comments
the database to use is in the connect string (the URL in the config file). in the example you posted you are looking for the database called bonita - it is what is directly after the portnumber/ in the URL. if it's called bonita here, and bonitaV6 on your server, that might be the problem.
otherwise, can we see the log file? (you can post it here, or if you have a dropbox you can share).
Hi TheB2B,
there are a bunch of things on the checklist for server setup. I read your submission and I think you've covered most of them. Have you created the (empty) bonita DB on srvmysql and given user xxxxxx admin rights to it?
try starting up and see what the log says the problem is.
and you can post the log entry here if you like - just take care to truncate it so that it is only the bit from the startup.
thx,
-declan
Comments
Preformed the points suggested, still unable to successfully get Bonita running.
Any further suggestions? I'm open to try most anything at this point, provide more information, looking for some help here please.
Here is what I believe you are looking for;
If not let me know, thanks for the help!
Found source of the problem, in the setup inst there is a line to add the following;
Note: add to the appropriate section in the file bitronix-resources.properties
Comments
And sorry I was away from the thread for so long - I'm glad you got it sorted out.
Strange that the commend vanished. if it happens again we can refer it to the admin on this site.