{"id":17,"date":"2014-10-12T14:48:55","date_gmt":"2014-10-12T14:48:55","guid":{"rendered":"http:\/\/adrhc.go.ro\/wordpress\/?p=17"},"modified":"2017-10-07T18:34:17","modified_gmt":"2017-10-07T16:34:17","slug":"install-configure-jforum","status":"publish","type":"post","link":"https:\/\/adrhc.go.ro\/blog\/install-configure-jforum\/","title":{"rendered":"Install &#038; configure JForum"},"content":{"rendered":"<pre class=\"brush:bash shell\">http:\/\/jforum.net\/install_no_wizard.jsp\r\ncd ~\/temp\r\nwget http:\/\/jforum.net\/jforum-2.1.9.zip\r\nunzip jforum-2.1.9.zip\r\n\/ffp\/opt\/apache-tomcat-7.0.54\/conf\/context.xml:\r\n    &lt;Resource name=\"jforum\"\r\n              auth=\"Container\"\r\n              type=\"javax.sql.DataSource\"\r\n              factory=\"org.apache.tomcat.jdbc.pool.DataSourceFactory\"\r\n              testWhileIdle=\"true\"\r\n              testOnBorrow=\"true\"\r\n              testOnReturn=\"false\"\r\n              validationQuery=\"SELECT 1\"\r\n              validationInterval=\"30000\"\r\n              timeBetweenEvictionRunsMillis=\"30000\"\r\n              maxActive=\"10\"\r\n              minIdle=\"1\"\r\n              maxIdle=\"3\"\r\n              maxWait=\"5000\"\r\n              initialSize=\"1\"\r\n              removeAbandonedTimeout=\"60\"\r\n              removeAbandoned=\"false\"\r\n              logAbandoned=\"false\"\r\n              minEvictableIdleTimeMillis=\"30000\"\r\n              jmxEnabled=\"false\"\r\n              jdbcInterceptors=\"org.apache.tomcat.jdbc.pool.interceptor.ConnectionState\"\r\n              username=\"jforum\"\r\n              password=\"jforum\"\r\n              driverClassName=\"com.mysql.jdbc.Driver\"\r\n              url=\"jdbc:mysql:\/\/localhost:3306\/jforum\"\/&gt;\r\ncd \/ffp\/opt\/apache-tomcat-7.0.54\/webapps\/\r\nrm -r jforum\r\nmkdir jforum &amp; cp -r ~\/temp\/jforum-2.1.9\/* jforum\r\nmysql -p\r\n#DROP DATABASE jforum;\r\nCREATE DATABASE jforum CHARACTER SET utf8;\r\nGRANT ALL ON jforum.* TO 'jforum'@'%' IDENTIFIED BY 'jforum' WITH GRANT OPTION;\r\nFLUSH PRIVILEGES;\r\nexit;\r\nhttp:\/\/nsa310:8080\/jforum\/install.jsp\r\nDatasource: java:comp\/env\/jforum\r\ncd \/ffp\/opt\/apache-tomcat-7.0.54\/webapps\/jforum\r\nfind -name *.sql -type f -exec sed -i 's\/TYPE=InnoDB\/ENGINE=InnoDB\/gi' {} \\;\r\nForum URL:\t\t\/jforum\/\r\nWebsite URL:\t\/jforum\/\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/jforum.net\/install_no_wizard.jsp cd ~\/temp wget http:\/\/jforum.net\/jforum-2.1.9.zip unzip jforum-2.1.9.zip \/ffp\/opt\/apache-tomcat-7.0.54\/conf\/context.xml: &lt;Resource name=&#8221;jforum&#8221; auth=&#8221;Container&#8221; type=&#8221;javax.sql.DataSource&#8221; factory=&#8221;org.apache.tomcat.jdbc.pool.DataSourceFactory&#8221; testWhileIdle=&#8221;true&#8221; testOnBorrow=&#8221;true&#8221; testOnReturn=&#8221;false&#8221; validationQuery=&#8221;SELECT 1&#8243; validationInterval=&#8221;30000&#8243; timeBetweenEvictionRunsMillis=&#8221;30000&#8243; maxActive=&#8221;10&#8243; minIdle=&#8221;1&#8243; maxIdle=&#8221;3&#8243; maxWait=&#8221;5000&#8243; initialSize=&#8221;1&#8243; removeAbandonedTimeout=&#8221;60&#8243; removeAbandoned=&#8221;false&#8221; logAbandoned=&#8221;false&#8221; minEvictableIdleTimeMillis=&#8221;30000&#8243; jmxEnabled=&#8221;false&#8221; jdbcInterceptors=&#8221;org.apache.tomcat.jdbc.pool.interceptor.ConnectionState&#8221; username=&#8221;jforum&#8221; password=&#8221;jforum&#8221; driverClassName=&#8221;com.mysql.jdbc.Driver&#8221; url=&#8221;jdbc:mysql:\/\/localhost:3306\/jforum&#8221;\/&gt; cd \/ffp\/opt\/apache-tomcat-7.0.54\/webapps\/ rm -r jforum [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/adrhc.go.ro\/blog\/install-configure-jforum\/#more-17\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">Install &#038; configure JForum<\/span><\/a><\/div>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,163],"tags":[7],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-configuration","category-nsa310","tag-jforum"],"_links":{"self":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":0,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}