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 _ >> >>
