[TRAFODION-2490] pyinstaller - admin user setup gives syntax error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Component/s: installer
• Environment: single-node cluster
• Assignee: Yi (Eason) Zhang
• Reporter: Steve Varnau
• Created: 17/Feb/17 17:47
• Updated: 17/Feb/17 17:47

Description

I worked around the sqconfig problem (TRAFODION-2489), and then ran into this error:

Host [slave-ahw23]: Script [traf_start.py] ...................................... [ FAIL ]
Failed to setup security for trafodion:
Apache Trafodion Conversational Interface 2.1.0
Copyright (c) 2015-2016 Apache Software Foundation
>>
— SQL operation complete.

— SQL operation complete.
>>

End of MXCI Session

Apache Trafodion Conversational Interface 2.1.0
Copyright (c) 2015-2016 Apache Software Foundation
>>

• • • ERROR[15001] A syntax error occurred at or before:
      alter user DB__ADMIN set external name admin;
      ^ (44 characters from start of SQL statement)

• • • ERROR[8822] The statement was not prepared.

>>

End of MXCI Session

====================
I tried to run with as many defaults as possible. This is the set-up for the configuration file:

cp ./python-installer/configs/db_config_default.ini ./Install_Config
echo "node_list = $(hostname -s)" >> ./Install_Config
echo "first_rsnode = $(hostname -s)" >> ./Install_Config
echo "ldap_identifiers = uid=,ou=users,dc=trafldap,dc=com" >> ./Install_Config
echo "ldap_security = Y" >> ./Install_Config
echo "ldap_hosts = static.trafodion.org" >> ./Install_Config
if rpm -q cloudera-manager-server >/dev/null
then
echo "mgr_url = $(hostname -f):7180" >> ./Install_Config
elif rpm -q ambari-server >/dev/null
then
echo "mgr_url = $(hostname -f):8080" >> ./Install_Config
fi
echo "java_home = $TRAFJAVA" >> ./Install_Config
echo "traf_package = $trafball" >> ./Install_Config

echo "traf_dirname = traf_run" >> ./Install_Config

echo "*** Calling db_install.py"
./python-installer/db_install.py --verbose --silent --config-file ./Install_Config