[Freeswitch-users] Use Nibblebill with PostgreSQL
Madovsky
infos at madovsky.org
Mon Jan 15 18:44:06 UTC 2018
yes, but as your call is not bridged hangup has no effect.
so it's better to redirect to another context and/or extension
answering the call with an ivr saying "your credit is too low blablabla"
then hangup
On 1/15/2018 10:03 AM, igor.potjevlesch at gmail.com wrote:
>
> I'm wondering if there's not something wrong here:
>
> 2018-01-15 18:56:53.560265 [DEBUG] mod_nibblebill.c:430 Retrieved
> current balance for account 98 (balance = 0.000000)
>
> 782f5610-fa1d-11e7-933a-47832fb85dfe 2018-01-15 18:56:53.560265
> [DEBUG] mod_nibblebill.c:523 Comparing 0.000000 to hangup balance of
> 1.000000, taking into account minimum charge of 1.000000
>
> 782f5610-fa1d-11e7-933a-47832fb85dfe 2018-01-15 18:56:53.560265
> [DEBUG] mod_nibblebill.c:526 Balance of 0.000000 fell below allowed
> amount of 1.000000! (Account 98)
>
> 782bbabe-fa1d-11e7-9318-47832fb85dfe 2018-01-15 18:56:53.560265 [INFO]
> mod_dialplan_xml.c:637 Processing +123456789 ->hangup in context test
>
> According to the source code, the call is transferred to default
> "nobal_amt" which is "hangup". So the call is supposed to be stopped
> once this log is printed. Isn't it?
>
> *De :*igor.potjevlesch at gmail.com [mailto:igor.potjevlesch at gmail.com]
> *Envoyé :* lundi 15 janvier 2018 18:51
> *À :* 'FreeSWITCH Users Help' <freeswitch-users at lists.freeswitch.org>
> *Objet :* RE: [Freeswitch-users] Use Nibblebill with PostgreSQL
>
> Ah ok, I didn't know nibble_current_balance.
> So with something like that should work, but unfortunately not:
>
> <action application="set" data="nibble_account=98"/>
>
> <action application="set" data="nibble_rate=0.0115"/>
>
> <action application="set" data="nibble_minimum=1"/>
>
> <action application="set" data="nibble_rounding=2"/>
>
> <action application="set" data="heartbeat 1"/>
>
> <action application="set" data="nibble_current_balance" inline="true"/>
>
> <condition break="on-true" field="${cond(${nibble_current_balance} <=
> 0 ? YES : NO)}" expression="^YES$">
>
> <action application="hangup" data="hangup_cause"/>
>
> </condition>
>
> The call is processed whereas balance in DB is equal to 0.
>
> *De :*FreeSWITCH-users
> [mailto:freeswitch-users-bounces at lists.freeswitch.org] *De la part de*
> Madovsky
> *Envoyé :* lundi 15 janvier 2018 17:59
> *À :* 'FreeSWITCH Users Help' <freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at lists.freeswitch.org>>
> *Objet :* Re: [Freeswitch-users] Use Nibblebill with PostgreSQL
>
> > I don't understand what is supposed to do the SQL request? I think
> that, indeed, nibble_balance is not set at the moment of the condition.
>
> when you set the nibble account so nibblebill makes the SQL request
> you set in its config
>
> to populate nibble_current_balance, so if you make a condition with
> nibble_current_balance just after set nibble_account
>
> so you should set it inline to make the condition available
>
> On 1/15/2018 5:29 AM, igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> Hello,
>
> I'm still stuck with Nibblebill config. Even if the current
> balance is 0 or negative, the dialplan start the call.
>
> Someone would have some examples of config where this behaviour is
> avoided? Thank you!
>
> Regards,
>
> Igor.
>
> *De :*igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> [mailto:igor.potjevlesch at gmail.com]
> *Envoyé :* mercredi 10 janvier 2018 15:49
> *À :* 'Madovsky' <infos at madovsky.org> <mailto:infos at madovsky.org>
> *Objet :* RE: [Freeswitch-users] Use Nibblebill with PostgreSQL
>
> This is the log: Action log(INFO ${nibble_balance} is equal or
> lower than 0)
>
> With or without "set nibble_balance". So I guess that this
> variable is undefined.
>
> *De :*igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> [mailto:igor.potjevlesch at gmail.com]
> *Envoyé :* mercredi 10 janvier 2018 15:39
> *À :* 'Madovsky' <infos at madovsky.org <mailto:infos at madovsky.org>>
> *Objet :* RE: [Freeswitch-users] Use Nibblebill with PostgreSQL
>
> I don't understand what is supposed to do the SQL request? I think
> that, indeed, nibble_balance is not set at the moment of the
> condition.
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* mardi 9 janvier 2018 21:24
> *À :* igor.potjevlesch at gmail.com <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use Nibblebill with PostgreSQL
>
> you should remove
>
> <action application="set" data="nibble_balance" inline="true"/>
>
> since when you populate nibble_account it makes automatically the
> SQL request
> and populate nibble_balance.
> then don't forget to put all nibble variables on the bridge
> like {nibble_account=${nibble_account},etc.}sofia/xxx
>
> On 1/9/2018 8:14 AM, igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> I didn't. What does it mean "inline" in that case?
>
> I tried like this and add "inline" on all settings. So, now
> the dialplan looks like this:
>
> <action application="set"
> data="nibble_account=1" inline="true"/>
>
> <action application="set" data="nibble_rate=1"
> inline="true"/>
>
> <action application="set"
> data="nibble_minimum=1" inline="true"/>
>
> <action application="set"
> data="nibble_rounding=2" inline="true"/>
>
> <action application="set"
> data="nibble_balance" inline="true"/>
>
> <action application="nibblebill"
> data="heartbeat 1"/>
>
> <condition break="on-true"
> field="${cond(${nibble_balance} <= 0 ? YES : NO)}"
> expression="^YES$">
>
> <action application="log" data="INFO
> ${nibble_balance} is equal or lower than 0"/>
>
> </condition>
>
> <action application="bridge"
> data="{nibble_account=1,nibble_rate=1,nibble_minimum=1,nibble_rounding=2,absolute_codec_string=PCMA,101,sip_invite_domain=$${ext-sip-ip}}sofia/gateway/outbound/0$1"/>
>
> The logs are showing the following outputs and the call start:
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> set(nibble_account=1) INLINE
>
> 8d308628-f555-11e7-9064-df48dc662f2c EXECUTE
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> set(nibble_account=1)
>
> 8d308628-f555-11e7-9064-df48dc662f2c 2018-01-09
> 16:55:44.782489 [DEBUG] mod_dptools.c:1548 SET
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> [nibble_account]=[1]
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> set(nibble_rate=1) INLINE
>
> 8d308628-f555-11e7-9064-df48dc662f2c EXECUTE
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> set(nibble_rate=1)
>
> 8d308628-f555-11e7-9064-df48dc662f2c 2018-01-09
> 16:55:44.782489 [DEBUG] mod_dptools.c:1548 SET
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> [nibble_rate]=[1]
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> set(nibble_minimum=1) INLINE
>
> 8d308628-f555-11e7-9064-df48dc662f2c EXECUTE
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> set(nibble_minimum=1)
>
> 8d308628-f555-11e7-9064-df48dc662f2c 2018-01-09
> 16:55:44.782489 [DEBUG] mod_dptools.c:1548 SET
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> [nibble_minimum]=[1]
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> set(nibble_rounding=2) INLINE
>
> 8d308628-f555-11e7-9064-df48dc662f2c EXECUTE
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> set(nibble_rounding=2)
>
> 8d308628-f555-11e7-9064-df48dc662f2c 2018-01-09
> 16:55:44.782489 [DEBUG] mod_dptools.c:1548 SET
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> [nibble_rounding]=[2]
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> set(nibble_balance) INLINE
>
> 8d308628-f555-11e7-9064-df48dc662f2c EXECUTE
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> set(nibble_balance)
>
> 8d308628-f555-11e7-9064-df48dc662f2c 2018-01-09
> 16:55:44.782489 [DEBUG] mod_dptools.c:1548 SET
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D>
> [nibble_balance]=[UNDEF]
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> nibblebill(heartbeat 1)
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> bridge({nibble_account=1,nibble_rate=1,nibble_minimum=1,nibble_rounding=2,absolute_codec_string=PCMA,101,sip_invite_domain=}sofia/gateway/out/0123456789)
>
> 8d308628-f555-11e7-9064-df48dc662f2c |--- Dialplan:
> sofia/client_in/+123456789 at A.B.C.D
> <mailto:sofia/client_in/+123456789 at A.B.C.D> Action
> hangup(hangup_cause)
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* lundi 8 janvier 2018 19:52
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use Nibblebill with PostgreSQL
>
> did you set nibble balance inline="true" before the condition?
>
> also check with log just after you set the var to be sure the
> SQL return a value
>
> On 1/8/2018 10:24 AM, igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> I basically tried this:
>
> <condition break="on-true" field="${cond(${nibble_balance}
> <= 0 ? YES : NO)}" expression="^YES$">
>
> <action application="log"
> data="INFO ${nibble_balance} is equal or lower than 0"/>
>
> </condition>
>
> But I didn't see anything in the logs, the call begin to
> start.
>
> Regards,
>
> Igor
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* vendredi 5 janvier 2018 14:44
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use Nibblebill with
> PostgreSQL
>
> Yes in a nested condition for ex.
>
> this method is more robust that trust nibblebill to do all
> the job
>
> On 1/5/2018 5:33 AM, igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> It means that I can test ${nibble_balance} before right?
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* jeudi 4 janvier 2018 20:31
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use Nibblebill with
> PostgreSQL
>
> you should make a nested condition before the bridge
>
> and if the balance not good transfer the call to
> hangup or something else
>
> On 1/4/2018 8:03 AM, igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> I uncommented this in the config file of nibblebill:
>
> <param name="custom_sql_lookup" value="SELECT
> euros AS nibble_balance FROM solde WHERE
> customer_id='${nibble_account}'"/>
>
> The request is working fine according to the logs,
> but the call is still placed with the logs:
>
> 2018-01-04 16:59:07.571051 [DEBUG]
> mod_nibblebill.c:422 Doing lookup query
>
> [SELECT euros AS nibble_balance FROM solde WHERE
> customer_id='1']
>
> 2018-01-04 16:59:07.571051 [DEBUG]
> mod_nibblebill.c:430 Retrieved current balance for
> account 1 (balance = -0.040000)
>
> 31fe25c6-f168-11e7-a065-b10720ff818b 2018-01-04
> 16:59:07.571051 [DEBUG] mod_nibblebill.c:523
> Comparing -0.040000 to hangup balance of 1.000000,
> taking into account minimum charge of 1.000000
>
> 31fe25c6-f168-11e7-a065-b10720ff818b 2018-01-04
> 16:59:07.571051 [DEBUG] mod_nibblebill.c:526
> Balance of -0.040000 fell below allowed amount of
> 1.000000! (Account 1)
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* jeudi 4 janvier 2018 16:37
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use Nibblebill
> with PostgreSQL
>
> add an sql request into nibblebill and link it to
> nibble_balance variables inline in diaplan
>
> On 1/4/2018 7:35 AM, igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> Yes, why not, but I don't find how to check
> the balance before a bridge.
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* jeudi 4 janvier 2018 16:29
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use
> Nibblebill with PostgreSQL
>
> it starts because you don't have any user
> linked to your nibble_account
>
> so the only way to not start the call is to
> create a condition with the nibble balance before
>
> the bridge
>
> On 1/4/2018 7:22 AM,
> igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> I did this:
>
> dca705f8-f161-11e7-9f81-b10720ff818b |---
> Dialplan: sofia/trunk1/+4425482090 at A.B.C.D
> <mailto:sofia/trunk1/+4425482090 at A.B.C.D>
> Action set(nibble_account=1)
>
> dca705f8-f161-11e7-9f81-b10720ff818b |---
> Dialplan: sofia/trunk1
> /+4425482090 at A.B.C.D
> <mailto:/+4425482090 at A.B.C.D> Action
> set(nibble_rate=1)
>
> dca705f8-f161-11e7-9f81-b10720ff818b |---
> Dialplan: sofia/trunk1/+4425482090 at A.B.C.D
> <mailto:sofia/trunk1/+4425482090 at A.B.C.D>
> Action set(nibble_minimum=1)
>
> dca705f8-f161-11e7-9f81-b10720ff818b |---
> Dialplan: sofia/trunk1/+4425482090 at A.B.C.D
> <mailto:sofia/trunk1/+4425482090 at A.B.C.D>
> Action set(nibble_rounding=2)
>
> dca705f8-f161-11e7-9f81-b10720ff818b |---
> Dialplan: sofia/trunk1/+4425482090 at A.B.C.D
> <mailto:sofia/trunk1/+4425482090 at A.B.C.D>
> Action nibblebill(heartbeat 1)
>
> dca705f8-f161-11e7-9f81-b10720ff818b |---
> Dialplan: sofia/trunk1/+4425482090 at A.B.C.D
> <mailto:sofia/trunk1/+4425482090 at A.B.C.D>
> Action
> bridge({nibble_account=1,nibble_rate=1,nibble_minimum=1,nibble_rounding=2,absolute_codec_string=PCMA,101,sip_invite_domain=}sofia/gateway/out_1/0123456789)
>
> […]
>
> 2018-01-04 16:13:47.410971 [DEBUG]
> mod_nibblebill.c:430 Retrieved current
> balance for account 1 (balance = 0.000000)
>
> dca7b05c-f161-11e7-9f9a-b10720ff818b
> 2018-01-04 16:13:47.410971 [DEBUG]
> mod_nibblebill.c:523 Comparing 0.000000 to
> hangup balance of 1.000000, taking into
> account minimum charge of 1.000000
>
> dca7b05c-f161-11e7-9f9a-b10720ff818b
> 2018-01-04 16:13:47.410971 [DEBUG]
> mod_nibblebill.c:526 Balance of 0.000000
> fell below allowed amount of 1.000000!
> (Account 1)
>
> But the call still starts.
>
> *De :*Madovsky [mailto:infos at madovsky.org]
> *Envoyé :* jeudi 4 janvier 2018 16:09
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use
> Nibblebill with PostgreSQL
>
> the nibblebill variables must be on the
> bridge like
>
> <action application="bridge"
> data="{nibble_account=1,nibble_rate=1,etc....absolute_codec_string=PCMA,101,sip_invite_domain=$${ext-sip-ip}}sofia/gateway/out_01/0$1"/>
>
> do not use "export" since I noticed some
> strange behavior with it.
> I don't know how nibblebill behaves
> without a nibble_account linked to a user
> account,
> so I cannot help for this case
>
> On 1/4/2018 7:06 AM,
> igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> I don't have a registered user. It's a
> peer trusted by his IP address.
>
> During the call the credit is updated
> every seconds but even without credit,
> the call start and stop immediately.
>
> Yes I know. I will switch to more
> reasonable value after my tests.
>
> What do you mean by "export all
> nibblebill variables to the bridge"?
>
> *De :*Madovsky
> [mailto:infos at madovsky.org]
> *Envoyé :* jeudi 4 janvier 2018 15:52
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users] Use
> Nibblebill with PostgreSQL
>
> > <action application="set"
> data="nibble_account=1"/>
>
> is 1 a valid nibble_account of a
> registered user?
>
> > <action application="nibblebill" data="check"/>
>
> you dont' need to check, as nibblebill
> automatically check the balance
>
> if the nibble_account is linked to a
> registered user
>
> > <action application="nibblebill"
> data="heartbeat 1"/>
>
> be aware that heartbeat to 1 means a
> request to your DB every second
>
> about your issue you should export all
> nibblebill variables to the bridge too
>
> On 1/4/2018 6:46 AM,
> igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com> wrote:
>
> That's the case:
>
> <condition
> break="on-true"
> expression="^\+44([1-9][0-9]{8})$"
> field="destination_number">
>
> <action
> application="set"
> data="nibble_account=1"/>
>
> <action
> application="nibblebill"
> data="check"/>
>
> <action
> application="set"
> data="nibble_rate=1"/>
>
> <action
> application="set"
> data="nibble_minimum=1"/>
>
> <action
> application="set"
> data="nibble_rounding=2"/>
>
> <action
> application="nibblebill"
> data="heartbeat 1"/>
>
> <action
> application="bridge"
> data="{absolute_codec_string=PCMA,101,sip_invite_domain=$${ext-sip-ip}}sofia/gateway/out_01/0$1"/>
>
> <action
> application="hangup"
> data="hangup_cause"/>
>
> </condition>
>
> *De :*Madovsky
> [mailto:infos at madovsky.org]
> *Envoyé :* jeudi 4 janvier 2018 12:41
> *À :* igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> *Objet :* Re: [Freeswitch-users]
> Use Nibblebill with PostgreSQL
>
> you must check or set
> nibble_account before the call
>
> On 1/4/2018 3:35 AM,
> igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> wrote:
>
> Hello,
>
> Finally the billing works
> good. Would it be possible to
> setup the rates in db? I don't
> find example or documentation
> related to this.
>
> Also, I don't understand why
> the call is allowed for
> bridging whereas the balance
> is 0 or negative?
>
> Regards,
>
> Igor.
>
> *De :*igor.potjevlesch at gmail.com
> <mailto:igor.potjevlesch at gmail.com>
> [mailto:igor.potjevlesch at gmail.com]
>
> *Envoyé :* jeudi 4 janvier
> 2018 10:19
> *À :* 'FreeSWITCH Users Help'
> <freeswitch-users at lists.freeswitch.org>
> <mailto:freeswitch-users at lists.freeswitch.org>
> *Objet :* RE:
> [Freeswitch-users] Use
> Nibblebill with PostgreSQL
>
> Hello,
>
>
> Thank you!
>
> Both db_dsn and odbc-dsn work.
> db-dsn fails.
>
> I keep the version with
> odbc-dsn because in that case
> I don't have the warning about
> deprecated function for
> versions earlier than 1.4.2
> even if I run 1.6.
>
> What is the best according to
> you? db_dsn or odbc-dsn?
>
> I have additional questions
> related to nibble:
>
> 1. After hanging up the call,
> I see in the logs the good
> value:
> "mod_nibblebill.c:590
> Billing $0.000234" but
> some line after there is
> another update:
> "mod_nibblebill.c:622
> Rounding to precision
> 1.000000, total 1.000000
> (0.999793 excess)". So the
> call is billed 1 instead
> of 0.000234.
> 2. Is it possible to setup in
> the db scheme different
> prefixes and their rate?
> Instead of putting them
> raw in the dialplan or any
> other config file?
>
> Thank you in advance for your
> clarification.
>
> Regards,
>
> Igor.
>
> *De :*FreeSWITCH-users
> [mailto:freeswitch-users-bounces at lists.freeswitch.org]
> *De la part de* Madovsky
> *Envoyé :* mercredi 3 janvier
> 2018 22:18
> *À :*
> freeswitch-users at lists.freeswitch.org
> <mailto:freeswitch-users at lists.freeswitch.org>
> *Objet :* Re:
> [Freeswitch-users] Use
> Nibblebill with PostgreSQL
>
> 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
> <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/20180115/11af10e8/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list