Socle Esup 3.1

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

Java JDK

depuis le package non-free de jpackage, nous avons recompilé sur un repository maison

[root@esup32dev yum.repos.d]# yum install java-1.6.0-sun-devel

===========================================================================================================================
 Package                           Arch                Version                         Repository                     Size
===========================================================================================================================
Installing:
 java-1.6.0-sun-devel              i586                1.6.0.21-1jpp                   el5-i386-perso                 23 M
Installing for dependencies:
 freetype                          i386                2.2.1-28.el5_5.1                core-0                        312 k
 java-1.6.0-sun                    i586                1.6.0.21-1jpp                   el5-i386-perso                 43 M
 jpackage-utils                    noarch              5.0.0-2.jpp5                    jpackage-generic               72 k
 libX11                            i386                1.0.3-11.el5                    core-0                        796 k
 libXau                            i386                1.0.1-3.1                       core-0                         18 k
 libXdmcp                          i386                1.0.1-2.1                       core-0                         19 k
 libXext                           i386                1.0.1-2.1                       core-0                         35 k
 libXfont                          i386                1.2.2-1.0.3.el5_1               core-0                        241 k
 libXi                             i386                1.0.1-4.el5_4                   core-0                         25 k
 libXtst                           i386                1.0.1-3.1                       core-0                         15 k
 libfontenc                        i386                1.0.2-2.2.el5                   core-0                         19 k
 xorg-x11-filesystem               noarch              7.1-2.fc6                       core-0                        5.4 k
 xorg-x11-font-utils               i386                1:7.1-3                         Ce5-i386-updates               76 k

Transaction Summary
===========================================================================================================================
Install      14 Package(s)
Upgrade       0 Package(s)

Total download size: 68 M
Is this ok [y/N]: y

au final entre le jdk et le jre java-sun nous avons

[root@esup32dev ~]# ls -l /usr/lib/jvm/
total 4
lrwxrwxrwx 1 root root   26 May 20 12:18 java -> /etc/alternatives/java_sdk
lrwxrwxrwx 1 root root   32 May 20 12:18 java-1.6.0 -> /etc/alternatives/java_sdk_1.6.0
lrwxrwxrwx 1 root root   23 May 20 12:18 java-1.6.0-sun -> java-1.6.0-sun-1.6.0.21
drwxr-xr-x 6 root root 4096 May 20 12:18 java-1.6.0-sun-1.6.0.21
lrwxrwxrwx 1 root root   30 May 20 12:18 java-sun -> /etc/alternatives/java_sdk_sun
lrwxrwxrwx 1 root root   21 May 20 12:18 jre -> /etc/alternatives/jre
lrwxrwxrwx 1 root root   27 May 20 12:18 jre-1.6.0 -> /etc/alternatives/jre_1.6.0
lrwxrwxrwx 1 root root   27 May 20 12:18 jre-1.6.0-sun -> java-1.6.0-sun-1.6.0.21/jre
lrwxrwxrwx 1 root root   25 May 20 12:18 jre-sun -> /etc/alternatives/jre_sun

Soit, en suivant les liens, un java_home de :

[root@esup32dev ~]# ll /usr/lib/jvm/java-1.6.0-sun-1.6.0.21/
total 16
drwxr-xr-x 2 root root 4096 May 20 12:18 bin
drwxr-xr-x 3 root root 4096 May 20 12:18 include
drwxr-xr-x 5 root root 4096 May 20 12:18 jre
drwxr-xr-x 3 root root 4096 May 20 12:18 lib

probleme de dependances

si probleme de dependance lors de l'installation de tomcat6 (chapitre suivant) du genre:

java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386 from core-0 has depsolving problems
  --> 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)

alors c'est un probleme connu:

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.

en effet

[root@esup32dev ~]# rpm -qa | grep jpackage-utils
jpackage-utils-5.0.0-2.jpp5

Ce que j'ai fais :

disable (enable=0) sur le repo jpackage-generic

[root@esup32dev 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@esup32dev yum.repos.d]# rpm -e jpackage-utils
error: Failed dependencies:
        jpackage-utils >= 0:1.5.38 is needed by (installed) java-1.6.0-sun-1.6.0.21-1jpp.i586
[root@esup32dev yum.repos.d]# rpm -e jpackage-utils --nodeps

installation (depuis centos repo !)

[root@esup32dev yum.repos.d]# yum install jpackage-utils
===========================================================================================================================
 Package                         Arch                    Version                             Repository               Size
===========================================================================================================================
Installing:
 jpackage-utils                  noarch                  1.7.3-1jpp.2.el5                    core-0                   61 k

Transaction Summary
===========================================================================================================================
Install       1 Package(s)
Upgrade       0 Package(s)

Total download size: 61 k

cela passe alors avec celui ci

[root@esup32dev yum.repos.d]# rpm -q jpackage-utils
jpackage-utils-1.7.3-1jpp.2.el5

on pense a réactiver jpackage50.repo (enabled=1) pour le futur tomcat6 .

Tomcat

Installation de tomcat6 en rpm via le repo jpackage50 + dependances

$ yum install tomcat6

Dependencies Resolved

===========================================================================================================================
 Package                                   Arch         Version                       Repository                      Size
===========================================================================================================================
Installing:
 tomcat6                                   noarch       6.0.29-1.jpp5                 jpackage-generic-updates        83 k
Installing for dependencies:
 alsa-lib                                  i386         1.0.17-1.el5                  core-0                         412 k
 antlr                                     noarch       2.7.6-6.jpp5                  jpackage-generic               345 k
 at                                        i386         3.1.8-84.el5                  core-0                          56 k
 atk                                       i386         1.12.2-1.fc6                  core-0                         222 k
 bc                                        i386         1.06-21                       core-0                         105 k
 bitstream-vera-fonts                      noarch       1.10-7                        core-0                         343 k
 cairo                                     i386         1.2.4-5.el5                   core-0                         394 k
 ecj                                       noarch       1:3.3.1.1-3.jpp5              jpackage-generic               1.3 M
 eclipse-ecj                               i386         1:3.2.1-19.el5.centos         core-0                         7.9 M
 fontconfig                                i386         2.4.1-7.el5                   core-0                         174 k
 gettext                                   i386         0.17-1.el5                    core-0                         2.4 M
 gjdoc                                     i386         0.7.7-12.el5                  core-0                         793 k
 gtk2                                      i386         2.10.4-21.el5_5.6             core-0                         6.5 M
 hicolor-icon-theme                        noarch       0.9-2.1                       core-0                          25 k
 jakarta-commons-collections-tomcat5       i386         3.2-2jpp.3                    core-0                          66 k
 jakarta-commons-daemon                    noarch       1:1.0.1-7.jpp5                jpackage-generic                30 k
 jakarta-commons-dbcp-tomcat5              noarch       1.2.2-2.jpp5                  jpackage-generic               112 k
 jakarta-commons-logging                   noarch       1.1-8.jpp5                    jpackage-generic               116 k
 jakarta-commons-pool-tomcat5              noarch       1.3-11.jpp5                   jpackage-generic                47 k
 java-1.4.2-gcj-compat                     i386         1.4.2.0-40jpp.115             core-0                          29 k
 libICE                                    i386         1.0.1-2.1                     core-0                          54 k
 libSM                                     i386         1.0.1-3.1                     core-0                          27 k
 libXcursor                                i386         1.1.7-1.1                     core-0                          32 k
 libXfixes                                 i386         4.0.1-2.1                     core-0                          14 k
 libXft                                    i386         2.1.10-1.1                    core-0                          44 k
 libXinerama                               i386         1.0.1-2.1                     core-0                         9.7 k
 libXrandr                                 i386         1.1.1-3.3                     core-0                          15 k
 libXrender                                i386         0.9.1-3.1                     core-0                          27 k
 libart_lgpl                               i386         2.3.17-4                      core-0                          76 k
 libgcj                                    i386         4.1.2-50.el5                  core-0                          16 M
 libgomp                                   i386         4.4.4-13.el5                  core-0                          72 k
 pango                                     i386         1.14.9-8.el5.centos.2         Ce5-i386-updates               334 k
 patch                                     i386         2.5.4-31.el5                  core-0                          65 k
 pax                                       i386         3.4-2.el5_4                   core-0                          63 k
 redhat-lsb                                i386         4.0-2.1.4.el5                 core-0                          25 k
 tomcat6-el-1.0-api                        noarch       6.0.29-1.jpp5                 jpackage-generic-updates        37 k
 tomcat6-jsp-2.1-api                       noarch       6.0.29-1.jpp5                 jpackage-generic-updates        74 k
 tomcat6-lib                               noarch       6.0.29-1.jpp5                 jpackage-generic-updates       2.8 M
 tomcat6-servlet-2.5-api                   noarch       6.0.29-1.jpp5                 jpackage-generic-updates        88 k
 zip                                       i386         2.31-2.el5                    core-0                         127 k

Transaction Summary
===========================================================================================================================
Install      41 Package(s)
Upgrade       0 Package(s)

