Re: Still Cannot Log In

[..hidden..]

HI,
I tried

ALTER ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT;



that was accepted ok, but made no odds to logging in



Creating a new dbase worked just fine - login is ok :-)



I'm guessing that's significant!



Some of my emails were bounced yesterday, there was one that I gave a chunk of the postgres log that showed that the dbase upgrade run by Setup was failing (due to permissions).

Is the root of the problem actually the dbase conversion failing I wonder? 



Cheers

Richard

-----Original Message-----
From: Robert James Clay <..hidden..>
To: ledger-smb-users <..hidden..>
Sent: Mon, 22 Oct 2012 18:57
Subject: Re: [Ledger-smb-users] Still Cannot Log In

On Mon, 2012-10-22 at 13:27 -0400, Richard wrote:
> On 22/10/12 18:15, Robert James Clay wrote:
> > On Mon, 2012-10-22 at 11:49 -0400, lrspares45 wrote:
> >
> >     For testing purposes; have you tried creating a new LSMB database?
> 
> Ah, I'd assumed the dbase upgrade took care of that.

   But that appears to be failing; why, we don't know yet. 


>  I'll try a dummy dbase too, should have thought of that!

   Yes, that'll help tell us where the issue might be...  (normal ops,
or the upgrade...)


> > ...., then a 'ledgersmb' database admin user (the one to be used in 
setup.pl) should
> > be present but may not be configured correctly. (For instance, to
> > correct: ALTER ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT;)
> 
> Ok, I'll try that. I did try ALTER ROLE but got sytax errors.

   What kind of syntax errors?  And is 'ledgersmb' actually present?
(If not,it can be created by:  CREATE ROLE ledgersmb WITH SUPERUSER
LOGIN NOINHERIT ENCRYPTED PASSWORD 'password';)


Jame




Jame



------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users