Missing tables in the core database

FreeSWITCH Troubleshooting
,
1

Hello everyone,

I can’t seem to get these items in my database:

 public | sip_authentication                  | table | fsuser
 public | sip_dialogs                         | table | fsuser
 public | sip_presence                        | table | fsuser
 public | sip_registrations                   | table | fsuser
 public | sip_shared_appearance_dialogs       | table | fsuser
 public | sip_shared_appearance_subscriptions | table | fsuser
 public | sip_subscriptions                   | table | fsuser

This is what my database looks like :

 public | accounts      | table | postgres
 public | aliases       | table | freeswitch
 public | calls         | table | freeswitch
 public | cdr           | table | postgres
 public | channels      | table | freeswitch
 public | complete      | table | freeswitch
 public | db_data       | table | freeswitch
 public | group_data    | table | freeswitch
 public | interfaces    | table | freeswitch
 public | limit_data    | table | freeswitch
 public | nat           | table | freeswitch
 public | recovery      | table | freeswitch
 public | registrations | table | freeswitch
 public | tasks         | table | freeswitch

The configuration in my ‘/autoload_configs/switch.conf.xml’ file looks OK to me:

    <param name="core-db-dsn" value="pgsql://hostaddr=xxx dbname=xxx user=freeswitch password='xxx' options='-c client_min_messages=NOT>

    <param name="auto-create-schemas" value="true"/>
    <param name="auto-clear-sql" value="true"/>

Waiting for your answers…
Thank you,

Cédric

2

@BrianWest-SW maybe you could help me with that ?

3

Unknown, do you get any errors on startup?

4

Thanks for your quick reply.

No, I don’t have any errors, in fact I’ve noticed that although I’ve defined an external database, some data is still stored (notably my users’ registration info) in the SQLite DB.

What I’m trying to do is configure Freeswitch so that all data, without exception, is stored in the external database (in this case, a Postgres).

Any ideas?

Thanks to you.