Re: 1.2 -> 1.3 - Unable to log in

[Andrew Rowland <..hidden..>]

>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

Thanks

Andrew

On Thu, Mar 8, 2012 at 8:25 AM, Chris Travers <..hidden..> wrote:

On Wed, Mar 7, 2012 at 4:17 PM, Andrew Rowland <..hidden..> 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
> ..hidden..
> 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
..hidden..
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users