It shouldn't connect to your db inside devcloud if you run the command on your physical laptop. It all depends on how you configure the db in utils/conf/db.properties: db.cloud.host=localhost If you point db.cloud.host=192.168.56.2, then " mvn -P developer -pl developer -Ddeploydb" will connect to 192.168.56.2.
-----Original Message----- From: Charles Moulliard [mailto:[email protected]] Sent: Monday, November 05, 2012 1:24 PM To: cloudstack-dev Subject: Re: Issue during build of Cloudstack DB I think that I know the reason. When we use the mvn -P developer -pl developer -Ddeploydb command, the maven sql plugin tries to update the MySQL DB which is deployed in DevCloud VM (VirtualBox). RedHat-MacBook:karafee chmoulli$ netstat -an | grep 3306 tcp4 0 0 192.168.56.1.55653 192.168.56.2.3306 SYN_SENT tcp4 0 0 *.3306 *.* LISTEN Question : Is it a normal behavior ? On Mon, Nov 5, 2012 at 10:18 PM, Charles Moulliard <[email protected]> wrote: > Mysql is configured to use port 3306 and this port is available : > > netstat -an | grep 3306 > tcp4 0 0 *.3306 *.* LISTEN > > > On Mon, Nov 5, 2012 at 6:57 PM, Charles Moulliard <[email protected]>wrote: > >> I will check but if mysql runs well on port 3306, so what could be >> the issue with maven sql plugin on MacOS ? >> >> On 11/5/12, Abhijith Chandrashekar >> <[email protected]> >> wrote: >> > Run netstat to see if mysql is listening on 3306. If it is not, >> > then you will probably have to restart mysql without the >> > --skip-networking >> option to >> > make sure it is listening on it. >> > >> > Thanks, >> > Abhijith >> > >> > -----Original Message----- >> > From: Charles Moulliard [mailto:[email protected]] >> > Sent: Monday, November 05, 2012 9:29 AM >> > To: cloudstack-dev >> > Subject: Issue during build of Cloudstack DB >> > >> > Hi, >> > >> > When I execute the following command to deploy the DB on my local >> > MySQL server, I get this message on MacOS : >> > >> > [INFO] --- sql-maven-plugin:1.5:execute (drop-database) @ >> cloud-developer >> > --- >> > [INFO] >> > ------------------------------------------------------------------- >> > ----- >> > [INFO] BUILD FAILURE >> > [INFO] >> > ------------------------------------------------------------------- >> > ----- >> > [INFO] Total time: 1:18.422s >> > [INFO] Finished at: Mon Nov 05 18:06:45 CET 2012 [INFO] Final Memory: >> > 11M/81M [INFO] >> > ------------------------------------------------------------------- >> > ----- >> > [ERROR] Failed to execute goal >> > org.codehaus.mojo:sql-maven-plugin:1.5:execute (drop-database) on >> project >> > cloud-developer: Communications link failure [ERROR] [ERROR] The >> > last >> packet >> > sent successfully to the server was 0 milliseconds ago. The driver >> > has >> not >> > received any packets from the server. Operation timed out >> > >> > I can connect without a root password to the server : >> > >> > MacBook:incubator-cloudstack chmoulli$ mysql -h localhost -u root >> > -P >> 3306 >> > Welcome to the MySQL monitor. Commands end with ; or \g. >> > Your MySQL connection id is 44 >> > Server version: 5.5.28 MySQL Community Server (GPL) >> > mysql> >> > >> > or using cloud as username and cloud as password >> > >> > Does somebody knows the reason ? >> > >> > Regards, >> > >> > -- >> > Charles Moulliard >> > Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : >> @cmoulliard | >> > Blog : http://cmoulliard.blogspot.com >> > >> >> -- >> Sent from my mobile device >> >> Charles Moulliard >> Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : >> @cmoulliard | Blog : http://cmoulliard.blogspot.com >> > > > > -- > Charles Moulliard > Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : > @cmoulliard | Blog : http://cmoulliard.blogspot.com > > > -- Charles Moulliard Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
