topic Re: Connection string Editor in N-Printing in Qlik NPrinting

Connection string Editor in N-Printing

PaulaMc — Wed, 08 Jun 2022 11:09:04 GMT

Hi, in Qlikview you can view the connection string editor by going to

repository>util>QlikSenseUtil>QliksenseUtil.exe

How do I see the connection string editor in n-printing?

Thanks

Re: Connection string Editor in N-Printing

Ray_Strother — Wed, 08 Jun 2022 12:23:10 GMT

Hello ,

1. I don't believe that utility exist for Nprinting.

2. Below is a link to how to connect to the Nprinting database and the location of the config files.

3. You can also make a feature request.

Article and help links:

1. https://community.qlik.com/t5/Knowledge/How-to-Connect-to-the-PostgreSQL-Database-used-for-Qlik/ta-p/1714888

2. https://community.qlik.com/t5/Knowledge/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1712581

Re: Connection string Editor in N-Printing

PaulaMc — Wed, 08 Jun 2022 12:26:42 GMT

Thankyou. I was trying to see the password on there as its not been retained at all. do you know if there is any way around this?

Re: Connection string Editor in N-Printing

Ray_Strother — Wed, 08 Jun 2022 12:29:13 GMT

What version of Nprinting are you using?

Re: Connection string Editor in N-Printing

PaulaMc — Wed, 08 Jun 2022 12:34:27 GMT

NPrinting May 2021 SR1

Re: Connection string Editor in N-Printing

Ray_Strother — Wed, 08 Jun 2022 12:37:34 GMT

Hello ,

Unfortunately in later version of Nprinting the password is encrypted.

Re: Connection string Editor in N-Printing

PaulaMc — Wed, 08 Jun 2022 12:43:12 GMT

Thanks for confirming Ray. Would you know if this will allow us to do a backup without this? and then reset the password? Ultimately I am trying to upgrade the n-printing. All the documentation without a password and with regards to password reset relates to Qliksense!

Re: Connection string Editor in N-Printing

Ray_Strother — Wed, 08 Jun 2022 13:05:04 GMT

This process should be the best to follow.

https://community.qlik.com/t5/Knowledge/Forgot-the-NPrinting-s-postgres-superuser-password-password/ta-p/1717485

Re: Connection string Editor in N-Printing

Frank_S — Wed, 08 Jun 2022 17:26:50 GMT

Hi @PaulaMc

Just some additional information:

With May 2021 NPrinting, the super user password is not required to create an NPrinting Backup.
See note inside this article: How to BackUp and Restore Qlik NPrinting Repositor... - Qlik Community - 1715863
- From NPrinting February 2020 and later versions, it is NOT necessary to enter a password

Kind regards...

Re: Connection string Editor in N-Printing

PaulaMc — Thu, 09 Jun 2022 08:16:40 GMT

Thanks Everyone.

Can I just check I have understood the process.

Perform Backup
reset the password
Uninstall NPrinting
Re-install on same version
restore backup
perform upgrade

Would this be the right order?

Re: Connection string Editor in N-Printing

David_Friend — Thu, 09 Jun 2022 18:38:38 GMT

@PaulaMc that looks correct to me. I would add that before doing ANYTHING you take a snapshot or a full backup of the server so if something doesn't work right you can quickly revert to a good state, and then start over the next day!

Re: Connection string Editor in N-Printing

Frank_S — Thu, 09 Jun 2022 18:45:37 GMT

@PaulaMc

In addition to David's excellent point I will add that if you cannot image your NP server, that you set up a TEST NP server that you can restore to so you can test your NP database is OK.

Once that is done then:

Perform Backup (there is no need to use a password as mentioned in my earlier post with May 2021 NPrinting.)
reset the password - (there is no password reset needed at this stage if you are using a version of NPrinting From Feb. 2020 or later)
Uninstall NPrinting
Re-install on same version (and ensure you document the username, email address, password used to install NPrinting with. (the superuser password is the password entered on the first screen of the installation process.)
Log into Nprinting and insert the product key
restore backup
perform upgrade

Kind regards