4 Replies Latest reply: Feb 22, 2017 5:22 AM by alexander korsikov RSS

    Qlik Sense shared cluster on FreeNAS

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

        • Re: Qlik Sense shared cluster on FreeNAS
          alexander korsikov

          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
            alexander 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 - YouTube

            • Re: Qlik Sense shared cluster on FreeNAS
              alexander korsikov

              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