How to Connect to the PostgreSQL Database used for Qlik NPrinting Repository

[Yoichi_Hirotake]

Modifying the Qlik NPrinting Repository will void the Support Agreement! Changes to the database should be performed by the Qlik NPrinting services only or through the use of supported API calls.

Qlik NPrinting use PostgreSQL as the repository database. For exploratory purposes, you can connect to the repository using pgAdmin.

1. Go to Windows Services.msc and stop all Qlik NPrinting services except the QlikNprintnigRepoService.
2. Go to Folder C:\Program Files\NPrintingServer\pgsql\bin and double click  pgAdmin3.exe 
3. Click Add a connection to a server button

4. Enter below information into New Server Registration window and press OK button

Name: Nprinting
Server: localhost
Port: 4992
Maintenance DB: Postgres (select from pull down)
Username: Postgres
Password:  The password that you entered on installation


 

5. Now connected to Qlik Nprinting Repository

Note:   It may be necessary to perform the following in order to connect to the database from other servers or from same NPrinting server without using 'localhost' or loopback 127.0.0.1 IP:  

1. Stop all NPrinting services including the repoService.
2. Obtain a backup copy of and then open the file C:\ProgramData\NPrinting\data\postgresql.conf
   Note: Older version may store this under c:\Program Files\NPrintingServer\data instead.
3. Change the parameter listen_addresses to equal '*', and remove the # sign from the beginning of the parameter string
   
   e.g: listen_addresses = '*'
   
   
4. Save and close the file.
   
   
5. Obtain a backup copy of and then open the file C:\ProgramData\NPrinting\data\pg_hba.conf
   
   
6. Change the line below the string "# IPv4 local connections:" to look like the following:
   
   host all all 0.0.0.0/0 md5
   
   
7. Save and close the file.
   
   
8. Start the QlikNPrintingRepoService.
   
   
9. Attempt connecting to the database.

Note: It is recommended to have all remaining services stopped when connecting to the database.

[Luck]

Hi, 

Is There any possibilities for nprinting to utilize database traffic encryption using SSL like qliksense does in this link ?

Best Regards,

Lucky

[Sonja_Bauernfeind]

Hello @Luck 

Let me verify this for you.

All the best,
Sonja 

[Sonja_Bauernfeind]

Hello @Luck 

This is not currently supported. I would suggest logging an idea.

All the best,
Sonja 

[ccaporaso]

Hi!

Is it possible to use connection data provided in the post to access NPrinting Repository through Qlik Sense Postgres connector?

Any precaution or advice? 

I'd be nice to access (read only mode) to the database to get relationships that are not easily shown (or not shown at all) in NPrinting application (eg. To which tasks a report is attached, In which tasks a user appears as destination, etc). 

When the use of NPrinting is intensive, maintenance can be difficult without that kind of information.

Regards,

Cecilia.

[Sonja_Bauernfeind]

Hello @ccaporaso 

This an interesting application of the Qlik Sense Postgres connector! And absolutely doable. As long as you (as you already mentioned) do not POST to the db and stay in read-only mode, you'll be good to go.

All the best,
Sonja 

[ccaporaso]

Hi @Sonja_Bauernfeind 

Thanks a lot for your answer! I'll proceed developing this set of analysis then.

Best regards, have a nice day.

Cecilia.

[Sebastian_Dec]

Hi, thanks a lot, great article. It connected without a problem.