Custmer and Business Manager failure after 10.3 upgrade

[BigSteef]

I hae upgraded to 10.3 and had some minor issues durng the upgrade.

after reslvinf everything i can see, i have one error left.

when i click on any of the business manager links (plesk billing) i get the message below:

Error: Credentials for application's account are required.

i have tried all the passwords i know, i have repaired the SSO via http://kb.odin.com/en/9509

sill no luck

any ideas?

 

[IgorG]

Try to fix it with article http://kb.odin.com/en/11204

 

[BigSteef]

Output from commands:

G:\Plesk\admin\bin>"%plesk_bin%\billing-update-hostname" --new-hostname=MyHostname
Try to reissue sp certificates.. [ OK ]

G:\Plesk\admin\bin>"%plesk_bin%\billing-repair-integration.exe" --command=repair
-all --idp-url=https://MyHostname:8443
Repair integration with local panel:
Try to repair integration...............................[ OK ]

Repair SSO connections (may take a few minutes, please wait...):
Repair SSL settings in IIS for SSO server:

Try to re-install CA certificate........................[ OK ]
Try to configure SSL settings in IIS....................[ OK ]
Repair CBM and Plesk Panel connections with SSO:

Try to detach the 'customer' application from SSO.......[ OK ]
Try to detach the 'admin' application from SSO..........[ OK ]
Try to clear the SSO database...........................[ OK ]
Try to attach the 'admin' application to SSO............[ OK ]
Try to attach the 'customer' application to SSO.........[ OK ]
Try to enable the 'admin' application to use SSO........[ OK ]
Try to enable the 'customer' application to use SSO.....[ OK ]

Repair administrative accounts:

Sales Team (ID: 1)......................................[ OK ]
OrderForm User (ID: 2)..................................[ OK ]
API User (ID: 3)........................................[ OK ]
Cron User (ID: 4).......................................[ OK ]

Repair customers accounts:

My Customer (ID: 1).........................................[ OK ]

The command 'sso:repair-all' completed.

Synchronize local panel:
Try to synchronize local panel..........................[ OK ]

The command 'integration:repair-all' completed.

Output of this command you can see in the 'g:\Plesk\tmp\billing/repair-integrati
on.php[2011-07-18 12:06:47].log' file.


Still no luck. still getting the error

I have dug into the database and the admin user has an "admin_password_date_changed" but i have never changed the password.

can you point me towards the password reset mechanism for 10.x - i found onefor Modernbill v4 (much older) but that didnt work... - i have reverted that and put the MD5 back...

 

[EgidijusS]

Same problem. Yesterday upgraded from 10.2 to 10.3 and now can't login to CBM. Centos 5.6 x86

 

[EugeneL]

Hello,

Please post here the result of the following MySQL query:
shell> /usr/share/plesk-billing/billing-db
mysql> select * from admin_login_attempts where attempt_number >= 3;

You can mask your IP for security reasons, I do not need it.

 

[EgidijusS]

Hello,

I fixed it later at night. Just deleted my IP from admin_login_attempts. After that i was able login directly to CBM, but not via Plesk. Then loged to CBM and changed admin password to same as password to Plesk. After that everything OK. Now i can walk from plesk to CBM and back.

 

[BigSteef]

i had some data in that table, which i have deleted and still no luck - how do i reset the password?

i had my ip address with 3 failed attempts. Deleted the data and tried to login again, checking after each login attempt and the count increases, indicating i have the wrong passwrd...

help?

 

[EugeneL]

Please use command
/usr/share/plesk-billing/update-admin --password <your password>

This command will change password in CBM.
It's better to use the same password as you use to log in to Panel.

 

[BigSteef]

the command:

"%plesk_bin%\php" -dauto_prepend_file="" "%plesk_dir%\billing\scripts\update-admin.php" --password <my password> failed with SSO errors.

i detatched the SSO by using the commands:

billing-sso --command=detach --app-type=admin
billing-sso --command=detach --app-type=customer

billing-sso --command=attach --app-type=admin --idp-url=https://myhostname:8443

then ran the command and it worked and got me in...

i now cant re-attach the SSO - getting:

G:\Plesk\sso\htdocs\lib\SslUtils.php (101): openssl_pkey_new() [<a href='function.openssl-pkey-new'>function.openssl-pkey-new</a>]: unable to write random state' caught at top level. (HTTP code: 500)</message>. All details of the problem has been stored into the 'G:\Plesk\billing\scripts/sso.crash.log' file.

i am now in the business manager but sso isnt working.. - but progress!

 

[EugeneL]

G:\Plesk\admin\bin>"%plesk_bin%\billing-repair-integration.exe" --command=repair-all --idp-url=https://MyHostname:8443

Does this command return the same error?

 

[BigSteef]

no - that commnd returns nothing..

(however it does not fix it - although i dont think you expected it to)

 

[EugeneL]

Please try the following
1. You must set RANDFILE variable by System Properties -> Advanced -> Environment Variables -> System variables -> new variable RANDFILE=%TEMP%\random.state.rnd
2. Set RW permissions on temp catalog for "psaadm" user.
3. Find old RND files on the system disk where the Parallels products were installed (use *.rnd matching pattern).
4. Delete all files you found with name '.rnd'.
5. Restart IIS.
6. G:\Plesk\admin\bin>"%plesk_bin%\billing-repair-integration.exe" --command=repair
-all --idp-url=https://MyHostname:8443

 

[BigSteef]

That has fixed it. thank you all for your help...

 

[lock2007]

Custmer and Business manager failure

I have the same problem


Error: Failed to upgrade Business Manager to version 10.4.4-1. See the log below for details and fix the problems if possible. Business Manager will restart the upgrade procedure next time you log in to it.




Upgrade is in progress, please wait...

Upgrading...............................................[ OK ]
Update permissions for actions..........................[ OK ]
Repair integration with local panel:
Try to repair integration...............................[ FAILED ]


Upgrade has been completed with errors.

 

[EugeneL]

Hello,

Please enable debug output (http://kb.parallels.com/en/9300, item 1 only since you can't log in to CBM)
Then execute the command /usr/share/plesk-billing/integration --command='upgrade' --from-version='10.3.0-1' --to-version='10.4.4-1 and post here the output