On Tue, Jan 31, 2012 at 8:39 AM, Linda Ursin <li...@heksebua.com> 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.
>
> Linda
>
>
> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>
> Linda Ursin
> Heksebua
>
> Adresse: Tlf: (+47) 402 40 767
> Solvang www: http://heksebua.com
> 7288 Soknedal E-post: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Tue, Jan 31, 2012 at 4:13 PM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>>
>>
>> On Tue, Jan 31, 2012 at 7:01 AM, Linda Ursin <li...@heksebua.com> 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.
>>>
>>> Linda
>>>
>>>
>>>
>>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>>
>>> Linda Ursin
>>> Heksebua
>>>
>>> Adresse: Tlf: (+47) 402 40 767
>>> Solvang www: http://heksebua.com
>>> 7288 Soknedal E-post: li...@heksebua.com
>>>
>>> Org: NO 995 578 107
>>>
>>>
>>> On Tue, Jan 31, 2012 at 3:53 PM, Chris Travers
>>> <chris.trav...@gmail.com>wrote:
>>>
>>>>
>>>>
>>>> On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin <li...@heksebua.com>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
>>>>
>>>>
>>>>>
>>>>>
>>>>>
>>>>> ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
>>>>>
>>>>> Linda Ursin
>>>>> Heksebua
>>>>>
>>>>> Adresse: Tlf: (+47) 402 40 767
>>>>> Solvang www: http://heksebua.com
>>>>> 7288 Soknedal E-post: li...@heksebua.com
>>>>>
>>>>> Org: NO 995 578 107
>>>>>
>>>>>
>>>>> On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers <
>>>>> chris.trav...@gmail.com> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin <li...@heksebua.com>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
>>>>>> Ledger-smb-users@lists.sourceforge.net
>>>>>> 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
>>>>> Ledger-smb-users@lists.sourceforge.net
>>>>> 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
>>>> Ledger-smb-users@lists.sourceforge.net
>>>> 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
>>> Ledger-smb-users@lists.sourceforge.net
>>> 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
>> Ledger-smb-users@lists.sourceforge.net
>> 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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
