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@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@lists.sip-router.org
From: miconda@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@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 list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


-- 
Daniel-Constantin Mierla
http://www.asipto.com
http://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@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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users