[SR-Users] Kamailio PostgreSQL Asking Password Everytime

[SamyGo]

Hi,
I've experienced the same in past couple of weeks, apparently if you've the
file */root/.pgpass* with the pgsql user/password in it something like

*:*:*:kamailio:kamailiopass

Then it should not ask you over and over again. I kept pasting password
until it was done doing it's DB stuff, so I can only assume that it keeps
asking for password for each new table/schema creation.

Although not a big probelm but I too would like to get a fix for this
situation.

Regards,
Sammy




On Fri, Mar 25, 2016 at 9:47 AM, Barış Şekerciler <
baris.sekerciler at outlook.com> wrote:

> Hello Daniel,
> Thanks for your reply.
>
> So I can't see any password for root user option in the kamctlrc file by
> default.
> How can I add?
>
> Regards.
> Barış.
>
> ------------------------------
> To: sr-users at lists.sip-router.org
> From: miconda at gmail.com
> Date: Wed, 23 Mar 2016 08:26:58 +0100
> Subject: Re: [SR-Users] Kamailio PostgreSQL Asking Password Everytime
>
>
> Hello,
>
> I haven't used the postgres in a long while, but I think it should ask
> only once.
>
> Can you try by setting the password inside the kamctlrc file and see if
> works straight away?
>
> Cheers,
> Daniel
>
> On 22/03/16 11:52, Barış Şekerciler wrote:
>
> Hello,
> I have one postgres server at one server and Kamailio at another server.
> So I believe I did true configuration to the Kamailio. Actually I made
> some tests and I could create user and authenticated etc.
>
> But I have a problem. When I tried to present "kamdbctl create" Kamailio
> asks password 50 times (almost, much or less idk certainly).
> After 50 times Db created successfully and works.
>
> And it looks like this:
>
> root at bs-kamailio:/home/bs-kamailio# kamdbctl create
>
> INFO: creating database kamailio ...
>
> 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:
>
>
> So how can I solve this situation? I want Kamailio to asks password one
> time and handle it's job.
>
>
> Regards.
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
>
>
> _______________________________________________ SIP Express Router (SER)
> and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160325/827fb011/attachment.html>