Hello Sammy,Thanks your for reply. I could not find the /root/.pgpass. Both Kamailio and PGS server.Should I manually create it? Regards,Barış. Date: Fri, 25 Mar 2016 12:00:35 -0400 From: govoiper(a)gmail.com To: sr-users(a)lists.sip-router.org Subject: Re: [SR-Users] Kamailio PostgreSQL Asking Password Everytime 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(a)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(a)lists.sip-router.org From: miconda(a)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(a)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(a)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(a)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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users