topic Qlik Sense shared cluster on FreeNAS in Management & Governance

Qlik Sense shared cluster on FreeNAS

korsikov — Tue, 21 Feb 2017 16:17:24 GMT

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?

Re: Qlik Sense shared cluster on FreeNAS

korsikov — Tue, 21 Feb 2017 16:25:06 GMT

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

Re: Qlik Sense shared cluster on FreeNAS

korsikov — Wed, 22 Feb 2017 07:58:29 GMT

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-Shared.htm#anchor-3

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 ??

Re: Qlik Sense shared cluster on FreeNAS

korsikov — Wed, 22 Feb 2017 08:28:45 GMT

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

Locate the following line:host all all 127.0.0.1/32 trust
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.
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.
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 - YouTube

Re: Qlik Sense shared cluster on FreeNAS

korsikov — Wed, 22 Feb 2017 10:22:14 GMT

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