Thanks Ron! That did the trick! Just had to install the mysql client and get the privileges right Ethan
-----Original Message----- From: Ron Wheeler [mailto:rwhee...@artifact-software.com] Sent: Tuesday, June 18, 2013 4:16 PM To: users@cloudstack.apache.org Subject: Re: Cloudstack 4.1 MySQL install issue 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
