Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] SQlite3 realtime


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
cursor at telecomabmex...
Guest





PostPosted: Tue Apr 29, 2014 1:16 pm    Post subject: [asterisk-users] SQlite3 realtime Reply with quote

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


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services