# Sonar

- [http://www.sonarsource.org/](http://www.sonarsource.org/)<span class="anchor" id="bkmrk-"></span><span class="anchor" id="bkmrk--1"></span>
- [![archi.png](http://218.39.181.171:6875/uploads/images/gallery/2023-05/scaled-1680-/archi.png)](http://218.39.181.171:6875/uploads/images/gallery/2023-05/archi.png)
- What is Sonar ?<span class="anchor" id="bkmrk--2"></span>
    - Sonar는 Codehaus에서 개발한 코드 품질 관리 플랫폼으로, 오픈소스<span class="anchor" id="bkmrk--3"></span>
    - PMD, [CheckStyle](http://web.joang.com:9000/jcook/CheckStyle), Findbugs, Cobertura등을 이용해서 코드검사, 코드커버리지, 중복도, 복잡도 등의 데이터를 추출해주고,그 외 품질관련 데이터도 뽑아주기 때문에 수월하게 좋은 데이터를 얻을 수 있다.<span class="anchor" id="bkmrk--4"></span>
        
        
        - [PMD](http://web.joang.com:9000/jcook/PMD) : source quality assurence<span class="anchor" id="bkmrk--5"></span><span class="anchor" id="bkmrk--6"></span>
    - 프로젝트 내의 규칙을 추가로 적용하여 반영할 수 있다.<span class="anchor" id="bkmrk--7"></span><span class="anchor" id="bkmrk--8"></span><span class="anchor" id="bkmrk--9"></span>
- Download Sonar<span class="anchor" id="bkmrk--10"></span>
    - [http://www.sonarsource.org/downloads/](http://www.sonarsource.org/downloads/)<span class="anchor" id="bkmrk--11"></span><span class="anchor" id="bkmrk--12"></span>
- [MySql](http://web.joang.com:9000/jcook/MySql)<span class="anchor" id="bkmrk--13"></span>
    
    
    - show databases;<span class="anchor" id="bkmrk--14"></span><span class="anchor" id="bkmrk--15"></span><span class="anchor" id="bkmrk--16"></span><span class="anchor" id="bkmrk--17"></span><span class="anchor" id="bkmrk--18"></span><span class="anchor" id="bkmrk--19"></span><span class="anchor" id="bkmrk--20"></span><span class="anchor" id="bkmrk--21"></span><span class="anchor" id="bkmrk--22"></span><span class="anchor" id="bkmrk--23"></span><span class="anchor" id="bkmrk--24"></span>```
        +--------------------+
        | Database           |
        +--------------------+
        | information_schema | 
        | mysql              | 
        | redmine            | 
        | test               | 
        +--------------------+
        4 rows in set (0.13 sec)
        ```
        
        <span class="anchor" id="bkmrk--25"></span><span class="anchor" id="bkmrk--26"></span><span class="anchor" id="bkmrk--27"></span><span class="anchor" id="bkmrk--28"></span><span class="anchor" id="bkmrk--29"></span><span class="anchor" id="bkmrk--30"></span><span class="anchor" id="bkmrk--31"></span><span class="anchor" id="bkmrk--32"></span><span class="anchor" id="bkmrk--33"></span>```
        mysql> create user 'sonar_usr'@'localhost' identified by 'sonar_usr';
        Query OK, 0 rows affected (0.00 sec)
        
        mysql> grant all privileges on sonar_db.* to 'sonar_usr'@'localhost' with grant  option;
        Query OK, 0 rows affected (0.00 sec)
        
        mysql> 
        ```
        
        <span class="anchor" id="bkmrk--34"></span><span class="anchor" id="bkmrk--35"></span>
- Sonar config<span class="anchor" id="bkmrk--36"></span>
    - <span class="anchor" id="bkmrk--37"></span><span class="anchor" id="bkmrk--38"></span><span class="anchor" id="bkmrk--39"></span><span class="anchor" id="bkmrk--40"></span><span class="anchor" id="bkmrk--41"></span><span class="anchor" id="bkmrk--42"></span><span class="anchor" id="bkmrk--43"></span><span class="anchor" id="bkmrk--44"></span><span class="anchor" id="bkmrk--45"></span><span class="anchor" id="bkmrk--46"></span><span class="anchor" id="bkmrk--47"></span><span class="anchor" id="bkmrk--48"></span><span class="anchor" id="bkmrk--49"></span><span class="anchor" id="bkmrk--50"></span><span class="anchor" id="bkmrk--51"></span><span class="anchor" id="bkmrk--52"></span><span class="anchor" id="bkmrk--53"></span>```
        #----- MySQL 5.x/6.x
        # Comment the embedded database and uncomment the following lines to use MySQL
        sonar.jdbc.url:                            jdbc:mysql://localhost:3306/sonar_db?useUnicode=true&characterEncoding=utf8
        sonar.jdbc.driverClassName:                com.mysql.jdbc.Driver
        sonar.jdbc.validationQuery:                select 1
        
        
        #----- Global database settings
        sonar.jdbc.username:                       sonar_usr
        sonar.jdbc.password:                       sonar_usr
        sonar.jdbc.maxActive:                      10
        sonar.jdbc.maxIdle:                        5
        sonar.jdbc.minIdle:                        2
        sonar.jdbc.maxWait:                        5000
        sonar.jdbc.minEvictableIdleTimeMillis:     600000
        sonar.jdbc.timeBetweenEvictionRunsMillis:  30000
        ```
        
        <span class="anchor" id="bkmrk--54"></span><span class="anchor" id="bkmrk--55"></span><span class="anchor" id="bkmrk--56"></span>
- Start<span class="anchor" id="bkmrk--57"></span>
    - /apps/sonar-2.7/bin/linux-x86-32/sonar.sh start<span class="anchor" id="bkmrk--58"></span><span class="anchor" id="bkmrk--59"></span>
- Stop<span class="anchor" id="bkmrk--60"></span>
    - /apps/sonar-2.7/bin/linux-x86-32/sonar.sh stop<span class="anchor" id="bkmrk--61"></span><span class="anchor" id="bkmrk--62"></span><span class="anchor" id="bkmrk--63"></span><span class="anchor" id="bkmrk--64"></span><span class="anchor" id="bkmrk--65"></span><span class="anchor" id="bkmrk--66"></span>

---

<span class="anchor" id="bkmrk--69"></span>

- 가이드 문서 : [http://www.sonarsource.org/support/documentation/](http://www.sonarsource.org/support/documentation/)