are you able to access the db with 'psql' ? This looks like an access issue in pg_hba.conf. <div><br></div><div>Most likely, the issue isn't opensips. Here's a quick ref for you..</div><div><br></div><div><a href="http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html">http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html</a></div>
<div><br><div>-Brett</div><div><br><br><div class="gmail_quote">On Thu, Apr 23, 2009 at 2:28 AM, Harendra Pratap Singh <span dir="ltr"><<a href="mailto:harendra.singh@globallogic.com">harendra.singh@globallogic.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">Hi All,</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">I want to use opensips with postgresql when I create a
database using the following command it is showing error.</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">/usr/local/sbin/opensipsdbctl create</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">INFO: creating database opensips ...</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">psql: FATAL: no pg_hba.conf entry for host
"127.0.0.1", user "root", database "template1",
SSL off</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">ERROR: Creating database failed!</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">Do anyone have anyidea why it is throwing errors?</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">Thanks,</span></font></p>
<p><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">Harendra</span></font></p>
</div>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div>