Connection to Impala with LDAP Authentication

[amartira]

It is possible to connect to Impala with LDAP Authentication rather than Kerberos Auth???

Principal is a parameter of "connect" function but i cant set a user and password instead. It should look like this:

"jdbc:hive2://:/;user=;password="

Is it possible??

Thank you!

[nagarajjayakumar]

Yes you can connect R IMPALA using LDAP authentication

[opanito]

Hi - Nagarajjayakumar, Can you provide an example how to connect to a secured cloudera cluster that is using LDAP?

Thanks

[nagarajjayakumar]

Hi

R Impala connector code is a Jdbc based.

Modified the connector code to connect to LDAP authentication enabled Impala server.

Deploy the jar and modify rimpala Python script to use new library

Please let me know if u need more info

On Saturday, December 5, 2015, opanito notifications@github.com wrote:

Hi - Nagarajjayakumar, Can you provide an example how to connect to a secured cloudera cluster that is using LDAP?

Thanks

— Reply to this email directly or view it on GitHub https://github.com/Mu-Sigma/RImpala/issues/2#issuecomment-162269143.

[opanito]

Thanks for the quick response.
I am not too familiar on how this work. I am assuming that i can open one of the downloaded custom Jars for cloudera R impala and change the connection there, then call rimpala.connect() and that should work?

On Dec 6, 2015, at 8:07 AM, nagarajjayakumar notifications@github.com wrote:

Hi

R Impala connector code is a Jdbc based.

Modified the connector code to connect to LDAP authentication enabled Impala server.

Deploy the jar and modify rimpala Python script to use new library

Please let me know if u need more info

On Saturday, December 5, 2015, opanito notifications@github.com wrote:

Hi - Nagarajjayakumar, Can you provide an example how to connect to a secured cloudera cluster that is using LDAP?

Thanks

— Reply to this email directly or view it on GitHub https://github.com/Mu-Sigma/RImpala/issues/2#issuecomment-162269143.

— Reply to this email directly or view it on GitHub.

[nagarajjayakumar]

You can use the source code in github....it is a simple Jdbc Java code...

You need to modify r Impala py script to use ur new jar

On Sunday, December 6, 2015, opanito notifications@github.com wrote:

Thanks for the quick response. I am not too familiar on how this work. I am assuming that i can open one of the downloaded custom Jars for cloudera R impala and change the connection there, then call rimpala.connect() and that should work?

On Dec 6, 2015, at 8:07 AM, nagarajjayakumar <notifications@github.com javascript:_e(%7B%7D,'cvml','notifications@github.com');> wrote:

Hi

R Impala connector code is a Jdbc based.

Modified the connector code to connect to LDAP authentication enabled Impala server.

Deploy the jar and modify rimpala Python script to use new library

Please let me know if u need more info

On Saturday, December 5, 2015, opanito <notifications@github.com javascript:_e(%7B%7D,'cvml','notifications@github.com');> wrote:

Hi - Nagarajjayakumar, Can you provide an example how to connect to a secured cloudera cluster that is using LDAP?

Thanks

— Reply to this email directly or view it on GitHub https://github.com/Mu-Sigma/RImpala/issues/2#issuecomment-162269143.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/Mu-Sigma/RImpala/issues/2#issuecomment-162336502.

[opanito]

I found this source code: https://github.com/Mu-Sigma/RImpala/tree/master/src/R line 74-75 shows this: rimpala.connect <- function(IP="localhost",port="21050",principal="noSasl"){ impalaObj = .jnew("com.musigma.ird.bigdata.RImpala") You think replacing this with this line would work:
function('jdbc:hive2://ip.localhost.local:21050/; user1@localhost.local; password="" ') then recompiling? If not, are you available to show me?

Thanks.

[nagarajjayakumar]

You need to modify the Java code om.musigma.ird.bigdata.RImpala and build the jar ,,,

Then you need to repoint the R script to new jar

On Monday, December 7, 2015, opanito notifications@github.com wrote:

I found this source code: https://github.com/Mu-Sigma/RImpala/tree/master/src/R line 74-75 shows this: rimpala.connect <- function(IP="localhost",port="21050",principal="noSasl"){ impalaObj = .jnew("com.musigma.ird.bigdata.RImpala") You think replacing this with this line would work:

function('jdbc:hive2://ip.localhost.local:21050/; user1@localhost.local javascript:_e(%7B%7D,'cvml','user1@localhost.local');; password="" ') then recompiling? If not, are you available to show me?

Thanks.

— Reply to this email directly or view it on GitHub https://github.com/Mu-Sigma/RImpala/issues/2#issuecomment-162413435.

[opanito]

This is what i found:

public static boolean connect(String IP, String port, String principal) {

    CONNECTION_URL = "jdbc:hive2://" + IP + ':' + port + "/;" + principal;

    try {
        Class.forName(JDBC_DRIVER_NAME);
        con = DriverManager.getConnection(CONNECTION_URL);
        con.setAutoCommit(false);
        return true;

which line do I need to change to What? sorry i am new to java.

[opanito]

Amarita noted: "jdbc:hive2://:/;user=;password=" I am wondering if this worked.

[opanito]

Here are my changes:

public static boolean connect(String IP, String port, String user, String password) {

    CONNECTION_URL = "jdbc:hive2://" + IP + ':' + port + "/;" + user + "/;" + password;

[opanito]

HI, I was able to connect to the secured cluster using a 32-bit version of Cloudera ODBC connector and R 32 bit. My next step is to try the option of compiling the Java code.

Thanks for your help!