[OpenSIPS-Users] opensips 1.11 postgress DB BUG

Podrigal, Aron aronp at guaranteedplus.com
Tue Apr 21 22:30:51 CEST 2015


MySQL has a option --password to provide the password on command line.
postgres however does not. but here is some refs how you can accomplish
what you would like.
http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html

On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel <satish.txt at gmail.com> wrote:

> can't we make password less? just like MySQL?
>
> On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron <aronp at guaranteedplus.com>
> wrote:
>
>> It executes a series of sql files ( I don't remember the dir location
>> where its stored I think somewhere in the share dir) for each file it asks
>> for the password.
>>
>> On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel <satish.txt at gmail.com>
>> wrote:
>>
>>> I am installing opensips 1.11.3 with postgress DB but i don't know what
>>> is going on here
>>>
>>>
>>> root at dopensips:/etc/opensips# opensipsdbctl create
>>> INFO: creating database opensips ...
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "version_t_name_idx" for table "version"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for
>>> serial column "acc.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "acc_pkey" for table "acc"
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "missed_calls_id_seq" for serial column "missed_calls.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "missed_calls_pkey" for table "missed_calls"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "domain_id_seq" for
>>> serial column "domain.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "domain_pkey" for table "domain"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "domain_domain_idx" for table "domain"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "grp_id_seq" for
>>> serial column "grp.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "grp_pkey" for table "grp"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "grp_account_group_idx" for table "grp"
>>> NOTICE:  CREATE TABLE will create implicit sequence "re_grp_id_seq" for
>>> serial column "re_grp.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "re_grp_pkey" for table "re_grp"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "address_id_seq" for
>>> serial column "address.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "address_pkey" for table "address"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "aliases_id_seq" for
>>> serial column "aliases.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "aliases_pkey" for table "aliases"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "aliases_alias_idx" for table "aliases"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "location_id_seq"
>>> for serial column "location.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "location_pkey" for table "location"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "location_account_contact_idx" for table "location"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "silo_id_seq" for
>>> serial column "silo.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "silo_pkey" for table "silo"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "dbaliases_id_seq"
>>> for serial column "dbaliases.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dbaliases_pkey" for table "dbaliases"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "dbaliases_alias_idx" for table "dbaliases"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "uri_id_seq" for
>>> serial column "uri.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "uri_pkey" for table "uri"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "uri_account_idx" for table "uri"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "rtpproxy_sockets_id_seq" for serial column "rtpproxy_sockets.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "rtpproxy_sockets_pkey" for table "rtpproxy_sockets"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "speed_dial_id_seq"
>>> for serial column "speed_dial.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "speed_dial_pkey" for table "speed_dial"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "speed_dial_speed_dial_idx" for table "speed_dial"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "usr_preferences_id_seq" for serial column "usr_preferences.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "usr_preferences_pkey" for table "usr_preferences"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "subscriber_id_seq"
>>> for serial column "subscriber.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "subscriber_pkey" for table "subscriber"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "subscriber_account_idx" for table "subscriber"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "pdt_id_seq" for
>>> serial column "pdt.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "pdt_pkey" for table "pdt"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "pdt_sdomain_prefix_idx" for table "pdt"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dialog_pkey" for table "dialog"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "dispatcher_id_seq"
>>> for serial column "dispatcher.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dispatcher_pkey" for table "dispatcher"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "dialplan_id_seq"
>>> for serial column "dialplan.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dialplan_pkey" for table "dialplan"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "dr_gateways_id_seq"
>>> for serial column "dr_gateways.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dr_gateways_pkey" for table "dr_gateways"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "dr_gateways_dr_gw_idx" for table "dr_gateways"
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "dr_rules_ruleid_seq" for serial column "dr_rules.ruleid"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dr_rules_pkey" for table "dr_rules"
>>> NOTICE:  CREATE TABLE will create implicit sequence "dr_carriers_id_seq"
>>> for serial column "dr_carriers.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dr_carriers_pkey" for table "dr_carriers"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "dr_carriers_dr_carrier_idx" for table "dr_carriers"
>>> NOTICE:  CREATE TABLE will create implicit sequence "dr_groups_id_seq"
>>> for serial column "dr_groups.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dr_groups_pkey" for table "dr_groups"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "load_balancer_id_seq" for serial column "load_balancer.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "load_balancer_pkey" for table "load_balancer"
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>>
>> --
>> Aron Podrigal
>> -
>> //Be happy :-)
>>
>> _______________________________________________
>> 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
>
>


-- 
Aron Podrigal
-
//Be happy :-)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150421/89fd9f23/attachment-0001.htm>


More information about the Users mailing list