Uploaded image for project: '{RETIRED} XWiki Enterprise'
  1. {RETIRED} XWiki Enterprise
  2. XE-1288

Debian packages fail to configure for postgres

    Details

    • keywords:
      postgres, tomcat, tomcat6, tomcat7
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      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

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                csirac2 Paul Harvey
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: