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

Re: initial database setup on 1.4





On Mon, Jan 21, 2013 at 11:09 AM, Grant <..hidden..> wrote:
> Out of curiosity, what is in the PostgreSQL log?  Is it limited to
> authentication issues for the apache user?

I think the problem was that I hadn't added apache to the postgres
group.


I don't think so.  Here's whats going on and if you fixed the issue by giving special rights to Apache as a user in PostgreSQL that may pose other issues.

LedgerSMB's authentication works as follows:

1)  Web browser sends HTTP auth headers to Apache
2)  Apache passes these through to the CGI script using mod_rewrite
3) The script uses these values to log into PostgreSQL

If no username is provided (as the log shows) it tries log into PostgreSQL with the user name of the owner of the process, which is what is happening.

Best Wishes,
Chris Travers
 
 I wiped out my databases so I'm not sure, and I need to find
out if ledgersmb can import bank transactions via CSV before I tackle
this again.  I get the impression that this functionality is not quite
complete?  Do folks using ledgersmb really enter each bank transaction
into the ledger one-by-one?

- Grant

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, _javascript_ and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users