On Wednesday 05 May 2010 18:29:26 Neeraj Chand wrote: > ------------------------------------------------------------------------ > --- > Message: 10 > Date: Wed, 5 May 2010 10:26:34 -0500 > From: Tilghman Lesher <[email protected]> > Subject: Re: [asterisk-users] CDR to MS-SQL via ODBC issue > To: "Asterisk Users Mailing List - Non-Commercial Discussion" > <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > On Wednesday 05 May 2010 06:51:48 Neeraj Chand wrote: > > I can connect to the database and run via isql, and also use > > func_odbc, > > > etc with res_odbc configured with the same database / freetds, but I > > cannot write CDRs. > > > >>Are you writing to the database with func_odbc, or just reading? My > > gut says > > >>that you need to check your permissions on the database to ensure that > > you're > > >>allowed to write to the CDR table. > > Hi Tilghman, yeah I thought so too at first but then, using the > same permissions I'm doing both read & writes as well. > > On the database end, the user is setup as database_owner and has db_read > & db_write permissions. > > I got Leif to check this with me last night, we couldn't figure it out. > > The error that pops up is: > > cdr_odbc: Connected to asterisk-freetds-connector > > cdr_odbc: Error in PREPARE -1 > > cdr_odbc: Query FAILED Call not logged! > > ________________________________________________________________________ > __
Okay, second idea is that you should very carefully examine your CDR table layout and ensure that the columns that you have match EXACTLY what the module expects you to have. If Asterisk expects you to have a column that you don't (or the column type is wrong), that is another reason that the prepare might fail. You might consider using the cdr_adaptive_odbc driver, instead, as it is designed to create the insert based upon the structure of the table. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
