Hey thanks the issue was that the columns where not in the missed calls
table.
Best Regards,
Ethan Brooks
On Fri, Apr 10, 2015 at 2:53 AM, Daniel-Constantin Mierla <mico...@gmail.com
> wrote:
> 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
> listsr-us...@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda -
> http://www.linkedin.com/in/miconda
> Kamailio World Conference, May 27-29, 2015
> Berlin, Germany - http://www.kamailioworld.com
>
>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
