[asterisk-users] Asterisk CDR Problem

[Steve Murphy]

On Fri, 2008-08-29 at 10:26 +0530, Hiren Mistry wrote:
> 
> Hi ,
> I have check zapte.conf in and after make some correction that problem
> solve.
> 
> But now I am facing other problem. We are using here Postgres Database
> and the data from CLI it can't insert in Postgres Database. I have
> also here mention below cdr_pgsql.conf, modules.conf and cdr.conf
> 
> cdr.conf -- Below
> [general]
> 
> [csv]
> usegmtime=yes ;log date/time in GMT
> loguniqueid=yes ;log uniqueid
> loguserfield=yes ;log user field
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> cdr_pgsql.conf -- Below
> 
> [global]
> hostname=localhost
> ;hostname=122.160.10.81
> port=5432
> dbname=asterisk
> password=postgres
> user=postgres
> table=cdr    
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> modules.conf -- Below
> 
> [modules]
> autoload=yes
> ;preload => res_odbc.so
> ;preload => res_config_odbc.so
> 
> noload => pbx_gtkconsole.so
> ;load => pbx_gtkconsole.so
> noload => pbx_kdeconsole.so
> load => res_musiconhold.so
> noload => chan_alsa.so
> 
> 
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> OUTPUT on CLI --- Below 
> localhost*CLI> cdr status 
> CDR logging: enabled
> CDR mode: simple
> CDR registered backend: csv
> CDR registered backend: cdr_manager
> CDR registered backend: cdr-custom
> localhost*CLI> 
> 
> also when I load manually cdr_pgsql.so on CLI then it show error which
> is also I describe below
> localhost*CLI> module load cdr_pgsql.so 
> [Aug 29 10:22:21] WARNING[8984]: loader.c:362 load_dynamic_module:
> Error loading module 'cdr_pgsql.so': libpq.so.5: cannot open shared
> object file: No such file or directory
> [Aug 29 10:22:21] WARNING[8984]: loader.c:614 load_resource: Module
> 'cdr_pgsql.so' could not be loaded.
> 

The above is the key to you getting Asterisk to use the pgsql backend.
You need to supply the libpq.so. See if your version of linux has a 
libpq or pgsql-devel or whatever package that will supply this, and
install it.

murf

> 
> So, Please guide me for load Postgres module in asterisk for CDR
> Database.
> 
> Subject: Re: [asterisk-users] Asterisk CLI Show Error :-
> ("**Unknown**") instead of ("Zap/22-1", )
> From: "Max Alex" <max.asterisk at gmail.com>
> Date: Thu, 28 Aug 2008 11:48:16 +0530
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
> <asterisk-users at lists.digium.com>
> 
> Hi Hiren,
> Have you properly configured the zap channels in asterisk,
> which device have you configured in asterisk with zaptel?
> 
> let me know the dial plan for ivr.
> 
> Thanks,
> Max Alex
> Voip Developer
> 
> 
> 
> On Thu, Aug 28, 2008 at 11:40 AM, Hiren Mistry
> <hiren.mistry at mobilefundas.com> wrote:
> 
> Hi, Everybody,
> 
> I am planning to make a new IVR on Asterisk I have Installed zaptel ,
> libpri, asterisk, asterisk-addon on CentOS 5
> I also start service of zaptel and asterisk it start successfully. But
> when goto asterisk CLI> prompt and check this IVR then all call string
> with ("**Unknown**") instead of ("Zap/22-1", ) and I have also 3 other
> Asterisk base IVR which is also on CentOS.
> [Asterisk CLI>  Executing [83301 at default:1] Answer("**Unknown**", "")
> in
> new stack ]
> 
> Please Help me for Configuring this IVR.
> 
> --
> With Regards,
> Hiren Mistry
> 
> 
> 
> -- 
> With Regards,
> Hiren Mistry
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> 
> AstriCon 2008 - September 22 - 25 Phoenix, Arizona
> Register Now: http://www.astricon.net
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-- 
Steve Murphy
Software Developer
Digium
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3227 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20080902/ca360a43/attachment.bin