[OpenSIPS-Users] rtpengine + cluster

Răzvan Crainea razvan at opensips.org
Tue Jun 26 02:01:02 EDT 2018


Hi, Volga!

You can find the raw structure of the rtpengine table in
scripts/postgres/rtpengine-create.sql[1].

[1] 
https://github.com/OpenSIPS/opensips/blob/master/scripts/postgres/rtpengine-create.sql

Best regards,

Răzvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com

On 06/26/2018 04:33 AM, volga629 at networklab.ca wrote:
> 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
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



More information about the Users mailing list