https://www.ejabberd.im/node/1243 en https://www.ejabberd.im/node/1243#comment-2738 <div class="quote-msg"> <div class="quote-author"><em>marshall</em> wrote:</div> <p>Sorry.</p> <p>I'm on a Debian Linux. Yes, there's a open Postgre connection (8.1 version).</p> <p>Ejabberd is the latest one. On logs there is nothing about db access.</p> <p>The conf file relative to the db:</p> <p>{auth_method, odbc}.<br /> {odbc_server, {pgsql, "localhost","ejabberd","ejabberd","ejabberd"}}.</p> <p>PS: If i simple change pgsql to mysql (Yes, have a mysql here too) it works!. </p></div> <p>i have one ejabberd running on debian etch with postgresql run 3 virtual host and i didnt get any problem :D</p> <p>check your pg_hba is allow to make connection ?<br /> set your postgresql to log all statement/client connection then check on your postgresql log.</p> Fri, 15 Dec 2006 09:41:45 +0000 kakuz comment 2738 at https://www.ejabberd.im https://www.ejabberd.im/node/1243#comment-2732 <p>Sorry.</p> <p>I'm on a Debian Linux. Yes, there's a open Postgre connection (8.1 version).</p> <p>Ejabberd is the latest one. On logs there is nothing about db access.</p> <p>The conf file relative to the db:</p> <p>{auth_method, odbc}.<br /> {odbc_server, {pgsql, "localhost","ejabberd","ejabberd","ejabberd"}}.</p> <p>PS: If i simple change pgsql to mysql (Yes, have a mysql here too) it works!.</p> Thu, 14 Dec 2006 11:20:57 +0000 marshall comment 2732 at https://www.ejabberd.im https://www.ejabberd.im/node/1243#comment-2730 <p>what is your server ?<br /> if linux you can check on resources whether there is open connection to postgresql service. this can be done with execute command 'ps ax'.</p> Thu, 14 Dec 2006 07:17:15 +0000 kakuz comment 2730 at https://www.ejabberd.im https://www.ejabberd.im/node/1243#comment-2728 <p>Hello, you need to provide more information.<br /> How is your configuration file, what are the version used, what do you find in the log files ?</p> <p>--<br /> Mickaël Rémond<br /> <noindex><a href="http://www.process-one.net/" rel="nofollow" >Process-one</a></noindex></p> Wed, 13 Dec 2006 10:47:54 +0000 mremond comment 2728 at https://www.ejabberd.im