[asterisk-bugs] [JIRA] (ASTERISK-23177) 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=214342#comment-214342 ] 

Michael L. Young edited comment on ASTERISK-23177 at 1/23/14 12:31 PM:
-----------------------------------------------------------------------

First thing that caught my eye is that your database table for t_sippeus has not been updated to the latest schema for sippeers.  Therefore, some of those columns are not big enough to hold the data that might be saved to it.  You will possibly get truncated data.

Second thing is that if you could enable debugging "core set debug 5", we could see the query that is trying to be run... at least see what exactly is being sent to the MySQL database.  That would help narrow this down very quickly.  I am looking at the code and have an idea but that debug would help to confirm it.
                
      was (Author: elguero):
    First thing that caught my eye is that your database table for t_sippeus has not been updated to the latest schema for sip_peers.  Therefore, some of those columns are not big enough to hold the data that might be saved to it.  You will possibly get truncated data.

Second thing is that if you could enable debugging "core set debug 5", we could see the query that is trying to be run... at least see what exactly is being sent to the MySQL database.  That would help narrow this down very quickly.  I am looking at the code and have an idea but that debug would help to confirm it.
                  
> 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