drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4036) logs/sqlline_queries.json can not be accessed by user mapr
Date Thu, 05 Nov 2015 04:09:27 GMT
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)

Mime
View raw message