topic Re: NPrinting Repository Database - Name in Qlik NPrinting

NPrinting Repository Database - Name

Anonymous — Wed, 25 Sep 2019 18:40:54 GMT

Does anyone know the name of the Qlik NPrinting repository database? For example in QlikSense the name is QSR. Actually I am able to querying the QSR database, I would like to make the same with NPrinting.

Regards,

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Fri, 28 Apr 2017 02:16:10 GMT

I am using QlikSense Postgres driver to connect to NPrinting repo:

hostname: localhost or "your server name"

Port: 4992

Database: nprinting

user name: postgres

password: here put your repository password

cheers

Lech

Re: NPrinting Repository Database - Name

Anonymous — Fri, 28 Apr 2017 15:17:39 GMT

A lot of Thanks lech_miszkiewicz‌ I have successfully connected to the NPrinting Repository database. Do you know if that database contain the information of the objects you read from QlikSense (Charts, Tables, etc.)?

Regards

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Sat, 29 Apr 2017 02:25:57 GMT

Hi,

I am working on it. I noticed that there are some information about objects (for example: Fields, Variables). I did not spend enough time to look for charts and other visualisation objects.

I am trying to build QlikView/QlikSense app which will read repository and provide simple and quick view of what NPrinting repository is storing. This is work in progress so stay tuned.

cheers

Lech

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Mon, 01 May 2017 00:54:12 GMT

Hi - look at this: Tracing QlikView/Qlik Sense objects in NPrinting Reports

I have been able to bring bit more light into it.

hth

cheers

Lech

Re: NPrinting Repository Database - Name

danielnord — Mon, 08 May 2017 14:10:32 GMT

Hi Lech,

I'm trying to connect to the database the same way you did, I can however not access it from our Sense server. I've made sure that the two servers (Sense and NP) are on the same VLAN and there is no firewall inbetween them but I cannot access the database.

Do you need to change any config file or anything to be able to access postgres from another server?

Do you have any guide or anything similar for this?

//Daniel

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Tue, 09 May 2017 02:13:07 GMT

Hi,

I have no documentation or anything - sorry. I did not do any changes to config files - just pure vanila NP and QS connection setup.

I just figured the connection details based on connection to to postgres QRS DB. So i tried couple of users, passwords, i looked in help document how the other services are communicating to repository to figure out port etc... and finally i manged to get it working.

are you able to install sense desktop on NPrinting Box just to try it localy with "localhost" so you would get figured whether it works (password user etc...) ?

cheers

Lech

Re: NPrinting Repository Database - Name

danielnord — Tue, 09 May 2017 06:56:12 GMT

Hi and thanks for your reply.

The issue here is that I have NPrinting installed on a server, and Sense Desktop cannot be installed on a server OS.

My main issue is that I cannot make a connection towards the NPrinting database, when I try to telnet the server on port 4992 I get a connection error, even though I have disabled firewalls and made sure that the two servers are on the same network. I think I might have read something about that you need to alter some config files in the Sense installation if you want any other IP than the localhost to make connections towards it, that's why I thought you needed to do the same in the NPrinting environment.

How does your setup look like? NP and Sense Desktop installed on a Windows client OS?

//Daniel

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Tue, 09 May 2017 07:12:44 GMT

I am partner and i use both on my laptop. I have QlikSense and NPrinting installed on one box running Windows 10. (i know it is not supported setup but works for testing)

How about installing PostGres client on NPrinting box and trying accessing it localy?

cheers

Lech

Re: NPrinting Repository Database - Name

gileswalker — Wed, 24 Apr 2019 00:38:55 GMT

I have been trying to connect nPrinting to Qlik Sense using the manner described in the above postings re PostgreSQL. I cannot connect unfortunately. We have nPrinting on 1 server and Sense on another…..and we can connect to nPrinting with telnet using localhost and 4992, we just can't access nPrinting from the Sense server. The firewall is off during testing. The error is per attached picture.

