<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, this occurs on the latest GIT version of freeswitch that I downloaded on Dec. 18, 2011 by command:</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">{</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"> git clone git://git.freeswitch.org/freeswitch.git </SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">}</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div><SPAN style="RIGHT: auto">
<div style="RIGHT: auto">The early GIT version (e.g. 2011-08-31) doesn't have such problems.<BR style="RIGHT: auto"></div></SPAN>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">The latest version can run on windows 2003, but keep printing out error messages in freeswitch.log and console, for example:</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">[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!</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">[DEBUG] switch_core_sqldb.c:897 SQL ERR [no such table: sip_subscriptions]</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">[DEBUG] switch_core_sqldb.c:897 SQL ERR [no such table: sip_presence]</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">[DEBUG] switch_core_sqldb.c:890 SQL ERR [no such table: sip_dialogs]</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">......</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">also, while running the new version of freeswitch, the following error messages keep coming<VAR id=yui-ie-cursor></VAR> up in freeswitch.log:</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">{</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">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</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">}</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </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><FONT size=3 face="Times New Roman"></FONT>
<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> Brian West <brian@freeswitch.org><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, December 19, 2011 9:24 AM<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>
<DIV style="RIGHT: auto" id=yiv1887292878>
<DIV style="RIGHT: auto">You're using a very old version of FreeSWITCH... why ?
<DIV><BR></DIV>
<DIV>/b</DIV>
<DIV style="RIGHT: auto"><BR>
<DIV>
<DIV>On Dec 18, 2011, at 7:11 PM, king2kin wrote:</DIV><BR class=yiv1887292878Apple-interchange-newline>
<BLOCKQUOTE type="cite"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; WORD-SPACING: 0px" class=yiv1887292878Apple-style-span>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" rel=nofollow target=_blank ymailto="mailto:jeff@jefflenk.com">jeff@jefflenk.com</A>><BR>To:<SPAN class=yiv1887292878Apple-converted-space> </SPAN><A href="mailto:freeswitch-users@lists.freeswitch.org" rel=nofollow target=_blank
ymailto="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A><SPAN class=yiv1887292878Apple-converted-space> </SPAN><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?</SPAN></BLOCKQUOTE></DIV><BR>
<DIV style="RIGHT: auto"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 16px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px" class=yiv1887292878Apple-style-span><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 16px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px" class=yiv1887292878Apple-style-span>
<DIV style="WORD-WRAP: break-word">
<DIV>
<DIV>-- </DIV>
<DIV>Brian West </DIV>
<DIV>FreeSWITCH Solutions, LLC</DIV>
<DIV>Phone: +1 (918) 420-9266 </DIV>
<DIV>Fax: +1 (918) 420-9267</DIV>
<DIV><A href="mailto:brian@freeswitch.org" rel=nofollow target=_blank ymailto="mailto:brian@freeswitch.org">brian@freeswitch.org</A></DIV>
<DIV>http://www.freeswitch.org</DIV></DIV></DIV></SPAN></SPAN></DIV><BR></DIV></DIV></DIV><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>