uPortal 5.2.1安装笔记

2019独角兽企业重金招聘Python工程师标准>>>

1. uPortal5 初始化、切换为mysql

$ git clone https://github.com/Jasig/uPortal-start.git 
$ cd uPortal-start

uPortal-start with MySQL configuration

＞mysql  Ver 14.14 Distrib 5.7.19

#---------------------------------------------------------------------------------------
# /etc/mysql/mysql.conf.d/mysqld.cnf
# adding the following two lines,
# restart mysql server
#---------------------------------------------------------------------------------------

lower_case_table_names=1
character_set_server=utf8

#---------------------------------------------------------------------------------------
# ./uPortal-start/etc/portal/global.properties
#---------------------------------------------------------------------------------------

hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/uPortal
hibernate.connection.username=***
hibernate.connection.password=***
hibernate.connection.validationQuery=select 1
hibernate.dialect=org.hibernate.dialect.MySQLDialect

#---------------------------------------------------------------------------------------
# ./uPortal-start/overlays/build.gradle
#---------------------------------------------------------------------------------------

    dependencies {
    ...  原有的hsql不要删除
        jdbc "mysql:mysql-connector-java:6.0.6"
    ...
    }

#---------------------------------------------------------------------------------------
# ./uPortal-start/overlays/cas/src/main/webapps/WEB-INF/deployerConfigContext.xml
# replace hsqldb datasource with mysql.
#---------------------------------------------------------------------------------------

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/uPortal" />
<property name="username"  value="***" />
<property name="password"  value="***" />
<property name="minIdle"   value="1" />
<property name="maxIdle"   value="2" />
<property name="maxActive" value="16" />
</bean>

#---------------------------------------------------------------------------------------
# comment out hsqldb related script
#---------------------------------------------------------------------------------------

＞./uPortal-start/build.gradle
//   apply from: rootProject.file('gradle/tasks/hsql.gradle')

＞./uPortal-start/gradle/tasks/portal.gradle
//   dependsOn ':hsqlStart'

＞./uPortal-start/gradle/tasks/tomcat.gradle 
// dependsOn ':hsqlStart'

$ cp build.properties.sample build.properties
$ ./gradlew portalInit
$ ./gradlew tomcatStart

Using the example credentials, you can bypass CAS when testing locally. Available default logins / URLs:

• admin: http://localhost:8080/uPortal/Login?userName=admin&password=admin
• faculty: http://localhost:8080/uPortal/Login?userName=faculty&password=faculty
• staff http://localhost:8080/uPortal/Login?userName=staff&password=staff
• student http://localhost:8080/uPortal/Login?userName=student&password=student
• guest http://localhost:8080/uPortal/render.userLayoutRootNode.uP

不支持CLOB类型的问题

2. properties/db/tables.xml

序号	表名	描述
1	UP_USER
2	UP_USER_LOCALE
3	UP_PERMISSION
4	UP_USER_LAYOUT
5	UP_LAYOUT_STRUCT
6	UP_LAYOUT_PARAM
7	UP_SEQUENCE
8	UP_USER_PROFILE
9	UP_GROUP
10	UP_ENTITY_TYPE
11	UP_GROUP_MEMBERSHIP
12	UP_ENTITY_CACHE_INVALIDATION
13	UP_ENTITY_LOCK
14	JGROUPSPING

    

 

 

 

 

 

 

 

转载于:https://my.oschina.net/yunjie/blog/1924393