How to reinstall Business Manager After Uninstalling It

[N3cTr0]

Hi,

I originally uninstalled business manager by switching off sso and doing a yum remove plesk-billing.
I also removed that one db field so the menu doesnt show on the left.

Now I have had around 5 different resellers requesting the feature so I would like to install it to its former glory.
I managed to install in again and all appears to be working, but the menu on the left is not there in the control panel.

Any idea how to get this back?

Regards,

 

[IgorG]

Just run /usr/local/psa/admin/bin/autoinstaller select CBM there and install it.

 

[N3cTr0]

Tried that keep getting errors:

Running Transaction
Installing : plesk-billing 1/1
Database created: billing_88f3
Database user created: billing_88f3
Configuration file created
Application type: admin
Connected with SSO: On
SSO enabled: On
SSO API URL: https://<hidden>:11443
SSO Relay port: https://<hidden>:11444
Service Provider ID: hsgs<changed>s583s
js6p<changed>sn795
Application type: client
Connected with SSO: On
SSO enabled: On
SSO API URL: https://<hidden>:11443
SSO Relay port: https://<hidden>:11444
Service Provider ID: js6p<changed>3sn795

Change option 'privileged_sp_id' in SSO config.

Done.

Error: Execution failed.
Command: billing_connect_panel
Details: The following SSO error occurred: Cannot create new FI due to 'admin' is already exists. (HTT P code: 404)

Unable to register local panel
Restarting SWsoft control panels server... stale pidfile. [ OK ]

 

[IgorG]

http://kb.odin.com/en/9139

 

[N3cTr0]

Did that:

[root@cp /]# /usr/share/plesk-billing/sso --command=repair-accounts
Repair administrative accounts:

FIRSTNAME <Hidden> Lowe (ID: 1)... [OK]
OrderForm User (ID: 2)... [OK]
API User (ID: 3)... [OK]
Cron User (ID: 4)... [OK]

Repair customers accounts:


The command 'repair-accounts' completed without errors.

Billing menus still dont show up on the left hand menu in the panel and its not syncing any customers from the panel to the billing manager.

 

[IgorG]

But did you successfully complete CBM installation with autoinstaller?

 

[N3cTr0]

Error: Execution failed.
Command: billing_connect_panel
Details: The following SSO error occurred: Cannot create new FI due to 'admin' is already exists. (HTT P code: 404)

Unable to register local panel
Restarting SWsoft control panels server... stale pidfile. [ OK ]

That error appears everytime I run the autoinstaller.
So I did what you said above and posted the reply.

 

[IgorG]

Try to remove admin account from SSO.

 

[N3cTr0]

Would you be kind enough to explain how?

 

[IgorG]

I can only assume but I'm not sure. It would be better contact support team.
You can try login to SSO database with

# sqlite3 /var/lib/sso/sso.db

From error message we can see "Cannot create new FI due to 'admin' is already exists".

So, there are two possible related tables:

federation_item (FI)
federation

For example:

sqlite> select * from federation_item;
1|s4e2a8ia3u7pzumon2g2od7o3dbub2c1ec8|q555jkf9orqgv8twjm0czrephdbub2c3g8l|
2|s4e2a8ia3u7pzumon2g2od7o3dbub2c1ec8|a397jkake18u1x4grjzlukr7wdbub2chuem|
3|s6vfq64fevr54z4b75wh3lxgfdbubasxl8a|ahul7gyi0yr15tn3v52o0qj99dbubat37dr|

sqlite> select * from federation;
s4e2a8ia3u7pzumon2g2od7o3dbub2c1ec8|nbhkd1b2568tgr2vqwufspusfdbub24bouz|admin|80437a44a661d141174209119d54125a59a64b2a|[email protected]|
s6vfq64fevr54z4b75wh3lxgfdbubasxl8a|ki2295qa4bi10garory6voc46dbub25lera|test|05fe7461c607c33229772d402505601016a7d0ea|[email protected]|