You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by "marble.zhong@coinflex.com" <ma...@coinflex.com> on 2020/06/25 03:11:12 UTC
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/
Re: Ignite authenticationEnabled queries
Posted by Ilya Kasnacheev <il...@gmail.com>.
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, marble.zhong@coinflex.com <
marble.zhong@coinflex.com>:
> 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/
>
Re: Ignite authenticationEnabled queries
Posted by "marble.zhong@coinflex.com" <ma...@coinflex.com>.
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/
Re: Ignite authenticationEnabled queries
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <il...@gmail.com>:
> Hello!
>
> I'm sorry for earlier advice, the correct syntax is:
> ALTER USER "ignite" WITH PASSWORD 'abcdefg' ;
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 25 июн. 2020 г. в 13:10, marble.zhong@coinflex.com <
> marble.zhong@coinflex.com>:
>
>> 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/
>>
>
Re: Ignite authenticationEnabled queries
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <il...@gmail.com>:
> Hello!
>
> I'm sorry for earlier advice, the correct syntax is:
> ALTER USER "ignite" WITH PASSWORD 'abcdefg' ;
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 25 июн. 2020 г. в 13:10, marble.zhong@coinflex.com <
> marble.zhong@coinflex.com>:
>
>> 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/
>>
>
Re: Ignite authenticationEnabled queries
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
I'm sorry for earlier advice, the correct syntax is:
ALTER USER "ignite" WITH PASSWORD 'abcdefg' ;
Regards,
--
Ilya Kasnacheev
чт, 25 июн. 2020 г. в 13:10, marble.zhong@coinflex.com <
marble.zhong@coinflex.com>:
> 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/
>
Re: Ignite authenticationEnabled queries
Posted by "marble.zhong@coinflex.com" <ma...@coinflex.com>.
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/
Re: Ignite authenticationEnabled queries
Posted by Ilya Kasnacheev <il...@gmail.com>.
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, marble.zhong@coinflex.com <
marble.zhong@coinflex.com>:
> 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/
>