[Reconnoiter-users] Error connecting to database, Error reconnecting to database: 'user=stratcon dbname=reconnoiter host=localhost password=stratcon'

Kiran Patil kirantpatil at gmail.com
Thu Dec 15 09:25:04 EST 2011


Sorry, I forgot to include reconnoiter-users.


> Thanks Theo.
>
> Earlier I enabled trust for only local.
>
> Now I enabled trust for host and the db connection happens.
>
> /var/lib/pgsql/data/pg_hba.conf snippet:
> -------------------------------------------------------
> # TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD
>
> # "local" is for Unix domain socket connections only
> # local   all             all                                     ident
> # local   all             all                                     trust
> # IPv4 local connections:
> # host    all             all             127.0.0.1/32            ident
>  host    all             all             127.0.0.1/32            trust
> # IPv6 local connections:
> host    all             all             ::1/128                 ident
>
>
>
> On Thu, Dec 15, 2011 at 6:44 PM, Theo Schlossnagle <jesus at omniti.com>wrote:
>
>> Your pg_hba.conf needs some reconfiguration to allow those users to
>> connect with password authentication (or less desirably trust).
>>
>> --
>> Theo Schlossnagle (mobile)
>> http://omniti.com/is/theo-schlossnagle
>>
>> On Dec 15, 2011, at 6:15 AM, Kiran Patil <kirantpatil at gmail.com> wrote:
>>
>> > Hello,
>> >
>> > scaffolding.sql file snippet, here we have created stratcon password as
>> encrypted, is this the issue for error database connection ?
>> >
>> > >> create user stratcon with encrypted password 'stratcon';I
>> >
>> >
>> > /usr/local/etc/stratcon.conf file snippet:
>> > -------------------------------------------------------
>> >
>> > <database>
>> >     <journal>
>> >       <path>/var/log/stratcon.persist</path>
>> >     </journal>
>> >     <dbconfig>
>> >       <host>localhost</host>
>> >       <dbname>reconnoiter</dbname>
>> >       <user>stratcon</user>
>> >       <password>stratcon</password>
>> >     </dbconfig>
>> >
>> >  <sslconfig>
>> >       <key_file>/usr/local/etc/test-stratcon.key</key_file>
>> >
>> <certificate_file>/usr/local/etc/test-stratcon.crt</certificate_file>
>> >       <ca_chain>/usr/local/etc/test-ca.crt</ca_chain>
>> >     </sslconfig>
>> >
>> >
>> > ca,noit,stratcon crt and key files generated by "make install" command.
>> >
>> -------------------------------------------------------------------------------------------------------
>> > [akshatha at localhost reconnoiter]$ ls /usr/local/etc/
>> > config_templates.conf  noit.conf         stratcon.conf
>> test-ca.crt  test-noit.crt  test-stratcon.crt
>> > default-ca-chain.crt   noit.conf.sample  stratcon.conf.sample
>>  test-ca.key  test-noit.key  test-stratcon.key
>> >
>> > System Information
>> > ----------------------------
>> > Fedora Linux 15
>> >
>> > [root at localhost ~]# postgres --version
>> > postgres (PostgreSQL) 9.0.6
>> >
>> >
>> > Stratcond deamon running output:
>> > -------------------------------------------------
>> > [root at localhost reconnoiter]# /usr/local/sbin/stratcond -c
>> /usr/local/etc/stratcon.conf -D
>> > [2011-12-15 16:25:35.767488] Found 6 /stratcon/logs//log stanzas
>> > [2011-12-15 16:25:35.768158] Found 1 outlets for log 'error'
>> > Found 1 outlets for log 'error/iep'
>> > Found 1 outlets for log 'error/eventer'
>> > Found 1 outlets for log 'error/datastore'
>> > Found 1 outlets for log 'debug/eventer'
>> > Found 6 /stratcon/logs//log stanzas
>> > [2011-12-15 16:25:35.771453] rlim { 1048576, 1048576 }
>> > Found 6 /stratcon/logs//log stanzas
>> > [2011-12-15 16:25:35.774976] Found 1 acl stanzas
>> > [2011-12-15 16:25:35.775352] Found 3 /stratcon/listeners//listener
>> stanzas
>> > noit_listener(/tmp/stratcon, 0, 1, 5, noit_console, (nil))
>> > noit_listener(*, 80, 1, 5, http_rest_api, (nil))
>> > noit_listener(*, 43191, 1, 5, control_dispatch, (nil))
>> > [2011-12-15 16:25:35.778090] Generic module stomp_driver successfully
>> loaded.
>> > [2011-12-15 16:25:35.786733] Error reconnecting to database:
>> 'user=stratcon dbname=reconnoiter host=localhost password=stratcon'
>> > Error: FATAL:  Ident authentication failed for user "stratcon"
>> >
>> > [2011-12-15 16:25:35.786799] Error connecting to database
>> > [2011-12-15 16:25:36.791192] Error reconnecting to database:
>> 'dbname=reconnoiter host=localhost password=stratcon user=stratcon'
>> > Error: FATAL:  Ident authentication failed for user "stratcon"
>> > FATAL:  Ident authentication failed for user "stratcon"
>> >
>> > [2011-12-15 16:25:36.791269] Error connecting to database
>> > [2011-12-15 16:25:37.795635] Error reconnecting to database:
>> 'user=stratcon host=localhost password=stratcon dbname=reconnoiter'
>> > Error: FATAL:  Ident authentication failed for user "stratcon"
>> > FATAL:  Ident authentication failed for user "stratcon"
>> > FATAL:  Ident authentication failed for user "stratcon"
>> >
>> > [2011-12-15 16:25:37.795747] Error connecting to database
>> >
>> > Thanks,
>> > Kiran.
>> > _______________________________________________
>> > Reconnoiter-users mailing list
>> > Reconnoiter-users at lists.omniti.com
>> > http://lists.omniti.com/mailman/listinfo/reconnoiter-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.omniti.com/pipermail/reconnoiter-users/attachments/20111215/94fb4461/attachment-0001.html>


More information about the Reconnoiter-users mailing list