[xwiki-users] GlassFish + MySQL + Xwiki
Hi, ** Not sure if i'm posting this in correct place, as this is my 1st post. ** I have installed GlassFish v 3.1.2.2 + MySQL 5.6 + Xwiki-enterprise-web-5.0.war Not sure if I’m using the correct Java container and DB... I will be using Xwiki with large DB. Have i choose the correct Container and DB? what do you recommend I should use. I don’t have any coding experience at all. Many Thanks, H -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and "lightness" ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p7584388.ht... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi and welcome, You could check the pre-requisites in install guide [1], BR, Jeremie [1] http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HPrerequisi... 2013/3/20 Hirji.patel <[email protected]>
Hi, ** Not sure if i'm posting this in correct place, as this is my 1st post. ** I have installed GlassFish v 3.1.2.2 + MySQL 5.6 + Xwiki-enterprise-web-5.0.war
Not sure if I’m using the correct Java container and DB... I will be using Xwiki with large DB.
Have i choose the correct Container and DB? what do you recommend I should use. I don’t have any coding experience at all.
Many Thanks, H
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hirji, Running MySQL is good enough I feel. Using Jetty makes it very easy to start just xwiki because of the packaging. Otherwise, using other servlet containers should work. Many have been using tomcat. We, at curriki, employ the Sun Java Application Server, which is a version earlier than Glassfish, and it is serving very well. My experience was however that exploding the war is necessary in almost all cases (and Glassfish supports this) so as to configure things. paul On 20 mars 2013, at 14:12, Hirji.patel wrote:
Hi, ** Not sure if i'm posting this in correct place, as this is my 1st post. ** I have installed GlassFish v 3.1.2.2 + MySQL 5.6 + Xwiki-enterprise-web-5.0.war
Not sure if I’m using the correct Java container and DB... I will be using Xwiki with large DB.
Have i choose the correct Container and DB? what do you recommend I should use. I don’t have any coding experience at all.
Many Thanks, H
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and "lightness" ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p758438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well. I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-) BR, Jeremie 2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p758438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p758438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Thank you for helping me out here. Xwiki will be in production with large files. 15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL? Regards, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p75 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ ____
____________________________________________________________________ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
Hi, Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat#H InstallationSteps This is what I have done so far... Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file) What's Next.. to get my xwiki going? Install Mysql? Regards, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Thank you for helping me out here. Xwiki will be in production with large files. 15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL? Regards, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p75 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ ____
____________________________________________________________________ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat is just one step On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel <[email protected]> wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat#H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p75 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ ____
____________________________________________________________________ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
Hi, After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml But now I get error below. Not sure what I'm doing wrong. Xml file attached. HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context ------------------------------------------------------------------------ -------- type Exception report message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context description The server encountered an internal error that prevented it from fulfilling this request. exception 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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml 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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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) 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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) 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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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) root cause com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:876) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) 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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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) root cause org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246) org.hibernate.cfg.Configuration.configure(Configuration.java:2158) com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure (DefaultHibernateSessionFactory.java:105) com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernate BaseStore.java:211) com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:607) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:749) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) 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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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) root cause org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482) org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238) org.hibernate.cfg.Configuration.configure(Configuration.java:2158) com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure (DefaultHibernateSessionFactory.java:105) com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernate BaseStore.java:211) com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:607) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:749) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) 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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs. ------------------------------------------------------------------------ -------- Apache Tomcat/7.0.37 Regards, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat is just one step On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel <[email protected]> wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get
with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p7 5 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
___________________________________________________________________ _ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ ____
___________________________________________________________________ _ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki Sorin B. On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel <[email protected]> wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
------------------------------------------------------------------------ --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
------------------------------------------------------------------------ --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel <[email protected]> wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get
with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p7 5 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
___________________________________________________________________ _ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ ____
___________________________________________________________________ _ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hirji, please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing). paul On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel <[email protected]> wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
------------------------------------------------------------------------ --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.configure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
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:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
------------------------------------------------------------------------ --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel <[email protected]> wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get
with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p7 5 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
___________________________________________________________________ _ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ ____
___________________________________________________________________ _ ____ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hello, I'm still finding it difficult to get my xwiki working, can anyone help me. I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders I have configured the hibernate.cfg.xml but it does not work keep getting error: 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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml Hibernate.cfg.xml <property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmts =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> Not sure what im doing wrong, can someone help me configure xml file. Many thanks, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki Hirji, please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing). paul On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel <[email protected]> wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
--------------------------------------------------------------------- --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestPro ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateSt ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.config ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibern ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHiber nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateSt ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.config ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibern ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHiber nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateSt ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
--------------------------------------------------------------------- --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomca t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel <[email protected]> wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomc at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected]> wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted
for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what
is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel <[email protected]>
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production
using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get
with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p 7 5 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
__________________________________________________________________ _ _ ____ This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk __________________________________________________________________ _ _ ____
__________________________________________________________________ _ _ ____ This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk __________________________________________________________________ _ _ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_____________________________________________________________________ ___ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _____________________________________________________________________ ___
_____________________________________________________________________ ___ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _____________________________________________________________________ ___ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
Hi, Hirji! There is a parameter xwiki.db in xwiki.cfg. You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: xwiki.db=xwiki_db Restart XWiki. Most probably should work Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>:
Hello,
I'm still finding it difficult to get my xwiki working, can anyone help me.
I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders
I have configured the hibernate.cfg.xml but it does not work keep getting error:
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmts =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Not sure what im doing wrong, can someone help me configure xml file.
Many thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hirji,
please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing).
paul
On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < [email protected] > wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
--------------------------------------------------------------------- --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestPro ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateSt ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.config ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibern ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHiber nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateSt ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.config ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibern ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHiber nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateSt ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reques tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionF ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
--------------------------------------------------------------------- --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomca t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < [email protected] > wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomc at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected] > wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted
for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what
is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel < [email protected] >
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production
using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get
with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p 7 5 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
__________________________________________________________________ _ _ ____ This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk __________________________________________________________________ _ _ ____
__________________________________________________________________ _ _ ____ This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk __________________________________________________________________ _ _ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __
____________________________________________________________________ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ __ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_____________________________________________________________________ ___ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _____________________________________________________________________ ___
_____________________________________________________________________ ___ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _____________________________________________________________________ ___ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Kind regards, Dmitry
I have made that change and still no joy. Same error... about Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml Is my hibernate.cfg.xml configured correctly? Regards, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dmitry Bakbardin Sent: 28 March 2013 16:43 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki Hi, Hirji! There is a parameter xwiki.db in xwiki.cfg. You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: xwiki.db=xwiki_db Restart XWiki. Most probably should work Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>:
Hello,
I'm still finding it difficult to get my xwiki working, can anyone help me.
I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders
I have configured the hibernate.cfg.xml but it does not work keep getting error:
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmt s =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Not sure what im doing wrong, can someone help me configure xml file.
Many thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hirji,
please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing).
paul
On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < [email protected]
wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
-------------------------------------------------------------------- - --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestPr o ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS t ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.confi g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHiber n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibe r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.confi g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHiber n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibe r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
-------------------------------------------------------------------- - --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomc a t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < [email protected] > wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTom c at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected] > wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted
for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what
is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel < [email protected] >
Thanks,
Which Servlet Container should I be using?
My DB will have large attachments and images.
Regards, H
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: [email protected] Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB & Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to "file-system attachments storage" or to use another database (not MySQL) - this is my opinion.
My experience with big attachments - from the begging I have Windows
+ Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage
- and right now I prefer this variant - more speed and "lightness" ...
But, in any case, Your selection is not bad variant for production
using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results & more speed you can get
with more simple hardware & software...
-- Best regards Eugen Colesnicov
-- View this message in context:
http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387 p 7 5 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_________________________________________________________________ _ _ _ ____ This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _________________________________________________________________ _ _ _ ____
_________________________________________________________________ _ _ _ ____ This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _________________________________________________________________ _ _ _ ____ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
___________________________________________________________________ _ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ __ __
___________________________________________________________________ _ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ __ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
___________________________________________________________________ _ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ __ __
___________________________________________________________________ _ __ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___________________________________________________________________ _ __ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
____________________________________________________________________ _ ___ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ _ ___
____________________________________________________________________ _ ___ This e-mail has been scanned for all viruses by Star. The service
is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ____________________________________________________________________ _ ___ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________________________________ _ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _______________________________________________________________________ _
_______________________________________________________________________ _ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk _______________________________________________________________________ _ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Kind regards, Dmitry _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
On 03/28/2013 12:50 PM, Hirji Patel wrote:
I have made that change and still no joy.
Same error... about Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Is my hibernate.cfg.xml configured correctly?
If it's a parsing error, then something is syntactically wrong in the file. Look for a stray <!-- or --> in it. Can you pastebin the whole contents of the file?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dmitry Bakbardin Sent: 28 March 2013 16:43 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hi, Hirji!
There is a parameter xwiki.db in xwiki.cfg. You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: xwiki.db=xwiki_db
Restart XWiki. Most probably should work
Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>:
Hello,
I'm still finding it difficult to get my xwiki working, can anyone help me.
I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders
I have configured the hibernate.cfg.xml but it does not work keep getting error:
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmt s =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Not sure what im doing wrong, can someone help me configure xml file.
Many thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hirji,
please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing).
paul
On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < [email protected]
wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
-------------------------------------------------------------------- - --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestPr o ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS t ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.confi g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHiber n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibe r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238)
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.confi g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHiber n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibe r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateS t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.jav a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Reque s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversion F ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
-------------------------------------------------------------------- - --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomc a t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < [email protected] > wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTom c at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected] > wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted
for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what
is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel < [email protected] >
> Thanks, > > Which Servlet Container should I be using? > > My DB will have large attachments and images. > > Regards, > H > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Eugen Colesnicov > Sent: 20 March 2013 13:46 > To: [email protected] > Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki > > Recommendations about DB & Container depend on Your scenario of > XWiki using ... For example, if you will have many and large > attachments - need to switch XWiki to "file-system attachments > storage" or to use another database (not MySQL) - this is my opinion. > > My experience with big attachments - from the begging I have > Windows
> + Glassfish + Oracle (attachments stored in DB), after I migrated > for Linux + MySQL + Tomcat, but with file-system attachments > storage
> - and right now I prefer this variant - more speed and "lightness" ... > > But, in any case, Your selection is not bad variant for > production
> using (for example comparative to other java servlets). Also you > should understand, that XWiki - it is not a BIG-BIG system, for > example, likes MS SharePoint. Same results & more speed you can > get
> with more simple hardware & software... > > -- > Best regards > Eugen Colesnicov >
-- Sergiu Dumitriu http://purl.org/net/sergiu
Here is the Hibernate,cfg.xml file. <?xml version="1.0" encoding="UTF-8"?> <!-- * See the NOTICE file distributed with this work for additional * information regarding copyright ownership. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. --> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) --> <!-- Generic parameters common to all Databases --> <property name="show_sql">false</property> <property name="use_outer_join">true</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. --> <property name="jdbc.use_scrollable_resultset">false</property> <!-- DBCP Connection Pooling configuration <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <!-- Setting dbcp.ps.maxActive configuration tells DBCP whether to cache Prepared Statement or not. Note 1: When using HSQLDB for example, it's important to NOT cache prepared statements because HSQLDB Prepared Statements (PS) contain the schema on which they were initially created and thus when switching schema if the same PS is reused it'll execute on the wrong schema! Since HSQLDB does internally cache prepared statement there's no performance loss. see http://jira.xwiki.org/browse/XWIKI-1740. Thus we recommend not turning on this configuration for HSQLDB unless you know what you're doing :) Note 2: The same applies to PostGreSQL. --> <!-- BoneCP Connection Pooling configuration. <property name="bonecp.idleMaxAgeInMinutes">240</property> <property name="bonecp.idleConnectionTestPeriodInMinutes">60</property> <property name="bonecp.partitionCount">3</property> <property name="bonecp.acquireIncrement">10</property> <property name="bonecp.maxConnectionsPerPartition">60</property> <property name="bonecp.minConnectionsPerPartition">20</property> <property name="bonecp.statementsCacheSize">50</property> <property name="bonecp.releaseHelperThreads">3</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> --> <!-- Configuration for the default database. Comment out this section and uncomment other sections below if you want to use another database. Note that the database tables will be created automatically if they don't already exist. <property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/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> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <!-- MySQL configuration. Uncomment if you want to use MySQL and comment out other database configurations. --> <property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> --> <!-- HSQLDB configuration. Uncomment if you want to use HSQLDB and comment out other database configurations. <property name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;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> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> --> <!-- PostgreSQL configuration. Uncomment if you want to use PostgreSQL and comment out other database configurations. Notes: - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 - "xwiki.virtual_mode" can be set to either "schema" or "database". Note that currently the database mode doesn't support database creation (see http://jira.xwiki.org/browse/XWIKI-8753) <property name="connection.url">jdbc:postgresql:xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="xwiki.virtual_mode">schema</property> <mapping resource="xwiki.postgresql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> --> <!-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Notes: - the 2 properties named "connection.SetBigStringTryClob" and "jdbc.batch_size". They are required to tell Oracle to allow CLOBs larger than 32K. - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 <property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.SetBigStringTryClob">true</property> <property name="jdbc.batch_size">0</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> --> <!-- Derby configuration. Uncomment if you want to use Derby and comment out other database configurations. <property name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> <property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> <property name="dialect">org.hibernate.dialect.DerbyDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.derby.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> --> </session-factory> </hibernate-configuration> Thanks, Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: 28 March 2013 17:33 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki On 03/28/2013 12:50 PM, Hirji Patel wrote:
I have made that change and still no joy.
Same error... about Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Is my hibernate.cfg.xml configured correctly?
If it's a parsing error, then something is syntactically wrong in the file. Look for a stray <!-- or --> in it. Can you pastebin the whole contents of the file?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dmitry Bakbardin Sent: 28 March 2013 16:43 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hi, Hirji!
There is a parameter xwiki.db in xwiki.cfg. You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: xwiki.db=xwiki_db
Restart XWiki. Most probably should work
Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>:
Hello,
I'm still finding it difficult to get my xwiki working, can anyone help me.
I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders
I have configured the hibernate.cfg.xml but it does not work keep getting error:
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepSt mt s =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Not sure what im doing wrong, can someone help me configure xml file.
Many thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hirji,
please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing).
paul
On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < [email protected]
wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
------------------------------------------------------------------- - - --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestP r o ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernate S t ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.ja v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246 )
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.conf i g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibe r n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHib e r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernate S t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.ja v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238 )
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.conf i g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibe r n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHib e r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernate S t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.ja v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
------------------------------------------------------------------- - - --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTom c a t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < [email protected] > wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTo m c at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected] > wrote:
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup
of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started
several years ago with version 0.9), some attachments got corrupted
for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well.
I don't think servlet container will have a big impact on the way big
attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what
is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-)
BR, Jeremie
2013/3/20 Hirji Patel < [email protected] >
> Thanks, > > Which Servlet Container should I be using? > > My DB will have large attachments and images. > > Regards, > H > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Eugen Colesnicov > Sent: 20 March 2013 13:46 > To: [email protected] > Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki > > Recommendations about DB & Container depend on Your scenario of > XWiki using ... For example, if you will have many and large > attachments - need to switch XWiki to "file-system attachments > storage" or to use another database (not MySQL) - this is my opinion. > > My experience with big attachments - from the begging I have > Windows
> + Glassfish + Oracle (attachments stored in DB), after I > + migrated > for Linux + MySQL + Tomcat, but with file-system attachments > storage
> - and right now I prefer this variant - more speed and "lightness" ... > > But, in any case, Your selection is not bad variant for > production
> using (for example comparative to other java servlets). Also you > should understand, that XWiki - it is not a BIG-BIG system, for > example, likes MS SharePoint. Same results & more speed you can > get
> with more simple hardware & software... > > -- > Best regards > Eugen Colesnicov >
-- Sergiu Dumitriu http://purl.org/net/sergiu _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
On Thu, Mar 28, 2013 at 7:35 PM, Hirji Patel <[email protected]> wrote:
Here is the Hibernate,cfg.xml file.
<?xml version="1.0" encoding="UTF-8"?>
<!-- * See the NOTICE file distributed with this work for additional * information regarding copyright ownership. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. -->
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory>
<!-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -->
<!-- Generic parameters common to all Databases -->
<property name="show_sql">false</property> <property name="use_outer_join">true</property>
<property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
<!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. --> <property name="jdbc.use_scrollable_resultset">false</property>
<!-- DBCP Connection Pooling configuration
Comment opened but never closed.
<property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<!-- Setting dbcp.ps.maxActive configuration tells DBCP whether to cache Prepared Statement or not.
Note 1: When using HSQLDB for example, it's important to NOT cache prepared statements because HSQLDB Prepared Statements (PS) contain the schema on which they were initially created and thus when switching schema if the same PS is reused it'll execute on the wrong schema! Since HSQLDB does internally cache prepared statement there's no performance loss. see http://jira.xwiki.org/browse/XWIKI-1740. Thus we recommend not turning on this configuration for HSQLDB unless you know what you're doing :)
Note 2: The same applies to PostGreSQL. -->
<!-- BoneCP Connection Pooling configuration. <property name="bonecp.idleMaxAgeInMinutes">240</property> <property name="bonecp.idleConnectionTestPeriodInMinutes">60</property> <property name="bonecp.partitionCount">3</property> <property name="bonecp.acquireIncrement">10</property> <property name="bonecp.maxConnectionsPerPartition">60</property> <property name="bonecp.minConnectionsPerPartition">20</property> <property name="bonecp.statementsCacheSize">50</property> <property name="bonecp.releaseHelperThreads">3</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> -->
<!-- Configuration for the default database.
Comment opened but never closed.
Comment out this section and uncomment other sections below if you want to use another database. Note that the database tables will be created automatically if they don't already exist.
<property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/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> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
<!-- MySQL configuration. Uncomment if you want to use MySQL and comment out other database configurations. --> <property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
-->
Badly closed comment. No matching open comment. Hope this helps, Marius
<!-- HSQLDB configuration. Uncomment if you want to use HSQLDB and comment out other database configurations. <property name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;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> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
<!-- PostgreSQL configuration. Uncomment if you want to use PostgreSQL and comment out other database configurations. Notes: - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 - "xwiki.virtual_mode" can be set to either "schema" or "database". Note that currently the database mode doesn't support database creation (see http://jira.xwiki.org/browse/XWIKI-8753)
<property name="connection.url">jdbc:postgresql:xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="xwiki.virtual_mode">schema</property> <mapping resource="xwiki.postgresql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
<!-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Notes: - the 2 properties named "connection.SetBigStringTryClob" and "jdbc.batch_size". They are required to tell Oracle to allow CLOBs larger than 32K. - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.SetBigStringTryClob">true</property> <property name="jdbc.batch_size">0</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
<!-- Derby configuration. Uncomment if you want to use Derby and comment out other database configurations. <property name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> <property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> <property name="dialect">org.hibernate.dialect.DerbyDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.derby.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
</session-factory> </hibernate-configuration>
Thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: 28 March 2013 17:33 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
On 03/28/2013 12:50 PM, Hirji Patel wrote:
I have made that change and still no joy.
Same error... about Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Is my hibernate.cfg.xml configured correctly?
If it's a parsing error, then something is syntactically wrong in the file. Look for a stray <!-- or --> in it. Can you pastebin the whole contents of the file?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dmitry Bakbardin Sent: 28 March 2013 16:43 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hi, Hirji!
There is a parameter xwiki.db in xwiki.cfg. You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: xwiki.db=xwiki_db
Restart XWiki. Most probably should work
Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>:
Hello,
I'm still finding it difficult to get my xwiki working, can anyone help me.
I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders
I have configured the hibernate.cfg.xml but it does not work keep getting error:
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepSt mt s =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Not sure what im doing wrong, can someone help me configure xml file.
Many thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hirji,
please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing).
paul
On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < [email protected]
wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
------------------------------------------------------------------- - - --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(RequestP r o ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernate S t ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.ja v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2246 )
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.conf i g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibe r n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHib e r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernate S t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.ja v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2238 )
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.conf i g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibe r n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHib e r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernate S t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.ja v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Requ e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversio n F ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
------------------------------------------------------------------- - - --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTom c a t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < [email protected] > wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTo m c at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected] > wrote:
> You didn't tell us if this wiki will be in production (ie, > available to many users, requiring to be up most of the time, > with proper backup
> of data, etc...) or if it's only a test wiki for you, for example. > If it's only for tests, the standalone wiki with jetty + hsqldb > is good enough, for production jetty is not recommended by xwiki > I believe. > I can only give you a personal feedback : I have a wiki (in > production) with Tomcat 6 + MySql 5.1, with db attachments. The > wiki has around 15000 pages now, and 1,6Go of attachments content > in db (including all versions of course). I plan to move to > filesystem attachments, because during the course and upgrades > (this wiki started
> several years ago with version 0.9), some attachments got > corrupted
> for any reason, and it might be easier to avoid/detect/repair > with filesystem based attachments than db. > Apart from that, it works pretty well. > > I don't think servlet container will have a big impact on the way > big
> attachments are managed, apart from possible limitations specific > to each container if they exist. The link I provided gives you > what
> is supported by xwiki, and with what it has been tested, but we > can't decide for you what container or rdbms to choose in the end > :-) > > BR, > Jeremie > > > 2013/3/20 Hirji Patel < [email protected] > > >> Thanks, >> >> Which Servlet Container should I be using? >> >> My DB will have large attachments and images. >> >> Regards, >> H >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] >> On Behalf Of Eugen Colesnicov >> Sent: 20 March 2013 13:46 >> To: [email protected] >> Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki >> >> Recommendations about DB & Container depend on Your scenario of >> XWiki using ... For example, if you will have many and large >> attachments - need to switch XWiki to "file-system attachments >> storage" or to use another database (not MySQL) - this is my opinion. >> >> My experience with big attachments - from the begging I have >> Windows
>> + Glassfish + Oracle (attachments stored in DB), after I >> + migrated >> for Linux + MySQL + Tomcat, but with file-system attachments >> storage
>> - and right now I prefer this variant - more speed and "lightness" ... >> >> But, in any case, Your selection is not bad variant for >> production
>> using (for example comparative to other java servlets). Also you >> should understand, that XWiki - it is not a BIG-BIG system, for >> example, likes MS SharePoint. Same results & more speed you can >> get
>> with more simple hardware & software... >> >> -- >> Best regards >> Eugen Colesnicov >>
-- Sergiu Dumitriu http://purl.org/net/sergiu _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
All working now, top man. Thanks for your help. Hirji -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Marius Dumitru Florea Sent: 28 March 2013 18:03 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki On Thu, Mar 28, 2013 at 7:35 PM, Hirji Patel <[email protected]> wrote:
Here is the Hibernate,cfg.xml file.
<?xml version="1.0" encoding="UTF-8"?>
<!-- * See the NOTICE file distributed with this work for additional * information regarding copyright ownership. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. -->
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory>
<!-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -->
<!-- Generic parameters common to all Databases -->
<property name="show_sql">false</property> <property name="use_outer_join">true</property>
<property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property>
<!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. --> <property name="jdbc.use_scrollable_resultset">false</property>
<!-- DBCP Connection Pooling configuration
Comment opened but never closed.
<property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionPro vider</property>
<!-- Setting dbcp.ps.maxActive configuration tells DBCP whether to cache Prepared Statement or not.
Note 1: When using HSQLDB for example, it's important to NOT cache prepared statements because HSQLDB Prepared Statements (PS) contain the schema on which they were initially created and thus when switching schema if the same PS is reused it'll execute on the wrong schema! Since HSQLDB does internally cache prepared statement there's no performance loss. see http://jira.xwiki.org/browse/XWIKI-1740. Thus we recommend not turning on this configuration for HSQLDB unless you know what you're doing :)
Note 2: The same applies to PostGreSQL. -->
<!-- BoneCP Connection Pooling configuration. <property name="bonecp.idleMaxAgeInMinutes">240</property> <property name="bonecp.idleConnectionTestPeriodInMinutes">60</property> <property name="bonecp.partitionCount">3</property> <property name="bonecp.acquireIncrement">10</property> <property name="bonecp.maxConnectionsPerPartition">60</property> <property name="bonecp.minConnectionsPerPartition">20</property> <property name="bonecp.statementsCacheSize">50</property> <property name="bonecp.releaseHelperThreads">3</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> -->
<!-- Configuration for the default database.
Comment opened but never closed.
Comment out this section and uncomment other sections below if you want to use another database. Note that the database tables will be created automatically if they don't already exist.
<property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/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> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
<!-- MySQL configuration. Uncomment if you want to use MySQL and comment out other database configurations. --> <property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
-->
Badly closed comment. No matching open comment. Hope this helps, Marius
<!-- HSQLDB configuration. Uncomment if you want to use HSQLDB and comment out other database configurations. <property name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;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> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
<!-- PostgreSQL configuration. Uncomment if you want to use PostgreSQL and comment out other database configurations. Notes: - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 - "xwiki.virtual_mode" can be set to either "schema" or "database". Note that currently the database mode doesn't support database creation (see http://jira.xwiki.org/browse/XWIKI-8753)
<property name="connection.url">jdbc:postgresql:xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="xwiki.virtual_mode">schema</property> <mapping resource="xwiki.postgresql.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
<!-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Notes: - the 2 properties named "connection.SetBigStringTryClob" and "jdbc.batch_size". They are required to tell Oracle to allow CLOBs larger than 32K. - "jdbc.use_streams_for_binary" needs to be set to "false", see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.SetBigStringTryClob">true</property> <property name="jdbc.batch_size">0</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
<!-- Derby configuration. Uncomment if you want to use Derby and comment out other database configurations. <property name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> <property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> <property name="dialect">org.hibernate.dialect.DerbyDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.derby.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> -->
</session-factory> </hibernate-configuration>
Thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: 28 March 2013 17:33 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
On 03/28/2013 12:50 PM, Hirji Patel wrote:
I have made that change and still no joy.
Same error... about Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Is my hibernate.cfg.xml configured correctly?
If it's a parsing error, then something is syntactically wrong in the file. Look for a stray <!-- or --> in it. Can you pastebin the whole contents of the file?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dmitry Bakbardin Sent: 28 March 2013 16:43 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hi, Hirji!
There is a parameter xwiki.db in xwiki.cfg. You used non-standard (xwiki) DB name, so you need to tell XWiki to use it: xwiki.db=xwiki_db
Restart XWiki. Most probably should work
Четверг, 28 марта 2013, 16:28 UTC от "Hirji Patel" <[email protected]>:
Hello,
I'm still finding it difficult to get my xwiki working, can anyone help me.
I have installed MySQL, created DB using command "Create Database xwiki_db;" Installed Tomcat, home directory " C:\Program Files\Tomcat_Home" Copyied Xwiki*.war files in to "C:\Program Files\Tomcat_Home\webapps\Xwiki" Copied "mysql-connector-java-5.1.24-bin.jar" to Lib folders
I have configured the hibernate.cfg.xml but it does not work keep getting error:
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/xwiki_db?useServerPrepS t mt s =false&useUnicode=true&characterEncoding=UTF-8</property> <property name="connection.username">admin1</property> <property name="connection.password">admin1</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>
Not sure what im doing wrong, can someone help me configure xml file.
Many thanks, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Libbrecht Sent: 22 March 2013 14:45 To: XWiki Users Subject: Re: [xwiki-users] Tomcat + MySQL + Xwiki
Hirji,
please also look in your log (by default in Tomcat, conf/catalina.out) to see the detailed error report about the hibernate file. The "web-facing" error you report does not provide a line number, for example, if the error can be attributed to a line (e.g. a wrong tag closing).
paul
On 22 mars 2013, at 14:41, Sorin Burjan wrote:
org.hibernate. HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
Seems you had an invalid configuration of hibernate file. It can't be properly parsed. Also make sure you put the MySQL JDBC driver in /lib folder from XWiki
Sorin B.
On Fri, Mar 22, 2013 at 3:01 PM, Hirji Patel < [email protected]
wrote:
Hi,
After installing TomCat7 + Mysql. Created blank DB in mysql. Configured hibernate.cfg.xml
But now I get error below. Not sure what I'm doing wrong. Xml file attached.
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
------------------------------------------------------------------ - - - --- --------
type Exception report
message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
description The server encountered an internal error that prevented it from fulfilling this request.
exception
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 [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.apache.struts.action.RequestProcessor.processException(Request P r o ces sor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(Req u e s tPr ocessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi o n F ilt er.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)
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:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:418) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Req u e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi o n F ilt er.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)
root cause
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.TagClass] Wrapped Exception: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernat e S t ore .java:876)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.j a v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Req u e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi o n F ilt er.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)
root cause
org.hibernate.HibernateException: Could not parse configuration: /WEB-INF/hibernate.cfg.xml
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:224 6 )
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.con f i g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHib e r n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHi b e r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernat e S t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.j a v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Req u e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi o n F ilt er.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)
root cause
org.dom4j.DocumentException: Error on line 47 of document : A DOCTYPE is not allowed in content. Nested exception: A DOCTYPE is not
allowed in content. org.dom4j.io.SAXReader.read(SAXReader.java:482)
org.hibernate.cfg.Configuration.doConfigure(Configuration.java:223 8 )
org.hibernate.cfg.Configuration.configure(Configuration.java:2158)
com.xpn.xwiki.store.hibernate.DefaultHibernateSessionFactory$1.con f i g ure (DefaultHibernateSessionFactory.java:105)
com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHib e r n ate BaseStore.java:211)
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHi b e r nat eBaseStore.java:607)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernat e S t ore .java:749)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.j a v a :29 0) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1429) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1472) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:828) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:798) com.xpn.xwiki.XWiki.<init>(XWiki.java:739) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
org.apache.struts.action.RequestProcessor.processActionPerform(Req u e s tPr ocessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1 1 9 6)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(Conversi o n F ilt er.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)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs.
------------------------------------------------------------------ - - - --- --------
Apache Tomcat/7.0.37
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Mortagne Sent: 20 March 2013 17:21 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWA R
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTo m c a t is just one step
On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel < [email protected] > wrote:
Hi,
Just installed Tomcat + Xwiki using link below, but it does not tell
me to install MySQL? Its telling me to install Nginx, should I be doing this?
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationT o m c at #H InstallationSteps
This is what I have done so far...
Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file)
What's Next.. to get my xwiki going? Install Mysql?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here.
Xwiki will be in production with large files.
15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL?
Regards, Hirji
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hi,
At the moment the safest way to go is Tomcat + MySQL. If you go with
Tomcat, make sure you set it to use UTF8 encoding, since the default
configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory.
Regards, Sorin B.
On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET < [email protected] > wrote:
> You didn't tell us if this wiki will be in production (ie, > available to many users, requiring to be up most of the time, > with proper backup
> of data, etc...) or if it's only a test wiki for you, for example. > If it's only for tests, the standalone wiki with jetty + hsqldb > is good enough, for production jetty is not recommended by xwiki > I believe. > I can only give you a personal feedback : I have a wiki (in > production) with Tomcat 6 + MySql 5.1, with db attachments. The > wiki has around 15000 pages now, and 1,6Go of attachments > content in db (including all versions of course). I plan to move > to filesystem attachments, because during the course and > upgrades (this wiki started
> several years ago with version 0.9), some attachments got > corrupted
> for any reason, and it might be easier to avoid/detect/repair > with filesystem based attachments than db. > Apart from that, it works pretty well. > > I don't think servlet container will have a big impact on the > way big
> attachments are managed, apart from possible limitations > specific to each container if they exist. The link I provided > gives you what
> is supported by xwiki, and with what it has been tested, but we > can't decide for you what container or rdbms to choose in the > end > :-) > > BR, > Jeremie > > > 2013/3/20 Hirji Patel < [email protected] > > >> Thanks, >> >> Which Servlet Container should I be using? >> >> My DB will have large attachments and images. >> >> Regards, >> H >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] >> On Behalf Of Eugen Colesnicov >> Sent: 20 March 2013 13:46 >> To: [email protected] >> Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki >> >> Recommendations about DB & Container depend on Your scenario of >> XWiki using ... For example, if you will have many and large >> attachments - need to switch XWiki to "file-system attachments >> storage" or to use another database (not MySQL) - this is my opinion. >> >> My experience with big attachments - from the begging I have >> Windows
>> + Glassfish + Oracle (attachments stored in DB), after I >> + migrated >> for Linux + MySQL + Tomcat, but with file-system attachments >> storage
>> - and right now I prefer this variant - more speed and "lightness" ... >> >> But, in any case, Your selection is not bad variant for >> production
>> using (for example comparative to other java servlets). Also >> you should understand, that XWiki - it is not a BIG-BIG system, >> for example, likes MS SharePoint. Same results & more speed you >> can get
>> with more simple hardware & software... >> >> -- >> Best regards >> Eugen Colesnicov >>
-- Sergiu Dumitriu http://purl.org/net/sergiu _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __
______________________________________________________________________ __ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ______________________________________________________________________ __ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
participants (10)
-
Dmitry Bakbardin -
Eugen Colesnicov -
Hirji Patel -
Hirji.patel
-
Jeremie BOUSQUET -
Marius Dumitru Florea -
Paul Libbrecht -
Sergiu Dumitriu -
Sorin Burjan -
Thomas Mortagne