[xwiki-users] Database Attachment and Filesystem Attachment
Hello Everyone I have this situation: I have a page with 3 attachment files: I used the Filesystem Attachment Porter to move the attachment in the database to the filesystem but it didn't worked, I get the message File Not Found so I was triying to going back to database attachment just for testing purposes, edited xwiki.cfg and restarted tomcat but it seems that the files are lost and cant add or remove them from the page, I clicked the attachment link on the page but nothing happen. Is there anything I can do to get my files back? Thanks in advance. -- View this message in context: http://xwiki.475771.n2.nabble.com/Database-Attachment-and-Filesystem-Attachment-tp7583229.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
Thanks a lot Guillaume, any idea would be greatly welcome. Cheers. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580576.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
Hi Guillaume, I've tried with the command you gave me and and I get this http://xwiki.475771.n2.nabble.com/file/n7580559/02_-_Connect_with_password.jpg As you can see so far I can login to the DB and I have full grants Change the port in hibernate.cfg.xml as you suggested. http://xwiki.475771.n2.nabble.com/file/n7580559/03_-_hibernate_conf_file.jpg Reload tomcat... and tada! Still the same issue :-( http://xwiki.475771.n2.nabble.com/file/n7580559/04_-_Same_problem.jpg Ive tried any sort of connections in the hibernate.cfg.xml file and I get always the same. Also I ve tried this What do you have in /etc/hosts ? I suspect some weird reverse DNS You should make sure nslookup 127.0.0.1 returns 'localhost' and not 'localhost.localdomain' which might be unknown to your mysql instance. You should have 127.0.0.1 localhost in your /etc/hosts (probably being first) Ludovic From this post http://xwiki.475771.n2.nabble.com/Re-Could-not-initialize-main-XWiki-context-td501954.html;cid=1343149060713-31 http://xwiki.475771.n2.nabble.com/Re-Could-not-initialize-main-XWiki-context-td501954.html;cid=1343149060713-31 I just don't get it, I'll keep searching anyway. Thanks a lot Guillaume. Cheers. Robinson. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580559.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
Hi Dmitry, thanks for the answer. Yeah, the database, user and password are set to xwiki, still cant find what wrong tho, xwiki user has full permisions, tried with diferent users, addresses etc, nothing works. Thanks anyway Dmitry, cheers. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580537.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
Any ideas? Thanks in advance. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580504.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Mysql Configuration problem
Hello everyone I' ve been really busy tryin to figure out what's wrong with my mysql conf., I've searched about this but can't find anything related so any advice, tip, hint... would be greatly welcome. Here's my conf. so far 1) Extracted xiki.war on tomcat/webapps folder... ( using Winscp ) http://xwiki.475771.n2.nabble.com/file/n7580467/xwiki-on-tomcat.jpg 2) Copy mysql driver inside xwiki/WEB-INF/lib folder http://xwiki.475771.n2.nabble.com/file/n7580467/mysql-driver-installed.jpg 3) Create the database xwiki ( currently empty ) http://xwiki.475771.n2.nabble.com/file/n7580467/mysql-database-list.jpg 4) Create user xwiki, grant all privileges ( using phpmyadmin) http://xwiki.475771.n2.nabble.com/file/n7580467/user-xwiki-all-provoleges.jpg 5) Edit the hibernate.cfg.xml file http://xwiki.475771.n2.nabble.com/file/n7580467/hibernate-cfg.jpg 6) Tomcat Working ... http://xwiki.475771.n2.nabble.com/file/n7580467/tomcat-working.jpg 7) netstat list, mysql http://xwiki.475771.n2.nabble.com/file/n7580467/procesos-mysql.jpg 8) And finally, THE HORROR!. http://xwiki.475771.n2.nabble.com/file/n7580467/xwiki-problem.jpg Any clue about this?, im using CentOS (based on Red Hat), seems like a dumb mistake but I'm out of ideas. Thanks in advance, Robinson. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Another installation problem....
Hi everyone, I'm new on xwiki, never heard of it before but here in the company they want to give it a try. I've been searching a lot now about this error and I think mine is quite particular from what I read and my conf. I followed this steps in order to complete the xwiki installation. 1) Copy the xwiki.war into the webapps folder,inside a new folder called xwiki 2) Copy the mysql driver (mysql-connector-java-5.1.9.jar) into $TOMCAT_HOME/webapps/xwiki/WEB_INF/lib 3) Edit the hibernate.cfg.xml file to use the mysql database 4) Then opened Mozilla at http://myaddres:9191/xwiki/ I get the following error pointing to hibernate.cfg.xml from what I see 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 [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. 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) causa raĆz 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 [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:417) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) 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) Heres the mysql configuration part.. property name=connection.urljdbc:mysql://localhost/xwiki/property property name=connection.username/property property name=connection.password/property property name=connection.driver_classcom.mysql.jdbc.Driver/property property name=dialectorg.hibernate.dialect.MySQL5InnoDBDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property mapping resource=xwiki.hbm.xml/ mapping resource=feeds.hbm.xml/ mapping resource=activitystream.hbm.xml/ Then why my case is particular... here's why. The server has XAMMP installed (PHP, MySQL, Apache) configured with another application, so I assume that I dont need to install MySQL since it's working now across XAMMP, and the process mysqld is running (we are using Linux CentOS, based on Red Hat), so we are not sure what's next about this problem. Any help would be appreciated, thanks in advance. -- View this message in context: http://xwiki.475771.n2.nabble.com/Another-installation-problem-tp7580408.html Sent
Re: [xwiki-users] Another installation problem....
Hi Guillaume, thanks for the reply Yeah that part is commented, here's a screenshot of that part I was thinkin maybe is the connection url property because in order to login to the databse I have to use this path: /opt/lammp/bin/mysql gonna try that but i'm not sure The dabatabse xwiki is created but empty, is that a problem or xwiki will fill it? http://xwiki.475771.n2.nabble.com/file/n7580410/xml-conf.jpg Thanks again. -- View this message in context: http://xwiki.475771.n2.nabble.com/Another-installation-problem-tp7580408p7580410.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users