ACCESS 3CX BUILT-IN DATABASE

[MARK AH]

Hi,
i am setting up a connection between SPLUNK and 3CX... during the setup, i have been asked to access the 3CX built-in Database. does anyone knows what is the link for this database?
- server,
- port,
- database type
thank you!

 

[Saqqara]

Accessing the 3CX databases is not supported by 3CX, and you will not get any details on how to connect, type , etc

 

[MARK AH]

hi, thank you for the reply i know it is not supported, but it is highly needed.
if you have any info kindly let me know!
thanks!

 

[VoIPTools]

I freely admit that this will sound self-serving. I suppose it is. However, "not supported" really means "Don't do it". You can have your 3CX flagged by 3CX support as unsupported if you get caught doing it. This has been mentioned both by 3CX and others in the community 1000. It is way too easy to inadvertently lock a record or even an entire table when connecting directly to PostgreSQL, not to mention the impact on 3CX performance. It does not take much imagination to consider what impacts accessing the database directly could have on a running 3CX server.

If you want a supported way of getting call detail information, you can configure 3CX to create CDR files for each call. Depending on what data you need, this may be sufficient and keep you out of trouble. To generate the CDR files, navigate within the 3CX Console to Settings -->CDR. My preference is to create a separate file for each call. This makes it easy to parse each call as they happen.

OK, here is the self-serving part of my post...

You may want to take a look at our VoIPTools REST API and our 3CX Exporter tool. Our API provides access to the 3CX data, and our Exporter tool synchronizes the data automatically to either SQL or MySQL. Exporter also automates the parsing of 3CX CDR files that 3CX can optionally create in real-time.

 

[MARK AH]

thank you for the clarification, i am not willing to modify the database. i am just installing SPLUNK and this software has a statistics app for 3CX related to Queues. during the installation i have been asked to access the 3cx Postgres database. anyway the team has managed to solve the issue and i think they have successfully connected. i will check tomorrow what is the procedure.
will keep you updated.

 

[VoIPTools]

Trust me, accessing the database directly will be severely frowned upon by 3CX Support. It doesn't matter if you are not making changes, it will still impact 3CX performance at the least, and may have unintended impacts at the worst. But you know the concern now. It is up to you to decide what you do with the warning.

Another concern you should be aware of... the PostgreSQL database only permits connections from localhost. That means for your external application to connect remotely, your team had to alter the configuration file for PostgreSQL. Friend, you are already in deep water. True it is a minor configuration change, but I asked 3CX if this change was permissible and they made it very clear we were not allowed to make this, or any other changes to the PostgreSQL configuration.

I will also point out that 3CX now knows who is making these changes.... so....