This is an old revision of the document!
Socle Esup
Installation d'un socle esup-portail 3.1.2 sous centos 5
System
cette installation de socle se fait sur un serveur virtuel openvz - centos 5.4
$ cat /etc/redhat-release
CentOS release 5.4 (Final)
$ free
total used free shared buffers cached
Mem: 786432 23504 762928 0 0 0
-/+ buffers/cache: 23504 762928
Swap: 0 0 0
[root@esup3dev /etc/yum.repos.d]
$ df -H
Filesystem Size Used Avail Use% Mounted on
/dev/simfs 2.1G 626M 1.5G 31% /
$ arch
x86_64
Pre-requis Java
Les centos/redhat proposent par defaut un environement Java a base de openjdk et gcj . Apparement pas entirement compatible avec esup-uPortal
nous allons alors installer un repository suplementaire afin de disposer d'un environement java Sun, mais aussi pour disposer d'un tomcat v6.
[root@esup3dev /etc/yum.repos.d] $ wget http://www.jpackage.org/jpackage50.repo
probleme de dependances
si probleme de dependance du genre:
Missing Dependency: /usr/bin/rebuild-security-providers is needed by package java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386 (core-0)
cf http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14911
http://www.redhat.com/archives/rhl-devel-list/2006-March/msg00723.html
Apparently Redhat released a version of jpackage-utils that includes the dependency, and the problem comes in when the Redhat version of jpackage-utils is replaced by the JPackage version of jpackage-utils.
I switched off the jpackage17-generic repository temporarily, and forced an erase of jpackage-utils, then told yum to install jpackage-utils.
CE que j'ai fais sur ecm3:
disable (enable=0) sur le repo jpackage-generic
[root@ecm3 yum.repos.d]# vim jpackage50.repo [jpackage-generic] name=JPackage (free), generic mirrorlist=http://www.jpackage.org/mirrorlist.php?dist=generic&type=free&release=5.0 failovermethod=priority gpgcheck=1 gpgkey=http://www.jpackage.org/jpackage.asc enabled=0
retrait sauvage (–nodeps) de jpackage-utils
[root@ecm3 yum.repos.d]# rpm -e jpackage-utils --nodeps
installation (depuis centos repo !)
[root@ecm3 yum.repos.d]# yum install jpackage-utils
cela passe alors avec celui ci
$ rpm -q jpackage-utils jpackage-utils-1.7.3-1jpp.2.el5
Package Arch Version Repository Size
Installing: jpackage-utils noarch 1.7.3-1jpp.2.el5 ce5-i386-Everything 61 k
Tomcat
l'installation de tomcat6 entraine l'installation du JRE (ici java-1.6.0-sun.x86_64) sous forme de dependance :
$ yum install tomcat6 Transaction Summary ============================================================================================================================= Install 48 Package(s) Update 1 Package(s) Remove 0 Package(s) Total download size: 51 M Installed: tomcat6.noarch 0:6.0.26-1.jpp5 Dependency Installed: at.x86_64 0:3.1.8-82.fc6 avahi.x86_64 0:0.6.16-6.el5 avahi-compat-libdns_sd.x86_64 0:0.6.16-6.el5 bc.x86_64 0:1.06-21 bitstream-vera-fonts.noarch 0:1.10-7 cairo.x86_64 0:1.2.4-5.el5 cups.x86_64 1:1.3.7-11.el5_4.6 dbus-glib.x86_64 0:0.73-8.el5 dbus-python.x86_64 0:0.70-9.el5_4 ecj.noarch 1:3.3.1.1-3.jpp5 fontconfig.x86_64 0:2.4.1-7.el5 freetype.x86_64 0:2.2.1-21.el5_3 gettext.x86_64 0:0.14.6-4.el5 jakarta-commons-collections-tomcat5.noarch 0:3.1-9.jpp5 jakarta-commons-daemon.noarch 1:1.0.1-7.jpp5 jakarta-commons-dbcp-tomcat5.noarch 0:1.2.2-2.jpp5 jakarta-commons-logging.noarch 0:1.1-8.jpp5 jakarta-commons-pool-tomcat5.noarch 0:1.3-11.jpp5 java-1.6.0-sun.x86_64 0:1.6.0.6-1jpp jpackage-utils.noarch 0:5.0.0-2.jpp5 libICE.x86_64 0:1.0.1-2.1 libSM.x86_64 0:1.0.1-3.1 libX11.x86_64 0:1.0.3-11.el5 libXau.x86_64 0:1.0.1-3.1 libXdmcp.x86_64 0:1.0.1-2.1 libXext.x86_64 0:1.0.1-2.1 libXft.x86_64 0:2.1.10-1.1 libXi.x86_64 0:1.0.1-4.el5_4 libXp.x86_64 0:1.0.0-8.1.el5 libXrender.x86_64 0:0.9.1-3.1 libXt.x86_64 0:1.0.2-3.1.fc6 libXtst.x86_64 0:1.0.1-3.1 libXxf86vm.x86_64 0:1.0.1-3.1 libdaemon.x86_64 0:0.10-5.el5 libdrm.x86_64 0:2.0.2-1.1 libxml2-python.x86_64 0:2.6.26-2.1.2.8 mesa-libGL.x86_64 0:6.5.1-7.7.el5 pango.x86_64 0:1.14.9-8.el5.centos paps.x86_64 0:0.6.6-18.el5 patch.x86_64 0:2.5.4-29.2.3.el5 pax.x86_64 0:3.4-1.2.2 redhat-lsb.x86_64 0:3.1-12.3.EL.el5.centos tomcat6-el-1.0-api.noarch 0:6.0.26-1.jpp5 tomcat6-jsp-2.1-api.noarch 0:6.0.26-1.jpp5 tomcat6-lib.noarch 0:6.0.26-1.jpp5 tomcat6-servlet-2.5-api.noarch 0:6.0.26-1.jpp5 xorg-x11-filesystem.noarch 0:7.1-2.fc6 Dependency Updated: cups-libs.x86_64 1:1.3.7-11.el5_4.6
Si on souhaite disposer de l'interface d'aministration de tomcat
$ yum install tomcat6-webapps tomcat6-admin-webapps Installed: tomcat6-webapps.noarch 0:6.0.26-1.jpp5 tomcat6-admin-webapps.noarch 0:6.0.26-1.jpp5 Dependency Installed: jakarta-taglibs-standard.noarch 0:1.1.2-7.jpp5 tomcat5-jsp-2.0-api.noarch 0:5.5.27-7.jpp5 tomcat5-servlet-2.4-api.noarch 0:5.5.27-7.jpp5 xalan-j2.noarch 0:2.7.0-10.jpp5 xerces-j2.noarch 0:2.7.1-12.jpp5 xml-commons.noarch 0:1.3.04-5.jpp5 xml-commons-jaxp-1.3-apis.noarch 0:1.3.04-5.jpp5 xml-commons-resolver12.noarch 0:1.3.04-5.jpp5
repertoire lib 5->6
en tomcat5 il y avait des librairies dans common et shared, depuis le 6 il y a seulement un repertoire lib. pour la compatibilité avec les anciens canaux esup , il faut recreer cette arborescence de lib.
tomcat5
[root@esupdev4 /usr/share/tomcat5] $ ls -al total 12 drwxr-xr-x 3 root root 4096 oct 15 2009 . drwxr-xr-x 50 root root 4096 jun 19 2009 .. drwxr-xr-x 2 root root 4096 oct 15 2009 bin lrwxrwxrwx 1 root root 23 oct 15 2009 common -> /var/lib/tomcat5/common lrwxrwxrwx 1 root root 12 oct 15 2009 conf -> /etc/tomcat5 lrwxrwxrwx 1 root root 16 oct 15 2009 logs -> /var/log/tomcat5 lrwxrwxrwx 1 root root 23 oct 15 2009 server -> /var/lib/tomcat5/server lrwxrwxrwx 1 root root 23 oct 15 2009 shared -> /var/lib/tomcat5/shared lrwxrwxrwx 1 root root 23 oct 15 2009 temp -> /var/cache/tomcat5/temp lrwxrwxrwx 1 root root 24 oct 15 2009 webapps -> /var/lib/tomcat5/webapps lrwxrwxrwx 1 root root 23 oct 15 2009 work -> /var/cache/tomcat5/work
tomcat6
[root@esup3dev /usr/share/tomcat6] $ ls -l total 4 drwxr-xr-x 2 root root 4096 Apr 24 17:01 bin lrwxrwxrwx 1 root root 12 Apr 24 17:01 conf -> /etc/tomcat6 lrwxrwxrwx 1 root root 23 Apr 24 17:01 lib -> /usr/share/java/tomcat6 lrwxrwxrwx 1 root root 16 Apr 24 17:01 logs -> /var/log/tomcat6 lrwxrwxrwx 1 root root 23 Apr 24 17:01 temp -> /var/cache/tomcat6/temp lrwxrwxrwx 1 root root 24 Apr 24 17:01 webapps -> /var/lib/tomcat6/webapps lrwxrwxrwx 1 root root 23 Apr 24 17:01 work -> /var/cache/tomcat6/work
adaptation
[root@esup3dev /usr/share/tomcat6] $ mkdir -p /var/lib/tomcat6/common/classes ; mkdir -p /var/lib/tomcat6/common/endorsed ; mkdir -p /var/lib/tomcat6/common/lib ; mkdir -p /var/lib/tomcat6/shared/classes ; mkdir -p /var/lib/tomcat6/shared/lib [root@esup3dev /usr/share/tomcat6] $ ln -s /var/lib/tomcat6/common common ; ln -s /var/lib/tomcat6/shared shared [root@esup3dev /usr/share/tomcat6] $ ls -l common shared lrwxrwxrwx 1 root root 23 Apr 24 17:50 common -> /var/lib/tomcat6/common lrwxrwxrwx 1 root root 23 Apr 24 17:50 shared -> /var/lib/tomcat6/shared
modification de catalina.properties
$ diff /etc/tomcat6/catalina.properties.orig /etc/tomcat6/catalina.properties
47c47
< common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar
---
> common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,${catalina.home}/common/classes,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar
Java JDK
depuis le package non-free de jpackage, noius avons recompilé sur un repository maison
[root@esup3dev ~] $ yum install java-1.6.0-sun-devel =========================================================================================================================== Package Arch Version Repository Size =========================================================================================================================== Installing: java-1.6.0-sun-devel x86_64 1.6.0.6-1jpp el5-x86_64-perso 9.4 M Transaction Summary =========================================================================================================================== Install 1 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 9.4 M Is this ok [y/N]: y
au final entre le jdk et le jre java-sun nous avons
$ ls -l /usr/lib/jvm/ total 4 lrwxrwxrwx 1 root root 26 Apr 27 17:50 java -> /etc/alternatives/java_sdk lrwxrwxrwx 1 root root 32 Apr 27 17:50 java-1.6.0 -> /etc/alternatives/java_sdk_1.6.0 lrwxrwxrwx 1 root root 22 Apr 27 17:50 java-1.6.0-sun -> java-1.6.0-sun-1.6.0.6 drwxr-xr-x 6 root root 4096 Apr 27 17:50 java-1.6.0-sun-1.6.0.6 lrwxrwxrwx 1 root root 30 Apr 27 17:50 java-sun -> /etc/alternatives/java_sdk_sun lrwxrwxrwx 1 root root 21 Apr 24 17:01 jre -> /etc/alternatives/jre lrwxrwxrwx 1 root root 27 Apr 24 17:01 jre-1.6.0 -> /etc/alternatives/jre_1.6.0 lrwxrwxrwx 1 root root 26 Apr 24 17:01 jre-1.6.0-sun -> java-1.6.0-sun-1.6.0.6/jre lrwxrwxrwx 1 root root 25 Apr 24 17:01 jre-sun -> /etc/alternatives/jre_sun
Soit, en suivant les liens, un java_home de :
$ ls -l /usr/lib/jvm/java-1.6.0-sun-1.6.0.6 total 16 drwxr-xr-x 2 root root 4096 Apr 27 17:50 bin drwxr-xr-x 3 root root 4096 Apr 27 17:50 include drwxr-xr-x 4 root root 4096 Apr 24 17:01 jre drwxr-xr-x 2 root root 4096 Apr 27 17:50 lib
Ant
il y a un problem entre centos et jpackage sur une depandance pour ant
$ yum install ant --> Processing Dependency: /usr/bin/rebuild-security-providers for package: java-1.4.2-gcj-compat https://bugzilla.redhat.com/show_bug.cgi?id=260161 --> Missing Dependency: /usr/bin/rebuild-security-providers is needed by package java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.x86_64 (ce5-x86_64-Everything)
retrait de jpckage-utils (from jpackage 5.0)
Removing: jpackage-utils noarch 5.0.0-2.jpp5 installed 172 k [root@esup3dev ~] $ rpm -e jpackage-utils --nodeps
reinstallation depuis le repo centos en version 1.7 incluant le fameux rebuild-security-providers
[root@esup3dev ~] $ yum install jpackage-utils Installing: jpackage-utils noarch 1.7.3-1jpp.2.el5 ce5-x86_64-Everything 61 k [root@esup3dev ~] $ rpm -qli jpackage-utils | grep rebuild-security /usr/bin/rebuild-security-providers
ainsi le yum install ant fonctionne correctement maintenant avec toutefois un desable temporaire de jpackage-generic
$ yum --disablerepo=jpackage-generic install ant ant-apache-regexp ant-contrib =========================================================================================================================== Package Arch Version Repository Size =========================================================================================================================== Installing: ant x86_64 1.6.5-2jpp.2 ce5-x86_64-Everything 2.3 M ant-apache-regexp x86_64 1.6.5-2jpp.2 ce5-x86_64-Everything 28 k ant-contrib noarch 1.0-0.10.b2.el5 el5-x86_64-epel 221 k Installing for dependencies: alsa-lib x86_64 1.0.17-1.el5 core-0 414 k antlr x86_64 2.7.6-4jpp.2 core-0 1.1 M atk x86_64 1.12.2-1.fc6 core-0 224 k gjdoc x86_64 0.7.7-12.el5 core-0 886 k gtk2 x86_64 2.10.4-20.el5 core-0 6.5 M hicolor-icon-theme noarch 0.9-2.1 core-0 25 k java-1.4.2-gcj-compat x86_64 1.4.2.0-40jpp.115 core-0 29 k junit x86_64 3.8.2-3jpp.1 core-0 337 k libXcursor x86_64 1.1.7-1.1 core-0 32 k libXfixes x86_64 4.0.1-2.1 core-0 15 k libXinerama x86_64 1.0.1-2.1 core-0 9.8 k libXrandr x86_64 1.1.1-3.1 core-0 15 k libart_lgpl x86_64 2.3.17-4 core-0 75 k libgcj x86_64 4.1.2-46.el5_4.2 Ce5-x86_64-updates 18 M regexp x86_64 1.4-2jpp.2 core-0 102 k zip x86_64 2.31-2.el5 core-0 136 k Transaction Summary =========================================================================================================================== Install 19 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 30 M Is this ok [y/N]: y
Ant nodeps
si au premier lancement de ant sur le package esup il plante sur :
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ ant usage Buildfile: build.xml BUILD FAILED /home/esup/src/esup-3.1.2-esup-0.5-RC3/build.xml:14: Could not create task or type of type: replaceregexp. ...
il manque alors le package ant-nodeps
$ yum install ant-nodeps =========================================================================================================================== Installing: ant-nodeps x86_64 1.6.5-2jpp.2 ce5-x86_64-Everything 900 k Transaction Summary =========================================================================================================================== Install 1 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 900 k Is this ok [y/N]: y
Mysql
Lower case
les tables doivent être en minuscule !
[root@bd3 ~]# grep lower /etc/my.cnf lower_case_table_names=1 [root@bd3 ~]# /etc/init.d/mysqld restart
database
mysql> create database uportal3dev ; Query OK, 1 row affected (0.00 sec) mysql> CREATE USER uportal@'%' IDENTIFIED BY 'secret'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT USAGE ON *.* TO 'uportal'@'%' IDENTIFIED BY 'secret' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOU MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON uportal3dev.* to uportal@'%' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON uportal3dev.* to uportal@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)
Test
$ mysql -u uportal --password="secret" -h bd3.it-sudparis.eu -e "SHOW DATABASES" +--------------------+ | Database | +--------------------+ | information_schema | | test | | uportal3dev | +--------------------+
user esup
tous les travaux de parametrage, compilation se feront avec un utilisateur dedié non privilégié: esup
$ useradd esup [root@esup3dev ~] $ passwd esup Changing password for user esup. New UNIX password: Retype new UNIX password: passwd: all authentication tokens updated successfully. $ su - esup [esup@esup3dev ~] $ pwd /home/esup
anticiper les droits d'acces au deploy d'esup
$ mkdir /usr/share/tomcat6/webapps/uPortal $ chown esup /usr/share/tomcat6/webapps/uPortal $ mkdir /usr/share/tomcat6/webapps/ResourceServingWebapp $ chown esup /usr/share/tomcat6/webapps/ResourceServingWebapp
Package Esup
archive
recuperer l'archive uPortal-esup-DLM depuis https://sourcesup.cru.fr/frs/?group_id=173&release_id=1216, ici esup-3.1.2-esup-0.5-RC3.tar.gz
travailler en tant qu'utilisateur esup.
[esup@esup3dev ~] $ mkdir src $ cd src $ wget https://sourcesup.cru.fr/frs/download.php/2902/esup-3.1.2-esup-0.5-RC3.tar.gz
[esup@esup3dev ~/src] $ tar xvfz esup-3.1.2-esup-0.5-RC3.tar.gz [esup@esup3dev ~/src] $ ln -s esup-3.1.2-esup-0.5-RC3 esup-install [esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ cp build.properties custom.properties
Taches ant
Voici les taches ant disponible dans le build.xml:
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant usage
Buildfile: build.xml
_version.display:
[echo] Esup version : esup-3.1.2-0.5-RC3
[echo] - Use uPortal [3.1.2]
usage:
[echo] *** How to use this package by step ***
[echo] *** 1) Rename build.sample.properties to build.properties
[echo] *** 2) adapt build.properties (java_home, etc...)
[echo] *** 3) Rename config.sample.properties to config.properties
[echo] *** 4) Adapt config.properties
[echo] *** 5) Adapt ant.[cmd|sh] (JAVA_HOME)
[echo] *** 6) ant getcomponents : get remote components like uPortal sources
[echo] *** 7) ant unzip : unzip remote components
[echo] *** 8) ant init : init the package installation
[echo] *** 9) ant db.test : test the database connection (becareful if you use production packageupdate your server.xml in tomcat before)
[echo] *** 10) ant db.init : init the database (erase all data)
[echo] *** 11) ant deploy : deploy portal in tomcat
[echo] *** 12) start-esup.[cmd|sh] : start embedded tomcat server
[echo] ***
[echo] *** look in logs folder (portal.log)
BUILD SUCCESSFUL
Total time: 4 seconds
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant -p
Buildfile: build.xml
Main targets:
clean Clean uPortal compile
db.delete Delete to database
db.export Export database part
db.import Import to database
db.init Drops all tables, then runs all the targets necessary prepare the portal database
db.test Displays information about the database defined in rdbm.properties
deploy Deploy
deploy-ear deploy-ear
getcomponents get remote components
hsql.start Start Hsql Server
hsql.stop Stop Hsql Server
init Initialization
package.clean Make a clean of package
package.make Make a package
portlet.deploy Deploy a portlet application
properties.debug Display properties
undeploy Clean deploy file
unzip unzip remote components
usage How to se this package
user.add Add on uPortal user
user.del Delete one uPortal user
users.del Delete users from flat file
users.ldap.add Add users from LDAP to database
Default target: usage
Annecdote memoire openvz
les taches ant peuvent comsomer beaucoup de ressources, ici sur notre serveur virtuel (container) openvz, l'allocation de 768M de ram n'est pas suffisante.
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant getcomponents
Buildfile: build.xml
_version.display:
[echo] Esup version : esup-3.1.2-0.5-RC3
[echo] - Use uPortal [3.1.2]
_prepare:
[mkdir] Created dir: /home/esup/src/esup-3.1.2-esup-0.5-RC3/packages
[mkdir] Created dir: /home/esup/src/esup-3.1.2-esup-0.5-RC3/temp
[mkdir] Created dir: /home/esup/src/esup-3.1.2-esup-0.5-RC3/logs
_script.init:
[echo] Init env.sh
[copy] Copying 1 file to /home/esup/src/esup-3.1.2-esup-0.5-RC3
BUILD FAILED
/home/esup/src/esup-3.1.2-esup-0.5-RC3/resources/ant-files/package.xml:55: The following error occurred while executing this line:
/home/esup/src/esup-3.1.2-esup-0.5-RC3/resources/ant-files/script.xml:95: Execute failed: java.io.IOException: Cannot run program "chmod": java.io.IOException: error=12, Cannot allocate memory
<code>
en effet
<code>
[root@epidaure ~]# vzctl exec 21230 cat /proc/user_beancounters
Version: 2.5
uid resource held maxheld barrier limit failcnt
21230: kmemsize 4953414 6300969 14372700 14790164 0
lockedpages 0 0 256 256 0
privvmpages 77174 205337 196608 196608 1
cf le failcnt = 1 pour privvmpages !
on passe a 1G
[root@epidaure ~]# vzctl set 21230 --privvmpages $((256 * 1024)) --save UB limits were set successfully Configure meminfo: 262144 Saved parameters for CT 21230
Ant getcomponents
recuperation online de uPortal 3.1.2
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant getcomponents
Buildfile: build.xml
_version.display:
[echo] Esup version : esup-3.1.2-0.5-RC3
[echo] - Use uPortal [3.1.2]
_prepare:
_script.init:
[echo] Init start-esup.sh
[copy] Copying 1 file to /home/esup/src/esup-3.1.2-esup-0.5-RC3
[echo] Init stop-esup.sh
[copy] Copying 1 file to /home/esup/src/esup-3.1.2-esup-0.5-RC3
getcomponents:
_uportal.getRemote:
[echo] Download uPortal ...
[get] Getting: http://www.ja-sig.org/downloads/uportal/uPortal-3.1.2/uPortal-3.1.2.tar.gz
[get] To: /home/esup/src/esup-3.1.2-esup-0.5-RC3/packages/uPortal-3.1.2.tar.gz
BUILD SUCCESSFUL
Total time: 15 seconds
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ locate uPortal-3.1.2.tar.gz
/home/esup/src/esup-3.1.2-esup-0.5-RC3/packages/uPortal-3.1.2.tar.gz
ant unzip
desarchivage de uPortal
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant unzip
Buildfile: build.xml
unzip:
_uportal.unzip:
[untar] Expanding: /home/esup/src/esup-3.1.2-esup-0.5-RC3/packages/uPortal-3.1.2.tar.gz into /home/esup/src/esup-3.1.2-esup-0.5-RC3/temp
[move] Moving 2470 files to /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2
BUILD SUCCESSFUL
Total time: 13 seconds
ant init
ant init prend les update esup les copie dans uportal et customisation dans uportal
il se peut que la tache init est un probleme avec la boucle for
BUILD FAILED /home/esup/src/esup-3.1.2-esup-0.5-RC3/resources/ant-files/uportal-init.xml:4: The following error occurred while executing this line: /home/esup/src/esup-3.1.2-esup-0.5-RC3/resources/ant-files/uportal-init.xml:294: Could not create task or type of type: for.
j'avais sur la machine une version de ant-contrib (cf http://standartux.fr/index.php?post/2010/03/08/ant-Could-not-create-task-or-type-of-type%3A-for) qui posait probleme, un update avec la version ant-contrib de jpackage ressoud le problem.
ant-contrib-1.0-0.10.b2.el5 vs ant-contrib-1.0-1.b3.1.jpp5
$ yum install ant-contrib =========================================================================================================================== Package Arch Version Repository Size =========================================================================================================================== Updating: ant-contrib noarch 1.0-1.b3.1.jpp5 jpackage-generic 209 k Installing for dependencies: bcel noarch 5.1-16.jpp5 jpackage-generic 459 k ivy noarch 1.3.1-3.jpp5 jpackage-generic 336 k jakarta-commons-cli noarch 1.1-1.jpp5 jpackage-generic 36 k jakarta-commons-codec noarch 1.3-9.jpp5 jpackage-generic 179 k jakarta-commons-httpclient noarch 1:3.0.1-3.jpp5 jpackage-generic 200 k jakarta-oro noarch 2.0.8-4.jpp5 jpackage-generic-updates 72 k Transaction Summary =========================================================================================================================== Install 6 Package(s) Update 1 Package(s) Remove 0 Package(s) Total download size: 1.5 M Is this ok [y/N]: y
Apres ceci, la tache s'execute bien
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant init
Buildfile: build.xml
_version.display:
[echo] Esup version : esup-3.1.2-0.5-RC3
[echo] - Use uPortal [3.1.2]
_prepare:
_script.init:
init:
_uportal.init:
[echo] Copy of updates/custom /home/esup/src/esup-3.1.2-esup-0.5-RC3/update
[copy] Copying 76 files to /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2
[copy] Copying 136 files to /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2
BUILD SUCCESSFUL
Total time: 9 seconds
ant deploy
ant deploy compile les class (1 milliers !) et les deploient dans webapps/esup-portail, la premiere fois ⇒ bcp de downloads de .jar ⇒ long (~6mn )
mais cette tache necessite maven
$ ant deploy
...
[artifact:dependencies] Downloading: org/easymock/easymock/2.4/easymock-2.4.jar from central
[artifact:dependencies] Downloading: org/springframework/spring-test/2.5.6/spring-test-2.5.6.jar from central
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is not available or out-of-date, calling 'mvn install'
mvn:
BUILD FAILED
/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/build.xml:1052: Execute failed: java.io.IOException: Cannot run program "/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/apache-maven-2.2.1/bin/mvn" (in directory "/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl"): java.io.IOException: error=2, No such file or directory
Total time: 6 minutes 0 seconds
Maven
=========================================================================================================================== Package Arch Version Repository Size =========================================================================================================================== Installing: maven noarch 1.1-7.jpp5 jpackage-generic 524 k Installing for dependencies: ant-junit noarch 1.7.1-7.jpp5 jpackage-generic 109 k ant-trax noarch 1.7.1-7.jpp5 jpackage-generic 35 k bea-stax x86_64 1.2.0-0.4.rc1.el5 el5-x86_64-epel 430 k bea-stax-api x86_64 1.2.0-0.4.rc1.el5 el5-x86_64-epel 61 k classpathx-mail noarch 1.1.2-1.jpp5 jpackage-generic 784 k classworlds noarch 1.1-2.jpp5 jpackage-generic 39 k dom4j noarch 1.6.1-10.jpp5 jpackage-generic 300 k forehead noarch 1:1.0-0.b4.2.jpp5 jpackage-generic 15 k ganymed-ssh2 noarch 210-5.jpp5 jpackage-generic 241 k geronimo-j2ee-1.4-apis noarch 1.2-13.jpp5 jpackage-generic 948 k geronimo-jaf-1.0.2-api noarch 1.2-13.jpp5 jpackage-generic 39 k geronimo-jms-1.1-api noarch 1.2-13.jpp5 jpackage-generic 32 k geronimo-specs-poms noarch 1.2-13.jpp5 jpackage-generic 21 k geronimo-stax-1.0-api noarch 1.2-13.jpp5 jpackage-generic 31 k glassfish-jaxb noarch 2.1.4-7.jpp5 jpackage-generic 3.5 M icu4j noarch 3.8.1-5.jpp5 jpackage-generic 4.0 M isorelax noarch 0.1-0.20041111.6.jpp5 jpackage-generic 71 k jakarta-commons-beanutils16 noarch 1.6.1-7jpp jpackage-generic 112 k jakarta-commons-cli10 noarch 1.0-9.jpp5 jpackage-generic 33 k jakarta-commons-collections noarch 3.1-9.jpp5 jpackage-generic 490 k jakarta-commons-discovery noarch 1:0.4-6.jpp5 jpackage-generic 70 k jakarta-commons-grant noarch 1:1.0-0.b5.cvs20040118.3.jpp5 jpackage-generic 9.0 k jakarta-commons-graph noarch 1:0.8.1-0.cvs20040118.4.jpp5 jpackage-generic 62 k jakarta-commons-io noarch 1.4-1jpp jpackage-generic 111 k jakarta-commons-jelly noarch 1.0-6.jpp5 jpackage-generic 150 k jakarta-commons-jelly-tags-ant noarch 1.0-6.jpp5 jpackage-generic 32 k jakarta-commons-jelly-tags-define noarch 1.0-6.jpp5 jpackage-generic 19 k jakarta-commons-jelly-tags-dynabean noarch 1.0-6.jpp5 jpackage-generic 11 k jakarta-commons-jelly-tags-interaction noarch 1.0-6.jpp5 jpackage-generic 7.9 k jakarta-commons-jelly-tags-log noarch 1.0-6.jpp5 jpackage-generic 9.5 k jakarta-commons-jelly-tags-util noarch 1.0-6.jpp5 jpackage-generic 15 k jakarta-commons-jelly-tags-xml noarch 1.0-6.jpp5 jpackage-generic 31 k jakarta-commons-jexl noarch 1.1-1jpp jpackage-generic 125 k jakarta-commons-lang noarch 2.1-7.jpp5 jpackage-generic 941 k jakarta-commons-net noarch 1.4.1-4.jpp5 jpackage-generic 166 k jakarta-commons-transaction noarch 1.1-9.jpp5 jpackage-generic 81 k jakarta-slide-webdavclient noarch 2.1-8.jpp5 jpackage-generic 215 k jaxen noarch 1.1-3.jpp5 jpackage-generic 671 k jdepend noarch 2.9.1-1.jpp5 jpackage-generic 177 k jdom noarch 1.0-5.jpp5 jpackage-generic 166 k jline noarch 0.9.94-1.jpp5 jpackage-generic 89 k jsch noarch 0.1.40-1.jpp5 jpackage-generic 192 k jtidy noarch 1:8.0-0.813.1.jpp5 jpackage-generic 234 k jzlib noarch 1.0.7-4.jpp5 jpackage-generic 37 k log4j noarch 1.2.14-15.jpp5 jpackage-generic 352 k maven-model noarch 3.0.2-3.jpp5 jpackage-generic 174 k maven-wagon noarch 1.0-0.b2.3jpp jpackage-generic 144 k msv noarch 1.2-0.20050722.6.jpp5 jpackage-generic 585 k msv-xsdlib noarch 1.2-0.20050722.6.jpp5 jpackage-generic 135 k mx4j noarch 3.0.1-9.jpp5 jpackage-generic 1.6 M plexus-container-default noarch 1.0-0.a9s1.1jpp jpackage-generic 162 k plexus-interactivity noarch 1.0-0.a5.6.jpp5 jpackage-generic 15 k plexus-utils noarch 1.4.8-2.jpp5 jpackage-generic 194 k relaxngDatatype noarch 1.0-3.jpp5 jpackage-generic 8.7 k stax-utils noarch 0.0-0.20070216.1jpp jpackage-generic 121 k sun-jaf x86_64 1.1-3jpp el5-x86_64-perso 131 k werkz noarch 1.0-0.b10.7.jpp5 jpackage-generic 30 k ws-jaxme noarch 0.5.1-10.jpp5 jpackage-generic 1.2 M xml-commons-jaxp-1.2-apis noarch 1.3.04-5.jpp5 jpackage-generic 112 k xml-commons-resolver11 noarch 1.3.04-5.jpp5 jpackage-generic 64 k xml-im-exporter noarch 1.1-4.jpp5 jpackage-generic 42 k xom noarch 1.2.1-1.jpp5 jpackage-generic 267 k xpp2 noarch 2.1.10-6.jpp5 jpackage-generic 239 k xpp3 noarch 1.1.3.8-1.jpp5 jpackage-generic 289 k Updating for dependencies: ant noarch 1.7.1-7.jpp5 jpackage-generic 1.3 M ant-apache-regexp noarch 1.7.1-7.jpp5 jpackage-generic 19 k ant-nodeps noarch 1.7.1-7.jpp5 jpackage-generic 400 k Transaction Summary =========================================================================================================================== Install 65 Package(s) Update 3 Package(s) Remove 0 Package(s) Total download size: 23 M Is this ok [y/N]: y
mais apparement c'est mvn (maven2 !?) que le build.xml semblre rechercher
#yum install maven2 Transaction Summary ========================================================================================== Install 43 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 17 M Installed: maven2.noarch 0:2.0.7-9.jpp5 Dependency Installed: asm.noarch 0:1.5.3-7.jpp5 aspectj.noarch 0:1.5.3-2jpp bsf.noarch 0:2.3.0-13.jpp5 bsh.noarch 0:1.3.0-13.jpp5 cglib.noarch 0:2.1.3-4.jpp5 cssparser.noarch 0:0.9.5-1.jpp5 easymock2.noarch 0:2.3-1.jpp5 excalibur.noarch 1:1.0-0.r508111.13.jpp5 excalibur-avalon-framework.noarch 1:4.3.1-0.r508111.13.jpp5 excalibur-avalon-logkit.noarch 1:2.2.1-0.r508111.13.jpp5 hamcrest.noarch 0:1.1-8.jpp5 itext.noarch 0:1.4-3.jpp5 jakarta-commons-beanutils.noarch 0:1.7.0-10.jpp5 jakarta-commons-digester.noarch 0:1.8-1jpp jmock.noarch 0:1.2.0-2.jpp5 junit4.noarch 0:4.5-4.jpp5 maven-doxia.noarch 0:1.0-0.a10.4.jpp5 maven-shared.noarch 0:8-0.p8.5.jpp5 maven-shared-monitor.noarch 0:1.0-0.p8.5.jpp5 maven-surefire.noarch 0:2.3.1-3.jpp5 maven-surefire-booter.noarch 0:2.3.1-3.jpp5 maven2-common-poms.noarch 0:1.0-6.jpp5 ognl.noarch 0:2.6.9-3.jpp5 plexus-ant-factory.noarch 0:1.0-0.a1.4.jpp5 plexus-archiver.noarch 0:1.0-0.a8.1jpp plexus-bsh-factory.noarch 0:1.0-0.a7s.4.jpp5 plexus-classworlds.noarch 0:1.2-0.a9.2.jpp5 plexus-cli.noarch 0:1.2-2.jpp5 plexus-compiler.noarch 0:1.5.3-3.jpp5 plexus-containers.noarch 0:1.0-0.a32.3.jpp5 plexus-containers-component-api.noarch 0:1.0-0.a32.3.jpp5 plexus-containers-container-default.noarch 0:1.0-0.a32.3.jpp5 plexus-i18n.noarch 0:1.0-0.b6.5.jpp5 plexus-io.noarch 0:1.0-0.a1.1jpp plexus-velocity.noarch 0:1.1.7-1jpp qdox.noarch 0:1.6.1-5.jpp5 sac.noarch 0:1.3-4.jpp5 saxon.noarch 0:6.5.5-1.jpp5 saxpath.noarch 0:1.0-3.jpp5 servletapi4.noarch 0:4.0.4-6.jpp5 velocity.noarch 0:1.5-4.jpp5 werken-xpath.noarch 0:0.9.4-0.beta.13.jpp5
si cela plante sur
[ERROR] BUILD ERROR
[exec] [INFO] ------------------------------------------------------------------------
[exec] [INFO] Internal error in the plugin manager executing goal 'org.apache.maven.plugins:maven-war-plugin:2.1-alpha-2:war': Unable to find the mojo 'org.apache.maven.plugins:maven-war-plugin:2.1-alpha-2:war' in the plugin 'org.apache.maven.plugins:maven-war-plugin'
il faut installer le plugin war de maven
=========================================================================================================================== Package Arch Version Repository Size =========================================================================================================================== Installing: maven-plugin-war noarch 1.1-7.jpp5 jpackage-generic 21 k maven2-plugin-war noarch 2.0.7-9.jpp5 jpackage-generic 53 k Installing for dependencies: giflib x86_64 4.1.3-7.1.el5_3.1 core-0 39 k java-1.6.0-openjdk x86_64 1:1.6.0.0-1.7.b09.el5 Ce5-x86_64-updates 27 M jettison noarch 1.1-1.el5 el5-x86_64-epel 55 k joda-time noarch 1.5.2-7.tzdata2008d.el5 el5-x86_64-epel 450 k maven-shared-archiver noarch 2.3-0.p8.5.jpp5 jpackage-generic 14 k wstx noarch 3.1.1-3.jpp5 jpackage-generic 928 k xstream noarch 1.3.1-1.jpp5 jpackage-generic 391 k Transaction Summary =========================================================================================================================== Install 9 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 29 M
droit d'acces aux webapps de tomcat
$ chgrp -R esup /usr/share/tomcat6/shared/ ; chmod -R 775 /usr/share/tomcat6/shared/
autrement:
/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/build.xml:298: java.io.FileNotFoundException: /usr/share/tomcat6/shared/lib/commons-logging-api-1.1.jar (Permission denied)
deploy-ear librarie
deploy des librairies necessaire au portail
[esup@esup3dev ~/src/esup-install]
$ ant deploy-ear
...
[exec] [INFO] Building jar: /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-ear-deployer/target/uportal-ear-deployer-3.1.2.jar
...
[exec] [INFO] [ear:ear]
[exec] [INFO] Copying artifact[war:org.jasig.portal:uportal-war:3.1.2] to[uPortal.war]
[exec] [INFO] Copying artifact[war:org.jasig.resourceserver:resource-server-webapp:1.0.5] to[ResourceServingWebapp.war]
[exec] [INFO] Copying artifact[jar:org.codehaus.castor:castor:1.1.1] to[castor-1.1.1.jar]
[exec] [INFO] Copying artifact[jar:javax.portlet:portlet-api:1.0] to[portlet-api-1.0.jar]
[exec] [INFO] Copying artifact[jar:org.apache.pluto:pluto-container:1.1.7] to[pluto-container-1.1.7.jar]
[exec] [INFO] Copying artifact[jar:org.jasig.service:person-directory-api:1.5.0-RC3] to[person-directory-api-1.5.0-RC3.jar]
[exec] [INFO] Copying artifact[jar:commons-logging:commons-logging-api:1.1] to[commons-logging-api-1.1.jar]
[exec] [INFO] Copying artifact[jar:org.apache.pluto:pluto-descriptor-api:1.1.7] to[pluto-descriptor-api-1.1.7.jar]
[exec] [INFO] Copying artifact[jar:org.apache.pluto:pluto-taglib:1.1.7] to[pluto-taglib-1.1.7.jar]
[exec] [INFO] Copying artifact[jar:org.apache.pluto:pluto-descriptor-impl:1.1.7] to[pluto-descriptor-impl-1.1.7.jar]
[exec] [INFO] Could not find manifest file: /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-ear/src/main/application/META-INF/MANIFEST.MF - Generating one
...
en effet apres le ant deploy on retrouve plusieurs librairies a ce niveau
$ ls -l /usr/share/tomcat6/shared/lib/ total 2028 -rw-rw-r-- 1 esup esup 1736099 Apr 29 14:11 castor-1.1.1.jar -rw-rw-r-- 1 esup esup 44598 Apr 29 14:11 commons-logging-api-1.1.jar -rw-rw-r-- 1 esup esup 3462 Apr 29 14:11 person-directory-api-1.5.0-RC3.jar -rw-rw-r-- 1 esup esup 142812 Apr 29 14:11 pluto-container-1.1.7.jar -rw-rw-r-- 1 esup esup 39406 Apr 29 14:11 pluto-descriptor-api-1.1.7.jar -rw-rw-r-- 1 esup esup 46472 Apr 29 14:11 pluto-descriptor-impl-1.1.7.jar -rw-rw-r-- 1 esup esup 25969 Apr 29 14:11 pluto-taglib-1.1.7.jar -rw-rw-r-- 1 esup esup 17090 Apr 29 14:11 portlet-api-1.0.jar
quand tout fonctionne cela doit finir sur:
fastWarDeploy:
[echo] extractWars=true
[echo] removeExisting=false
[mkdir] Created dir: /tmp/jasig/uPortal
[unwar] Expanding: /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-war/target/uPortal.war into /tmp/jasig/uPortal
[echo] Moving /tmp/jasig/uPortal to /usr/share/tomcat6/webapps
[move] Moving 2736 files to /usr/share/tomcat6/webapps
BUILD SUCCESSFUL
Total time: 2 minutes 5 seconds
DB init
initialisation ed la base de donnée. En esup3 cette etape est plus simplifiée, le mecanisme “d'import” changement completement le mode de fonctionnement par rapport a esup v2.x qui fonctionnais avec un fichier xml … . il n'y a plus les users de demo, canaux acessoires etc ..
La BD avant
mysql> use uportal3dev; Database changed mysql> show tables; Empty set (0.00 sec)
DB test
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.test
Buildfile: build.xml
db.test:
dbtest:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-523179059-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is not available or out-of-date, calling 'mvn install'
mvn:
[exec] [INFO] Scanning for projects...
[exec] [INFO] ----------------------------------------------------------------------------
[exec] [INFO] Building uPortal Source
[exec] [INFO] task-segment: [install]
[exec] [INFO] ----------------------------------------------------------------------------
[exec] [INFO] [enforcer:enforce {execution: enforce-versions}]
[exec] [INFO] [resources:resources]
[exec] [WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent!
[exec] [INFO] Copying 457 resources
[exec] [INFO] [compiler:compile]
[exec] [INFO] Compiling 69 source files to /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/classes
[exec] [INFO] [resources:testResources]
[exec] [WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent!
[exec] [INFO] Copying 44 resources
[exec] [INFO] [compiler:testCompile]
[exec] [INFO] Not compiling test sources
[exec] [INFO] [surefire:test]
[exec] [INFO] Tests are skipped.
[exec] [INFO] [jar:jar]
[exec] [INFO] Building jar: /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar
[exec] [INFO] [install:install]
[exec] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[exec] [INFO] ------------------------------------------------------------------------
[exec] [INFO] BUILD SUCCESSFUL
[exec] [INFO] ------------------------------------------------------------------------
[exec] [INFO] Total time: 38 seconds
[exec] [INFO] Finished at: Sun May 02 23:24:54 MSD 2010
[exec] [INFO] Final Memory: 41M/256M
[exec] [INFO] ------------------------------------------------------------------------
[echo] Invoking DbTest
[java] INFO Looking up bean 'PortalDb' in ApplicationContext due to context not yet being initialized
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@239cd5f5' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@560508be)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 18502ms
[java] INFO Looking up bean 'PortalDB.metadata' in ApplicationContext due to context not yet being initialized
[java] WARN The uPortal database is not initialized, the database tests will not be performed.
[java] INFO MySQL (5.0.77) / MySQL-AB JDBC Driver (mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )) database/driver
[java] Connected To: jdbc:mysql://bd3.it-sudparis.eu/uportal3dev
[java] WARNING: uPortal tables do no exist, not all meta-data tests were executed.
[java]
[java] Database name: 'MySQL'
[java] Database version: '5.0.77'
[java] Driver name: 'MySQL-AB JDBC Driver'
[java] Driver version: 'mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )'
[java] Driver class: 'MySQL-AB JDBC Driver'
[java] Connection URL: 'jdbc:mysql://bd3.it-sudparis.eu/uportal3dev'
[java] User: 'uportal@157.159.21.230'
[java]
[java] supportsANSI92EntryLevelSQL: true
[java] supportsANSI92FullSQL: false
[java] supportsCoreSQLGrammar: true
[java] supportsExtendedSQLGrammar: false
[java]
[java] supportsTransactions: true
[java] supportsMultipleTransactions: true
[java] supportsOpenCursorsAcrossCommit: false
[java] supportsOpenCursorsAcrossRollback: false
[java] supportsOpenStatementsAcrossCommit: false
[java] supportsOpenStatementsAcrossRollback: false
[java]
[java] supportsStoredProcedures: true
[java] supportsOuterJoins: true
[java] supportsFullOuterJoins: false
[java] supportsLimitedOuterJoins: true
[java] supportsBatchUpdates: true
[java] supportsColumnAliasing: true
[java] supportsExpressionsInOrderBy: true
[java] supportsOrderByUnrelated: false
[java] supportsPositionedDelete: false
[java] supportsSelectForUpdate: true
[java] supportsUnion: true
[java] supportsUnionAll: true
[java]
[java] getMaxColumnNameLength: 64
[java] getMaxColumnsInIndex: 16
[java] getMaxColumnsInOrderBy: 64
[java] getMaxColumnsInSelect: 256
[java] getMaxColumnsInTable: 512
[java] getMaxConnections: 0
[java] getMaxCursorNameLength: 64
[java] getMaxIndexLength: 256
[java] getMaxRowSize: 2147483639
[java] getMaxStatements: 0
[java] getMaxTableNameLength: 64
[java] getMaxTablesInSelect: 256
[java] getMaxUserNameLength: 16
[java] getSearchStringEscape: \
[java] getStringFunctions: ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER
[java] getSystemFunctions: DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION
[java] getTimeDateFunctions: DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
[java]
[java] Table Types: TABLE,VIEW,LOCAL TEMPORARY
[java] SQL Types: BIT,BOOL,TINYINT,TINYINT UNSIGNED,BIGINT,BIGINT UNSIGNED,LONG VARBINARY,MEDIUMBLOB,LONGBLOB,BLOB,TINYBLOB,VARBINARY,BINARY,LONG VARCHAR,MEDIUMTEXT,LONGTEXT,TEXT,TINYTEXT,CHAR,NUMERIC,DECIMAL,INTEGER,INTEGER UNSIGNED,INT,INT UNSIGNED,MEDIUMINT,MEDIUMINT UNSIGNED,SMALLINT,SMALLINT UNSIGNED,FLOAT,DOUBLE,DOUBLE PRECISION,REAL,VARCHAR,ENUM,SET,DATE,TIME,DATETIME,TIMESTAMP
BUILD SUCCESSFUL
Total time: 1 minute 16 seconds
DB init
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.init
Buildfile: build.xml
db.init:
prodPrompt:
db:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-838441650-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[echo] Invoking DbLoader
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@7878529d' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@4ab4faeb)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 18066ms
[java] INFO Dropping existing tables
[java] INFO drop table if exists UP_VERSIONS
[java] INFO drop table if exists UP_USER
[java] INFO drop table if exists UP_USER_PARAM
[java] INFO drop table if exists UP_USER_LOCALE
[java] INFO drop table if exists UP_PERSON_DIR
[java] INFO drop table if exists UP_PERMISSION
[java] INFO drop table if exists UP_USER_LAYOUT
[java] INFO drop table if exists UP_LAYOUT_STRUCT
[java] INFO drop table if exists UP_LAYOUT_STRUCT_LOCALE
[java] INFO drop table if exists UP_LAYOUT_PARAM
[java] INFO drop table if exists UP_CHANNEL
[java] INFO drop table if exists UP_CHANNEL_PARAM
[java] INFO drop table if exists UP_CHAN_TYPE
[java] INFO drop table if exists UP_SEQUENCE
[java] INFO drop table if exists UP_USER_UA_MAP
[java] INFO drop table if exists UP_USER_PROFILE
[java] INFO drop table if exists UP_USER_PROFILE_LOCALE
[java] INFO drop table if exists UP_SS_USER_PARM
[java] INFO drop table if exists UP_SS_USER_ATTS
[java] INFO drop table if exists UP_SS_THEME
[java] INFO drop table if exists UP_SS_THEME_PARM
[java] INFO drop table if exists UP_SS_STRUCT
[java] INFO drop table if exists UP_SS_STRUCT_PAR
[java] INFO drop table if exists UP_SS_MAP
[java] INFO drop table if exists UP_MIME_TYPE
[java] INFO drop table if exists UP_GROUP
[java] INFO drop table if exists UP_ENTITY_TYPE
[java] INFO drop table if exists UP_GROUP_MEMBERSHIP
[java] INFO drop table if exists UPC_PERM_MGR
[java] INFO drop table if exists UP_ENTITY_CACHE_INVALIDATION
[java] INFO drop table if exists UP_ENTITY_LOCK
[java] INFO drop table if exists UP_ENTITY_PROP
[java] INFO Creating tables
[java] INFO create table UP_VERSIONS (FNAME varchar(255) not null, MAJOR integer, MINOR integer, MICRO integer, DESCRIPTION varchar(255), primary key (FNAME), unique (FNAME, MAJOR, MINOR, MICRO)) type=InnoDB
[java] INFO create table UP_USER (USER_ID integer not null, USER_NAME varchar(35), USER_DFLT_USR_ID integer, USER_DFLT_LAY_ID integer, NEXT_STRUCT_ID integer, LST_CHAN_UPDT_DT datetime, primary key (USER_ID)) type=InnoDB
[java] INFO create table UP_USER_PARAM (USER_ID integer not null, USER_PARAM_NAME varchar(35) not null, USER_PARAM_VALUE varchar(255), primary key (USER_ID, USER_PARAM_NAME)) type=InnoDB
[java] INFO create table UP_USER_LOCALE (USER_ID integer not null, LOCALE varchar(64) not null, PRIORITY integer, primary key (USER_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_PERSON_DIR (USER_NAME varchar(35) not null, ENCRPTD_PSWD varchar(64), LST_PSWD_CGH_DT datetime, FIRST_NAME varchar(15), LAST_NAME varchar(15), EMAIL varchar(60), primary key (USER_NAME)) type=InnoDB
[java] INFO create table UP_PERMISSION (OWNER varchar(255), PRINCIPAL_TYPE integer, PRINCIPAL_KEY varchar(255), ACTIVITY varchar(255), TARGET varchar(255), PERMISSION_TYPE varchar(255), EFFECTIVE datetime, EXPIRES datetime) type=InnoDB
[java] INFO create table UP_USER_LAYOUT (LAYOUT_ID integer not null, USER_ID integer not null, LAYOUT_TITLE varchar(15), INIT_STRUCT_ID integer, primary key (LAYOUT_ID, USER_ID)) type=InnoDB
[java] INFO create table UP_LAYOUT_STRUCT (USER_ID integer not null, LAYOUT_ID integer not null, STRUCT_ID integer not null, NEXT_STRUCT_ID integer, CHLD_STRUCT_ID integer, EXTERNAL_ID varchar(64), CHAN_ID integer, NAME varchar(35), TYPE varchar(35), HIDDEN varchar(1), IMMUTABLE varchar(1), UNREMOVABLE varchar(1), primary key (LAYOUT_ID, USER_ID, STRUCT_ID)) type=InnoDB
[java] INFO create table UP_LAYOUT_STRUCT_LOCALE (USER_ID integer not null, LAYOUT_ID integer not null, NODE_ID integer not null, LOCALE varchar(64) not null, PRIORITY integer, primary key (USER_ID, LAYOUT_ID, NODE_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_LAYOUT_PARAM (USER_ID integer not null, LAYOUT_ID integer not null, STRUCT_ID integer not null, STRUCT_PARM_NM varchar(35) not null, STRUCT_PARM_VAL text not null, primary key (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM)) type=InnoDB
[java] INFO create table UP_CHANNEL (CHAN_ID integer not null, CHAN_TITLE varchar(128), CHAN_NAME varchar(128), CHAN_DESC varchar(255), CHAN_CLASS varchar(100), CHAN_TYPE_ID integer, CHAN_PUBL_ID integer, CHAN_PUBL_DT datetime, CHAN_APVL_ID integer, CHAN_APVL_DT datetime, CHAN_TIMEOUT integer, CHAN_EDITABLE varchar(1), CHAN_HAS_HELP varchar(1), CHAN_HAS_ABOUT varchar(1), CHAN_FNAME varchar(255), CHAN_SECURE varchar(1), primary key (CHAN_ID)) type=InnoDB
[java] INFO create table UP_CHANNEL_PARAM (CHAN_ID integer not null, CHAN_PARM_NM varchar(255) not null, CHAN_PARM_DESC varchar(255), CHAN_PARM_VAL text, CHAN_PARM_OVRD varchar(1), primary key (CHAN_ID, CHAN_PARM_NM)) type=InnoDB
[java] INFO create table UP_CHAN_TYPE (TYPE_ID integer not null, TYPE varchar(128) not null, TYPE_NAME varchar(70), TYPE_DESCR text, TYPE_DEF_URI varchar(255), primary key (TYPE_ID)) type=InnoDB
[java] INFO create table UP_SEQUENCE (SEQUENCE_NAME varchar(255) not null, SEQUENCE_VALUE integer, primary key (SEQUENCE_NAME)) type=InnoDB
[java] INFO create table UP_USER_UA_MAP (USER_ID integer, USER_AGENT varchar(255), PROFILE_ID integer) type=InnoDB
[java] INFO create table UP_USER_PROFILE (USER_ID integer not null, PROFILE_ID integer not null, PROFILE_NAME varchar(50), DESCRIPTION varchar(100), LAYOUT_ID integer, STRUCTURE_SS_ID integer, THEME_SS_ID integer, primary key (USER_ID, PROFILE_ID)) type=InnoDB
[java] INFO create table UP_USER_PROFILE_LOCALE (USER_ID integer not null, PROFILE_ID integer not null, LOCALE varchar(64) not null, PRIORITY integer, primary key (USER_ID, PROFILE_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_SS_USER_PARM (USER_ID integer not null, PROFILE_ID integer not null, SS_ID integer not null, SS_TYPE integer not null, PARAM_NAME varchar(100) not null, PARAM_VAL varchar(255), primary key (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME)) type=InnoDB
[java] INFO create table UP_SS_USER_ATTS (USER_ID integer not null, PROFILE_ID integer not null, SS_ID integer not null, SS_TYPE integer not null, STRUCT_ID integer not null, PARAM_NAME varchar(100) not null, PARAM_TYPE integer not null, PARAM_VAL varchar(255), primary key (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE)) type=InnoDB
[java] INFO create table UP_SS_THEME (SS_ID integer not null, SS_NAME varchar(255), SS_URI varchar(255), SS_DESCRIPTION_URI varchar(255), SS_DESCRIPTION_TEXT text, STRUCT_SS_ID integer, SAMPLE_ICON_URI varchar(255), SAMPLE_URI varchar(255), MIME_TYPE varchar(30), DEVICE_TYPE varchar(30), SERIALIZER_NAME varchar(255), UP_MODULE_CLASS varchar(255), primary key (SS_ID)) type=InnoDB
[java] INFO create table UP_SS_THEME_PARM (SS_ID integer not null, PARAM_NAME varchar(100) not null, PARAM_DEFAULT_VAL varchar(255), PARAM_DESCRIPT varchar(255), TYPE integer not null, primary key (SS_ID, PARAM_NAME, TYPE)) type=InnoDB
[java] INFO create table UP_SS_STRUCT (SS_ID integer not null, SS_NAME varchar(255), SS_URI varchar(255), SS_DESCRIPTION_URI varchar(255), SS_DESCRIPTION_TEXT text, primary key (SS_ID)) type=InnoDB
[java] INFO create table UP_SS_STRUCT_PAR (SS_ID integer not null, PARAM_NAME varchar(100) not null, PARAM_DEFAULT_VAL varchar(255), PARAM_DESCRIPT varchar(255), TYPE integer not null, primary key (SS_ID, PARAM_NAME, TYPE)) type=InnoDB
[java] INFO create table UP_SS_MAP (THEME_SS_ID integer, STRUCT_SS_ID integer, MIME_TYPE varchar(30)) type=InnoDB
[java] INFO create table UP_MIME_TYPE (MIME_TYPE varchar(30) not null, MIME_TYPE_DESCRIPTION text, primary key (MIME_TYPE)) type=InnoDB
[java] INFO create table UP_GROUP (GROUP_ID varchar(240) not null, CREATOR_ID varchar(240) not null, ENTITY_TYPE_ID integer not null, GROUP_NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (GROUP_ID)) type=InnoDB
[java] INFO create table UP_ENTITY_TYPE (ENTITY_TYPE_ID integer not null, ENTITY_TYPE_NAME varchar(255), DESCRIPTIVE_NAME varchar(255), primary key (ENTITY_TYPE_ID), unique (ENTITY_TYPE_NAME)) type=InnoDB
[java] INFO create table UP_GROUP_MEMBERSHIP (GROUP_ID varchar(200) not null, MEMBER_SERVICE varchar(80) not null, MEMBER_KEY varchar(200) not null, MEMBER_IS_GROUP varchar(1) not null, primary key (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)) type=InnoDB
[java] INFO create table UPC_PERM_MGR (IPERMISSIBLE_CLASS varchar(255) not null, primary key (IPERMISSIBLE_CLASS)) type=InnoDB
[java] INFO create table UP_ENTITY_CACHE_INVALIDATION (ENTITY_TYPE_ID integer not null, ENTITY_KEY varchar(240) not null, INVALIDATION_TIME datetime not null, ENTITY_CACHE_ID integer not null, primary key (ENTITY_TYPE_ID, ENTITY_KEY)) type=InnoDB
[java] INFO create table UP_ENTITY_LOCK (ENTITY_TYPE_ID integer not null, ENTITY_KEY varchar(240) not null, LOCK_TYPE integer not null, EXPIRATION_TIME datetime not null, LOCK_OWNER varchar(240) not null, primary key (ENTITY_TYPE_ID, ENTITY_KEY, LOCK_OWNER, EXPIRATION_TIME)) type=InnoDB
[java] INFO create table UP_ENTITY_PROP (ENTITY_TYPE_ID integer not null, ENTITY_KEY varchar(255) not null, PROPERTY_NAME varchar(150) not null, PROPERTY_VALUE varchar(255), LAST_MODIFIED datetime not null, primary key (ENTITY_TYPE_ID, ENTITY_KEY, PROPERTY_NAME)) type=InnoDB
[java] INFO create index UPU_DFLT_ID_IDX on UP_USER (USER_DFLT_USR_ID)
[java] INFO create index UPPD_NAME_PSWD_IDX on UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD)
[java] INFO create index UPPERM_IDX__PETYPE on UP_PERMISSION (PERMISSION_TYPE)
[java] INFO create index UPPERM_IDX__OWNER on UP_PERMISSION (OWNER)
[java] INFO create index UPPERM_IDX__PRKEY on UP_PERMISSION (PRINCIPAL_KEY)
[java] INFO create index UPPERM_IDX__TARGET on UP_PERMISSION (TARGET)
[java] INFO create index UPPERM_IDX__ACTIVITY on UP_PERMISSION (ACTIVITY)
[java] INFO create index UPPERM_IDX__PRTYPE on UP_PERMISSION (PRINCIPAL_TYPE)
[java] INFO create index UPCHAN_FNAME_IDX on UP_CHANNEL (CHAN_FNAME)
[java] INFO create index UPG_GROUP_NAME_IDX on UP_GROUP (GROUP_NAME)
[java] INFO Populating database
[java] INFO INSERT INTO UP_VERSIONS (FNAME, MAJOR, MINOR, MICRO, DESCRIPTION) VALUES (?, ?, ?, ?, ?) [UP_FRAMEWORK, 3, 1, 2, The uPortal Framework.] [12, 4, 4, 4, 12]
[java] INFO INSERT INTO UP_SEQUENCE (SEQUENCE_NAME, SEQUENCE_VALUE) VALUES (?, ?) [UP_GROUP, 10] [12, 4]
[java] INFO INSERT INTO UP_SS_MAP (THEME_SS_ID, STRUCT_SS_ID, MIME_TYPE) VALUES (?, ?, ?) [1, 1, text/html] [4, 4, 12]
[java] INFO INSERT INTO UP_MIME_TYPE (MIME_TYPE, MIME_TYPE_DESCRIPTION) VALUES (?, ?) [text/html, HTML mime type is the one that most desktop browsers use] [12, 12]
[java] INFO INSERT INTO UPC_PERM_MGR (IPERMISSIBLE_CLASS) VALUES (?) [org.jasig.portal.channels.permissionsmanager.PermissiblePublishChannels] [12]
[java] INFO INSERT INTO UPC_PERM_MGR (IPERMISSIBLE_CLASS) VALUES (?) [org.jasig.portal.channels.permissionsmanager.PermissibleSubscribeChannels] [12]
[java] INFO INSERT INTO UPC_PERM_MGR (IPERMISSIBLE_CLASS) VALUES (?) [org.jasig.portal.channels.groupsmanager.CGroupsManager] [12]
[java] INFO INSERT INTO UPC_PERM_MGR (IPERMISSIBLE_CLASS) VALUES (?) [org.jasig.portal.channels.error.SupportedPermissions] [12]
[java] INFO INSERT INTO UPC_PERM_MGR (IPERMISSIBLE_CLASS) VALUES (?) [org.jasig.portal.channels.cusermanager.CUserManager] [12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [admin, (MD5)OP2Z89LDMIY6gHAwfoFPRSQWDl5Z16Vt, null, Admin, User, admin.user@jasig.org] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [demo, (MD5)IAnYXaWGdqTkifNNwo0bfIIphj2NPvSG, null, Demo, User, demo.user@jasig.org] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [developer, (MD5)thUo6uSm62Jpj/ybqVyFy6bxJVWLgTnx, null, Developer, User, developer.user@jasig.org] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [ent-lo, (MD5)FwlZ/YNTQ/hbNPEIUl8yTGfYwwnp65/g, null, Entertainment, Layout Owner, null] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [faculty, (MD5)FoDMOEu9EMjbJ3bikDnqdFT0Tpd7xg6S, null, Faculty, User, faculty.user@jasig.org] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [fragmentTemplate, (MD5)TcJ+RAxMebVLfq2+xF1YY4Mv5dRGo7Rg, null, Fragment, Template, null] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [guest-lo, (MD5)NZpveCmtCTXi6qaq0Rx7O5HcQDEW3MTE, null, Guest, Layout Owner, null] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [news-lo, (MD5)d3ST813VSpkgg4g7mlVsK2T2pue7b9J6, null, News, Layout Owner, null] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [staff, (MD5)YGvCb8TdruiHaXdY9OvhRJ0MhwZYVTHa, null, Staff, User, staff.user@jasig.org] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [student, (MD5)mhmjKvf2F3gPizS9DrA+CsFmqj74oTSb, null, Student, User, student.user@jasig.org] [12, 12, 93, 12, 12, 12]
[java] INFO INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL) VALUES (?, ?, ?, ?, ?, ?) [welcome-lo, (MD5)d3ST813VSpkgg4g7mlVsK2T2pue7b9J6, null, Welcome, Layout Owner, password.that.of.news-lo@ja-sig.org] [12, 12, 93, 12, 12, 12]
prodPrompt:
db-hibernate:
prodPrompt:
db-hibernate-portal:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1060146756-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@4d74f02c' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@4ab4faeb)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 18433ms
[java] alter table UP_DLM_EVALUATOR_PAREN drop foreign key FK389B659C244DD4B5
[java] alter table UP_DLM_EVALUATOR_PAREN drop foreign key FK389B659C5BAB673E
[java] alter table UP_DLM_EVALUATOR_PAREN drop foreign key FK389B659CE342C201
[java] alter table UP_PORTLET_DEF drop foreign key FKF564C5C91ACC674
[java] alter table UP_PORTLET_ENT drop foreign key FKF56514291ACC674
[java] alter table UP_PORTLET_ENT drop foreign key FKF5651425D0D9A60
[java] alter table UP_PORTLET_PREF drop foreign key FKDB78E48C91ACC674
[java] alter table UP_PORTLET_PREF_VALUES drop foreign key FK608BB435807F1BE0
[java] drop table if exists UP_DLM_EVALUATOR
[java] drop table if exists UP_DLM_EVALUATOR_PAREN
[java] drop table if exists UP_PORTLET_DEF
[java] drop table if exists UP_PORTLET_ENT
[java] drop table if exists UP_PORTLET_PREF
[java] drop table if exists UP_PORTLET_PREFS
[java] drop table if exists UP_PORTLET_PREF_VALUES
[java] create table UP_DLM_EVALUATOR (DTYPE varchar(31) not null, evaluatorId bigint not null auto_increment, FRAGMENT_NAME varchar(255), OWNER_ID varchar(255), PRECEDENCE double precision, ATTRIBUTE_MODE integer, ATTRIBUTE_NAME varchar(255), ATTRIBUTE_VALUE varchar(255), EVALUATOR_MODE integer, GROUP_KEY varchar(255), GROUP_NAME varchar(255), PAREN_TYPE integer, primary key (evaluatorId)) type=InnoDB
[java] create table UP_DLM_EVALUATOR_PAREN (PAREN_EVAL_ID bigint not null, CHILD_EVAL_ID bigint not null, EVAL_INDEX integer not null, primary key (PAREN_EVAL_ID, EVAL_INDEX), unique (CHILD_EVAL_ID)) type=InnoDB
[java] create table UP_PORTLET_DEF (PORTLET_DEF_ID bigint not null auto_increment, CHANNEL_DEF_ID integer not null unique, PORTLET_PREFS_ID bigint not null, primary key (PORTLET_DEF_ID)) type=InnoDB
[java] create table UP_PORTLET_ENT (PORTLET_ENT_ID bigint not null auto_increment, CHANNEL_SUB_ID varchar(255) not null, USER_ID integer not null, PORTLET_DEF_ID bigint not null, PORTLET_PREFS_ID bigint not null, primary key (PORTLET_ENT_ID), unique (CHANNEL_SUB_ID, USER_ID)) type=InnoDB
[java] create table UP_PORTLET_PREF (PORTLET_PREF_ID bigint not null auto_increment, NAME text not null, READ_ONLY bit not null, PORTLET_PREFS_ID bigint, PREF_ORDER integer, primary key (PORTLET_PREF_ID)) type=InnoDB
[java] create table UP_PORTLET_PREFS (PORTLET_PREFS_ID bigint not null auto_increment, primary key (PORTLET_PREFS_ID)) type=InnoDB
[java] create table UP_PORTLET_PREF_VALUES (PORTLET_PREF_ID bigint not null, VALUE text, VALUE_ORDER integer not null, primary key (PORTLET_PREF_ID, VALUE_ORDER)) type=InnoDB
[java] alter table UP_DLM_EVALUATOR_PAREN add index FK389B659C244DD4B5 (PAREN_EVAL_ID), add constraint FK389B659C244DD4B5 foreign key (PAREN_EVAL_ID) references UP_DLM_EVALUATOR (evaluatorId)
[java] alter table UP_DLM_EVALUATOR_PAREN add index FK389B659C5BAB673E (PAREN_EVAL_ID), add constraint FK389B659C5BAB673E foreign key (PAREN_EVAL_ID) references UP_DLM_EVALUATOR (evaluatorId)
[java] alter table UP_DLM_EVALUATOR_PAREN add index FK389B659CE342C201 (CHILD_EVAL_ID), add constraint FK389B659CE342C201 foreign key (CHILD_EVAL_ID) references UP_DLM_EVALUATOR (evaluatorId)
[java] create index IDX_PORT_DEF__CHAN_DEF on UP_PORTLET_DEF (CHANNEL_DEF_ID)
[java] alter table UP_PORTLET_DEF add index FKF564C5C91ACC674 (PORTLET_PREFS_ID), add constraint FKF564C5C91ACC674 foreign key (PORTLET_PREFS_ID) references UP_PORTLET_PREFS (PORTLET_PREFS_ID)
[java] create index IDX_PORT_END__USR_CHAN_SUB on UP_PORTLET_ENT (CHANNEL_SUB_ID, USER_ID)
[java] alter table UP_PORTLET_ENT add index FKF56514291ACC674 (PORTLET_PREFS_ID), add constraint FKF56514291ACC674 foreign key (PORTLET_PREFS_ID) references UP_PORTLET_PREFS (PORTLET_PREFS_ID)
[java] alter table UP_PORTLET_ENT add index FKF5651425D0D9A60 (PORTLET_DEF_ID), add constraint FKF5651425D0D9A60 foreign key (PORTLET_DEF_ID) references UP_PORTLET_DEF (PORTLET_DEF_ID)
[java] alter table UP_PORTLET_PREF add index FKDB78E48C91ACC674 (PORTLET_PREFS_ID), add constraint FKDB78E48C91ACC674 foreign key (PORTLET_PREFS_ID) references UP_PORTLET_PREFS (PORTLET_PREFS_ID)
[java] alter table UP_PORTLET_PREF_VALUES add index FK608BB435807F1BE0 (PORTLET_PREF_ID), add constraint FK608BB435807F1BE0 foreign key (PORTLET_PREF_ID) references UP_PORTLET_PREF (PORTLET_PREF_ID)
prodPrompt:
db-hibernate-stats:
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@3844006e' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@2fc5809e)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 18801ms
prodPrompt:
i18n-db:
[echo] Invoking DbLoader for localizationed database setting
prodPrompt:
db:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1814146253-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[echo] Invoking DbLoader
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@4d74f02c' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@66a8a81c)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 18585ms
[java] INFO Dropping existing tables
[java] INFO drop table if exists UP_CHAN_TYPE_MDATA
[java] INFO drop table if exists UP_CHANNEL_MDATA
[java] INFO drop table if exists UP_LAYOUT_STRUCT_MDATA
[java] INFO drop table if exists UP_USER_PROFILE_MDATA
[java] INFO drop table if exists UP_USER_LAYOUT_MDATA
[java] INFO drop table if exists UP_USER_MDATA
[java] INFO Creating tables
[java] INFO create table UP_CHAN_TYPE_MDATA (TYPE_ID integer not null, LOCALE varchar(64) not null, TYPE_NAME varchar(70), TYPE_DESCR text, primary key (TYPE_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_CHANNEL_MDATA (CHAN_ID integer not null, LOCALE varchar(64) not null, CHAN_TITLE varchar(128), CHAN_NAME varchar(128), CHAN_DESC varchar(255), primary key (CHAN_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_LAYOUT_STRUCT_MDATA (USER_ID integer not null, LAYOUT_ID integer not null, STRUCT_ID integer not null, LOCALE varchar(64) not null, NAME varchar(35), primary key (USER_ID, LAYOUT_ID, STRUCT_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_USER_PROFILE_MDATA (USER_ID integer not null, PROFILE_ID integer not null, LOCALE varchar(64) not null, PROFILE_NAME varchar(50), DESCRIPTION varchar(100), primary key (USER_ID, PROFILE_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_USER_LAYOUT_MDATA (LAYOUT_ID integer not null, USER_ID integer not null, LOCALE varchar(64) not null, LAYOUT_TITLE varchar(128), primary key (LAYOUT_ID, USER_ID, LOCALE)) type=InnoDB
[java] INFO create table UP_USER_MDATA (USER_ID integer not null, LOCALE varchar(64) not null, primary key (USER_ID), unique (USER_ID, LOCALE)) type=InnoDB
[java] INFO Populating database
db.import:
prodPrompt:
crn-import:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1895810496-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java]
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@2140243b' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@54992725)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 18188ms
[java] Base Import Directory=/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/db/mini
[java] FILE_PATTERN=.*
[java] Import Entity Type: entity-type/java.lang.Object.entity-type
[java] INFO Looking up bean 'PortalDb' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'counterStore' in ApplicationContext due to context not yet being initialized
[java] Import Entity Type: entity-type/org.jasig.portal.ChannelDefinition.entity-type
[java] Import Entity Type: entity-type/org.jasig.portal.groups.IEntity.entity-type
[java] Import Entity Type: entity-type/org.jasig.portal.groups.IEntityGroup.entity-type
[java] Import Entity Type: entity-type/org.jasig.portal.security.IPermissionSet.entity-type
[java] Import Entity Type: entity-type/org.jasig.portal.security.IPerson.entity-type
[java] Import Entity Type: entity-type/org.jasig.portal.services.entityproperties.EntityProperties.entity-type
[java] Import Structure: structure/DLM_Tabs_and_columns.structure
[java] Import Theme: theme/DLM_XHTML.theme
[java] Import Template User: user/defaultTemplateUser.template-user
[java] Import User: user/admin-lo.user
[java] Import User: user/admin.user
[java] Import User: user/all-lo.user
[java] Import User: user/fragmentTemplate.user
[java] Import User: user/guest-lo.user
[java] Import User: user/guest.user
[java] Import User: user/system.user
[java] Import Group_Membership: group_membership/Administrateurs_Portail.group_membership
[java] Import Group_Membership: group_membership/Anonymes.group_membership
[java] Import Group_Membership: group_membership/Applications.group_membership
[java] Import Group_Membership: group_membership/Canaux_eSup.group_membership
[java] Import Group_Membership: group_membership/Canaux_uPortal.group_membership
[java] Import Group_Membership: group_membership/Proprietaires_de_fragment.group_membership
[java] Import Group_Membership: group_membership/Tout_le_monde.group_membership
[java] Import Group_Membership: group_membership/Toutes_les_categories.group_membership
[java] Import Memberships: group_membership/Administrateurs_Portail.group_membership
[java] Import Memberships: group_membership/Anonymes.group_membership
[java] Import Memberships: group_membership/Applications.group_membership
[java] Import Memberships: group_membership/Canaux_eSup.group_membership
[java] Import Memberships: group_membership/Canaux_uPortal.group_membership
[java] Import Memberships: group_membership/Proprietaires_de_fragment.group_membership
[java] Import Memberships: group_membership/Tout_le_monde.group_membership
[java] INFO Parsing group service configuration.
[java] INFO RDBMEntityGroupStore.initialize(): Node separator set to .
[java] INFO Looking up bean 'cacheFactory' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'entityCachingService' in ApplicationContext due to context not yet being initialized
[java] Import Memberships: group_membership/Toutes_les_categories.group_membership
[java] Import Channel Type: channel-type/Applet.channel-type
[java] Import Channel Type: channel-type/Bookmarks_Portlet.channel-type
[java] Import Channel Type: channel-type/Image.channel-type
[java] Import Channel Type: channel-type/Inline_Frame.channel-type
[java] Import Channel Type: channel-type/Portlet.channel-type
[java] Import Channel Type: channel-type/RSS.channel-type
[java] Import Channel Type: channel-type/SQL.channel-type
[java] Import Channel Type: channel-type/Simple_Web_Proxy_Portlet.channel-type
[java] Import Channel Type: channel-type/Version.channel-type
[java] Import Channel Type: channel-type/Web_Proxy.channel-type
[java] INFO Property [org.jasig.portal.MediaManager.HTMLPublicId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.HTMLSystemId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.XHTMLPublicId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.XHTMLSystemId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.WMLPublicId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.WMLSystemId] was requested but not found.
[java] Import Channel Type: channel-type/Web_Proxy_Portlet.channel-type
[java] Import Channel Type: channel-type/XML_SSL.channel-type
[java] Import Channel Type: channel-type/XML_XSLT.channel-type
[java] Import Channel: channel-esup/cas-test.channel
[java] INFO Looking up bean 'channelRegistryStore' in ApplicationContext due to context not yet being initialized
[java] INFO Join test failed: org.jasig.portal.rdbm.DatabaseMetaDataImpl$OracleDb on statement: 'SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0':
[java] StatementCallback; bad SQL grammar [SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND UP_USER.USER_ID=0' at line 1
[java] INFO Using join test: org.jasig.portal.rdbm.DatabaseMetaDataImpl$PostgreSQLDb
[java] INFO MySQL (5.0.77) / MySQL-AB JDBC Driver (mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )) database/driver
[java] Connected To: jdbc:mysql://bd3.it-sudparis.eu/uportal3dev
[java] Supports:
[java] Outer Joins: true
[java] {ts metasyntax: true
[java] TO_DATE(): false
[java] INFO Creating singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Adding destruction callback singleton for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Looking up bean 'jpaInterceptor' in ApplicationContext due to context not yet being initialized
[java] Import Channel: channel-esup/ent-info.channel
[java] Import Channel: channel-esup/esup-portail-nouvelles.channel
[java] Import Channel: channel-esup/esup-portail-rss.channel
[java] Import Channel: channel-esup/esup-portail.org.channel
[java] Import Channel: channel-esup/groups-id.channel
[java] Import Channel: channel-esup/https-test.channel
[java] Import Channel: channel-esup/param-test.channel
[java] Import Channel: channel-esup/ws-test.channel
[java] Import Channel: channel/AttributeSwapper.channel
[java] Import Channel: channel/IdentitySwapper.channel
[java] Import Channel: channel/admin.navigation.links.channel
[java] Import Channel: channel/css-viewer.channel
[java] Import Channel: channel/footer.channel
[java] Import Channel: channel/fragment-admin-exit.channel
[java] Import Channel: channel/fragment-admin.channel
[java] Import Channel: channel/groupsmanager.channel
[java] Import Channel: channel/header.channel
[java] Import Channel: channel/layout-sitemap.channel
[java] Import Channel: channel/missing-properties.channel
[java] Import Channel: channel/permissionsmanager.channel
[java] Import Channel: channel/person-attributes.channel
[java] Import Channel: channel/portal.channelmanager.general.channel
[java] Import Channel: channel/portal.login.general.channel
[java] Import Channel: channel/portal.userpreferences.dlm.channel
[java] Import Channel: channel/portal.userpreferences.general.channel
[java] Import Channel: channel/session-locales-selector.channel
[java] Import Channel: channel/skinselector.channel
[java] INFO Property [org.jasig.portal.layout.channels.CSkinSelector.skins_path] was requested but not found.
[java] Import Channel: channel/snooper.channel
[java] Import Channel: channel/thrower.channel
[java] Import Channel: channel/timeout.channel
[java] Import Channel: channel/user-locales-selector.channel
[java] Import Permission: permission/Administrateurs_Portail__MANAGE__CHAN_ID._94-.permission
[java] Import Permission Set: permission_set/Administrateurs_Portail__IMPERSONATE__system.permission_set
[java] Import Permission Set: permission_set/Administrateurs_Portail__MANAGE__UP_FRAMEWORK.permission_set
[java] Import Permission Set: permission_set/Administrateurs_Portail__PUBLISH__UP_FRAMEWORK.permission_set
[java] Import Permission Set: permission_set/Administrateurs_Portail__VIEW__UP_ERROR_CHAN.permission_set
[java] Import Permission Set: permission_set/Administrateurs_Portail__VIEW__UP_SECURE_INFO_CHAN.permission_set
[java] Import Permission Set: permission_set/Tout_le_monde__VIEW__org.jasig.portal.channels.groupsmanager.CGroupsManager.permission_set
[java] Import DLM Fragment Layout: fragment-layout/admin-lo.fragment-layout
[java] Import DLM Fragment Layout: fragment-layout/all-lo.fragment-layout
[java] Import DLM Fragment Layout: fragment-layout/guest-lo.fragment-layout
[java] Import Layout: layout/admin.layout
[java] Import Layout: layout/defaultTemplateUser.layout
[java] Import Layout: layout/fragmentTemplate.layout
[java] Import Layout: layout/guest.layout
[java] Import Layout: layout/system.layout
[java] Import of /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/db/mini Complete: 38331
BUILD SUCCESSFUL
Total time: 3 minutes 9 seconds
Au final, on a une base de donnée remplie de plusieurs tables:
mysql> show tables; +------------------------------+ | Tables_in_uportal3dev | +------------------------------+ | up_chan_type | | up_chan_type_mdata | | up_channel | | up_channel_mdata | | up_channel_param | | up_dlm_evaluator | | up_dlm_evaluator_paren | | up_entity_cache_invalidation | | up_entity_lock | | up_entity_prop | | up_entity_type | | up_group | | up_group_membership | | up_layout_param | | up_layout_struct | | up_layout_struct_locale | | up_layout_struct_mdata | | up_mime_type | | up_permission | | up_person_dir | | up_portlet_def | | up_portlet_ent | | up_portlet_pref | | up_portlet_pref_values | | up_portlet_prefs | | up_sequence | | up_ss_map | | up_ss_struct | | up_ss_struct_par | | up_ss_theme | | up_ss_theme_parm | | up_ss_user_atts | | up_ss_user_parm | | up_user | | up_user_layout | | up_user_layout_mdata | | up_user_locale | | up_user_mdata | | up_user_param | | up_user_profile | | up_user_profile_locale | | up_user_profile_mdata | | up_user_ua_map | | up_versions | | upc_perm_mgr | +------------------------------+ 45 rows in set (0.00 sec)
Lien apache
proxy AJP
On met apache en frontal avec le proxy-ajp
https://listes.esup-portail.org/sympa/arc/esup-utilisateurs/2010-04/msg00003.html
$ tail -3 /etc/httpd/conf.d/proxy_ajp.conf ProxyPass /uPortal ajp://localhost:8009/uPortal retry=1 ProxyPass /ResourceServingWebapp ajp://localhost:8009/ResourceServingWebapp retry=1
SSL
il faut une confiance entre le serveur CAS et le serveur du portail esup. c'est en certifiant le frontend apache que cette confiance (communication https entre CAS et uPortal/tomcat/apache) est réalisée. autrement on reçoit suite a une auth CAS ce genre d'erreure
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
⇒ cf ordre CA-chain ci-dessous !!
package ssl apache
sur le serveur uPortal on met en place un frontend apache pour recptionner les requetes https (443) du serveur CAS
[root@esup3dev ~] $ yum install mod_ssl
certificat TCS
signature d'un request de certificat par TCS, puis paramtrage apache mod_ssl
SSLCertificateFile /etc/pki/tls/certs/cert-1073-esup3dev.it-sudparis.eu.pem SSLCertificateKeyFile /etc/pki/tls/private/esup3dev-1073.key SSLCertificateChainFile /etc/pki/tls/certs/chain-1073-esup3dev.it-sudparis.eu.pem
Ordre de la CA-chain
https://listes.esup-portail.org/sympa/arc/esup-utilisateurs/2010-06/msg00049.html
Mathieu LARCHET a écrit : > Oui une dernière idée. > On a eu des soucis car la chaîne de certification présentée par Apache était dans le désordre (fichier addtrust_chain.pem) et provoquait ce genre d'erreur. > > Voici l'ordre tel qu'il doit être (à vérifier côté Apache CAS et Apache ENT) : > > subject= /C=NL/O=TERENA/CN=TERENA SSL CA > subject= /C=US/ST=UT/L=Salt Lake City/O=The USERTRUST Network/OU=http://www.usertrust.com/CN=UTN-USERFirst-Hardware > subject= /C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root Jehan Procaccia a ecrit : le site "officiel" une chaine AddTrust/Tenrena: $ wget http://www.cru.fr/_media/services/tcs/cachain.pem je renomme pour faire apparaitre l'ordre dans le nom de fichier $ cp cachain.pem cachain-TERENA_UTN-USERFirst-Hardware_AddTrust.pem effectivement celui livré à la signature (il y a ~3semaines) par la PKI TCS est en ordre inverse chain-1073-esup3dev.it-sudparis.eu.pem = Addtrust, puis UTN-USERFirst-Hardware et enfin TERENA :-( ! je corrige mes 2 frontaux apache (esup et CAS) avec : SSLCertificateChainFile /etc/pki/tls/certs/cachain-TERENA_UTN-USERFirst-Hardware_AddTrust.pem Cela marche .
test de validation ssl
[root@arvouin certs]# wget http://www.cru.fr/_media/services/tcs/add_trust_external_ca_root.pem [root@arvouin ~]# openssl s_client -connect esup3dev.it-sudparis.eu:443 -CAfile /etc/pki/tls/certs/add_trust_external_ca_root.pem -verify 3 verify depth is 3 CONNECTED(00000003) depth=3 /C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root verify return:1 depth=2 /C=US/ST=UT/L=Salt Lake City/O=The USERTRUST Network/OU=http://www.usertrust.com/CN=UTN-USERFirst-Hardware verify return:1 depth=1 /C=NL/O=TERENA/CN=TERENA SSL CA verify return:1 depth=0 /C=FR/L=Evry/O=T\xC3\xA9l\xC3\xA9com & Management SudParis/OU=DISI/CN=esup3dev.it-sudparis.eu verify return:1 --- Certificate chain 0 s:/C=FR/L=Evry/O=T\xC3\xA9l\xC3\xA9com & Management SudParis/OU=DISI/CN=esup3dev.it-sudparis.eu i:/C=NL/O=TERENA/CN=TERENA SSL CA 1 s:/C=NL/O=TERENA/CN=TERENA SSL CA i:/C=US/ST=UT/L=Salt Lake City/O=The USERTRUST Network/OU=http://www.usertrust.com/CN=UTN-USERFirst-Hardware 2 s:/C=US/ST=UT/L=Salt Lake City/O=The USERTRUST Network/OU=http://www.usertrust.com/CN=UTN-USERFirst-Hardware i:/C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root 3 s:/C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root i:/C=SE/O=AddTrust AB/OU=AddTrust External TTP Network/CN=AddTrust External CA Root
Tomcat serveur en https
Methode ancienne !! pour que le serveur tomcat soit reconnu par CAS en https, donc le serveur tomcat doit etre signé en tant que client CAS.
Racines de certification
ici nous cumulons plusieurs PKI, une ancienne PKI Institut Telecom v1 (pkiit1), une pkiit2 et maintenant la chaine de certification Addtrust (TCS / Renater). Ayant des serveurs (cas et autres) sur les 3 pki on prend de la marge en itegrant dans le keystore pour tomcat toute ces pki .
[root@esup3dev /etc/pki/tls/certs] $ ( cat itrootca.crt.1 ; cat itca.crt.1 ; cat tmspca.crt.1 ) > ca-chain-itrootca1-itca1-tmspca1.crt $ ( cat itrootca2.crt ; cat itca2.crt ; cat tmspca2.crt ) > ca-chain-itrootca2-itca2-tmspca2.crt $ ( cat cachain-tcs-addtrust.pem ; cat ca-chain-itrootca2-itca2-tmspca2.crt ; cat ca-chain-itrootca1-itca1-tmspca1.crt ) > ca-chain-tcs-addtrust-pkiit2-pkiit1-bundle.crt
generation du keystore
[root@esup3dev /etc/pki/tls/certs] $ openssl pkcs12 -export -in cert-1073-esup3dev.it-sudparis.eu.pem -inkey ../private/esup3dev-1073.key -out esup3dev_ca-chain-tcs-addtrust-pkiit2-pkiit1-bundle.p12 -name tomcat -CAfile ca-chain-tcs-addtrust-pkiit2-pkiit1-bundle.crt -caname root -chain Enter Export Password: Verifying - Enter Export Password:
verification
[root@esup3dev /etc/pki/tls/certs] $ keytool -keystore esup3dev_ca-chain-tcs-addtrust-pkiit2-pkiit1-bundle.p12 -list -storetype pkcs12 -v Keystore type: PKCS12 Keystore provider: SunJSSE Your keystore contains 1 entry Alias name: tomcat Creation date: Jun 9, 2010 Entry type: PrivateKeyEntry Certificate chain length: 4 Certificate[1]: Owner: CN=esup3dev.it-sudparis.eu, OU=DISI, O=Télécom & Management SudParis, L=Evry, C=FR Issuer: CN=TERENA SSL CA, O=TERENA, C=NL ... Certificate[4]: Owner: CN=AddTrust External CA Root, OU=AddTrust External TTP Network, O=AddTrust AB, C=SE Issuer: CN=AddTrust External CA Root, OU=AddTrust External TTP Network, O=AddTrust AB, C=SE Serial number: 1
contexts tomcat
definition du context uPortal et /ResourceServingWebapp pour tomcat, cf http://www.esup-portail.org/display/ESUPMU/Tomcat+en+production
<Context path="/uPortal"
docBase="/var/lib/tomcat6/webapps/uPortal"
crossContext="true"
reloadable="true">
<Resource name="jdbc/PortalDb"
auth="Container"
type="javax.sql.DataSource"
username="uportal" password="secret"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://bd3.it-sudparis.eu/uportal3dev?autoReconnect=true"
maxActive="50" maxIdle="30" maxWait="10000"
poolPreparedStatements="true"
removeAbandoned="true"
removeAbandonedTimeout="300"
/>
<Manager pathname="" />
</Context>
<Context path="/ResourceServingWebapp"
docBase="/var/lib/tomcat6/webapps/ResourceServingWebapp"
reloadable="false">
<Manager pathname=""/>
</Context>
</Host>
</Engine>
</Service>
</Server>
driver Mysql
il faut rendre accessible a tomcat le driver mysql autrement au demarrage du serveur on a ce type d'erreur:
May 25, 2010 9:27:29 PM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor uPortal.xml May 25, 2010 9:27:29 PM org.apache.catalina.startup.HostConfig deployDescriptor WARNING: A docBase /var/lib/tomcat6/webapps/uPortal inside the host appBase has been specified, and will be ignored Cannot load JDBC driver class 'com.mysql.jdbc.Driver' java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
copie du jar mysql
[root@esup3dev /etc/tomcat6] $ cp /home/esup/src/esup-3.1.2-esup-0.5-RC3/update/Tomcat/lib/mysql-connector-java-5.1.6.jar /var/lib/tomcat6/shared/lib/ [root@esup3dev /etc/tomcat6] $ ls -l /var/lib/tomcat6/shared/lib/ total 2720 -rw-rw-r-- 1 esup esup 1736099 Apr 30 15:55 castor-1.1.1.jar -rw-rw-r-- 1 esup esup 44598 Apr 30 15:55 commons-logging-api-1.1.jar -rw-r--r-- 1 root root 703265 May 25 21:33 mysql-connector-java-5.1.6.jar -rw-rw-r-- 1 esup esup 3462 Apr 30 15:55 person-directory-api-1.5.0-RC3.jar -rw-rw-r-- 1 esup esup 142812 Apr 30 15:55 pluto-container-1.1.7.jar -rw-rw-r-- 1 esup esup 39406 Apr 30 15:55 pluto-descriptor-api-1.1.7.jar -rw-rw-r-- 1 esup esup 46472 Apr 30 15:55 pluto-descriptor-impl-1.1.7.jar -rw-rw-r-- 1 esup esup 25969 Apr 30 15:55 pluto-taglib-1.1.7.jar -rw-rw-r-- 1 esup esup 17090 Apr 30 15:55 portlet-api-1.0.jar
Ldap users
groups sur attributs utilisateur
Rechercher les attributs utilisateur dans ldap, les attributs qu'on souhaite mapper pour chaque utilisateur dans ldap
custom.properties esup.ldap.persondirs.use=true
active la partie ldap du fichier /Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/contexts/personDirectoryContext.xml
on copie ce fichier pour eventullement le customiser:
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ mkdir -p custom/uPortal/uportal-impl/src/main/resources/properties/contexts/
ligne 265 *<bean id=“cachinguPortalLdapUserSource”* partie gauche nom de l'attribut ldap, droite nom de l'attribut uPortal
les groupes PAGS sont constitués sur des attributs utilisateurs et non sur des groupes ldap.
Group Ldap
group locaux
groups dans la BD esup . plus besoin de “groupLoader”, maintenant usage de db.import !
ce qui est deployé a l'initialisation d'esup (jasig)
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ ls Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/db/mini/ channel channel-type fragment-layout layout permission_set theme channel-esup entity-type group_membership permission structure user $ ls Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/db/mini/group_membership/ Administrateurs_Portail.group_membership Canaux_uPortal.group_membership Anonymes.group_membership Proprietaires_de_fragment.group_membership Applications.group_membership Toutes_les_categories.group_membership Canaux_eSup.group_membership Tout_le_monde.group_membership
import DB
avec db.import , chaque éléments de la BD uPortal est une “entité”, on peu appercevoir une liste d'entité (layout, channel, user …) dans ta tache crn-export du build.xml de uPortal:
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ vim Portail/uPortal_rel-3.1.2/build.xml
<target name="crn-export" description="Exports the specified entity or entities to XML on the file system">
<uportal-impl-macro>
<!-- Three properties control the export: dir, type, and sysid -->
<fail unless="type">
You must specify a "type" parameter (-Dtype={something}) from the following: all, layout,
all-layouts, channel, all-channels, all-permissions, all-memberships, group, all-groups, user,
all-users.
</fail>
DB export
exemple d'export des groups
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ mkdir -p custom/db-export
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.export -Ddir=/home/esup/src/esup-3.1.2-esup-0.5-RC3/custom/db-export/ -Dtype=all-groups
Buildfile: build.xml
db.export:
crn-export:
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@4eb64f2e' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@4a018e1b)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 27661ms
[java] Begin uPortal Export 'all-groups': 1276198629405
[java] Export Group: GROUP_NAME=Tout le monde
[java] Export Group: GROUP_NAME=Toutes les categories
[java] Export Group: GROUP_NAME=Anonymes
[java] Export Group: GROUP_NAME=Applications
[java] Export Group: GROUP_NAME=Canaux eSup
[java] Export Group: GROUP_NAME=Canaux uPortal
[java] Export Group: GROUP_NAME=Proprietaires de fragment
[java] Export Group: GROUP_NAME=Administrateurs Portail
[java] uPortal Export 'all-groups' Complete: 2195
BUILD SUCCESSFUL
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ls -l custom/db-export/group/
total 32
-rw-rw-r-- 1 esup esup 263 Jun 10 23:37 Administrateurs_Portail-2.group
-rw-rw-r-- 1 esup esup 244 Jun 10 23:37 Anonymes-11.group
-rw-rw-r-- 1 esup esup 242 Jun 10 23:37 Applications-12.group
-rw-rw-r-- 1 esup esup 240 Jun 10 23:37 Canaux_eSup-13.group
-rw-rw-r-- 1 esup esup 246 Jun 10 23:37 Canaux_uPortal-14.group
-rw-rw-r-- 1 esup esup 282 Jun 10 23:37 Proprietaires_de_fragment-15.group
-rw-rw-r-- 1 esup esup 260 Jun 10 23:37 Toutes_les_categories-1.group
-rw-rw-r-- 1 esup esup 250 Jun 10 23:37 Tout_le_monde-0.group
Smart ldap group
il semble y avoir un bug sur le recuperation de group ldap via SmartLdapGroupStoreConfig.xml …
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ ls Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/groups/ compositeGroupServices.xml PAGSGroupStoreConfig.xml SmartLdapGroupStoreConfig.xml LDAPGroupStoreConfig.xml pags.properties
Group PAGS
reference http://www.esup-portail.org/display/ESUPMU/Groupes+%28esup-3%29
Les group PAGS se basent sur des attributs utilisateur uPortal ⇒ il faut avoir fait le mapping d'attributs dans le “persondir” au prealable . L'appartenance a est groupe est calculé à la connexion au portail, on recupere ses attrribut utilisateur puis on verifie dans le fichier PAGS les groupes auquels il appartient ⇒ peformance, mais pas de possibilité de lister les membre d'un groupe PAGS
Activer la fonctionnalité groupePAGS:
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ echo "esup.ldap.groups.use=true" >> custom.properties
configurer les group PAGS, lesquels, sur quels attributs:
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ mkdir -p custom/uPortal/uportal-impl/src/main/resources/properties/groups [esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ cp Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/groups/PAGSGroupStoreConfig.xml custom/uPortal/uportal-impl/src/main/resources/properties/groups
dans une definition de type
<group-key>TousPers</group-key>
le clée sera Pags.TousPers !
personnaliser PAGSGroupStoreConfig.xml
exemple ajout de serv_disi et etab_tmsp:
<group>
<group-key>serv_disi</group-key>
<group-name>Service DISI (LDAP)</group-name>
<group-description>Tous les personnels de la DISI Evry</group-description>
<selection-test>
<test-group>
<test>
<attribute-name>supannAffectation</attribute-name>
<tester-class>org.jasig.portal.groups.pags.testers.StringEqualsIgnoreCaseTester</tester-class>
<test-value>S2IA</test-value>
</test>
</test-group>
</selection-test>
</group>
<group>
<group-key>etab_tmsp</group-key>
<group-name>Etablissement TMSP (LDAP)</group-name>
<group-description>Tous les personnels de TMSP</group-description>
<selection-test>
<test-group>
<test>
<attribute-name>eduPersonOrgUnitDN</attribute-name>
<tester-class>org.jasig.portal.groups.pags.testers.ValueExistsTester</tester-class>
<test-value>TMSP</test-value>
</test>
</test-group>
</selection-test>
</group>
Deployer ce PAGSGroupStoreConfig.xml via un ant init puis ant deploy, apres un redemarrage du portail on doit retrouver ces definitions de groupes. En tant qu'admin, dans le group Manager → *search group of person contains LDAP* on voit alors apparaitre nos definitions de groupe.
Attachement des PAGS
L'etape suivante est de ratacher ces groupes PAGS a des groupes locaux afin qu'ils apparaissent “proprement” dans le group Manager mais aussi qu'il y ait un hierarchie de groupe, donc heritage “deepMemberOf” …
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ mkdir -p custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership
on créé ici nos groupe LDAP et leur dependances hierarchiques .
ensuite on lance le db.import en s'assurant que l'on a pas fais d'erreur de syntaxe dans les noms de groupe (correspondance exacte entre le PAGSGroupStoreConfig.xml et les diffrent group attache dans les fihcier *.group_membership)! , autrement on reçoit des erreurs a l'import .
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.import -Ddir=/home/esup/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership/ Buildfile: build.xml
db.import:
prodPrompt:
crn-import:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1131381763-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java]
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@563b100c' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@68deeebd)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 5472ms
[java] Base Import Directory=/home/esup/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership/
[java] FILE_PATTERN=.*
[java] Import Group_Membership: Etablissements.group_membership
[java] Import Group_Membership: ITSP_groupes_LDAP.group_membership
[java] Import Group_Membership: Services.group_membership
[java] Import Group_Membership: Tout_le_monde.group_membership
[java] Import Memberships: Etablissements.group_membership
[java] INFO Parsing group service configuration.
[java] INFO RDBMEntityGroupStore.initialize(): Node separator set to .
[java] INFO Looking up bean 'cacheFactory' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'PortalDb' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'entityCachingService' in ApplicationContext due to context not yet being initialized
[java] Import Memberships: ITSP_groupes_LDAP.group_membership
[java] Import Memberships: Services.group_membership
[java] Import Memberships: Tout_le_monde.group_membership
[java] Import of /home/esup/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership/ Complete: 6082
BUILD SUCCESSFUL
Total time: 12 seconds
On a ainsi rattaché dans la BD uPortal les “enfants” du groupe local “Etablissements” qui comprendra (clés de groups) “pags.etab_tsp”, “pags.tab_tem” … dont les filtres ldap sont definis dans PAGSgroupStoreConfig.xml . CE fichier étant chargé au démarrage du portail, il faut le redémarrer pour toutes modifications
compositeGroupServices.xml definit le mecanisme de branchement des types de groupes. on constate qu'il y a a coté du PAGSGroupstore un LDAPGroupStoreConfig.xml qui fait des filtre ldap mais avec des performances tres mediocres !. smartldap autre gestionnaire qui se base sur le portail, pas les attributs ldap !.
Canaux
Exemple canal-hello
On positione les sources dans un arborescence dediée au canaux
[esup@esup3dev ~/src] $ mkdir canaux [esup@esup3dev ~/src] $ cp /tmp/esup-canal-hello-1.00.zip canaux/
Désarchivage
[esup@esup3dev ~/src/canaux] $ unzip esup-canal-hello-1.00.zip Archive: esup-canal-hello-1.00.zip creating: CHelloWorld-1.00/ creating: CHelloWorld-1.00/build/ creating: CHelloWorld-1.00/build/WEB-INF/ ...
recuperation du build.properties et adaptation des chemin a notre installation de package systemes a base de RPM (tomcat.home,
[esup@esup3dev ~/src/canaux/CHelloWorld-1.00] $ cp /tmp/build.properties ~/src/canaux/CHelloWorld-1.00/ $ vim build.properties #Répertoire d'installation de Tomcat #tomcat.home = /home/esup/tomcat tomcat.home = /usr/share/tomcat6 #Répertoire d'installation d'uPortal uportal.home = /home/esup/src/esup-install/Portail/uPortal_rel-3.1.2^M #Répertoire de déploiement #deploy.home = /home/esup/webapps/uPortal deploy.home = /usr/share/tomcat6/webapps
Pour la partie tomcat , dans les build.xml des canaux il y a une reference au common/lib de tomcat, d'où l'astuce de créer un lien de common/lib vers lib de tomcat , autrement le canal plante lors du deploiement (ne trouve pas servlet.jar, xmlapi …)
deploy
[esup@esup3dev ~/src/canaux/CHelloWorld-1.00]
$ ant deploy
Buildfile: build.xml
prepare:
[mkdir] Created dir: /home/esup/src/canaux/CHelloWorld-1.00/docs/api
[mkdir] Created dir: /home/esup/src/canaux/CHelloWorld-1.00/tests
[mkdir] Created dir: /home/esup/src/canaux/CHelloWorld-1.00/properties
[mkdir] Created dir: /home/esup/src/canaux/CHelloWorld-1.00/lib
[mkdir] Created dir: /home/esup/src/canaux/CHelloWorld-1.00/webpages/media/org/esupportail/portal/channels/CHelloWorld
[mkdir] Created dir: /home/esup/src/canaux/CHelloWorld-1.00/db
prepareINSTALL:
prepareUPGRADE:
prepareREADME:
prepareLICENCE:
prepareCHANGELOG:
compile:
deploy:
[copy] Copying 5 files to /usr/share/tomcat6/webapps
BUILD SUCCESSFUL
Total time: 0 seconds
publication
Répertoire custom pour heberger les fichier xml de publication systeme des canaux (equivalent de pubchan en 2.5)
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ mkdir -p custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel/
Copie du fichier de publication
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3] $ cp ~/src/canaux/CHelloWorld-1.00/CHello.channel ~/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel/
publication
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.import -Ddir=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel -Dpattern="CHello.channel"
Buildfile: build.xml
db.import:
prodPrompt:
crn-import:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1357606155-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java]
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@77cb8e0f' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@5f0704e1)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 3742ms
[java] Base Import Directory=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel
[java] FILE_PATTERN=CHello.channel
[java] Import Channel: CHello.channel
[java] INFO Looking up bean 'channelRegistryStore' in ApplicationContext due to context not yet being initialized
[java] INFO Join test failed: org.jasig.portal.rdbm.DatabaseMetaDataImpl$OracleDb on statement: 'SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0':
[java] StatementCallback; bad SQL grammar [SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND UP_USER.USER_ID=0' at line 1
[java] INFO Using join test: org.jasig.portal.rdbm.DatabaseMetaDataImpl$PostgreSQLDb
[java] INFO MySQL (5.0.77) / MySQL-AB JDBC Driver (mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )) database/driver
[java] Connected To: jdbc:mysql://bd3.it-sudparis.eu/uportal3dev
[java] Supports:
[java] Outer Joins: true
[java] {ts metasyntax: true
[java] TO_DATE(): false
[java] INFO Creating singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Adding destruction callback singleton for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Looking up bean 'PortalDb' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'jpaInterceptor' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'counterStore' in ApplicationContext due to context not yet being initialized
[java] WARN Unable to load class 'org.esupportail.portal.channels.CHelloWorld.CHelloWorld' for channel id=36, fname='canal-hello'
[java] INFO Parsing group service configuration.
[java] INFO RDBMEntityGroupStore.initialize(): Node separator set to .
[java] INFO Looking up bean 'cacheFactory' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'entityCachingService' in ApplicationContext due to context not yet being initialized
[java] Import of /home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel Complete: 4519
BUILD SUCCESSFUL
Total time: 9 seconds
publication de tous la canaux
avec l'expression reguliere -Dpattern=“.*\.channel” on import tous le fichiers de definition de canal
[esup@esup3dev ~/src/esup-install]
$ ant db.import -Ddir=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel -Dpattern=".*\.channel"
....
[java] Base Import Directory=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel
[java] FILE_PATTERN=.*\.channel
[java] Import Channel: Administration.channel
[java] INFO Looking up bean 'channelRegistryStore' in ApplicationContext due to context not yet being initialized
[java] INFO Join test failed: org.jasig.portal.rdbm.DatabaseMetaDataImpl$OracleDb on statement: 'SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0':
[java] StatementCallback; bad SQL grammar [SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID(+) AND UP_USER.USER_ID=0]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND UP_USER.USER_ID=0' at line 1
[java] INFO Using join test: org.jasig.portal.rdbm.DatabaseMetaDataImpl$PostgreSQLDb
[java] INFO MySQL (5.0.77) / MySQL-AB JDBC Driver (mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )) database/driver
[java] Connected To: jdbc:mysql://bd3.it-sudparis.eu/uportal3dev
[java] Supports:
[java] Outer Joins: true
[java] {ts metasyntax: true
[java] TO_DATE(): false
[java] INFO Creating singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Adding destruction callback singleton for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Using existing singleton instance for bean 'scopedTarget.sessionAttributesOverridesMap'
[java] INFO Looking up bean 'PortalDb' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'jpaInterceptor' in ApplicationContext due to context not yet being initialized
[java] INFO Parsing group service configuration.
[java] INFO RDBMEntityGroupStore.initialize(): Node separator set to .
[java] INFO Looking up bean 'cacheFactory' in ApplicationContext due to context not yet being initialized
[java] INFO Looking up bean 'entityCachingService' in ApplicationContext due to context not yet being initialized
[java] Import Channel: AssosAnciens.channel
[java] Import Channel: AssosEtudiants.channel
[java] Import Channel: CAnnuaire.channel
[java] WARN Unable to load class 'org.esupportail.portal.channels.CAnnuaire.CAnnuaire' for channel id=44, fname='null'
[java] WARN Unable to load class 'org.esupportail.portal.channels.CAnnuaire.CAnnuaire' for channel id=44, fname='CAnnuaire'
[java] Import Channel: CHello.channel
[java] WARN Unable to load class 'org.esupportail.portal.channels.CHelloWorld.CHelloWorld' for channel id=36, fname='null'
[java] WARN Unable to load class 'org.esupportail.portal.channels.CHelloWorld.CHelloWorld' for channel id=36, fname='canal-hello'
[java] Import Channel: CImap.channel
[java] WARN Unable to load class 'org.esupportail.portal.channels.CImap.CImap' for channel id=45, fname='null'
[java] WARN Unable to load class 'org.esupportail.portal.channels.CImap.CImap' for channel id=45, fname='Cimap'
[java] Import Channel: CStockage.channel
[java] WARN Unable to load class 'org.esupportail.portal.channels.CStockage.CStockage' for channel id=46, fname='null'
[java] WARN Unable to load class 'org.esupportail.portal.channels.CStockage.CStockage' for channel id=46, fname='CStockage'
[java] Import Channel: CanalU.channel
[java] Import Channel: Catalogues.channel
[java] Import Channel: EvryPratique.channel
[java] Import Channel: Gaspar.channel
[java] Import Channel: Handicap.channel
[java] Import Channel: Infopedia.channel
[java] Import Channel: MaisonEleves.channel
[java] Import Channel: MotPasse.channel
[java] Import Channel: Nuxeo.channel
[java] Import Channel: OpenPortal.channel
[java] Import Channel: Presentation.channel
[java] Import Channel: ReglementScola.channel
[java] Import Channel: Signets.channel
[java] WARN Unable to load class 'org.esupportail.portal.channels.CSignet2.CSignet2' for channel id=59, fname='null'
[java] WARN Unable to load class 'org.esupportail.portal.channels.CSignet2.CSignet2' for channel id=59, fname='CSignet2'
[java] Import Channel: Sympa.channel
[java] WARN Unable to load class 'org.esupportail.portal.channels.CSympaMultiServeur.CSympaMultiServeur' for channel id=60, fname='null'
[java] WARN Unable to load class 'org.esupportail.portal.channels.CSympaMultiServeur.CSympaMultiServeur' for channel id=60, fname='Sympa'
[java] Import Channel: Webmail.channel
[java] Import Channel: Wifi.channel
[java] INFO Property [org.jasig.portal.MediaManager.HTMLPublicId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.HTMLSystemId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.XHTMLPublicId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.XHTMLSystemId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.WMLPublicId] was requested but not found.
[java] INFO Property [org.jasig.portal.MediaManager.WMLSystemId] was requested but not found.
[java] Import Channel: inlineMeteo.channel
[java] Import of /home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/channel Complete: 4456
BUILD SUCCESSFUL
Total time: 8 seconds
Canal Stockage
reference: http://www.esup-portail.org/display/PROJCANSTOCK/Canal+stockage
[esup@esup3dev ~/src/canaux] $ wget https://sourcesup.cru.fr/frs/download.php/2900/esup-canal-stockage-4.7-RC-2.zip [esup@esup3dev ~/src/canaux] $ unzip esup-canal-stockage-4.7-RC-2.zip
Dependance MAG
http://www.esup-portail.org/pages/viewpage.action?pageId=5865511
[esup@esup3dev ~/src/canaux] $ wget http://www.esup-portail.org/download/attachments/5865511/esup-utils-mag-2.5.zip [esup@esup3dev ~/src/canaux] $ unzip esup-utils-mag-2.5.zip [esup@esup3dev ~/src/canaux/esup-utils-mag-2.5] $ diff -ur build.properties.orig build.properties --- build.properties.orig 2010-08-25 16:38:19.000000000 +0200 +++ build.properties 2010-08-25 16:39:33.000000000 +0200 @@ -8,14 +8,13 @@ #R�pertoire d'installation de Tomcat -tomcat.home = /home/uportal/PROD/Tomcat +tomcat.home = /usr/share/tomcat6 -#R�pertoire d'installation d'uPortal -uportal.home = /home/uportal/BUILD/uPortal-sources - -#R�pertoire de d�ploiement -deploy.home = /home/uportal/PROD/webapps/uPortal +#Repertoire d'installation d'uPortal +uportal.home = /home/esup/src/esup-install/Portail/uPortal_rel-3.1.2 +#Repertoire de deploiement +deploy.home = /usr/share/tomcat6/webapps/uPortal
[esup@esup3dev ~/src/canaux/esup-utils-mag-2.5] $ ant all BUILD FAILED /home/esup/src/canaux/esup-utils-mag-2.5/build.xml:155: /home/esup/src/esup-install/Portail/uPortal_rel-3.1.2/lib not found.
alors
[esup@esup3dev ~/src/canaux/esup-utils-mag-2.5] $ mkdir /home/esup/src/esup-install/Portail/uPortal_rel-3.1.2/lib
puis erreur
compile:
[javac] Compiling 25 source files to /home/esup/src/canaux/esup-utils-mag-2.5/build/WEB-INF/classes
[javac] /home/esup/src/canaux/esup-utils-mag-2.5/source/org/esupportail/portal/utils/channels/ConfigChannel.java:7: package javax.servlet.jsp does not exist
alors
$ diff -ur build.xml.orig build.xml
--- build.xml.orig 2010-08-25 17:15:38.000000000 +0200
+++ build.xml 2010-08-25 17:17:05.000000000 +0200
@@ -62,6 +62,9 @@
<!-- Les lib de Tomcat -->
<fileset dir="${tomcat.home}/common/lib" includes="**/*.jar" />
+ <!-- https://listes.esup-portail.org/sympa/arc/esup-utilisateurs/2010-02/msg00099.html -->
+ <fileset dir="${tomcat.home}/lib" includes="**/*.jar" />
+
[esup@esup3dev ~/src/canaux/esup-utils-mag-2.5]
$ ant all
Buildfile: build.xml
clean:
[delete] Deleting directory /home/esup/src/canaux/esup-utils-mag-2.5/build
undeploy:
prepare:
[mkdir] Created dir: /home/esup/src/canaux/esup-utils-mag-2.5/build
[mkdir] Created dir: /home/esup/src/canaux/esup-utils-mag-2.5/build/WEB-INF/classes
prepareINSTALL:
prepareUPGRADE:
prepareREADME:
prepareLICENCE:
prepareCHANGELOG:
compile:
[javac] Compiling 25 source files to /home/esup/src/canaux/esup-utils-mag-2.5/build/WEB-INF/classes
[javac] /home/esup/src/canaux/esup-utils-mag-2.5/source/org/esupportail/portal/utils/channels/ConfigChannel.java:59: warning: [deprecation] DEBUG in org.apache.log4j.Priority has been deprecated
[javac] logLevel = Priority.DEBUG;
[javac] ^
[javac] /home/esup/src/canaux/esup-utils-mag-2.5/source/org/esupportail/portal/utils/channels/SubChannel.java:201: warning: [deprecation] getBaseWorkerURL(java.lang.String,boolean) in org.jasig.portal.ChannelRuntimeData has been deprecated
[javac] xslParameters.put("baseDownloadURL",runtimeData.getBaseWorkerURL(UPFileSpec.FILE_DOWNLOAD_WORKER, true).replaceAll("%2F", "/"));
[javac] ^
[javac] /home/esup/src/canaux/esup-utils-mag-2.5/source/org/esupportail/portal/utils/channels/SubChannelAjax.java:116: warning: [deprecation] getBaseActionURL(boolean) in org.jasig.portal.ChannelRuntimeData has been deprecated
[javac] getXSLParameter().put("baseActionURL",runtimeData.getBaseActionURL(true));
[javac] ^
[javac] /home/esup/src/canaux/esup-utils-mag-2.5/source/org/esupportail/portal/utils/channels/SubChannelAjax.java:211: warning: [deprecation] getBaseActionURL(boolean) in org.jasig.portal.ChannelRuntimeData has been deprecated
[javac] String redirect = runtimeData.getBaseActionURL(true) + "?";
[javac] ^
[javac] Note: Some input files use unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.
[javac] 4 warnings
[copy] Copying 2 files to /home/esup/src/canaux/esup-utils-mag-2.5/build/WEB-INF/classes/properties/channels/org_esup/esup-utils-mag
[copy] Copying 5 files to /home/esup/src/canaux/esup-utils-mag-2.5/build/WEB-INF/classes
[copy] Copying 10 files to /home/esup/src/canaux/esup-utils-mag-2.5/build/media
deploy:
[copy] Copying 42 files to /usr/share/tomcat6/webapps/uPortal
all:
BUILD SUCCESSFUL
Total time: 1 second
fragments
ils permettent d'affecter automatiquement un ensemble de contenu a une population. il faut preparer des contenu ciblé, onglet, colonne , canaux pour qu'une population est ce pre-remplissage a la connexion .
Deux composantes:
- definition du fragment (nom-destination) properties/dlm.xml,
- puis ralisation du contenu du fragment
definition
ownerID pour trouver le contenu de ce fragment, on crée un utilisateur pour lequel on crée un environement onglets/canaux/colones et on definit le fragment X comme etant l'environement de l'utilisateur X-lo (LayOut) .
bonne pratique creer un fragment par onglet afin de pouvoir intercaler de nouveaux onglets en cours d'année, idem pour les precedences (10-20-30 …), se garder du mou …
audiance ⇒ deepMemberOf de “tout le monde” (heritage), mais memberOf “eteblissement X” = attachement direct a ce group (feuille).
users-lo
l'option d'import/création d'un utilisateur pour gérer les fragments façon 2.6 n'est plus recommandée: *ant useradd + mot de passe*
en Esup3 la simple déclaration du user-lo dans le fichier dlm.xml créé automatiquement l'utilisateur . comme il n'a pas de mot de passe, on peut se connecter en tant qu'admin puis graphiquement → fragment Administrator → guest → on est connecté en tant que guest-lo et ainsi on peux manipuler graphiquement son environnement (memorisé en BD) puis fait un BD.export du layout .
Principes d'usage, la partie anonyme du portail sur le compte guest-lo, puis personnel-lo et etudiants-lo.
définition des utilisateurs
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/utilisateurs] $ ls enseignant-lo.user etudiant-lo.user personnel-lo.user [esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/utilisateurs] $ cat enseignant-lo.user <user script="classpath://org/jasig/portal/io/import-user_v3-0.crn" username="enseignant-lo"> <default-user>defaultTemplateUser</default-user> </user>
import des utilisateurs
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.import -Ddir=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/utilisateurs/
Buildfile: build.xml
db.import:
prodPrompt:
crn-import:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1136063799-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java]
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@54dbb83a' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@45d18084)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 3734ms
[java] Base Import Directory=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/utilisateurs/
[java] FILE_PATTERN=.*
[java] Import User: enseignant-lo.user
[java] INFO Looking up bean 'counterStore' in ApplicationContext due to context not yet being initialized
[java] Import User: etudiant-lo.user
[java] Import User: personnel-lo.user
[java] Import of /home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/utilisateurs/ Complete: 4148
BUILD SUCCESSFUL
Total time: 8 seconds
il est de bon usage d'ajouter ces utilisateurs au groupe “proprietaire de fragment” pour faciliter la gestion graphique de ces comptes
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership]
$ cat Proprietaires_de_fragment.group_membership
<group script="classpath://org/jasig/portal/io/import-group_membership_v3-0.crn">
<name>Proprietaires de fragment</name>
<entity-type>org.jasig.portal.security.IPerson</entity-type>
<creator>system</creator>
<description>These are fragment layout owner accounts</description>
<children>
<literal>admin-lo</literal>
<literal>all-lo</literal>
<literal>fragmentTemplate</literal>
<literal>guest-lo</literal>
<literal>personnel-lo</literal>
<literal>enseignant-lo</literal>
<literal>etudiant-lo</literal>
</children>
</group>
db import
[esup@esup3dev ~/src/esup-3.1.2-esup-0.5-RC3]
$ ant db.import -Ddir=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership/ -Dpattern="Proprietaires_de_fragment.*\.group_membership"
Buildfile: build.xml
db.import:
prodPrompt:
crn-import:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1791558980-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java]
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@54dbb83a' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@45d18084)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 3972ms
[java] Base Import Directory=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership/
[java] FILE_PATTERN=Proprietaires_de_fragment.*\.group_membership
[java] Import Group_Membership: Proprietaires_de_fragment.group_membership
[java] Import Memberships: Proprietaires_de_fragment.group_membership
[java] Import of /home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/group_membership/ Complete: 4306
BUILD SUCCESSFUL
Total time: 8 seconds
Fragments Import XML
on prepare nos fragments par type de population (associées aux utilisateurs modeles)
[esup@esup3dev ~/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/fragments] $ ls admin-lo.fragment-layout enseignant-lo.fragment-layout guest-lo.fragment-layout all-lo.fragment-layout etudiant-lo.fragment-layout personnel-lo.fragment-layout
Fragments par GUI
on peux aussi les administrer via l'interface web du portail, via le Canal “Fragment Administration”
import des xml
[esup@esup3dev ~/src/esup-install]
$ ant db.import -Ddir=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/fragments/
Buildfile: build.xml
db.import:
prodPrompt:
crn-import:
install-parent-pom:
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/pom.xml to /home/esup/.m2/repository/org/jasig/portal/uportal-parent/3.1.2/uportal-parent-3.1.2.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-1466962851-marker
[echo] Artifact '/home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar' is up-to-date
[artifact:install] [INFO] Installing /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/target/uportal-impl-3.1.2.jar to /home/esup/.m2/repository/org/jasig/portal/uportal-impl/3.1.2/uportal-impl-3.1.2.jar
[java]
[java] INFO Creating new lazily initialized GenericApplicationContext for the portal
[java] INFO Created new MemoryContext with environment '{java.naming.factory.url.pkgs=tyrex.naming, java.naming.provider.url=, java.naming.factory.initial=org.jasig.portal.jndi.DisposableMemoryContextFactory}'
[java] INFO Initialized portal JNDI context
[java] INFO Failed to load bean 'PortalDb.JNDI' from ApplicationContext expecting type: interface javax.sql.DataSource. Will try to load the next bean in the list instead. Error message from the attempt to load this bean ('PortalDb.JNDI'): Error creating bean with name 'PortalDb.JNDI' defined in class path resource [properties/contexts/datasourceContext.xml]: Invocation of init method failed; nested exception is javax.naming.NotContextException: comp is not a subcontext (enable debug for stack trace)
[java] INFO Loaded bean for name PortalDb.direct
[java] INFO Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@77cb8e0f' on ThreadLocal
[java] AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@5f0704e1)
[java] LogAbandoned: true
[java] RemoveAbandoned: true
[java] RemoveAbandonedTimeout: 300
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 3831ms
[java] Base Import Directory=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/fragments/
[java] FILE_PATTERN=.*
[java] Import DLM Fragment Layout: admin-lo.fragment-layout
[java] Import DLM Fragment Layout: all-lo.fragment-layout
[java] Import DLM Fragment Layout: enseignant-lo.fragment-layout
[java] Import DLM Fragment Layout: etudiant-lo.fragment-layout
[java] Import DLM Fragment Layout: guest-lo.fragment-layout
[java] Import DLM Fragment Layout: personnel-lo.fragment-layout
[java] Import of /home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/fragments/ Complete: 5622
BUILD SUCCESSFUL
Total time: 10 seconds
DLM
Skin
skinList
principe de separation entre le html et la css
on peux avoir plusieurs css et l'utilisateur passe de l'une a l'autre. Quand on desactive la css on a un portail “serialisé” voire “accessible” … 
Fichier skinList.xml de base avec 2 skin
uportal-war/src/main/webapp/media/skins/universality/skinList.xml
pour notre skin on reprend ce fichier dans custom
[esup@esup3prod ~/src/esup-install/custom/uPortal] $ mkdir -p uportal-war/src/main/webapp/media/skins/universality/ [esup@esup3prod ~/src/esup-install/custom/uPortal] $ cp ~/src/esup-install/Portail/uPortal_rel-3.1.2/uportal-war/src/main/webapp/media/skins/universality/skinList.xml uportal-war/src/main/webapp/media/skins/universality/
et on l'edit pour ajouter la notre
[esup@esup3prod ~/src/esup-install/custom/uPortal] $ vim uportal-war/src/main/webapp/media/skins/universality/skinList.xml $ diff uportal-war/src/main/webapp/media/skins/universality/skinList.xml ~/src/esup-install/Portail/uPortal_rel-3.1.2/uportal-war/src/main/webapp/media/skins/universality/skinList.xml 27,34d26 < < <skin> < <skin-key>itsp</skin-key> < <skin-name>Campus</skin-name> < <skin-description> < Skin de Telecom SudParis et Telecom Ecole de Management. < </skin-description> < </skin>
Skin maison
Creation d'une skin itsp, preparation de l'arborescence custom et definition des css etc … (ici reprise sur une machine de dev)
[esup@esup3prod ~/src/esup-install/custom/uPortal] $ mkdir -p uportal-war/src/main/webapp/media/skins/universality/itsp/ [esup@gaspar-dev universality]$ scp -r itsp/* root@esup3prod.it-sudparis.eu:/home/esup//src/esup-install/custom/uPortal/uportal-war/src/main/webapp/media/skins/universality/itsp
le point d'entrée est itsp.css qui fait des import des autres.
ensuite pour mettre en ligne on init et deploy
skin par defaut
le changement du theme par defaut se via le fichier qui gere le profile DLM XML DLM_XHTML.theme a recopier dans notre custom .
[esup@esup3prod ~/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp] $ cp /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/db/mini/theme/DLM_XHTML.theme ./theme
modification
[esup@esup3prod ~/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/theme] $ diff DLM_XHTML.theme /home/esup/src/esup-3.1.2-esup-0.5-RC3/Portail/uPortal_rel-3.1.2/uportal-impl/src/main/resources/properties/db/mini/theme/DLM_XHTML.theme 23c23 < <value>itsp</value> --- > <value>uportal3</value> 28c28 < </theme> --- > </theme>
importation de cette nouvelle xsl
[esup@esup3prod ~/src/esup-install]
$ ant db.import -Ddir=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/theme/
Buildfile: build.xml
...
[java] Base Import Directory=/home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/theme/
[java] FILE_PATTERN=.*
[java] Import Theme: DLM_XHTML.theme
[java] Import of /home/esup/src/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/theme/ Complete: 3353
BUILD SUCCESSFUL
Total time: 7 seconds
Tout utilisateur ayant deja personnelement changer son skin, le gardera , donc si on le fait trop tard il faut modifier dans le BD le choix du skin pour chaque users !
Tutoriel esup3 en video
Vidéo tutoriel eSup V3
http://mediatheque.parisdescartes.fr/rubrique.php3?id_rubrique=706&tri=titre
http://www.esup-portail.org/pages/viewpage.action?pageId=88244244
sujets video1
9mn tomcat5 → tomcat6 /lib (vs common - shared)
34mn context /cas et serialisation de sessions au demarrage/arret
39mn installation du portail
41,30 java_home build.properties
42 tomcat.update mettre les jar dont esup a besoin dans tomcat, lors du deployement il les met là où il faut . true une fois, puis a false , sauf si necessité d'une MAJ
47 real.host quand load balancing
/guest acces a un canal en mode non authentifié
48 context uportal et contexServingWebapps
54 sidebar de gauche uportalv3 desactivé
60 ant get-components (chercher le uportal du jasig)
61 ant unzip decompacte les zip des package exterieurs esup* ant init prend les update esup les copie dans uportal et customisation dans uportal * ant deploy compile les class (1 milliers !) et les deploient dans webapps/esup-portail * ant db_init cree les tables
video2
- 20mn le compte admin:
handler file webapps/cas/WEB-INF/usersFile login::md5password
- 27mn ldap persondir
- 38mn ldap groups, smartGroupstore
- 46mn group locaux
- 52mn db.import
video3
- 0,30mn rappel group PAGS
- 10mn rattachement des groupe PAGS ldap au groupe locaux en db.import
- 15mn discussion sur les types de groups (pags, ldap, smart …)
- 26mn publication d'un canal
- 38mn les fragments
- 48mn users-lo; utilisateurs modeles de layout
- 51mn DLM
video4
- 0mn contenu des fragments
- 14mn fragment cache: fragment_cache_refresh 5mn par defaut
- 25mn allow disallow move colonne, canal etc …
- 26mn un fragment commun webmail mais avec cannal iframe masqué par type de population, droits des canaux
- 28,5mn Skin
- 35mn skin par defaut , 35,5 principe de generation xsl structure → xsl theme
- 41,20 choix du theme par population; uPortalTemplateUserName