The command should be : cloud-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password>
change localhost to your-mysql-server-ip dbpassword/password to whatever password > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Monday, October 15, 2012 5:35 PM > To: [email protected] > Subject: Re: CS 4 Trial - CloudStack-oss-4.0.0-524.tar > > > > The Manual sates > > CLOUD-SETUP-DATABASES CLOUD:@LOCALHOST > > --DEPLOY-AS=ROOT: > -E > -M > -K > > It does not in reading it, state to > add a host ip as you say at the end of the command for --deploy-as. Im > just following the manual > > IE the precise command im using is defining > the ip address > > _CLOUD-SETUP-DATABASES CLOUD:@10.X.X.X > --DEPLOY-AS=ROOT:PASSWORD_ > > (in this message im removing the ip > address) > > if i add a server ip to the --deploy-as it fails to run. > Assuming the ip you ad is the address of the mysql > server. > > CLOUD-SETUP-DATABASES CLOUD:@10.X.X.X > --DEPLOY-AS=ROOT:[email protected] > > Mysql user name:cloud [ OK ] > Mysql > user password: [ OK ] > Mysql server ip: x.x.x.x REMOVED [ OK ] > Mysql > server port:3306 [ OK ] > Mysql root user name:root [ OK ] > Mysql root user > password:[email protected] [ OK ] > Checking Cloud database files ... [ OK > ] > Checking local machine hostname ... [ OK ] > Checking SELinux setup ... > [ OK ] > Detected local IP address as 10.x.x.x, will use as cluster > management server node IP[ OK ] > Preparing > /etc/cloud/management/db.properties [ OK ] > Applying > /usr/share/cloud/setup/create-database.sql > > We apologize for below > error: > *************************************************************** > Encountering > an error when executing mysql > script > ---------------------------------------------------------------------- > table: > /usr/share/cloud/setup/create-database.sql > > Error: > ERROR > 2005 (HY000): Unknown MySQL server host '10.x.x.x' (110) > > Sql > parameters: > {'passwd': '[email protected]', 'host': '10.x.x.x', 'user': > 'root', 'port': > 3306} > ---------------------------------------------------------------------- > > *************************************************************** > Please > run: > > cloud-setup-database -h > > ?Confused! > > :- > > On 16.10.2012 11:21, > Ahmad Emneina wrote: > > So I see some potential issues with the command. > --deploy-as=root:password > > doesn¹t have a host pointer. My gut tells me > it should look like > > --deploy-as=root:password@remote-host. > > > > Now > for another potential issue you do a cloud-setup-databases > > > cloud:@remoteip where I feel you should be doing cloud@remoteip (if > you > > want cloud user to log in without a password). > > > > I would try > with the above deploy-as=root modification, and correct the > > cloud user > param. > > > > > > On 10/15/12 5:07 PM, "[email protected]" wrote: > > > > >> > >> > >>Thanks Ahmad > >> > >>i tried the format that you suggest. but it > sill > >>doesn't work. > >> > >>i have to also install mysql tools before the > server will > >>connect to the remote mysql host. > >> > >>ive tried with > multiple builds of the > >>latest build on ubuntu. Now im trying the > nonoss vers > >> > >>same issue with > >>it setting up the DB. AKA have to > remove any password from the database > >>name on setup of > DB > >> > >>cloud-setup-databases > cloud:@remoteip > >>--deploy-as=root:password > >> > >>i have disabled all > firewalls on hosts. UB > >>12.04.1 LTS > >> > >>_Not true, for production > installs, I always have the db > >>server remote to management servers and > there are passwords on all > >>accounts. One thing to try is have a mysql > user password with little to > >>no special characters, if you do quote > them, for example > >>cloud-setup-databases > cloud:'mcloudpass'@remote.host.com > >>--deploy-as=root:'rootpass'@remote.host.com > _ > >> > >> >
