...
uPortal relies on database transactional support, which in MySQL is dependent upon the underlying storage engine (per-table).
The default (MyISAM) is not transaction safe. The most common transactional table type on MySQL is InnoDB. Configure InnoDB as the default by adding the following line under the [mysqld] directive:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[mysqld] default-storage-engine=innodb |
...
MySQL table names are case-sensitive depending on the filesystem of the server. (e.g. insensitive in Windows & Mac HFS+, while case sensitive in Unix.)
The SQL used in uPortal may not always be in the same case so the following line of code must be added to the my.cnf file:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[mysqld] lower_case_table_names=1 |
...
You can also set all of the memory, table, and connection limits as well as a host of other options.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
# Example settings used for uPortal at Manchester max_connections = 1500 table_cache = 512 query_cache_size = 128M set-variable = innodb_buffer_pool_size=128M set-variable = innodb_log_file_size=256M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_log_buffer_size=4M innodb_flush_log_at_trx_commit=1 |
...
| No Format |
|---|
Buildfile: build.xml
dbtest:
install-parent-pom:
[artifact:install] [INFO] Installing /uportal/pom.xml to /root/.m2/repository/org/jasig/portal/uportal-parent/3.2.1/uportal-parent-3.2.1.pom
[touch] Creating /tmp/jasig/uportal-parent.pom-851062517-marker
[echo] Artifact '/uportal/uportal-impl/target/uportal-impl-3.2.1.jar' is not available or out-of-date, calling 'mvn install'
[delete] Deleting: /uportal/uportal-impl/target/uportal-impl-3.2.1.jar
mvn:
[artifact:mvn] [INFO] Scanning for projects...
[artifact:mvn] [INFO] ------------------------------------------------------------------------
[artifact:mvn] [INFO] Building uPortal Source
[artifact:mvn] [INFO] task-segment: [install]
[artifact:mvn] [INFO] ------------------------------------------------------------------------
[artifact:mvn] [INFO] [enforcer:enforce {execution: enforce-versions}]
[artifact:mvn] [INFO] [resources:resources {execution: default-resources}]
[artifact:mvn] [INFO] Using 'UTF-8' encoding to copy filtered resources.
[artifact:mvn] [INFO] Copying 393 resources
[artifact:mvn] [INFO] [compiler:compile {execution: default-compile}]
[artifact:mvn] [INFO] Nothing to compile - all classes are up to date
[artifact:mvn] [INFO] [resources:testResources {execution: default-testResources}]
[artifact:mvn] [INFO] Using 'UTF-8' encoding to copy filtered resources.
[artifact:mvn] [INFO] Copying 50 resources
[artifact:mvn] [INFO] [compiler:testCompile {execution: default-testCompile}]
[artifact:mvn] [INFO] Nothing to compile - all classes are up to date
[artifact:mvn] [INFO] [surefire:test {execution: default-test}]
[artifact:mvn] [INFO] Surefire report directory: /portal/uportal/uportal-impl/target/surefire-reports
[artifact:mvn]
[artifact:mvn] -------------------------------------------------------
[artifact:mvn] T E S T S
[artifact:mvn] -------------------------------------------------------
[artifact:mvn] Running org.jasig.portal.channels.error.CThrowerTest
[artifact:mvn] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.114 sec
[artifact:mvn] Running org.jasig.portal.lang.ChainedThrowable_Test
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.697 sec
[artifact:mvn] Running org.jasig.portal.portlet.url.PortletUrlSyntaxProviderImplTest
[artifact:mvn] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.151 sec
[artifact:mvn] Running org.jasig.portal.layout.dlm.providers.ParenTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
[artifact:mvn] Running org.jasig.portal.PortalExceptionTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec
[artifact:mvn] Running org.jasig.portal.security.provider.RestrictedPersonTest
[artifact:mvn] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec
[artifact:mvn] Running org.jasig.portal.security.provider.BasicLocalConnectionContextTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.06 sec
[artifact:mvn] Running org.jasig.portal.utils.PooledCounterStoreTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.111 sec
[artifact:mvn] Running org.jasig.portal.layout.UserLayoutStoreFactoryTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec
[artifact:mvn] Running org.jasig.portal.url.support.ChannelRequestParameterManagerTest
[artifact:mvn] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec
[artifact:mvn] Running org.jasig.portal.channels.error.tt.ThrowableToElementTest
[artifact:mvn] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec
[artifact:mvn] Running org.jasig.portal.channels.support.TitledChannelRuntimePropertiesTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec
[artifact:mvn] Running org.jasig.portal.portlet.dao.jpa.JpaPortletDaoTest
[artifact:mvn] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.784 sec
[artifact:mvn] Running org.jasig.portal.events.handlers.db.JpaPortalEventStoreTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.176 sec
[artifact:mvn] Running org.jasig.portal.security.provider.cas.CasSecurityContextMockTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.04 sec
[artifact:mvn] Running org.jasig.portal.services.stats.ConditionalStatsRecorderTest
[artifact:mvn] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.045 sec
[artifact:mvn] Running org.jasig.portal.services.HttpClientManagerTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.883 sec
[artifact:mvn] Running org.jasig.portal.UPFileSpecTest
[artifact:mvn] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
[artifact:mvn] Running org.jasig.portal.channels.error.tt.ResourceMissingExceptionToElementTest
[artifact:mvn] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec
[artifact:mvn] Running org.jasig.portal.security.provider.cas.CasConnectionContextTest
[artifact:mvn] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.145 sec
[artifact:mvn] Running org.jasig.portal.utils.uri.PrefixUriScrutinizerTest
[artifact:mvn] Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.055 sec
[artifact:mvn] Running org.jasig.portal.lang.Resources_Test
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.018 sec
[artifact:mvn] Running org.jasig.portal.web.skin.ResourcesDaoImplTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.518 sec
[artifact:mvn] Running org.jasig.portal.portlet.container.properties.CacheRequestPropertiesManagerTest
[artifact:mvn] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.042 sec
[artifact:mvn] Running org.jasig.portal.portlet.url.PortletRequestParameterManagerTest
[artifact:mvn] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.025 sec
[artifact:mvn] Running org.jasig.portal.rdbm.TransientDatasourceTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.058 sec
[artifact:mvn] Running org.jasig.portal.groups.PersonDirNameFinderTest
[artifact:mvn] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.02 sec
[artifact:mvn] Running org.jasig.portal.channels.cusermanager.ChannelRuntimeDataToPersonConverterTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.012 sec
[artifact:mvn] Running org.jasig.portal.lang.TypeConverter_Test
[artifact:mvn] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec
[artifact:mvn] Running org.jasig.portal.lang.StackTrace_Test
[artifact:mvn] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.058 sec
[artifact:mvn] Running org.jasig.portal.utils.uri.BlockedUriExceptionTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
[artifact:mvn] Running org.jasig.portal.tools.checks.ClassPresenceCheckTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.021 sec
[artifact:mvn] Running org.jasig.portal.ExceptionHelperTest
[artifact:mvn] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
[artifact:mvn] Running org.jasig.portal.spring.LazyPortalApplicationContextTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.816 sec
[artifact:mvn] Running org.jasig.portal.portlet.container.properties.HttpRequestPropertiesManagerTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.022 sec
[artifact:mvn] Running org.jasig.portal.channels.CAbstractXsltTest
[artifact:mvn] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.678 sec
[artifact:mvn] Running org.jasig.portal.portlet.registry.TransientPortletWindowRegistryImplTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.053 sec
[artifact:mvn] Running org.jasig.portal.channels.error.ErrorDocumentTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.069 sec
[artifact:mvn] Running org.jasig.portal.channels.error.tt.InternalTimeoutExceptionToElementTest
[artifact:mvn] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec
[artifact:mvn] Running org.jasig.portal.channel.dao.jpa.ChannelDefinitionTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.201 sec
[artifact:mvn] Running org.jasig.portal.channels.error.tt.AuthorizationExceptionToElementTest
[artifact:mvn] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec
[artifact:mvn] Running org.jasig.portal.io.SafeFileNamePhraseTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec
[artifact:mvn] Running org.jasig.portal.channels.CSecureInfoTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec
[artifact:mvn] Running org.jasig.portal.channels.error.CErrorTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.054 sec
[artifact:mvn] Running org.jasig.portal.layout.node.UserLayoutChannelDescriptionTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
[artifact:mvn] Running org.jasig.portal.channels.portlet.SpringPortletChannelImplTest
[artifact:mvn] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.137 sec
[artifact:mvn] Running org.jasig.portal.groups.pags.PAGSTest
[artifact:mvn] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.129 sec
[artifact:mvn] Running org.jasig.portal.concurrency.locking.EntityLockTest
[artifact:mvn] Caught Exception: Could not create lock: entity already locked.
[artifact:mvn] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.083 sec
[artifact:mvn] Running org.jasig.portal.channels.portlet.CSpringPortletAdaptorTest
[artifact:mvn] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.017 sec
[artifact:mvn] Running org.jasig.portal.layout.dlm.JpaFragmentDefinitionDaoTest
[artifact:mvn] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.07 sec
[artifact:mvn] Running org.jasig.portal.layout.LayoutStructureTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.045 sec
[artifact:mvn] Running org.jasig.portal.io.ImportTest
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.69 sec
[artifact:mvn] Running org.jasig.portal.groups.filesystem.FileSystemGroupsTest
[artifact:mvn] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.597 sec
[artifact:mvn] Running org.jasig.portal.portlet.container.properties.RequestPropertiesManagerBrokerTest
[artifact:mvn] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.018 sec
[artifact:mvn] Running org.jasig.portal.url.PortalUrlProviderImplTest
[artifact:mvn] Tests run: 21, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.266 sec
[artifact:mvn] Running org.jasig.portal.lang.ThrowableHelper_Test
[artifact:mvn] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.028 sec
[artifact:mvn] Running org.jasig.portal.utils.RequiresJDK15Test
[artifact:mvn] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
[artifact:mvn] Running org.jasig.portal.properties.PropertiesManagerTest
[artifact:mvn] Tests run: 49, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.078 sec
[artifact:mvn]
[artifact:mvn] Results :
[artifact:mvn]
[artifact:mvn] Tests run: 317, Failures: 0, Errors: 0, Skipped: 0
[artifact:mvn]
[artifact:mvn] [INFO] [jar:jar {execution: default-jar}]
[artifact:mvn] [INFO] Building jar: /uportal/uportal-impl/target/uportal-impl-3.2.1.jar
[artifact:mvn] [INFO] Preparing source:jar
[artifact:mvn] [WARNING] Removing: jar from forked lifecycle, to prevent recursive invocation.
[artifact:mvn] [INFO] [enforcer:enforce {execution: enforce-versions}]
[artifact:mvn] [INFO] [source:jar {execution: attach-sources}]
[artifact:mvn] [INFO] Building jar: /uportal/uportal-impl/target/uportal-impl-3.2.1-sources.jar
[artifact:mvn] [INFO] [install:install {execution: default-install}]
[artifact:mvn] [INFO] Installing /uportal/uportal-impl/target/uportal-impl-3.2.1.jar to /root/.m2/repository/org/jasig/portal/uportal-impl/3.2.1/uportal-impl-3.2.1.jar
[artifact:mvn] [INFO] Installing /uportal/uportal-impl/target/uportal-impl-3.2.1-sources.jar to /root/.m2/repository/org/jasig/portal/uportal-impl/3.2.1/uportal-impl-3.2.1-sources.jar
[artifact:mvn] [INFO] ------------------------------------------------------------------------
[artifact:mvn] [INFO] BUILD SUCCESSFUL
[artifact:mvn] [INFO] ------------------------------------------------------------------------
[artifact:mvn] [INFO] Total time: 33 seconds
[artifact:mvn] [INFO] Finished at: Thu Jul 22 10:00:15 CDT 2010
[artifact:mvn] [INFO] Final Memory: 36M/87M
[artifact:mvn] [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 Setting CacheProvider 'org.jasig.portal.utils.cache.hibernate.EhCacheProvider@13ca5df9' on ThreadLocal
[java] INFO Created new lazily initialized GenericApplicationContext for the portal in 8199ms
[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.26) / MySQL-AB JDBC Driver (mysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} )) database/driver
[java] Connected To: jdbc:mysql://newsql.southwestern.edu/uportal32
[java] WARNING: uPortal tables do no exist, not all meta-data tests were executed.
[java]
[java] Database name: 'MySQL'
[java] Database version: '5.0.26'
[java] Driver name: 'MySQL-AB JDBC Driver'
[java] Driver version: 'mysql-connector-java-5.1.6 ( Revision: ${bzr.revision-id} )'
[java] Driver class: 'MySQL-AB JDBC Driver'
[java] Connection URL: 'jdbc:mysql://your.mysql.server/databasename'
[java] User: 'user@yourservername'
[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,....yadda...yadda...,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,..yadda...yadda...,TIME_TO_SEC
[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,...yadda...yadda...,TIMESTAMP
BUILD SUCCESSFUL
Total time: 50 seconds
|
Verify the values on the Database name, Database version, Driver name, Driver version match those entered in dbloader.xml exactly.Download driver / connector; http://dev.mysql.com/downloads/connector/j/5.0.html
| Info | ||
|---|---|---|
| ||
Additional References |
| Warning | ||||
|---|---|---|---|---|
| ||||
Please send us feedback at uportal-user@lists.ja-sig.org |
...