viMbadmin 3.0.11 Unexpected Error

[jeduar...@gmail.com]

Hello

I made the installation as the github.com documentation, however to access the browser brings me the following error

Uh oh! Unexpected Error! We're very sorry but something we didn't expect has just happened. We've alerted the web monkeys and, after a severe flogging, they will get it fixed as soon as possible. Please feel free to email the Example Support Team

Development Platform Detected! Display errors enabled via application.ini. Disable in production!

Doctrine\DBAL\Exception\ConnectionException

File

/usr/local/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 vimbadmin.admin a0_': SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'vimbadmin'@'localhost' for table 'admin'

Code

0

Trace

#0 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /usr/local/vimbadmin/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT COUNT(a0...', Array)
#2 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(a0...', Array, Array, NULL)
#3 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query->_doExecute()
#5 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 4)
#6 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(804): Doctrine\ORM\AbstractQuery->execute(NULL, 4)
#7 /usr/local/vimbadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(833): Doctrine\ORM\AbstractQuery->getSingleResult(4)
#8 /usr/local/vimbadmin/application/Repositories/Admin.php(27): Doctrine\ORM\AbstractQuery->getSingleScalarResult()
#9 /usr/local/vimbadmin/application/controllers/AuthController.php(52): Repositories\Admin->getCount()
#10 /usr/local/vimbadmin/vendor/opensolutions/oss-framework/src/OSS/Controller/Trait/Auth.php(99): AuthController->_preLogin()
#11 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): AuthController->loginAction()
#12 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('loginAction')
#13 /usr/local/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 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#15 /usr/local/vimbadmin/vendor/zendframework/zendframework1/library/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#16 /usr/local/vimbadmin/public/index.php(34): Zend_Application->run()
#17 {main}

Version vimbadmin: 3.0.11

Version PHP: PHP 5.5.9-1ubuntu4.7 (cli) (built: Mar 16 2015 20:47:39)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies

Version Mysql: mysql  Ver 14.14 Distrib 5.5.41,

Version Ubuntu:14.04

[Barry O'Donovan]

On 26/03/2015 03:13, jeduar...@gmail.com wrote:
> I made the installation as the github.com documentation, however to
> access the browser brings me the following error

Which is:

> Message
> An exception occurred while executing 'SELECT COUNT(a0_.id) AS
> sclr_0 FROM vimbadmin.admin a0_': SQLSTATE[42000]: Syntax error or
> access violation: 1142 SELECT command denied to user
> 'vimbadmin'@'localhost' for table 'admin'

Ie. you have a MySQL permissions problem.

Check you created the MySQL user correct, check the details in
application.ini are correct and check that you use those same details on
the command line:

mysql -h $host -u user -p$pass $database -e "SELECT COUNT(a0_.id) AS
sclr_0 FROM vimbadmin.admin a0_;"


- Barry

[jeduar...@gmail.com]

Yes, verifying the information in application.ini are correct, however looking at the so bank has this information

mysql> show tables;

+ ------------------------ +

| Tables_in_vimbadmin_db |

+ ------------------------ +

| Domain_admins |

+ ------------------------ +

I think that's why the select this not working

[Barry O'Donovan]

Try: https://groups.google.com/forum/#!topic/vimbadmin-discuss/9UmB-YM1zig

On 26/03/2015 14:08, jeduar...@gmail.com wrote:
> Yes, verifying the information in application.ini are correct, however
> looking at the so bank has this information
>
> mysql> show tables;
> + ------------------------ +
> | Tables_in_vimbadmin_db |
> + ------------------------ +
> | Domain_admins |
> + ------------------------ +
>
> I think that's why the select this not working
>
> Em quinta-feira, 26 de março de 2015 03:08:30 UTC-3, barryo escreveu:
>
>
>

> On 26/03/2015 03:13, jeduar...@gmail.com <javascript:> wrote:
> > I made the installation as the github.com <http://github.com>

> documentation, however to
> > access the browser brings me the following error
>
> Which is:
>
> > Message
> > An exception occurred while executing 'SELECT COUNT(a0_.id) AS
> > sclr_0 FROM vimbadmin.admin a0_': SQLSTATE[42000]: Syntax
> error or
> > access violation: 1142 SELECT command denied to user
> > 'vimbadmin'@'localhost' for table 'admin'
>
> Ie. you have a MySQL permissions problem.
>
> Check you created the MySQL user correct, check the details in
> application.ini are correct and check that you use those same
> details on
> the command line:
>
> mysql -h $host -u user -p$pass $database -e "SELECT COUNT(a0_.id) AS
> sclr_0 FROM vimbadmin.admin a0_;"
>
>
> - Barry
>
>

> --
> --
> --
>
> ViMbAdmin :: Virtual Mailbox Administration ::
> https://github.com/opensolutions/ViMbAdmin
>
> You received this message because you are subscribed to the Google
> Groups "vimbadmin-discuss" group.
> To post to this group, send email to vimbadmi...@googlegroups.com
> To unsubscribe from this group, send email to
> vimbadmin-disc...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/vimbadmin-discuss?hl=en
> ---
> You received this message because you are subscribed to the Google
> Groups "vimbadmin-discuss" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to vimbadmin-disc...@googlegroups.com
> <mailto:vimbadmin-disc...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

--
Kind regards,
Barry O'Donovan

Open Solutions - Internet Infrastructure Specialists

Web: http://www.opensolutions.ie/
Mob: +353 86 801 7669

Open Source Solutions Ltd
7th Floor, North Block,
Rockfield Central,
Dundrum, Dublin 16.

Open Source Solutions Limited is a company registered in the Republic
of Ireland (#438231). Open Source Solutions Limited trades as Open
Solutions (registered business name #329120).