Red Hat Bugzilla – Bug 1210763
[ovirt-hosted-engine-setup] script doesn't validate user input for username for iscsi storage domain > 50 characters.
Last modified: 2016-03-09 14:11:38 EST
Description of problem: hosted-engine --deploy fails with internal engine error 2015-04-08 17:36:44,251 INFO [org.ovirt.engine.core.bll.AddDiskCommand] (ajp-/127.0.0.1:8702-7) [35de27da] Running command: AddDiskCommand internal: false. Entities affected : ID: aaa00000-0000-0000-0000-12345 6789aaa Type: SystemAction group CREATE_DISK with role type USER, ID: aaa00000-0000-0000-0000-123456789aaa Type: SystemAction group CONFIGURE_SCSI_GENERIC_IO with role type ADMIN 2015-04-08 17:36:44,312 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (ajp-/127.0.0.1:8702-7) [35de27da] transaction rolled back 2015-04-08 17:36:44,313 ERROR [org.ovirt.engine.core.bll.AddDiskCommand] (ajp-/127.0.0.1:8702-7) [35de27da] Command org.ovirt.engine.core.bll.AddDiskCommand throw exception: org.springframework.dao.DataIntegrity ViolationException: CallableStatementCallback; SQL [{call insertstorage_server_connections(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: value too long for type character varying(50) Where: SQL statement "INSERT INTO storage_server_connections(connection, id, iqn, port,portal, password, storage_type, user_name,mount_options,vfs_type,nfs_version,nfs_timeo,nfs_retrans) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 )" PL/pgSQL function "insertstorage_server_connections" line 2 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(50) Where: SQL statement "INSERT INTO storage_server_connections(connection, id, iqn, port,portal, password, storage_type, user_name,mount_options,vfs_type,nfs_version,nfs_timeo,nfs_retrans) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 )" PL/pgSQL function "insertstorage_server_connections" line 2 at SQL statement at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) [spring-jdbc.jar:3.1.1.RELEASE] Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(50) Where: SQL statement "INSERT INTO storage_server_connections(connection, id, iqn, port,portal, password, storage_type, user_name,mount_options,vfs_type,nfs_version,nfs_timeo,nfs_retrans) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 )" PL/pgSQL function "insertstorage_server_connections" line 2 at SQL statement Version-Release number of selected component (if applicable): latest How reproducible: Always Steps to Reproduce: 1. hosted-engine --deploy, specify username for iscsi storage domain > 50 characters Actual results: RuntimeError('Cannot add the Hosted Engine VM Disk to the engine',) Expected results: User gets a warning that username is not valid, as database limits it to 50 characters [ varying(50)] Additional info:
User and password length validation is done: Entered a username with more than 50 characters: [ ERROR ] Username should not be longer than 50 characters. Entered a password with more than 50 characters: Please specify the iSCSI portal password: [ ERROR ] Password should not be longer than 50 characters. Verified using: ovirt-3.6.0-alpha3 ovirt-hosted-engine-ha-1.3.0-0.0.master.20150615153650.20150615153645.git5f8c290.el7.noarch ovirt-hosted-engine-setup-1.3.0-0.0.master.20150729070044.git26149d7.el7.noarch iptables-services-1.4.21-13.el7.x86_64 iptables-1.4.21-13.el7.x86_64 vdsm-4.17.0-1229.git8299061.el7.noarch
wrong component, changed to hosted-engine-setup
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHEA-2016-0375.html