Sonar behind firewall

View: New views
8 Messages — Rating Filter:   Alert me  

Sonar behind firewall

by Pieter Degraeuwe :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be

Re: Sonar behind firewall

by Olivier Gaudin-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier



On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be


Re: Sonar behind firewall

by Pieter Degraeuwe :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks for the reply, however, I'm affraid that I can't open the ports...
Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )

Thanks

Pieter

On Mon, Oct 26, 2009 at 6:46 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier




On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be

Re: Sonar behind firewall

by Olivier Gaudin-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello Pieter,

Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
Unfortunately not
 
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )
This is due to the volume of data to be processed

Could you maybe tell in a few words a little bit more about your constraints (apart from the ports that can not be open) to see if I can suggest something to help ?

Olivier


On Tue, Oct 27, 2009 at 4:26 AM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Thanks for the reply, however, I'm affraid that I can't open the ports...
Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )

Thanks

Pieter


On Mon, Oct 26, 2009 at 6:46 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier




On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be


Re: Sonar behind firewall

by Pieter Degraeuwe :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok.

I work now in de Flemish Governement.  Here are a lot development teams. Some teams are completely third party teams (so thy develop 'in-house' : which means not on our network), others develop inside the buildings of the governement.

Since we want to standardize coding conventions, coverage, etc, we also need a tool to enforce this (by doing 'inspections'). Sonar seems to be the perfect tool for this.
Since we cannot (yet) enforce all thes teams to use our VCS, our buildserver, we want to let them 'push' the sonar measurements into our Sonar.
Of course, the Sonar instance is located behind one (probably more) firewalls for most of the development teams.

At this point, I can't see any solution to overcome the firewall problem :-(

Thanks,

Pieter

On Tue, Oct 27, 2009 at 12:18 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,


Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
Unfortunately not
 
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )
This is due to the volume of data to be processed

Could you maybe tell in a few words a little bit more about your constraints (apart from the ports that can not be open) to see if I can suggest something to help ?

Olivier



On Tue, Oct 27, 2009 at 4:26 AM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Thanks for the reply, however, I'm affraid that I can't open the ports...
Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )

Thanks

Pieter


On Mon, Oct 26, 2009 at 6:46 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier




On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be





--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be

Re: Sonar behind firewall

by Nick Stolwijk-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Can you pull their codebase in your buildserver? They don't have to use it, but you can generate statistics.

And do you need realtime statistics or are they acceptance criteria? You can take each release of the third-party vendors and run the sonar plugin inhouse to generate the statistics for each release.

Hth,

Nick Stolwijk
~Java Developer~

IPROFS BV.
Claus Sluterweg 125
2012 WS Haarlem
http://www.iprofs.nl


On Tue, Oct 27, 2009 at 12:37 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Ok.

I work now in de Flemish Governement.  Here are a lot development teams. Some teams are completely third party teams (so thy develop 'in-house' : which means not on our network), others develop inside the buildings of the governement.

Since we want to standardize coding conventions, coverage, etc, we also need a tool to enforce this (by doing 'inspections'). Sonar seems to be the perfect tool for this.
Since we cannot (yet) enforce all thes teams to use our VCS, our buildserver, we want to let them 'push' the sonar measurements into our Sonar.
Of course, the Sonar instance is located behind one (probably more) firewalls for most of the development teams.

At this point, I can't see any solution to overcome the firewall problem :-(

Thanks,

Pieter


On Tue, Oct 27, 2009 at 12:18 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,


Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
Unfortunately not
 
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )
This is due to the volume of data to be processed

Could you maybe tell in a few words a little bit more about your constraints (apart from the ports that can not be open) to see if I can suggest something to help ?

Olivier



On Tue, Oct 27, 2009 at 4:26 AM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Thanks for the reply, however, I'm affraid that I can't open the ports...
Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )

Thanks

Pieter


On Mon, Oct 26, 2009 at 6:46 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier




On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be





--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be


Re: Sonar behind firewall

by Pieter Degraeuwe :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I do want to avoid that I have to run the tests locally on my local (near Sonar) build server. The reason for this is that some projects do require specific, platform dependent properties (libraries, licenses, appservers (integration tests) , etc). To avoid having an over complicated build environment I really want to build at the 'team/development - side' .

Thanks



On Tue, Oct 27, 2009 at 1:57 PM, Nick Stolwijk <nick.stolwijk@...> wrote:
Can you pull their codebase in your buildserver? They don't have to use it, but you can generate statistics.

And do you need realtime statistics or are they acceptance criteria? You can take each release of the third-party vendors and run the sonar plugin inhouse to generate the statistics for each release.

Hth,

Nick Stolwijk
~Java Developer~

IPROFS BV.
Claus Sluterweg 125
2012 WS Haarlem
http://www.iprofs.nl



On Tue, Oct 27, 2009 at 12:37 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Ok.

I work now in de Flemish Governement.  Here are a lot development teams. Some teams are completely third party teams (so thy develop 'in-house' : which means not on our network), others develop inside the buildings of the governement.

