brayden.jo's profile - activity

I am using the askbot hosting. I decided to migrate from askbot to self hosting. From the askbot hosting, I can download backup files as the tar.gz format.

For the self hosting, I am using Ubuntu 16.04 and Python 2.7 (installed version) and postgresql 9.5. At the first time, I installed askbot by using the pip command. Then, I copied everything askbot document as below.

1. install pip and install askbot

   $ sudo apt install python-pip

   $ pip install askbot

2. install postgresql

   $ sudo apt-get install postgresql postgresql-contrib

   $ sudo apt-get install python-psycopg2

   $ sudo apt-get install libqp-dev

3. add the postgres user and database

   $ sudo -u postgres psql

   $ CREATE DATABASE askbotdb;

   $ CREATE ROLE askbotuser WITH LOGIN PASSWORD 'password';

   $ GRANT ALL PRIVILEGES ON DATABASE askbotdb TO askbotuser;

4. Add users and authorized 'superuser' to restore the backup file downloaded from askbot.org.

   $ create role askbot with login password 'password';

   $ alter role askbot superuser;

   $ alter role askbotuser superuser;

5. restore backup file.

   $ tar zxvf backups.tar.gz

   $ psql -U askbotuser askbotdb < dump.sql

6. Edit the pg_hba.conf

7. restart postgres

8. make the directory for django project.

   $ sudo usermod -a -G www-data root

   $ sudo mkdir -p /var/www/project_name

   $ sudo chown root:www-data /var/www/project_name

   $ sudo chmod g+w /var/www/project_name

   $ cd /var/www/project_name

   $ askbot-setup

9. Fill the basic information

   1) . 2) 1 (postgresql) 3) askbotdb 4) askbotuser 5) password for askbotuser

10. run below command

    $ python manage.py collectstatic

11. change mode

    $ sudo chmod g+x askbot/upfiles

    $ sudo chmod g+x log/

    $ sudo chown -R root:www-data /var/www/project-name

12. run below command.

    $ python mange.py migrate askbot --fake-initial

    WARNING!!! You are using a 'locmem' (local memory) caching backend, which is OK for a low volume site running on a single-process server. For a multi-process configuration it is neccessary to have a production cache system, such as redis or memcached.

    With local memory caching and multi-process setup you might intermittently see outdated content on your site.

    Please run command

    python manage.py collectstatic
    

    System check identified some issues:

    WARNINGS: django_authopenid.UserPasswordQueue.user: (fields.W342) Setting unique=True on a ForeignKey has the same effect as using a OneToOneField. HINT: ForeignKey(unique=True) is usually better served by a OneToOneField. group_messaging.SenderList.recipient: (fields.W342) Setting unique=True on a ForeignKey has the same effect as using a OneToOneField. HINT: ForeignKey(unique=True) is usually better served by a OneToOneField. Operations to perform: Apply all migrations: askbot Running migrations: Rendering model states... DONE Applying askbot.0001_initial...Traceback (most recent call last): File "manage.py", line 10, in <module> execute_from_command_line(sys.argv) File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line utility.execute() File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv self.execute(args, *cmd_options) File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute ...