[Home]

Summary:ASTERISK-01466: [patch] New retrieve_extensions_from_sql.pl
Reporter:nix (nix)Labels:
Date Opened:2004-04-25 10:32:38Date Closed:2008-01-15 14:52:18.000-0600
Priority:MajorRegression?No
Status:Closed/CompleteComponents:Core/General
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:( 0) retrieve_extensions_from_sql.pl
Description:Here is a new perl app for the asterisk contrib/scripts directory. I was going to clean up retrieve_extensions_from_mysql.pl but I decided to rewrite it completely. I have taken care to make retrieve_extensions_from_sql.pl portable across (at least) Postgresql, Oracle and Mysql, but it should work with MSSQL and any other reasonably ANSI compliant SQL server. This will work with the same DB schema as retrieve_extensions_from_mysql.pl so you should be able to seemlessly upgrade to it, but for cleaner visual output of extensions.conf you should use the new schema which uses VARCHARs instead of CHARS. (Therefore no ugly space padding)
Comments:By: Olle Johansson (oej) 2004-04-25 12:01:48

Make sure you remember to send your disclaimer to Digium and confirm it here. http://bugs.digium.com for more information. /O

By: Brian West (bkw918) 2004-04-25 15:52:26

is this a total rewrite or a mod to the orginal one?  If a mod can you attach a diff -u please :P

bkw

By: nix (nix) 2004-04-25 16:41:06

bkw: If you have a look at the file, you will see that it has about 6 lines out of 158 in common with retrieve_extensions_from_mysql.pl It also no longer defaults to MySQL and therefore retrieve_extensions_from_sql.pl is a more appropriate name. I suggest that retrieve_extensions_from_mysql.pl eventially be removed from cvs as it is now redundant, however as it has a different file name it can happily be left there if do desired.
oej: Digium has had my disclaimer for approximately 9 months. (I wish people would stop asking for this EVERY time I post a patch!!!)

By: Mark Spencer (markster) 2004-04-28 09:52:01

Added to CVS, we can remove the old one if necessary in the future.

By: Digium Subversion (svnbot) 2008-01-15 14:52:18.000-0600

Repository: asterisk
Revision: 2795

A   trunk/contrib/scripts/retrieve_extensions_from_sql.pl

------------------------------------------------------------------------
r2795 | markster | 2008-01-15 14:52:18 -0600 (Tue, 15 Jan 2008) | 2 lines

Add Peter's SQL complaint script (bug ASTERISK-1466)

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

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