[Home]

Summary:ASTERISK-15948: [patch] sip-friends.sql Missing 'useragent'
Reporter:Harley Alaniz (thehar)Labels:
Date Opened:2010-04-12 15:02:05Date Closed:2010-04-20 13:02:02
Priority:MinorRegression?No
Status:Closed/CompleteComponents:Documentation
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:( 0) sip-friends.patch
Description:Imported ./contrib/scripts/sip-friends.sql to mysql.  Initial asterisk load reports:

[Apr 12 13:17:07] WARNING[24988]: res_config_odbc.c:1032 require_odbc: Realtime table sipfriends@asterisk requires column 'useragent', but that column does not exist!
Comments:By: Paul Belanger (pabelanger) 2010-04-12 15:23:35

Are you able to write a patch?
By: Harley Alaniz (thehar) 2010-04-12 15:36:18

Done.
By: Paul Belanger (pabelanger) 2010-04-12 15:45:54

Thanks for the patch.  In the future, if you could generate your patch from the base of your asterisk directory, rather from a sub-directory inside asterisk. :)
By: Leif Madsen (lmadsen) 2010-04-13 13:06:35

What versions does this apply to? 1.6.2 and greater only? Or does this apply to some of the other 1.6.x branches?
By: Digium Subversion (svnbot) 2010-04-20 13:01:29

Repository: asterisk
Revision: 258106

U   trunk/contrib/scripts/sip-friends.sql

------------------------------------------------------------------------
r258106 | lmadsen | 2010-04-20 13:01:28 -0500 (Tue, 20 Apr 2010) | 7 lines

Add missing 'useragent' field to sip-friends.sql file.

(closes issue ASTERISK-15948)
Reported by: thehar
Patches:
     sip-friends.patch uploaded by thehar (license 831)
Tested by: pabelanger, thehar
------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=258106
By: Digium Subversion (svnbot) 2010-04-20 13:02:02

Repository: asterisk
Revision: 258107

_U  branches/1.6.2/
U   branches/1.6.2/contrib/scripts/sip-friends.sql

------------------------------------------------------------------------
r258107 | lmadsen | 2010-04-20 13:02:01 -0500 (Tue, 20 Apr 2010) | 15 lines

Merged revisions 258106 via svnmerge from
https://origsvn.digium.com/svn/asterisk/trunk

........
 r258106 | lmadsen | 2010-04-20 13:01:28 -0500 (Tue, 20 Apr 2010) | 7 lines
 
 Add missing 'useragent' field to sip-friends.sql file.
 
 (closes issue ASTERISK-15948)
 Reported by: thehar
 Patches:
       sip-friends.patch uploaded by thehar (license 831)
 Tested by: pabelanger, thehar
........

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=258107