Khurram Faraaz created DRILL-4036:
-------------------------------------
Summary: logs/sqlline_queries.json can not be accessed by user
mapr
Key: DRILL-4036
URL: https://issues.apache.org/jira/browse/DRILL-4036
Project: Apache Drill
Issue Type: Bug
Components: Storage - Writer
Affects Versions: 1.3.0
Reporter: Khurram Faraaz
Priority: Minor
Drill was installed using RPM and when I try to connect to Drill from sqlline
as mapr user it results in permission denied error. That file
sqlline_queries.json is always empty, it has no content in it, and it is owned
by root and others can not write to it.
The change was made using he below commit
https://github.com/apache/drill/commit/42d5f818a5501dbd05808c53959db86e66202792
{code}
I logged in as root
[root@centos-01 bin]# id
uid=0(root) gid=0(root) groups=0(root)
Note that the file is owned by root, and non-root users can not write to that
file.
[root@centos-01 bin]# ls -lrt
/opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json
-rw-r--r-- 1 root root 0 Nov 2 20:56
/opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json
and then I connect to Drill as mapr user
[root@centos-01 bin]# su - mapr
-bash-4.1$ pwd
/home/mapr
-bash-4.1$ cd /opt/mapr/drill/drill-1.3.0/bin/
-bash-4.1$ ./sqlline -u "jdbc:drill:schema=dfs.tmp -n mapr -p mapr"
23:30:38,366 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback.groovy]
23:30:38,366 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback-test.xml]
23:30:38,367 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found
resource [logback.xml] at [file:/opt/mapr/drill/drill-1.3.0/conf/logback.xml]
23:30:38,565 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction
- debug attribute not set
23:30:38,571 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About
to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
23:30:38,583 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming
appender as [STDOUT]
23:30:38,613 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA
- Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder]
for [encoder] property
23:30:38,693 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About
to instantiate appender of type
[ch.qos.logback.core.rolling.RollingFileAppender]
23:30:38,696 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming
appender as [QUERY]
23:30:38,722 |-INFO in
ch.qos.logback.core.rolling.FixedWindowRollingPolicy@69663655 - No compression
will be used
23:30:38,736 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA
- Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder]
for [encoder] property
23:30:38,737 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[QUERY] -
Active log file name: /opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json
23:30:38,737 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[QUERY] -
File property is set to [/opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json]
23:30:38,739 |-ERROR in ch.qos.logback.core.rolling.RollingFileAppender[QUERY]
- openFile(/opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json,true) call
failed. java.io.FileNotFoundException:
/opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json (Permission denied)
at java.io.FileNotFoundException:
/opt/mapr/drill/drill-1.3.0/logs/sqlline_queries.json (Permission denied)
at at java.io.FileOutputStream.open(Native Method)
at at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at at
ch.qos.logback.core.recovery.ResilientFileOutputStream.<init>(ResilientFileOutputStream.java:28)
at at
ch.qos.logback.core.FileAppender.openFile(FileAppender.java:149)
at at ch.qos.logback.core.FileAppender.start(FileAppender.java:108)
at at
ch.qos.logback.core.rolling.RollingFileAppender.start(RollingFileAppender.java:86)
at at
ch.qos.logback.core.joran.action.AppenderAction.end(AppenderAction.java:96)
at at
ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:317)
at at
ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:196)
at at
ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:182)
at at
ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:149)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:135)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:99)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:49)
at at
ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
at at
ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:148)
at at
org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:85)
at at
org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
at at org.slf4j.LoggerFactory.bind(LoggerFactory.java:129)
at at
org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:108)
at at
org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:302)
at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:276)
at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:288)
at at org.apache.drill.jdbc.Driver.<clinit>(Driver.java:34)
at at java.lang.Class.forName0(Native Method)
at at java.lang.Class.forName(Class.java:195)
at at
sqlline.DatabaseConnection.connect(DatabaseConnection.java:125)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
