[OpenSIPS-Users] rtpengine + cluster

[volga629 at networklab.ca]

Hello Everyone,
I tried create new database with

[root at canldev01-fedora27 opensips]# opensipsdbctl create opensips01
PGSQL password for postgres:
INFO: creating database opensips01 ...
ERROR: role "opensips_prod" already exists
WARNING: Create user in database failed, perhaps they already exist? 
Try to continue..
INFO: Core OpenSIPS tables successfully created.
Install presence related tables? (Y/n): y
INFO: creating presence tables into opensips01 ...
INFO: Presence tables successfully created.
Install tables for
 b2b
 cachedb_sql
 call_center
 carrierroute
 cpl
 domainpolicy
 emergency
 fraud_detection
 freeswitch_scripting
 imc
 registrant
 siptrace
 userblacklist
? (Y/n): y
INFO: creating extra tables into opensips01 ...
INFO: Extra tables successfully created.


but rtpengine_new table is not created. I am not sure what is missing.

postgres=# \c opensips01
You are now connected to database "opensips01" as user "postgres".
opensips01=# \d
                        List of relations
 Schema | Name | Type | Owner
--------+-----------------------------------+----------+----------
 public | acc | table | postgres
 public | acc_id_seq | sequence | postgres
 public | active_watchers | table | postgres
 public | active_watchers_id_seq | sequence | postgres
 public | address | table | postgres
 public | address_id_seq | sequence | postgres
 public | b2b_entities | table | postgres
 public | b2b_entities_id_seq | sequence | postgres
 public | b2b_logic | table | postgres
 public | b2b_logic_id_seq | sequence | postgres
 public | cachedb | table | postgres
 public | carrierfailureroute | table | postgres
 public | carrierfailureroute_id_seq | sequence | postgres
 public | carrierroute | table | postgres
 public | carrierroute_id_seq | sequence | postgres
 public | cc_agents | table | postgres
 public | cc_agents_id_seq | sequence | postgres
 public | cc_calls | table | postgres
 public | cc_calls_id_seq | sequence | postgres
 public | cc_cdrs | table | postgres
 public | cc_cdrs_id_seq | sequence | postgres
 public | cc_flows | table | postgres
 public | cc_flows_id_seq | sequence | postgres
 public | clusterer | table | postgres
 public | clusterer_id_seq | sequence | postgres
 public | cpl | table | postgres
 public | cpl_id_seq | sequence | postgres
 public | dbaliases | table | postgres
 public | dbaliases_id_seq | sequence | postgres
 public | dialog | table | postgres
 public | dialplan | table | postgres
 public | dialplan_id_seq | sequence | postgres
 public | dispatcher | table | postgres
 public | dispatcher_id_seq | sequence | postgres
 public | domain | table | postgres
 public | domain_id_seq | sequence | postgres
 public | domainpolicy | table | postgres
 public | domainpolicy_id_seq | sequence | postgres
 public | dr_carriers | table | postgres
 public | dr_carriers_id_seq | sequence | postgres
 public | dr_gateways | table | postgres
 public | dr_gateways_id_seq | sequence | postgres
 public | dr_groups | table | postgres
 public | dr_groups_id_seq | sequence | postgres
 public | dr_partitions | table | postgres
 public | dr_partitions_id_seq | sequence | postgres
 public | dr_rules | table | postgres
 public | dr_rules_ruleid_seq | sequence | postgres
 public | emergency_report | table | postgres
 public | emergency_report_id_seq | sequence | postgres
 public | emergency_routing | table | postgres
 public | emergency_routing_id_seq | sequence | postgres
 public | emergency_service_provider | table | postgres
 public | emergency_service_provider_id_seq | sequence | postgres
 public | fraud_detection | table | postgres
 public | fraud_detection_ruleid_seq | sequence | postgres
 public | freeswitch | table | postgres
 public | freeswitch_id_seq | sequence | postgres
 public | globalblacklist | table | postgres
 public | globalblacklist_id_seq | sequence | postgres
 public | grp | table | postgres
 public | grp_id_seq | sequence | postgres
 public | imc_members | table | postgres
 public | imc_members_id_seq | sequence | postgres
 public | imc_rooms | table | postgres
 public | imc_rooms_id_seq | sequence | postgres
 public | load_balancer | table | postgres
 public | load_balancer_id_seq | sequence | postgres
 public | location | table | postgres
 public | location_contact_id_seq | sequence | postgres
 public | missed_calls | table | postgres
 public | missed_calls_id_seq | sequence | postgres
 public | presentity | table | postgres
 public | presentity_id_seq | sequence | postgres
 public | pua | table | postgres
 public | pua_id_seq | sequence | postgres
 public | re_grp | table | postgres
 public | re_grp_id_seq | sequence | postgres
 public | registrant | table | postgres
 public | registrant_id_seq | sequence | postgres
 public | rls_presentity | table | postgres
 public | rls_presentity_id_seq | sequence | postgres
 public | rls_watchers | table | postgres
 public | rls_watchers_id_seq | sequence | postgres
 public | route_tree | table | postgres
 public | route_tree_id_seq | sequence | postgres
 public | rtpproxy_sockets | table | postgres
 public | rtpproxy_sockets_id_seq | sequence | postgres
 public | silo | table | postgres
 public | silo_id_seq | sequence | postgres
 public | sip_trace | table | postgres
 public | sip_trace_id_seq | sequence | postgres
 public | speed_dial | table | postgres
 public | speed_dial_id_seq | sequence | postgres
 public | subscriber | table | postgres
 public | subscriber_id_seq | sequence | postgres
 public | tls_mgm | table | postgres
 public | tls_mgm_id_seq | sequence | postgres
 public | uri | table | postgres
 public | uri_id_seq | sequence | postgres
 public | userblacklist | table | postgres
 public | userblacklist_id_seq | sequence | postgres
 public | usr_preferences | table | postgres
 public | usr_preferences_id_seq | sequence | postgres
 public | version | table | postgres
 public | watchers | table | postgres
 public | watchers_id_seq | sequence | postgres
 public | xcap | table | postgres
 public | xcap_id_seq | sequence | postgres
(109 rows)


volga629

On Sun, Jun 10, 2018 at 1:23 PM, volga629 at networklab.ca wrote:
> Hello Everyone,
> Where possible find raw structure for PgSQL rtpengine table.
> I  was wonder how should work session relocation when one node fail ? 
> Is require some script logic and rewrite host function to send call 
> next available node ?
> 
> 
> volga629
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users