Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Calls Log PGSQL access

Discussion in '3CX Phone System - General' started by WANAO, Mar 8, 2018.

Thread Status:
Not open for further replies.
  1. WANAO

    Joined:
    Mar 6, 2018
    Messages:
    12
    Likes Received:
    0
    Dear Community,

    I try to get my calls logs for commercial purpose but email extract, csv or html is to complicated for a no dev
    I tried to connect to PGSQL 3CX database, on 5480, with logsreader username and the same password (like described in C:\Program Files\3CX Phone System\Bin\3CXPhoneSystem.ini)
    But I get the following message : FATAL: password authentication failed for user "logsreader"

    Could you tell me please to get the correct password ?

    Thank you in advance.

    Regards
     
  2. WANAO

    Joined:
    Mar 6, 2018
    Messages:
    12
    Likes Received:
    0
    Ok, I found out 2 min after I posted this thread.
    You have to open this file: C:\Program Files\3CX Phone System\Instance1\Bin\3CXPhoneSystem.ini
    Find QMDatabase section, then use dbuser and password records, its works !
     
  3. mariosM_3CX

    mariosM_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Nov 1, 2017
    Messages:
    406
    Likes Received:
    40
  4. WANAO

    Joined:
    Mar 6, 2018
    Messages:
    12
    Likes Received:
    0
    I didn't know about theses CDR. Thank you!
     
  5. mariosM_3CX

    mariosM_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Nov 1, 2017
    Messages:
    406
    Likes Received:
    40
    No problem, glad to help.
    Let me know if you need any clarification on this
     
  6. voiptoys

    voiptoys Active Member

    Joined:
    Feb 13, 2013
    Messages:
    893
    Likes Received:
    154
    One of the nice things about the CDR files is that the data structure is simple to understand. It doesn't have the same amount of detail that the PostgreSQL tables do, but for many situations it's the easiest choice, and it is the only supported way to get the call detail records.

    If you need help automating the parsing of the CDR files, and putting the data in a SQL or MySQL database, take a look at our "3CX Exporter". We now process CDR files automatically.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.