Posts

How to convert all wav files into mp3 extensions in centos/linux at one go? is there any command?

shell script #!/bin/bash SAVEIF=$IFS IFS=$(echo -en "\n\b") for file in $(/usr/bin/find /usr/src/wav-folder/ -type f -name "*.wav") do   name=${file%%.wav}   lame -V0 -h -b 160 --vbr-new $name.wav $name.mp3 done IFS=$SAVEIFS

copy directory on a remote server via SCP

scp -rp source-directory root@IP:/path-of-directory -r means recursive -p preserves modification times, access times, and modes from the original file.

Run MySQL query from Asterisk Dialplan and get values

[MySQL] exten => 1234,1,Answer() exten => 1234,n,NoOp(${CALLERID(num)}) exten => 1234,n,Read(caller,,10) exten => 1234,n,Set(CID=${CALLERID(num)}) exten => 1234,n,NoOp(${caller}) exten => 1234,n,Set(userCID=${caller}) exten => 1234,n,MYSQL(Connect connid YOUR_IP username pwd Database_name) exten => 1234,n,MYSQL(Query resultid ${connid} select * from customer where caller='${userCID}') exten => 1234,n,MYSQL(Fetch fetchid ${resultid} id name) exten => 1234,n,SayAlpha(${name}) exten => 1234,n,Saydigits(${id}) exten => 1234,n,MYSQL(Clear ${resultid}) exten => 1234,n,MYSQL(Disconnect ${connid}) exten => 1234,n,Playback(vm-goodbye) Tested on Asterisk 11.22

Memory leaks in chan_sip.c with realtime peers

  Just comment the below line as I did     31402                 /* Startup regular pokes */   31403                 if (!devstate_only && enablepoke) {   31404                         /*sip_ref_peer(peer, "schedule qualify");*/   31405                         sip_poke_peer(peer, 0);   31406                 }

Increase import limit in vtiger

Under /modules/Import $ImportConfig = array( 'importTypes' => array( 'csv' => array('reader' => 'Import_CSV_Reader', 'classpath' => 'modules/Import/readers/CSVReader.php'), 'vcf' => array('reader' => 'Import_VCard_Reader', 'classpath' => 'modules/Import/readers/VCardReader.php'), 'default' => array('reader' => 'Import_File_Reader', 'classpath' => 'modules/Import/readers/FileReader.php') ), 'userImportTablePrefix' => 'vtiger_import_', // Individual batch limit - Specified number of records will be imported at one shot and the cycle will repeat till all records are imported 'importBatchLimit' => '2500', // Threshold record limit for immediate import. If record count is more than this, then the import is scheduled through cron job 'immediateImportLimi...

pbx.c:4926 pbx_extension_helper: No application 'MeetMe' for extension

Solution: pbx*CLI> module load app_meetme.so

res_config_odbc.c:1250 require_odbc: Realtime table booking@meetme requires column 'members', but that column does not exist!

Solution: The members column is not used by WMM, and you can disable it with a logmembercount=no in meetme.conf