Coding Spider

Problem: When using the Overview: Support Assessment i find the following "error" Check "System Time" vs "Current Timestamp". There is a material difference (443201 seconds) between application server (2323691961) and database server (12323148760) time. Solution: I got my problem solved by simply restart the mysql daemon sevice > service mysqld restart

Solution: Run the below command to check the modules first > /opt/otrs/bin/otrs.CheckModules.pl Then if not installed -> Time::HiRes run the below command > yum install "perl(Time::HiRes)" And if you are updating the  Ticket::StorageModule then you should run the below command too so that all the attcahmemts will switch from DB to FS bin/otrs.ArticleStorageSwitch.pl -s ArticleStorageDB -d ArticleStorageFS

Getting Is the bcmath extension detected, No, GEO detection will be disabled Below are the library php-bcmath.x86_64 : A module for PHP applications for using the bcmath library php54-php-bcmath.x86_64 : A module for PHP applications for using the bcmath library php55-php-bcmath.x86_64 : A module for PHP applications for using the bcmath library php55w-bcmath.x86_64 : A module for PHP applications for using the bcmath library php56w-bcmath.x86_64 : A module for PHP applications for using the bcmath library php70w-bcmath.x86_64 : A module for PHP applications for using the bcmath library php71w-bcmath.x86_64 : A module for PHP applications for using the bcmath library rh-php56-php-bcmath.x86_64 : A module for PHP applications for using the bcmath library yum install php54-php-bcmath.x86_64 OUTPUT Loaded plugins: fastestmirror, refresh-packagekit, replace, security Setting up Install Process Loading mirror speeds from cached hostfile  * base: mirror.supremebytes...

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

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

[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