Hi Ramon, On May 18, 2011, at 8:17 PM, Ramon Gomes Brandão - SERINT wrote:
> Hi, > > I've got it working. For PostgreSQL, in xwiki.db property from xwiki.cfg, it > should be leaved commented out since the database name is already specified > in the postgresql connection URL from hibernate.cgf.xml. If you specify > anything on that property in xwiki.cfg, hibernate tries to connect to a > schema that doesn't exist, other than the "public" created by default on the > xwiki database by postgresql, following the instructions on Admin Pages of > XWiki.org. > > I would suggest to add this note on XWiki Postgresql instrucutions page at > XWiki.org, since this is NOT documented elsewhere. The relation between > xwiki.db option and connection URL, for the Postgresql case, is confusing and > poor documented. I've spent two days figuring this out. xwiki.org is an open wiki, do you think you could help us and add it yourself? That would help us! Thanks -Vincent > Regards, > > Ramon Gomes Brandão > > > > > -----Mensagem original----- > De: users-boun...@xwiki.org em nome de Ramon Gomes Brandão - SERINT > Enviada: ter 17/5/2011 19:03 > Para: users@xwiki.org > Assunto: [xwiki-users] ERROR: XWiki 3.0M1 + Postgres + JBoss4.3 not working > > Hi all, > > I'm trying to set up a fresh install of XE 3.0 on a JBoss 4.3 + Postgres 8.3 > production environment. XE application deploys, but it does not start at all > when I point the browser to it. > > The stack trace root cause is: "org.postgresql.util.PSQLException: ERROR: > schema 'wikinf' does not exist". > > I've change the default database name from xwiki to wikinf, to attend our app > names. I've set it properly in xwiki.db property from xwiki.cfg and, as well, > in hibernate.cfg.xml file, on the postgres config section > (jdbc:postgresql://<server>/wikinf), and I followed just exactly the > Postgresql installation database creation instructions on Config pages from > Xwiki.org. My database, called "wikinf", has nothing but the default public > schema with the proper rights according to instructions (users and groups > created accordingly). > > I'm using the postgresql-9.0-801.jdbc4.jar connector. > > Why it says the schema does not exist, if the database indeed exist, with the > default public schema? I'm getting really annoying with this no-explication > error, and could not find any instructions on Web. Could you help me please? > > Regards, > > Ramon Gomes Brandão _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
