search for: loguniqueid

Hi, Since a few days I'm experiencing this: > cdr_odbc: Connected to asterisk > cdr_odbc: Error in Query -1 > cdr_odbc: Query FAILED Call not logged! > cdr_odbc: Connected to asterisk > cdr_odbc: Reconnecting to dsn asterisk > cdr_odbc: Trying Query again! > cdr_odbc: Error in Query -2 > cdr_odbc: Query FAILED

...ut having to recompile asterisk-addons as stated here http://www.voip-info.org/wiki-Asterisk+cdr+mysql ? After version 1.4 it is said in release that it can be done (not sure if it applies to mysql backend) How would it be the syntax in cdr.conf? I tried this without success in cdr.conf: [mysql] loguniqueid=yes ;log uniqueid loguserfield=yes ;log user field Regards Luis Palma -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070917/7768f033/attachment.htm

...at I have also set up the same odbc database for func_odbc, and registered my custom SQL functions and can access these (the db manager shows that this session is connected) cdr.conf ========== [general] enable=yes cdr_odbc.conf ========== [general] dsn=mydsn username=myuser password=mypassword loguniqueid=yes dispositionstring=yes table=PUB.cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT I must be missing something really really obvious here and would appreciate any help Julian

...00 at sip',9,9,'ANSWERED',3,'1235681438.1') a16-q1:/etc/asterisk# cat cdr.conf [general] enable=yes ;unanswered = no ;batch=no ;size=100 ;time=300 ;scheduleronly=no ;safeshutdown=yes ;endbeforehexten=no [csv] usegmtime=yes ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default is "no" loguserfield=yes ; log user field. Default is "no" [odbc] usegmtime=yes ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default is "no" loguserfield=yes ; log user field. Default is "...

...21:30:01] ERROR[14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=******* ;loguniqueid=yes ;dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=yes ; set to "yes" to log in GMT What am I doing wrong please ? Best Regards, -- SplatNIX IT Services :: Innovation through collaboration

...raceFile = /var/log/odbc-asterisk /etc/asterisk/res_odbc.conf: [asterisk] enabled => yes dsn => asterisk username => asterisk password => exodus_2009 pre-connect => yes /etc/asterisk/cdr_odbc.conf: ; cdr_odbc.conf ; [global] dsn=asterisk username=asterisk password=exodus_2009 loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT ---------------------------------------------------------------------------------------------------------- Any ideas?

; ; cdr_odbc.conf ; ;[global] ;dsn=MySQL-test ;username=username ;password=password ;loguniqueid=yes ;dispositionstring=yes ;table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT Though, reading from https://issues.asterisk.org/view.php?id=15021, it seems that lines username= and password= in cdr_odbc.conf are not used...

Hi, I'm logging cdr via odbc to mysql. It seems that there is an intermittent problem where the CDR(userfield) isn't written to the database. The rows all seem to be there, but that specific field is missing. The same dialplan. Nothings changed. Probably 1 in 10 is missing the userfield. Any ideas how I can debug this? Many thanks Dan -------------- next part -------------- An HTML

....2.13 Server Radius: Freeradius version 1.X Radius client: radiusclient-ng version 0.5.5 With the Asterisk core debug on 1 when a call terminate, on the console appear this error: Unable to create RADIUS record. CDR not recorded! My cdr.conf is: [radius] usegmtime=yes ; log date/time in GMT loguniqueid=yes ; log uniqueid loguserfield=yes ; log user field radiuscfg=/etc/radiusclient-ng/radiusclient.conf When I load the cdr_radius module no error appear. Any suggestion? Regards - Andrea

I am using the new 1.8.5 and I just found out that Asterisk won't record the call if the call just hangup. I did a test like this: exten => 1009, 1, Hangup() Then I called 1009: == Using UDPTL CoS mark 5 == Using SIP RTP CoS mark 5 -- Executing [1009 at init-1005:1] Hangup("SIP/1007-0000003c", "") in new stack == Spawn extension (init-1005, 1009, 1)

...ing fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow: [global] dsn=oracle username=asterisk password=manager ;loguniqueid=yes I don't use uniqueid ! I noticed that /usr/lib/asterisk/modules/cdr_odbc.so library is missing so I can't include it in modules.conf under /etc/asterisk I tried to compile cdr_odbc.c but failed with a lot of errors! A config exemples is highly appreciated or any other help. Other...

Hi to all, I actually have an asterisk server configured to write CDR mysql records in the same machine (localhost), but I want to write this records to another machine also in mysql at the same time, It is possible? It means that I want save the records in both machines. Thanks in advance. Ricardo Melendez -------------- next part -------------- An HTML attachment was scrubbed... URL:

...created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no loguniqueid=yes loguserfield=yes accountlogs=yes I created the table in the DB so: CREATE TABLE IF NOT EXISTS `cdr` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `sr...

...Last connection attempt: 2014-01-11 18:16:40 Pooled: Yes Limit: 1000 Connections in use: 0 -------------- /etc/asterisk/cdr.conf lists below: [general] enable=yes unanswered = yes congestion = yes endbeforehexten=yes [csv] usegmtime=no ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default is "no" loguserfield=yes ; log user field. Default is "no" accountlogs=yes ; create separate log file for each account code. Default is "yes" -------------- /etc/odbc.ini [asterisk-connector] Description = MySQL connection to...

...the config file for asterisk. /etc/asterisk/res_odbc.conf ----------------------------- [mysql] enabled => yes dsn => MySQL-asterisk username => asterisk password => qpalym pre-connect => yes and /etc/asterisk/cdr_odbc.conf ---------------------------- [global] dsn=MySQL-asterisk loguniqueid=yes dispositionstring=yes table=cdr But after a call hangup I get the following error: cdr_odbc.c: Unable to retrieve database handle. CDR failed. What is going wrong here, please? -Thorsten-

....conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > > [general] > enable=yes > unanswered = yes > safeshutdown=yes > > [mysql] > usegmtime=no > loguniqueid=yes > loguserfield=yes > accountlogs=yes > > I created the table in the DB so: > > CREATE TABLE IF NOT EXISTS `cdr` ( > `id` int(11) unsigned NOT NULL AUTO_INCREMENT, > `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', > `clid` varchar(80) COLLA...

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

...h isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any more. My cdr_odbc.conf: [global] dsn=oracle username=asterisk password=asterisk loguniqueid=on odbc.ini [ORACLE] Driver = ORACLE Database = db9i Servername = 192.168.0.94 Port = 1523 User = asterisk Password = asterisk METADATA_ID = 0 ENABLE_USER_CATALOG = 1 ENABLE_SYNONYMS = 1 odbcinst.ini [ORACLE] Descri...

...problem. I have used the guide from http://www.voip-info.org/wiki-Asterisk+res_config. res_config_odbs.conf: [settings] table => ast_config connection => asterisk res_odbc.conf: ;;; odbc setup file [settings] dsn = asterisk USER = asterisk Password = <password> loguniqueid = yes pre-connect = yes extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc sip.conf => odbc odbc.ini and odbcinst.ini should be ok, as i can access the mysql database with the isql commandline tool. I have an empty sip.conf in the asterisk...

...n this error or if my config is off. mySQL 5 Asterisk branch/1.4 current rev cdr.conf [general] enabled=yes batch=no size=100 time=300 scheduleronly=no endbeforehexten=no safeshutdown=yes cdr_manager.conf [general] enabled=yes cdr_odbc.conf [global] dsn=asterisk username=user password=password loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT loaded files cdr_manager.so cdr_odbc.so cdr_csv.so ----------------------------------------...