1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'SiteBuilder' started by tt_iserve4u, Jan 22, 2009.

  1. tt_iserve4u

    tt_iserve4u Guest

    0
     
    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?
     
  2. hannuvirta

    hannuvirta New Pleskian

    22
    90%
    Joined:
    Mar 7, 2008
    Messages:
    12
    Likes Received:
    0
    Location:
    Finland
    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.
     
  3. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    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?
     
  4. tt_iserve4u

    tt_iserve4u Guest

    0
     
    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?
     
  5. tt_iserve4u

    tt_iserve4u Guest

    0
     
    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.
     
  6. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    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.
     
  7. tt_iserve4u

    tt_iserve4u Guest

    0
     
    Thank you very much, I hope this helps.
     
  8. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    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;
     
  9. tt_iserve4u

    tt_iserve4u Guest

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

    Thanks very much for your help!
     
Loading...