<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">No, I didn't remove any tables. I just compiled and run it with few settings updated (e.g. sounds, odbc).<VAR id=yui-ie-cursor></VAR><BR style="RIGHT: auto" class=yui-cursor></SPAN></div>
<div><BR></div>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Arial>
<DIV style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class=hr readonly="true" contenteditable="false"></DIV><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Peter Olsson <peter.olsson@visionutveckling.se><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> "freeswitch-users@lists.freeswitch.org" <freeswitch-users@lists.freeswitch.org> <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, December 19, 2011 2:50 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)<BR></FONT><BR>Did you try to remove all tables, so FS can create everything from scratch?<BR><BR>/Peter<BR><BR>----- Reply message -----<BR>Från:
"king2kin" <<A href="mailto:xing2kin@yahoo.com" ymailto="mailto:xing2kin@yahoo.com">xing2kin@yahoo.com</A>><BR>Datum: mån, dec 19, 2011 07:11<BR>Rubrik: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)<BR>Till: "FreeSWITCH Users Help" <<A href="mailto:freeswitch-users@lists.freeswitch.org" ymailto="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A>><BR><BR>No, this occurs on the latest GIT version of freeswitch that I downloaded on Dec. 18, 2011 by command:<BR>{<BR>git clone git://git.freeswitch.org/freeswitch.git<BR>}<BR><BR>The early GIT version (e.g. 2011-08-31) doesn't have such problems.<BR><BR>The latest version can run on windows 2003, but keep printing out error messages in freeswitch.log and console, for example:<BR><BR>[DEBUG] switch_core_sqldb.c:890 SQL ERR [no such table: sip_registrations]<BR>[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 '%']<BR>Auto Generating Table!<BR><BR>[DEBUG] switch_core_sqldb.c:897 SQL ERR [no such table: sip_subscriptions]<BR>[DEBUG] switch_core_sqldb.c:897 SQL ERR [no such table: sip_presence]<BR>[DEBUG] switch_core_sqldb.c:890 SQL ERR [no such table: sip_dialogs]<BR>......<BR><BR>also, while running the new version of freeswitch, the following error messages keep coming up in freeswitch.log:<BR>{<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip
it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18
03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>2011-12-18 03:21:13.578125 [WARNING] switch_xml.c:2328 Invalid UTF-8 character to ampersand, skip it<BR>}<BR><BR>From: Brian West <<A href="mailto:brian@freeswitch.org" ymailto="mailto:brian@freeswitch.org">brian@freeswitch.org</A>><BR>To: FreeSWITCH Users Help <<A href="mailto:freeswitch-users@lists.freeswitch.org" ymailto="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A>><BR>Sent: Monday, December 19, 2011 9:24 AM<BR>Subject: Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)<BR><BR>You're using a very old version of FreeSWITCH... why ?<BR><BR>/b<BR><BR>On Dec 18, 2011, at 7:11 PM, king2kin wrote:<BR><BR>No, these tables were not created automatically by freeswitch on windows 2003 while MySQL is running.<BR>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.<BR><BR>It seems to me that these db tables come up only in more recent GIT version.<BR>From: Jeff Lenk <<A href="mailto:jeff@jefflenk.com" ymailto="mailto:jeff@jefflenk.com">jeff@jefflenk.com</A><mailto:<A href="mailto:jeff@jefflenk.com" ymailto="mailto:jeff@jefflenk.com">jeff@jefflenk.com</A>>><BR>To: <A href="mailto:freeswitch-users@lists.freeswitch.org" ymailto="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A><mailto:<A href="mailto:freeswitch-users@lists.freeswitch.org" ymailto="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A>><BR>Sent: Monday, December 19, 2011 1:30 AM<BR>Subject: Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version)<BR><BR>All the required tables should be
created on first run. Same as always. Is<BR>that not happening?<BR><BR>--<BR>Brian West<BR>FreeSWITCH Solutions, LLC<BR>Phone: +1 (918) 420-9266<BR>Fax: +1 (918) 420-9267<BR><A href="mailto:brian@freeswitch.org" ymailto="mailto:brian@freeswitch.org">brian@freeswitch.org</A><mailto:<A href="mailto:brian@freeswitch.org" ymailto="mailto:brian@freeswitch.org">brian@freeswitch.org</A>><BR><A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org</A><BR><BR><BR>_________________________________________________________________________<BR>Professional FreeSWITCH Consulting Services:<BR><A href="mailto:consulting@freeswitch.org" ymailto="mailto:consulting@freeswitch.org">consulting@freeswitch.org</A><mailto:<A href="mailto:consulting@freeswitch.org" ymailto="mailto:consulting@freeswitch.org">consulting@freeswitch.org</A>><BR><A href="http://www.freeswitchsolutions.com/"
target=_blank>http://www.freeswitchsolutions.com</A><<A href="http://www.freeswitchsolutions.com/" target=_blank>http://www.freeswitchsolutions.com/</A>><BR><BR>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR><A href="http://www.cudatel.com/" target=_blank>http://www.cudatel.com</A><<A href="http://www.cudatel.com/" target=_blank>http://www.cudatel.com/</A>><BR><BR>Official FreeSWITCH Sites<BR><A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org</A><<A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org/</A>><BR><A href="http://wiki.freeswitch.org/" target=_blank>http://wiki.freeswitch.org</A><<A href="http://wiki.freeswitch.org/" target=_blank>http://wiki.freeswitch.org/</A>><BR><A href="http://www.cluecon.com/" target=_blank>http://www.cluecon.com</A><<A href="http://www.cluecon.com/" target=_blank>http://www.cluecon.com/</A>><BR><BR>FreeSWITCH-users mailing
list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org" ymailto="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><mailto:<A href="mailto:FreeSWITCH-users@lists.freeswitch.org" ymailto="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A>><BR><A href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org</A><<A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org/</A>><BR><BR><BR>!DSPAM:4eeed36a32763536013952!<BR><BR>_________________________________________________________________________<BR>Professional
FreeSWITCH Consulting Services:<BR><A href="mailto:consulting@freeswitch.org" ymailto="mailto:consulting@freeswitch.org">consulting@freeswitch.org</A><BR><A href="http://www.freeswitchsolutions.com/" target=_blank>http://www.freeswitchsolutions.com</A><BR><BR>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR><A href="http://www.cudatel.com/" target=_blank>http://www.cudatel.com</A><BR><BR>Official FreeSWITCH Sites<BR><A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org</A><BR><A href="http://wiki.freeswitch.org/" target=_blank>http://wiki.freeswitch.org</A><BR><A href="http://www.cluecon.com/" target=_blank>http://www.cluecon.com</A><BR><BR>FreeSWITCH-users mailing list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org" ymailto="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR><A href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A href="http://www.freeswitch.org/" target=_blank>http://www.freeswitch.org</A><BR><BR><BR></DIV></DIV></div></body></html>