Install of Plesk Billing failes...

[KennethMcKnight]

Hi guys,

when i try to install the plesk billing module during the autoinstaller I get the following error message:

Downloading the file PSA_9.0.0/dist-rpm-SuSE-10.2-x86_64/opt/billing/plesk-billing-6.0.0-20081206.12.noarch.rpm: skipped because of md5 checksum match.
Starting installation of packages
Installing the package plesk-billing-6.0.0-20081206.12.noarch (b 0x1d0f440 source=0xd861d0 P:6055 R:5)
Database created: billing_e048
Database user created: billing_e048
Configuration file created
URL:https://127.0.0.1:11443/sp
Unexpected result code 500 returned from IdP. Response body:
Server error (code 500): Exception with message 'SQLSTATE[HY000]: General error: 1 no such table: sp' caught at top level.Unable to register Plesk Billing in SSO server
Congratulations!
Parallels Plesk Billing has been successfully installed on your server.

Also I'll get the following message, whenever I open the section "Customers" in the CP:

Unable to fetch customers' balances: Unable to connect to Plesk-Billing.

Removing plesk-billing an reinstalling it, doesn't change anything.

Thanks for helping...

 

[wsani]

have you tried installing the module manually through the shell?

 

[KennethMcKnight]

Hi wsani,

yes I did. Same result...

Kenneth

 

[KennethMcKnight]

Hi guys,

are there really no ideas or support from Plesk people?

 

[cmarxmeier]

workaround

Taken from logfiles:
[2009-01-17T21:03:13Z][12153][INFO][DBMigrate.php(21) (main)] [begin] DB migrate.
[2009-01-17T21:03:13Z][12153][INFO][SchemaUtil.php(124) update] Required DB schema version is 7.
[2009-01-17T21:03:13Z][12153][DEBUG][Db.php(26) __construct] Opening DB connection to sqlite:/var/lib/sso/sso.db (readable=true, writable=
true)
[2009-01-17T21:03:13Z][12153][DEBUG][Db.php(34) __construct] Opened DB connection to sqlite:/var/lib/sso/sso.db
[2009-01-17T21:03:13Z][12153][DEBUG][Db.php(39) __call] query: select version from schema_version;
[2009-01-17T21:03:13Z][12153][INFO][SchemaUtil.php(85) getOrigSchemaVersion] Current DB schema version is 1.


dirty workaround:
mv /var/lib/sso/sso.db /var/lib/sso/sso.db.old
Then install billing and check:
- did it create a newer version of sso.db?
- did all applications registered properly or does it throw error messages in logfile /var/log/sso/sso.log?


I got plesk Billing running with customers from control-panel and uninstalled it after discovering that it needs a license to have more than 10 customers.

no guarantee how things run on your host - that's how it worked for me.

 

[CyrilD]

http://kb.parallels.com/en/9327

Linux
Disable "Single Sign-On"
# /usr/local/psa/bin/sso --disable

Windows
%plesk_dir%/bin/sso --disable


Note: %plesk_dir% is an environment variable, which points to Plesk installation folder. By default the installation folder is C:\Program Files\Parallels\Plesk