[Freeswitch-users] Use Nibblebill with PostgreSQL

[Madovsky]

If you compiled FS with --enable-core-odbc-support so you can use

<param name="odbc-dsn" value="pgsql://hostaddr=xx.xx.xx.xx port=xxxx 
dbname=xxx user=xxx password='xxxx' options='-c 
client_min_messages=NOTICE' application_name='freeswitch'" />

you must set odbc.ini

On 1/3/2018 1:02 PM, Geoff Mina wrote:
> I think the param is db-dsn. Not the underscore version.
>
> On Jan 3, 2018, at 12:59 PM, Sergey Safarov <s.safarov at gmail.com 
> <mailto:s.safarov at gmail.com>> wrote:
>
>> I used connection string
>>
>> <param name="db_dsn" value="pgsql://hostaddr=127.0.0.1 dbname=******* 
>> user=******* password=*******"/>
>>
>> Sergey
>>
>>
>> ср, 3 янв. 2018 г. в 22:06, <igor.potjevlesch at gmail.com 
>> <mailto:igor.potjevlesch at gmail.com>>:
>>
>>     Hello !
>>
>>     I try to connect Nibblebill directly to PostgreSQL but it still
>>     fails.
>>
>>     I follow the documentation and setup the param like this: <param
>>     name="odbc_dsn" value="pgsql://A.B.C.D dbname=prepaid
>>     user=prepaid password=<hidden>"/>
>>
>>     When I hangup a call, the logs report the following:
>>     52c8b77c-f0b8-11e7-8d19-5566a3fb77f6 2018-01-03 20:00:19.037333
>>     [CRIT] mod_nibblebill.c:604 Failed to log to database!
>>
>>     Any idea on how to proceed with FS 1.6? Thank you!
>>
>>     Regards,
>>
>>     Igor.
>>
>>     _________________________________________________________________________
>>     Professional FreeSWITCH Consulting Services:
>>     consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>     http://www.freeswitchsolutions.com
>>
>>     Official FreeSWITCH Sites
>>     http://www.freeswitch.org
>>     http://confluence.freeswitch.org
>>     http://www.cluecon.com
>>
>>     FreeSWITCH-users mailing list
>>     FreeSWITCH-users at lists.freeswitch.org
>>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>     http://www.freeswitch.org
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>> http://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org 
>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180103/a464975b/attachment.html>