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

[Peter Olsson]

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 at lists.freeswitch.org [mailto:freeswitch-users-bounces at 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 at visionutveckling.se<mailto:peter.olsson at visionutveckling.se>>
To: "freeswitch-users at lists.freeswitch.org<mailto:freeswitch-users at lists.freeswitch.org>" <freeswitch-users at lists.freeswitch.org<mailto: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<mailto: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<mailto: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<mailto:brian at freeswitch.org>>
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org<mailto: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><mailto:jeff at jefflenk.com<mailto:jeff at jefflenk.com>>>
To: freeswitch-users at lists.freeswitch.org<mailto:freeswitch-users at lists.freeswitch.org><mailto: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><mailto:brian at freeswitch.org<mailto:brian at freeswitch.org>>
http://www.freeswitch.org<http://www.freeswitch.org/>


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org<mailto:consulting at freeswitch.org><mailto:consulting at freeswitch.org<mailto:consulting at freeswitch.org>>
http://www.freeswitchsolutions.com<http://www.freeswitchsolutions.com/><http://www.freeswitchsolutions.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 at lists.freeswitch.org<mailto:FreeSWITCH-users at lists.freeswitch.org><mailto: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/><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:4ef1f26932769813811637!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111221/098fcfd1/attachment.html