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.

3CX database?

Discussion in '3CX Phone System - General' started by iperez_genius, Jul 24, 2008.

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

    Joined:
    Jul 1, 2008
    Messages:
    56
    Likes Received:
    0
    Is it possible to access and view the 3cx database?
    if so how...

    where can i find the DB name, username and password?


    Ilan
     
  2. Anonymous

    Anonymous Guest

    http://docs.google.com/View?docid=dqnz5cc_59cb9jn8hp
     
  3. francesco

    francesco New Member

    Joined:
    Jun 23, 2008
    Messages:
    102
    Likes Received:
    0
    you can use pgadmin III
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Henk

    Henk Member

    Joined:
    Nov 13, 2007
    Messages:
    250
    Likes Received:
    0
    5.1 Accessing the 3CX Database
    To access the database from another server than the localhost or the server where the software is installed on you have to make some changes to the PostgreSQL configuration.

    <3CX install dir>\Data\DB\pg_hba.conf

    In the # IPv4 local connections: section

    Type Database User CIDR-address Method
    Host All All 127.0.0.1/32 Password
    Host All All <your IP range like eg 192.168.0.0 >/24 password

    The IPv6 stuff is not supported by 3CX as yet so leave that for the time being.


    <3CX install dir>\Data\DB\ postgresql.conf:

    # - Connection Settings -

    listen_addresses = '*'
    # SDP allowed any IP address to be listened for!
    # was restricted to 'localhost'
    port = 5480
    max_connections = 250

    This can be troublesome.. after any changes stop and start the 3cx Database service and then check your postgresql log for any issues (located at: C:\Program Files\3CX PhoneSystem\Data\DB\pg_log)

    Now on your client PC:
    Download the psqlodbc Win 32 version from here:
    http://www.postgresql.org/ftp/odbc/versions/msi/ (get latest release - from the bottom!) and install it.
    Add an ODBC Connection (Start/Control Panel/Administrative Tools/Data Sources (ODBC), choose at Add under the System DSN TAB and choose the Psqlodbc driver, the details entered should be as follows:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Henk

    Henk Member

    Joined:
    Nov 13, 2007
    Messages:
    250
    Likes Received:
    0
    MS Access? ( walking away head shaking).

    But lets not start a discussion about that ....... :)/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Henk

    Henk Member

    Joined:
    Nov 13, 2007
    Messages:
    250
    Likes Received:
    0
    :),

    I know it works, just kidding with ya.

    Personally I do not like MSAccess to much as a DB but that is just a personal thing.

    H
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Thona

    Joined:
    Aug 10, 2007
    Messages:
    54
    Likes Received:
    0
    The DB is not access....
    ....just the reporting utility, if i unerstood that right.

    A funny choice, but understandable.
     
  8. cyclone76

    Joined:
    Mar 3, 2017
    Messages:
    44
    Likes Received:
    0
    Can i install and use phpmyadmin to see sql database ?
     
Thread Status:
Not open for further replies.