[
https://issues.apache.org/jira/browse/RANGER-2491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal resolved RANGER-2491.
-------------------------------------
Resolution: Fixed
Seems issue has been fixed in RANGER-2287:
[https://github.com/apache/ranger/commit/21a6d956833545a2b563abc4f284d32afa11f1f0#diff-4a4d52f7367a0b5a95644f7a775b1f3b]
> 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
> Assignee: Pradeep Agrawal
> Priority: Major
> Labels: easyfix
> Fix For: 2.0.0
>
>
> 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.14#76016)
