<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Max,<br>
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....<br>
<br>
localhost*CLI> module load cdr_pgsql.so<br>
== Parsing '/etc/asterisk/cdr_pgsql.conf': Found<br>
Loaded cdr_pgsql.so => (PostgreSQL CDR Backend)<br>
localhost*CLI> <br>
<br>
------------------------------<br>
And OUTPUT on CLI --- Below <br>
<br>
localhost*CLI> cdr status <br>
CDR logging: enabled<br>
CDR mode: simple<br>
CDR registered backend: csv<br>
CDR registered backend: cdr_manager<br>
CDR registered backend: cdr-custom<br>
CDR registered backend: pgsql<br>
localhost*CLI> <br>
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. <br>
<br>
With Regards.<br>
Hiren Mistry<br>
<br>
Max Alex wrote:
<blockquote
cite="mid:c8ba87ad0808292153g6c60d8fbl136aa9066647e636@mail.gmail.com"
type="cite">
<div dir="ltr">Hi,<br>
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.<br>
<br clear="all">
Thanks,<br>
Max Alex<br>
Voip Developer<br>
<br>
<br>
<br>
<div class="gmail_quote">On Fri, Aug 29, 2008 at 10:26 AM, Hiren
Mistry <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:hiren.mistry@mobilefundas.com">hiren.mistry@mobilefundas.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"><br>
Hi ,<br>
I have check zapte.conf in and after make some correction that problem
solve.<br>
<br>
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<br>
<br>
cdr.conf -- Below<br>
[general]<br>
<br>
[csv]<br>
usegmtime=yes ;log date/time in GMT<br>
loguniqueid=yes ;log uniqueid<br>
loguserfield=yes ;log user field<br>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
cdr_pgsql.conf -- Below<br>
<br>
[global]<br>
hostname=localhost<br>
;hostname=<a moz-do-not-send="true" href="http://122.160.10.81"
target="_blank">122.160.10.81</a><br>
port=5432<br>
dbname=asterisk<br>
password=postgres<br>
user=postgres<br>
table=cdr <br>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
modules.conf -- Below<br>
<br>
[modules]<br>
autoload=yes<br>
;preload => res_odbc.so<br>
;preload => res_config_odbc.so<br>
<br>
noload => pbx_gtkconsole.so<br>
;load => pbx_gtkconsole.so<br>
noload => pbx_kdeconsole.so<br>
load => res_musiconhold.so<br>
noload => chan_alsa.so<br>
<br>
<br>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
OUTPUT on CLI --- Below <br>
localhost*CLI> cdr status <br>
CDR logging: enabled<br>
CDR mode: simple<br>
CDR registered backend: csv<br>
CDR registered backend: cdr_manager<br>
CDR registered backend: cdr-custom<br>
localhost*CLI> <br>
<br>
also when I load manually cdr_pgsql.so on CLI then it show error which
is also I describe below<br>
localhost*CLI> module load cdr_pgsql.so <br>
[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<br>
[Aug 29 10:22:21] WARNING[8984]: loader.c:614 load_resource: Module
'cdr_pgsql.so' could not be loaded.<br>
<br>
<br>
So, Please guide me for load Postgres module in asterisk for CDR
Database.<br>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td>
<div style="display: inline;">Subject: </div>
Re: [asterisk-users] Asterisk CLI Show Error :- ("**Unknown**") instead
of ("Zap/22-1", )</td>
</tr>
<tr>
<td>
<div style="display: inline;">From: </div>
"Max Alex" <a moz-do-not-send="true"
href="mailto:max.asterisk@gmail.com" target="_blank"><max.asterisk@gmail.com></a></td>
</tr>
<tr>
<td>
<div style="display: inline;">Date: </div>
Thu, 28 Aug 2008 11:48:16 +0530</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td>
<div style="display: inline;">To: </div>
"Asterisk Users Mailing List - Non-Commercial Discussion"
<a moz-do-not-send="true"
href="mailto:asterisk-users@lists.digium.com" target="_blank"><asterisk-users@lists.digium.com></a></td>
</tr>
</tbody>
</table>
<br>
Hi Hiren,<br>
Have you properly configured the zap channels in asterisk,<br>
which device have you configured in asterisk with zaptel?<br>
<br>
let me know the dial plan for ivr.<br>
<br clear="all">
Thanks,<br>
Max Alex<br>
Voip Developer<br>
<br>
<br>
<br>
On Thu, Aug 28, 2008 at 11:40 AM, Hiren Mistry <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:hiren.mistry@mobilefundas.com"
target="_blank">hiren.mistry@mobilefundas.com</a>></span>
wrote:<br>
<br>
Hi, Everybody,<br>
<br>
I am planning to make a new IVR on Asterisk I have Installed zaptel ,<br>
libpri, asterisk, asterisk-addon on CentOS 5<br>
I also start service of zaptel and asterisk it start successfully. But<br>
when goto asterisk CLI> prompt and check this IVR then all call
string<br>
with ("**Unknown**") instead of ("Zap/22-1", ) and I have also 3 other<br>
Asterisk base IVR which is also on CentOS.<br>
[Asterisk CLI> Executing [83301@default:1] Answer("**Unknown**",
"") in<br>
new stack ]<br>
<br>
Please Help me for Configuring this IVR.<br>
<br>
--<br>
With Regards,<br>
Hiren Mistry<br>
<br>
<br>
<br>
<pre cols="72">--
With Regards,
Hiren Mistry
</pre>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
With Regards,
Hiren Mistry
</pre>
</body>
</html>