[GH-ISSUE #138] ViMbAdmin does not work anymore after 3.0.11 update #106

New issue

Closed

opened 2026-02-26 09:35:57 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 09:35:57 +03:00

Owner

Originally created by @liayn on GitHub (May 27, 2015).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/138

Hi!

I updated from .10 to .11 following
https://github.com/opensolutions/ViMbAdmin/wiki/Updating

git checkout was successful
composer update did quite some work
bin/doctrine2-cli.php orm:validate-schema reported everything to be ok

Error is:

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 'mailserver'@'webserver' for table 'admin'

application.ini:

resources.doctrine2.connection.options.driver   = 'pdo_mysql'
resources.doctrine2.connection.options.dbname   = 'mailserver'
resources.doctrine2.connection.options.user     = 'mailserver'
resources.doctrine2.connection.options.password = '....'
resources.doctrine2.connection.options.host     = 'dbserver'
resources.doctrine2.connection.options.charset  = 'utf8'

I also updated entities, proxies and repos as described, which resulted in some changes, but didn't resolve the issue.

Why is it selecting from "vimbadmin.admin"?
My database name is "mailserver" as configured.

DB credentials are ok, I verified them on command line.

Any help really appreciated. Thanks a lot.

Originally created by @liayn on GitHub (May 27, 2015). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/138 Hi! I updated from .10 to .11 following https://github.com/opensolutions/ViMbAdmin/wiki/Updating - `git checkout` was successful - `composer update` did quite some work - `bin/doctrine2-cli.php orm:validate-schema` reported everything to be ok Error is: ``` 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 'mailserver'@'webserver' for table 'admin' ``` application.ini: ``` resources.doctrine2.connection.options.driver = 'pdo_mysql' resources.doctrine2.connection.options.dbname = 'mailserver' resources.doctrine2.connection.options.user = 'mailserver' resources.doctrine2.connection.options.password = '....' resources.doctrine2.connection.options.host = 'dbserver' resources.doctrine2.connection.options.charset = 'utf8' ``` I also updated entities, proxies and repos as described, which resulted in some changes, but didn't resolve the issue. Why is it selecting from "vimbadmin.admin"? My database name is "mailserver" as configured. DB credentials are ok, I verified them on command line. Any help really appreciated. Thanks a lot.

kerem closed this issue

2026-02-26 09:35:57 +03:00

kerem commented

2026-02-26 09:35:58 +03:00

Author

Owner

@liayn commented on GitHub (May 27, 2015):

Resolved by fixing the doctrine schema. See https://github.com/opensolutions/ViMbAdmin/issues/124#issuecomment-106100832

@liayn commented on GitHub (May 27, 2015): Resolved by fixing the doctrine schema. See https://github.com/opensolutions/ViMbAdmin/issues/124#issuecomment-106100832