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
