Hello!
I’m using (or at least I try to) Freepbx 17, and want to give a Windows sip client access to asterisks call log. So he can see his calls while the PC was off.
I used the quite short doc of the sip client (in german: Asterisk CDR auslesen ) but with not much luck so far.
I grant permissions to the db, and installed the mariadb odbc connector. Windows didn’t let me use it as file-DSN like the phonesuite doc wanted. But I could get it to connect with System-DSN. Don’t know if that makes a difference.
The ODBC connector can connect to mariadb, and also shows the correct db (asteriskcdrdb).
But if I try to load the data in the phone client, it gets only three older entries from one single extension. But none of the calls that I wanted…
At this point I’m confused and don’t know whether the problem is on the client or server side. Or in front of the keyboard… (SQL is not really my friend)
In the call log of the FreePBX gui I can see all calls (a quite long list), so it seems to be recorded.
“cdr show status” gives:
Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log calls by default: Yes
Log unanswered calls: Yes
Log congestion: Yes
Ignore bridging changes: No
Ignore dial state changes: No
* Registered Backends
-------------------
cdr_manager
Adaptive ODBC
Edit:
“odbc show” says “Logging: Disabled”. Is that my problem?
ODBC DSN Settings
-----------------
Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Number of active connections: 2 (out of 5)
Logging: Disabled