[Ejbca-develop] EJBCA Community 6.10.1.2 : Database problem while install

[Christian F. <pu...@fe...>]

Hello,

while testing ejbca-setup with 6.10.1.2 following problem occurs while
install process:

Data too long for column 'clearPassword' at row 1

which is caused by a SQL declaration for clearPassword with a length of
250. Wildfly log shows a real length of 517. For now a very nasty hack
in ejbca-setup fixes that:

doPatch() {
  if [ $EJBCA_RELEASE == "6_10_1_2" ]; then
    cd ejbca || exit 1
    sed -i.bak 's/<basic fetch="EAGER" name="clearPassword"><column
name="clearPassword" column-definition="VARCHAR(250)
BINARY"\/><\/basic>/<basic fetch="EAGER" name="clearPassword"><column
name="clearPassword" column-definition="VARCHAR(1000)
BINARY"\/><\/basic>/g' modules/ejbca-entity/resources/orm-ejbca-
mysql.xml || exit 1
    echo "patch for 6_10_1_2 applied"
    cd ..
  fi
}


Christian