My thought was that if ofbiz can not connect permanently there is no reason to have ofbiz running. users will get all sorts of errors starting at login. so just have ofbiz shut down. That way the ajp will give the 503 error.
David E Jones sent the following on 6/28/2009 9:00 AM: > > Well, no, it might be a good reason to shut it down, but you still don't > have enough details to say for sure. If it can't connect at all on > startup there are 2 likely reasons: > > 1. the database is not running or there is a firewall or other network > issue preventing access > 2. the database setup in OFBiz is incorrect > > If the problem is #1 then shutting down OFBiz won't do any good, unless > you want to keep people from accessing the site while you fix it. > > If the problem is #2 then you absolutely need to shut down and restart > OFBiz after making the configuration corrections. > > -David > > > On Jun 28, 2009, at 9:54 AM, BJ Freeman wrote: > >> this is 9.04 and is because it can not connect to the postmaster of >> postresql >> sorry I was not clear enough. >> But I can see from your comments this would not be the appropriate place >> to shut down ofbiz. >> >> >> >> David E Jones sent the following on 6/28/2009 8:41 AM: >>> >>> If that error shows up a few times and goes away then it just means the >>> server is busy (or that you haven't configured a big enough connection >>> pool to handle the HTTP request thread pool size). >>> >>> If that error shows up for all requests and no user can get in, then it >>> probably means your connection pool is full of stale connections. You >>> can look at the connection list for your database to verify this. This >>> shouldn't happen much in newer versions of OFBiz using DBCP, and was >>> more of a problem with the old Minerva stuff. >>> >>> -David >>> >>> >>> On Jun 28, 2009, at 9:22 AM, BJ Freeman wrote: >>> >>>> when the DB is not able to be connected to? >>>> [ DatabaseUtil.java:1059:ERROR] Unable to establish a connection with >>>> the database... Error was:java.sql.SQLException: Unable to acquire a >>>> new >>>> connection from the pool >>>> >>>> >>>> is there a reason not to shut down ofbiz at this point? >>>> >>>> >>>> -- >>>> BJ Freeman >>>> http://www.businessesnetwork.com/automation >>>> http://bjfreeman.elance.com >>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>>> >>>> >>>> Systems Integrator. >>>> >>> >>> >> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> >> Systems Integrator. >> > > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
