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

Postgres Read only Access in v14

Status
Not open for further replies.

Bankstone

Joined
Dec 19, 2015
Messages
10
Reaction score
0
Has anyone any pointers for read only access to postgreSQL used by 3CX
The only thing I can think of is something that I noticed a while back
it is a 64bit driver however it seems to be a 32bit database connection
and there seems to be some conflict


Firstly I would like to say I have been using 3CX in different versions for many years,
I have found, every version, to be very robust, reliable and flexible, even under load,
I cant praise the product enough, rating it up there with the likes of VMware ESX, which is high praise indeed.
It has been worth the cost, and the initial very steep learning curve.
With version 14 I like the WebRTC option, which we are to be using on the website very soon.
and the Pro version has some nice features with the call centre editions.

The only problem I have had with it is the access to the call data outside the call reports,
which to be honest the reports are the only thing in my opinion that let it down.

I am trying to access Postgres in read only mode in version 14, I only want to read the call data,
and export it into MySQL or MS SQL so I can manipulate it and further automate it
and deliver bespoke web reports to customers.
You could do this in v9, v10 and v11 (didn't try v12), but I cant seem to make the
same DSN connection as previous but I either get invalid password or no server response.
I am using the info from the ini file as usual (See below),
Correct driver installed in System DSN : PostgreSQL Unicode (x64)

[CallReports]
USERNAME=logsreader
DRIVER=PostgreSQL Unicode
PASSWORD=logsreader
DATABASE=phonesystem
PORT=5480
SERVER=localhost
ReadOnly=1
[MIME_TYPES]
MESSAGE=x-chat/control

[DbAdminREADONLY]
User=phonesystem
Password=***************
[instance1]
pbxSLNIC=127.0.0.1
cmPort=5482
pbxuser=instance_instance184475
pbxpass=**************


If anyone can shed some light on to this I would be grateful

Other than that the product is excellent, near perfect,

It would be nice if the following were added / amended
1. WAV converts to MP3 (I have written a routine using lame that converts it for me, so not important)
2. Option to use either MySQL or MS SQL rather than Postgres would be excellent
I don't mind paying extra for the MS SQL licenses or MySQL Enterprise.
3. Export of CSV / Excel Reports is one long list and doesn't break up into various sheets
As I am having to remove all the gaps on 300 + pages manually each month.

Many Thanks, Appreciated.
 
Updated, would appreciate some pointers

Many Thanks in advance
 
Hello.
The same problem here. Cannot connect to DB with logsreader due authentication error.
 
Solved:

You should open file : C:\Program Files\3CX Phone System\Instance1\Bin\3CXPhoneSystem.ini

You`ll see kind of this text :
[QMDatabase]
DBHost=127.0.0.1
DBPort=5480
DBName=database_single
dbUser=logsreader_single
dbPassword=123kjasdlkj3l


Database name and login changed after upgrade.

Please check and let me know.
 
Waqeef,

That is excellent work, well found, I had been looking for ages
Many Thanks, saved me time.

However after logging in via PQAdmin I found the schema
has changed significantly, I am trying to select the
correct joins for the various tables that seem to be used now.
 
Status
Not open for further replies.

Getting Started - Admin

Latest Posts

Forum statistics

Threads
141,627
Messages
748,922
Members
144,741
Latest member
Boykins_54
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.