Re: 1.2 -> 1.3 - Unable to log in

[Chris Travers <..hidden..>]

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