Thank you and Happy new year!
Indeed it is about a development installation (not ISO)
- I have tried to change the path LibOdbcDir to /usr/lib in
sipxcallresolver.sh (I have also made the softlink), restarted the sipx
but I have not seeting the data into the cdr tables (or page)
- The sipXproxy.log is saying that:
....
"2010-01-05T14:49:15.062380Z":83:ODBC:DEBUG:bart.itcnetworks:pid-17923:B7F59740:SipXProxy:"odbcConnect:
Connected to database
DATABASE=SIPXCDR;SERVER=localhost;UID=postgres;PWD=;DRIVER={PostgreSQL};READONLY=0;,
OdbcHandle 0x85791b8"
"2010-01-05T14:49:15.062444Z":84:CDR:DEBUG:bart.itcnetworks:pid-17923:B7F59740:SipXProxy:"CallStateEventWriter_DB::openLog
connected to database SIPXCDR"
"2010-01-05T14:49:15.064104Z":85:ODBC:DEBUG:bart.itcnetworks:pid-17923:B7F59740:SipXProxy:"odbcExecute:
statement INSERT INTO observer_state_events VALUES
(DEFAULT,'11.126.12.13:-1',0,timestamp '2010-01-05
14:49:15.051',101,'SipXProxyCseObserver'); succeeded"
"2010-01-05T14:49:15.064203Z":86:CDR:DEBUG:bart.itcnetworks:pid-17923:B7F59740:SipXProxy:"CallStateEventWriter_DB::writeLog"
"2010-01-05T14:49:15.064367Z":88:SIP:DEBUG:bart.itcnetworks:pid-17923:B7F59740:SipXProxy:"SipUserAgent::allowMethod
this = 'SipUserAgent-2', methodName = 'BYE', bAllow = 1"
"2010-01-05T14:49:15.064366Z":87:KERNEL:WARNING:bart.itcnetworks:OsTimer-9:B77FBB90:SipXProxy:"OsTimerTask::insertTimer
timer to fire 31 microseconds in the past, queue length = 0"
....
- I have cofigured my system with --enable-cdr
Not sure what is still wrong in my setup.
Thank you
Daniel
On Wed, 2009-12-23 at 10:18 -0500, Raymond Dans wrote:
> Daniel wrote:
> >Subject: [sipX-dev] Populating the CDR pages
> >
> >Hi
> >
> >While working for http://track.sipfoundry.org/browse/XX-6132
> >(Exception due to stale link on user portal ) I discovered
> >that I can not get my CDR table/pages to be populated. Not
> >sure what I am doing wrong or missing.
> >
> >I have:
> >
> >- Added 2 softphones (xlite as Bria)
> >- Associated one line for each
> >- The CDR server is up and running
> >- "Enable Call Detail Records" setting is enabled.
> >- Successfully making internal call between 2 lines
> >
> >All the CDR page remains empty and so the db tables
> >associated. I did not find anything wrong in the
> >supervisor.log or sipxcallresolver.log (but I probably looking
> >in the wrong place as I do not have much experience with CDR)
> >
> >Any suggestion/help much appreciated
> >
> >
> I assume you're using a development system and not an ISO image.
>
> If you are using a development system, you should:
>
> 1. Edit the sipxcallresolver.sh in the bin directory and change the
> LibOdbcDir path to point to /usr/lib instead of your lib install path or
> even simpler, create a softlink link called "unixODBC" in your install
> lib directory and have it point to /usr/lib (i.e. ln -s /usr/lib
> unixODBC from your install lib directory). Now restart your system for
> the change to be recognized.
>
> 2. Check the sipXproxy.log file to see if it was able to successfully
> open the database in order to write Call State Events (CSE) to it.
>
>
> Raymond
>
>
_______________________________________________
sipx-dev mailing list [email protected]
List Archive: http://list.sipfoundry.org/archive/sipx-dev
Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev
sipXecs IP PBX -- http://www.sipfoundry.org/
