[asterisk-bugs] [JIRA] (ASTERISK-23177) RealTime cant update sipbuddies table when registering or updating friend

[Denis (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-23177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=214338#comment-214338 ] 

Denis edited comment on ASTERISK-23177 at 1/23/14 9:41 AM:
-----------------------------------------------------------

I've attached conf files and db schema. There are no debug logs, because this error occurs right after Aterisk start when registering user or peer and goes on all the time, i can make calls and recieve calls but table t_sippeus is not updated after registering user or peer. This error also where discussed with no success on http://forums.asterisk.org/viewtopic.php?f=1&t=87972. As answered david55 "It looks like the user agent string from the peer contains an SQL string delimiter, which is not being escaped properly when the query is being constructed". Application MYSQL works fine. In Asterisk 11 with the same configs and db schema this error does not occur.
                
      was (Author: den159):
    I've attached conf files and db schema. There are no debug logs, because this error occurs right after Aterisk start when registering user or peer and goes on all the time, i can make calls and recieve calls but table t_sippeus is not updated after registering user or peer. This error also where discussed with no success on http://forums.asterisk.org/viewtopic.php?f=1&t=87972. In Asterisk 11 with the same configs and db schema this error does not occur.
                  
> RealTime cant update sipbuddies table when registering or updating friend 
> --------------------------------------------------------------------------
>
>                 Key: ASTERISK-23177
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23177
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/res_config_mysql, PBX/pbx_realtime
>    Affects Versions: 12.0.0
>         Environment: Centos 6.5 on Oracle VirtualBox
>            Reporter: Denis
>            Assignee: Denis
>         Attachments: files.zip
>
>
> {noformat}
> Connected to Asterisk 12.0.0 currently running on localhost (pid = 6257)
>   == Manager 'manager' logged on from 192.168.1.25
>     -- Registered SIP '101' at 192.168.1.25:5065
>        > Saved useragent "PJSUA v2.1 win32-5.1/i386/msvc-15.0" for peer 101
> [Jan 22 09:26:16] WARNING[6284]: res_config_mysql.c:631 update_mysql: MySQL RealTime: Failed to update database: Unknown column 'sip:101 at 192.168.1.25:5065;ob' in 'field list'
> {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira