On Mon, Jan 21, 2013 at 11:09 AM, Grant <emailgr...@gmail.com> 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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
