Loading...

ledger-smb-users@lists.sourceforge.net

[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: [Ledger-smb-users] 1.2 -> 1.3 - Unable to log in Erik Huelsmann Thu Mar 08 06:01:08 2012

Hi Andrew,

You could try executing the SQL statement:

GRANT lsmb_<your company>__users_manage TO andrew;

that should give you access to the menu to manage your own access rights.
Be sure to log out and in after executing that statement.

HTH,

Erik.

On Thu, Mar 8, 2012 at 2:28 PM, 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
>
>
> 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