Currently writing special pages to extend functionality of MediaWiki,
but considering using XWiki instead.
Experimenting with XWiki Enterprise by attempting install of xwiki-
enterprise-web-1.9.3.war:
In Apache Tomcat 5.5.23
Using PostgreSQL 8.4.0 -- Succeeds
Or HSQLDB 1.8.0.7 -- Succeeds
But MySQL 5.0.45 -- Fails.
MySQL is required for XWiki Enterprise Manger, so I need to use MySQL.
I get this error in the browser:
javax.servlet.ServletException: Error number 3 in 0: Could not
initialize main XWiki context Wrapped Exception: Error number 3001 in
3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager
from param xwiki.store.migration.manager.class Wrapped Exception:
Error number 0 in 3: Exception while hibernate execute Wrapped
Exception: Could not create a DBCP pool. There is an error in the
hibernate configuration file, please review it.
I get this additionally in catalina.out:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
I have installed mysql-connector-java-5.0.8-bin.jar in /var/lib/
tomcat5/webapps/xwiki/WEB-INF/lib.
I have modified /var/lib/tomcat5/webapps/xwiki/WEB-
INF.hibernate.cfg.xml as follows:
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other
database configurations.
Note that the database will be created automatically if it
doesn't already exist.
We need to set the sql_mode to a less strict value, see
XWIKI-1945
-->
<property name="connection.url">jdbc:mysql://localhost/xwiki?
useServerPrepStmts=false&useUnicode=true&\
characterEncoding=UTF-8&sessionVariables=sql_mode=''</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">PASSWORD</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</
property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</
property>
<property
name
=
"connection
.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
I created an xwiki database and granted privileges in MySQL as follows:
$ mysql -u root -p
mysql> create database xwiki;
mysql> grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified
by 'xwiki';
mysql> grant all privileges on xwiki.* to xwiki@localhost identified
by 'xwiki';
OR
mysql> create database xwiki;
mysql> grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified
by 'SAMEASROOT';
mysql> grant all privileges on xwiki.* to xwiki@localhost identified
by 'SAMEASROOT';
Note that PASSWORD in the hibernate.cfg.xml file was set to either
'xwiki', or to the same password as for the root MySQL user, with the
thought that perhaps the Hibernate configuration assumed an empty root
MySQL user password, and that, somehow, this might help.
I then modified /var/lib/tomcat5/webapps/xwiki/WEB-
INF.hibernate.cfg.xml as follows, since this is what the installation
instructions actually show, that is, omitting some MySQL parameters:
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other
database configurations.
Note that the database will be created automatically if it
doesn't already exist.
We need to set the sql_mode to a less strict value, see
XWIKI-1945
-->
<property name="connection.url">jdbc:mysql://localhost/xwiki</
property>
<property name="connection.username">xwiki</property>
<property name="connection.password">PASSWORD</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</
property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</
property>
<property
name
=
"connection
.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
I have tried many permutations and scoured installation instructions,
FAQ, and archives. I definitely need some help here.
>If your attachment is an image, it's most probably a browser cache issue.
>Can you try force-refreshing your browser (ctrl-shift-R) in Firefox and see
>what happens?
My document is not an image but it was a browser cache issue.
Thank you for the help
Hello,
1. I am wondering if any users running XWiki on Tomcat 5.5 have set up a SecurityManager policy. The documentation isn't really clear on this, other than "it's an issue" that may not be resolved. The one "comment" on XWiki.org that has a security policy is close but not quite clear. I couldn't figure out the part about Log4J.
- is a policy necessary?
- without one, are there any inherent security risks using XWiki/Tomcat "out of the box"?
- what about Tomcat's default "users" and "roles"?
2. Are there any security risks using the default "xwiki" installation location in webapps? ie. if it's there and someone realizes you're running XWiki, couldn't they then direct their attacks specifically at MySQL / Tomcat / XWiki, looking for holes? I tried installing the WAR to a different location, and failed miserably. Does it matter?
3. Is anyone using XWiki over SSL? Anything special we need to do for that, other than getting a certificate?
As you can tell, I'm not familiar with Tomcat and not a security guru. I'm just the one who has to make sure our setup "out of the box" is secure against exploits.
We're running on Ubuntu, with MySQL. Yes, the server will be behind a firewall, and the MySQL passwords have been changed.
I think what would help in the online documentation is a "security checklist" that rounds up all the various bits that I found on various pages.
Thanks,
Trevor
Hi,
On Mar 6, 2009, at 11:02 AM, Helmut Lehner wrote:
> Hi Vincent
>
>> I don't know if there's much we can do here since the tinymce-based
>> wysiwyg will have saved the content of the page in HTML in your case
>> and the converter cannot distinguish this from someone typing HTML in
>> the page.
>
> I get this code editing a page in WYSIWYG-Mode with Syntax 1.0 and
> only the headings are html. The rest is wiki syntax. This behavior
> started somwhere around Version 1.5 i think. before headings were
> created correctly in wiki syntax (as the rest).
>
>
>> If you have an idea of how to do it let us know. For me you'll need
>> to
>> correct the 1.0 content for your pages that have this problem.
>
> I know how to correct this i just wanted to mention that this could
> be a problem not only for me but for every user who creates pages in
> syntax 1.0 in WYSIWYG and converts them to syntax 2.0 afterwards.
Yes it's a problem. One thing that can be done is to write/provide a
small velocity/groovy script that scans all wiki pages and replaces
the heading with the wiki syntax.
> The best thing would be to make the tiny mce editor create headings
> again in wiki syntax:)
That will not solve the problem for all page contents which have now
HTML for headings.
> The next best thing would be to convert html headings like the ones
> created (without class, or style information) to headings in xwiki
> syntax 2.0 because i think there are fewer headings created
> intentionally in html with that code than by accident through that
> editor bug.
I think I'd prefer the script solution since otherwise that'll make
the converter heavier and with some hacks.
WDYT?
Thanks
-Vincent
Dear all,
I encounter the following problem.
I have a link to an attachement using the 2.0 syntax :
[[document>>attach:docAdmin.doc]]
But when I add a new version to the attachement, the link permits to
download he previous version.
It is the same problem inside the attachment panel, it displays version 1.2
but give access to the 1.1 version.
I can only download my new 1.2 version using the history view of the
attachment.
I use XWiki Enterprise 1.9.2. Is there a bug for this case ? Could you
reproduce it ?
Regards,
Maxime
I found it, the Administration button at the right top corner was not
obvious this time :-O I have installed previous versions of xwiki and it
was obvious to me. Nothing has changed but I didn't see it. Maybe it
should change color (RED/BOLD) for some blind people like me.
I had the same problem with my first attempts of XWiki installation. As a
trial I used the xwiki user in oracle and it worked. For my installations I
have to always use xwiki oracle user in order to get passed this point. Can
you try it
hi all
anyone have u success integrate liferay with xwiki?
liferay have their own wiki, but i believe xwiki more mroe advanced in feature
i want to make both tech use one LDAP server
--
Frans Thamura
Meruvian.
Center of Java and Enterprise OpenSource
Meruvian bukan hanya membuat anak SMK menjadi bisa tapi SAKTI, malah
saktinya SAKTI Mandraguna.
Mobile: +62 855 7888 699
Blog & Profile: http://frans.thamura.info
We provide services to migrate your apps to Java (web), in amazing
fast and reliable.
Hi,
i was just wondering how embedded documents work. The Syntax Help gives no
example.
I don't know but is it just the include macro?
Thanks
hel.
-----
semantic-web.hel.at
hel(a)hel.at
--
View this message in context: http://n2.nabble.com/Embedded-documents-tp3423459p3423459.html
Sent from the XWiki- Users mailing list archive at Nabble.com.