Service user password

[prasa7]

how do we reset the service user password.

[kruegerb]

which version?
in actual 10.1 you can change it in UI: log in as service, go to menu File -> Change Password

[prasa7]

I don't have a service password so I need to reset it. So I can log in as a service user . On version 9.1.9

[kruegerb]

why to login with service? isnt it possible to login as Administrator?

[kruegerb]

you can reset to the default Passwort:
Open a command window
change folder to c:\Program Files\Avaya\IP Office Contact Center\PostgreSQL\9.3\bin
type psql cc Administrator
type password for Administrator account if queried for
type select reset_service(); and press Return key

Maybe an info message like following is shown:
cc=# select reset_service();
INFO: ABSORB_INIT successfull!
CONTEXT: SQL-Anweisung "SELECT notifyLNA_GlobalAccount('UPDATE', NEW, OLD, clie
ntName)"
PL/pgSQL-Funktion globalaccounttupd4notify() Zeile 7 bei Zuweisung
SQL-Funktion "reset_service" Anweisung 1
INFO: OrbHelper::initializeOrbObject(1): TriggerRef: IOR:010000001b00000049444c
3a4c4e41457874656e73696f6e4e6f746966793a312e300000 01000000000000006c000000010102
00100000003133352e3132342e3130392e31383000f6c20000 14000000ff6269646972fe2ed7d454
01000c68000000000102000000000000000800000001000000 00545441010000001c000000010000
00010001000100000001000105090101000100000009010100
CONTEXT: SQL-Anweisung "SELECT notifyLNA_GlobalAccount('UPDATE', NEW, OLD, clie
ntName)"
PL/pgSQL-Funktion globalaccounttupd4notify() Zeile 7 bei Zuweisung
SQL-Funktion "reset_service" Anweisung 1
reset_service
---------------
(1 row)
Password is now reset to its default value.