• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Password expiry - panel now broken

J

Joshua Hough

Guest
Hi There,

Plesk told me today that the password had expired and needed changing. Since then, when i try and access the panel, i now get the following error 'No SP with id=' followed by 35 random characters.

Any ideas on the problem/how to fix?

Thanks,

Josh
 
Looks like there is problem with SSO and CBM integration. Try to repair it with following command:

"%plesk_bin%\billing-repair-integration.exe" --command=repair-all --idp-url=https://MyHostname:8443
 
Hi, We have run the below command and we are getting the following error;

C:\Users\Administrator>"%plesk_bin%\billing-repair-integration.exe" --command=repair-all --idp-url=https://host.mas-host.com
: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............The 'C:\plesk\billing\scripts\sso.php' utility was failed with t
he unknown message: <message>Server error (code 500): Exception with message 'Script error [2] in C:\plesk\sso\htdocs\lib\Ss
lUtils.php (101): openssl_pkey_new() [<a href='function.openssl-pkey-new'>function.openssl-pkey-new</a>]: unable to write ra
ndom state' caught at top level. (HTTP code: 500)</message>. All details of the problem has been stored into the 'C:\plesk\b
illing\scripts/sso.crash.log' file.

Usage: C:\plesk\billing\scripts\sso.php [ options ]
--command <string> attach | attach-all | detach | enable | disable | repair-accounts | repair-all | reissue-sp-certs | i
nfo.

attach
Connects the Administrator's or Customer's panel to the SSO service. The
panel type is defined by the required option --app-type. To connect both panels,
run the operation twice with different --app-type options. This command also
requires option --idp-url.
Example: sso --command=attach --app-type=customer --idp-url=https://host.mas-host.com:8443

detach
Disconnects the Administrator's or Customer's panel from the SSO service.
The panel type is defined by the required option --app-type. To disconnect both
panels, provide two --app-type options.
Example: sso --command=detach --app-type=customer

enable
Turns on the SSO service for the connected panel. Initially, the service
is turned off. The panel type is defined by the required option --app-type.
Example: sso --command=enable --app-type=customer

disable
Turns off the SSO service for the connected panel. The panel type is
defined by the required option --app-type.
Example: sso --command=disable --app-type=customer

repair-accounts
Repairs global accounts for the connected panels. Make sure that the 'admin'
application is configured as privileged to manage SSO. For that you should see and
modify if needed the SSO configuration file: 'C:\plesk\\admin\conf\sso\sso_config.ini'.
Example: sso --command=repair-accounts

repair-all (alias: attach-all)
Repairs all aspects of integration between the connected panels and
Customer & Business Manager. This command can be used with option --idp-url.
If you will skip this option then the SSO service will be repaired with the
default URL to SSO server: https://host.mas-host.com:8443.
Example 1: sso --command=repair-all
Example 2: sso --command=repair-all --idp-url=https://host.mas-host.com:8443

reissue-sp-certs
Reissue certificates for 'admin' and 'client' applications. Make sure that the 'admin'
application is configured as privileged to manage SSO. For that you should see and
modify if needed the SSO configuration file: 'C:\plesk\\admin\conf\sso\sso_config.ini'.
Example: sso --command=reissue-sp-certs

info
Displays information about the connected panel properties. If you do not
provide --prop-name, all properties are displayed. Otherwise, only a specific
property is displayed.
Example: sso --command=info --app-type=customer

--idp-url <string> URL to SSO server, for example, https://host.mas-host.com:8443. Required with commands: attach | atta
ch-all. Optional with command: repair-all.
--app-type <string> Application type: admin | customer (Customer & Business Manager Administrator's or Customer's panel).

--prop-name <string> Property to display: connected | enabled | api_url | relay_url | sp_id.
--force Run attach | detach | enable | disable commands regardless the status of connection with SSO.
--dont-repair-accounts Don't try to repair accounts. Optional for command: repair-all.
--help Display this help message.

[ FAILED ]

The command 'integration:repair-all' completed with this error: "Failed to run command 'cmd /C ""C:\plesk\admin\bin\php.exe"
-dauto_prepend_file="" "C:\plesk\billing\scripts\sso.php" --command="repair-all" --idp-url="https://host.mas-host.com:8443"
"' Exit code: 254".
Failed to run command 'cmd /C ""C:\plesk\admin\bin\php.exe" -dauto_prepend_file="" "C:\plesk\billing\scripts\sso.php" --comm
and="repair-all" --idp-url="https://host.mas-host.com:8443""' Exit code: 254
Output:
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............The 'C:\plesk\billing\scripts\sso.php' utility was failed with t
he unknown message: <message>Server error (code 500): Exception with message 'Script error [2] in C:\plesk\sso\htdocs\lib\Ss
lUtils.php (101): openssl_pkey_new() [<a href='function.openssl-pkey-new'>function.openssl-pkey-new</a>]: unable to write ra
ndom state' caught at top level. (HTTP code: 500)</message>. All details of the problem has been stored into the 'C:\plesk\b
illing\scripts/sso.crash.log' file.

Usage: C:\plesk\billing\scripts\sso.php [ options ]
--command <string> attach | attach-all | detach | enable | disable | repair-accounts | repair-all | reissue-sp-certs | i
nfo.
(usage commands removed to reduce character count)

--idp-url <string> URL to SSO server, for example, https://host.mas-host.com:8443. Required with commands: attach | atta
ch-all. Optional with command: repair-all.
--app-type <string> Application type: admin | customer (Customer & Business Manager Administrator's or Customer's panel).

--prop-name <string> Property to display: connected | enabled | api_url | relay_url | sp_id.
--force Run attach | detach | enable | disable commands regardless the status of connection with SSO.
--dont-repair-accounts Don't try to repair accounts. Optional for command: repair-all.
--help Display this help message.


Output of this command you can see in the 'C:\plesk\tmp\billing/repair-integration.php[2011-10-20 09:08:14].log' file.

C:\Users\Administrator>

I have followed the steps in this KB article - http://kb.odin.com/en/112030
The SSO crash log contained the following;

Description: 'Server error (code 500): Exception with message 'Script error [2] in C:\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)' at C:\plesk\billing\lib\lib-tk\include\sso\SSORegister.php:67
Created: 2011-10-20 09:08:46
Action:
To obtain more details, turn the debug logging on. For details on how to turn the debug logging on, see the context help on the 'Events > Debug Log' page
 
Hi, thanks for the link.
I have read through and run the commands which are shown, I get the following

--command=install
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>%plesk_bin%\billing-integration.exe --command=install
The Customer & Business Manager is already installed. Nothing to do.

Output of this command you can see in the 'C:\plesk\tmp\billing/integration.php[2011-10-20 12:18:4
7].log' file.

C:\Users\Administrator>

I get the same result if I use the hostname at the end.
 
I dont know if this is a bug in plesk, but i'm having the same problem even after following the steps set out above.
 
Back
Top