Hello,
hmm, quite interesting, if works for everything but 5xx. Does it happen
for each 5xx, or just from time to time?
Can you enable query log in mysql and see what query is sent to the server?
Also, in case you record missed calls, be sure you have the columns in
missed_calls table.
Cheers,
Daniel
On 10/04/15 02:05, Ethan Brooks wrote:
I am seeing a very strange error saying that time_attr
is an unknown
column and the insert is failing. What is strange is that it is in the
acc table and is being populated for all successful calls. It seem to
only happen for 5xx unsuccessful calls and the INVITE is not recorded.
4xx response are recorded.
*config*
modparam("acc", "time_mode", 1);
modparam("acc", "failed_transaction_flag", 3)
*syslog*
Apr 9 20:40:52 a-deploy-callprocessing3 /usr/sbin/kamailio[9732]:
ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver
error on query: Unknown column 'time_attr' in 'field list'
Apr 9 20:40:52 a-deploy-callprocessing3 /usr/sbin/kamailio[9732]:
ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while
submitting query
Apr 9 20:40:52 a-deploy-callprocessing3 /usr/sbin/kamailio[9732]:
ERROR: acc [acc.c:504]: acc_db_request(): failed to insert into database
*Database Fields:*
`time_attr` int(11) DEFAULT NULL,
`time_exten` int(11) DEFAULT NULL,
*kamailio -v*
version: kamailio 4.2.3 (x86_64/linux)
flags: STATS: Off, USE_TCP, USE_TLS, TLS_HOOKS, USE_RAW_SOCKS,
DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC,
F_MALLOC, DBG_F_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT,
USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST,
HAVE_RESOLV_RES
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: unknown
compiled on 12:08:27 Feb 16 2015 with gcc 4.9.1
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users