Aset Madraimov created RANGER-2491:
--------------------------------------
Summary: Incorrect syntax for setting options in the database
configuration script (db_setup.py)
Key: RANGER-2491
URL: https://issues.apache.org/jira/browse/RANGER-2491
Project: Ranger
Issue Type: Bug
Components: admin
Affects Versions: 1.2.0
Reporter: Aset Madraimov
During the installation of the ranger, an error occurred about the incorrect
syntax for setting options for the postgres database:
{{2019-06-27 11:40:19,818 [JISQL] /usr/java/default/bin/java -cp
/usr/share/java/postgresql.jar:/hdd/data01/ranger/ranger-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver postgresql -cstring
jdbc:postgresql://kz-dmpignt13/ranger -u rangerdba -p '********' -noheader
-trim -c \; -query "set option public.reserved_keywords='LIMIT';"}}
{{SQLException : SQL state: 42601 org.postgresql.util.PSQLException: ERROR:
syntax error at or near "public"}}
{{ Position: 13 ErrorCode: 0}}
According to official documentation, the word option is not needed.
[https://www.postgresql.org/docs/current/sql-set.html]
In this case statement:
{{set option public.reserved_keywords='LIMIT';}}
The statement should be:
{{set public.reserved_keywords='LIMIT';}}
I manually deleted the option word in the script, after which the installation
was successful. Please check the database configuration script.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
