Admin account not working
  • My admin for some reason stopped working.  I went through the forum and also tried to modify the db directly but it does not work.   I ran the following in the database but still I cannot gain access using the admin account.   I tried to delete it from the Airtime GUI but I assume that since it is a admin account it cannot be deleted.  This is about the 3rd time I had problems with the account.  In the past I ran the same SQL commands to change it and it did work but now it does not.  I using 2.4.1.  The SQL command I ran is:
    update cc_subjs set pass = md5('password') where login = 'admin';

  • 5 Comments sorted by
  • Vote Up0Vote Down Cliff WangCliff Wang
    Posts: 339Member, Sourcefabric Team
    Probably admin is already removed from cc_subjs.

    Try:
    select * from cc_subjs where login='admin';
    Cloud Radio -> http://airtime.pro
  • Vote Up0Vote Down hoerichhoerich
    Posts: 627Member, Airtime Moderator
    this should reactivate admin-user, maybe it helps

    sudo -u postgres psql airtime -c "DELETE from cc_pref where keystr = 'library_datatable' and subjid = 1"

    cheers
    Official Airtime Forum Manager
    --------------------------
    Most of the time an issue is located between keyboard and chair.
  • Now this is weird.  I tried the admin account and it now works.  Did nothing except the "select * from cc_subjs where login='admin';" to check the existence of the admin account.  @hoerich did not run yours since the account is back.

  • Vote Up0Vote Down hoerichhoerich
    Posts: 627Member, Airtime Moderator
    anyways, let's mark this discussion as solved.
    Official Airtime Forum Manager
    --------------------------
    Most of the time an issue is located between keyboard and chair.
  • Vote Up0Vote Down Albert FRAlbert FR
    Posts: 1,978Member, Airtime Moderator
    another way is to do a :

    dpkg-reconfigure airtime