DOWNLOAD DEMO
Current Version: 2.4.1.0 2016-04-10
Need a hand? Join the community.

Using PostgreSQL

Rate this Content 4 Votes

See the bottom of the page for the contents to create the files plpgsql.sql and CreateDatabase.sql. Place those files in your home directory or any working directory

1) First, you'll need to run as the postgres user:

su postgres

if you don't already have  the plpgsql language installed, install it:
psql -d template1 -f plpgsql.sql

2) Run
psql -d template1 -f CreateDatabase.sql

3) Create a mojoportal user:
createuser --pwprompt --no-adduser --no-createdb mojo

4) Ensure that mojo can connect through tcpip:

If your database server and webserver are on the same machine, add these 2 lines to the the top of /var/lib/pgsql/data/pg_hba.conf to create the least privileged settings for mojo to connect from the local machine.

host mojoportal mojo ::1/128 password
host mojoportal mojo 127.0.0.1 255.255.255.255 password

If your database server and webserver are on different machines, make sure the firewall on the database server machine is open to tcp traffic on port 5432 from the webserver and see the PostgreSQL documentation for details on setting listen_addresses in postgresql.conf and setting up pg_hba.conf to allow access from remote hosts.

If you want to make the postgresql server listen on all its ip addresses, in /var/lib/pgsql/data/postgresql.conf:
listen_addresses = '*'
by default it is only listening on the loopback address 127.0.0.1
you can also specify an ip address range if you don't want it to listen on all its addresses, but often there is only 1 address anyway.

5) As root, restart posgresql.
/etc/init.d/postgresql restart

6) Then just make sure that you change the password in the web.config or user.config
to the password you specified when you created the mojo user.

Navigate to yoursiteroot/Setup/Default.aspx

If you have any trouble, please post in the forums and specify your  versions of OS, db, mono and mojoPortal

Create the above script files as follows:

plpgsql.sql:

SET search_path = public, pg_catalog;

CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;

CreateDatabase.sql:

CREATE DATABASE mojoportal WITH TEMPLATE = template1 ENCODING = 'UNICODE';

mojoPortal Hosting Made Easy

Monetize Your Site With Site Membership Pro!

Go Mobile with mojoPortal and Mobile Kit Pro!