<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#0000ff">Hi </div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#0000ff">it seems you created database with postgres user and not with "Dbuser" . Either connect the database with user "postgres" in cdr_pg_csv.xml or grant permission to database for "Dbuser" .</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#0000ff">in pg_hba.conf let the host entry as trust for now . (will eliminate the confusion with password part ).</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#0000ff">regards</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#0000ff">Ahmed</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;color:#0000ff"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Apr 17, 2016 at 1:50 PM, jungle Boogie <span dir="ltr"><<a href="mailto:jungleboogie0@gmail.com" target="_blank">jungleboogie0@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi All,<br>
<br>
So last week I was able to get freeswitch working with postgres!<br>
thanks all that responded in this thread:<br>
<a href="http://lists.freeswitch.org/pipermail/freeswitch-users/2016-April/119827.html" rel="noreferrer" target="_blank">http://lists.freeswitch.org/pipermail/freeswitch-users/2016-April/119827.html</a><br>
<br>
Now I'd like to have CDR records recorded to a postgres database table as per:<br>
<a href="https://freeswitch.org/confluence/display/FREESWITCH/mod_cdr_pg_csv" rel="noreferrer" target="_blank">https://freeswitch.org/confluence/display/FREESWITCH/mod_cdr_pg_csv</a><br>
<br>
conf/autoload_configs/cdr_pg_csv.conf.xml:<br>
<param name="db-info" value="host=localhost dbname=freeswitchcdr<br>
user=DBuser password=xxx connect_timeout=10" /><br>
<br>
In that same file, I have ab legs and all of the schema enabled.<br>
<br>
I created my table with this sample:<br>
<a href="https://freeswitch.org/stash/projects/FS/repos/freeswitch/browse/src/mod/event_handlers/mod_cdr_pg_csv/scripts/create.sql" rel="noreferrer" target="_blank">https://freeswitch.org/stash/projects/FS/repos/freeswitch/browse/src/mod/event_handlers/mod_cdr_pg_csv/scripts/create.sql</a><br>
<br>
I've made a few calls and yet, the database is empty:<br>
select * from cdr;<br>
id | local_ip_v4 | caller_id_name | caller_id_number |<br>
destination_number | context | start_stamp | answer_stamp | end_stamp<br>
| duration | billsec | hangup_cause | uuid | bleg_uuid | accountcode |<br>
read_codec | write_codec | sip_hangup_disp<br>
osition | ani<br>
----+-------------+----------------+------------------+--------------------+---------+-------------+--------------+-----------+----------+---------+--------------+------+-----------+-------------+------------+-------------+----------------<br>
--------+-----<br>
(0 rows)<br>
<br>
<br>
I see this in the FS logs:<br>
2016-04-17 08:44:13.904128 [CRIT] mod_cdr_pg_csv.c:274 INSERT command<br>
failed: ERROR: permission denied for relation cdr<br>
<br>
My username and password above are exactly the same on the database<br>
I modified pg_hba.conf to have trust and md5. Should it only be one or<br>
the other?<br>
<br>
Thanks!<br>
<br>
<br>
--<br>
-------<br>
inum: 883510009027723<br>
sip: <a href="mailto:jungleboogie@sip2sip.info">jungleboogie@sip2sip.info</a><br>
xmpp: <a href="mailto:jungle-boogie@jit.si">jungle-boogie@jit.si</a><br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br></div>