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

[Michael L. Young (JIRA)]

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

Michael L. Young commented on ASTERISK-23177:
---------------------------------------------

How are you installing Asterisk?

You would need to have the source code for Asterisk 12. From within the Asterisk source directory run:
{noformat}"wget -O - https://issues.asterisk.org/jira/secure/attachment/49168/asterisk-23177-use-field-name.diff | patch -p0"{noformat}

Then compile and install.
                
> [patch] 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
>    Affects Versions: 12.0.0
>         Environment: Centos 6.5 on Oracle VirtualBox
>            Reporter: Denis
>            Assignee: Denis
>         Attachments: asterisk-23177-use-field-name.diff, debug_log, files2.zip, 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