Total download size: 42 M
Is this ok [y/N]: y

Si on souhaite disposer de l'interface d'aministration de tomcat

$ yum install tomcat6-webapps tomcat6-admin-webapps


===========================================================================================================================
 Package                             Arch              Version                   Repository                           Size
===========================================================================================================================
Installing:
 tomcat6-admin-webapps               noarch            6.0.29-1.jpp5             jpackage-generic-updates             41 k
 tomcat6-webapps                     noarch            6.0.29-1.jpp5             jpackage-generic-updates            252 k
Installing for dependencies:
 jakarta-taglibs-standard            noarch            1.1.2-7.jpp5              jpackage-generic                    292 k
 tomcat5-jsp-2.0-api                 noarch            5.5.27-7.jpp5             jpackage-generic                     72 k
 tomcat5-servlet-2.4-api             noarch            5.5.27-7.jpp5             jpackage-generic                    113 k
 xalan-j2                            noarch            2.7.0-10.jpp5             jpackage-generic                    1.7 M

Transaction Summary
===========================================================================================================================
Install       6 Package(s)
Upgrade       0 Package(s)

Total download size: 2.5 M
Is this ok [y/N]: y

repertoire lib 5->6

[video1 3.2 ~29mn]

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

initialement

[root@esup32dev tomcat6]# ls -l /var/lib/tomcat6/
total 4
drwxrwxr-x 7 root tomcat 4096 May 20 12:36 webapps
[root@esup32dev tomcat6]# cd /usr/share/tomcat6/lib/
[root@esup32dev lib]# pwd
/usr/share/tomcat6/lib
[root@esup32dev lib]# ls
annotations-api-6.0.29.jar  [commons-collections-tomcat5].jar  tomcat6-servlet-2.5-api-6.0.29.jar
annotations-api.jar         [commons-dbcp-tomcat5].jar         tomcat-coyote-6.0.29.jar
catalina-6.0.29.jar         [commons-pool-tomcat5].jar         tomcat-coyote.jar
catalina-ant-6.0.29.jar     [ecj].jar                          tomcat-i18n-es-6.0.29.jar
catalina-ant.jar            jasper-6.0.29.jar                  tomcat-i18n-es.jar
catalina-ha-6.0.29.jar      jasper-el-6.0.29.jar               tomcat-i18n-fr-6.0.29.jar
catalina-ha.jar             jasper-el.jar                      tomcat-i18n-fr.jar
catalina.jar                jasper.jar                         tomcat-i18n-ja-6.0.29.jar
catalina-tribes-6.0.29.jar  tomcat6-el-1.0-api-6.0.29.jar      tomcat-i18n-ja.jar
catalina-tribes.jar         tomcat6-jsp-2.1-api-6.0.29.jar

adaptation

[root@esup32dev tomcat6]# mkdir -p /var/lib/tomcat6/shared/lib
[root@esup32dev tomcat6]# mkdir -p /var/lib/tomcat6/shared/classes
[root@esup32dev tomcat6]# mkdir -p /var/lib/tomcat6/common/
[root@esup32dev tomcat6]# chgrp -R tomcat /var/lib/tomcat6/shared /var/lib/tomcat6/common/

[root@esup32dev tomcat6]# pwd
/usr/share/tomcat6
[root@esup32dev tomcat6]# ln -s /var/lib/tomcat6/common common
[root@esup32dev tomcat6]# ln -s /var/lib/tomcat6/shared shared
[root@esup32dev tomcat6]# ll
total 4
drwxr-xr-x 2 root root 4096 May 20 12:32 bin
lrwxrwxrwx 1 root root   23 May 20 15:46 common -> /var/lib/tomcat6/common
lrwxrwxrwx 1 root root   12 May 20 12:32 conf -> /etc/tomcat6
lrwxrwxrwx 1 root root   23 May 20 12:32 lib -> /usr/share/java/tomcat6
lrwxrwxrwx 1 root root   16 May 20 12:32 logs -> /var/log/tomcat6
lrwxrwxrwx 1 root root   23 May 20 15:46 shared -> /var/lib/tomcat6/shared
lrwxrwxrwx 1 root root   23 May 20 12:32 temp -> /var/cache/tomcat6/temp
lrwxrwxrwx 1 root root   24 May 20 12:32 webapps -> /var/lib/tomcat6/webapps
lrwxrwxrwx 1 root root   23 May 20 12:32 work -> /var/cache/tomcat6/work

avant 2010…

