无法在windows中将mysql与liferay连接

vfh0ocws  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(428)

我已经使用 create database dblife character set utf8 . 我用的是mysql版本 8.0.11 和mysql连接器版本 5.1.4 . 在下载mysql连接器之后,我已经替换了 .jar 文件与 Mysql.jar 内部 lib/ext 目录。所以,当我运行liferay服务器版本时 6.2 ,它给出如下错误。
在eclipse控制台上出现错误:

09:51:13,420 INFO  [localhost-startStop-1][DialectDetector:71] Determine dialect for MySQL 8
09:51:13,445 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect org.hibernate.dialect.MySQLDialect
    09:40:37,209 INFO  [http-bio-8080-exec-2][StartupAction:97] There are no patches installed
09:40:37,216 ERROR [http-bio-8080-exec-2][JDBCExceptionReporter:82] Table 'dblife.lock_' doesn't exist
09:40:37,221 WARN  [http-bio-8080-exec-2][StartupAction:147] Unable to clear locks because Lock table does not exist
09:40:37,223 WARN  [http-bio-8080-exec-2][ReleaseLocalServiceImpl:171] Table 'dblife.release_' doesn't exist
09:40:37,226 INFO  [http-bio-8080-exec-2][ReleaseLocalServiceImpl:84] Create tables and populate with default data
09:40:38,058 WARN  [http-bio-8080-exec-2][BaseDB:457] 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 'system tinyint,    maxUsers integer,   active_ tinyint) engine InnoDB' at line 1: create table Company (   companyId bigint not null primary key,  accountId bigint,   webId varchar(75) null, key_ longtext null, mx varchar(75) null,    homeURL longtext null,  logoId bigint,  system tinyint, maxUsers integer,   active_ tinyint) engine InnoDB;_ [Sanitized]
09:40:47,056 WARN  [http-bio-8080-exec-2][BaseDB:457] Table 'dblife.company' doesn't exist: create index IX_38EFE3FD on Company (logoId);_ [Sanitized]
09:40:47,058 WARN  [http-bio-8080-exec-2][BaseDB:457] Table 'dblife.company' doesn't exist: create index IX_12566EC2 on Company (mx);_ [Sanitized]
09:40:47,059 WARN  [http-bio-8080-exec-2][BaseDB:457] 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 'system)' at line 1: create index IX_35E3E7C6 on Company (system);_ [Sanitized]
09:40:47,060 WARN  [http-bio-8080-exec-2][BaseDB:457] Table 'dblife.company' doesn't exist: create unique index IX_EC00543C on Company (webId);_ [Sanitized]
09:40:58,636 WARN  [http-bio-8080-exec-2][BaseDB:457] Specified key was too long; max key length is 3072 bytes: create index IX_7020130F on SCProductVersion (directDownloadURL);_ [Sanitized]
09:40:58,637 ERROR [http-bio-8080-exec-2][BaseDB:464] create index IX_7020130F on SCProductVersion (directDownloadURL);
09:41:01,417 WARN  [http-bio-8080-exec-2][BaseDB:457] Specified key was too long; max key length is 3072 bytes: create index IX_89509087 on User_ (companyId, openId);_ [Sanitized]
09:41:01,418 ERROR [http-bio-8080-exec-2][BaseDB:464] create index IX_89509087 on User_ (companyId, openId);
09:41:03,401 INFO  [http-bio-8080-exec-2][BaseDB:484] Database does not support case sensitive queries
09:41:04,169 INFO  [http-bio-8080-exec-2][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProcessSuite
09:41:04,170 INFO  [http-bio-8080-exec-2][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProperties
09:41:04,195 ERROR [http-bio-8080-exec-2][DBUpgrader:247] Unable to execute verify process: com.liferay.portal.verify.VerifyException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dblife.company' doesn't exist
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dblife.company' doesn't exist

Caused by: com.liferay.portal.verify.VerifyException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dblife.company' doesn't exist

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dblife.company' doesn't exist

此外,我无法补充 portal-ext.properties 内部 liferay.home 目录。当我加上这个 portal-ext.properties 文件,然后我得到错误: Liferay v6.2(tomcat7 在localhost上遇到了一个问题。
我已经检查了现有的解决方案liferay不使用mysql,但是我看不到 Database Migration 控制面板>管理工具中的选项
谁能给我建议一个解决办法吗。我将非常感谢你。

htzpubme

htzpubme1#

安装liferay时,需要对数据库具有create table和其他ddl权限。确保将这些权限授予运行liferay的用户。一旦创建了表,您就可以撤消它们—安装之后,liferay只需要标准的crud操作(直到您升级或部署需要此类权限的新组件)。
另外,liferay 6.2比MySQL8早了几年——可以肯定的是,这两个版本从未一起测试过,我建议使用经过测试的数据库,而不是像以前没有人尝试过的那样尝试工作。您可以在兼容性列表中找到企业支持的版本。

相关问题