Since we want to standardize coding conventions, coverage, etc, we also need a tool to enforce this (by doing 'inspections'). Sonar seems to be the perfect tool for this.
Since we cannot (yet) enforce all thes teams to use our VCS, our buildserver, we want to let them 'push' the sonar measurements into our Sonar.
Of course, the Sonar instance is located behind one (probably more) firewalls for most of the development teams.

At this point, I can't see any solution to overcome the firewall problem :-(

Thanks,

Pieter


On Tue, Oct 27, 2009 at 12:18 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,


Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
Unfortunately not
 
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )
This is due to the volume of data to be processed

Could you maybe tell in a few words a little bit more about your constraints (apart from the ports that can not be open) to see if I can suggest something to help ?

Olivier



On Tue, Oct 27, 2009 at 4:26 AM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Thanks for the reply, however, I'm affraid that I can't open the ports...
Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )

Thanks

Pieter


On Mon, Oct 26, 2009 at 6:46 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier




On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be





--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be

Re: Sonar behind firewall

by Olivier Gaudin-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello Pieter,

Thanks for the explanation, I do understand better now. Nick's suggestion sounds very good to me as an investment if you can have it in a CI server as Hudson for example.
If you cannot do this, then you could ask the third party vendors to setup Sonar on their side and provide them the Sonar profile to be used with the objectives.

Olivier



On Tue, Oct 27, 2009 at 9:03 AM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
I do want to avoid that I have to run the tests locally on my local (near Sonar) build server. The reason for this is that some projects do require specific, platform dependent properties (libraries, licenses, appservers (integration tests) , etc). To avoid having an over complicated build environment I really want to build at the 'team/development - side' .

Thanks




On Tue, Oct 27, 2009 at 1:57 PM, Nick Stolwijk <nick.stolwijk@...> wrote:
Can you pull their codebase in your buildserver? They don't have to use it, but you can generate statistics.

And do you need realtime statistics or are they acceptance criteria? You can take each release of the third-party vendors and run the sonar plugin inhouse to generate the statistics for each release.

Hth,

Nick Stolwijk
~Java Developer~

IPROFS BV.
Claus Sluterweg 125
2012 WS Haarlem
http://www.iprofs.nl



On Tue, Oct 27, 2009 at 12:37 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Ok.

I work now in de Flemish Governement.  Here are a lot development teams. Some teams are completely third party teams (so thy develop 'in-house' : which means not on our network), others develop inside the buildings of the governement.

Since we want to standardize coding conventions, coverage, etc, we also need a tool to enforce this (by doing 'inspections'). Sonar seems to be the perfect tool for this.
Since we cannot (yet) enforce all thes teams to use our VCS, our buildserver, we want to let them 'push' the sonar measurements into our Sonar.
Of course, the Sonar instance is located behind one (probably more) firewalls for most of the development teams.

At this point, I can't see any solution to overcome the firewall problem :-(

Thanks,

Pieter


On Tue, Oct 27, 2009 at 12:18 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,


Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
Unfortunately not
 
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )
This is due to the volume of data to be processed

Could you maybe tell in a few words a little bit more about your constraints (apart from the ports that can not be open) to see if I can suggest something to help ?

Olivier



On Tue, Oct 27, 2009 at 4:26 AM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Thanks for the reply, however, I'm affraid that I can't open the ports...
Do you think the plugin api is sufficient to solve this ? (then I could maybe write a plugin for this...)
What is the reason that the maven plugin needs directly access to the db. (from architectural point of view, is is not so a nice thing to do, not? )

Thanks

Pieter


On Mon, Oct 26, 2009 at 6:46 PM, Olivier Gaudin <gaudol@...> wrote:
Hello Pieter,

Currently the build machine needs access to the database to save the results, so you need to have the ports open.

Olivier




On Mon, Oct 26, 2009 at 1:10 PM, Pieter Degraeuwe <pieter.degraeuwe@...> wrote:
Hi,

I searched already a while to solve this problem, unfortunately, I didn't find a solution....
Here is my situation:

- I have a sonar running on machine A.
- My build machine is located on Machine B.
- between A and B there is a firewall.

Is it possible to run "mvn -Psonar install sonar:sonar" on machine B and post the results to my sonar instance on machine A.
My sonar profile points to my correct sonar.host.url (port 80 is open), but the mysql pors are blocked.
Is there a way to post the metric results over port 80 to the Sonar database. (which is in my opinion a much robuster solution, no?)

Thanks

<profile>
       <id>sonar</id>
       <activation>
         <activeByDefault>false</activeByDefault>
        </activation>
        <properties>
           <sonar.host.url>http://xxx/sonar/</sonar.host.url>          
           <sonar.jdbc.url>jdbc:mysql://xxx/sonar?useUnicode=true&amp;characterEncoding=</sonar.jdbc.url>
           <sonar.jdbc.driver>com.mysql.jdbc.Driver</sonar.jdbc.driver>
           <sonar.jdbc.username>sonar</sonar.jdbc.username>
           <sonar.jdbc.password>sonar</sonar.jdbc.password>          
     </properties>
    </profile>


--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be





--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be




--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@...
visit us at http://www.systemworks.be