postgresql

  1. 3CX Data Connectors - System Metrics

    Good day, Apologies if this is posted in the incorrect section. The new documentation and data connectors page on the admin console mention that system metrics can be exported to an external database. I have configured a data connection to a postgresql database and only see the following...

  2. 3CX Hosted + Call Scripts + Database connection

    Hi, i have 3CX hosted Version 20.0 Update 6 (Build 708) ENTERPRISE 8SC Call flow designer 20.2.84.0 I modified the survey demo project with my database credentials (PostgreSQL) and built the app without compile errors. I uploaded the zip file from integrations >> call scripts. I am able to...

  3. Call Journaling - CRM Integration ( Database Postgresql )

    Hello, I am trying to log all the calls into a dedicated postgresql database for monitoring purposes. My dedicated PostgresQL database is empty and contains 2 tables (calls, contacts). From Settings -> Integrations -> CRM ( following this guide...
    • pierremueller
    • Thread
    • call journaling crm integration crm postgresql
    • Replies: 14
    • Forum: Other

  4. CDR / Power BI / MYSQL or PostgreSQL

    Hi all, Needing some help here. Im looking to build dashboards for my clients using Power BI and need the CDR sent to my SQL server as the first step. I’ve tried setting this up via CDR and sending to my database but whatever i do, I can’t get the active connection working. Environment setup...
    • Nikala
    • Thread
    • cdr cdr logs mysql postgresql sql v18
    • Replies: 1
    • Forum: Other
  5. g.fiszt

    Unsupported Database issue after upgrade to V18

    Hello everyone! I've made the upgrade from V16 to V18 and it's completed smoothly. We have a slave PostgreSQL database that we make queries and the results are displayed in some custom dashboards that we created on Google DataStudio. After upgrading to V18, the databases were out of sync, then...

  6. 3CX integrated with database

    Hello everyone 1. I see 3CX can be integrated with PostgreSQL database, But I would like to ask how to add contactid when Contact Creation In the article, I only saw this paragraph of SQL Statement, but did not see how to add contactid "INSERT INTO contacts (first_name, last_name, phone)...
    • Alex.Hu
    • Thread
    • database postgresql
    • Replies: 2
    • Forum: Other

  7. Searching for table with option "Do not show extension in 3CX company phonebook"

    Hi all, we are running own bash scripts for creating all our phonebooks for different models and ran into a small problem. Our scripts do not check for the option “Do not show extension in 3CX company phonebook” and so all numbers are in the phonebooks, no matter if this option is activated. I...

  8. PostgreSQL Errors - 3CXv16

    We recently upgraded our 3cx instance from v15 to v16 recently. Unknown to me, our DBAs had PostgreSQL process running that would extract call history and other data for historical purposes. Since the upgrade to v16 it had broke this process due to a parameter change, in the config files...

  9. Solved Lost admin password

    We have a site we are taking over that looks to be running 15.6 that currently does not have a valid backup. They do not have a working admin password and we are trying to avoid rebuilding the PBX from scratch. The password reset via failed login is also not working and we are not sure why. We...

  10. Automating Outbound Rules

    Hi I want to change automatiquely Outbound Rules. I know how to make the changes in the postgres database. However, the changes are not taken into account until I restart 3CX. Is there a cleaner solution that does not require a 3CX reboot? Is there an API or something else to do this...
    • BIRD
    • Thread
    • api outbound rules postgresql
    • Replies: 1
    • Forum: Other

  11. ¿Cómo consultar información de una BD PostgreSQL?

    Buen día, estoy creando una aplicación CFD para que marque a unos números que están registrados en una base de datos PostgreSQL versión 10.5. El servidor de BD lo tengo instalado fuera de la central. Sin embargo, no logro conectarme a la misma. ¿Cuáles pueden ser los posibles problemas? Los...

  12. Postrgesql error?

    We had an unexpected reboot on our 3CX server and I'm now receiving the following: "ERROR: invalid page header in block 8 of relation base/16451/127448 STATEMENT: truncate table eventlog" The phones are working, but the Windows event log is filling up with this (about 10 per second). How do I...
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom