Re: 1.2 -> 1.3 - Unable to log in

On Thu, Mar 8, 2012 at 5:28 AM, Andrew Rowland <andrewr68@...> 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 <chris.travers@...>
> wrote:
>>
>> On Wed, Mar 7, 2012 at 4:17 PM, Andrew Rowland <andrewr68@...>
>> 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
>> > Ledger-smb-users@...
>> > 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
>> Ledger-smb-users@...
>> 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
> Ledger-smb-users@...
> 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/