Master DNL Class4
  • Introduction
  • Configure a new Class 4 instance
    • Setup Admin Access
    • First Time Login
    • Setup SIP Switch
  • Your First Call with Class 4 Fusion
    • Create Vendor Rate Table
    • Create Termination Vendor
    • Create Egress Trunk
    • Create Dynamic Route
    • Create Routing Plan
    • Create Client Rate Table
    • Create Termination Client
    • Create Ingress Trunk
    • Simulate Your Call
  • Support Contact
  • eLearning
  • Bug Reporting Process
  • Hardware Sizing
  • Licensing
  • Installation
    • Install with Tarball
    • Install with RPM
      • Step by Step Guide
    • Install with AWS
    • Install with Google Cloud
    • Distributed Architecture
      • Switch Server
        • dnl_live_monitor
        • dnl_tool
        • dnl_livecall
        • dnl_softswitch
        • dnl_watchdog
        • dnl_cloud
      • Web UI
        • dnl_web_helper
    • Troubleshoot Your Installation
    • Setup SSL on Web UI
    • LAN IP Setup for Virtual Machine
    • Change IP/MAC Address
    • Validate Your Installation
      • Check dnl_softswitch log
    • Configuring DNL softswitch
    • Setup Selinux
  • Configuring Stir/Shaken
    • Generating Certificate with Peeringhub.io
  • Upgrade an Existing Installation
    • Update an Existing Installation
      • Update with Tarball
      • Update with RPM
  • Stir Shaken
    • Introduction
    • Configure Class 4
    • Configure Stir Shaken in DB
    • Configure Ingress Trunk
    • Configuring Egress Trunk
    • Basic Configuration Example
    • Validation of Stir/Shaken Setup
    • Setup External AS/VS connectivity
  • Basic Switch Configuration
    • Integrate Class 4 to Google SMTP
    • Customize your logo
    • Customize Domain Name
    • Customize email template
    • Customize invoice template
    • Configuring Payment Gateway
      • Stripe Configuration
      • Paypal Configuration
    • Configuring CDR and PCAP Backup
      • Google Cloud Setup
    • Configuring SIP Registration
    • Configuring LRN
  • Quick Setup for Termination Traffic
    • Create Termination Vendor
      • Specify IP to send to egress
    • Create Termination Route
      • Routing Plan
      • Static Route
      • Dynamic Route
    • Create Termination Client
    • Test with Call Simuation
    • Test Calls with SIP Client
    • Check CDR
  • Quick Setup for Origination Traffic
    • Introduction
    • Create DID Vendors
    • Create DID Billing Plan
    • Create DID Clients
    • DID Repository
    • Assign DID to Client
    • Test Calls with Call Simulation
    • Setup for your client to buy DIDs from portal
  • Data Access
    • Postgres Database
      • Obtain Report Data from DB
      • Obtain CDR from DB
    • Raw Switch Data
      • CDR Data
        • Release Cause Definition
      • PCAP Data
      • Auto Data Cleanup
  • System Administration
    • Modules
    • Start and Stop
    • Logging
    • Software Updates
    • Setup additional dnl_softswitch
    • Add Additional IP to Switch
    • Configure SIP Cause Code and Q850 Mapping
    • Enable Media Proxy
  • Class 4 API
    • Authorization
    • Class4 API
  • Troubleshooting
    • Calls are failure
    • Change Q850 in 4xx/5xx
    • One-way Audio with SIP Client Testing
      • Using Zoiper to resolve NAT issue
  • Automatic Call Blocking
    • Introduction
    • Youmail Blocking
    • DNC Blocking
    • LERG Blocking
Powered by GitBook
On this page

Was this helpful?

  1. Data Access

Postgres Database

You can access to DB via the following command:

[root@ns505185 ~]# psql -U postgres
psql (12.5)
Type "help" for help.

postgres=# \l
                                  List of databases
    Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
------------+----------+----------+-------------+-------------+-----------------------
 class4_dnl | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
            |          |          |             |             | postgres=CTc/postgres
 template1  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
            |          |          |             |             | postgres=CTc/postgres
(4 rows)

postgres=# \c class4_dnl ;
You are now connected to database "class4_dnl" as user "postgres".
class4_dnl=# 

You can get the list of tables with the following commands:

class4_dnl=# \d+;
                                                                                          List of relations
 Schema |                       Name                       |   Type   |    Owner    |    Size    |                                            Description                                            
--------+--------------------------------------------------+----------+-------------+------------+---------------------------------------------------------------------------------------------------
 public | agent                                            | table    | postgres    | 0 bytes    | 
 public | agent_agent_id_seq                               | sequence | postgres    | 8192 bytes | 
 public | agent_client_client                              | table    | postgres    | 0 bytes    | 
 public | agent_client_client_id_seq                       | sequence | postgres    | 8192 bytes | 
 public | agent_client_client_record                       | table    | postgres    | 8192 bytes | 
 public | agent_client_client_record_record_id_seq         | sequence | postgres    | 8192 bytes | 
 public | agent_clients                                    | table    | postgres    | 0 bytes    | 
 public | agent_clients_id_seq                             | sequence | postgres    | 8192 bytes | 
 public | agent_commission_history                         | table    | postgres    | 8192 bytes | 
 public | agent_commission_history_detail                  | table    | postgres    | 8192 bytes | 
 public | agent_commission_history_detail_id_seq           | sequence | postgres    | 8192 bytes | 
 public | agent_commission_history_history_id_seq          | sequence | postgres    | 8192 bytes | 
 public | agent_commission_payment                         | table    | postgres    | 8192 bytes | 
 public | agent_commission_payment_id_seq                  | sequence | postgres    | 8192 bytes | 
 public | alembic_version                                  | table    | postgres    | 8192 bytes | 
 public | alert_rules                                      | table    | postgres    | 8192 bytes | 
 public | alert_rules_id_seq                               | sequence | postgres    | 8192 bytes | 
 public | alert_rules_log                                  | table    | postgres    | 8192 bytes | 
 public | alert_rules_log_detail                           | table    | postgres    | 8192 bytes | 
 public | alert_rules_log_detail_id_seq                    | sequence | postgres    | 8192 bytes | 
 public | alert_rules_log_id_seq                           | sequence | postgres    | 8192 bytes | 
 public | allowed_sendto_ip                                | table    | postgres    | 0 bytes    | 
 public | allowed_sendto_ip_id_seq                         | sequence | postgres    | 8192 bytes | 
 public | allowed_sendto_ip_record                         | table    | postgres    | 8192 bytes | 
 public | allowed_sendto_ip_record_record_id_seq           | sequence | postgres    | 8192 bytes | 
 public | async_ftp_export                                 | table    | postgres    | 8192 bytes | 
PreviousSetup for your client to buy DIDs from portalNextObtain Report Data from DB

Last updated 4 years ago

Was this helpful?