| rev | 
   line source | 
| 
bsw@1045
 | 
     1 <html>
 | 
| 
bsw@1045
 | 
     2 <head>
 | 
| 
jbe@1046
 | 
     3 <title>LiquidFeedback Installation Instructions</title>
 | 
| 
bsw@1045
 | 
     4 </head>
 | 
| 
bsw@1045
 | 
     5 <body>
 | 
| 
jbe@1046
 | 
     6 <h1>LiquidFeedback Installation Instructions</h1>
 | 
| 
jbe@1046
 | 
     7 
 | 
| 
jbe@1046
 | 
     8 <p>This document gives a short outline about the necessary steps to setup a
 | 
| 
jbe@1046
 | 
     9 LiquidFeedback system.</p>
 | 
| 
jbe@1046
 | 
    10 
 | 
| 
jbe@1046
 | 
    11 <h2>1. Install necessary dependencies</h2>
 | 
| 
jbe@1046
 | 
    12 
 | 
| 
jbe@1046
 | 
    13 <p>If you're using a Debian system, make sure that the following packages are
 | 
| 
jbe@1046
 | 
    14 installed:</p>
 | 
| 
jbe@1046
 | 
    15 
 | 
| 
bsw@1045
 | 
    16 <ul>
 | 
| 
jbe@1156
 | 
    17 <li>build-essential</li>
 | 
| 
jbe@1156
 | 
    18 <li>lua5.2</li>
 | 
| 
jbe@1156
 | 
    19 <li>liblua5.2-dev</li>
 | 
| 
jbe@1308
 | 
    20 <li>postgresql (including the corresponding server-dev package)</li>
 | 
| 
bsw@1045
 | 
    21 <li>libpq-dev</li>
 | 
| 
jbe@1308
 | 
    22 <li>libbsd-dev</li>
 | 
| 
jbe@1244
 | 
    23 <li>pmake or bmake</li>
 | 
| 
bsw@1045
 | 
    24 <li>imagemagick</li>
 | 
| 
bsw@1045
 | 
    25 <li>exim4</li>
 | 
| 
jbe@1191
 | 
    26 <li>markdown2 (<code>apt-get install python-pip; pip install markdown2</code>)</li>
 | 
| 
bsw@1045
 | 
    27 </ul>
 | 
| 
jbe@1046
 | 
    28 
 | 
| 
jbe@1046
 | 
    29 <p>If you're using any other Linux distribution or BSD system, install the
 | 
| 
jbe@1046
 | 
    30 necessary software components accordingly.</p>
 | 
| 
jbe@1046
 | 
    31 
 | 
| 
jbe@1046
 | 
    32 <h2>2. Ensure that the user account of your webserver has access to the database</h2>
 | 
| 
jbe@1046
 | 
    33 
 | 
| 
jbe@1156
 | 
    34 <p>The useraccount of the webserver (usually <code>www-data</code>) or the Moonbridge server
 | 
| 
jbe@1156
 | 
    35 process needs to have access to your PostgreSQL installation. This is done by
 | 
| 
jbe@1156
 | 
    36 executing PostgreSQL's shell command <code>createuser</code> as database superuser
 | 
| 
jbe@1156
 | 
    37 (usually <code>pgsql</code>, or <code>postgres</code> for Debian installations):</p>
 | 
| 
jbe@1046
 | 
    38 
 | 
| 
jbe@1191
 | 
    39 <pre><code>su postgres -s $SHELL
 | 
| 
jbe@1191
 | 
    40 createuser --no-superuser --createdb --no-createrole www-data
 | 
| 
jbe@1046
 | 
    41 exit
 | 
| 
jbe@1046
 | 
    42 </code></pre>
 | 
| 
jbe@1046
 | 
    43 
 | 
| 
jbe@1046
 | 
    44 <h2>3. Install and configure LiquidFeedback-Core</h2>
 | 
| 
jbe@1046
 | 
    45 
 | 
| 
jbe@1046
 | 
    46 <p>We recommend to create the database with the same user as your webserver
 | 
