Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

rafael_tramonti
New Contributor II

NPrinting Postgres Password Reset

Hi there community !

I started a NPrinting upgrade from September to November version in a customer where nobody was aware of Postgres password, so I´m not able to do data base backup.

Is there a Qlik doc on how to reset the password for NPrinting Postgres ?

I already checked the Qlik Sense doc on how to do it, but the files and folders are not the same, so it didn´t worked.

Any ideia ?

Kind regards,

Tags (2)
1 Solution

Accepted Solutions
rafael_tramonti
New Contributor II

Re: NPrinting Postgres Password Reset

Team, sorry for not answering before !

rpc‌, mto‌, rwunderlich

Based on your advise, I created a case with Qlik and received the following answer and worked fine to me !

1. Stop all NPrinting services

2. Open file pg_hba.conf at C:\ProgramFiles\NPrintingServer\data

3. Change METHOD from md5 to trust. Save the file

4. Start only QlikNprintingRepoService

5. Open file pgadmin3.exe at C:\ProgramFiles\NPrintingServer\pgsql\bin

6. Clik Add a connection to server

7. Use the following details in New Server Registration

Name: Nprinting

Server: localhost

Port: 4992

Maintenance DB: postgres (select from pull down)

Username: postgres

Password: Left the field empty

8. Once connected, select Nprinting then go to File > Change Password

9. Enter your old password (empty again) and new password (x2) as requested

10. Now stop the QlikNprintnigRepoService as well

11. Update the "pg-password" key value stored in these 2 config files to the new password:

C:\Program Files\NPrintingServer\NPrinting\WebEngine\webengine.config

C:\Program Files\NPrintingServer\NPrinting\Scheduler\scheduler.config

12. Change METHOD from trust to md5. Save the file

13. Start all NPrinting services

6 Replies
Employee
Employee

Re: NPrinting Postgres Password Reset

I also tried to find this document and didn´t find out.

I guess that should be the same of Qlik Sense, but.....

mto‌‌ hicrwunderlich, do you‌ know some oficial document from Qlik to help this guy?

Regards

Employee
Employee

Re: NPrinting Postgres Password Reset

Hi Ricardo - thanks for tagging me I put this in front of the NPrinting team - they are quite busy, but am hoping they can chime in here. Stand by.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: NPrinting Postgres Password Reset

Abosulety Michael, don´t worry.

It´s not a mission critical for me.

I think that some customers could have this issue and a simple step-by-step can help them.

Thanks a lot.

bjt
New Contributor II

Re: NPrinting Postgres Password Reset

Hi Rafael,

Are you able to open a support case, so we may assist you with the recovery of the postgres password in NPrinting?  Someone in support will be able to assist, and recover it, but it should only be done with the assistance of a support engineer.  Thanks!

Regards,

Dillon Mullis

Highlighted
Employee
Employee

Re: NPrinting Postgres Password Reset

Please open a support ticket about this issue.

Thanks

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
rafael_tramonti
New Contributor II

Re: NPrinting Postgres Password Reset

Team, sorry for not answering before !

rpc‌, mto‌, rwunderlich

Based on your advise, I created a case with Qlik and received the following answer and worked fine to me !

1. Stop all NPrinting services

2. Open file pg_hba.conf at C:\ProgramFiles\NPrintingServer\data

3. Change METHOD from md5 to trust. Save the file

4. Start only QlikNprintingRepoService

5. Open file pgadmin3.exe at C:\ProgramFiles\NPrintingServer\pgsql\bin

6. Clik Add a connection to server

7. Use the following details in New Server Registration

Name: Nprinting

Server: localhost

Port: 4992

Maintenance DB: postgres (select from pull down)

Username: postgres

Password: Left the field empty

8. Once connected, select Nprinting then go to File > Change Password

9. Enter your old password (empty again) and new password (x2) as requested

10. Now stop the QlikNprintnigRepoService as well

11. Update the "pg-password" key value stored in these 2 config files to the new password:

C:\Program Files\NPrintingServer\NPrinting\WebEngine\webengine.config

C:\Program Files\NPrintingServer\NPrinting\Scheduler\scheduler.config

12. Change METHOD from trust to md5. Save the file

13. Start all NPrinting services

Community Browser