Could not login remotely - VSQL

Comments

• Options

  Gayatri_R

  April 2016

  Hi Ujjwal,

   

  The screenshots show that you've used different users in the successful and unsuccessful connection attempts.

   

  1. Please run

   

  select * from users where is_locked;

   

  and see if user pm_0405xx_analytics account is locked.

   

  2. Then use ALTER USER to unlock the acccount (Doc reference : https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/ALTERUSER.htm )

   

  Hope this helps

   

  Gayatri

   

   

   

  0
• Options

  UJJWAL_RANA

  April 2016

  Hi Gayatri

  Thanks for the response. Please find the attached screenshot for the above query which you have requested for. Now its locked but before when it was un locked the main problem is the following user pm_0405xx_data , pm_0405xx_config, pm_0405xx_analytics  could not login from remote ip 10.70.2.104 whereas if i try to login with the same user pm_0405xx_data, pm_0405xx_config, pm_0405xx_analytics from 10.70.31.43 ip then it get successfully login. So the problem is 10.70.2.104 is an REMOTE IP where trying login with the above user from remote based ip 10.70.2.104 is not working.

   

  So my question is despite of account unlock if the login access failed while login from remotely then what activities do i need to care about. please advise

   

  Regards

   

  Ujjwal

  0
• Options

  Gayatri_R

  April 2016

  Hi Ujjwal,

   

  Thanks for clarifying the issue.

   

  How have you defined the client authentication in Vertica?

   

  the output of "select * from client_auth;" will show you the current authentication records.

   

  Please check the examples listed here : https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATEAUTHENTICATION.htm

   

  I suspect that you have defined access method HOST which is restricting these users to specific hosts. Alter it to include the 10.70.2.x IPs.

   

  Thanks

  Gayatri

  0
• Options

  UJJWAL_RANA

  April 2016

  Hello Gayatri

  I ran this statement but it showing blank output..I mean there is no any records inside this table.

   

  select * from client_auth;

   

  So do you mean that i need to provide authentication so that the user can login remotely from other ip ?

   

  Regards

   

  ujjwal

  0
• Options

  Gayatri_R

  April 2016

  Hi Ujjwal

   

  Please run the query as dbadmin user.

   

  Thanks

  Gayatri

   

  0
• Options

  UJJWAL_RANA

  April 2016

  Hi Gayatri

  Please find the output for following query statement from below. It shows 0 rows.

   

  dbadmin=> select * from client_auth;

  
   auth_oid | auth_name | is_auth_enabled | auth_host_type | auth_host_address | auth_method | auth_parameters | auth_priority
  ----------+-----------+-----------------+----------------+-------------------+-------------+-----------------+---------------
  (0 rows)
  
  dbadmin=>

   

  Will look forward to hear from you

   

  Thanks

   

  Ujjwal

  0
• Options

  Sashidhar_Arcot

  April 2016

  From your screen shot four.jpg, it is account lock issue. If it fails, the vsql will tell you why it fails.

   

  Since you dont have client_auth records, it should not fail. 

   

  If it fails even after unlock, please attach the screen shot of the failure. Also, attach the screen shot of the users table showing it is unlocked. 

   

   

  0