<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hello Sammy,<div>Thanks your for reply.</div><div><br></div><div>I could not find the <b>/root/.pgpass. </b>Both Kamailio and PGS server.</div><div>Should I manually create it?</div><div><br></div><div>Regards,</div><div>Barış.<br><br><div><hr id="stopSpelling">Date: Fri, 25 Mar 2016 12:00:35 -0400<br>From: govoiper@gmail.com<br>To: sr-users@lists.sip-router.org<br>Subject: Re: [SR-Users] Kamailio PostgreSQL Asking Password Everytime<br><br><div dir="ltr">Hi,<div>I've experienced the same in past couple of weeks, apparently if you've the file <b>/root/.pgpass</b> with the pgsql user/password in it something like</div><div><br></div><div><font face="monospace, monospace">*:*:*:kamailio:kamailiopass</font></div><div><font face="monospace, monospace"><br></font></div>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. <div><br></div><div>Although not a big probelm but I too would like to get a fix for this situation.</div><div><br></div><div>Regards,</div><div>Sammy</div><div><div><br></div><div><br><div><br></div></div></div></div><div class="ecxgmail_extra"><br><div class="ecxgmail_quote">On Fri, Mar 25, 2016 at 9:47 AM, Barış Şekerciler <span dir="ltr"><<a href="mailto:baris.sekerciler@outlook.com" target="_blank">baris.sekerciler@outlook.com</a>></span> wrote:<br><blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr"><div><div dir="ltr">Hello Daniel,<div>Thanks for your reply.</div><div><br></div><div>So I can't see any password for root user option in the kamctlrc file by default.</div><div>How can I add?</div><div><br></div><div>Regards.</div><div>Barış.</div><div><br><div><hr>To: <a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>From: <a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a><br>Date: Wed, 23 Mar 2016 08:26:58 +0100<br>Subject: Re: [SR-Users] Kamailio PostgreSQL Asking Password Everytime<div><div class="h5"><br><br>
Hello,<br>
<br>
I haven't used the postgres in a long while, but I think it should
ask only once.<br>
<br>
Can you try by setting the password inside the kamctlrc file and see
if works straight away?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div>On 22/03/16 11:52, Barış Şekerciler
wrote:<br>
</div>
<blockquote>
<div dir="ltr">Hello,
<div>I have one postgres server at one server and Kamailio at
another server.</div>
<div>So I believe I did true configuration to the Kamailio.
Actually I made some tests and I could create user and
authenticated etc.</div>
<div><br>
</div>
<div>But I have a problem. When I tried to present "kamdbctl
create" Kamailio asks password 50 times (almost, much or less
idk certainly).</div>
<div>After 50 times Db created successfully and works.</div>
<div><br>
</div>
<div>And it looks like this:</div>
<div><br>
</div>
<div>
<span>root@bs-kamailio:/home/bs-kamailio#
kamdbctl create</span><BR>
<span>INFO: creating database
kamailio ...</span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span>Password for user postgres: </span><BR>
<span><br>
</span><BR>
<span>So how can I solve this
situation? I want Kamailio to asks password one time and
handle it's job.</span><BR>
<span><br>
</span><BR>
<span>Regards.</span><BR>
<span></span><br>
<BR>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre>--
Daniel-Constantin Mierla
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
<br>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></div></div></div></div> </div></div> </div></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________
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</div></div> </div></body>
</html>