Reports database connection issues

For temporary troubleshooting purposes, set the IPV4 local connections to allow address 0.0.0.0/0. This setting allows all IP addresses to connect. If the business intelligence tool can connect with that setting, you can figure out which specific IP addresses need to be added to the allowed list in pg_hba.conf.

To determine whether the database is listening on the port:

1. Open a command line and type: netstat -an

   A list of open ports is displayed.

2. Check the list for the port specified on the Database Settings page.

If the database is not listening on the port, stop and restart the PostgreSQL database. The sample commands listed below use the default values from the Database Settings for the user name, password, and port number. If you changed any of those values, use your values in the command.

1. Stop the database:
   • docker stop rpd-reports-postgres

     or

   • pg_ctl stop -o "-p portnumber" -U rpdreports

     Where rpdreports is the user name of the PostgreSQL user and portnumber is the port that RICOH ProcessDirector uses to access the Reports database.

     or

   • /usr/pgsql-15/bin/pg_ctl stop -o "-p portnumber" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace

     Where rpdreports and testpassword are the name and password for the PostgreSQL user and portnumber is the port that RICOH ProcessDirector uses to access the Reports database.

2. Start the database:
   Note:
   • On Windows, running the database command can be unreliable. To see whether the database started, log in to RICOH ProcessDirector and click the Administration tab. Open Reports ⇒ Database Settings.

     If the page reports that the database is connected, the command worked correctly. If the page reports that the database is not connected, click the switch to enable data collection. RICOH ProcessDirector starts the database for you.

   • docker start rpd-reports-postgres

     or

   • pg_ctl start -o "-p portnumber" -U rpdreports

     Where rpdreports is the user name of the PostgreSQL user and portnumber is the port that RICOH ProcessDirector uses to access the Reports database.

     or

   • /usr/pgsql-15/bin/pg_ctl start -o "-p portnumber" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace

     Where rpdreports and testpassword are the name and password for the PostgreSQL user and portnumber is the port that RICOH ProcessDirector uses to access the Reports database.

• Check for firewalls or other network issues.
• If no other network issues exist, reboot the server that holds the database.