search

opensolutions / ViMbAdmin

Virtual Mailbox Administration
http://www.vimbadmin.net/
GNU General Public License v3.0
485 stars 101 forks source link

Issue whilke Database Creation #284

Closed Vaibhav4697 closed 2 years ago

Vaibhav4697 commented 2 years ago

I have been following the steps and when I am trying to create the database with the command below, it throwing me such error.

Database Creation Now that your configuration is set and you have setup a database and user in MySQL, you need to create the database schema:

cd $INSTALL_PATH ./bin/doctrine2-cli.php orm:schema-tool:create

Error: image Can you please give it a look, what is it about?

mfechner commented 2 years ago

I think the error message is very clear. The user vimbadmin does not have the permissions it requires. Or you use a wrong password.

Vaibhav4697 commented 2 years ago

Yeah, I know that but I have granted all the permission to this user in mysql and I have also verified the password many times.

barryo commented 2 years ago

In your application.ini file, you'll have config like:

resources.doctrine2.connection.options.driver   = 'pdo_mysql'
resources.doctrine2.connection.options.dbname   = 'vimbadmin'
resources.doctrine2.connection.options.user     = 'vimbadmin'
resources.doctrine2.connection.options.password = 'password'
resources.doctrine2.connection.options.host     = 'localhost'

Taking these exactly as they are and on the same server as ViMbAdmin, this should work:

mysql -h localhost -u vimbadmin -ppassword vimbadmin