[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

Server.xml

[root@esup32dev /etc/tomcat6]
$ diff server.xml.orig server.xml
102c102
<     <Engine name="Catalina" defaultHost="localhost">
---
>     <Engine name="Catalina" defaultHost="localhost" jvmRoute="esup1">
129c129
<             unpackWARs="true" autoDeploy="true"
---
>             unpackWARs="false" autoDeploy="false"

catalina.properties

les librairies pluto* etc .. vont encore suivre l'arborescence tomcat5 (shared/lib …) il faut donc indiquer a ce tomcat6 de charger ces librairie depuis cette arborescence qu'ona reconstruit plus haut .

[root@esup32dev /etc/tomcat6]
$ diff catalina.properties.orig catalina.properties
74c74
< shared.loader=
---
> shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar

Ant

il y a un problem entre centos et jpackage sur une depandance pour ant

$ yum install ant
--> Finished Dependency Resolution
java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386 from installed has depsolving problems
  --> Missing Dependency: /usr/bin/rebuild-security-providers is needed by package java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386 (installed)
Error: Missing Dependency: /usr/bin/rebuild-security-providers is needed by package java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386 (installed)

retrait de jpckage-utils (from jpackage 5.0, enabled = 0 dans le fichier .repo)

$ rpm -e jpackage-utils
error: Failed dependencies:
        jpackage-utils >= 0:1.5.38 is needed by (installed) java-1.6.0-sun-1.6.0.21-1jpp.i586
        jpackage-utils is needed by (installed) antlr-2.7.6-6.jpp5.noarch
        jpackage-utils >= 0:1.7.2 is needed by (installed) jakarta-commons-logging-1.1-8.jpp5.noarch
        jpackage-utils >= 0:1.6.6-1jpp_1rh is needed by (installed) java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386
        /usr/bin/rebuild-security-providers is needed by (installed) java-1.4.2-gcj-compat-1.4.2.0-40jpp.115.i386

on force un –nodeps

[root@esup32dev /etc/tomcat6]
$ rpm -e jpackage-utils --nodeps
warning: /etc/maven/maven2-depmap.xml saved as /etc/maven/maven2-depmap.xml.rpmsave

</code>

reinstallation depuis le repo centos en version 1.7 incluant le fameux rebuild-security-providers

[root@esup32dev /etc/tomcat6]
$ yum install jpackage-utils
Installed:
  jpackage-utils.noarch 0:1.7.3-1jpp.2.el5

$ 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

[root@esup32dev /etc/tomcat6]
$ yum --disablerepo=jpackage-generic install ant ant-apache-regexp ant-contrib

===========================================================================================================================
 Package                           Arch                Version                            Repository                  Size
===========================================================================================================================
Installing:
 ant                               i386                1.6.5-2jpp.2                       core-0                     2.0 M
 ant-apache-regexp                 i386                1.6.5-2jpp.2                       core-0                      27 k
 ant-contrib                       noarch              1.0-0.10.b2.el5                    el5-i386-epel              221 k
Installing for dependencies:
 junit                             i386                3.8.2-3jpp.1                       core-0                     304 k
 regexp                            i386                1.4-2jpp.2                         core-0                      91 k
 xerces-j2                         i386                2.7.1-7jpp.2.el5_4.2               core-0                     2.7 M
 xml-commons                       i386                1.3.02-0.b2.7jpp.10                core-0                      19 k
 xml-commons-apis                  i386                1.3.02-0.b2.7jpp.10                core-0                     334 k
 xml-commons-resolver              i386                1.1-1jpp.12                        core-0                     148 k

Transaction Summary
===========================================================================================================================
Install       9 Package(s)
Upgrade       0 Package(s)

Total download size: 5.8 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/download.php/3562/esup-uPortal-3.2.4-esup-1.0.0-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@esup32dev ~]
$ ls -l
total 2132
-rw-rw-r-- 1 esup esup 2178865 May 20 17:24 esup-uPortal-3.2.4-esup-1.0.0-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 

le retry=1 demande a apache de ressayer apres 1s si echec d'acces au tomcat. pratique en developpement , mais en prod peut-etre trop lourd si X client accedent alors que le tomcat n'a pas encore demarré. Le parametre par defaut de retry d'apache en cas d'echec de connexion apache → ajp tomcat doit etre de l'ordre de 30s cf video 3.2 ~50mn

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 &quot;type&quot; 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: http://sourcesup.cru.fr/scm/viewvc.php/trunk/esup-smsu/properties/groups/PAGSGroupStoreConfig.xml?root=esup-smsu&view=markup

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

<code> 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