topic Re: [Alfresco 3c] Mediawiki Amp in Alfresco Archive

[Alfresco 3c] Mediawiki Amp

rbergstrom — Mon, 22 Dec 2008 19:46:05 GMT

Hello:The Mediawiki integration amp was listed as part of release 3c, but I can't locate the amp in any of the released packages. Any pointers as to where I can find it?Thanks,// rbergstrom

Re: [Alfresco 3c] Mediawiki Amp

siquser — Tue, 23 Dec 2008 07:14:29 GMT

I was also searching for it since couple of days and I could not able to find it. We contacted Alfresco team for the same.

Re: [Alfresco 3c] Mediawiki Amp

dberansky — Tue, 23 Dec 2008 19:15:22 GMT

have you gotten any answers?

Re: [Alfresco 3c] Mediawiki Amp

siquser — Tue, 23 Dec 2008 19:29:55 GMT

I found a dev nightly build version of Mediawiki integration AMP file and I will posts the link with in 15 minutes.

Re: [Alfresco 3c] Mediawiki Amp

siquser — Tue, 23 Dec 2008 20:44:31 GMT

I was searching for Mediawiki amp file on forums and somebody listed out dev nightly build URL for PHP integration amp file. I also found a nightly build version of MediawikiInetgration amp file there

http://dev.alfresco.com/downloads/nightly/dist/

Note: I don’t know the stability of this but I will integrate this and let you know the status.

Re: [Alfresco 3c] Mediawiki Amp

rbergstrom — Mon, 29 Dec 2008 15:44:26 GMT

I too found the nightly build version, however I am getting database connection error after you get past the login page. I am not sure if this is a compatibility issue or not, however alfresco is working just fine.

// RAB

Re: [Alfresco 3c] Mediawiki Amp

siquser — Mon, 29 Dec 2008 17:09:15 GMT

Can you please POST the database error message?

Even we got some DB problem, but I believe we ended up using MySQL Database Password as NULL (nothing) and it worked after that…

Re: [Alfresco 3c] Mediawiki Amp

rbergstrom — Mon, 29 Dec 2008 19:38:01 GMT

Here is the error:


/var/lib/tomcat-6/webapps/alfresco/php/wiki/includes/Database.php:540: Warning: A link to the server could not be established. url=jdbc:mysql://localhost:3306/ driver=com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. [mysql_errno]
‍‍‍

Now, I noticed that the URL is wrong, but even changing the LocalSettings.php in the Mediawiki PHP code doesn't seem to help. Further down the page:


(Can't contact the database server: Unknown error (10.XX.XX.XX))
‍‍‍

The IP address is the IP address of our database server, so some configuration is coming through.

Re: [Alfresco 3c] Mediawiki Amp

rbergstrom — Mon, 29 Dec 2008 19:53:24 GMT

This is the nagging question: Given the alfresco extension is going through an external API, why is MediaWiki going at the database at all? Do I have something else setup wrong?

// RAB

Re: [Alfresco 3c] Mediawiki Amp

siquser — Mon, 29 Dec 2008 19:58:47 GMT

Alfresco and Mediawiki uses the same Alfresco repository (for example My SQL DB - Alfresco). Look at the installation steps once again. Alll you need is Alfresco, PHP Integration and Mediawiki Integration amp files. Do not install Mediawiki standard version (also don't need install PHP full version). Basically, AMP files do the magic work for you.

Re: [Alfresco 3c] Mediawiki Amp

rbergstrom — Mon, 29 Dec 2008 20:04:52 GMT

Alfresco and Mediawiki uses the same Alfresco repository (for example My SQL DB - Alfresco). Look at the installation steps once again. Alll you need is Alfresco, PHP Integration and Mediawiki Integration amp files. Do not install Mediawiki standard version (also don't need install PHP full version). Basically, AMP files do the magic work for you.

That's exactly what I have done. I am not using the standard version of Mediawiki. Anyone else using the Mediawiki piece with a remote mySQL installation?

Re: [Alfresco 3c] Mediawiki Amp

siquser — Mon, 29 Dec 2008 20:09:17 GMT

I've not tried remote SQL, i.e. I put MY SQL also on the same box. I'm not sure whether yours is on Unix/Linux server but mine is windows 2003 server.

Re: [Alfresco 3c] Mediawiki Amp

rbergstrom — Mon, 29 Dec 2008 20:29:23 GMT

It seems that the mediawiki integration does not like remote database servers. I created a mySQL instance on the local machine and everything works perfectly. This is fine for the short term. However, longer term however I would like to use the remote database infrastructure.

I have tried modifying LocalSettings.php with my server ip, database name, hostname, and password, but it doesn't seem to take. I'll dig into this and post any solution, but I would welcome any insight.

// RAB

Re: [Alfresco 3c] Mediawiki Amp

siquser — Mon, 29 Dec 2008 21:54:57 GMT

In my opinion MySQL DB on REMOTE Server should not be an problem (but you never know).
I presume your servers (Alfresco Server & My SQL DB Server) are on Same Domain, if not, then that could an issue too.

My 2 cents…

Re: [Alfresco 3c] Mediawiki Amp

vipo — Mon, 12 Jan 2009 00:35:47 GMT

I've tried using the nightly build (org.alfresco.module.mediawikiintegration.amp, from 02-Jan-2009, 3d-dev), because the AMP is missing from 3c distribution.
After getting PHP-Server work fine and MMT-instaling MediaWiki-AMP, i have to clean tomcat manually (removing alfresco-directory in tomcat/webapps, because tomcat didn't a clean deploy).
Note: i really should have used "apply_amps.sh" instead of manually installing this 😉
After a restart the MediaWiki-module startet (from catalina.out log)

Userystem INFO [repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.mediawikiintegration' version 1.1.

I then tried to edit the file /php/wiki/LocalSettings.php (in the expanded WAR alfresco directory) to setup my remote MySQL-connection informations (setting some $wgDB* variables) and did a clean restart. Then added a WikiAdministrator-User in the Wiki-workspace (to give access).

I 've checked the MySQL-Db:
Alfresco did create tables named 'mediawiki_<space-id>_*, so the connection to MySQL obviously did work out (as expected).

Also i can see the login-form, after login a got this error:
—
com.caucho.quercus.QuercusException: org.alfresco.module.mediawikiintegration.MediaWikiSpace.validate: org.alfresco.repo.security.authentication.AuthenticationUtil.pushAuthentication()V

java.lang.NoSuchMethodError: org.alfresco.repo.security.authentication.AuthenticationUtil.pushAuthentication()V
—

So (probably) the nightly build version (3d) uses methods (pushAuthentication), which are not implemented in the alfresco.jars from 3c.

So i was not able to use MediaWiki 😞

Can anybody give a hint to a MediWiki.amp (version 1.0?) usable with 3c?

Re: [Alfresco 3c] Mediawiki Amp

vipo — Mon, 12 Jan 2009 00:52:30 GMT

I only could find the actual source on the web (Subversion/HEAD):

https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/source/java/org/alfresco/repo/security/authentication/AuthenticationUtil.java

there (Alfresco 3d-dev) the missing function is implemented.

Under

http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/modules/mediawiki-integration/source/java/org/alfresco/module/mediawikiintegration/MediaWikiSpace.java

the new MediaWiki-Integration source code can be found.

Has anyone a buildenvironment ready, which can create the MediaWiki-AMP file needed to work with 3c (not using the 3d-dev head, but the previous version)?