Hi All I have 3 sofia profiles. Two of them are using sqlite, and one is using odbc. Whenever I restart a profile that is using sqlite, I get the following error: 2009-12-31 00:29:56.914495 [ERR] switch_core_db.c:109 SQL ERR [table sip_shared_appearance_dialogs has no column named network_ip] I'm on version FreeSWITCH Version 1.0.trunk (16055) I did a checkout from trunk and switch_core_db.c hasn't changed from the version I have, so I didn't bother to recompile. Thoughts? Thanks! Bill
delete all the files in your /usr/local/freeswitch/db and rebuild trunk and try again. On Wed, Dec 30, 2009 at 11:53 PM, Bill W. <freeswitch@aastral.net> wrote:
Hi All
I have 3 sofia profiles. Two of them are using sqlite, and one is using odbc.
Whenever I restart a profile that is using sqlite, I get the following error:
2009-12-31 00:29:56.914495 [ERR] switch_core_db.c:109 SQL ERR [table sip_shared_appearance_dialogs has no column named network_ip]
I'm on version FreeSWITCH Version 1.0.trunk (16055)
I did a checkout from trunk and switch_core_db.c hasn't changed from the version I have, so I didn't bother to recompile.
Thoughts?
Thanks! Bill
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
Worked! Was that a one-time thing or do I need to blow away the sqlite database every time I upgrade? Or more generally, how does FreeSWITCH handle database updates and what should the procedures be to ensure the database remains current and no data is lost by having to remove database files? Thanks! Bill Anthony Minessale wrote:
delete all the files in your /usr/local/freeswitch/db and rebuild trunk and try again.
usually it does a test and erases the table and recreates it when need be. On Thu, Dec 31, 2009 at 1:07 PM, Bill W <freeswitch@aastral.net> wrote:
Worked!
Was that a one-time thing or do I need to blow away the sqlite database every time I upgrade?
Or more generally, how does FreeSWITCH handle database updates and what should the procedures be to ensure the database remains current and no data is lost by having to remove database files?
Thanks! Bill
Anthony Minessale wrote:
delete all the files in your /usr/local/freeswitch/db and rebuild trunk and try again.
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
participants (3)
-
Anthony Minessale
-
Bill W
-
Bill W.