[
https://issues.apache.org/jira/browse/DRILL-4036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-4036.
-----------------------------------
Resolution: Invalid
Drill doesn't have an RPM. This sounds like it has to do with the MapR RPM
packaging which is outside the scope of this JIRA
> 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)
