Hello, is there a chance to have sofia_reg_external in odbc/mysql instead of sqlite? In a B2BUA environment we have thousand of external registrations during a migration phase, and it would be good to have easy external control over the registered gateways (like in fs_internal. sip_registrations). Best regards Peter
<param name="odbc-dsn" value="dsn:user:pass"/> On the profile. /b On Aug 30, 2009, at 5:25 PM, Peter P GMX wrote:
Hello,
is there a chance to have sofia_reg_external in odbc/mysql instead of sqlite? In a B2BUA environment we have thousand of external registrations during a migration phase, and it would be good to have easy external control over the registered gateways (like in fs_internal. sip_registrations).
Best regards Peter
Hello Brian, I've done this. FS creates the tables sccessfully, but then doesn't fill them. isql: SQL> show tables; +-----------------------------------------------------------------+ | Tables_in_fs_external | +-----------------------------------------------------------------+ | sip_authentication | | sip_dialogs | | sip_presence | | sip_registrations | | sip_shared_appearance_dialogs | | sip_shared_appearance_subscriptions | | sip_subscriptions | +-----------------------------------------------------------------+ SQLRowCount returns 7 7 rows fetched Is that right, that the tables have the same structure as for the internal database? "sofia status" shows 7 registered external gateways, but none of them is shown in the ODBC database. All tables are empty. Any idea? Best regrads Peter Brian West schrieb:
<param name="odbc-dsn" value="dsn:user:pass"/>
On the profile.
/b
On Aug 30, 2009, at 5:25 PM, Peter P GMX wrote:
Hello,
is there a chance to have sofia_reg_external in odbc/mysql instead of sqlite? In a B2BUA environment we have thousand of external registrations during a migration phase, and it would be good to have easy external control over the registered gateways (like in fs_internal. sip_registrations).
Best regards Peter
_______________________________________________ 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
gateways do not go into the table... ONLY inbound registrations to the profile do. /b On Sep 1, 2009, at 5:16 AM, Peter P GMX wrote:
Hello Brian,
I've done this. FS creates the tables sccessfully, but then doesn't fill them. isql: SQL> show tables; +-----------------------------------------------------------------+ | Tables_in_fs_external | +-----------------------------------------------------------------+ | sip_authentication | | sip_dialogs | | sip_presence | | sip_registrations | | sip_shared_appearance_dialogs | | sip_shared_appearance_subscriptions | | sip_subscriptions | +-----------------------------------------------------------------+ SQLRowCount returns 7 7 rows fetched
Is that right, that the tables have the same structure as for the internal database?
"sofia status" shows 7 registered external gateways, but none of them is shown in the ODBC database. All tables are empty. Any idea?
Best regrads Peter
participants (2)
-
Brian West
-
Peter P GMX