{"id":75,"date":"2017-02-20T15:09:34","date_gmt":"2017-02-20T15:09:34","guid":{"rendered":"https:\/\/d1m0.com\/?p=75"},"modified":"2017-08-26T09:13:07","modified_gmt":"2017-08-26T09:13:07","slug":"redmine-how-to","status":"publish","type":"post","link":"https:\/\/d1m0.com\/?p=75","title":{"rendered":"Redmine How To \/postgres"},"content":{"rendered":"<p>\/var\/lib\/pgsql\/9.6\/data\/pg_hba.conf<br \/>\n<strong>host redmine redmine 127.0.0.1\/32 md5<\/strong><\/p>\n<p>user add redmine12<br \/>\nadd redmine12 in sudoers<br \/>\ncd \/home\/redmine12<br \/>\nwget <a class=\"external\" href=\"http:\/\/www.redmine.org\/releases\/redmine-3.3.1.tar.gz\">http:\/\/www.redmine.org\/releases\/redmine-3.3.1.tar.gz<\/a><br \/>\nsudo tar zxvf redmine-3.3.1.tar.gz<br \/>\nsudo su postgres<br \/>\npsql<br \/>\nCREATE ROLE redmine LOGIN ENCRYPTED PASSWORD &#8216;@@&#8217; NOINHERIT VALID UNTIL &#8216;infinity&#8217;;<br \/>\nCREATE DATABASE redmine WITH ENCODING=&#8217;UTF8&#8242; OWNER=redmine;<br \/>\ncd redmine-3.3.1<br \/>\nCopy config\/database.yml.example to config\/database.yml and edit<\/p>\n<ul>\n<li><strong>production:<br \/>\nadapter: postgresql<br \/>\ndatabase: redminedb<br \/>\nhost: localhost<br \/>\nusername: redmine<br \/>\npassword: &#8220;@@&#8221;<\/strong><\/li>\n<\/ul>\n<p><!--more--><\/p>\n<p>sudo gem install bundler<br \/>\ncd \/home\/redmine12\/redmine-3.3.1\/<br \/>\nyum install ruby-dev gcc postgresql-devel ImageMagick-devel<br \/>\nbundle install &#8211;without development test<br \/>\nbundle exec rake generate_secret_token<br \/>\nRAILS_ENV=production bundle exec rake db:migrate<br \/>\nRAILS_ENV=production bundle exec rake redmine:load_default_data<br \/>\ngem install passenger &#8211;no-rdoc &#8211;no-ri<br \/>\ncd .gem\/ruby\/gems\/passenger-5.0.30\/<br \/>\nyum group install &#8220;Development Tools&#8221; libcurl-devel httpd-devel apr-devel apr-util-devel<br \/>\npassenger-install-apache2-module<br \/>\ncp \/home\/redmine12\/redmine-3.3.1 \/var\/www\/redmine\/<br \/>\nhttpd<br \/>\nredmine.conf<br \/>\n<strong>LoadModule passenger_module \/home\/redmine12\/.gem\/ruby\/gems\/passenger-5.0.30\/buildout\/apache2\/mod_passenger.so<br \/>\n&lt;IfModule mod_passenger.c&gt;<br \/>\nPassengerRoot \/home\/redmine12\/.gem\/ruby\/gems\/passenger-5.0.30<br \/>\nPassengerDefaultRuby \/usr\/bin\/ruby<br \/>\n&lt;\/IfModule&gt;<br \/>\nDocumentRoot \/var\/www\/redmine-3.3.1\/public\/<br \/>\n&lt;Directory &#8220;\/var\/www\/redmine-3.3.1\/public&#8221;&gt;<br \/>\nAllowOverride all<br \/>\nOptions -MultiViews<br \/>\nOptions FollowSymLinks<br \/>\nOrder allow,deny<br \/>\nAllow from all<\/strong><\/p>\n<p>OR<\/p>\n<p>ln -s \/home\/redmine12\/redmine-3.3.1\/public \/var\/www\/redmine-3.3.1\/public<\/p>\n<p>add in redmine.conf in &lt;Directory&gt; &#8216;PassengerResolveSymlinksInDocumentRoot on&#8217;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\/var\/lib\/pgsql\/9.6\/data\/pg_hba.conf host redmine redmine 127.0.0.1\/32 md5 user add redmine12 add redmine12 in sudoers cd \/home\/redmine12 wget http:\/\/www.redmine.org\/releases\/redmine-3.3.1.tar.gz sudo tar zxvf redmine-3.3.1.tar.gz sudo su postgres psql CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD &#8216;@@&#8217; NOINHERIT VALID UNTIL &#8216;infinity&#8217;; CREATE DATABASE redmine WITH ENCODING=&#8217;UTF8&#8242; OWNER=redmine; cd redmine-3.3.1 Copy config\/database.yml.example to config\/database.yml and edit production: adapter: postgresql database: redminedb &#8230;<\/p>\n<p><a href=\"https:\/\/d1m0.com\/?p=75\" class=\"more-link\">Continue reading &lsquo;Redmine How To \/postgres&rsquo; &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-75","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=75"}],"version-history":[{"count":3,"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":135,"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions\/135"}],"wp:attachment":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}