Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.5
-
Ubuntu 12.04.2 LTS server, configured with Postgres and OpenSSH selected in tasksel.
-
postgres, tomcat, tomcat6, tomcat7
-
N/A
-
N/A
-
Description
On a fresh VM, I do:
sudo apt-get install xwiki-enterprise-tomcat6-pgsql
or
sudo apt-get install xwiki-enterprise-tomcat7-pgsql
which installs and configures tomcat6 (or 7) and postgres 9.1. It appears to install successfully, however visiting the server on :8080 gives me an error 500 page with the following backtrace:
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiGlobalRights] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: The empty database xwiki seems to be not writable, please check your configuration! org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) root cause
I've verified that I can connect as the nominated user with the nominated password asked for during dbconfig.
I've verified that this user can create and drop tables in the xwiki database.
I've tried manually granting all privileges to the xwiki database user on the xwiki database.
I've tried granting superuser permission on the xwiki user.
The first few lines when hitting :8080 with the 500 error from the postgres logs are: 2013-02-21 15:38:08 EST ERROR: relation "xwikidbversion" does not exist at character 45 2013-02-21 15:38:08 EST STATEMENT: select this_.XWV_VERSION as XWV1_25_0_ from xwikidbversion this_ 2013-02-21 15:38:08 EST ERROR: relation "xwikidoc" does not exist at character 29 2013-02-21 15:38:08 EST STATEMENT: select count(*) as y0_ from xwikidoc this_ 2013-02-21 15:38:08 EST ERROR: relation "xwikidbversion" does not exist at character 45 2013-02-21 15:38:08 EST STATEMENT: select this_.XWV_VERSION as XWV1_25_0_ from xwikidbversion this_ 2013-02-21 15:38:08 EST ERROR: relation "xwikidoc" does not exist at character 29
... and so on.
The package xwiki-enterprise-tomcat7-mysql appears to work fine, however.
Attachments
Issue Links
- is related to
-
XWIKI-8835 Nullpointer exception when "xwiki.virtual_mode" is not set in hibernate.cfg.xml with Postgre SQL
- Closed
-
XWIKI-9004 PostgreSQL wrongly tries to switch to the schema with database name when in database mode
- Closed
-
XWIKI-1960 Add virtual mode support for postgresql using schemas
- Closed