Qlik Sense shared cluster on FreeNAS

[korsikov]

I want try intresting thing - install QS using PogreSQL and share from FreeNAS

i'm install and confiure FreeNAS windows share and create jail with PostreSQL9.3

Can connect to with DB server usung PGAdmin

but if I try install QS 3.2 shared persistence set connection parameters with DB superuser credentials and installation failed with error

Could not connect to database. Make sure that the database service is running and accepting connections, that database QSR exists and that the database user credentials are correct.

[12AC:1114][2017-02-21T18:07:52]e000: Error 0x80070643: Failed to install MSI package.

I need manualy create QRS Database?

[korsikov]

After reviewing the setup log I have a question. Why does the installation tries to install postgres SQL database on the local machine?

[korsikov]

I will describe the course of my research, perhaps someone will come in handy.

First how to install PostreSQL on FreeNAS https://forums.freenas.org/index.php?threads/how-to-install-postgresql-in-9-3.27827/

Creating a new cluster and connecting to a database on a dedicated machine

http://help.qlik.com/en-US/sense/3.2/Subsystems/Installation/Content/InstallationLicensing/Install-S...

problem now is

how change postreSQL listen port on freebsd?

What about diffirent location. In windows is

ENCODING = 'UTF8'

      TABLESPACE = pg_default

      LC_COLLATE = 'Ukrainian_Ukraine.1251'

      LC_CTYPE = 'Ukrainian_Ukraine.1251'

but in Freebsd is ru_RU.UTF-8 ??

[korsikov]

change port on freebsd PostreSQL

#/usr/local/etc/rc.d/postgresql stop

#ee /mnt/postgres/data/postgresql.conf

Where /mnt/postgres/data it is DB_DIR is I set during installation

locate and uncomment #port = 5432 and chage port to 4432

Uncomment the listen_addresses line and change it to listen_addresses = '*'.

Set the maximum number of database connections to 100 x number of nodes in the Qlik Sense, with the max_connections setting, for example, max_connections = 200 # this example is for a site with 2 nodes.

save postgresql.conf

#ee /mnt/postgres/data/pg_hba.conf

1. Locate the following line:host all all 127.0.0.1/32 trust
2. This line determines which servers can access the server that the repository database runs on. The default setting, 127.0.0.1/32, only allows localhost to access the database.
3. Replace 127.0.0.1/32 with a subnet specification that covers the IP addresses of all nodes in your site. Either add one row for each node, using /32 as suffix for each address, or add a subnet that covers all addresses using, for example, /24 as suffix. To allow all servers to access the repository database, use 0.0.0.0/0.
4. Save the pg_hba.conf file .

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

check is everythinbg correct

root@postresql:/usr/local/etc/rc.d # sockstat -4 -l | grep postgres

pgsql    postgres   22787 3  tcp4   172.17.3.4:4432       *:*

here is video instruction Deploy Qlik Sense - multi-node with shared persistence - distributed database and file storage - You...

[korsikov · Accepted solution]

I do it. It's work's

change colation

edit /etc/login.conf

postgres:\

:lang=ru_RU.UTF-8:\

:setenv=LC_COLLATE=C:\

:tc=default:

run command

#cap_mkdb /etc/login.conf

Stop PostreSQl

#/usr/local/etc/rc.d/postgresql stop

delete all data from database folder. I my case it /mnt/postresql/data

change rc.conf file to

--

postgresql_enable="YES"

postgresql_data="/mnt/postgres/data"

postgresql_flags="-w -s -m fast"

zpostgresql_initdb_flags="--locale=ru_RU.UTF-8"

postgresql_class="postgres"

--

init db again

#/usr/local/etc/rc.d/postgresql initdb --locale=ru_RU.UTF-8 --lc-collate=ru_RU.UTF-8 --lc-ctype=ru_RU.UTF-8 --encoding=UTF8 -D /mnt/postgresql/data

make the changes described in the previous post:

• change port and listen address
• change ip allow range
• create user qliksenserepository
• create QSR database with owner qliksenserepository

start PostreSQL

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

install Qlik Sense 3.2 and ProfIT