search for: mysql_cdr

...well except for a strange problem I ran into this morning. During some cdr database maintenance, the cdr table was locked for a few minutes, during this condition all the Asterisk servers stopped processing calls and reported this error: Jan 5 09:57:03 ERROR[938]: cdr_addon_mysql.c:226 mysql_log: mysql_cdr: Failed to insert into database: (1205) Lock wait timeout exceeded; try restarting transaction Jan 5 09:57:54 ERROR[970]: cdr_addon_mysql.c:226 mysql_log: mysql_cdr: Failed to insert into database: (1205) Lock wait timeout exceeded; try restarting transaction Jan 5 09:58:45 ERROR[515]: cdr_addon_...

...#39; '51010077', 'userfield' '', 'MMI_field' 'not found' Issue #2: When a call is not answered, a record of that call is written to the database, but uniqueid is left blank. The next time a call isn't answered, Asterisk complains: cdr_addon_mysql.c: mysql_cdr: Failed to insert into database: (1062) Duplicate entry '' for key 1 I haven't found any other information regarding these errors. I am just wondering if they are bugs. Any insight would be appreciated! -- Jason Martin Metrix Matrix, Inc. 785 Elmgrove Road, Building 1, Rochester, N...

Hi people! i'm trying to work together the cdr with mysql. MySQL works on a windows machine, it seems ok but when i hangup with the sip phone, * write: Failed to insert into database. I have tryed to insert manually some values into the table and after i have seen that values in a php web page, and the sql server accept the incoming calls and display it properly. With MySQL Administrator i see

Sometimes I get the following error on the console: [May 31 11:14:01] ERROR[23502]: cdr_addon_mysql.c:230 mysql_log: mysql_cdr: Failed to insert into database: (1062) Duplicate entry '1180628004.3214' for key 1 -- Zap/38-1 answered UniCall/11-1 Why would the UNIQUEID be duplicated? Isn't is supposed to be UNIQUE? This worries me a bit because the customer is losing calls that will not appear in their CDR...

...ime zone set to whatever i have in configuration i tried cdrzone=GMT, cdrzone=UTC, cdrzone=yes and many combinations with timezone=UTC and without timezone=UTS but cdr is alway in my local timezone GMT +2. in further investigation i have seen there is no timezone conversation. from asterisk1.8.231 mysql_cdr.c if (!strcmp(entry->name, "calldate")) { /*!\note * For some dumb reason, "calldate" used to be formulated using * the datetime the record was posted, rather than the start...

...So,cecking the conf file and the username, password and domain are ok. Need to configure other modules?or the information passed by sip are incorrect? I use a budgettone grand stream and msn client it make me crazy.... regards Walter > Hi, > > when everthing is according to the Wiki's mysql_cdr pages, > it should work. > > Please check permissions! > (Insert permission granted to the user as defined in > cdr_mysql.conf? Even if other host, respectively even > if same host? Did you realize, that host '%' does not > include localhost in mysql?) > > > Ro...

hi, i saw the cdr file called Master.csv and i want to know what these represent. examples "","","4","incoming","","Zap/1-1","Zap/4-1","Voicemail","u8888","2003-11-07 17:43:04","2003-11-07 17:43:04","2003-11-07 17:43:22","ANSWERED","DOCUMENTATION"

I am trying to use a the SIP tapi from www.enum.at <http://www.enum.at/> . This works fine from all kinds of applications which support TAPI, like outlook and Dialer Pro. However when making tapi controlled calls, the signaling to and from PSTN seems to fail. I have used the digium hardware ISDN PRI boards, but also a SIP gateway. Both result in a audio message from asterisk