Specifically on the username and password for the PostgreSQL connection, which username and password should it be, the one used when you log in to nPrinting, or an admin password? I am not the admin, but none of the others I have have worked.

If anyone can maybe make a suggestion as to how to trouble shoot this I would appreciate it.

Re: NPrinting Repository Database - Name

jeshil09 — Thu, 01 Aug 2019 10:10:54 GMT

Following these steps threw the same error for me as above! It seems the remote server where the Nprinting is installed would not allow connections. After searching a while I found the reason and managed to have it working.

It looks like by default PostgreSQL does not allow remote connections, so some settings need to be updated before setting up a conneciton to to the repo db. The files that need to be edited are postgresql.conf and pg_hba.conf which for me were located under Program Data\Nprnting\data.

This step is needed, of course, in case your installations of Nprinting and QlikSense/QlikView are in different servers.

Just follow the article here https://support.qlik.com/articles/000079987

Re: NPrinting Repository Database - Name

KHSDM — Tue, 08 Oct 2019 14:49:25 GMT

Is it located inside the "data" folder? I can't find this "data" folder inside "NprintingServer" folder.

Re: NPrinting Repository Database - Name

Frank_S — Tue, 08 Oct 2019 18:14:50 GMT

Note that there is no longer a 'data' folder and thus the information (provided externally by NPrinting product forum contributors), may not be applicable for versions of NPrinting newer that Nov. 2017 NPrinting Server. The data folder no longer exists in those newer versions.

Also you must be very careful when accessing the NPrinting database directly as any direct interaction may lead to unexpected consequences.

Please ensure to backup your NPrinting Repository regularly to ensure you can quickly restore it. You may follow the steps in the following NP backup/restore article: How to BackUp and Restore NPrinting Repository Database from End to End

Re: NPrinting Repository Database - Name

Danijel — Mon, 27 Jan 2020 12:44:38 GMT

Has anyone already tried how to reestablish the connection?

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Mon, 27 Jan 2020 23:03:08 GMT

hi @Danijel

what do you mean by "reestablish the connection"?

if you are trying to connect to postgress from other machine you need to allow/accept connections from other IPs. This is explained here: https://support.qlik.com/articles/000026032

regards

Lech

Re: NPrinting Repository Database - Name

Danijel — Wed, 29 Jan 2020 11:39:08 GMT

Hey @Lech_Miszkiewicz

thanks for the link, with this I could connect to the database.

Greetings

Re: NPrinting Repository Database - Name

Sebastian_Dec — Mon, 04 Sep 2023 12:27:06 GMT

Hi, google searches hard for the article you provided, and the first solution is not always correct.
Can some moderator also mark your answer with the article as a second solution?
https://community.qlik.com/t5/Official-Support-Articles/How-to-Connect-to-the-PostgreSQL-Database-used-for-Qlik/tac-p/2112841#M10067

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Mon, 04 Sep 2023 12:44:14 GMT

Hi @Sebastian_Dec

not sure what do you mean. The topic of this conversation was to find out NPrinting repository database name. For that my answer is still correct and is marked as solution.

I could mark my second answer as solution as well, but it already is part of the conversation and it touches totally different subject which is connecting to postgres from external (not localhost) machine and which requires changes to postgres config files. Link is part of the conversation though so for those who search for answers any link provided should be a lead worth checking.

lastly - regarding google search - indeed google search engine is really poor lately and community posts are not popping up as they should when using google. I am not sure if it is community settings or google settings but indeed it is way below expectations.

Re: NPrinting Repository Database - Name

Sebastian_Dec — Mon, 04 Sep 2023 12:50:38 GMT

I understand when I was looking to connect Qlik to Nprinting via google in various ways and the query almost always pops up this post.
What I needed was the article you mentioned in a later conversation, and I didn't read the whole thread, I just focused on the solution.

Re: NPrinting Repository Database - Name

Lech_Miszkiewicz — Mon, 04 Sep 2023 13:31:33 GMT

Lesson learned - next time you will know that it is worth going through whole conversation to get a picture on the whole discussion..

Cheers