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
