We often require to do string manipulation on a variable. For example, a variable named phonenumber which represents a number we’d like to call, and we want to strip off the first 5 digit before dialing the number. Asterisk provides a special syntax for doing just that, which looks like ${variable[:skip[:length]} The optional skip field tells Asterisk how many … Read more
Action: Originate Channel: SIP/2003 Context: test Exten: s Priority: 1 Variable: __SIPADDHEADER51=Call-Info: <sip:192.168.0.19>\;answer-after=0 Callerid: MyTestCall Timeout: 15000 ActionID: 200 Where 192.168.0.19 is the IP of Asterisk Server
ChannelRedirect : This is used to redirect the given channel to target dialplan. For example if you want to redirect the channel SIP/1222-09992 to wrap context at 2 priority. You can use this function/command to do so. This has been added in Asterisk 1.4 version. For Asterisk 1.4 version ChannelRedirect(channel|[[context|]extension|]priority) For Asterisk 1.8 and above … Read more
You can use Pipe Viewer to monitor mysql dump. If you don’t already have pv, you can install it with: yum install pv # pv db1.sql.gz | gunzip | mysql -u root -p db1 693MiB 1:00:33 [ 325kiB/s] [====================> ] 68% ETA 0:16:20
Easiest way to do this is to add a UNIQUE index on the column. When you write the ALTER statement, include the IGNORE keyword. Like so: ALTER IGNORE TABLE jobs ADD UNIQUE INDEX idx_name (site_id, title, company); This will drop all the duplicate rows. As an added benefit, future INSERTs that are duplicates will error … Read more
Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character sequences in Web forms, URLs, or whatever application you have built. Be sure that your application remains secure if a user enters something like “; DROP DATABASE mysql;”. This is … Read more
This article describes general security issues to be aware of and what you can do to make your MySQL installation more secure against attack or misuse. Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. In discussing security, it is necessary to consider fully … Read more
The LOAD DATA statement can load a file that is located on the server host, or it can load a file that is located on the client host when the LOCAL keyword is specified. There are two potential security issues with supporting the LOCAL version of LOAD DATA statements: The transfer of the file from … Read more
Here is an example to select multiple column of a table from select statement in asterisk. exten => h,1,MYSQL(Connect conn localhost username password database) exten => h,n,MYSQL(Query res ${conn} ‘SELECT call_id,callerid,calltime FROM todaycall WHERE calltime=curdate() order by calltime desc limit 1′) exten => h,n,MYSQL(Fetch fid ${r} call_id callerid calltime) exten => h,n,MYSQL(Clear ${r}) exten => … Read more
Once replication has been started it should execute without requiring much regular administration. Depending on your replication environment, you will want to check the replication status of each slave periodically, daily, or even more frequently. Checking Replication Status: The most common task when managing a replication process is to ensure that replication is taking place … Read more