sent from my phone
On Jul 16, 2013 7:20 PM, "Arne Hanssen" <..hidden..> wrote:
>
> Den 15. juli 2013 23:30, skrev Erik Huelsmann:
> >
> >
> > [ snipped description of setup ]
> >
> > Â Â Â> The 'ledgersmb.conf' file usually contains the name of the host to be
> > Â Â Â> used as the database IP connection host. If you're using a
> >
> > Â Â It is set to 'localhost'.
> >
> >
> > Ok. You could try setting it to the path your unix sockets for
> > postgresql reside in, that allows bypassing the firewall. If nothing
> > else, that's a performance gain, most likely.
>
> I set host to '/var/run/postgresql/' (file '9.1-main.pid' resides here),
> but then logon was refused (bad user or password).
>
> > Actually, my (8.4) pg_hba.conf lines are:
> >
> > Â # "local" is for Unix domain socket connections only
> > local  all     all                md5
> > # IPv4 local connections:
> > host  Âall     all 127.0.0.1/32     Âmd5
> > # IPv6 local connections:
> > host  Âall     all     ::1/128        md5
> >
> >
> > Note that mine don't list the second IP address that yours do. Maybe
> > that's part of the issue? (I have another instance with 9.2 on it, which
> > looks exactly like this one).
>
> That was a quotation error which went unnoticed on my part (your answer
> is probably html which resulted in unexpected output). ÂThe format in my
> file is exactly as yours.
>
> > Ok. Well, it's a bit mystical to me so far. Do the postgresql logs hold
> > information which might indicate problems? Maybe multiple rejected
> > requests in short succession?
>
> I got these when experimenting with host=/var/run/postgresql/:
>
> 2013-07-16 18:28:09 CEST FATAL: ÂPeer authentication failed for user "arne"
> 2013-07-16 18:33:30 CEST FATAL: Ârole "www-data" does not exist
> 2013-07-16 18:33:31 CEST LOG: Âprovided user name (arne) and
> authenticated user name (www-data) do not match
>
This means you have a line starting with local and ending with peer. You could replace the peer with md5 to fix your problem, if I'm correct.
> Apache runs as user www-data. ÂLSMB directory is owned by root.
>
> I guess I have to play around looking for clues and try different
> settings. ÂBut hints are most welcome.
>
> --
> Vennlig hilsen / Best regards   Â|\   ___,,--,    Â_
> Arne Hanssen, Senja, Norway    Â/,`--''    Â\-,,__,'/
> [ Linux counter #102028 @ ] Â Â Â |,4 Â ) )_ Â Â) /~-----'
> [ http://linuxcounter.net ]------'---^~(_/-_)--(_/_)-------
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users