Skip to main content

Q & A

CDR Reports 沒有任何紀錄

檢查 MySQL 資料表

# MySQL Credentials

cat /etc/freepbx.conf



# Check the mysql

mysql -u freepbxuser -p asteriskcdrdb -e 'SELECT * FROM cdr ORDER BY calldate DESC LIMIT 4'

檢查 asterisk module

asterisk -rx "module show like odbc"



Module                         Description                              Use Count  Status      Support Level

cdr_adaptive_odbc.so           Adaptive ODBC CDR backend                0          Running              core

cdr_odbc.so                    ODBC CDR Backend                         0          Running          extended

cel_odbc.so                    ODBC CEL backend                         0          Running              core

func_odbc.so                   ODBC lookups                             0          Running              core

res_config_odbc.so             Realtime ODBC configuration              0          Running              core

res_odbc.so                    ODBC resource                            6          Running              core

res_odbc_transaction.so        ODBC transaction resource                1          Running              core

重啟服務出現以下錯誤

fwconsole stop

fwconsole start

[2022-06-03 10:38:42] WARNING[32144] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can't open lib '/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so' : file not f

Solution:

#> locate libmaodbc.so

/usr/lib/i386-linux-gnu/odbc/libmaodbc.so



#> cp /etc/odbcinst.ini /etc/odbcinst.ini.orig

#> vi /etc/odbcinst.ini



# Change this line

Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so

重啟服務確認錯誤不再發生

fwconsole stop

fwconsole start
Can't send 10 type frames with SIP write

Frame type '10' is comfort noise (aka CNG) which Asterisk does not support.

However as of 13.18.0 this message will be silenced so you won’t see it anymore.

You can ignore it or disable CNG on all of your endpoints and ask the telecom providers as well to disable the CNG on your trunks.

FXO 不會正確地傳送 Answer 至 IP 端


當透過 Gateway 撥打外線時 (IP to PSTN)，不管 PSTN 端是否接起電話，Gateway 總是傳送 Answer 至 IP 端。這個對於一般電話操作不會有影響，不過，若是要對通話進行計費時，就會造成很大問題。

原因及解法如下：

 

 

 

 

 


Back to top