Accessing PostgreSQL

Discussion in '3CX Phone System - General' started by Yiannos Ioannou, Jan 18, 2018.

Thread Status:
Not open for further replies.
  1. Yiannos Ioannou

    Joined:
    Nov 13, 2017
    Messages:
    20
    Likes Received:
    2
    Dear all ,

    We trying to access postgres SQL using the 3CXPhoneystem.ini detail with pgAdminIII

    using the folowing

    [CallReports]
    USERNAME = logsreader
    DRIVER = PostgreSQL Unicode
    PASSWORD = logsreader
    DATABASE = phonesystem
    PORT = 5480
    SERVER = localhost
    ReadOnly = 1

    but we get a error . Also with using phonesystem as database we get authentication error with user logreader

    upload_2018-1-18_11-13-53.png
     
  2. YiannisH_3CX

    YiannisH_3CX Support Team
    Staff Member 3CX Support

    Joined:
    May 10, 2016
    Messages:
    4,443
    Likes Received:
    282
    Hello @Yiannos Ioannou

    Please note that accessing the database in not recommended and no support will be given in case you have an issue in the future. The phone system is a live system and the smallest change can break the normal functionality. That being said nobody can stop you from doing so, so proceed at your own risk.
     
  3. Stefan Löwe

    Joined:
    Dec 30, 2017
    Messages:
    17
    Likes Received:
    5
    Dear Yiannos,

    please use Username = logsreader_single

    Good luck ;-)

    Stefan
     
Thread Status:
Not open for further replies.