hy<div><br></div><div>have u checked the local fw on the windows server for inbound connection from the presence server.</div><div><br></div><div>have u done the config in the hba.conf and so on<br><br>Am Donnerstag, 20. März 2014 schrieb Jeffrey Girard :<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="#0563C1" vlink="#954F72"><div><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I have searched the Cisco site and there are tons of documents on how to configure the database for *nix installs.  I, unfortunately, am not skilled in that arena.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I have downloaded and installed PostgreSQL on a Win2k8R2 server.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I tried to interpret the Cisco doc instructions as best I could<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I have created a new database called tcmadb<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I have created a new entity under Login Roles called tcuser and gave that user superadmin rights<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I went back to the tcmadb database and made the tcuser the owner of the database<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">In CUPS, I created the new external database:  <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">          Database name -> tcmadb<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">          Username -> tcuser<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">          Pasword -> password that I assigned to tcuser when I created it in the database<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">          Hostname -> IP address of my win2K8 server<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">          Port Number -> 5432.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">After several failures, I found a thread that indicated that I should create a new user in the Windows domain called tcuser.  I did that, and gave that user domain admin privileges.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">I get the failure to connect error under External Database Status<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">Green check for reachability<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">Failure on connectivity to database “Verify the hostname, username, and password are valid”<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">Does it have anything to do with the postgres user account?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif"">Jeff</span><span style="font-size:12.0pt;color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p></div></div></blockquote></div><br><br>-- <br>--<br>Florian Kroessbacher<br>gmail: <a href="mailto:florian.kroessbacher@gmail.com">florian.kroessbacher@gmail.com</a><br>