InTouch, Archestra IDE - Reset/Find/Break - password

Прочие SCADA: iFix, InTouch, Citect, ...
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

On computer installed and running Arhestra IDE (InTouch )
When I try to connect to the Galaxy, the system asks for username and password, i do not know user and password.
How can be Reset/Find/Break - password.


Image
leocdms
Posts: 6
Joined: Tue Oct 30, 2012 3:10 pm

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by leocdms »

hello y'all !

Sorry oleksandr_ua but I'm not coming with the solution. In fact to endorse your claim.

I have the same problem.

Does any one can help us !!! Please !!
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

How can I copy a windows from password-protected project to my project.
to at least look to what tags attached objects.
jiwoon
Posts: 1
Joined: Sat Jan 17, 2009 11:06 am
Location: CHINA

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by jiwoon »

open your project Database and find the table "user_profile",edit it flow blew:
find have "Administrator" row and change
usrer_guid change to f10f8ca3-15f4-4a26-937a-a45532036ea5
password_hash change to 2039933623

now
you can use administrator and password:123456 to open the project!
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

where it is stored and the name of this file? (oo) (oo) (oo) (oo)

C:\Program Files\ArchestrA\Framework\Bin\GalaxyData - - ???
Schtiel
Site Admin
Posts: 1122
Joined: Wed Sep 06, 2006 12:03 pm
Location: CIS

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by Schtiel »

oleksandr_ua wrote:where it is stored and the name of this file?
It's not about file, it's about table in database. Open SQL Management Studio, choose Galaxy database, find table user_profile and modify one row in it.
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

jiwoon wrote:open your project Database and find the table "user_profile",edit it flow blew:
find have "Administrator" row and change
usrer_guid change to f10f8ca3-15f4-4a26-937a-a45532036ea5
password_hash change to 2039933623

now
you can use administrator and password:123456 to open the project!
can not find "Administrator" (h) (h) (h) (h)
where i can find...

Image
Schtiel
Site Admin
Posts: 1122
Joined: Wed Sep 06, 2006 12:03 pm
Location: CIS

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by Schtiel »

oleksandr_ua wrote:can not find "Administrator" (h) (h) (h) (h)
where i can find...
Right click on table name (dbo.user_profile), choose edit top 200 rows:
Image
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

Schtiel wrote:
oleksandr_ua wrote:can not find "Administrator" (h) (h) (h) (h)
where i can find...
Right click on table name (dbo.user_profile), choose edit top 200 rows:
Image
(h) (h) (h) (h) (h) (h) (h) (h) (h) (h)
where i can find...
(sos) (sos) (sos) (sos) (sos) (sos) (sos) (sos)

Image

Image

Image

Image
Schtiel
Site Admin
Posts: 1122
Joined: Wed Sep 06, 2006 12:03 pm
Location: CIS

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by Schtiel »

Execute the following query:

Code: Select all

SELECT * FROM dbo.user_profile;
and post screenshot
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

step by step go for password (oo) (oo) (oo)
How can I change usrer_guid (change to f10f8ca3-15f4-4a26-937a-a45532036ea5)
field only read (not_allow) (not_allow) (not_allow)

Image
Schtiel
Site Admin
Posts: 1122
Joined: Wed Sep 06, 2006 12:03 pm
Location: CIS

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by Schtiel »

oleksandr_ua wrote:How can I change usrer_guid (change to f10f8ca3-15f4-4a26-937a-a45532036ea5)
Execute the following query:

Code: Select all

UPDATE dbo.user_profile SET user_guid='f10f8ca3-15f4-4a26-937a-a45532036ea5', password_hash=2039933623 WHERE user_profile_id=2;
Don't forget to commit transaction
oleksandr_ua
Posts: 104
Joined: Thu Jan 01, 2015 9:02 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by oleksandr_ua »

it works !!!!
:haha: :haha: :haha: :haha: :haha: :haha: :haha: :haha:
thank you for your help
(clap) (clap) (clap) (clap) (clap) (clap) (clap) (clap) (clap) (clap) (clap)
LM555
Posts: 1
Joined: Wed Jan 11, 2017 12:34 am

Re: InTouch, Archestra IDE - Reset/Find/Break - password

Post by LM555 »

It also worked for me (oo)

Thank you so much!!!