• V20: 3CX Re-engineered. Get V20 for increased security, better call management, a new admin console and Windows softphone. Learn More.

Accessing PostgreSQL

Status
Not open for further replies.

Yiannos Ioannou

Gold Partner
Advanced Certified
Joined
Nov 13, 2017
Messages
28
Reaction score
4
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
 
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.
 
Dear Yiannos,

please use Username = logsreader_single

Good luck ;-)

Stefan
 
Status
Not open for further replies.
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.