[xwiki-users] Shifting to a new computer
Hi. I am shifting my wiki into another computer. I wish to retain the same state of the wiki as it is now - the same registered users, document pages, preferences etc. Could I just copy-paste the wiki files ? :) Harikrishnan -- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13361084 Sent from the XWiki- Users mailing list archive at Nabble.com.
Export the contents of your XWiki in a XAR, import the XAR back in your new XWiki :-) You can search for "Import" on XWiki.org to find out more about this topic. Guillaume On 23/10/2007, V. Harikrishnan Nair <[email protected]> wrote:
Hi.
I am shifting my wiki into another computer. I wish to retain the same state of the wiki as it is now - the same registered users, document pages, preferences etc. Could I just copy-paste the wiki files ? :)
Harikrishnan -- View this message in context: http://www.nabble.com/Shifting -to-a-new-computer-tf4676458.html#a13361084 Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Guillaume Lerouge wrote:
Export the contents of your XWiki in a XAR, import the XAR back in your new XWiki :-)
Please, take care : the import functionality isn't working right now (http://jira.xwiki.org/jira/browse/XWIKI-1809) -- Víctor A. Rodríguez (http://www.bit-man.com.ar) El bit Fantasma (Bit-Man) - Algorithm junkie Perl Mongers Capital Federal (http://cafe.pm.org/) GNU/Linux User Group - FCEyN - UBA (http://glugcen.dc.uba.ar/
I usally do it the long way round: 1) Disable tomcat/other-java-container 2) Full backup of database. MySQL has this feature as part of it's admin gui. 3) Move xwiki folder from the old tomcat server to the new one. Make sure tomcat is disabled on new server. 4) Restore database to the new server. Create username and assign permissions. You may need to do some configuration updates to allow the import of large data. 5) Start tomcat on new server, and login. I have a document for each of my main wiki classes so that each can be qualified - I do this for each new release that we use in the plant as well. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of "Víctor A. Rodríguez" Sent: 23 October 2007 12:17 To: XWiki Users Subject: Re: [xwiki-users] Shifting to a new computer Guillaume Lerouge wrote:
Export the contents of your XWiki in a XAR, import the XAR back in your new XWiki :-)
Please, take care : the import functionality isn't working right now (http://jira.xwiki.org/jira/browse/XWIKI-1809) -- Víctor A. Rodríguez (http://www.bit-man.com.ar) El bit Fantasma (Bit-Man) - Algorithm junkie Perl Mongers Capital Federal (http://cafe.pm.org/) GNU/Linux User Group - FCEyN - UBA (http://glugcen.dc.uba.ar/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
I've got a small doubt. Right now, the database configuration in the hibernate.cfg.xml is using the one shown below and not the MySQL (which is commented) - <property name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> Does this mean that it is not using a database currently? I had tried to configure it to MySQL now but on restart it showed an error (refer to 'Error on restart' by me). Is it safe to configure a MySQL database in the new computer and import the xar file ? Harikrishnan -- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13379125 Sent from the XWiki- Users mailing list archive at Nabble.com.
So you're not using MySQL as database, but the one that is bundled with XWiki. I think you can simply copy and paste the database folder from the old pc to the new one. Can anyone confirm this? Vito V. Harikrishnan Nair wrote:
I've got a small doubt. Right now, the database configuration in the hibernate.cfg.xml is using the one shown below and not the MySQL (which is commented) -
<property name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
Does this mean that it is not using a database currently? I had tried to configure it to MySQL now but on restart it showed an error (refer to 'Error on restart' by me).
Is it safe to configure a MySQL database in the new computer and import the xar file ?
Harikrishnan
Can I view the data from the database which is bundled with XWiki ? Vitantonio Messa wrote:
So you're not using MySQL as database, but the one that is bundled with XWiki. I think you can simply copy and paste the database folder from the old pc to the new one. Can anyone confirm this?
Vito
V. Harikrishnan Nair wrote:
I've got a small doubt. Right now, the database configuration in the hibernate.cfg.xml is using the one shown below and not the MySQL (which is commented) -
<property name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
Does this mean that it is not using a database currently? I had tried to configure it to MySQL now but on restart it showed an error (refer to 'Error on restart' by me).
Is it safe to configure a MySQL database in the new computer and import the xar file ?
Harikrishnan
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13379718 Sent from the XWiki- Users mailing list archive at Nabble.com.
Sorry but I cannot really help on this. I've been using XWiki with MySQL from the beginning, so I really don't know that much about HSQL-DB. Vito V. Harikrishnan Nair wrote:
Can I view the data from the database which is bundled with XWiki ?
Vitantonio Messa wrote:
So you're not using MySQL as database, but the one that is bundled with XWiki. I think you can simply copy and paste the database folder from the old pc to the new one. Can anyone confirm this?
Vito
V. Harikrishnan Nair wrote:
I've got a small doubt. Right now, the database configuration in the hibernate.cfg.xml is using the one shown below and not the MySQL (which is commented) -
<property name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
Does this mean that it is not using a database currently? I had tried to configure it to MySQL now but on restart it showed an error (refer to 'Error on restart' by me).
Is it safe to configure a MySQL database in the new computer and import the xar file ?
Harikrishnan
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
V. Harikrishnan Nair wrote:
Can I view the data from the database which is bundled with XWiki ?
Could this helps? http://hsqldb.sourceforge.net/doc/guide/ch01.html Depending in the platform you are using as client OS, you will have a number of options to connect/read/write data to/from your hsqldb database. You have already seen in the connection.url property in hibernate.cfg.xml that XWiki is using JDBC to connect to the database. Not only to hsqldb but also to MySQL. Thus, you can use any other client using JDBC. A simple OpenOffice JDBC connection could work. Cheers, -- Ricardo Rodríguez Your XEN ICT Team
Hi Hari, As suggested just export and re-import from the Administration page. Someone mentioned that the export feature is broken. I haven't found so. I think this person meant that it's not working only when trying to import an old XWiki 0.9 version in a new 1.1 version. AFAIK it's not broken in 1.1. I'll double check when I'm at my desk again (offline now). Re HSQLDB yes, you can also very simply copy the $XWIKINSTALLDIR/ database/ directory to the new computer too but the import/export will work between any databases and should be preferred. That's unless your database is so big that it becomes unpractical and then pure database import/export solution should be used. But I don't think this is your case from what I see. Thanks -Vincent On Oct 23, 2007, at 12:18 PM, V. Harikrishnan Nair wrote:
Hi.
I am shifting my wiki into another computer. I wish to retain the same state of the wiki as it is now - the same registered users, document pages, preferences etc. Could I just copy-paste the wiki files ? :)
Harikrishnan
Hi Vincent, Vincent Massol wrote:
Hi Hari,
As suggested just export and re-import from the Administration page.
Someone mentioned that the export feature is broken. I haven't found so. I think this person meant that it's not working only when trying to import an old XWiki 0.9 version in a new 1.1 version.
AFAIK it's not broken in 1.1. I'll double check when I'm at my desk again (offline now).
I mentioned it :-) and just to make it clear : - the broken one is the import functionality (IMHO). Just take a look at http://jira.xwiki.org/jira/browse/XWIKI-1809 (I think that at least someone else couldn't make it work). It didn't work for me in 1.1.4918 but it throws a NullPointerException - the export functionality now works on 0.9 (I mean it is documented how to make it work in http://www.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HFillingitwithda...) HTH -- Víctor A. Rodríguez (http://www.bit-man.com.ar) El bit Fantasma (Bit-Man) - Algorithm junkie Perl Mongers Capital Federal (http://cafe.pm.org/) GNU/Linux User Group - FCEyN - UBA (http://glugcen.dc.uba.ar/
On Oct 24, 2007, at 5:24 PM, Víctor A. Rodríguez wrote:
Hi Vincent,
Vincent Massol wrote:
Hi Hari,
As suggested just export and re-import from the Administration page.
Someone mentioned that the export feature is broken. I haven't found so. I think this person meant that it's not working only when trying to import an old XWiki 0.9 version in a new 1.1 version.
AFAIK it's not broken in 1.1. I'll double check when I'm at my desk again (offline now).
I mentioned it :-) and just to make it clear :
- the broken one is the import functionality (IMHO). Just take a look at http://jira.xwiki.org/jira/browse/XWIKI-1809 (I think that at least someone else couldn't make it work). It didn't work for me in 1.1.4918 but it throws a NullPointerException
Could you please explain a bit more your case? In the case of Marc Lijour it didn't work because he was importing from a 0.9 version. AFAIK it's working fine if you import from a 1.0 or later version. I've never seen an issue with it when importing 1.0 or later so I'm curious to know how I can reproduce this problem.
- the export functionality now works on 0.9 (I mean it is documented how to make it work in http://www.xwiki.org/xwiki/bin/view/AdminGuide/ Installation#HFillingitwithdata)
Thanks -Vincent
Vincent Massol wrote:
On Oct 24, 2007, at 5:24 PM, Víctor A. Rodríguez wrote:
Hi Vincent,
Vincent Massol wrote:
Hi Hari,
As suggested just export and re-import from the Administration page.
Someone mentioned that the export feature is broken. I haven't found so. I think this person meant that it's not working only when trying to import an old XWiki 0.9 version in a new 1.1 version.
AFAIK it's not broken in 1.1. I'll double check when I'm at my desk again (offline now) I mentioned it :-) and just to make it clear :
- the broken one is the import functionality (IMHO). Just take a look at http://jira.xwiki.org/jira/browse/XWIKI-1809 (I think that at least someone else couldn't make it work). It didn't work for me in 1.1.4918 but it throws a NullPointerException
Could you please explain a bit more your case? In the case of Marc Lijour it didn't work because he was importing from a 0.9 version. AFAIK it's working fine if you import from a 1.0 or later version.
That's exactly my case, importing from 0.9 Sorry, I wasn't paying attention that the problem was importing from 1.0 -- Víctor A. Rodríguez (http://www.bit-man.com.ar) El bit Fantasma (Bit-Man) - Algorithm junkie Perl Mongers Capital Federal (http://cafe.pm.org/) GNU/Linux User Group - FCEyN - UBA (http://glugcen.dc.uba.ar/
On Oct 24, 2007, at 7:28 PM, Víctor A. Rodríguez wrote:
Vincent Massol wrote:
On Oct 24, 2007, at 5:24 PM, Víctor A. Rodríguez wrote:
Hi Vincent,
Vincent Massol wrote:
Hi Hari,
As suggested just export and re-import from the Administration page.
Someone mentioned that the export feature is broken. I haven't found so. I think this person meant that it's not working only when trying to import an old XWiki 0.9 version in a new 1.1 version.
AFAIK it's not broken in 1.1. I'll double check when I'm at my desk again (offline now) I mentioned it :-) and just to make it clear :
- the broken one is the import functionality (IMHO). Just take a look at http://jira.xwiki.org/jira/browse/XWIKI-1809 (I think that at least someone else couldn't make it work). It didn't work for me in 1.1.4918 but it throws a NullPointerException
Could you please explain a bit more your case? In the case of Marc Lijour it didn't work because he was importing from a 0.9 version. AFAIK it's working fine if you import from a 1.0 or later version.
That's exactly my case, importing from 0.9 Sorry, I wasn't paying attention that the problem was importing from 1.0
The problem seems to be importing from a 0.9 version (importing from 1.0 should work fine I think). -Vincent
But there should be a place visible to the human eye where all the data is stored :) ! I had a problem with the script which I replaced but the data is missing... I want to try to copy-paste the default HSQL database (wherever it is). If this works, then I can say that XWiki is the most friendly wiki I have ever come across ! I could even create a document 'In case of errors' or 'shifting your wiki' or 'creating an easy backup' !!! :) Vitantonio Messa wrote:
Sorry but I cannot really help on this. I've been using XWiki with MySQL from the beginning, so I really don't know that much about HSQL-DB.
Vito
V. Harikrishnan Nair wrote:
Can I view the data from the database which is bundled with XWiki ?
Vitantonio Messa wrote:
So you're not using MySQL as database, but the one that is bundled with XWiki. I think you can simply copy and paste the database folder from the old pc to the new one. Can anyone confirm this?
Vito
V. Harikrishnan Nair wrote:
I've got a small doubt. Right now, the database configuration in the hibernate.cfg.xml is using the one shown below and not the MySQL (which is commented) -
<property name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
Does this mean that it is not using a database currently? I had tried to configure it to MySQL now but on restart it showed an error (refer to 'Error on restart' by me).
Is it safe to configure a MySQL database in the new computer and import the xar file ?
Harikrishnan
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13400443 Sent from the XWiki- Users mailing list archive at Nabble.com.
On Oct 25, 2007, at 7:14 AM, V. Harikrishnan Nair wrote:
But there should be a place visible to the human eye where all the data is stored :)
Yes. Check my last answer from yesterday. I've specified this location and what you could do.
! I had a problem with the script which I replaced but the data is missing... I want to try to copy-paste the default HSQL database (wherever it is). If this works, then I can say that XWiki is the most friendly wiki I have ever come across ! I could even create a document 'In case of errors' or 'shifting your wiki' or 'creating an easy backup' !!! :)
See my last email on this thread. Thanks -Vincent
Vitantonio Messa wrote:
Sorry but I cannot really help on this. I've been using XWiki with MySQL from the beginning, so I really don't know that much about HSQL-DB.
Vito
V. Harikrishnan Nair wrote:
Can I view the data from the database which is bundled with XWiki ?
Vitantonio Messa wrote:
So you're not using MySQL as database, but the one that is bundled with XWiki. I think you can simply copy and paste the database folder from the old pc to the new one. Can anyone confirm this?
Vito
V. Harikrishnan Nair wrote:
I've got a small doubt. Right now, the database configuration in the hibernate.cfg.xml is using the one shown below and not the MySQL (which is commented) -
<property name="connection.url">jdbc:hsqldb:file:database/ xwiki_db;shutdown=true</property> <property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectio nProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
Does this mean that it is not using a database currently? I had tried to configure it to MySQL now but on restart it showed an error (refer to 'Error on restart' by me).
Is it safe to configure a MySQL database in the new computer and import the xar file ?
Harikrishnan
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- View this message in context: http://www.nabble.com/Shifting-to-a- new-computer-tf4676458.html#a13400443 Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
vmassol wrote:
Re HSQLDB yes, you can also very simply copy the $XWIKINSTALLDIR/ database/ directory to the new computer too but the import/export will work between any databases and should be preferred.
Sorry for 'turning a blind eye', Vincent, thank you for pointing it out. But I do not understand - if you meant copying C:/xwiki/.../database, it did not work. There was a problem with the script (which I replaced). I do not know what $XWIKINSTALLDIR means otherwise (Is it velocity language ?). thank you for being so patient with me. Harikrishnan -- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13403262 Sent from the XWiki- Users mailing list archive at Nabble.com.
On Oct 25, 2007, at 11:41 AM, V. Harikrishnan Nair wrote:
vmassol wrote:
Re HSQLDB yes, you can also very simply copy the $XWIKINSTALLDIR/ database/ directory to the new computer too but the import/export will work between any databases and should be preferred.
Sorry for 'turning a blind eye', Vincent, thank you for pointing it out. But I do not understand - if you meant copying C:/xwiki/.../database, it did not work. There was a problem with the script (which I replaced). I do not know what $XWIKINSTALLDIR means otherwise (Is it velocity language ?). thank you for being so patient with me.
Copying database/ works fine. I've done it countless times. Of course if you tampered with the files inside database/ then you're on your own. Database data should never be modified directly. $XWIKINSTALLDIR is where you installed XE (that's if you've used the standalone installation). Anyway if you found the database/ directory then you know where the HSQLDB files are stored. Thanks -Vincent
I had installed using this -> xwiki-enterprise-installer-windows-1.2-milestone-1.exe Thank you anyway, Vincent, I've found the culprit. The files were indeed tampered with inadvertently. :) vmassol wrote:
On Oct 25, 2007, at 11:41 AM, V. Harikrishnan Nair wrote:
vmassol wrote:
Re HSQLDB yes, you can also very simply copy the $XWIKINSTALLDIR/ database/ directory to the new computer too but the import/export will work between any databases and should be preferred.
Sorry for 'turning a blind eye', Vincent, thank you for pointing it out. But I do not understand - if you meant copying C:/xwiki/.../database, it did not work. There was a problem with the script (which I replaced). I do not know what $XWIKINSTALLDIR means otherwise (Is it velocity language ?). thank you for being so patient with me.
Copying database/ works fine. I've done it countless times. Of course if you tampered with the files inside database/ then you're on your own. Database data should never be modified directly.
$XWIKINSTALLDIR is where you installed XE (that's if you've used the standalone installation). Anyway if you found the database/ directory then you know where the HSQLDB files are stored.
Thanks -Vincent
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13404094 Sent from the XWiki- Users mailing list archive at Nabble.com.
After installing both my servlet container and Mysql database, I am still not able to log into xwiki. I edited the necessary files and am positive that Tomcat 5.5 is configured correctly. I can get the apache page but when I click xwiki home I get the error listed below. One strange thing is when I comment the mysql database back, it allows me to view the xwiki but when I uncomment like the directions say, it does not work. What could be the problem? Thanks, Tim javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool 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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) root cause 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 XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:247) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) 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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
It sounds like you don't have the mysql database driver in your classpath. This is a separate download from the web. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Campbell, Timothy D Sent: Friday, October 26, 2007 1:39 PM To: XWiki Users Subject: Exception while reading document XWiki.XWikiPreferences After installing both my servlet container and Mysql database, I am still not able to log into xwiki. I edited the necessary files and am positive that Tomcat 5.5 is configured correctly. I can get the apache page but when I click xwiki home I get the error listed below. One strange thing is when I comment the mysql database back, it allows me to view the xwiki but when I uncomment like the directions say, it does not work. What could be the problem? Thanks, Tim javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool org.apache.struts.action.RequestProcessor.processException(RequestProces sor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:117) root cause 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 XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:247) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:117)
Hi. The same thing has happened to me too. I had run xwiki without changing the conf.xml file first. When I changed the database after the very first call I got the error you mentioned below. My guess is that when you run it for the first time, it 'sticks' to the database it sees first and refuses to let go... :) I suggest you export a backup xar file (if you have any data) from your running wiki, then install a new wiki with your database, see if it works and then import the xar file. Keep the old installation, just in case, if you want to tinker around with it. Harikrishnan Hammonds,John,ST LOUIS,Engineering wrote:
It sounds like you don't have the mysql database driver in your classpath. This is a separate download from the web.
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Campbell, Timothy D Sent: Friday, October 26, 2007 1:39 PM To: XWiki Users Subject: Exception while reading document XWiki.XWikiPreferences
After installing both my servlet container and Mysql database, I am still not able to log into xwiki. I edited the necessary files and am positive that Tomcat 5.5 is configured correctly. I can get the apache page but when I click xwiki home I get the error listed below. One strange thing is when I comment the mysql database back, it allows me to view the xwiki but when I uncomment like the directions say, it does not work. What could be the problem?
Thanks, Tim
javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool
org.apache.struts.action.RequestProcessor.processException(RequestProces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:117)
root cause 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 XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:247) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:117)
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- View this message in context: http://www.nabble.com/Shifting-to-a-new-computer-tf4676458.html#a13439777 Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi Tim, Try following again the instructions from http://www.xwiki.org/xwiki/ bin/view/AdminGuide/InstallationMySQL As John was saying you may be missing the mysql java connector jar. In any case this is a DB configuration issue. Thanks -Vincent On Oct 26, 2007, at 8:39 PM, Campbell, Timothy D wrote:
After installing both my servlet container and Mysql database, I am still not able to log into xwiki. I edited the necessary files and am positive that Tomcat 5.5 is configured correctly. I can get the apache page but when I click xwiki home I get the error listed below. One strange thing is when I comment the mysql database back, it allows me to view the xwiki but when I uncomment like the directions say, it does not work. What could be the problem?
Thanks, Tim
javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool 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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:117)
root cause 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 XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:247) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) 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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:117) <winmail.dat> _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Thanks to both of you but now it is not allowing me to create a class sheet for the "XWiki.XWikiServerClass". I need this in order to set up the virtual wiki. Also other pages are giving me the same error. (4.26) Error number 4001 in 4: Error while parsing velocity page XWiki.XWikiServer Wrapped Exception: Invocation of method 'substring' in class java.lang.String threw exception java.lang.StringIndexOutOfBoundsException: String index out of range: -1 @ XWiki.XWikiServer4,26? <https://wmail.wssu.edu/xwiki/bin/edit/XWiki/4%2C26?parent=XWiki.XWikiServer&editor=wysiwyg> Do you have any idea why this may be happening? ________________________________ From: [email protected] on behalf of Vincent Massol Sent: Sat 10/27/2007 2:42 AM To: XWiki Users Subject: Re: [xwiki-users] Exception while reading documentXWiki.XWikiPreferences Hi Tim, Try following again the instructions from http://www.xwiki.org/xwiki/ bin/view/AdminGuide/InstallationMySQL As John was saying you may be missing the mysql java connector jar. In any case this is a DB configuration issue. Thanks -Vincent On Oct 26, 2007, at 8:39 PM, Campbell, Timothy D wrote:
After installing both my servlet container and Mysql database, I am still not able to log into xwiki. I edited the necessary files and am positive that Tomcat 5.5 is configured correctly. I can get the apache page but when I click xwiki home I get the error listed below. One strange thing is when I comment the mysql database back, it allows me to view the xwiki but when I uncomment like the directions say, it does not work. What could be the problem?
Thanks, Tim
javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool 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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:117)
root cause 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 XWiki.XWikiPreferences Wrapped Exception: Could not create a DBCP pool com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:247) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:397) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) 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:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:117) <winmail.dat> _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hey, I created a page (People) in my xwiki and I am trying to incorporate another blog for that with forms and a Blog.Macro. I was successful on creating the page and forms but it continues to post to the original blog rather than a new one like I want. Any suggestions on what I can do so I will have two blogs in the same wiki? Thanks for your time, Tim
participants (9)
-
"Víctor A. Rodríguez" -
Campbell, Timothy D -
Esbach, Brandon -
Guillaume Lerouge -
Hammonds,John,ST LOUIS,Engineering -
V. Harikrishnan Nair -
Vincent Massol -
Vitantonio Messa -
Your XEN ICT Team - Ricardo Rodriguez