Could not login remotely - VSQL

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

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

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

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

Hi Ujjwal

Please run the query as dbadmin user.

Thanks

Gayatri

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

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.