http://stackoverflow.com/questions/5287220/is-there-a-way-to-only-install-the-mysql-client-linux
You need the client on any machine that wants to access a database on
another machine.
You should not have to install the server on each machine.
You may also need a mysql connector.
I am not sure about this but watch out for errors accessing the remote
database in case the app does not include its own connector and
automatically configure it to find the remote database.
Ron
On 18/06/2013 2:06 PM, Ethan Gillani wrote:
Help!
I am setting up cloudstack management on one server with MySQL installed on a
second server, both on CentOS. I have followed the installation material and
setup mysql and edited the my.cnf file as well, but when I go back to the
management server to run the cloudstack-setup-databases script pointing to the
mysql server I get an error at the very end.
Error:
/bin/sh: mysql: command not found
Below is exactly what happens when I run the script on the management server. I
have already set SELinux to permissive and edited the iptables on both servers
ot open the port 3306 as well...
Thanks in advance!
Ethan Gillani
[root@CloudstackManagement setup]# cloudstack-setup-databases
'cloud:password'@10.0.3.11 --deploy-as='root:password'
Mysql user name:cloud
Mysql user password:password
Mysql server ip:10.0.3.11
Mysql server port:3306
Mysql root user name:root
Mysql root user password:password
Checking Cloud database files ...
Checking local machine hostname ...
Checking SELinux setup ...
Detected local IP address as 10.0.3.10, will use as cluster management server n
Preparing /etc/cloudstack/management/db.properties
Applying /usr/share/cloudstack-management/setup/create-database.sql
We apologize for below error:
***************************************************************
Encountering an error when executing mysql script
----------------------------------------------------------------------
table:
/usr/share/cloudstack-management/setup/create-database.sql
Error:
/bin/sh: mysql: command not found
Sql parameters:
{'passwd': 'password', 'host': '10.0.3.11', 'user': 'root', 'port': 3306}
----------------------------------------------------------------------
***************************************************************
Please run:
cloud-setup-database -h
for full help
[root@CloudstackManagement setup]#
--
Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102