[asterisk-users] SQlite3 realtime

Carlos Chavez cursor at telecomabmex.com
Tue Apr 29 13:16:18 CDT 2014


     I just finished migrating our web interface from Mysql to SQlite3 
and everything seems to be working fine.  I just have one detail.  The 
following keeps appearing on my logs:

[Apr 29 13:09:32] WARNING[30494]: res_config_sqlite3.c:520 
realtime_sqlite3_execute_handle: Could not execute 'UPDATE "sip_buddies" 
SET "ipaddr" = '192.168.0.52', "port" = '5060', "regseconds" = 
'1398795032', "defaultuser" = '112', "useragent" = 'Zoiper r21999', 
"lastms WHERE "name" = '112'': near "112": syntax error5060;rinst
[Apr 29 13:10:26] WARNING[30494]: res_config_sqlite3.c:520 
realtime_sqlite3_execute_handle: Could not execute 'UPDATE "sip_buddies" 
SET "ipaddr" = '192.168.0.52', "port" = '5060', "regseconds" = 
'1398795086', "defaultuser" = '112', "useragent" = 'Zoiper r21999', 
"lastms WHERE "name" = '112'': near "112": syntax error5060;rinst

     I guess these are the realtime updates when an extension registers 
with Asterisk.  I really do not know why it is trying to update the 
"defaultuser" field but the problem seems to be that the SQL code for 
updating the table is has a syntax error.  So far everything is working, 
just keep getting this messages on the log file.  Should I report this 
as a bug?

     We are using Asterisk 11.7.0 on CentOS 6

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161




More information about the asterisk-users mailing list