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.

Customized reporting

Discussion in '3CX Phone System - General' started by raj, Nov 30, 2010.

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

    raj

    Joined:
    Nov 30, 2010
    Messages:
    4
    Likes Received:
    0
    Hello,

    How can I connect to 3CX database to be able to extract data for creating my custom reports. I checked the forum and found that version 7 has ways to connect to database using odbc, but no information is available for connecting to version 8 or 9. This document explained how it worked in version 7.

    http://wiki.3cx.com/old-versions/custom-call-reporting

    I tried this approach but PostgreSQL ODBC driver will not accept username: logsreader and not even the admin password that I use for connecting to 3CX phone system. Can someone provide me information about achieving this with version 9. Thanks...
     
  2. mfm

    mfm Active Member

    Joined:
    Mar 4, 2010
    Messages:
    641
    Likes Received:
    2
    Hi.

    The PAssword for the database can be found in the program files/ 3cx phonesystem folder, in a file called phonesystem.ini there you must look for a field called dbpass = SOMETHING . It will be a bunch of hashes and characters. You can use that to access the database.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. raj

    raj

    Joined:
    Nov 30, 2010
    Messages:
    4
    Likes Received:
    0
    Hi Mark,

    Thank you very much. It worked perfectly.

    Regards,

    Raj
     
  4. mfm

    mfm Active Member

    Joined:
    Mar 4, 2010
    Messages:
    641
    Likes Received:
    2
    Hi Raj,

    Your welcome. Best of luck with your setup.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.