{"id":589,"date":"2013-03-15T19:34:00","date_gmt":"2013-03-15T18:34:00","guid":{"rendered":"http:\/\/blog.rabahi.net\/?page_id=589"},"modified":"2014-08-04T17:35:50","modified_gmt":"2014-08-04T15:35:50","slug":"sonar","status":"publish","type":"page","link":"https:\/\/blog.rabahi.net\/?page_id=589","title":{"rendered":"Sonar"},"content":{"rendered":"

Prerequiste<\/h1>\n

I assume that you have a Centos installation.<\/p>\n

Installation<\/h1>\n

You can copy\/paste this script and use it to configure automatically your server.<\/p>\n

  1. #!\/bin\/bash<\/span><\/div><\/li>
  2.  <\/div><\/li>
  3. echo<\/span> "import sonar repository"<\/span><\/div><\/li>
  4. sudo<\/span> wget<\/span> -O<\/span> \/<\/span>etc\/<\/span>yum.repos.d\/<\/span>sonar.repo http:\/\/<\/span>downloads.sourceforge.net\/<\/span>project\/<\/span>sonar-pkg\/<\/span>rpm\/<\/span>sonar.repo<\/div><\/li>
  5.  <\/div><\/li>
  6. echo<\/span> "create database sonar, user\/password sonar\/sonar"<\/span>:<\/div><\/li>
  7. mysql --user<\/span>=root --password<\/span>=root -e<\/span> "CREATE USER 'sonar'@'localhost' IDENTIFIED BY 'sonar';"<\/span><\/div><\/li>
  8. mysql --user<\/span>=root --password<\/span>=root -e<\/span> "CREATE DATABASE IF NOT EXISTS sonar;"<\/span><\/div><\/li>
  9. mysql --user<\/span>=root --password<\/span>=root -e<\/span> "use sonar; GRANT ALL PRIVILEGES ON sonar.* TO 'sonar'@'localhost' WITH GRANT OPTION;"<\/span><\/div><\/li>
  10.  <\/div><\/li>
  11. echo<\/span> "install sonar"<\/span><\/div><\/li>
  12. dnf -y<\/span> install<\/span> sonar<\/div><\/li>
  13.  <\/div><\/li>
  14. echo<\/span> "start sonar on boot"<\/span><\/div><\/li>
  15. systemctl enable<\/span> sonar.service<\/div><\/li>
  16.  <\/div><\/li>
  17. echo<\/span> "Configure sonar"<\/span><\/div><\/li>
  18. # add # before each sonar.jdbc.url that are not commented:<\/span><\/div><\/li>
  19. sed<\/span> -i<\/span> "s\/^\\(sonar.jdbc.url\\)\/#\\1\/"<\/span> \/<\/span>opt\/<\/span>sonar\/<\/span>conf\/<\/span>sonar.properties<\/div><\/li>
  20.  <\/div><\/li>
  21. # remove comment for the sonar.jdbc.url in mysql part:<\/span><\/div><\/li>
  22. sed<\/span> -i<\/span> "s\/^#\\(sonar.jdbc.url=.*jdbc:mysql\\)\/\\1\/"<\/span> \/<\/span>opt\/<\/span>sonar\/<\/span>conf\/<\/span>sonar.properties<\/div><\/li>
  23.  <\/div><\/li>
  24. # user creditential:<\/span><\/div><\/li>
  25. sed<\/span> -i<\/span> "s\/^#\\(sonar.jdbc.username=\\).*\/\\1sonar\/"<\/span> \/<\/span>opt\/<\/span>sonar\/<\/span>conf\/<\/span>sonar.properties<\/div><\/li>
  26. sed<\/span> -i<\/span> "s\/^#\\(sonar.jdbc.password=\\).*\/\\1sonar\/"<\/span> \/<\/span>opt\/<\/span>sonar\/<\/span>conf\/<\/span>sonar.properties<\/div><\/li>
  27.  <\/div><\/li>
  28. # sonar web context<\/span><\/div><\/li>
  29. sed<\/span> -i<\/span> "s\/^#\\(sonar.web.context=\\).*\/\\1\\\/sonar\/"<\/span> \/<\/span>opt\/<\/span>sonar\/<\/span>conf\/<\/span>sonar.properties<\/div><\/li>
  30. sed<\/span> -i<\/span> "s\/^\\(sonar.web.context=\\).*\/\\1\\\/sonar\/"<\/span> \/<\/span>opt\/<\/span>sonar\/<\/span>conf\/<\/span>sonar.properties<\/div><\/li>
  31.  <\/div><\/li>
  32. echo<\/span> "configure httpd (create \/etc\/httpd\/conf.d\/sonar.conf)"<\/span><\/div><\/li>
  33. cat<\/span> ><\/span> \/<\/span>etc\/<\/span>httpd\/<\/span>conf.d\/<\/span>sonar.conf <<<\/span> "EOF"<\/span><\/div><\/li>
  34. ProxyPreserveHost On<\/div><\/li>
  35. Proxypass \/<\/span>sonar http:\/\/<\/span>localhost:9000<\/span>\/<\/span>sonar<\/div><\/li>
  36. Proxypassreverse \/<\/span>sonar http:\/\/<\/span>localhost:9000<\/span>\/<\/span>sonar<\/div><\/li>
  37. ProxyRequests     Off<\/div><\/li>
  38. EOF<\/div><\/li>
  39.  <\/div><\/li>
  40. echo<\/span> "start service"<\/span><\/div><\/li>
  41. systemctl restart httpd.service<\/div><\/li>
  42. systemctl start sonar.service<\/div><\/li>
  43.  <\/div><\/li>
  44. myip<\/span>=`<\/span>hostname<\/span> -I`<\/span><\/div><\/li>
  45. echo<\/span> "Now meet you here: http:\/\/$myip<\/span>\/sonar"<\/span><\/div><\/li>
  46.  <\/div><\/li><\/ol><\/pre>\n
    That’s all \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
    Prerequiste I assume that you have a Centos installation. Installation You can copy\/paste this script and use it to configure automatically your server. That’s all \ud83d\ude42<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":562,"menu_order":4,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-589","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=589"}],"version-history":[{"count":6,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/589\/revisions"}],"predecessor-version":[{"id":1022,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/589\/revisions\/1022"}],"up":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/562"}],"wp:attachment":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}