| 
jbe@1046
 | 
    47 (usually <code>www-data</code>) to avoid having to setup database privileges.</p>
 | 
| 
jbe@1046
 | 
    48 
 | 
| 
jbe@1046
 | 
    49 <p>The example below installs the database as <code>www-data</code> and stores the two
 | 
| 
jbe@1046
 | 
    50 executables <code>lf_update</code> and <code>lf_update_issue_order</code> in the directory
 | 
| 
jbe@1046
 | 
    51 <code>/opt/liquid_feedback_core/</code>:</p>
 | 
| 
jbe@1046
 | 
    52 
 | 
| 
bsw@1045
 | 
    53 <pre><code># Download and unpack LiquidFeedback-Core
 | 
| 
bsw@1045
 | 
    54 # from http://www.public-software-group.org/pub/projects/liquid_feedback/backend/
 | 
| 
bsw@1045
 | 
    55 make
 | 
| 
bsw@1045
 | 
    56 mkdir /opt/liquid_feedback_core
 | 
| 
jbe@1196
 | 
    57 cp core.sql lf_update lf_update_issue_order lf_update_suggestion_order /opt/liquid_feedback_core
 | 
| 
jbe@1191
 | 
    58 su www-data -s $SHELL
 | 
| 
bsw@1045
 | 
    59 cd /opt/liquid_feedback_core
 | 
| 
bsw@1045
 | 
    60 createdb liquid_feedback
 | 
| 
bsw@1045
 | 
    61 createlang plpgsql liquid_feedback  # command may be omitted, depending on PostgreSQL version
 | 
| 
jbe@1046
 | 
    62 psql -v ON_ERROR_STOP=1 -f core.sql liquid_feedback
 | 
| 
jbe@1046
 | 
    63 </code></pre>
 | 
| 
jbe@1046
 | 
    64 
 | 
| 
bsw@1045
 | 
    65 <p>A simple configuration may look as follows:</p>
 | 
| 
jbe@1046
 | 
    66 
 | 
| 
bsw@1045
 | 
    67 <pre><code>psql liquid_feedback
 | 
| 
bsw@1045
 | 
    68 
 | 
| 
jbe@1046
 | 
    69 INSERT INTO system_setting (member_ttl) VALUES ('1 year');
 | 
| 
jbe@1046
 | 
    70 INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (false, '1 hour', 20, 6);
 | 
| 
jbe@1046
 | 
    71 INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (false, '1 day', 80, 12);
 | 
| 
jbe@1046
 | 
    72 INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (true, '1 hour', 200, 60);
 | 
| 
jbe@1046
 | 
    73 INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (true, '1 day', 800, 120);
 | 
| 
jbe@1246
 | 
    74 INSERT INTO policy (index, name, min_admission_time, max_admission_time, discussion_time, verification_time, voting_time, issue_quorum_num, issue_quorum_den, initiative_quorum_num, initiative_quorum_den) VALUES (1, 'Default policy', '4 days', '8 days', '15 days', '8 days', '15 days', 10, 100, 10, 100);
 | 
| 
jbe@1046
 | 
    75 INSERT INTO unit (name) VALUES ('Our organization');
 | 
| 
jbe@1046
 | 
    76 INSERT INTO area (unit_id, name) VALUES (1, 'Default area');
 | 
| 
jbe@1046
 | 
    77 INSERT INTO allowed_policy (area_id, policy_id, default_policy) VALUES (1, 1, TRUE);
 | 
| 
jbe@1046
 | 
    78 </code></pre>
 | 
| 
jbe@1046
 | 
    79 
 | 
| 
bsw@1045
 | 
    80 <p>If you want to create an admin user with an empty password (CAUTION!), then execute the following SQL statement:</p>
 | 
| 
jbe@1046
 | 
    81 
 | 
| 
jbe@1046
 | 
    82 <pre><code>INSERT INTO member (login, name, admin, password) VALUES ('admin', 'Administrator', TRUE, '$1$/EMPTY/$NEWt7XJg2efKwPm4vectc1');
 | 
