Symptoms
There is a script that connects to database, uses a query to fetch list of accounts or orders to be notified and sends notifications by calling PBA-E API.
After PBA-E was migrated to CentOS 6 script stopped working.
Cause
During migration PBA-E application and PBA-E database are decoupled (i.e. if before migration they were running on same server - after migration database will be running on a separate server). If old IP address is used in script to connect to database - it will stop working.
During migration backnet and/or frontnet IP addresses of PBA-E application server (and thus of API endpoint) might get changed. If script uses old IP address to send API requests - it will stop working.
- If on old PBA-E server there was customized xinetd configuration file to allow PBA-E accept API requests on public IP and this configuration was not moved to new PBA-E server, clients that were sending API requests to public IP address of PBA-E server will stop working.
Resolution
Check database connection IP address in script and correct it if necessary. Check /var/lib/pgsql/data/pg_hba.conf on PBA-E database server and if needed add settings to allow external host to connect to database.
Move xinetd customization file to new PBA-E server and restart xinetd to allow PBA-E to accept API requests on public IP after migration.
Check and fix IP address of API endpoint used in script.