[SOLVED] update password from psql - Airtime Support Discussions on Sourcefabric Forum

Alexandru Matei · Post edited by Alexandru Matei at 2014-04-07 15:14:42

Hi!

I managed to forget the password I've set for the [only] two users from airtime.

I tried to update the password using this command in psql

#update cc_subjs set pass=crypt('passwd',gen_salt('md5')) where login='alex';

but it doesn't work.

How should I do?

I didn't set the mail recovery and the other options from the interface.

Thanks.

Alex

Cliff Wang

update cc_subjs set pass=md5('123456') where login='alex';

Alexandru Matei

It works.

Thanks.