[Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)

king2kin xing2kin at yahoo.com
Wed Dec 21 17:50:43 MSK 2011


No, I didn't remove any tables. I just compiled and run it with few settings updated (e.g. sounds, odbc).


From: Peter Olsson <peter.olsson at visionutveckling.se>
To: "freeswitch-users at lists.freeswitch.org" <freeswitch-users at lists.freeswitch.org> 
Sent: Monday, December 19, 2011 2:50 PM
Subject: Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)

Did you try to remove all tables, so FS can create everything from scratch?

/Peter

----- Reply message -----
Från: "king2kin" <xing2kin at yahoo.com>
Datum: mån, dec 19, 2011 07:11
Rubrik: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)
Till: "FreeSWITCH Users Help" <freeswitch-users at lists.freeswitch.org>

No, this occurs on the latest GIT version of freeswitch that I downloaded on Dec. 18, 2011 by command:
{
git clone git://git.freeswitch.org/freeswitch.git
}

The early GIT version (e.g. 2011-08-31) doesn't have such problems.

The latest version can run on windows 2003, but keep printing out error messages in freeswitch.log and console, for example:

[DEBUG] switch_core_sqldb.c:890 SQL ERR [no such table: sip_registrations]
[delete from sip_registrations where (contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='W2k3T602' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']
Auto Generating Table!

[DEBUG] switch_core_sqldb.c:897 SQL ERR [no such table: sip_subscriptions]
[DEBUG] switch_core_sqldb.c:897 SQL ERR [no such table: sip_presence]
[DEBUG] switch_core_sqldb.c:890 SQL ERR [no such table: sip_dialogs]
......

also, while running  the new version of freeswitch, the following error messages keep coming up in freeswitch.log:
{
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it
}

From: Brian West <brian at freeswitch.org>
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
Sent: Monday, December 19, 2011 9:24 AM
Subject: Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)

You're using a very old version of FreeSWITCH... why ?

/b

On Dec 18, 2011, at 7:11 PM, king2kin wrote:

No, these tables were not created automatically by freeswitch on windows 2003 while MySQL is running.
During the past three months, I had been playing around the GIT version of 2011-08-31, whose log file [freeswitch.log] didn't complain those database tables that I listed in my previous email.

It seems to me that these db tables come up only in more recent GIT version.
From: Jeff Lenk <jeff at jefflenk.com<mailto:jeff at jefflenk.com>>
To: freeswitch-users at lists.freeswitch.org<mailto:freeswitch-users at lists.freeswitch.org>
Sent: Monday, December 19, 2011 1:30 AM
Subject: Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)

All the required tables should be created on first run. Same as always. Is
that not happening?

--
Brian West
FreeSWITCH Solutions, LLC
Phone: +1 (918) 420-9266
Fax:  +1 (918) 420-9267
brian at freeswitch.org<mailto:brian at freeswitch.org>
http://www.freeswitch.org


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


</>

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


!DSPAM:4eeed36a32763536013952!

_________________________________________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111221/3df240d5/attachment-0001.html 


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