7 Mart 2013 Perşembe

How to install and configure a Liferay on mysql cluster ndb

Hi all, jdbc.default.url=jdbc:mysql:loadbalance://MYSQLSERVER1:3306,MYSQLSERVER':3306/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false loadBalanceBlacklistTimeout=5000 database.mysql.engine=ndb But when we run the liferay server It fail to create database and say that error no:140. When we googling the error 140, that say that if your database is utf-8 varchar can not be greater than 256 so before we start the liferay portal first we change the database structure. Download the liferay-portal-sql.**.zip then in create-minimal-mysql.sql script find “create table User_” then change “openId varchar(1024) null” to “openId varchar(200) null” and “engine InnoDB;” to “engine NDB;” and run the create script in one of the node. Lastly when you run the liferay portal it run normally. Dont afraid the first creating takes 10 minute or more. create table User_ ( uuid_ varchar(75) null, userId bigint not null primary key, companyId bigint, createDate datetime null, modifiedDate datetime null, defaultUser tinyint, contactId bigint, password_ varchar(75) null, passwordEncrypted tinyint, passwordReset tinyint, passwordModifiedDate datetime null, digest varchar(255) null, reminderQueryQuestion varchar(75) null, reminderQueryAnswer varchar(75) null, graceLoginCount integer, screenName varchar(75) null, emailAddress varchar(75) null, facebookId bigint, openId varchar(200) null, portraitId bigint, languageId varchar(75) null, timeZoneId varchar(75) null, greeting varchar(255) null, comments longtext null, firstName varchar(75) null, middleName varchar(75) null, lastName varchar(75) null, jobTitle varchar(100) null, loginDate datetime null, loginIP varchar(75) null, lastLoginDate datetime null, lastLoginIP varchar(75) null, lastFailedLoginDate datetime null, failedLoginAttempts integer, lockout tinyint, lockoutDate datetime null, agreedToTermsOfUse tinyint, active_ tinyint ) engine NDB;

Hiç yorum yok:

Yorum Gönder