[Freeswitch-users] Setting up mod_lcr

[Sergey Okhapkin]

mod_lcr uses ODBC, but not direct connection to mysql server. You need to 
configure ODBC to point to your mysql server.

On Monday 26 July 2010, Randall Degges wrote:
> Hi everyone,
> 
> I've now got freeswitch installed and running (thanks to everyone who
>  helped out with my previous email question), and now I'm working on
>  configuring mod_lcr, for least cost routing.
> 
> I've got the module compiled into freeswitch successfully, the problem I'm
> having is trying to configure the lcr.conf.xml file correctly.
> 
> I've created a MySQL database on localhost (for simplicity purposes), and
> created a database called freeswitch, as well as a user 'freeswitch' with a
> password 'freeswitch' who has access to that database.
> 
> DB: freeswitch
> User: freeswitch
> Pass: freeswitch
> 
> In the <settings> xml section, the paramater value looks like:
> 
> <param name="odbc-dsn" value="freeswitch-mysql:freeswitch:Fr33Sw1tch"/>
> 
> Which, according to the documentation (
> http://wiki.freeswitch.org/wiki/Mod_lcr#Installing), is the only thing I
> need to edit to get LCR to connect to my database, and prepare for using
>  it. However, this value line doesn't contain any sort of IP address to the
>  MySQL db, or database name. It looks like it only has options for a
>  username and password.
> 
> What do I need to do to correctly specify my database values for mod_lcr to
> use?
> 
> Thanks!
> 
> -Randall
>