I am a fairly novice Asterisk 1.4 user who used to use CallWeaver, based on asterisk 1.2. I used Realtime MySQL with CallWeaver and am currently using the very same MYSQL tables (and columns) with Asterisk 1.4.11 and things are working well. The questions I have are, since new configuration variables have been added into Asterisk 1.4, can I simply add columns in my MySQL sippeers table for things such as "videosupport" "mohinterpret", etc.? When a user upgrades, how would one know if all of the possible user/peer/friend variables listed in sip.conf can in fact be pulled from Realtime? I have consulted http://www.voip-info.org/wiki-Asterisk+RealTime+Sip but that table seems to be out of date. For example, "musiconhold" isn't even listed in my 1.4.11 sip.conf as an option for a user or a peer, and "videosupport" isn't listed at www.voip-info.org. Do the order of the columns matter, etc.? Where do I go to find the latest Realtime table information for a specific Asterisk version? (The same questions apply to IAX Realtime.) Thank you in advance for your help. -- Anthony - http://messinet.com - http://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part. Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20070921/f0c3d569/attachment.pgp
On Friday 21 September 2007 22:07:42 Anthony Messina wrote:> The questions I have are, since new configuration variables have been added > into Asterisk 1.4, can I simply add columns in my MySQL sippeers table for > things such as "videosupport" "mohinterpret", etc.?Yes.> When a user upgrades, how would one know if all of the possible > user/peer/friend variables listed in sip.conf can in fact be pulled from > Realtime?Dynamic realtime is designed to be extensible in that way, so yes, all of the available parameters in sip.conf can be used with realtime simply by adding a column to the table. Note that if set to NULL, the parameter is considered not present, and will be treated the same as if the entry was in sip.conf without that parameter (meaning whatever default takes control).> Do the order of the columns matter, etc.?In most cases, no. However, you should place the disallow column prior to the allow column, as columns are parsed in the order in which they appear in the table. Hence, disallow=all, then allow=ulaw, allow=gsm, etc.> Where do I go to find the latest Realtime table information for a specific > Asterisk version? (The same questions apply to IAX Realtime.)Consult the corresponding .sample file in the configs/ subdirectory. -- Tilghman
On Friday 21 September 2007 10:36:37 pm Tilghman Lesher wrote:> On Friday 21 September 2007 22:07:42 Anthony Messina wrote: > > The questions I have are, since new configuration variables have been > > added into Asterisk 1.4, can I simply add columns in my MySQL sippeers > > table for things such as "videosupport" "mohinterpret", etc.? > > Yes. > > > When a user upgrades, how would one know if all of the possible > > user/peer/friend variables listed in sip.conf can in fact be pulled from > > Realtime? > > Dynamic realtime is designed to be extensible in that way, so yes, all of > the available parameters in sip.conf can be used with realtime simply by > adding a column to the table. Note that if set to NULL, the parameter is > considered not present, and will be treated the same as if the entry was in > sip.conf without that parameter (meaning whatever default takes control). > > > Do the order of the columns matter, etc.? > > In most cases, no. However, you should place the disallow column prior > to the allow column, as columns are parsed in the order in which they > appear in the table. Hence, disallow=all, then allow=ulaw, allow=gsm, etc. > > > Where do I go to find the latest Realtime table information for a > > specific Asterisk version? (The same questions apply to IAX Realtime.) > > Consult the corresponding .sample file in the configs/ subdirectory.thank you VERY much! that was helpful info to have prior to screwing with my db! have a good night. -a -- Anthony - http://messinet.com - http://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part. Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20070921/b47a0575/attachment.pgp