OK so I have a website installed and working fine. Next I installed the whole stack using the “ee install stack all” command
Everything worked perfectly, but when i go to VIMB admin i get this error:
Doctrine\DBAL\Exception\ConnectionException File /var/www/22222/htdocs/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php Line 103 Message An exception occurred while executing 'SELECT COUNT(a0_.id) AS sclr_0 FROM admin.admin a0_': SELECT command denied to user 'vimbadmin'@'localhost' for table 'admin' Code 0 Trace
#0 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\Mysqli\MysqliException))
#1 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\Mysqli\Driver), Object(Doctrine\DBAL\Driver\Mysqli\MysqliException), 'SELECT COUNT(a0...', Array)
#2 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(a0...', Array, Array, NULL)
#3 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(306): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query->_doExecute()
#5 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 4)
#6 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(804): Doctrine\ORM\AbstractQuery->execute(NULL, 4)
#7 /var/www/22222/htdocs/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(833): Doctrine\ORM\AbstractQuery->getSingleResult(4)
#8 /var/www/22222/htdocs/vimbadmin/application/Repositories/Admin.php(27): Doctrine\ORM\AbstractQuery->getSingleScalarResult()
#9 /var/www/22222/htdocs/vimbadmin/application/controllers/AuthController.php(52): Repositories\Admin->getCount()
#10 /var/www/22222/htdocs/vimbadmin/vendor/opensolutions/oss-framework/src/OSS/Controller/Trait/Auth.php(99): AuthController->_preLogin()
#11 /var/www/22222/htdocs/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): AuthController->loginAction()
#12 /var/www/22222/htdocs/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('loginAction')
#13 /var/www/22222/htdocs/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#14 /var/www/22222/htdocs/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#15 /var/www/22222/htdocs/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#16 /var/www/22222/htdocs/vimbadmin/public/index.php(34): Zend_Application->run()
#17 {main}
Things I have tried:
1)Using the default stack command (This Error) - The Database Connection is fine from SSH Terminal as well as from PHPMyAdmin
2)Followed Custom Guide (https://rtcamp.com/tutorials/mail/server/postfix-dovecot-ubuntu/) - Everything worked fine but after i created the mailbox in VIMBAdmin, Access to it through roundcube didnt work
Kindly Help. Only Mail Server is remaining else I am almost done with my server. Also I am using Linode with Debian 7 if it may be needed at all.
Thank you. Have a nice day.