Also get rid of the colon after cloud user, if youre not going to specify a password.
On 10/15/12 5:39 PM, "Edison Su" <[email protected]> wrote: >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 >> _ >> >> >> >> >> > -- Æ
