Passive CDR telnet connection failing

[Gurei123]

Hi all.
I have 3cx on google cloud and enabled for CDR passive socket server mode. I have used port 5015. Just before the port setting, I see a system generated number like 10.148.0.8 (not the actual number). The public IP for 3cx is a.b.c.d.
Do I telnet to a.b.c.d port 5015 or 10.148.0.8 port 5015? Both options return telnet connection failed.
Please advise.
Thank you.

 

[cobaltit]

I wouldn't use port 5015 as that may inherently be an issue as 5015 is the web setup port. As far as which IP to use, it depends on where your accessing the CDRs from.

 

[Gurei123]

Thank you for the response. I had tried several ports and ended up with 5015 following advice from another post. I have now used more ports and still fail to connect via telnet. What am I missing?
Please assist further.

 

[VasilisV_3CX]

Hi @Gurei123,

Have you ensured the port you're using, is open on the firewall for TCP traffic?

 

[Gurei123]

Got it connecting after allowing port on the firewall

 

[VasilisV_3CX]

Great to hear you got this working @Gurei123.

 

[VoIPTools]

If I were going to guess, the approach of making an IP socket connection was originally implemented by 3CX to facilitate communicating with hotel systems. You have not specified why you need the CDR data, but I personally see a huge hole in this approach. What happens if your socket connection goes down even briefly? The answer is the data is lost. Maybe that is not a big deal, but I suspect it is a very big deal. So, what are the alternatives when 3CX is hosted (implied by you referencing "public IP" addresses)?

I would configure 3CX to create CDR text files and process the text files. That way, if you have a internet failure, you don't lose the information... you simply pick up where you left off when the connection is restored. That begs the question "how do I process CDR files on a hosted 3CX server?" I assume there are client applications (maybe winscp or FileZilla) that can automate coping files?

Alternatively, you could take a look at our 3CX Exporter tool that can process the CDR files automatically and insert the data directly into a SQL / MySQL database. This approach will ensure you never lose any data.