Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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,

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

6 Replies
Ricardo_Gerhard
Employee
Employee

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

Ricardo Gerhard
OEM Solution Architect
LATAM
Michael_Tarallo
Employee
Employee

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
Ricardo_Gerhard
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM
Anonymous
Not applicable
Author

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

Ruggero_Piccoli
Support
Support

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.
Anonymous
Not applicable
Author

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