[OpenSIPS-Users] rtpengine + cluster
Răzvan Crainea
razvan at opensips.org
Tue Jun 26 10:39:29 EDT 2018
No, you don't need to add it if you don't need it.
Răzvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com
On 06/26/2018 04:35 PM, volga629 at networklab.ca wrote:
> Hello Razvan,
> Thank you, do I need add SEQUENCE too ?
>
>
> CREATE SEQUENCE public.rtpengine_id_seq
> START WITH 1
> INCREMENT BY 1
> NO MINVALUE
> MAXVALUE 2147483647
> CACHE 1
> CYCLE;
>
> volga629
>
> On Tue, Jun 26, 2018 at 3:01 AM, Răzvan Crainea <razvan at opensips.org>
> wrote:
>> 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
>>
>> _______________________________________________
>> 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