[asterisk-users] Asterisk CDR Problem

[Hiren Mistry]

Hi Max,
                In CDR configuration for Pstgres Database, I have copied 
cdr_pgsql.so module file from other Asterisk System. May be that happen 
in this my problem I have Installed Asterisk 1.4 on CentOS-5 (64bit). 
So, exactly what in both system which I have made recently the file size 
of cdr_pgsql.so is different one is 128.2 kb and one is 130.5 kb when I 
copied 130.5 file in /usr/lib/asterisk/modules and cdr_pgsql.so can load 
which is I describe below....

localhost*CLI> module load cdr_pgsql.so
  == Parsing '/etc/asterisk/cdr_pgsql.conf': Found
 Loaded cdr_pgsql.so => (PostgreSQL CDR Backend)
localhost*CLI>

------------------------------
And 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
CDR registered backend: pgsql
localhost*CLI>
Now data are inserting in Postgres Database. Thank you Max for your 
Supports. But is it possible there are two different file size ? And 
when I install Asterisk 1.4 in /etc/asterisk directory no one files are 
copied. Now that problem is solve.

With Regards.
Hiren Mistry

Max Alex wrote:
> Hi,
> let me know that you have configured properly in res_pgsql.conf in 
> asterisk with proper, and it is connected properly to database with 
> database details.
>
> Thanks,
> Max Alex
> Voip Developer
>
>
>
> On Fri, Aug 29, 2008 at 10:26 AM, Hiren Mistry 
> <hiren.mistry at mobilefundas.com <mailto:hiren.mistry at mobilefundas.com>> 
> 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 <http://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.
>
>
>     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> <mailto: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>
>     <mailto: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
>     <mailto: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
>         
>
>


-- 
With Regards,
Hiren Mistry

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080830/12c96f8d/attachment.htm