Plesk Dedicated --Problems with Sitebuilder 4.0

[etoh1973]

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,

 

[caustic]

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?

 

[etoh1973]

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

Originally posted by caustic
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?

 

[etoh1973]

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

 

[caustic]

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)

 

[etoh1973]

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,

 

[etoh1973]

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

 

[Dmitry Frantsev]

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.