OK, giving the right privileges to jahia user was the point. Now Jahia is working ok with the remote postgresql db.
What I am dubting if the process of migration from the hsql to the postgres was right. First i have character coding issues, maybe HSQL and postgres were not working in the same locale configuration. Has anybody migrated from HSQL to Postgres succesfully? I think our process is not the right one. By the other hand I am getting the next error in the catalina.out log: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update I dont know exactly where can the problem come form. El Mar, 13 de Noviembre de 2007, 12:35 pm, Javier Turégano escribió: > > Mmmmm, it looks like a postgresql rights issue. I can access the > prefs_node table from the local server but not from the remote one with > command line. > > I will take a look at the db rights. > > El Mar, 13 de Noviembre de 2007, 12:29 pm, Javier Turégano escribió: >> Hi Sergiy, >> >> You were totally right, we were using the portal with ROOT context. >> Modifying ROOT.xml makes jahia start connecting to the postgresql server >> and not the HSQL. >> >> A big steep, but still not working. It looks like we did not well the >> data >> migration or there are some issues we havent take care correctly. >> >> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException >> during the execution of the query (for >> org.apache.jetspeed.prefs.om.impl.NodeImpl): ERROR: >> permission denied for the relation prefs_node >> >> Any idea of the problem? Is there any procedure to load HSQL sql data to >> postgresql? We did not find any. >> >> El Mar, 13 de Noviembre de 2007, 11:46 am, Sergiy Shyrkov escribió: >>> Hi Javier, >>> >>> The last exception that I see in your catalina.out file is: >>> >>> 13-nov-2007 11:00:33 org.apache.catalina.core.StandardContext >>> resourcesStart >>> GRAVE: Error arrancando Recursos estáticos >>> java.lang.IllegalArgumentException: El Documento base >>> /var/www/jahia/tomcat/webapps/jahia no existe o no es un directorio >>> legible >>> at >>> org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:140) >>> >>> >>> I am not confident with Spanish, but assume that the Jahia Web >>> application is not found under webapps/jahia. >>> Have you used Jahia with "/jahia" context or as a ROOT Web application? >>> It could be that jahia.xml is a wrong file in case of ROOT application >>> or you have accidentally overwritten your line with docbase with the >>> one >>> I sent you: >>> ... >>> <Context path="/jahia" docBase="jahia" crossContext="true"> >>> ... >>> >>> Could you check it, please, and let me know. It can be, that we are >>> trying to change the wrong file :-) >>> >>> Kind regards >>> Sergiy >>> >>> Javier Turégano wrote: >>>> Hi Sergiy, >>>> >>>> A lot of thanks for your help and the time you are using with us. I >>>> expect >>>> there is no problem mailing you directly the catalina.out, I thought >>>> it >>>> would be a good idea not to flood the list, but if there is any >>>> problem >>>> just tell me. >>>> >>>> Here is the output of tomcat at the startup with the changes you >>>> recomended us. >>>> >>>> >>> >>> >> >> >> -- >> --------------------------------- >> Javier Turégano Molina >> Jefe de Proyecto >> >> Andago Ingeniería >> www.andago.com >> t: 916011373 Ext. 45 >> f: 916011372 >> -------------------------------- >> ADE7 A690 29BB C644 3021 3919 C702 E423 014A D1F6 >> >> _______________________________________________ >> install_list mailing list >> [email protected] >> http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list >> > > > -- > --------------------------------- > Javier Turégano Molina > Jefe de Proyecto > > Andago Ingeniería > www.andago.com > t: 916011373 Ext. 45 > f: 916011372 > -------------------------------- > ADE7 A690 29BB C644 3021 3919 C702 E423 014A D1F6 > > _______________________________________________ > install_list mailing list > [email protected] > http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list > -- --------------------------------- Javier Turégano Molina Jefe de Proyecto Andago Ingeniería www.andago.com t: 916011373 Ext. 45 f: 916011372 -------------------------------- ADE7 A690 29BB C644 3021 3919 C702 E423 014A D1F6 _______________________________________________ install_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
