error with install in CPanel

[scapeweb]

sb_config --update_modules --update_templates --update_locales
[ERROR] Errors during locales update
[ERROR] Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mycool_builder.config_param' doesn't exist
file: /usr/local/sitebuilder/include/Zend/Db/Statement/Pdo.php
line: 238
code: 0
Internal Sitebuilder error.
Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mycool_builder.config_param' doesn't exist
file: /usr/local/sitebuilder/include/Zend/Db/Statement/Pdo.php
line: 238
code: 0
[ERROR] Errors during templates update
There were some configuration errors, check logs
Logs saved to /usr/local/sitebuilder/tmp/sb_config-1008021558.log

 

[Dmitry Frantsev]

It looks like Sitebuilder database is inconsistent or was not created at all.

Sometimes during installation on cPanel installation scripts can not connect to database. On cPanel server mysql user and password are stored in /root/.my.cnf. They cannot be overwritten by Sitebuilder usual way.

~# cat /root/.my.cnf
[client]
user="root"
pass="XXXXXX"
~#

Sitebuilder defaults are configured in file Defaults.pm. These values are shown with command "/usr/local/bin/sb_config --help".

~# vi /usr/local/sitebuilder/utils/SB/Defaults.pm
...
'db_admin_name' => "root", <- change mysql user
'db_admin_passwd' => "123qwe", <- change mysql password
...
~#

To check:

~# /usr/local/bin/sb_config --help
Usage:
...
--db_admin_name MySQL administrator username [root] <- mysql user
--db_admin_passwd MySQL administrator password [123qwe] <- mysql password
...
~#

After the reconfiguration above script sb_config should be able to connect to mysql database. You should recreate Sitebuilder user sitebuilder_db, Apache configuration file of Sitebuilder virtual host and update ownership.

~# sb_config --force_update_db <- recreate mysql user sitebuilder_db
~# sb_config --force_update_wscfg <- to rebuilt Apache configuration for Sitebuilder virtual host /etc/swsoft/sitebuilder/sitebuilder.conf
~# sb_config --httpd_owner nobody:nobody <- to change ownership for sites

Check it up.