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

[king2kin]

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>
>To: 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
http://www.freeswitch.org

_________________________________________________________________________
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/20111218/5177a529/attachment.html