similar to: Updating asteriskcdrdb with uniqueid field from Master.csv, Master.csv.1....Master.csv.5 - Must I bring all files together first?

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Thanks!

Hi, I hope this can help others, so this is it. Use it at your own risk. I have test it on 3 separate systems without any problem. Take care to edit the following files taking into consideration your own settings. If you have all the CDR info in the Master.csv too, then delete all the data from the 'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate

Hello, is there anyone who can point me to correct information ? Following http://pbxinaflash.com/forum/showthread.php?t=9042 and http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql > Extending CDR does not result in a working environment for me. Any feedback appreciated. Kind regards, Jonas. -------- Original Message -------- Subject: [asterisk-users] Asterisk 1.6.2.10 & CDR

Hi, When dealing with CDR SQL tables, I always added an auto-incremented cdr_id key as a primary key, just in case provided uniqueid key went wrong. Now I'm facing a situation where I need to insert into a database's table and from the dialplan, a reference to the CDR record which is currently processed. So my questions are: 1. Can uniqueid/sequence (or uniqueid/sequence/calldate)

Hi, I've noticed that the UNIQUEID for a call is not the same in the Dialplan (when executed e.g. exten => s,n,NoOp(${UNIQUEID}) as it is when passed via STDIN to an AGI script. Is this normal, and is this supposed to behave this way? The UNIQUEID received in the AGI is usually .001 higher than the one in the dial plan -- but sometimes it is also a second behind. Here's an example

I have been storing the output of facter in a database with the assumption that uniqueid was actually unique, until I found that it is the same for a handful of my machines. It appears that uniqueid is set from the output of hostid. I checked into hostid and it gets its value from gethostid(). The following link, http://www.opengroup.org/onlinepubs/009695399/functions/gethostid.html, states,

Hi, I have Fedora Core 2 running with a T1 card. I try to put the log on db but I get the error: Aug 20 15:17:47 ERROR[262160]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database exists and I try with "mysqlaccess localhost asteriskcdrdb" and I get: Access-rights for USER 'localhost', from HOST

Is uniqueid globally unique? I have three Asterisk installations and I need to store data from all of them in same database, in same table. Will this uniqueid field be unique? -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)270248 Mob.: +385(91)1212148 SIP: tomo@sip.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr -------------- next part -------------- A

Hi. I've been using the Asterisk Manager Interface to originate calls from Console/dsp. I get the following form the server. > Response: Success > Message: Originate successfully queued > Uniqueid: asterisk-3301-1252055630.26701 > > Event: Newchannel > Privilege: call,all > Channel: Console/dsp > State: Down > CallerIDNum: <unknown> > CallerIDName:

I set uniquename = MYHOST in asterisk.conf (under [options]) so that my uniqueid data shows up as MYHOST.time.seq. First of all, I would like to know if uniquename (or sysname?) will still be valid across future * versions (mainly 1.6). Secondly, is there a way to specify uniquename as an asterisk option at the command line? (asterisk -h doesn't show me anything regarding this feature)

What is the format of the UNIQUEID variable? It seems to be something like: 40651204817492.56 Does it always have the pattern <long_number>.<short_number>? ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

Hi to all. I'm begin a use the AMI and i have the need to get the uniqueid from the call i have generate using the Action Originate. Anyone can help me? When I generate these commands: action: Originate channel: SIP/101 application: Dial data: SIP/100,120,Ttr The only response I get when the call is answered, is this: Response: Success Message: Originate successfully queued Thanks a

Hello Asterisk Users, I guess the subject says the most of it; here goes some more detail: - Running Asterisk 1.2.14 - Objective: record all calls managed by a specific queue - Name those files ${TIMESTAMP}-${CALLERIDNUM}-${UNIQUEID} Facts: - If the UNIQUEID chan var is used in the MONITOR_FILENAME, before calling the Queue() application, the two legs of the call are not

Hi folks, I've just updated my * and I noticed that from the update the uniqueid field into mysql, is not written and ASTPP do not charge the calls. I got an eye to cdr_mysql.c and I found that at line 212, into one insert query, uniqueid is missing. But I can be wrong. In any case, somebody got same problem? Any suggestions? Thanks to all. -- .:FaberK:. -------------- next part

Hi Guys, I am looking to delete some of the CDR logged by Asterisk in asteriskcdrdb in a PbxinaFlash system running Asterisk 1.4.x The CDR records to deleted are probably a big chunk and spread out all through the database but I basically want to delete all calls that came in through a specific DID. I think they all show as SIP/did_number I don't want to break the system or break the

Hi guys, I have recently installed a Asterisk Server with CDR Call Detail Records. I have installed it over a Asterisk 1.2 , but now It do not run . I have installed it with the following procedure: # yum install ncurses #yum install openh323-devel # yum install mysql-server # yum install mysql # yum install php-gd # yum install php-mysql # yum install mysqlclient10 # yum install zlib # yum

Hi; I have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session