[Freeswitch-users] Core.db MSSQL

Andre andretodd at verizon.net
Fri Mar 29 17:59:07 MSK 2013


Aww, 

Wrong:

  <param name="core-db-dsn" value="dsn:sqldb::" />  

Correct:

  <param name="core-db-dsn" value="sqldb::" />  

 

You guys rock!

 

From: Andre [mailto:andretodd at verizon.net] 
Sent: Friday, March 29, 2013 10:54 AM
To: 'FreeSWITCH Users Help'
Subject: RE: [Freeswitch-users] Core.db MSSQL

 

I went back to ODBC Administrator.

Added a new ODBC Driver 11 for SQL Server 32 bit

Named it sqldb

Changed the default database to a blank database called freeswitch no
password needed.

Tested good. 

Now I changed the config to the below.

 

 

    <param name="auto-create-schemas" value="true"/>

    <param name="auto-clear-sql" value="true"/>

      <param name="core-dbtype" value="MSSQL"/>  

  <param name="core-db-dsn" value="dsn:sqldb::" />  

 

Restarted freeswitch.

Looked in my sqldb and no tables found in the freeswitch db.

 

Do I have to load anything in the modules?

 

 

 

From: freeswitch-users-bounces at lists.freeswitch.org
<mailto:freeswitch-users-bounces at lists.freeswitch.org>
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Ken Rice
Sent: Friday, March 29, 2013 10:34 AM
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Core.db MSSQL

 

  <param name="core-db-dsn" value="dsn:sqldb::" />  

Shouldn't that be odbc://DSN_NAME::    

On 3/29/13 8:15 AM, "Andre" <andretodd at verizon.net> wrote:

I'm trying to figure out how to get the Core.db into a Microsoft SQL Server.

In Switch.config.xml have 
 
<param name="auto-create-schemas" value="true"/>
    <param name="auto-clear-sql" value="true"/>
<param name="core-dbtype" value="MSSQL"/>  
   <param name="core-db-dsn" value="dsn:sqldb::" />  
 
I have a DNS setup called sqldb using ODBC DRIVER 11 FOR SQL SERVER.
 
I don't see anything happening and I don't see a database structure being
built.
What did I do wrong?
Thanks
Andre


  _____  


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org
http://www.freeswitchsolutions.com




Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.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


-- 
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130329/d74b7ab1/attachment-0001.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list