FreeBSD Documentation.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

FreeBSD Documentation.

Johan Hendriks
I noticed a lot of TODO in the documentation page of baruwa 2.0 when it comes to FreeBSD.

Maybe someone can add this to the page.
This is what i do on FreeBSD.  baruwa 2.0 still does not work but i think it has nothing to do with the following.
I can not get any message into the database!

Well that is for later ..
Here the documentation part.

Step 3a

cd /usr/ports/databases/postgresql84-server
make install clean

cd /usr/ports/databases/postgresql84-plpython
make install clean


Next step
Now that the PostgreSQL server is installed you need to initialize and start it

echo # postgresql >> /etc/rc.conf
echo 'postgresql_enable="YES"' >> /etc/rc.conf
echo 'postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C -W -A md5"' >> /etc/rc.conf

/usr/local/etc/rc.d/postgresql initdb
/usr/local/etc/rc.d/postgresql start

Edit the file /usr/local/pgsql/data/pg_hba.conf


# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         postgres                          trust
host    all         all         127.0.0.1/32          md5
host    all         all         ::1/128               md5
local   all         baruwa                            trust

Use the UTC time
sed -i -e "s/^#timezone = \(.*\)$/timezone = 'UTC'/" /usr/local/pgsql/data/postgresql.conf

Restart the service

/usr/local/etc/rc.d/postgresql restart


For FreeBSD there is another postgresql user then centos and debian. 

Create the database user.
su - pgsql -c "psql postgres -c \"CREATE ROLE baruwa WITH LOGIN PASSWORD 'verysecretpw';\""

Create the database.
su - pgsql -c 'createdb -E UTF8 -O baruwa -T template1 baruwa'

Baruwa uses functions written in the plpgsql and plpythonu procedural languages.
Enable these languages in the db:
su - pgsql -c "psql baruwa -c \"CREATE LANGUAGE plpgsql;\""
su - pgsql -c "psql baruwa -c \"CREATE LANGUAGE plpythonu;\""
Creation of functions written in plpythonu requires PostgreSQL admin user access. So we create them in this step using the postgres admin account:
curl -O https://raw.github.com/akissa/baruwa2/2.0.1/baruwa/config/sql/admin-functions.sql
su - pgsql -c 'psql baruwa -f /usr/home/baruwa/admin-functions.sql'

Step 3b

RabbitMQ

cd /usr/ports/net/rabbitmq
make install clean

echo # rabbitmq >> /etc/rc.conf
echo 'rabbitmq_enable="YES"' >> /etc/rc.conf

/usr/local/etc/rc.d/rabbitmq start

Step 3c: Sphinx


cd /usr/ports/textproc/sphinxsearch
make install clean

Select postgresql support.

cd /usr/local/etc; mv sphinx.conf sphinx.conf.orig
        curl -O https://raw.github.com/akissa/baruwa2/2.0.1/extras/config/sphinx/sphinx.conf
        sed -i -e 's:sql_host =:sql_host = 127.0.0.1:' sphinx.conf
        sed -i -e 's:sql_user =:sql_user = baruwa:' sphinx.conf
        sed -i -e 's:sql_pass =:sql_pass = 'verysecretpw':' sphinx.conf
        sed -i -e 's:sql_db =:sql_db = baruwa:' sphinx.conf
        sed -i -e 's:/var/lib/sphinx:/var/db/sphinxsearch/data:g' sphinx.conf
        sed -i -e 's:/var/log/sphinx:/var/log/sphinxsearch:g' sphinx.conf


echo # sphinxsearch >> /etc/rc.conf
echo 'sphinxsearch_enable="YES"' >> /etc/rc.conf

Start the service

/usr/local/etc/rc.d/sphinxsearch start

Step 3d: Memcached

cd /usr/ports/databases/memcached
make install clean

echo # memcached >> /etc/rc.conf
echo 'memcached_enable="YES"' >> /etc/rc.conf


Step 5a: Create configuration files

mkdir usr/local/etc/baruwa
mv production.ini /usr/local/etc/baruwa

Step 5d: Create the required directories

mkdir -p /var/log/baruwa /var/run/baruwa /var/lib/baruwa/data/{cache,sessions,uploads} \
/var/lock/baruwa /usr/local/etc/MailScanner/baruwa/signatures /usr/local/etc/MailScanner/baruwa/dkim \
/usr/local/etc/MailScanner/baruwa/rules


Step 5e: Start the celery daemon

paster celeryd /usr/local/etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log &

Step 5f: Test using builtin server

paster serve --reload /usr/local/etc/baruwa/production.ini



regards
Johan



_______________________________________________
http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: FreeBSD Documentation.

Andrew Colin Kissa
Administrator

On 23 Sep 2013, at 11:49 AM, Johan Hendriks wrote:

> Maybe someone can add this to the page.

Actually you can, just clone the git repo, update and send me a pull request on github.

--
www.baruwa.org




_______________________________________________
http://pledgie.com/campaigns/12056

signature.asc (858 bytes) Download Attachment
--
Baruwa - www.baruwa.org
Reply | Threaded
Open this post in threaded view
|

Re: FreeBSD Documentation.

Johan Hendriks
Andrew Colin Kissa wrote:
On 23 Sep 2013, at 11:49 AM, Johan Hendriks wrote:

Maybe someone can add this to the page.
Actually you can, just clone the git repo, update and send me a pull request on github.

--
www.baruwa.org

Ok i will try within the next few days i hope.

gr
Johan




_______________________________________________
http://pledgie.com/campaigns/12056


_______________________________________________
http://pledgie.com/campaigns/12056