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

Plesk Dedicated --Problems with Sitebuilder 4.0

Discussion in 'Sitebuilder 4.0 for Linux' started by etoh1973, Aug 8, 2007.

  1. etoh1973

    etoh1973 Guest

    0
     
    Hey, guys
    server info:
    Hostname ip-72-167-35-123.ip.secureserver.net
    Plesk version psa v8.2.0_build82070706.15 os_FedoraCore 6
    Operating system Linux 2.6.20-1.2962.fc6

    I've been trying for almost 12 hours to figure out what I might be doing wrong. I installed using the psa_ autoinstaller -- Work find no issue. I login to my Plesk and to go module and I see "Sitebuilder Administration Module 4.0"
    but it says this:
    Could not connect to specified SiteBuilder server
    I've run the sb_config:
    --phpcli_path PHP CLI executable [/opt/php52/bin/php5]
    --phpcgi_path PHP CGI executable [/opt/php52/cgi-bin/php5]
    --update_locales Update locales [no]
    --update_templates Update templates [no]
    --update_modules Update modules [no]
    --migrate_all Migrate all sites [no]
    --help Show this help [no]
    --verbose Be verbose [no]
    --[no]use_rewrite Enable/disable mod_rewrite usage [yes]
    --sb_admin_passwd Password for admin user [not changed by default]
    --db_host MySQL database remote host [localhost]
    --db_port MySQL database remote port [3306]
    --db_admin_name MySQL administrator username [admin]
    --db_admin_passwd MySQL administrator password xxxxxxxxxx
    --sb_db_user_name SiteBuilder MySQL username [sitebuilder3]
    --sb_db_user_passwd SiteBuilder MySQL password
    --sb_db_name SiteBuilder database name [sitebuilder]
    --httpd_port Webserver port [80]
    --sb_host_ip Create virtual host on the specified IP [72.167.35.123]
    --sb_hostname SiteBuilder virutal host name [ip-72-167-35-123.ip.secures
    erver.net]
    --httpd_owner Webserver user and group [www-data:www-data]
    --[no]enable_ssl Enable/disable SSL [no]
    (*did change the httpd_ownwer from apache|apache to ^^
    But when attempting to connect to configure I says, can not connect to a sitebuilder server, and says .. when click on "check for local install"
    Local sitebuilder installation was found but it's remote api isn't available. May be server is down or DNS is not configured properly!
    -- but i do have a DNS A record setup for the name
    I've tried the hostname, the sitebuilder.domainname.com but nothing and the error logs say this:
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] file: /usr/local/sitebuild
    er/include/Zend/Zend/Db/Adapter/Abstract.php
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] line: 156
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] code: 42S02
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] PDOException: SQLSTATE[42S
    02]: Base table or view not found: 1146 Table 'sitebuilder.config_param' doesn't
    exist
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] file: /usr/local/sitebuild
    er/include/Zend/Zend/Db/Adapter/Abstract.php
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] line: 156
    [Wed Aug 08 05:42:58 2007] [error] [client 127.0.0.1] code: 42S02

    Which leads to me to build that a database is not setup, but under the domain name itself is the same database name and password that was generated in the /usr/local/sitebuilder/config file.
    Any insight or suggestions would be unbelievible helpfull!!
    Thanks,
     
  2. caustic

    caustic Guest

    0
     
    judging from the "Table 'sitebuilder.config_param' doesn't exist" error message on ip-72-167-35-123.ip.secureserver.net I'd say that sitebuilder database has not been setup properly. Normally sitebuilder's database name is sitebuilder3, not just sitebuilder.

    Can you post
    mysql -e 'show databases'
    and
    mysql -e 'show tables' sitebuilder
    output here?
     
  3. etoh1973

    etoh1973 Guest

    0
     
    Hey,
    Thanks for the reply:
    phpmyadmin_HTL0vQq48jvE |
    psa |
    sitebuilder |
    sitebuilder3 | -- change the username to sitebuilder3
    sitebuilder_db1 |
    slicklivedata |
    spidertrack_data |

    -- now it says the login and password is bad. I thought it would be the same information you use to login into your plesk control panel.
    Gonna try working around the user name and password issue.. Thanks again!
    Keith

     
  4. etoh1973

    etoh1973 Guest

    0
     
    close -- now it says ;; Requires Sitebuilder Api v.4.0

    Close to a solutions.. It found the correct location and login information and password, but now is says that "Sitebuilder Api v.4.0" is required. But, I installed it from the psa_install for Sitebuilder 4.0
    ?
    Keith
     
  5. caustic

    caustic Guest

    0
     
    Close to a solutions.. It found the correct location and login information and password, but now is says that "Sitebuilder Api v.4.0" is required. But, I installed it from the psa_install for Sitebuilder 4.0
    so you got the sitebuilder working. Now you want attach SBM to it, right?
    Try adding /4.0 suffix to the address string in SBM (where the ServiceFacade is)
     
  6. etoh1973

    etoh1973 Guest

    0
     
    possible configuration issue.

    Hey, thanks for the reply.. But, I think I've stumble and configuration issue that I've caused :)
    I've added /4.0 a http://domainname.com/ServiceFacade/4.0

    1. If I use the domain name sitename.com/ServiceFacade
    it finds it and says "require Sitebuilder api 4.0"
    2. If I add /4.0 -- it can not find a sitebuilder server, but if you check it.. it detects that it is installed but API or DNS issue.

    3. If i replace it with the hostname which is:
    ip-72-167-35-123.ip.secureserver.net/ServiceFacade/ it finds it but says requires api.
    4. Add /4.0 with step 3 and it can not find sitebuilder server.
    I can access the "Reselller" and Domains" pages -- so I know I'm close, but the rest of the tabs generate page can not be found.
    sb_config
    --phpcli_path PHP CLI executable [/opt/php52/bin/php5]
    --phpcgi_path PHP CGI executable [/opt/php52/cgi-bin/php5]
    --update_locales Update locales [no]
    --update_templates Update templates [no]
    --update_modules Update modules [no]
    --migrate_all Migrate all sites [no]
    --help Show this help [no]
    --verbose Be verbose [no]
    --[no]use_rewrite Enable/disable mod_rewrite usage [yes]
    --sb_admin_passwd Password for admin user [not changed by default]
    --db_host MySQL database remote host [localhost]
    --db_port MySQL database remote port [3306]
    --db_admin_name MySQL administrator username [admin]
    --db_admin_passwd MySQL administrator password ]
    --sb_db_user_name SiteBuilder MySQL username [sitebuilder3]
    --sb_db_user_passwd SiteBuilder MySQL password
    --sb_db_name SiteBuilder database name [sitebuilder3]
    --httpd_port Webserver port [80]
    --sb_host_ip Create virtual host on the specified IP [72.167.35.123]
    --sb_hostname SiteBuilder virutal host name [sitebuilder.webandlinks.com
    !!! -- this is where I want this to be !!
    --httpd_owner Webserver user and group [www-data:www-data]
    --[no]enable_ssl Enable/disable SSL [no]
    the config file - /usr/local/sitebuilder
    ;; Automatically generated, do not change

    [database]
    password =
    emulate_prepares = 0
    adapter = PDO_MYSQL
    dbname = sitebuilder3
    username = sitebuilder3
    host = localhost

    [general]
    remote_admin = 1
    db_sessions = 1
    use_rewrite = 1
    allow_trial_sites = on
    allow_unsupported_browsers = off
    preloader = 1
    session_life_time = 86400
    application_url = http://sitebuilder.webandlinks.com/ServiceFacade/4.0/:80
    fallback_locale = en_US

    Once, again thanks for your assistance ! Any insight would be most helpfull.
    Thanks,
     
  7. etoh1973

    etoh1973 Guest

    0
     
    update -- insane installation.. arg :(

    Ok, oddly enought. I game sitebuilder.webandlinks.com its own ip address, update sb_config information and one can reach sitebuilder.webandlinks.com, but now when you login to into Plesk and go into the modules it wants to give :
    http://sitebuilder.webandlinks.com/ServiceFacade/
    as Sitebuilder server
    http://sitebuilder.webandlinks.com/ServiceFacade/4.0/
    still can not find the server and gives the following error:

    Could not connect to specified SiteBuilder server Local sitebuilder installation was found but it's remote api isn't available. May be server is down or DNS is not configured properly!
    I
    Why is documentation so limited? I can not believe no one else has ever had this installtion problem. None of the documentation leads you possible solutions if this.. then do this....

    Once again, any suggestions to resolve this as quickly as possible would be most helpful. It always fun to spend 3 days on configuration issue, that should be spend 3 days configuring the setup.. ARGH :(
     
  8. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    As I can see http://sitebuilder.webandlinks.com/ServiceFacade/ API is accessible and should work fine. So in Plesk admin CP -> Modules -> Remote Admin for SiteBuilder -> URL
    you need to put http://sitebuilder.webandlinks.com/ServiceFacade/
    and not
    http://sitebuilder.webandlinks.com/ServiceFacade/4.0/

    after that specify correct admin password.

    If it still can not connect please make sure that Sitebuilder configuration file, by default /etc/httpd/conf.d/zz011_sitebuilder.conf is included into Apache configuration and contains correct 72.167.35.132 IP address to which host sitebuilder.webandlinks.com is resolved. You can also check if correct IP address exist for Sitebuilder configuration here:

    # sb_config --help|grep host_ip
    # sb_config --help|grep hostnam

    And the last thing which you can check is apache error_log files for any errors.
     
Loading...