| 
jbe@1046
 | 
    83 </code></pre>
 | 
| 
jbe@1046
 | 
    84 
 | 
| 
bsw@1045
 | 
    85 <p>Exit the <code>psql</code> interface by typing:</p>
 | 
| 
jbe@1046
 | 
    86 
 | 
| 
jbe@1046
 | 
    87 <pre><code>\q
 | 
| 
jbe@1046
 | 
    88 </code></pre>
 | 
| 
jbe@1046
 | 
    89 
 | 
| 
bsw@1045
 | 
    90 <p>And don't forget to quit the <code>www-data</code> shell:</p>
 | 
| 
jbe@1046
 | 
    91 
 | 
| 
jbe@1046
 | 
    92 <pre><code>exit
 | 
| 
jbe@1046
 | 
    93 </code></pre>
 | 
| 
jbe@1046
 | 
    94 
 | 
| 
jbe@1244
 | 
    95 <h2>4. Install Moonbridge</h2>
 | 
| 
jbe@1046
 | 
    96 
 | 
| 
jbe@1156
 | 
    97 <pre><code># Download and unpack Moonbridge
 | 
| 
jbe@1156
 | 
    98 # from http://www.public-software-group.org/pub/projects/moonbridge/
 | 
| 
jbe@1156
 | 
    99 pmake MOONBR_LUA_PATH=/opt/moonbridge/?.lua
 | 
| 
jbe@1156
 | 
   100 mkdir /opt/moonbridge
 | 
| 
jbe@1156
 | 
   101 cp moonbridge /opt/moonbridge/
 | 
| 
jbe@1156
 | 
   102 cp moonbridge_http.lua /opt/moonbridge/
 | 
| 
jbe@1156
 | 
   103 </code></pre>
 | 
| 
jbe@1156
 | 
   104 
 | 
| 
jbe@1156
 | 
   105 <h2>5. Install WebMCP</h2>
 | 
| 
jbe@1156
 | 
   106 
 | 
| 
jbe@1156
 | 
   107 <p>Note: Using Debian, it may be necessary to append <code>-I /usr/include/lua5.2</code> at
 | 
| 
jbe@1046
 | 
   108 the end of the CFLAGS line in <code>Makefile.options</code> of the WebMCP source
 | 
| 
jbe@1046
 | 
   109 distibution:</p>
 | 
| 
jbe@1046
 | 
   110 
 | 
| 
bsw@1045
 | 
   111 <pre><code># Download and unpack WebMCP
 | 
| 
bsw@1045
 | 
   112 # from http://www.public-software-group.org/pub/projects/webmcp/
 | 
| 
jbe@1156
 | 
   113 vi Makefile.options  # Debian requires  -I /usr/include/lua5.2  at end of CFLAGS line
 | 
| 
bsw@1045
 | 
   114 make
 | 
| 
bsw@1045
 | 
   115 mkdir /opt/webmcp
 | 
