Ignite authenticationEnabled queries

classic Classic list List threaded Threaded
7 messages Options
marble.zhong@coinflex.com marble.zhong@coinflex.com
Reply | Threaded
Open this post in threaded view
|

Ignite authenticationEnabled queries

Hi Guru,

Enabled the authentication with below configuration, it is ok for jdbc thin
client with ignite/ignite to connect to server, but found cannot change
ignite's password, will say no this user.

And created new user cannot access, and no where to grant priviledges, how
can we go? thanks a lot.

<property name="authenticationEnabled" value="true"/>



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Ignite authenticationEnabled queries

Hello!

Try ALTER USER "ignite" SET PASSWORD 'NewPassword'.

WRT grants, we do not have granular object in JDBC authentication currently, except by using a 3rd party security plugin.

Regards,
--
Ilya Kasnacheev


чт, 25 июн. 2020 г. в 06:11, [hidden email] <[hidden email]>:
Hi Guru,

Enabled the authentication with below configuration, it is ok for jdbc thin
client with ignite/ignite to connect to server, but found cannot change
ignite's password, will say no this user.

And created new user cannot access, and no where to grant priviledges, how
can we go? thanks a lot.

<property name="authenticationEnabled" value="true"/>



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
marble.zhong@coinflex.com marble.zhong@coinflex.com
Reply | Threaded
Open this post in threaded view
|

Re: Ignite authenticationEnabled queries

not works, still show error,

ALTER USER "ignite" SET password 'abcdefg' ;                                                                                                                                                                                            

SQL Error [1001] [42000]: Failed to parse query. User "ignite" not found;
SQL statement:
ALTER USER "ignite" SET password 'abcdefg' [90032-197]



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Ignite authenticationEnabled queries

Hello!

I'm sorry for earlier advice, the correct syntax is:
ALTER USER "ignite" WITH PASSWORD 'abcdefg' ;

Regards,
--
Ilya Kasnacheev


чт, 25 июн. 2020 г. в 13:10, [hidden email] <[hidden email]>:
not works, still show error,

ALTER USER "ignite" SET password 'abcdefg' ;                                                                                                                                                                                             

SQL Error [1001] [42000]: Failed to parse query. User "ignite" not found;
SQL statement:
ALTER USER "ignite" SET password 'abcdefg' [90032-197]



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Ignite authenticationEnabled queries

Hello!

I have filed a ticket about this mismatch: https://issues.apache.org/jira/browse/IGNITE-13184

Regards,
--
Ilya Kasnacheev


чт, 25 июн. 2020 г. в 13:48, Ilya Kasnacheev <[hidden email]>:
Hello!

I'm sorry for earlier advice, the correct syntax is:
ALTER USER "ignite" WITH PASSWORD 'abcdefg' ;

Regards,
--
Ilya Kasnacheev


чт, 25 июн. 2020 г. в 13:10, [hidden email] <[hidden email]>:
not works, still show error,

ALTER USER "ignite" SET password 'abcdefg' ;                                                                                                                                                                                             

SQL Error [1001] [42000]: Failed to parse query. User "ignite" not found;
SQL statement:
ALTER USER "ignite" SET password 'abcdefg' [90032-197]



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
marble.zhong@coinflex.com marble.zhong@coinflex.com
Reply | Threaded
Open this post in threaded view
|

Re: Ignite authenticationEnabled queries

thanks a lot, with statement works.

Btw, created a new user , but cannot connect to the instance, anything else
need settle done? thanks




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Ignite authenticationEnabled queries

Hello!

Make sure user's login is "in quotes", otherwise it will be case-insensitive, i.e. ALLCAPS login.

Regards,
--
Ilya Kasnacheev


пт, 26 июн. 2020 г. в 05:02, [hidden email] <[hidden email]>:
thanks a lot, with statement works.

Btw, created a new user , but cannot connect to the instance, anything else
need settle done? thanks




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/