[xwiki-users] RES: ERROR: XWiki 3.0M1 + Postgres + JBoss4.3 not working

2011-05-18 Thread Ramon Gomes Brandão - SERINT
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.

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

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] RES: ERROR: XWiki 3.0M1 + Postgres + JBoss4.3 not working

2011-05-18 Thread Vincent Massol
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