Wow - quick response from you guys.
With Erik's statement I get a few more options in the left pane including
"Admin Users"
I guess full admin should be a last resort so I'll have a play until I get
a happy medium
Many thanks
Andrew
On Thu, Mar 8, 2012 at 9:37 PM, Chris Travers <[email protected]>wrote:
> On Thu, Mar 8, 2012 at 5:28 AM, Andrew Rowland <[email protected]>
> wrote:
> >>ALTER USER andrew VALID UNTIL '2012-03-10';
> >
> > ERROR: role "andrew" does not exist
> >
> > Thanks Chris but there is no postgres user by that name - not a database
> > user anyway, just an entry in the company DB 'user' table. This is why
> I'm
> > getting authentication failure,
> > Something must have gone wrong during the user creation part of the
> upgrade
> > and now I am unable to get back to that screen to retry.
> >
> >
> > Edit: I just tried create USER andrew WITH PASSWORD 'mypassword';
> >
> > With this it logs in but I only get a blank page with 3 options in the
> left
> > frame : Preferences, New Window, Logout
> > So that gives me access but presumably no permissions to do or see
> anything.
> >
> > Can somebody please explain how to either:
> >
> > Get back to the user create/import screen OR
> > Do a manual creation of a user using SQL statements
>
> Secure by default.
>
> You can:
> SELECT admin__add_user_to_role('andrew', rolname)
> FROM pg_roles where rolname like 'lsmb_[dbhame]__%';
>
> if you need full permissions....
>
> Best Wishes,
> Chris Travers
> >
> >
> > Thanks
> >
> > Andrew
> >
> >
> > On Thu, Mar 8, 2012 at 8:25 AM, Chris Travers <[email protected]>
> > wrote:
> >>
> >> On Wed, Mar 7, 2012 at 4:17 PM, Andrew Rowland <[email protected]>
> >> wrote:
> >> > Hi
> >> >
> >> > I finally managed to get my 1.2 database upgraded to 1.3 but find
> myself
> >> > unable to log in using my application level user account.
> >> >
> >> > After conversion I got a user creation/import screen which I'm not
> sure
> >> > worked correctly.
> >> >
> >> > Looking in the database there is a user created in the company
> database
> >>
> >> There are two possibilities here.
> >>
> >> The first is that the password is wrong. The second is that the
> >> admin-created passwords time out after, iirc, 24-48 hrs.
> >>
> >> I would suggest logging in to PostgreSQL via psql and trying this:
> >>
> >> ALTER USER andrew VALID UNTIL '2012-03-10';
> >>
> >> Then try to log in through the front-end again.
> >>
> >> If that fails
> >>
> >> ALTER USER andrew WITH PASSWORD 'mypassword';
> >>
> >> One of those should fix it.
> >>
> >> Best Wishes,
> >> Chris Travers
> >>
> >> >
> >> > mycompany=> select * from users;
> >> > id | username | notify_password | entity_id
> >> > ----+----------+-----------------+-----------
> >> > 1 | andrew | 7 days | 49
> >> >
> >> >
> >> > 1.2 had a ledgersmb username/password hard coded into configuration
> but
> >> > 1.3.
> >> > seems to only use the application user only so do I not also need a
> >> > postgres
> >> > account as well for this user? Currently there is none (only
> ledgersmb)
> >> >
> >> > Looking in the PG logs it's failing on what looks like a PG
> >> > authentication
> >> >
> >> > password authentication failed for user "andrew"
> >> >
> >> > I think something went wrong in the user creation step. Is there any
> way
> >> > to
> >> > re-do this as if I re-run setup.pl it doesn't give me that screen
> again
> >> >
> >> > Any idea how to do this or even to fix it using some SQL
> >> >
> >> > Thanks
> >> >
> >> >
> >> > Andrew
> >> >
> >> >
> >> >
> >> >
> >> >
> ------------------------------------------------------------------------------
> >> > Virtualization & Cloud Management Using Capacity Planning
> >> > Cloud computing makes use of virtualization - but cloud computing
> >> > also focuses on allowing computing to be delivered as a service.
> >> > http://www.accelacomm.com/jaw/sfnl/114/51521223/
> >> > _______________________________________________
> >> > Ledger-smb-users mailing list
> >> > [email protected]
> >> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >> >
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Virtualization & Cloud Management Using Capacity Planning
> >> Cloud computing makes use of virtualization - but cloud computing
> >> also focuses on allowing computing to be delivered as a service.
> >> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> >> _______________________________________________
> >> Ledger-smb-users mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Virtualization & Cloud Management Using Capacity Planning
> > Cloud computing makes use of virtualization - but cloud computing
> > also focuses on allowing computing to be delivered as a service.
> > http://www.accelacomm.com/jaw/sfnl/114/51521223/
> > _______________________________________________
> > Ledger-smb-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
>
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
