Page 2 of 2 First 12
  • Jump to page:
    #16
  1. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Mar 2003
    Posts
    1,019
    Rep Power
    35
    The odbc_connect() should be using the username and password that I'm passing it and the error that I'm getting is telling me that it's completely ignoring my username and password.
    [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AuthorizationException: User 'servername$@domain.COM' does not have privileges to execute 'SELECT' on: database.table
    'servername$@domain.COM' is not my user in the code below. This is the same issue I had when I started the thread, isn't there any way to force it to use the username and password that I'm passing it?
    Can anyone help?

    The error happens on the last line below
    PHP Code:
    $conn odbc_connect("Sample Cloudera Impala DSN_32""user""password");  
    if( 
    $conn === false ) {die( print_rodbc_errormsg(), true));}  
        
      
    $DispQuery "select shipto from database.table limit 1;";  
      
    $DispResult odbc_exec($conn,$DispQuery);  
        if( 
    $DispResult === false) {die( print_rodbc_errormsg(), true) );}  
        while( 
    $Row odbc_fetch_array$DispResultODBC_FETCH_ASSOC) )  
        {  
            
    $RowShipto $Row["shipto"];  
        }  
          
      echo 
    $RowShipto;  
        
      
    odbc_close($conn);  
      exit; 
  2. #17
  3. Maddening Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,504
    Rep Power
    9645
    Please try to pay attention. We're now back to your original problem that started this thread and I'm getting tired trying to explain things if you're not learning.

    Look at the four authentication methods and pick the one that sounds like it should be what you're using. Then make sure you've entered any additional information that you need to enter having made your choice.

    Now,
    1. Exactly which method did you choose and what, if any, information did you enter according to that choice?
    2. Does it work?
  4. #18
  5. No Profile Picture
    Super Moderator
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Jun 2009
    Location
    Hartford, WI
    Posts
    1,531
    Rep Power
    111
    Sorry for a side reference. Just figured I hope this may help with it's visual options/layout...
    https://sskaje.me/2014/07/php-odbc-c...a-impala-hive/

    Comments on this post

    • requinix agrees
    He who knows not that he knows not is a fool, ignore him. He who knows that he knows not is ignorant, teach him. He who knows not that he knows is asleep, awaken him. He who knows that he knows is a leader, follow him.
Page 2 of 2 First 12
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo