Loading...

Knowledge Center


No password required when logging into Postgres database (no password defined)
Technical Articles ID:  KB66052
Last Modified:  10/07/2013
Rated:


Environment

Red Hat Enterprise Linux (32-bit / 64-bit)
Novell SUSE Linux Enterprise Server (32-bit / 64-bit)
IBM Lotus Domino for Linux
 

Problem

Access to the Postgres database should be password protected when logging in, but there is no password prompt or check.


Cause

Password files were not added to the Postgres database that contains default passwords.

Solution

With the current implementation, only a McAfee Security for Domino on Linux  (MSDL) user will be allowed to log in to the database. By default as part of MSDL installation, the password will be set to McAfee$123.

There are two ways to change the password:

Method 1: Modify the password files and create a new database.

Creating a new database is the preferred method during the initial MSDL installation.

IMPORTANT: Do not use this method after installation if quarantined items exist in the database because it will cause the items to be lost. Use Method 2 instead.  

  1. Stop the MSDL service.
  2. Delete the MSDLData folder located under the path set for Detected items.
  3. Modify the files .passwd and .pgpass located under the /home/msdl folder with the new password.
  4. Restart the MSDL service.

     
Method 2: Modify password files without deleting the database

Use this procedure when you need to change the password after using MSDL for some time and want to retain the old database. 

IMPORTANT: To perform this procedure, the MSDL service must be running but must not be scanning and quarantining. This is best achieved is by unprotecting the Domino server.
  1. From the Security for Domino 7.5 user interface, Unprotect the Domino Server.
  2. From a shell, log in to the database as: ./psql -U msdl -p 5455 
    Log in as either msdl/root or a User (preferred).
     
  3. Navigate to the directory PostgresSQL/bin
  4. Modify the files .passwd and .pgpass located under the /home/msdl folder with the new password.
    IMPORTANT:  When modifying these files, make sure you do the following: 
    • Retain the file format and the permission set for .passwd and .pgpass.
    • End the line in both files by pressing ENTER.
    • Modify only the fifth cloumn in the .pgpass file.
       
  5. Exit the shell by typing: \q
  6. From the Security for Domino 7.5 user interface, Protect the Domino Server.

Rate this document

Did this article resolve your issue?

Please provide any comments below

Glossary of Technical Terms


Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.
United States - English
© 2003-2013 McAfee, Inc.