WordnetLoom

Wordnet Visual Editor This branch contains only Princeton Wordent 3.1 and Dannet

Installation

Application requirement's

• Linux OS
• installed java 8 jre
• installed Maven 3+
• installed MySql 5.7+
• installed Wildfly 10.1.0+ (add necessary DB Drivers in this case MySql )

Files

Load dannet.sql file to mysql mysql -u xxx -p dannet < dannet.sql

Unzip and copy files from files folder to /opt on your linux machine

Wildfly configuration

Add line JAVA_OPTS="$JAVA_OPTS -Djboss.as.management.blocking.timeout=3600" to standalone.conf file in you server bin directory required at initial import

Security config

<security-realm name="ApplicationRealm">
	<server-identities>
		<ssl>
	                <keystore path="application.keystore" relative-to="jboss.server.config.dir" keystore-password="password" alias="server" key-password="password" generate-self-signed-certificate-host="localhost"/>
                </ssl>
	</server-identities>
        <authentication>
                <jaas name="wordnetloom"/>
        </authentication>
</security-realm>

<security-domain name="wordnetloom" cache-type="default">
	<authentication>
	        <login-module code="Database" flag="required">
	                <module-option name="dsJndiName" value="java:/datasources/wordnet"/>
                        <module-option name="principalsQuery" value="SELECT password FROM users WHERE email=?"/>
                        <module-option name="rolesQuery" value="SELECT u.role, 'Roles' FROM users u WHERE u.email=?"/>
                        <module-option name="password-stacking" value="useFirstPass"/>
                        <module-option name="hashAlgorithm" value="SHA-256"/>
                        <module-option name="hashEncoding" value="base64"/>
                </login-module>
	</authentication>
</security-domain>

Database config

<datasource jta="true" jndi-name="java:/datasources/wordnet" pool-name="WordnetDS" enabled="true" use-ccm="true">
	<connection-url>jdbc:mysql://localhost:3306/wordnet</connection-url>
	        <driver-class>com.mysql.jdbc.Driver</driver-class>
                <connection-property name="useUnicode">
                        true
                </connection-property>
                <connection-property name="characterEncoding">
                        UTF-8
                </connection-property>
                <connection-property name="useSSL">
                        false
                </connection-property>
                <driver>mysql</driver>
                <security>
                        <user-name>XXXXXXX</user-name>
                        <password>XXXXXXXX</password>
                </security>
                <validation>
                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
                        <background-validation>true</background-validation>
                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
                </validation>
</datasource>
<drivers>
	<driver name="mysql" module="com.mysql.driver">
	        <driver-class>com.mysql.jdbc.Driver</driver-class>
        </driver>
</drivers>

Step 1 (preparation phase)

Master branch is prepared to run based on older database version which at first run is transformed to new schema.

1. Download database dump from http://ws.clarin-pl.eu/public/wordnet-work.LATEST.sql.gz
2. Create empty database "wordnet_work"
3. Load dump to "wordnet_work" database

Step 2 (Compilation & Deployment)

1. git clone https://github.com/CLARIN-PL/WordnetLoom.git
2. mvn clean install
3. deploy wordnetloom-server.ear to wildfly

Step 3 (Client Application)

1. to run client go to ..\wordnetloom-client\target java -jar wordnetloom-client.jar
2. e.g. login user:admin@gmail.com password:password