forgot airtime password - Airtime Support Discussions on Sourcefabric Forum

johngough

As the title suggests I have forgotten my login to Airtime 1.8.2.
How can I recover/reset it??

many thanks
j

Martin Konecny

Hi John,

There is no simple way to do it in 1.8.2. In Airtime 1.9, we've added a simple command line utility to do this.

I can post instructions later today on how to modify the password by modifying the Airtime database directly, if you're up for getting your hands dirty.

johngough

Damn was hoping you wouldn't say that:) yes ill get my hands dirty trying it. It might be worth having instrictions posted here anyway!

I would appreciate some instructions hiw to do it.

Thanks Martin

P. S the airtime i'm locked out of isn't in production yet so i could do a fresh install with 1.9.3. Would that overwrite my old password and database? If it does it would be a simple workaround for me, the library is not important!

On 1 Sep 2011, at 16:27, Martin Konecny <airtime-support@lists.sourcefabric.org> wrote:

>
> Hi John,
>
> There is no simple way to do it in 1.8.2. In Airtime 1.9, we've added a simple command line utility to do this.
>
> I can post instructions later today on how to modify the password by modifying the Airtime database directly, if you're up for getting your hands dirty.
>

Martin Konecny

Ok its actually pretty simple Smile

First lets connect to the airtime database with root permissions:

sudo -u postgres psql airtime

Now we are connected to the database. Next we insert the following command:

update cc_subjs set pass = md5('your_new_password') where login = 'admin';

And that's all. Return back to the terminal using "\q"

As for your 1.9.3 question, installing this version would upgrade from your 1.8.2 install and keep your database intact while also giving you access to the "airtime-user" commandline utility which allows you to change the password of any user.

johngough

Thanks Martin, that was way easier than I thought it would be.
best
j

Paul Baranowski

Yes, a reinstall would fix the problem as well.

Albert FR

Hi,

I've installed the 1.9.4 tonight and admin user can't connect
password seems wrong

i'm working with psql 8.4 on lucid

how i can change the passwd

thanks

Martin Konecny

Try using "airtime-user" command from the command prompt. It should give you instructions how to use it.

Albert FR

this command is not available Sad

Martin Konecny

Ill look into why that isn't available before we release 1.9.4. In the meantime, you can simply follow these steps:

http://forum.sourcefabric.org/index.php/mv/msg/3934/12536/#m sg_12536

Albert FR

psql says : table do not exist, very strange...

Martin Konecny

Thats strange, looks like the database isn't setup properly.

What shows up when you type

\dt

from the psql prompt?

Howdy, Stranger!

Categories

Poll

Top Posters