mysql - Jasper Server CE 6.2 在 MySQL 上的安装问题

Question

我正在尝试按照 JasperReports-Server-CP-Install-Guide.pdf 文件(3.2 使用 js-install 脚本安装 WAR 文件)中指定的步骤安装 Jasper Server CE 6.2

更新default_master.properties后，当我尝试使用js-install-ce.bat test命令进行测试运行时，出现以下错误(从日志中提取)

错误详细信息

do-install-upgrade-test:
     [echo] Checking DBMS host and port:
     [echo] About to validate port: mysql-db.company.com:3306
     [echo]   Port 3306 is OK
     [echo] Done validating port: mysql-db.company.com:3306
     [echo] Validating administrative database connection at jdbc:mysql://mysql-db.company.com:3306/mysql. Phase: [test]
     [echo] For JDBC driver the artifactId and version properties are set:
     [echo]   maven.jdbc.artifactId=mariadb-java-client
     [echo]   maven.jdbc.version=1.1.2
     [echo]   Specified JDBC driver jar exists
[advanced-sql] Failed to connect: Could not connect: Access denied for user 'jasper_admin'@'%' to database 'mysql'
     [echo] Connection failed:
     [echo]   SQLState: HY0000
     [echo]   Vendor specific error code: -1
     [echo]   Message: [Could not connect: Access denied for user 'jasper_admin'@'%' to database 'mysql']

BUILD FAILED
E:\Software-Downloads\jasperreports-server-cp-6.2.0-bin\jasperreports-server-cp-6.2.0-bin\buildomatic\bin\validation.xml:495: The following error occurred while executing this line:
E:\Software-Downloads\jasperreports-server-cp-6.2.0-bin\jasperreports-server-cp-6.2.0-bin\buildomatic\bin\validation.xml:376: The following error occurred while executing this line:
E:\Software-Downloads\jasperreports-server-cp-6.2.0-bin\jasperreports-server-cp-6.2.0-bin\buildomatic\conf_source\db\mysql\db.xml:65: The following error occurred while executing this line:
E:\Software-Downloads\jasperreports-server-cp-6.2.0-bin\jasperreports-server-cp-6.2.0-bin\buildomatic\bin\validation.xml:434: The following error occurred while executing this line:
E:\Software-Downloads\jasperreports-server-cp-6.2.0-bin\jasperreports-server-cp-6.2.0-bin\buildomatic\bin\validation.xml:470: Database doesn't exist. Treating problem with JDBC connection as unrecoverable

default_master.properties 文件中的数据库详细信息

# database type
dbType=mysql

# database location and connection settings

dbHost=mysql-db.company.com
dbUsername=jasper_admin
dbPassword=jasper_admin_password


# additional database parameters
# (uncomment these if you want non-default settings)

dbPort=3306

# JasperServer db name, sample db names
js.dbName=jasper
# sugarcrm.dbName=sugarcrm
# foodmart.dbName=foodmart

注意:用户 jasper_admin 已存在于数据库中，并且此连接已测试成功。数据库 jasper 也存在。

我无法以 root 访问权限进行连接!如果有任何解决方法，请建议我。

提前非常感谢您的帮助。

[更新]在错误日志中，我可以看到以下错误

 Could not connect: Access denied for user 'jasper_admin'@'%' to database 'mysql'

但是我在哪里可以看到 Jasper 构建脚本使用什么代码来验证这一点？因为，我可以通过 MySQL 客户端使用同一用户连接到 MySQL 数据库。

Answer 1

问题出在 MySQL 用户“jasper_admin”上。该用户应该有权访问内部数据库 mysql。最好的情况是尝试使用 MySQL“root”用户安装 Jasper。