<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.32.2">
</HEAD>
<BODY>
Hello,<BR>
<BR>
I install asterisk an postgresql 9.1 in gentoo, I already did the configuration in both asterisk and postgresql, in fact If I make a call and asterisk log it to CDR table, my question is:<BR>
<BR>
how can I make a function like the ones in func_odbc.conf for postgresql, if I am using res_pgsql.conf instead of res_odbc.conf?<BR>
<BR>
I also configure odbc and it connects with <B><TT>echo "select 1" | isql -v asterisk-connector</TT></B> with out problems, but when I try an odbc function or restart asterisk it logs:<BR>
<BR>
<TT><B>Error SQLConnect=-1 errno=101 [unixODBC]Could not connect to the server; Could not connect to remote socket.</B></TT><BR>
<BR>
and the command<BR>
<BR>
<TT><B>CLI> odbc show</B></TT><BR>
<BR>
<B><TT>ODBC DSN Settings</TT></B><BR>
<B><TT>-----------------</TT></B><BR>
<BR>
<B><TT> Name: asterisk</TT></B><BR>
<B><TT> DSN: asterisk-connector</TT></B><BR>
<B><TT> Last connection attempt: 2012-02-22 06:45:36</TT></B><BR>
<BR>
<BR>
I will appreciate any help.<BR>
<BR>
<BR>
Regards,<BR>
<BR>
</BODY>
</HTML>