Ranger 安装报错日志

1，导入失败，log_bin_trust_function_creators 为 OFF

Error executing: CREATE FUNCTION `getXportalUIdByLoginId`(input_val VARCHAR(100)) RETURNS int(11) BEGIN DECLARE myid INT; SELECT x_portal_user.id into myid FROM x_portal_user WHERE x_portal_user.login_id = input_val; RETURN myid; END  
java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
SQLException : SQL state: HY000 java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) ErrorCode: 1418
2022-01-04 10:38:19,847  [E] ranger_core_db_mysql.sql file import failed!
2022-01-04 10:38:19,848  [I] Unable to create DB schema, Please drop the database and try again
2022-01-04 10:38:19,848  [JISQL] /data/module/jdk1.8.0_212/bin/java  -cp /data/software/mysql-connector-java-5.1.48.jar:/data/module/ranger/ranger-2.2.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://stars-bigdata-01/ranger -u 'ranger' -p '********' -noheader -trim -c \;  -query "delete from x_db_version_h where version = 'CORE_DB_SCHEMA' and active = 'N' and updated_by='stars-bigdata-01';"
Tue Jan 04 10:38:20 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2022-01-04 10:38:20,403  [E] CORE_DB_SCHEMA import failed!

useSSL=false 的异常报警，配置里面已经设置了false，但是安装还是打印，先不用管

查看 log_bin_trust_function_creators 数据库配置

mysql> show variables like '%func%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------+
1 row in set (0.00 sec)

 修改配置

mysql> set global log_bin_trust_function_creators=1;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%func%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON    |
+---------------------------------+-------+
1 row in set (0.00 sec)

删除ranger 数据库，重新安装

mysql> drop database ranger;
Query OK, 73 rows affected (0.94 sec)

mysql> create database ranger;
Query OK, 1 row affected (0.00 sec)

[root@stars-bigdata-01 ranger-2.0.0-admin]# ./setup.sh

安装完，启动服务

[root@stars-bigdata-01 ranger-2.0.0-admin]# sudo -i -u ranger ranger-admin start