Can I install sitebuilder mysql database on another server?

[isabel.estevao]

Hi,

I would like to known if I can install sitebuilder mysql database on one server and the sitebuilder directory on another server?

The server with sitebuilder directory has the following components installed:

1) mysql-client
2) mysql-shared
3) php5-mysql
4) mysql-devel
5) perl-DBD-mysql

When I try to install sitebuilder-4.2.0 it gives me the following error:

error: Failed dependencies:
perl-DBD-mysql is needed by sitebuilder-core-4.2.0-suse101.build08030317.x86_64
mysql is needed by sitebuilder-core-4.2.0-suse101.build08030317.x86_64


Need help.



Regards

Isabel Estêvão

 

[Dmitry Frantsev]

It is possible to have Sitebuilder installed on one server and database located on different server configuration. Actually, package sitebuilder-core has following requirements:

# rpm -qR sitebuilder-core
/bin/sh
/bin/sh
httpd
libc.so.6
libc.so.6(GLIBC_2.0)
libc.so.6(GLIBC_2.1)
libc.so.6(GLIBC_2.1.3)
libc.so.6(GLIBC_2.3)
libexpat.so.0
mysql-server
perl-DBD-MySQL
php5-ioncube-php52
php5sb >= 5.2.1
rpmlib(CompressedFileNames) <= 3.0.4-1
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
sitebuilder-selinux >= 1.0

As you can see mysql-server required in this case. There are two ways for resolving this:

1. Install mysql-server package, install Sitebuilder itself and configure it with help of 'sb_config' to use different server mysql database:

# sb_config --help|grep MySQL
--db_host MySQL database remote host [localhost]
--db_port MySQL database remote port [3306]
--db_admin_name MySQL administrator username [root]
--db_admin_passwd MySQL administrator password

2. Install Sitebuilder packages manually with '--nodeps' option and after that configure it to use different database server with 'sb_config' utility.