If I run this command on DevCloud VM (= 192.168.56.2), the Mysql server is running on port 3306
root@devcloud:~# netstat -an | grep 3306 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN On Mon, Nov 5, 2012 at 10:24 PM, Charles Moulliard <[email protected]> wrote: > 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 > > > -- Charles Moulliard Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
