similar to: What's diff between ${CDR(start)} , ${CDR(answer)} , ${CDR(calldate)}

hi,all as you know, we can use MYSQL command to visit mysql database but if i use other database like Oracke,sybase,etc, Could i use MYSQL command ? if not, is there any other alternative could do the same function(visit database in dailplan)? Thanks! -- Best regards, Sucan

hi, All one thing confused me a long time. when i change the extensions.conf file. why not take effects after restart the asterisk? details as follow: my dailplan is : [95040] exten => _95040XXXXX,1,Set(CALLINNUM=${CALLERID(dnid)}) exten => _95040XXXXX,n(start),Answer exten => _95040XXXXX,n(welcome),Background(${welcomefile},,123) ... exten => i,1,Playback(invalid) exten =>

hi, all recently, i face a GotoIfTime problem GotoIfTime("08:00:00-07:00:00,mon-sun,*,*?95040263008,start") as you can see the section is 08:00:00-07:00:00 , which is the begin time is later than the end time what's this refers then? in my test , my system time is 10:57:00, but this check will pass, although i guess i will not. is begin time later than the end time means

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel

hi, list i want to know what is the best OS for install Asterisk 1.6.2.9, which should work properly on working system. i want to use CentOS5.2 or CentOS 5.4. Which is better and stable? Thanks for your help. -- Thanks for your supporting, have a nice day. Sucan

hi, guys, when i create a manager account used for freepbx, the follow info produce all the time? do you know that's the reason? == Manager 'bitzsk' logged off from 127.0.0.1 == Manager 'bitzsk' logged on from 127.0.0.1 == Manager 'bitzsk' logged off from 127.0.0.1 == Manager 'bitzsk' logged on from 127.0.0.1 == Manager 'bitzsk' logged

hi , all when i do the command "module load cdr_radius.so" ,error happens. i have installed radiusclient-ng , what's wrong with it? thanks! error message as follow: ZHANGSHUKUN*CLI> module load cdr_radius.so Unable to load module cdr_radius.so Command 'module load cdr_radius.so' failed. [Dec 23 17:55:41] WARNING[31072]: loader.c:380 load_dynamic_module: Error

hi, all i want to use g729 codec for set up a call. so i donwloaded the so file from web site: http://asterisk.hosting.lv/#bin and install it properly. *CLI> *CLI> core show translation Translation times between formats (in microseconds) for one second of data Source Format (Rows) Destination Format (Columns) g723 gsm ulaw alaw g726aal2 adpcm slin

hello,all there is a AudioCodes Mediant 2000 out there. i want to realise ip to PSTN and PSTN to ip connection. after some configuration on AudioCodes Mediant 2000, PSTN to ip connecttion works. next ,i want to dial from asterisk to PSTN now. i have see the sample in the extensions.conf relevent to PSTN as follow: ; If you are freely delivering calls to the PSTN, list them here ; ;exten =>

hi,list Could Asterisk-addson-1.6.2.0 install in 64bit Cent-OS ? after i make and make install. i cant find the .so file. is this mean it can't install on 64bit Cent-OS. ps: it works fine on the 32 bit Cent-OS Thanks very much! -- Thanks for your supporting, have a nice day. Sucan

hi, Does A2Billing has mial list? -- Thanks, Sucan

Hi,all i want to hear the voicemail recorded, but when hear "if you want to play message , press 3", after i press 3 i only hear that that's the time the file recorded. not the content. do you know how to hear content of voicemail fle? debug message: == Parsing '/var/spool/asterisk/voicemail/95040654321/3/INBOX/msg0001.txt': Found -- <SIP/1003-00000058>

Dear all, I can't understand the diff between roundrobin and rrmemory strategy. Could you explain for me ? and is roundrobin means each available interface ring once or several times and ring another? ; A strategy may be specified. Valid strategies include: ; ; ringall - ring all available channels until one answers (default) ; roundrobin - take turns ringing each available interface ;

hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are

hi, dear all MYSQL commands work well in 1.4.28 edition, but not in 1.6.21 is that the grammar is different between them? extensions.conf exten => s,2,MYSQL(Query resultid ${connid} SELECT\ callerid\ from\ blacklist\ where\ companycode = ${ARG2} and callerid=${ARG1} and blockenabled = 1) cli: -- Executing [s at macro-checkblacklist:2] MYSQL("SIP/1003-00000006", "Query

hi, all in my test,it shows Playback will answer the call automaticly, but i don't want to so. i will use answer function to answer the call. could you help me ? -- Best regards, Sucan

Hi All, I'm stuck and need some help. I have installed the Asterisk CDR Analyser Version 2.0.1. It mostly works except for the CDR Report. I get the following error even though it lists the CDR details. Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >=

Dears, I need to save some information on userfield when calls end in Asterisk13, but I have two error cases: 1. With endbeforehexten=no in cdr.conf, I have a registry in cdr, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it

Hi, I have asterisk-server version of 1.8.11-cert7. When external enemy try to using it for calling, server write this string to log: 2014-03-13 09:56:04] VERBOSE[4754] pbx.c: -- Executing [9810972592309759 at from-sip-external:1] NoOp("SIP/external-ip-00065fd2", "Received incoming SIP connection from unknown peer to 9810972592309759") in new stack [2014-03-13

hi, all after my installation of asterisk and adds-on . when start astrisk, error accours as follow: [Feb 26 13:18:08] WARNING[16077]: config.c:2025 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available what's wrong with me ? Thanks. -- Best regards, Sucan