[Freeswitch-users] Freeswitch 1.10.X mod_limit db configuration

[Volodymyr Fedorov]

Hi Andrey,
Thank you for given example. Works like a charm now!

BR,
Vova

On Mon, Nov 11, 2019 at 9:33 PM Andrey Wolk <andywolk at gmail.com> wrote:
>
> Since it's a regex
> "^pgsql|^odbc|^sqlite|[^:]+:[^:]*:.*"
> "dsn:username:password"
>
> Try adding : at the end of the value.
>
> <param name="odbc-dsn"
> value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=fsgreat!;:"/>
>
>>
>> From: Volodymyr Fedorov <lexxua at gmail.com>
>> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
>> Cc:
>> Bcc:
>> Date: Mon, 11 Nov 2019 09:25:23 +0100
>> Subject: [Freeswitch-users] Freeswitch 1.10.X mod_limit db configuration
>> Hi I need some help from community, I have a question regarding
>> mod_limit db configuration in modern freeswitch release where we have
>> new db drivers.
>> I tried to use following construction:
>> <configuration name="db.conf" description="LIMIT DB Configuration">
>>   <settings>
>>     <param name="odbc-dsn"
>> value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=fsgreat!;"/>
>>   </settings>
>> </configuration>
>>
>> When I try to load mod_db I`m getting following error:
>> 2019-11-11 09:22:11.813986 [ERR] switch_xml_config.c:267 Invalid value
>> [mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=fsgreat!;]
>> for parameter [odbc-dsn]
>> freeswitch at loopkam>
>> Item name: [odbc-dsn]
>> Type: string (optional)
>> Syntax: dsn:username:password
>> Help: If set, the ODBC DSN used by the limit and db applications
>>
>> I have following version installed:
>> FreeSWITCH (Version 1.10.1 -release-12-f9990221e6 64bit) is ready
>>
>> Thanks for advices!
>> --
>> Best regards,
>> Volodymyr
>
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time https://signalwire.community
>
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://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
> https://freeswitch.com



-- 
Best regards,
Volodymyr