[xwiki-users] Error because of Preferences
Hi. I was trying to get rid of the "Print" link through the .vm file and I got the error below. I undid everything I changed but the error persists. HTTP ERROR: 500 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 I did not get any information from anywhere else. I'm at risk of losing all the data which was entered by many people if it doesn't work again. Any solutions, please ? Harikrishnan -- View this message in context: http://www.nabble.com/Error-because-of-Preferences-tf4682780.html#a13380982 Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi, which file have you modified? and how? Basically if you don't want to have the print option, you can simpy hide it from the menu. In this way, if you change your mind and one day will need the printing option, it will be easy to have it back. Vito V. Harikrishnan Nair wrote:
Hi.
I was trying to get rid of the "Print" link through the .vm file and I got the error below. I undid everything I changed but the error persists.
HTTP ERROR: 500 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
I did not get any information from anywhere else. I'm at risk of losing all the data which was entered by many people if it doesn't work again. Any solutions, please ?
Harikrishnan
There is an easy solution, just replace the file from the origional release. Then you can hide the features using HTML comment tags like so: <!-- This will not be shown to the user --> -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Vitantonio Messa Sent: 24 October 2007 10:29 To: XWiki Users Subject: Re: [xwiki-users] Error because of Preferences Hi, which file have you modified? and how? Basically if you don't want to have the print option, you can simpy hide it from the menu. In this way, if you change your mind and one day will need the printing option, it will be easy to have it back. Vito V. Harikrishnan Nair wrote:
Hi.
I was trying to get rid of the "Print" link through the .vm file and I got the error below. I undid everything I changed but the error persists.
HTTP ERROR: 500 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
I did not get any information from anywhere else. I'm at risk of losing all the data which was entered by many people if it doesn't work again. Any solutions, please ?
Harikrishnan
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
I modified menuview.vm and I only commented the lines pertaining to the link. I didn't do anything else and I even changed it back to the earlier config. I have been able to hide the Documents link before. But now I do not understand the reason for this to happen. I want my data back ! :(( Esbach, Brandon wrote:
There is an easy solution, just replace the file from the origional release. Then you can hide the features using HTML comment tags like so: <!-- This will not be shown to the user -->
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Vitantonio Messa Sent: 24 October 2007 10:29 To: XWiki Users Subject: Re: [xwiki-users] Error because of Preferences
Hi,
which file have you modified? and how? Basically if you don't want to have the print option, you can simpy hide it from the menu. In this way, if you change your mind and one day will need the printing option, it will be easy to have it back.
Vito
V. Harikrishnan Nair wrote:
Hi.
I was trying to get rid of the "Print" link through the .vm file and I got the error below. I undid everything I changed but the error persists.
HTTP ERROR: 500 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
I did not get any information from anywhere else. I'm at risk of losing all the data which was entered by many people if it doesn't work again. Any solutions, please ?
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/Error-because-of-Preferences-tf4682780.html#a13382814 Sent from the XWiki- Users mailing list archive at Nabble.com.
I have not changed anything in the hibernate.cfg.xml file. The username 'sa' was present by default and I tried another backup file of the hibernate.cfg.xml file but it did not work either... This is the stack trace -> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon nectionFactory (User not found: SA) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:540) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionPr ovider.java:181) ... 40 more Caused by: java.sql.SQLException: User not found: SA at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:851) ... 42 more 16:07:09.484 INFO [P1-19] org.mortbay.util.Container.start(Container.java:74)
08> Started HttpContext[/,/]
Or please give me a method to retrieve all the data I have entered in the wiki. -- View this message in context: http://www.nabble.com/Error-because-of-Preferences-tf4682780.html#a13383259 Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi, There are good chances that you did not lost any data, unless you erased your database, but you would have noticed ... ;-) I had the same problem after migration of wiki kernel version. When re-deployed the .war file in my tomcat container, I forgot to add again the mysql*.jar library in $TOMCAT_HOME/webapps/xwiki/WEB-INF/lib Or is there a possibility that your hibernate.cfg.xml file was updated by someone else, or by you a long ago, and tomcat was restarted only recently, so the problem appears only now ? Most of the time default mysql user for xwiki is named xwiki ... Jeremie -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of V. Harikrishnan Nair Sent: mercredi 24 octobre 2007 12:48 To: [email protected] Subject: Re: [xwiki-users] Error because of Preferences I have not changed anything in the hibernate.cfg.xml file. The username 'sa' was present by default and I tried another backup file of the hibernate.cfg.xml file but it did not work either... This is the stack trace -> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon nectionFactory (User not found: SA) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:540) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionPr ovider.java:181) ... 40 more Caused by: java.sql.SQLException: User not found: SA at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:851) ... 42 more 16:07:09.484 INFO [P1-19] org.mortbay.util.Container.start(Container.java:74)
08> Started HttpContext[/,/]
Or please give me a method to retrieve all the data I have entered in the wiki. -- View this message in context: http://www.nabble.com/Error-because-of-Preferences-tf4682780.html#a13383 259 Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
No. Only I have the access. I even copy-pasted the original cfg file. But the problem I found was with the database script which I replaced. The wiki is working but the data is not available. Plus I need this solution for shifting to a new computer (refer to 'Shifting to a new computer' in this forum). BOUSQUET Jeremie-2 wrote:
Hi,
There are good chances that you did not lost any data, unless you erased your database, but you would have noticed ... ;-)
I had the same problem after migration of wiki kernel version. When re-deployed the .war file in my tomcat container, I forgot to add again the mysql*.jar library in $TOMCAT_HOME/webapps/xwiki/WEB-INF/lib
Or is there a possibility that your hibernate.cfg.xml file was updated by someone else, or by you a long ago, and tomcat was restarted only recently, so the problem appears only now ? Most of the time default mysql user for xwiki is named xwiki ...
Jeremie
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of V. Harikrishnan Nair Sent: mercredi 24 octobre 2007 12:48 To: [email protected] Subject: Re: [xwiki-users] Error because of Preferences
I have not changed anything in the hibernate.cfg.xml file. The username 'sa' was present by default and I tried another backup file of the hibernate.cfg.xml file but it did not work either...
This is the stack trace ->
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon nectionFactory (User not found: SA) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:540) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionPr ovider.java:181) ... 40 more Caused by: java.sql.SQLException: User not found: SA at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:851) ... 42 more
16:07:09.484 INFO [P1-19] org.mortbay.util.Container.start(Container.java:74)
08> Started HttpContext[/,/]
Or please give me a method to retrieve all the data I have entered in the wiki. -- View this message in context: http://www.nabble.com/Error-because-of-Preferences-tf4682780.html#a13383 259 Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________ 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/Error-because-of-Preferences-tf4682780.html#a13400474 Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (4)
-
BOUSQUET Jeremie -
Esbach, Brandon -
V. Harikrishnan Nair -
Vitantonio Messa