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 <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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" <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]>
    Date:
    Thu, 28 Aug 2008 11:48:16 +0530

    To:
    "Asterisk Users Mailing List - Non-Commercial Discussion"
    <[email protected]>
    <mailto:[email protected]>


    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
    <[EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]>> 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 [EMAIL PROTECTED]: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

_______________________________________________
-- 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

Reply via email to