You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Charles Moulliard <ch...@gmail.com> on 2012/11/05 18:29:04 UTC

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

Re: Issue during build of Cloudstack DB

Posted by Charles Moulliard <ch...@gmail.com>.
Find the reason. There was still an override db.properties file. That works
now.


On Mon, Nov 5, 2012 at 10:39 PM, Edison Su <Ed...@citrix.com> wrote:

> 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:ch007m@gmail.com]
> 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 <ch...@gmail.com>
> 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 <ch007m@gmail.com
> >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
> >> <Ab...@citrix.com>
> >> 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:ch007m@gmail.com]
> >> > 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

RE: Issue during build of Cloudstack DB

Posted by Edison Su <Ed...@citrix.com>.
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:ch007m@gmail.com] 
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 <ch...@gmail.com> 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 <ch...@gmail.com>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 
>> <Ab...@citrix.com>
>> 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:ch007m@gmail.com]
>> > 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

Re: Issue during build of Cloudstack DB

Posted by Charles Moulliard <ch...@gmail.com>.
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 <ch...@gmail.com> 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 <ch...@gmail.com>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 <ch...@gmail.com>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 <Ab...@citrix.com>
>>> 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:ch007m@gmail.com]
>>> > 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

Re: Issue during build of Cloudstack DB

Posted by Charles Moulliard <ch...@gmail.com>.
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 <ch...@gmail.com> 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 <ch...@gmail.com>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 <Ab...@citrix.com>
>> 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:ch007m@gmail.com]
>> > 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

Re: Issue during build of Cloudstack DB

Posted by Charles Moulliard <ch...@gmail.com>.
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 <ch...@gmail.com> 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 <Ab...@citrix.com>
> 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:ch007m@gmail.com]
> > 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

Re: Issue during build of Cloudstack DB

Posted by Charles Moulliard <ch...@gmail.com>.
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 <Ab...@citrix.com> 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:ch007m@gmail.com]
> 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

RE: Issue during build of Cloudstack DB

Posted by Abhijith Chandrashekar <Ab...@citrix.com>.
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:ch007m@gmail.com] 
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