Cannot Log In (first time) - An Error has occurred

Get Help
1

Hello all,

New to Libretime…

I have installed Libretime and got through the install process and now at the login page and when trying to login for the first time, I am getting an error ‘An error has occurred’.

In the legacy.log file I see this:

Next Zend_Db_Adapter_Exception: SQLSTATE[08006] [7] FATAL: password authentication failed for user “airtime”
FATAL: password authentication failed for user “airtime” in /usr/share/airtime/php/legacy/vendor/zf1s/zend-db/library/Zend/Db/Adapter/Pdo/Abstract.php:144
Stack trace:
#0 /usr/share/airtime/php/legacy/vendor/zf1s/zend-db/library/Zend/Db/Adapter/Pdo/Pgsql.php(87): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /usr/share/airtime/php/legacy/vendor/zf1s/zend-db/library/Zend/Db/Adapter/Abstract.php(861): Zend_Db_Adapter_Pdo_Pgsql->_connect()
#2 /usr/share/airtime/php/legacy/vendor/zf1s/zend-db/library/Zend/Db/Adapter/Abstract.php(931): Zend_Db_Adapter_Abstract->quote(‘mypassword’, NULL)
#3 /usr/share/airtime/php/legacy/vendor/zf1s/zend-auth/library/Zend/Auth/Adapter/DbTable.php(447): Zend_Db_Adapter_Abstract->quoteInto(‘“pass” = MD5(?)’, ‘mypassword’)
#4 /usr/share/airtime/php/legacy/vendor/zf1s/zend-auth/library/Zend/Auth/Adapter/DbTable.php(367): Zend_Auth_Adapter_DbTable->_authenticateCreateSelect()
#5 /usr/share/airtime/php/legacy/vendor/zf1s/zend-auth/library/Zend/Auth.php(117): Zend_Auth_Adapter_DbTable->authenticate()
#6 /usr/share/airtime/php/legacy/application/controllers/LoginController.php(68): Zend_Auth->authenticate(Object(Zend_Auth_Adapter_DbTable))
#7 /usr/share/airtime/php/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Action.php(516): LoginController->indexAction()
#8 /usr/share/airtime/php/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(‘indexAction’)
#9 /usr/share/airtime/php/legacy/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#10 /usr/share/airtime/php/legacy/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#11 /usr/share/airtime/php/legacy/vendor/zf1s/zend-application/library/Zend/Application.php(391): Zend_Application_Bootstrap_Bootstrap->run()
#12 /usr/share/airtime/php/legacy/application/airtime-boot.php(80): Zend_Application->run()
#13 /usr/share/airtime/php/legacy/public/index.php(53): require_once(‘/usr/share/airt…’)
#14 {main}

I have tried resetting the password using the following commands to ensure the password is correct (as the error is quite clear):

(within psql) ALTER USER airtime WITH PASSWORD mypassword
rabbitmqctl change_password airtime mypassword

Could anyone point me in the right direction to resolve and get to log in?

Many thanks.

2

set admin password:

sudo -u postgres psql airtime

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

source

Make sure your /etc/airtime/airtime.conf file reflects the passwords changes you have made with the database and rabbitmqctl (those are the only passwords the website gives directions on how to change.)

some other helpful commands:

check status of all libretime stuff:
sudo systemctl status libretime-analyzer libretime-api libretime-liquidsoap libretime-celery libretime-playout

restart all libretime stuff:
sudo systemctl restart libretime-analyzer libretime-api libretime-liquidsoap libretime-celery libretime-playout

3

Thank you, this helped me get it working in the end, slight confusion over ‘airtime’ and ‘admin’ users.

Thanks.