Differences

This shows you the differences between two versions of the page.

--- docpublic:systemes:esup:esup_socle_4_c6 [2014/07/02 12:40]
procacci@tem-tsp.eu [URL a proteger]
+++ docpublic:systemes:esup:esup_socle_4_c6 [2015/05/20 16:10] (current)
procacci@tem-tsp.eu [build & config properties]
@@ Line 123: / Line 123: @@
 ensuite, faut-il appliquer ce patch :  https://www.esup-portail.org/pages/viewpage.action?pageId=269090823 ?
+==== pb LC_COLLATE ====
+suite a une mise a jour a chaud sur le container openvz, apres un redemrrage des services (tomcat, postgres ...) le portail ne marchait plus !
+uPortal.log:
+<code>
+[esup4] WARN [main] Jan/09 09:26:33,041 jdbc.TomcatDataSourceFactory.[] - Failed to register connection pool with MBeanServer. JMX information will not be available for: RawEventsDb
+org.postgresql.util.PSQLException: FATAL: database locale is incompatible with operating system
+  Detail: The database was initialized with LC_COLLATE "fr_FR.UTF-8",  which is not recognized by setlocale().
+  Hint: Recreate the database with another locale or install the missing locale.
+</code>
+cette erreure est expliquée sur http://serverfault.com/questions/491237/postgresql-9-2-invalid-locale-name-on-ubuntu-12-04
+où la conclusion est :
+<code>
+If PostgreSQL hasn't been restarted after the new locale has been created, that would be the reason. service postgresql restart should suffice.
+This is presumably due to how locales are implemented in Linux libc. The new locales don't get seamlessly imported into the environment of already running processes.
+</code>
+donc simplement en redemarrant la VM , tout repart sans soucis !
+==== acces BD ====
 ouverture acces BD en mode trust (ident par defaut n'autorise pas )
@@ Line 816: / Line 842: @@
 +environment.build.ldap.baseDn=dc=int-evry,dc=fr
 +environment.build.ldap.userName=cn=mcibind,ou=system,dc=int-evry,dc=fr
-+environment.build.ldap.password=mcianony
++environment.build.ldap.password=secret
  environment.build.ldap.pooled=false
  environment.build.ldap.uidAttr=uid
@@ Line 1559: / Line 1585: @@
 ===== context tomcat =====
-dans le server.xml de tomcat6 :
+definition du context uPortal et /ResourceServingWebapp pour tomcat, cf
+http://www.esup-portail.org/display/ESUPMU/Tomcat+en+production
+context ajoutés dans le server.xml de tomcat, sous section de  //<Host name="localhost"  appBase="webapps"// :
 <code>
@@ Line 1580: / Line 1610: @@
 # JNDI property to uncomment :
 environment.build.hibernate.connection.jndiname=jdbc/uPortalDB
-</code>
-===== contexts tomcat =====
-definition du context uPortal et /ResourceServingWebapp pour tomcat, cf
-http://www.esup-portail.org/display/ESUPMU/Tomcat+en+production
-video esup 3.2 82mn
-context ajoutés dans le server.xml de tomcat, sous section de  //<Host name="localhost"  appBase="webapps"// :
-<code>
-<Context path="/uPortal"
-                   docBase="/var/lib/tomcat6/webapps/uPortal"
-                   crossContext="true"
-                   reloadable="true">
-                <Resource name="jdbc/PortalDb"
-                          auth="Container"
-                          type="javax.sql.DataSource"
-                          username="uportal32re7" password="secret"
-                          driverClassName="com.mysql.jdbc.Driver"
-                          url="jdbc:mysql://bd.it-sudparis.eu/uportalre7dev?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>
 </code>
@@ Line 1626: / Line 1616: @@
 le portail sera accessible dans ces conditions (ProxyPass /uportal) sur l'URL
-http://esup3re7.it-sudparis.eu/uPortal/render.userLayoutRootNode.uP
+http://esup4dev.tem-tsp.eu/uPortal/render.userLayoutRootNode.uP
 ===== SSL =====
@@ Line 1644: / Line 1634: @@
 <code>
-[root@esup3re7 ~]
+[root@esup4dev ~]
 $ yum install mod_ssl
 </code>
@@ Line 1653: / Line 1643: @@
 <code>
-[root@esup3re7 certs]#  grep SSLCertificate /etc/httpd/conf.d/ssl.conf
+[root@esup4dev certs]#  grep SSLCertificate /etc/httpd/conf.d/ssl.conf
 SSLCertificateFile /etc/pki/tls/certs/cert-10605--.tem-tsp.eu.pem
 SSLCertificateKeyFile /etc/pki/tls/private/tem-tsp_star_nop.key
@@ Line 1694: / Line 1684: @@
 <code>
-[procacci@arvouin ~]
+$ openssl s_client -connect esup4dev.tem-tsp.eu:443 -CAfile /etc/pki/tls/certs/add_trust_external_ca_root.pem -verify 3
-$ openssl s_client -connect esup3re7.tem-tsp.eu:443 -CAfile /etc/pki/tls/certs/add_trust_external_ca_root.pem -verify 3
 verify depth is 3
 CONNECTED(00000003)
@@ Line 1716: / Line 1705: @@
 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
+---
 </code>
@@ Line 1727: / Line 1717: @@
-==== driver Mysql ====
+==== driver PostgreSQL / Mysql ====
-il faut rendre accessible a tomcat le driver mysql autrement au demarrage du serveur on a ce type d'erreur:
+il faut rendre accessible a tomcat le driver mysql et/ou postgresql,  autrement au demarrage du serveur on a ce type d'erreur:
 <code>
@@ Line 1739: / Line 1729: @@
 </code>
-copie du jar mysql
+il ne semble plus necessaire de copier le driver, le build / ant se chargeant  de le mettre en place dans webapps
 <code>
-[root@esup3re7 tomcat6]# cp /home/esup/esup-uPortal-3.2.4-esup-1.0.0-RC3/update/Tomcat/lib/mysql-connector-java-5.1.6.jar /var/lib/tomcat6/shared/lib/
+[root@esup4dev conf]# locate postgresql-9.0-801.jdbc4.jar
-[root@esup3re7 tomcat6]#
+/home/esup/.m2/repository/postgresql/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar
-[root@esup3re7 tomcat6]#
+...
-[root@esup3re7 tomcat6]# ls -al /var/lib/tomcat6/shared/lib/
+/var/lib/tomcat6/webapps/WebProxyPortlet/WEB-INF/lib/postgresql-9.0-801.jdbc4.jar
-total 2728
+/var/lib/tomcat6/webapps/uPortal/WEB-INF/lib/postgresql-9.0-801.jdbc4.jar
-drwxrwxr-x 2 root esup    4096 Feb  8 11:22 .
-drwxrwxr-x 4 root esup    4096 Dec  2 16:02 ..
--rw-rw-r-- 1 esup esup 1736099 Feb  7 23:17 castor-1.1.1.jar
--rw-rw-r-- 1 esup esup   44598 Feb  7 23:17 commons-logging-api-1.1.jar
--rw-r--r-- 1 root root  703265 Feb  8 11:22 mysql-connector-java-5.1.6.jar
--rw-rw-r-- 1 esup esup    3463 Feb  7 23:17 person-directory-api-1.5.0-RC6.jar
--rw-rw-r-- 1 esup esup  142812 Feb  7 23:17 pluto-container-1.1.7.jar
--rw-rw-r-- 1 esup esup   39406 Feb  7 23:17 pluto-descriptor-api-1.1.7.jar
--rw-rw-r-- 1 esup esup   46472 Feb  7 23:17 pluto-descriptor-impl-1.1.7.jar
--rw-rw-r-- 1 esup esup   25969 Feb  7 23:17 pluto-taglib-1.1.7.jar
--rw-rw-r-- 1 esup esup   17090 Feb  7 23:17 portlet-api-1.0.jar
-[root@esup3re7 tomcat6]# chown esup /var/lib/tomcat6/shared/lib/mysql-connector-java-5.1.6.jar
 </code>
-finalement dans /usr/share/tomcat6/lib/ semble mieux que /usr/share/tomcat6/shared/lib/
+ou en mysql
 <code>
-[root@esup3re7 tomcat6]# cp /home/esup/esup-uPortal-3.2.4-esup-1.0.0-RC3/update/Tomcat/lib/mysql-connector-java-5.1.6.jar /usr/share/tomcat6/lib/
+[root@ecampusdev ~]# locate mysql-connector-java-5.1.9.jar
+/home/esup/.m2/repository/mysql/mysql-connector-java/5.1.9/mysql-connector-java-5.1.9.jar
-[root@esup3re7 tomcat6]# ls -l /usr/share/tomcat6/lib/mysql-connector-java-5.1.6.jar
+...
--rw-r--r-- 1 root root 703265 Feb  8 11:33 /usr/share/tomcat6/lib/mysql-connector-java-5.1.6.jar
+/usr/local/apache-tomcat-6.0.36-esup/webapps/WebProxyPortlet/WEB-INF/lib/mysql-connector-java-5.1.9.jar
+/usr/local/apache-tomcat-6.0.36-esup/webapps/uPortal/WEB-INF/lib/mysql-connector-java-5.1.9.jar
 </code>
@@ Line 1776: / Line 1752: @@
 ==== custom admin ====
-il faut imperativement changer le mot de passe admin, pour cela on va en profiter pour commencer a structurer la personalisation du portail en construsant un arborescence de custom .
+il faut imperativement changer le mot de passe admin
 video2 esup3.2 5mn
 <code>
-[esup@esup3re7 esup-install]$ mkdir -p custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/admin
+[esup@esup4dev esup-uportal]$ locate admin.user.xml
-[esup@esup3re7 esup-install]$ cd custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/admin
+/home/esup/esup-uportal/uportal-war/src/main/data/default_entities/user/admin.user.xml
-[esup@esup3re7 admin]$ locate admin.user
-/home/esup/esup-uPortal-3.2.4-esup-1.0.0-RC3/update/uPortal/uportal-impl/src/main/resources/properties/db/mini/user/admin.user
-[esup@esup3re7 admin]$ cp /home/esup/esup-uPortal-3.2.4-esup-1.0.0-RC3/update/uPortal/uportal-impl/src/main/resources/properties/db/mini/user/admin.user .
 </code>
@@ Line 1795: / Line 1765: @@
 <code>
-$ cat /home/esup/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/admin/admin.user
+[esup@esup4dev esup-uportal]$ cat /home/esup/esup-uportal/uportal-war/src/main/data/default_entities/user/admin.user.xml
-<user script="classpath://org/jasig/portal/io/import-user_v3-2.crn" username="admin">
-  <default-user>defaultTemplateUser</default-user>
+<user xmlns="https://source.jasig.org/schemas/uportal/io/user" xmlns:ns2="https://source.jasig.org/schemas/uportal/io/permission-owner" xmlns:ns3="https://source.jasig.org/schemas/uportal/io/stylesheet-descriptor" xmlns:ns4="https://source.jasig.org/schemas/uportal/io/portlet-definition" xmlns:ns5="https://source.jasig.org/schemas/uportal" xmlns:ns6="https://source.jasig.org/schemas/uportal/io/portlet-type" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" username="admin" version="4.0" xsi:schemaLocation="https://source.jasig.org/schemas/uportal/io/user https://source.jasig.org/schemas/uportal/io/user/user-4.0.xsd">
-  <person-directory>
+    <default-user>defaultTemplateUser</default-user>
-    <encrptd-pswd>(MD5)5ebe2294ecd0e0f08eab7690d2a6ee69</encrptd-pswd>
+    <password>(MD5)64a24fed9cf544cfe09249ddc6e56795</password>
-    <first-name>Admin</first-name>
+    <attribute>
-    <last-name>Utilisateur</last-name>
+        <name>givenName</name>
-    <email>admin@int-evry.fr</email>
+        <value>Amy</value>
-  </person-directory>
+    </attribute>
-</user>
+    ...
 </code>
 import
 <code>
-[esup@esup3re7 esup-install]$ ant db.import -Ddir=/home/esup/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/admin/
+[esup@esup4dev esup-uportal]$ ant data-import -Dfile=uportal-war/src/main/data/default_entities/user/admin.user.xml
-Buildfile: build.xml
-     [java] FILE_PATTERN=.*
-     [java] Import User:  admin.user
-     [java] Import of /home/esup/esup-install/custom/uPortal/uportal-impl/src/main/resources/properties/db/itsp/admin/ Complete in 670 milliseconds.
-BUILD SUCCESSFUL
-Total time: 9 seconds
 </code>
@@ Line 1837: / Line 1801: @@
+===== custom dir =====
+Nous allons travailler dans une arborescence de personnalisation (custom) propre a cette plateforme de developpement.
+Pour ce faire nous creeons un directory de custom spécifique et le lien qui va avec
+<code>
+[esup@esup4dev esup-uportal]$ cd uportal-war/src/main/data/
+[esup@esup4dev data]$ ls
+default_entities  quickstart_entities  required_entities
+[esup@esup4dev data]$ mkdir tem-tsp
+[esup@esup4dev data]$ cd /home/esup/esup-uportal/
+[esup@esup4dev esup-uportal]$ ln -s uportal-war/src/main/data/tem-tsp/ custom
+[esup@esup4dev esup-uportal]$ ls -l custom
+lrwxrwxrwx 1 esup tomcat 34 Jul 16 15:18 custom -> uportal-war/src/main/data/tem-tsp/
+</code>
+==== git custom ====
+ici nous recuperons le sous repertoire custom d'une autre machine de develoopement , pour profitons de l'outil git pour ce faire plutot que les traditionels "scp" !
+ http://jasonkarns.com/blog/subdirectory-checkouts-with-git-sparse-checkout/
+<code>
+[esup@esup4dev custom]$ git remote add ecampusdev-esup-uportal ssh://gituser@gitshare.tem-tsp.eu/~/ecampus/ecampusdev-esup-uportal.git
+[esup@esup4dev custom]$ git branch -a
+[esup@esup4dev custom]$ git remote -v show
+ecampusdev-esup-uportal	ssh://gituser@gitshare.tem-tsp.eu/~/ecampus/ecampusdev-esup-uportal.git (fetch)
+ecampusdev-esup-uportal	ssh://gituser@gitshare.tem-tsp.eu/~/ecampus/ecampusdev-esup-uportal.git (push)
+[esup@esup4dev custom]$ ls -al
+total 12
+drwxr-xr-x 3 esup tomcat 4096 Jul 16 15:21 .
+drwxr-xr-x 6 esup tomcat 4096 Jul 16 15:14 ..
+drwxr-xr-x 7 esup tomcat 4096 Jul 16 15:33 .git
+</code>
+===== group Pags ======
+https://wiki.jasig.org/pages/viewpage.action?pageId=52953648
+groups sur attributs utilisateur
+Rechercher les attributs utilisateur dans ldap, les attributs qu'on souhaite mapper pour chaque utilisateur dans ldap.
+<code>
+[esup@esup4dev esup-uportal]$ diff /tmp/personDirectoryContext.xml /home/esup/esup-uportal/uportal-war/src/main/resources/properties/contexts/personDirectoryContext.xml
+c161
+<                      	<ref bean="uPortalLdapAttributeSource"/>
+---
+>                         <ref bean="uPortalLdapAttributeSource"/>
+c242
+< <!-- Rajout ci-dessous pour retirer le "Unrecognized Person" -->
+---
+>
+,247d245
+< 	<!-- AND NOT FOUND BEFORE ?? -->
+< 	<property name="baseDN" value="${ldap.baseDn}" />
+,285d278
+<                 <entry key="departmentNumber">                  <value>departmentNumber</value></entry>
+<                 <entry key="Title">                             <value>Title</value></entry>
+<                 <entry key="employeeType">                      <value>employeeType</value></entry>
+<                 <entry key="eduPersonScopedAffiliation"> 	<value>eduPersonScopedAffiliation</value></entry>
+<                 <entry key="eduPersonPrimaryOrgUnitDN">         <value>eduPersonPrimaryOrgUnitDN</value></entry>
+[esup@esup4dev esup-uportal]$ cp /tmp/personDirectoryContext.xml /home/esup/esup-uportal/uportal-war/src/main/resources/properties/contexts/personDirectoryContext.xml
+</code>
+===== import user =====
+import d'utilisateur modele pour les layout (user-lo.xml ...)
+<code>
+[esup@esup4dev esup-uportal]$ ant data-import -Dfile=custom/uportal-war/src/main/data/tem-tsp/user/application-lo.user.xml
+...
+ [java]  INFO [21:55,276] Importing Data from: custom/uportal-war/src/main/data/tem-tsp/user/application-lo.user.xml
+     [java]  INFO [21:55,440] Imported : file:/home/esup/esup-uportal/custom/uportal-war/src/main/data/tem-tsp/user/application-lo.user.xml
+     [java]  INFO [21:55,489] Closing JPA EntityManagerFactory for persistence unit 'PortalDb'
+     [java]  INFO [21:55,500] Closing JPA EntityManagerFactory for persistence unit 'AggrEventsDb'
+     [java]  INFO [21:55,506] Closing JPA EntityManagerFactory for persistence unit 'RawEventsDb'
+BUILD SUCCESSFUL
+Total time: 22 seconds
+</code>
+==== import group ====
+<code>
+[esup@esup4dev esup-uportal]$ ant data-import -Dfile=custom/uportal-war/src/main/data/tem-tsp/group_membership/Academics.group-membership.xml
+[java]  INFO [19:13,736] Importing Data from: custom/uportal-war/src/main/data/tem-tsp/group_membership/Academics.group-membership.xml
+     [java]  INFO [19:13,867] Imported : file:/home/esup/esup-uportal/custom/uportal-war/src/main/data/tem-tsp/group_membership/Academics.group-membership.xml
+     [java]  INFO [19:13,872] Imported : file:/home/esup/esup-uportal/custom/uportal-war/src/main/data/tem-tsp/group_membership/Academics.group-membership.xml
+     [java]  INFO [19:13,944] Closing JPA EntityManagerFactory for persistence unit 'PortalDb'
+     [java]  INFO [19:13,955] Closing JPA EntityManagerFactory for persistence unit 'AggrEventsDb'
+     [java]  INFO [19:13,961] Closing JPA EntityManagerFactory for persistence unit 'RawEventsDb'
+BUILD SUCCESSFUL
+Total time: 22 seconds
+[esup@esup4dev esup-uportal]$ ant data-import -Dfile=custom/uportal-war/src/main/data/tem-tsp/group_membership/Applications.group-membership.xml
+...
+ [java]  INFO [21:02,889] Importing Data from: custom/uportal-war/src/main/data/tem-tsp/group_membership/Applications.group-membership.xml
+     [java]  INFO [21:03,036] Looking up bean 'counterStore' in ApplicationContext due to context not yet being initialized
+     [java]  INFO [21:03,059] Imported : file:/home/esup/esup-uportal/custom/uportal-war/src/main/data/tem-tsp/group_membership/Applications.group-membership.xml
+     [java]  INFO [21:03,064] Imported : file:/home/esup/esup-uportal/custom/uportal-war/src/main/data/tem-tsp/group_membership/Applications.group-membership.xml
+     [java]  INFO [21:03,140] Closing JPA EntityManagerFactory for persistence unit 'PortalDb'
+     [java]  INFO [21:03,152] Closing JPA EntityManagerFactory for persistence unit 'AggrEventsDb'
+     [java]  INFO [21:03,160] Closing JPA EntityManagerFactory for persistence unit 'RawEventsDb'
+BUILD SUCCESSFUL
+Total time: 22 seconds
+</code>
+==== import portlet ====
+exemple avec portlet esup-filemanager
+<code>
+[esup@esup4dev esup-uportal]$ ant data-import -Ddir=custom/uportal-war/src/main/data/tem-tsp/portlet-definition/ -Dpattern=esup-filemanager.portlet-definition.xml
+...
+   [java]  INFO [19:54,195] Importing Data from: custom/uportal-war/src/main/data/tem-tsp/portlet-definition/ that matches esup-filemanager.portlet-definition.xml
+     [java]  INFO [19:54,201] Scanning for files to Import from: custom/uportal-war/src/main/data/tem-tsp/portlet-definition
+     [java]  INFO [19:54,244] Found 1 files to Import from: custom/uportal-war/src/main/data/tem-tsp/portlet-definition
+     [java]  INFO [19:54,244] Importing 1 files of type <{https://source.jasig.org/schemas/uportal/io/portlet-definition}portlet-definition version="4.0">
+     [java]  INFO [19:54,329] Looking up bean 'referenceEntitySearcher' in ApplicationContext due to context not yet being initialized
+     [java]  INFO [19:54,396] Looking up bean 'entityTypes' in ApplicationContext due to context not yet being initialized
+     [java]  INFO [19:54,423] Looking up bean 'entityCachingService' in ApplicationContext due to context not yet being initialized
+     [java]  INFO [19:54,477] Looking up bean 'authorizationService' in ApplicationContext due to context not yet being initialized
+     [java]  INFO [19:54,545] Imported : esup-filemanager.portlet-definition.xml
+     [java]  INFO [19:54,549] For a detailed report on the data import see /home/esup/esup-uportal/target/data-import-reports/data-import.txt
+     [java]  INFO [19:54,606] Closing JPA EntityManagerFactory for persistence unit 'PortalDb'
+     [java]  INFO [19:54,633] Closing JPA EntityManagerFactory for persistence unit 'AggrEventsDb'
+     [java]  INFO [19:54,649] Closing JPA EntityManagerFactory for persistence unit 'RawEventsDb'
+BUILD SUCCESSFUL
+Total time: 21 seconds
+</code>
 ====== Ancienne doc uPortal 3.2 a faire evoluer ... ======

docpublic/systemes/esup/esup_socle_4_c6.1404304834.txt.gz · Last modified: 2014/07/02 12:40 by procacci@tem-tsp.eu

Show page Old revisions

[unknown link type]Back to top