[
https://issues.apache.org/jira/browse/RANGER-3687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17523868#comment-17523868
]
Pradeep Agrawal commented on RANGER-3687:
-----------------------------------------
Reverted this commit as ranger install is failing for me with this patch.
{code:java}
2022-04-18 19:33:39,125 [JISQL] /usr/java/jdk1.8.0_232-cloudera/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/root/ranger-3.0.0-SNAPSHOT-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger1?useSSL=false -u 'rangeradmin' -p '********'
-noheader -trim -c \; -input
/root/ranger-3.0.0-SNAPSHOT-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class
is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the
SPI and manual loading of the driver class is generally unnecessary.
Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL
AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time` datetime
DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL, `upd_by_id` bigint(20)
DEFAULT NULL, `first_name` varchar(1022) DEFAULT NULL, `last_name`
varchar(1022) DEFAULT NULL, `pub_scr_name` varchar(2048) DEFAULT NULL,
`login_id` varchar(767) DEFAULT NULL, `password` varchar(512) NOT NULL,
`email` varchar(512) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0',
`user_src` int(11) NOT NULL DEFAULT '0', `notes` varchar(4000) DEFAULT NULL,
`other_attributes` varchar(4000) DEFAULT NULL, `sync_source` varchar(4000)
DEFAULT NULL, `old_passwords` varchar(4000) DEFAULT NULL,
`password_updated_time` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE
KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
`x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
(`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
`x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
(`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
`x_portal_user_email` (`email`), CONSTRAINT `x_portal_user_FK_added_by_id`
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), CONSTRAINT
`x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES
`x_portal_user` (`id`) ) ROW_FORMAT=DYNAMIC;
java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for
the used table type, not counting BLOBs, is 65535. This includes storage
overhead, check the manual. You have to change some columns to TEXT or BLOBs
SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: Row size too
large. The maximum row size for the used table type, not counting BLOBs, is
65535. This includes storage overhead, check the manual. You have to change
some columns to TEXT or BLOBs ErrorCode: 1118
2022-04-18 19:33:39,706 [E] ranger_core_db_mysql.sql file import failed!
2022-04-18 19:33:39,706 [I] Unable to create DB schema, Please drop the
database and try again
2022-04-18 19:33:39,706 [JISQL] /usr/java/jdk1.8.0_232-cloudera/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/root/ranger-3.0.0-SNAPSHOT-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger1?useSSL=false -u 'rangeradmin' -p '********'
-noheader -trim -c \; -query "delete from x_db_version_h where version =
'CORE_DB_SCHEMA' and active = 'N' and
updated_by='pa7215-3.pa7215.root.hwx.site';"
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class
is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the
SPI and manual loading of the driver class is generally unnecessary.
2022-04-18 19:33:40,254 [E] CORE_DB_SCHEMA import failed! {code}
> Password Policy Best Practices for Strong Security
> --------------------------------------------------
>
> Key: RANGER-3687
> URL: https://issues.apache.org/jira/browse/RANGER-3687
> Project: Ranger
> Issue Type: Improvement
> Components: Ranger
> Affects Versions: 3.0.0, 2.3.0
> Reporter: Bhavik Patel
> Assignee: Bhavik Patel
> Priority: Major
> Fix For: 3.0.0, 2.3.0
>
>
> # Password history should be configured to restrict users from reusing their
> last 4 or 5 passwords.
> # Forcing users to change passwords every 90-180 days
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
