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@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@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@freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@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@jefflenk.com<mailto:jeff@jefflenk.com>> To: freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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@freeswitch.org<mailto:brian@freeswitch.org> http://www.freeswitch.org _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com<http://www.freeswitchsolutions.com/> FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com<http://www.cudatel.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@lists.freeswitch.org<mailto:FreeSWITCH-users@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!
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@visionutveckling.se> To: "freeswitch-users@lists.freeswitch.org" <freeswitch-users@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@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@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@freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@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@jefflenk.com<mailto:jeff@jefflenk.com>> To: freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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@freeswitch.org<mailto:brian@freeswitch.org> http://www.freeswitch.org _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com<http://www.freeswitchsolutions.com/> FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com<http://www.cudatel.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@lists.freeswitch.org<mailto:FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
So... That's a good start then - just to see if it's created correctly. It's supposed to auto-recreate everything though. /Peter Från: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] För king2kin Skickat: den 21 december 2011 15:51 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] Where are table definitions of database for freewsitch (latest GIT version) 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@visionutveckling.se<mailto:peter.olsson@visionutveckling.se>> To: "freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@lists.freeswitch.org>" <freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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@yahoo.com<mailto:xing2kin@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@lists.freeswitch.org<mailto:freeswitch-users@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@freeswitch.org<mailto:brian@freeswitch.org>> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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@jefflenk.com<mailto:jeff@jefflenk.com><mailto:jeff@jefflenk.com<mailto:jeff@jefflenk.com>>> To: freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@lists.freeswitch.org><mailto:freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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@freeswitch.org<mailto:brian@freeswitch.org><mailto:brian@freeswitch.org<mailto:brian@freeswitch.org>> http://www.freeswitch.org<http://www.freeswitch.org/> _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org><mailto:consulting@freeswitch.org<mailto:consulting@freeswitch.org>> http://www.freeswitchsolutions.com<http://www.freeswitchsolutions.com/><http://www.freeswitchsolutions.com/> FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com<http://www.cudatel.com/><http://www.cudatel.com/> Official FreeSWITCH Sites http://www.freeswitch.org<http://www.freeswitch.org/><http://www.freeswitch.org/> http://wiki.freeswitch.org<http://wiki.freeswitch.org/><http://wiki.freeswitch.org/> http://www.cluecon.com<http://www.cluecon.com/><http://www.cluecon.com/> FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org><mailto:FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@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/><http://www.freeswitch.org/> _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com<http://www.freeswitchsolutions.com/> FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com<http://www.cudatel.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@lists.freeswitch.org<mailto:FreeSWITCH-users@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:4ef1f26932769813811637!
participants (2)
-
king2kin
-
Peter Olsson