[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Some issues.

[ 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 database on
> the local host, it's best to enter 'localhost' there - not the name of
> the host in the DNS.

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.

> Actually, what I do when I run against a database which is local, I
> enter the unix domain socket file's directory as the host name. On my
> debian system that's /var/run/postgresql/. This reduces chances of your
> firewall interfering with your database connection.
> Â Â The only errors I can find is this and seems related to login:
> Â Â /var/log/postgresql/postgresql-9.1-main.log:
> Â Â 2013-07-14 16:53:58 CEST LOG: Âcould not receive data from client:
> Â Â Connection reset by peer
> Â Â /var/log/apache2/error.log:
> Â Â [Sun Jul 14 16:53:58 2013] [error] [client] DBI
> Â Â connect('dbname=nix','',...) failed: fe_sendauth: no password supplied
> Â Â at LedgerSMB.pm line 986, referer: http://ledgersmb.kingel.net/login.pl
> Hmm. if you're able to log in afterwards, this is a bit unexplicable.
> Does this happen on every page? or just when logging in?

Just on login.

Ok. Then it can't explain the long response times on the later pages.
> Â Â I have this in /usr/share/postgresql/9.1/pg_hba.conf:
> Â Â host Âall Âall Â127.0.0.1/32 Â Âhttp:// Â Âmd5
> Â Â host Âall Âall Â192.168.1.0/24 Âhttp:// Âmd5

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     Â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).

What do these two lines in pg_hba.conf mean?:

@..hidden.. "local" is for Unix domain socket connections
@..hidden.. Âall Âall ..hidden..@

These lines look like they should not have been there. The "local" item is the configuration for the "directory based" access method through Unix sockets, but these lines look like remnants of a partially processed template.
> Ok. I assume you have restarted the postgresql server after you changed
> its configuration files (such as pg_hba.conf)?

Yes, more than once. :-)

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?Â



http://efficito.comÂ-- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
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!
Ledger-smb-users mailing list