Re: [sonar-dev] Help for MySql DB for Sonar

[Freddy Mallet]

Sending an email to three mailing lists at the same time to be sure to get an answer is what I call a spam. 

I'll answer to this email but later.

-----

twitter.com/FreddyMallet

Sonar for Continuous Inspection

On Thu, Sep 13, 2012 at 10:06 AM, Vishal chugh <[hidden email]> wrote:

Hi ,

Sorry , we are new to Sonar. Trying to understand through it's documentation.

In our organization , we are using Sonar 2.3.1 and seems it is using MySQL DB ( not the embedded DB of Sonar ) .

Now we have request to move this Sonar installation to another RHEL server ( as current server having Sonar will be removed very soon).

So we plan to take tar of current sonar installation from source server and untar it on target server ( Hope we are doing right) .

Next comes taking action for MySQL DB .

We already have MySQL installed on our new RHEL target server .

We plan to take export of current MySQL DB sonar and import it on target server's mysql .

Are we thinking and doing right regarding MySQL DB or more needs to done regarding sonar  DB ?

Would be grateful if we can have documentation for the configuring MySQL DB for Sonar .

Can someone please advise urgently.

Thanks,
Vishal Chugh

[Vishal chugh]

Sorry i wasn't sure about mailing list to which i should ask my query ( Don't know , on what basis it can be decided ) . So sent to all mailing lists .

On Thu, Sep 13, 2012 at 2:37 PM, Freddy Mallet <[hidden email]> wrote:

Sending an email to three mailing lists at the same time to be sure to get an answer is what I call a spam. 

I'll answer to this email but later.

-----

twitter.com/FreddyMallet

Sonar for Continuous Inspection

On Thu, Sep 13, 2012 at 10:06 AM, Vishal chugh <[hidden email]> wrote:

Hi ,

Sorry , we are new to Sonar. Trying to understand through it's documentation.

In our organization , we are using Sonar 2.3.1 and seems it is using MySQL DB ( not the embedded DB of Sonar ) .

Now we have request to move this Sonar installation to another RHEL server ( as current server having Sonar will be removed very soon).

So we plan to take tar of current sonar installation from source server and untar it on target server ( Hope we are doing right) .

Next comes taking action for MySQL DB .

We already have MySQL installed on our new RHEL target server .

We plan to take export of current MySQL DB sonar and import it on target server's mysql .

Are we thinking and doing right regarding MySQL DB or more needs to done regarding sonar  DB ?

Would be grateful if we can have documentation for the configuring MySQL DB for Sonar .

Can someone please advise urgently.

Thanks,
Vishal Chugh

[Freddy Mallet]

Hi Vishal, 

See my comments below :

In our organization , we are using Sonar 2.3.1 and seems it is using MySQL DB ( not the embedded DB of Sonar ) .

Would be better to not have any doubt about that :)

 

Now we have request to move this Sonar installation to another RHEL server ( as current server having Sonar will be removed very soon).

OK

 

So we plan to take tar of current sonar installation from source server and untar it on target server ( Hope we are doing right) .

Yes, that's perhaps the simple option

 

Next comes taking action for MySQL DB .
We already have MySQL installed on our new RHEL target server .
We plan to take export of current MySQL DB sonar and import it on target server's mysql .
Are we thinking and doing right regarding MySQL DB or more needs to done regarding sonar  DB ?

You don't have to do anything except perhaps creating a dedicated MySQL user to be used by Sonar.

http://docs.codehaus.org/display/SONAR/Documentation

Would be grateful if we can have documentation for the configuring MySQL DB for Sonar .

There isn't anything magic to be known : 

http://docs.codehaus.org/display/SONAR/Installing+Sonar#InstallingSonar-ConfiguringDatabase

Kind regards,

Freddy

 

Can someone please advise urgently.

Thanks,
Vishal Chugh

[Vishal chugh]

We are done with this !! Thanks!!

On Fri, Sep 14, 2012 at 6:17 PM, Freddy Mallet <[hidden email]> wrote:

Hi Vishal, 

See my comments below :

In our organization , we are using Sonar 2.3.1 and seems it is using MySQL DB ( not the embedded DB of Sonar ) .

Would be better to not have any doubt about that :)

 

Now we have request to move this Sonar installation to another RHEL server ( as current server having Sonar will be removed very soon).

OK

 

So we plan to take tar of current sonar installation from source server and untar it on target server ( Hope we are doing right) .

Yes, that's perhaps the simple option

 

Next comes taking action for MySQL DB .
We already have MySQL installed on our new RHEL target server .
We plan to take export of current MySQL DB sonar and import it on target server's mysql .
Are we thinking and doing right regarding MySQL DB or more needs to done regarding sonar  DB ?

You don't have to do anything except perhaps creating a dedicated MySQL user to be used by Sonar.

http://docs.codehaus.org/display/SONAR/Documentation

Would be grateful if we can have documentation for the configuring MySQL DB for Sonar .

There isn't anything magic to be known : 

http://docs.codehaus.org/display/SONAR/Installing+Sonar#InstallingSonar-ConfiguringDatabase

Kind regards,

Freddy

 

Can someone please advise urgently.

Thanks,
Vishal Chugh