LiferayGUSEInstallation < IGIPortal

You are here: TWiki>
IGIPortal Web>AdministrationGuide>LiferayGUSEInstallation (2012-07-13, DiegoMichelotto) (raw view)
<noautolink>

---+!! A guide for Liferay and gUSE installation 

%TOC%

---# Prerequisites

Before preceding the installation, make sure that all the following hardware and software requirements are met :

   * Hardware  
      * 2 GB memory
      * x86 CPU (minimum 2.4 GHz, depends on usage)
      * minimum 1GB (portal installation) and additional 20-100 GB HDD for user data
   * Software 
      * Linux -Scientific or other (Ubuntu,...)
      * J2SE 6.x
      * Apache Tomcat 6.x (6.0.26, 6.0.29 tested...)
      * mysql (5.1.41 tested) remote or local installed
      * Liferay 6.0.5 (Bundled with Tomcat works)
      * gLite User Interface installation (if necessary see our installation guide [[https://wiki.italiangrid.it/twiki/bin/view/IGIRelease/IgiGlite][here]]) - this isn't necessary when installing without EGEE support (optional) + SC Linux

---# Install MySQL server and client

Use the packet manager for install rpms, start MySQL server and set the root password for MySQL:

<verbatim>
 $ yum install mysql mysql-server
 $ service mysqld start
 $ mysqladmin -h fullyqualified.hostname -u root password NEWPASSWORD
</verbatim>

---## Portal databases

Create empty liferay, wspgrade and portaluser databases.

<verbatim>
 $ mysql -h fullyqualified.hostname -u root -pNEWPASSWORD
 > create database liferay;
 > create database wspgrade;
 > create database PortalUser;
</verbatim>

---## MySQL users and permissions

Create liferay, wspgrade and portaluser users and set privileges for each users on databases.

<verbatim>
 $ mysql -h fullyqualified.hostname -u root -pNEWPASSWORD
 > create user liferay identified by 'liferaysecret';	
 > create user wspgrade identified by 'wspgradesecret';	
 > create user PortalUser identified by 'PortalUsersecret';
 > grant all on liferay.* to 'liferay'@'localhost' identified by 'liferaysecret';
 > grant all on wspgrade.* to 'wspgrade'@'localhost' identified by 'wspgradesecret';
 > grant all on PortalUser.* to 'PortalUser'@'localhost' identified by 'PortalUsersecret';	
 > grant all on liferay.* to 'liferay'@'fullyqualified.hostname' identified by 'liferaysecret';
 > grant all on wspgrade.* to 'wspgrade'@'fullyqualified.hostname' identified by 'wspgradesecret';
 > grant all on PortalUser.* to 'PortalUser'@'fullyqualified.hostname' identified by 'PortalUsersecret';
</verbatim>

---# Install Liferay

First download the Liferay 6.0.5 package bundle with Tomcat from the URL: http://sourceforge.net/projects/lportal/files/Liferay%20Portal/6.0.5/liferay-portal-tomcat-6.0.5.zip/download .

Now unzip the archive in the =/opt= folder.

---## Edit/Create Liferay properties

Edit the file called =portal-ext.properties=. If it does not exists, please create a file with this name in the '''tomcat's root folder''', if exists please move it to '''tomcat's root folder'''.

gUSE requires the following settings:

   * jdbc.default.driverClassName = JDBC driver implementation
   * jdbc.default.url = JDBC URL
   * jdbc.default.username = user name to the database
   * jdbc.default.password = user's password to the database
   * jdbc.default.maxIdleTime = connections timeout
For example:
<verbatim>
  jdbc.default.driverClassName=com.mysql.jdbc.Driver
  jdbc.default.url=jdbc:mysql://fullyqualified.hostname:3306/liferay?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
  jdbc.default.username=liferay
  jdbc.default.password=liferaysecret
  jdbc.default.maxIdleTime=3600
</verbatim>

---# gUSE installation and configuration

Download gUSE from http://sourceforge.net/projects/guse/files/latest/download?_test=goal and extract the content of the archive in your home folder.

---## gUSE database

Creating database tables for gUSE.

<verbatim>
 $ mysql -h fullyqualified.hostname -u wspgrade -pwspgradesecret wspgrade < guse_tables.sql
 $ mysql -h fullyqualified.hostname -u wspgrade -pwspgradesecret wspgrade < guse_table_mess.sql
 $ mysql -h fullyqualified.hostname -u wspgrade -pwspgradesecret wspgrade < guse_tables_index.sql
</verbatim>

---## Parameterizing runtime environment

In the shell which starts the webcontainer the following environment variables must be set:
<verbatim>
 $ export JAVA_OPTS="-server -Xms256m -Xmx1024m -XX:MaxPermSize=512m -Dfile.encoding=UTF8 -Duser.timezone=GMT"
</verbatim>

Where :

   * -server : JVM has to be run in server mode
   * -Xms : initial heap size
   * -Xmx : maximum heap size
   * -XX:MaxPermSize=128m : memory to store long term object instances
   * -Dfile.encoding=UTF8 : file encoding
   * -Duser.timezone=GMT" : timezone
*Very important*:
   * the setting will be effective after reboot
   * make sure that there is always as much available memory as it had been specified in the settings
   * for configuration with high load, Xmx can be increased up to 64 GB
   * the size of XX:MaxPermSize can be configured to be higher for development (TomCat bug)

<verbatim>
 $ export X509_USER_PROXY=x509up
</verbatim>

If it is not set, voms extension cannot be set for the proxy
<verbatim>
 $ export CATALINA_OPTS="-DcrlUpdateInterval=0s -DcrlEnabled=false -Dorg.globus.tcp.port.range=20000,25000 "
</verbatim>

Where:

   * -DcrlUpdateInterval :
   * -DcrlEnabled :
   * -Dorg.globus.tcp.port.range :Needed to run GT2/GT4, if not set, jobs will stay in PENDING status

In the file  =/opt/liferay-portal-6.0.5/tomcat-6.0.26/bin/setenv.sh= you cancel all the content and replace with =JAVA_OPTS="$JAVA_OPTS"=.

---## Copying additional jar files to shared libs directory

Copy the following jar files from libs folder to the servers shared libs' directory ( =/opt/liferay-portal-6.0.5/tomcat-6.0.26/lib= in tomcat 6.0, =/opt/liferay-portal-6.0.5/tomcat-6.0.26/shared/libs= in version 5.5).

Libraries:
   * cog-jglobus.jar
   * commons-logging-1.1.1.jar
   * cryptix-asn1.jar
   * cryptix32.jar
   * javaee-api-5.0-1.jar
   * jce-jdk13-131.jar
   * mysql-connector-java-5.1.6-bin.jar
   * puretls.jar
   * dsn.jar
   * imap.jar
   * mailapi.jar
   * mail.jar
   * pop3.jar
   * smtp.jar

---## Configuring ws-pgrade installer package

Set "database connection" information of gUSE in =information.war/WEB-INF/classes/META-INF/persistence.xml= and "service urls" in =information.war/WEB-INF/config/service.xml= replace =http://localhost:8080= with =http://fullyqualified.hostname:8080= for all the occurences. 

After you configure the file =init.jsp= with your parameter for faster inizializzation of gUSE.

For do this you must extract the file from the =information.war= file modify the file and recreate the _war_ file. You can do this using for example _Eclipse_: import project from WAR, modify the files and export to WAR. The name of archive must be the same.

---## Deploying the gUSE war files

After starting Liferay with command:

<verbatim>
 $ /opt/liferay-portal-6.0.5/tomcat-6.0.26/bin/startup.sh
</verbatim>

from web browser: http://fullyqualified.hostname:8080 navigate to __Manage/Control Panel/Plugins Installation/Install More Portlets/Upload File__ and upload gUSE web applications (all the war files).

---## Initialising gUSE services

From web browser go to: http://fullyqualified.hostname:8080/information/init.jsp Please note that initialization interface is protected by username and password within tomcat's manager role! To add a tomcat user and manager role, please modify tomcat-users.xml file in =/opt/liferay-portal-6.0.5/tomcat-6.0.26/conf= folder. Check your database settings, if necessary, and hit &ldquo;send&rdquo;.

*It is necessary after every tomcat restart.*

---# Portlet installation and configuration

---## Create tables for PortalUser

Download
   * [[%ATTACHURL%/PortalUser.sql][PortalUser.sql]]: Dump of PortalUser database only structure
   * [[%ATTACHURL%/PortalUser_IDP.sql][PortalUser_IDP.sql]]: Dump of table IDP from PortalUser structure and data
and run:
<verbatim>
 $ mysql -h fullyqualified.hostname -u PortalUser -pPortalUsersecret PortaUser < PortalUser.sql
 $ mysql -h fullyqualified.hostname -u PortalUser -pPortalUsersecret PortaUser < PortalUser_IDP.sql
</verbatim>

---## Deploying the portlets war files

Download the portlets:
   * [[%ATTACHURL%/Login-1.1.war][Login-1.1.war]]: Portlet Login
   * [[%ATTACHURL%/Registration-4.war][Registration-4.war]]: Portlet Registration
   * [[%ATTACHURL%/VO-manager-portlet-0.1.war][VO-manager-portlet-0.1.war]]: Portlet VOManager
Now copy the portlets war file in =/opt/liferay-portal-6.0.5/deploy/= folder or install using the LIferay interface by  __Manage/Control Panel/Plugins Installation/Install More Portlets/Upload File__.

Now ou create the folder =/upload_files= and download these files into the folder:
   * [[%ATTACHURL%/get_vo_info.py.txt][get_vo_info.py]]: Python utility for manage the VO table in the PortaUser database.
   * [[%ATTACHURL%/myproxy2.py.txt][myproxy2.py]]: Python utility for upload user's certificate into myproxy server.
   * [[%ATTACHURL%/splitP12.py.txt][splitP12.py]]: Python utility for conversion of user's certificate from p12 format into pem format.

*NOTE:* after download check that the files are properly named.

Now you edit the =get_vo_info.py= with your database connection information.

Now you must install this python library by executing this command:

<verbatim>
 $ yum install pycurl pexpect MySQL-python
</verbatim>

For the proper functioning of registration workflow you must add these line to =portal-ext.properties= at the and of file:

<verbatim>
  auth.login.url=/web/guest/registration
  users.reminder.queries.enabled=false
</verbatim>

For the automatic redirect from http port to https port add these line at the same file:

<verbatim>
  company.security.auth.requires.https=true
  web.server.https.port=443
</verbatim>

And now modify the =$tomcat_home/webapp/ROOT/WEB-INF/web.xml= in this way:

%TWISTY{
mode="div"
showlink="   *web.xml* "
hidelink="     *web.xml* " 
remember="off" firststart="hide"
showimgright="%ICONURLPATH{toggleopen}%"
hideimgright="%ICONURLPATH{toggleclose}%"
}%
<verbatim>
  [...]
  <security-constraint>
		<web-resource-collection>
			<web-resource-name>Entire Application</web-resource-name>
				<url-pattern>/*</url-pattern>
			</web-resource-collection>
			<!--	<web-resource-name>/c/portal/protected</web-resource-name>
			<url-pattern>/c/portal/protected</url-pattern>
			<url-pattern>/ar/c/portal/protected</url-pattern>
			<url-pattern>/ar_SA/c/portal/protected</url-pattern>
			<url-pattern>/bg/c/portal/protected</url-pattern>
			<url-pattern>/bg_BG/c/portal/protected</url-pattern>
			<url-pattern>/ca/c/portal/protected</url-pattern>
			<url-pattern>/ca_AD/c/portal/protected</url-pattern>
			<url-pattern>/ca_ES/c/portal/protected</url-pattern>
			<url-pattern>/cs/c/portal/protected</url-pattern>
			<url-pattern>/cs_CZ/c/portal/protected</url-pattern>
			<url-pattern>/de/c/portal/protected</url-pattern>
			<url-pattern>/de_DE/c/portal/protected</url-pattern>
			<url-pattern>/el/c/portal/protected</url-pattern>
			<url-pattern>/el_GR/c/portal/protected</url-pattern>
			<url-pattern>/en/c/portal/protected</url-pattern>
			<url-pattern>/en_GB/c/portal/protected</url-pattern>
			<url-pattern>/en_US/c/portal/protected</url-pattern>
			<url-pattern>/es/c/portal/protected</url-pattern>
			<url-pattern>/es_ES/c/portal/protected</url-pattern>
			<url-pattern>/et/c/portal/protected</url-pattern>
			<url-pattern>/et_EE/c/portal/protected</url-pattern>
			<url-pattern>/eu/c/portal/protected</url-pattern>
			<url-pattern>/eu_ES/c/portal/protected</url-pattern>
			<url-pattern>/fa/c/portal/protected</url-pattern>
			<url-pattern>/fa_IR/c/portal/protected</url-pattern>
			<url-pattern>/fi/c/portal/protected</url-pattern>
			<url-pattern>/fi_FI/c/portal/protected</url-pattern>
			<url-pattern>/fr/c/portal/protected</url-pattern>
			<url-pattern>/fr_FR/c/portal/protected</url-pattern>
			<url-pattern>/gl/c/portal/protected</url-pattern>
			<url-pattern>/gl_ES/c/portal/protected</url-pattern>
			<url-pattern>/hi/c/portal/protected</url-pattern>
			<url-pattern>/hi_IN/c/portal/protected</url-pattern>
			<url-pattern>/hu/c/portal/protected</url-pattern>
			<url-pattern>/hu_HU/c/portal/protected</url-pattern>
			<url-pattern>/in/c/portal/protected</url-pattern>
			<url-pattern>/in_ID/c/portal/protected</url-pattern>
			<url-pattern>/it/c/portal/protected</url-pattern>
			<url-pattern>/it_IT/c/portal/protected</url-pattern>
			<url-pattern>/iw/c/portal/protected</url-pattern>
			<url-pattern>/iw_IL/c/portal/protected</url-pattern>
			<url-pattern>/ja/c/portal/protected</url-pattern>
			<url-pattern>/ja_JP/c/portal/protected</url-pattern>
			<url-pattern>/ko/c/portal/protected</url-pattern>
			<url-pattern>/ko_KR/c/portal/protected</url-pattern>
			<url-pattern>/nb/c/portal/protected</url-pattern>
			<url-pattern>/nb_NO/c/portal/protected</url-pattern>
			<url-pattern>/nl/c/portal/protected</url-pattern>
			<url-pattern>/nl_NL/c/portal/protected</url-pattern>
			<url-pattern>/pl/c/portal/protected</url-pattern>
			<url-pattern>/pl_PL/c/portal/protected</url-pattern>
			<url-pattern>/pt/c/portal/protected</url-pattern>
			<url-pattern>/pt_BR/c/portal/protected</url-pattern>
			<url-pattern>/pt_PT/c/portal/protected</url-pattern>
			<url-pattern>/ru/c/portal/protected</url-pattern>
			<url-pattern>/ru_RU/c/portal/protected</url-pattern>
			<url-pattern>/sk/c/portal/protected</url-pattern>
			<url-pattern>/sk_SK/c/portal/protected</url-pattern>
			<url-pattern>/sv/c/portal/protected</url-pattern>
			<url-pattern>/sv_SE/c/portal/protected</url-pattern>
			<url-pattern>/tr/c/portal/protected</url-pattern>
			<url-pattern>/tr_TR/c/portal/protected</url-pattern>
			<url-pattern>/uk/c/portal/protected</url-pattern>
			<url-pattern>/uk_UA/c/portal/protected</url-pattern>
			<url-pattern>/vi/c/portal/protected</url-pattern>
			<url-pattern>/vi_VN/c/portal/protected</url-pattern>
			<url-pattern>/zh/c/portal/protected</url-pattern>
			<url-pattern>/zh_CN/c/portal/protected</url-pattern>
			<url-pattern>/zh_TW/c/portal/protected</url-pattern>
			<http-method>GET</http-method>
			<http-method>POST</http-method>
		</web-resource-collection>
		<auth-constraint>
			<role-name>users</role-name>
		</auth-constraint>-->
		<user-data-constraint>
			<transport-guarantee>CONFIDENTIAL</transport-guarantee>
		</user-data-constraint>
	</security-constraint>
  [...]
</verbatim>
%ENDTWISTY%

---# Setting IGIPortal layout

Download [[%ATTACHURL%/igiportal.lar][igiportal.lar]] and navigate to __Manage/Control Panel/Communities/Actions(on a community)/Manage Pages/ExportImport/Import__ and upload it.

Please note that layout is *working with Liferay 6.0.5*, different liferay versions may not compatible with it.

In the _Welcome_ page import in the Web Content portlet this file:  [[%ATTACHURL%/welcome.portlet.lar][welcome.portlet.lar]]

---# Stop and Start IGIPortal.

---## Stopping

For stopping the portal from the root shell of portal-igi launch the command:

<verbatim>
     # stop
</verbatim>

Note: =stop= is a alias of =/opt/liferay-portal-6.1.0/tomcat-7.0.23/bin/shutdown.sh=.

---## Starting

Before starting the portal check if mysqld is runnung:

<verbatim>
     # service mysqld status
</verbatim>

If it isn't start the mysql server:

<verbatim>
     # service mysqld start
</verbatim>

When is done, start the IGIPortal container from the root shell of portal-igi launching:

<verbatim>
     # start
</verbatim>

If into the log you see these lines liferay is started successfully.

<verbatim>
     tail -f /opt/liferay-portal-6.1.0/tomcat-7.0.23/logs/catalina.out 
     13-lug-2012 9.11.48 org.apache.coyote.AbstractProtocol start
     INFO: Starting ProtocolHandler ["http-bio-8080"]
     13-lug-2012 9.11.48 org.apache.coyote.AbstractProtocol start
     INFO: Starting ProtocolHandler ["http-bio-80"]
     13-lug-2012 9.11.48 org.apache.coyote.AbstractProtocol start
     INFO: Starting ProtocolHandler ["http-bio-443"]
     13-lug-2012 9.11.48 org.apache.coyote.AbstractProtocol start
     INFO: Starting ProtocolHandler ["ajp-bio-8009"]
     13-lug-2012 9.11.48 org.apache.catalina.startup.Catalina start
     INFO: Server startup in 122971 ms
</verbatim>

After this operation you must initialize WS-Pgrade.

Note: =start= is a alias of =/opt/liferay-portal-6.1.0/tomcat-7.0.23/bin/startup.sh=.

---## Initialize WS-Pgrade

For initializing the portal is necessary tree steps. 

---### DCI initializzation
The first operation is enabling the DCI-bridge for accepting jobs. For do this go to https://portal.italiangrid.it/dci_bridge_service/conf now navigate to _manager_ tab and select _Accept jobs_ and Save. You see something like this image:

 <img src="%ATTACHURLPATH%/DCI.png" alt="DCI.png" width="1149" height="433" />

---### WS-Pgrade initializzation
The secondo step is initializing WS-Pgrade. For do this go to https://portal.italiangrid.it/information/init.jsp now you see something like this:

<img src="%ATTACHURLPATH%/WSPgrade.png" alt="WSPgrade.png" width="565" height="216" />

The form is precompiled, now press _send_ button.

Into the log of portal if you see these lines all is done:

%TWISTY{
mode="div"
showlink="   *WSPgrade Inizialization logs* "
hidelink="     *WSPgrade Inizialization logs* " 
remember="off" firststart="hide"
showimgright="%ICONURLPATH{toggleopen}%"
hideimgright="%ICONURLPATH{toggleclose}%"
}%
<verbatim>
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	[Ljava.lang.String;@5601a409
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/information/WEB-INF/lib/UI.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@57e6e6d8
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/information/WEB-INF/lib/portal.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@e2a3881
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/information/WEB-INF/lib/resource.wsdd
	<Admin>Done processing</Admin>
	31  informationPU  INFO   [http-bio-443-exec-11] openjpa.Runtime - Starting OpenJPA 1.0.1
	124  informationPU  INFO   [http-bio-443-exec-11] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary".
	717  informationPU  INFO   [http-bio-443-exec-11] openjpa.Enhance - Creating subclass for "[class hu.sztaki.lpds.information.data.GuseServiceTypeBean, class hu.sztaki.lpds.information.data.GuseServiceBean, class hu.sztaki.lpds.information.data.GuseServiceCommunicationBean, class hu.sztaki.lpds.information.data.ServiceUserBean, class hu.sztaki.lpds.information.data.ServicePropertyBean, class hu.sztaki.lpds.information.data.ServiceResourceBean, class hu.sztaki.lpds.information.data.OptionBean]". This means that your application will be less efficient and will consume more memory than it would if you ran the OpenJPA enhancer. Additionally, lazy loading will not be available for one-to-one and many-to-one persistent attributes in types using field access; they will be loaded eagerly instead.
	guse.system.database.driver=com.mysql.jdbc.Driver
	guse.system.database.url=jdbc:mysql://localhost:3306/guse
	guse.system.database.user=guse
	guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/wspgrade========
	http://portal.italiangrid.it:8080/wspgrade:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/wspgrade:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/wspgrade:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/wspgrade:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/wfi========
	http://portal.italiangrid.it:8080/wfi:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/wfi:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/wfi:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/wfi:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/wfs========
	http://portal.italiangrid.it:8080/wfs:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/wfs:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/wfs:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/wfs:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/information========
	http://portal.italiangrid.it:8080/information:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/information:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/information:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/information:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/storage========
	http://portal.italiangrid.it:8080/storage:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/storage:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/storage:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/storage:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/repository========
	http://portal.italiangrid.it:8080/repository:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/repository:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/repository:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/repository:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/information========
	http://portal.italiangrid.it:8080/information:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/information:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/information:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/information:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/dci_bridge_service========
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/dci_bridge_service========
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/dci_bridge_service:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/stataggregator========
	http://portal.italiangrid.it:8080/stataggregator:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/stataggregator:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/stataggregator:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/stataggregator:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/statvisualizer========
	http://portal.italiangrid.it:8080/statvisualizer:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/statvisualizer:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/statvisualizer:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/statvisualizer:guse.system.database.password=gusepass
	=======http://portal.italiangrid.it:8080/ANSYS========
	http://portal.italiangrid.it:8080/ANSYS:guse.system.database.driver=com.mysql.jdbc.Driver
	http://portal.italiangrid.it:8080/ANSYS:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	http://portal.italiangrid.it:8080/ANSYS:guse.system.database.user=guse
	http://portal.italiangrid.it:8080/ANSYS:guse.system.database.password=gusepass
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/wspgrade
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/wspgrade
	SET-PROPERTY:notify.quota.time.in.hour=1
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:notify.smtp.host=localhost
	SET-PROPERTY:repeat.submit.workflow=1
	SET-PROPERTY:gemlcacache.refreshintervall_min=30
	SET-PROPERTY:guse.wspgrade.suportedwfengines=zen
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:wspgrade.maxulpoadfilesize=100
	SET-PROPERTY:guse.logdir=/guselogg
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:cache.time.msec=3000000
	SET-PROPERTY:service.loglevel=6
	SET-PROPERTY:guse.system.database.password=gusepass
	SET-PROPERTY:notify.quota.max.percent=95
	SET-PROPERTY:service.logtrace=false
	[Ljava.lang.String;@6ec45c0e
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wspgrade/WEB-INF/lib/storage.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@374f2c4e
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wspgrade/WEB-INF/lib/submitter.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@62b57ee2
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wspgrade/WEB-INF/lib/remote.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@5b3c2982
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wspgrade/WEB-INF/lib/wfi.wsdd
	<Admin>Done processing</Admin>
	LOGGER ACTIVALVA:http://portal.italiangrid.it:8080/wspgrade

	[Ljava.lang.String;@409ac440
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wfi/WEB-INF/lib/portal.wsdd
	<Admin>Done processing</Admin>
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/wfi
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/wfi
	SET-PROPERTY:tt.wsdl=http://portal.italiangrid.it:8080/management/TesterService?wsdl
	SET-PROPERTY:wfi.zen.loggfile=guselogg/wfi
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:wfi.zen.activeingjobs.max=500000
	SET-PROPERTY:guse.wfi.zen.sendinitstatus=true
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.logdir=/guselogg
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:service.loglevel=6
	SET-PROPERTY:wfi.incomingpoll.sendcount=100
	SET-PROPERTY:guse.system.database.password=gusepass
	SET-PROPERTY:wfi.zen.waiting.getjobcount=60000
	SET-PROPERTY:wfi.incomingpoll.waiting=1000
	SET-PROPERTY:system.id=guse3.4
	LOGGER ACTIVALVA:http://portal.italiangrid.it:8080/wfi
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/wfs
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/wfs
	SET-PROPERTY:guse.wfs.system.saveonlyendstatus=false
	SET-PROPERTY:guse.wfs.wfiplugin.zen=hu.sztaki.lpds.wfs.service.angie.plugins.wfi.ZenImpl
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:guse.wfs.system.savevisualizerdata=true
	SET-PROPERTY:history.max=200
	SET-PROPERTY:guse.wfs.system.savestatus=true
	SET-PROPERTY:noproxy=DesktopGrid,Local,Unibroker
	SET-PROPERTY:guse.system.database.password=gusepass
	SET-PROPERTY:guse.wfs.system.defaultworkflowtype=zen
	SET-PROPERTY:guse.wfs.system.sleepsavetime=2000
	[Ljava.lang.String;@7ade17d8
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wfs/WEB-INF/lib/portal.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@70bd9535
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wfs/WEB-INF/lib/wfi.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@15cbc11e
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wfs/WEB-INF/lib/repository.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@b03e9f
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/wfs/WEB-INF/lib/storage.wsdd
	<Admin>Done processing</Admin>
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/storage
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/storage
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:guse.storage.importid.type=date
	SET-PROPERTY:guse.storage.system.defaultworkflowtype=zen
	SET-PROPERTY:guse.system.database.password=gusepass
	SET-PROPERTY:guse.storageclient.localmode.sendquota=true
	[Ljava.lang.String;@5ee6b897
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/storage/WEB-INF/lib/portal.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@7811dd12
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/storage/WEB-INF/lib/wfi.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@575fb87
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/storage/WEB-INF/lib/submitter.wsdd
	<Admin>Done processing</Admin>
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/repository
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/repository
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:rootuser=root
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:quotamax=2000
	SET-PROPERTY:guse.storage.importid.type=date
	SET-PROPERTY:guse.system.database.password=gusepass
	[Ljava.lang.String;@494b05ae
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/repository/WEB-INF/lib/portal.wsdd
	<Admin>Done processing</Admin>
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/stataggregator
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/stataggregator
	SET-PROPERTY:jobinstancetimeout=1
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:statrunningtimeout=1
	SET-PROPERTY:aggregatejoblimit=250
	SET-PROPERTY:sleeptime=100
	SET-PROPERTY:guse.system.database.password=gusepass
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/statvisualizer
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/statvisualizer
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:portal.url=http://portal.italiangrid.it:8080/wspgrade
	SET-PROPERTY:guse.system.database.password=gusepass
	SET-PROPERTY:language=hu
	SET-PROPERTY:country=HU
	---------propertyinit--------
	http-param:is.id-/services/urn:infoservice
	http-param:is.url-http://portal.italiangrid.it:8080/information
	http-param:service.url-http://portal.italiangrid.it:8080/ANSYS
	SET-PROPERTY:is.url=http://portal.italiangrid.it:8080/information
	SET-PROPERTY:is.id=/services/urn:infoservice
	SET-PROPERTY:service.url=http://portal.italiangrid.it:8080/ANSYS
	SET-PROPERTY:notify.quota.time.in.hour=1
	SET-PROPERTY:guse.system.database.driver=com.mysql.jdbc.Driver
	SET-PROPERTY:notify.smtp.host=localhost
	SET-PROPERTY:repeat.submit.workflow=1
	SET-PROPERTY:gemlcacache.refreshintervall_min=30
	SET-PROPERTY:guse.wspgrade.suportedwfengines=zen
	SET-PROPERTY:guse.system.database.url=jdbc:mysql://localhost:3306/guse
	SET-PROPERTY:guse.system.database.user=guse
	SET-PROPERTY:wspgrade.maxulpoadfilesize=100
	SET-PROPERTY:guse.logdir=/guselogg
	SET-PROPERTY:cache.time.msec=3000000
	SET-PROPERTY:service.loglevel=6
	SET-PROPERTY:guse.system.database.password=gusepass
	SET-PROPERTY:notify.quota.max.percent=95
	SET-PROPERTY:service.logtrace=false
	[Ljava.lang.String;@7c98cb9c
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ANSYS/WEB-INF/lib/storage.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@74179f50
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ANSYS/WEB-INF/lib/submitter.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@6a6b9ab
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ANSYS/WEB-INF/lib/remote.wsdd
	<Admin>Done processing</Admin>
	[Ljava.lang.String;@655dc8c
	Processing file /opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ANSYS/WEB-INF/lib/wfi.wsdd
	<Admin>Done processing</Admin>
	10:18:29,643 INFO  [PortalImpl:4873] Current URL /poller/receive generates exception: null
</verbatim>
%ENDTWISTY%

If something was wrong check if into the database =guse= the tables =service=, =serviceresource=, =servicetype= and =serviceproperties= aren't empty. If these table are empty use the sql dump file in attachment named such as the tables.

   * [[%ATTACHURL%/service.sql][service.sql]]: Dump of service tables

   * [[%ATTACHURL%/serviceproperties.sql][serviceproperties.sql]]: Dump of service tables

   * [[%ATTACHURL%/serviceresource.sql][serviceresource.sql]]: Dump of service tables

   * [[%ATTACHURL%/servicetype.sql][servicetype.sql]]: Dump of service tables

---### Statistics Initialization

The third step is initilizing the statistics aggregator. For do this go to https://portal.italiangrid.it/stataggregator. If in this page are the text _Startting_ is done otherwise reload the page.



---+ References

   * Liferay: http://www.liferay.com/
   * gUSE: http://www.guse.hu/

-- [[Main.DiegoMichelotto][Diego Michelotto]] - 11 Nov 2011
Attachments
Topic attachments
I	Attachment	Action	Size	Date	Who	Comment
sql	PortalUser.sql	manage	4.3 K	2011-11-10 - 13:58	DiegoMichelotto	Dump of PortalUser database only structure
sql	PortalUser_IDP.sql	manage	1.7 K	2011-11-10 - 14:00	DiegoMichelotto	Dump of table IDP from PortalUser structure + data
war	Login-1.1.war	manage	22385.2 K	2012-01-11 - 08:45	DiegoMichelotto	Portlet for PortalUser
war	Registration-4.war	manage	17065.9 K	2012-01-11 - 08:44	DiegoMichelotto	Portlet for PortalUser
war	VO-manager-portlet-0.1.war	manage	18795.9 K	2012-01-11 - 08:44	DiegoMichelotto	Portlet for PortalUser
txt	get_vo_info.py.txt	manage	8.0 K	2012-01-11 - 09:19	DiegoMichelotto
lar	igiportal.lar	manage	1707.9 K	2012-01-11 - 10:05	DiegoMichelotto
lar	igiportla.lar	manage	1892.8 K	2012-01-11 - 09:01	DiegoMichelotto	Layout IGI
txt	myproxy2.py.txt	manage	1.0 K	2012-01-11 - 09:04	DiegoMichelotto	Python utility
txt	splitP12.py.txt	manage	1.1 K	2012-01-11 - 09:04	DiegoMichelotto	Python utility
lar	welcome.portlet.lar	manage	120.2 K	2012-01-11 - 09:01	DiegoMichelotto	Layout IGI
png	DCI.png	manage	95.3 K	2012-07-13 - 11:53	DiegoMichelotto
png	WSPgrade.png	manage	36.1 K	2012-07-13 - 11:53	DiegoMichelotto
sql	service.sql	manage	2.9 K	2012-07-13 - 12:02	DiegoMichelotto	Dump of service tables
sql	serviceproperties.sql	manage	6.7 K	2012-07-13 - 12:02	DiegoMichelotto	Dump of service tables
sql	serviceresource.sql	manage	5.3 K	2012-07-13 - 12:02	DiegoMichelotto	Dump of service tables
sql	servicetype.sql	manage	1.4 K	2012-07-13 - 12:02	DiegoMichelotto	Dump of service tables
Topic revision: r11 - 2012-07-13 - DiegoMichelotto
User Guide
Administration Guide
Documents
Create New Topic
TWIKI.NET
IGIPortal

Edit
Attach