[lqfb-main] Test install for PP Greece

[Jan Behrens]

On 04/01/12 18:20, Stratos Zolotas wrote:
> Dear Jan,
>
> thanks for your response. In the mean time we have figured out how to
> add admin users and members (executing init.sql was the missing point).
>
> We have a test install of the stable core 1.3.1 with beta33 frontend and
> is working nicely.
>
> So until version 2.0 is stable, we will stick with this. I think that
> you are preparing an upgrade path to 2.0 for the 1.3.1 installations.
> Correct me if i'm wrong.

That is correct. Since core v1.0 we provide an easy upgrade path. 
Further instructions are included in the README file of the 
LiquidFeedback Core:

http://www.public-software-group.org/mercurial/liquid_feedback_core/file/v2.0.8/README

======
Updating is done using the update scripts in the update/ directory.
After updating it is recommended to recreate the schema as follows:
$ pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql
$ dropdb DATABASE_NAME
$ createdb DATABASE_NAME
$ psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME
$ psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME
$ rm tmp.sql
======

>
> Thank you in advance.
>
> Stratos Zolotas

Regards
Jan Behrens

>
> On Sun, Apr 1, 2012 at 7:05 PM, Jan Behrens
> <jbe at public-software-group.org <mailto:jbe at public-software-group.org>>
> wrote:
>
>     On 03/24/12 12:16, Stratos Zolotas wrote:
>
>         Hello to all and thank you for your great work.
>
>         I'm a member of the newly created Pirate Party Greece and
>         experienced
>         sysadmin (not a developer).
>
>         We want to implement liquid feeedback for use in the Pirate
>         Party Greece.
>
>         I have made a test install on a virtual machine at my home
>         system using
>         the how to here
>
>         http://dev.liquidfeedback.org/__trac/lf/wiki/installation
>         <http://dev.liquidfeedback.org/trac/lf/wiki/installation>
>
>         First of all although i can see the login screen, i haven't
>         found how to
>         login. Is there a default admin account and what is the password?
>
>
>     Dear Stratos,
>
>     there is no default account. In general the accreditation of members
>     is not part of the LiquidFeedback software, however it is planned to
>     complete the administrative interface. You may manually create an
>     account by adding it to the "member" table, or you can create so
>     called "invite codes" by adding entries to the "invite_code" table
>     of the database. If you need further advice on that, feel free to
>     ask about details.
>
>     With Version 2.0 there is no "invite_code" table anymore, and all
>     accounts and invite codes are stored in the "member" table. Voting
>     rights are granted by adding rows to the "privilege" table.
>
>     All relevant tables and columns are commented, so if you use any
>     interface (e.g. a webinterface of your choice) to access the
>     database, you may see those comments.
>
>
>
>         Second what is the procedure to upgrade to latest development
>         release?
>
>
>     You may get the latest frontend from our mercurial (hg) repositiry
>     (until there is a released package available):
>
>     http://www.public-software-__group.org/mercurial/liquid___feedback_frontend/
>     <http://www.public-software-group.org/mercurial/liquid_feedback_frontend/>
>
>     A currently working revision is tagged as "v2.beta4", you may update
>     to this version by typing:
>
>     hg update v2.beta4
>
>     if you have cloned the mercurial repository before with hg clone.
>
>
>
>         Forgive my ignorance and lack of knowledge.
>
>
>     It is not your fault, the administrative interface isn't finished
>     yet. The pirate party in germany works with a rather complicated
>     system to synchronize their party member database with the
>     LiquidFeedback member database. Other installations use individual
>     solutions, depending on the organizations needs.
>
>
>
>         Thank you in advance and keep up the good work.
>
>         Stratos.
>
>
>     Regards
>     Jan Behrens
>
>
>
>         _________________________________________________
>         Main mailing list
>         Main at dev.liquidfeedback.org <mailto:Main at dev.liquidfeedback.org>
>         http://dev.liquidfeedback.org/__cgi-bin/mailman/listinfo/main
>         <http://dev.liquidfeedback.org/cgi-bin/mailman/listinfo/main>
>
>
>
>     _________________________________________________
>     Main mailing list
>     Main at dev.liquidfeedback.org <mailto:Main at dev.liquidfeedback.org>
>     http://dev.liquidfeedback.org/__cgi-bin/mailman/listinfo/main
>     <http://dev.liquidfeedback.org/cgi-bin/mailman/listinfo/main>
>
>