Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

2020-03-23 Thread Ilya Kasnacheev 
Hello!

I have just rechecked this case:
1) start persistent node.
2) try changing password - failure (cluster not active)
3) activate cluster (control.sh --activate, ignite/ignite)
4) try changing password - success.
5) check with sqlline - new password (test) accepted.
6) try connecting with thin client and ignite/ignite again - failure.

Are you sure you're not losing your cluster together with all data between
runs?

igniteClient.query(new SqlFieldsQuery("ALTER USER \"ignite\" WITH
PASSWORD 'test'")).getAll();


Regards,
-- 
Ilya Kasnacheev


ср, 18 мар. 2020 г. в 11:47, DS :

>
>
> igniteClient.query(new SqlFieldsQuery(" ALTER USER 'ignite' WITH PASSWORD
> 'password' "));
>
> igniteClient.query(new SqlFieldsQuery(" ALTER USER "ignite'' WITH PASSWORD
> 'password' "));
>
> 1) Both give the same result. i.e query runs without throwing any
> error/exception.
>
> 2) Unable to connect with the new password.
>
> 3) Again tried with 'ignite' as password, it connects back.
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

2020-03-18 Thread DS 



igniteClient.query(new SqlFieldsQuery(" ALTER USER 'ignite' WITH PASSWORD
'password' "));

igniteClient.query(new SqlFieldsQuery(" ALTER USER "ignite'' WITH PASSWORD
'password' "));

1) Both give the same result. i.e query runs without throwing any
error/exception.

2) Unable to connect with the new password.

3) Again tried with 'ignite' as password, it connects back.




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

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

2020-03-17 Thread dbutkovic 
 I think that username must be in single quote without \

igniteClient.query(new SqlFieldsQuery(" ALTER USER 'ignite' WITH PASSWORD
'password' "));



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

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

2020-03-17 Thread DS 
Hello,

The below query ran without throwing any error. :

  igniteClient.query(new SqlFieldsQuery("ALTER USER \"ignite\" WITH
PASSWORD 'password'"));

But  when I am trying  to connect with new password i.e.
 ClientCfg.setUserName("ignite");
 ClientCfg.setUserPassword("password");
 Ignition.startClient(ClientCfg)

It throws an exception >
SEVERE: The user name or password is incorrect [userName=ignite]





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

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

2020-03-17 Thread Ilya Kasnacheev 
Hello!

ALTER USER "ignite" WITH PASSWORD 'new password';

Yep!

Regards,
-- 
Ilya Kasnacheev


вт, 17 мар. 2020 г. в 15:00, dbutkovic :

> try with ALTER USER 'ignite' WITH PASSWORD 'test'
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

2020-03-17 Thread dbutkovic 
try with ALTER USER 'ignite' WITH PASSWORD 'test'





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