| 
jbe@1046
 | 
   116 cp -RL framework/* /opt/webmcp/
 | 
| 
jbe@1046
 | 
   117 </code></pre>
 | 
| 
bsw@1045
 | 
   118 
 | 
| 
jbe@1156
 | 
   119 <h2>6. Install the LiquidFeedback-Frontend</h2>
 | 
| 
bsw@1045
 | 
   120 
 | 
| 
bsw@1045
 | 
   121 <p>Unpack source tree into appropriate directory, e.g. <code>/opt/liquid_feedback_frontend</code>:</p>
 | 
| 
jbe@1046
 | 
   122 
 | 
| 
bsw@1045
 | 
   123 <pre><code># Download LiquidFeedback-Frontend
 | 
| 
bsw@1045
 | 
   124 # from http://www.public-software-group.org/pub/projects/liquid_feedback/frontend/
 | 
| 
jbe@1046
 | 
   125 mv liquid_feedback_frontend-vX.X.X /opt/liquid_feedback_frontend
 | 
| 
jbe@1046
 | 
   126 </code></pre>
 | 
| 
jbe@1046
 | 
   127 
 | 
| 
bsw@1045
 | 
   128 <p>Make <code>tmp/</code> directory of LiquidFeedback-Frontend writable for webserver:</p>
 | 
| 
jbe@1046
 | 
   129 
 | 
| 
jbe@1046
 | 
   130 <pre><code>chown www-data /opt/liquid_feedback_frontend/tmp
 | 
| 
jbe@1046
 | 
   131 </code></pre>
 | 
| 
jbe@1046
 | 
   132 
 | 
| 
jbe@1156
 | 
   133 <h2>7. Configure mail system</h2>
 | 
| 
jbe@1046
 | 
   134 
 | 
| 
jbe@1046
 | 
   135 <p>It may be necessary to configure your server's mail system, e.g. running
 | 
| 
jbe@1046
 | 
   136 <code>dpkg-reconfigure exim4-config</code> on a Debian system.</p>
 | 
| 
jbe@1046
 | 
   137 
 | 
| 
jbe@1244
 | 
   138 <h2>8. Configure the LiquidFeedback-Frontend</h2>
 | 
| 
jbe@1046
 | 
   139 
 | 
| 
bsw@1045
 | 
   140 <pre><code>cd /opt/liquid_feedback_frontend/config
 | 
| 
bsw@1045
 | 
   141 cp example.lua myconfig.lua
 | 
| 
jbe@1046
 | 
   142 # edit myconfig.lua according to your needs
 | 
| 
jbe@1046
 | 
   143 </code></pre>
 | 
| 
jbe@1046
 | 
   144 
 | 
| 
jbe@1244
 | 
   145 <h2>9. Setup regular execution of <code>lf_update</code> and related commands </h2>
 | 
| 
jbe@1046
 | 
   146 
 | 
| 
jbe@1051
 | 
   147 <p>The executables <code>lf_update</code>, <code>lf_update_issue_order</code>, and
 | 
| 
jbe@1051
 | 
   148 <code>lf_update_suggestion_order</code> must be executed regularly. This may be achieved
 | 
| 
jbe@1051
 | 
   149 by creating a file named <code>/opt/liquid_feedback_core/lf_updated</code> with the
 | 
| 
jbe@1051
 | 
   150 following contents:</p>
 | 
| 
jbe@1046
 | 
   151 
 | 
| 
bsw@1045
 | 
   152 <pre><code>#!/bin/sh
 | 
| 
bsw@1045
 | 
   153 
 | 
| 
jbe@1046
 | 
   154 PIDFILE="/var/run/lf_updated.pid"
 | 
| 
bsw@1045
 | 
   155 PID=$$
 | 
| 
bsw@1045
 | 
   156 
 | 
| 
jbe@1046
 | 
   157 if [ -f "${PIDFILE}" ] && kill -CONT $( cat "${PIDFILE}" ); then
 | 
| 
jbe@1046
 | 
   158   echo "lf_updated is already running."
 | 
| 
bsw@1045
 | 
   159   exit 1
 | 
| 
bsw@1045
 | 
   160 fi
 | 
| 
bsw@1045
 | 
   161 
 | 
| 
jbe@1046
 | 
   162 echo "${PID}" > "${PIDFILE}"
 | 
| 
bsw@1045
 | 
   163 
 | 
| 
bsw@1045
 | 
   164 while true; do
 | 
| 
jbe@1191
 | 
   165   su - www-data -s /bin/sh -c 'nice /opt/liquid_feedback_core/lf_update dbname=liquid_feedback 2>&1 | logger -t "lf_updated"'
 | 
| 
jbe@1191
 | 
   166   su - www-data -s /bin/sh -c 'nice /opt/liquid_feedback_core/lf_update_issue_order dbname=liquid_feedback 2>&1 | logger -t "lf_updated"'
 | 
| 
jbe@1191
 | 
   167   su - www-data -s /bin/sh -c 'nice /opt/liquid_feedback_core/lf_update_suggestion_order dbname=liquid_feedback 2>&1 | logger -t "lf_updated"'
 | 
| 
bsw@1045
 | 
   168   sleep 5
 | 
| 
jbe@1046
 | 
   169 done
 | 
| 
jbe@1046
 | 
   170 </code></pre>
 | 
| 
jbe@1046
 | 
   171 
 | 
| 
bsw@1045
 | 
   172 <p>This file must be marked as executable:</p>
 | 
| 
jbe@1046
 | 
   173 
 | 
| 
jbe@1046
 | 
   174 <pre><code>chmod +x /opt/liquid_feedback_core/lf_updated
 | 
| 
jbe@1046
 | 
   175 </code></pre>
 | 
| 
jbe@1046
 | 
   176 
 | 
| 
bsw@1045
 | 
   177 <p>And this file should be started automatically at system boot.</p>
 | 
| 
jbe@1046
 | 
   178 
 | 
| 
jbe@1244
 | 
   179 <h2>10. Start the system</h2>
 | 
| 
jbe@1046
 | 
   180 
 | 
| 
jbe@1244
 | 
   181 <p>After <code>lf_update</code> has been executed at least once, you should be able to use
 | 
| 
jbe@1244
 | 
   182 your LiquidFeedback system.</p>
 | 
| 
jbe@1046
 | 
   183 
 | 
| 
jbe@1244
 | 
   184 <p>The server is started by calling:</p>
 | 
| 
jbe@1156
 | 
   185 
 | 
| 
jbe@1192
 | 
   186 <pre><code>su www-data -s $SHELL
 | 
| 
jbe@1192
 | 
   187 /opt/moonbridge/moonbridge /opt/webmcp/bin/mcp.lua /opt/webmcp/ /opt/liquid_feedback_frontend/ main myconfig
 | 
| 
jbe@1156
 | 
   188 </code></pre>
 | 
| 
jbe@1162
 | 
   189 
 | 
| 
jbe@1162
 | 
   190 <p>In the latter case, the Moonbridge server will open a TCP port according to
 | 
| 
jbe@1162
 | 
   191 your configuration. Directly accessing this TCP port through your webbrowser
 | 
| 
jbe@1162
 | 
   192 is helpful for development purposes. For real-life deployment, however, it is
 | 
| 
jbe@1162
 | 
   193 recommended to further proxy the application (e.g. using nginx). The proxy can
 | 
| 
jbe@1190
 | 
   194 also add HTTPS and/or HTTP/2 support (which is not supported by Moonbridge
 | 
| 
jbe@1190
 | 
   195 itself).</p>
 | 
| 
jbe@1190
 | 
   196 
 | 
| 
jbe@1190
 | 
   197 <p>To start the Moonbridge as a background process, please refer to the Moonbridge
 | 
| 
jbe@1190
 | 
   198 command line options:</p>
 | 
| 
jbe@1190
 | 
   199 
 | 
| 
jbe@1190
 | 
   200 <pre><code>Get this help message: moonbridge {-h|--help}
 | 
| 
jbe@1190
 | 
   201 Usage: moonbridge \
 | 
| 
jbe@1190
 | 
   202            [-b|--background] \
 | 
| 
jbe@1190
 | 
   203            [-d|--debug] \
 | 
| 
jbe@1190
 | 
   204            [-f|--logfacility {DAEMON|USER|0|1|...|7}] \
 | 
| 
jbe@1190
 | 
   205            [-i|--logident <syslog ident> \
 | 
| 
jbe@1190
 | 
   206            [-l|--logfile <logfile>] \
 | 
| 
jbe@1190
 | 
   207            [-p|--pidfile <pidfile>] \
 | 
| 
jbe@1190
 | 
   208            [-s|--stats] \
 | 
| 
jbe@1190
 | 
   209            -- <Lua script> [<cmdline options for Lua script>]
 | 
| 
jbe@1190
 | 
   210 </code></pre>
 | 
| 
bsw@1045
 | 
   211 </body>
 | 
| 
bsw@1045
 | 
   212 </html>
 |