Sitebuilder-Server-URL cannot be entered for Plesk-Integration / Plesk SB Support

[tt_iserve4u]

Problem:
The Sitebuilder-Server-URL cannot be entered at PleskCP:Server->Sitebuilder-Support
(HTML- Form is greyed out/deactivated)

How to reproduce this issue:
1. Log in to Plesk Control Panel
2. Click on Server, then Sitebuilder-Support
3. When trying to fill out the sitebuilder administrator-access-data (Sitebuilder-Administratorzugangsdaten) the URL cannot be entered and the form is empty.

What we did:
Sitebuilder3 was installed before.
We removed the rpm's of this older version and removed the relevant Databases/PSA-tables too
(SBConfig, SBResellers, SBSites, sitebuilder3).

Then we installed Sitebuilder 4.5 and Sitebuilder-support for Plesk8.3 with parallels-autoinstaller.

We've also tried this in vain: http://kb.odin.com/en/3595

Those are some of the currently installed Packages regarding sitebuilder/plesk:
php5sb-5.2.1-10swsoft
sb-publish-3.0.1-200610111450
psa-sbm3-5.0-11
sitebuilder-4.5.0-all.build08090214
sitebuilder-core-4.5.0-suse101.build08090214

OS: SUSE LINUX 10.1 (x86-64)
Kernel: Linux 2.6.16.54-0.2.5-smp x86_64

How can we get the plesk-integration of sitebuilder running?
Sitebuilder itself works flawlessly.
Is this a version issue?

 

[hannuvirta]

I Have a similar problem. I'm running Plesk 9.0.0 Cant figure out how to set up Sitebuilder integration. Sitebuilder was installed by puchased installation service.

 

[Dmitry Frantsev]

Actually, in this case you should use exactly http://kb.odin.com/en/3595 article for configuration. Just update with new Sitebuilder URL with help of suggested utility and after that in Server -> Sitebuilder-Support update administrator credentials for Parallels Plesk Sitebuilder admin CP.
If there are any further issue, just let me know which step does not work exactly?

 

[tt_iserve4u]

Thanks for your Replies.


All Steps worked, but the URL-Field remains empty.

I've found out, through some errors on Client creation, that the table psa.SBSite doesn't exist.
Shouldn't that be created by plesk-autoinstaller.

How can I recreate fresh tables for Sitebuilder-Integration?
Is there somewhere an SQL-Schema for this?

 

[tt_iserve4u]

More Details:

---------------------------------------------------------------------------------------
server:/home/user # /usr/local/psa/bin/sitebuilder.sh -s http://sitebuilder.server.tld/ServiceFacade/
===> Set sitebuilder server...
===> Ok. New sitebuilder server have been set
===> Now you should configured login and password to it in Plesk web panel on 'server -> sitebuilder' page

server:/home/user # /usr/local/psa/bin/sitebuilder.sh --get
Sitebuilder is not configured. Use -s command to set url to api of some sitebuilder server
---------------------------------------------------------------------------------------

This looks like the URL was not saved and the transaction was not verified.

 

[Dmitry Frantsev]

Try to create psa.SBConfig table manually in MySQL with following request:

CREATE TABLE `SBConfig` (
`param_name` varchar(255) character set ascii collate ascii_bin default NULL,
`param_value` varchar(255) character set ascii collate ascii_bin default NULL,
UNIQUE KEY `param_name` (`param_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

After that repeat Sitebuilder configuration procedure with sitebuilder.sh script and defining administrator credentials in Parallels Plesk admin interface. Hope it helps.

 

[tt_iserve4u]

Thank you very much, I hope this helps.

 

[Dmitry Frantsev]

There should be also psa.SBResellers and psa.SBSites tables exist. Listing tables structure below, just in case:

CREATE TABLE `SBResellers` (
`id` int(10) unsigned NOT NULL auto_increment,
`client_id` int(10) unsigned NOT NULL,
`sb_client_login` varchar(255) character set utf8 NOT NULL,
`sb_reseller_id` varchar(255) character set ascii collate ascii_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `client_id` (`client_id`),
UNIQUE KEY `sb_client_login` (`sb_client_login`),
UNIQUE KEY `sb_reseller_id` (`sb_reseller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `SBSites` (
`id` int(10) unsigned NOT NULL auto_increment,
`virtualHost_id` int(10) unsigned NOT NULL,
`sb_site_id` varchar(255) character set ascii collate ascii_bin default NULL,
`sb_siteowner_id` varchar(255) character set ascii collate ascii_bin default NULL,
`sb_siteowner_login` varchar(255) character set utf8 NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `virtualHost_id` (`virtualHost_id`),
UNIQUE KEY `sb_site_id` (`sb_site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[tt_iserve4u]

yeah! I found those tables in my backup and could restore it.
Sitebuilder integration in plesk works now.

Thanks very much for your help!