Accessing CheckoutApp Database

At first, be sure you firewall your network to checkout's server or else you might have security risks. It is recommended to only forward TCP port 5505 on which Checkout's Postgres server is accessed and to enable access of WAN to only your Magento's host IP for extra security. In order for this Magento module to work, your Magento host server will have to be able to reach Checkout's server (normally this means to have server set on a static IP)

Locally, if you want to access Checkout's DB, first launch Checkout. The welcome window will show, and a loading wheel on the top right will indicate server is being started. Once server started open your preferred GUI Postgres Admin (like pgAdmin or Navicat).



When you setup a new store in Checkout, a 6 character Database Name is used, and non-related to the name you have set.
Checkout comes with a preset demo store...but let's just try to look at which databases are available on the server first.

Set in pgAdmin host as localhost (or any other adequate IP).
set port: 5505
username: admin
password: admin
set maintenance DB the default postgres

you should now be able to login.



Take note of the required DB name, we will need to input this in the module's configuration in Magento. (note that if you did not setup a new store, you should be able to see a DB already there which is the demo store)