On Tue, Jan 31, 2012 at 8:39 AM, Linda Ursin
<..hidden..> wrote:
It's the default configuration. I haven't touched it. What should be there that isn't?
Now that I have had a chance to sleep on this just a little....
Basically you have two options.
1) I suspect you are missing a database port assignment in your ledgersmb.conf. If you add that in, it will fix the problem.
2) You could also grant all users md5 access to the database in question. This would not be sufficient to use the
setup.pl to create new databases though.
What's happening is that the first rule here requires the postgres user on all local connections to be logged in to the operating system as the postgres operating system user. In 1.2 this is not a problem. In 1.3, this is, because you have to have a superuser that creates/manages the databases, and by default that's postgres.
Your PostgreSQL configuration is set up with basically two rule sets. The first, for local UNIX socket connections is:
If user is postgres, ask OS what user the individual is logged in as, and if not postgres, deny.
If user and db are ledgersmb, ask for password
otherwise ask OS what user the individual is logged in as and require that it matches the requested db user.
The second rule set, for TCP/IP connections is much more simple:
Always ask for a password.
It seems to me that the easiest answer here is to correct the ledgersmb.conf. It might be worth attaching or pasting it inline on the reply to this email and we can talk about the best way to set this up.
On Tue, Jan 31, 2012 at 4:13 PM, Chris Travers
<..hidden..> wrote:
On Tue, Jan 31, 2012 at 7:01 AM, Linda Ursin
<..hidden..> wrote:
How is that possible when I haven't changed it? ( I changed it back to default after trying trust)
1.3 handles things a bit differently, security-wise, so it isn't entirely surprising that some configurations that worked with 1.2 are not working with 1.3.
This is what it looks like:
-----
# Database administrative login by UNIX sockets
local all postgres ident
local ledgersmb ledgersmb md5
Try changing hte above two lines to:
local ledgersmb all md5
local all postgres md5
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident.
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
-----
The rest is commented out.
LindaOn Tue, Jan 31, 2012 at 3:53 PM, Chris Travers
<..hidden..> wrote:
On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin
<..hidden..> wrote:
[Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI connect('dbname=template1','postgres',...) failed: FATAL: Ident authentication failed for user "postgres" at LedgerSMB.pm line 982, referer: http://lur.aitel.hist.no/ledgersmb/setup.pl
You have a bad line in your pg_hba.conf
Best Wishes,
Chris Travers
On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers
<..hidden..> wrote:
On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin
<..hidden..> wrote:
ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even if the command worked.
If I was still using the old ledgersmb confiuration for apache, my installation would be available through http://..../regnskap/
but it isn't, it's aat http://......./ledgersmb/
Ok, so ruling that out.....
can you check your httpd error logs and see what it prints when it gives the auth dialog?
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users