Getting error when trying to install - Unhandled System_Db_Exception: CREATE VIEW

Submitted by kastler on 2013-11-15

I've confirmed that the tables all seem to be created, but then I get this:

Configure your WebIssues Server

Installation failed with the following fatal error:

Unhandled System_Db_Exception: CREATE VIEW command denied to user 'web34'@'localhost' for table 'nss_effective_rights' in /var/www/web34/html/support/system/db/mysqli/engine.inc.php on line 287
Stack trace:
#0 /var/www/web34/html/support/system/db/mysqli/engine.inc.php(101): System_Db_Mysqli_Engine->handleError(Object(mysqli))
#1 /var/www/web34/html/support/system/db/mysqli/engine.inc.php(79): System_Db_Mysqli_Engine->executeQuery('CREATE VIEW nss...')
#2 /var/www/web34/html/support/system/db/connection.inc.php(215): System_Db_Mysqli_Engine->execute('CREATE VIEW nss...', Array)
#3 /var/www/web34/html/support/system/db/connection.inc.php(186): System_Db_Connection->executeArgs('CREATE VIEW {ef...', Array)
#4 /var/www/web34/html/support/system/db/schemagenerator.inc.php(113): System_Db_Connection->execute('CREATE VIEW {ef...')
#5 /var/www/web34/html/support/admin/setup/installer.inc.php(293): System_Db_SchemaGenerator->createView('effective_right...', 'SELECT p.projec...')
#6 /var/www/web34/html/support/admin/setup/install.php(419): Admin_Setup_Installer->installSchema()
#7 /var/www/web34/html/support/admin/setup/install.php(148): Admin_Setup_Install->installDatabase()
#8 /var/www/web34/html/support/admin/setup/install.php(57): Admin_Setup_Install->processForm()
#9 /var/www/web34/html/support/system/web/component.inc.php(100): Admin_Setup_Install->execute()
#10 /var/www/web34/html/support/system/web/application.inc.php(77): System_Web_Component->run()
#11 /var/www/web34/html/support/system/core/application.inc.php(210): System_Web_Application->execute()
#12 /var/www/web34/html/support/system/bootstrap.inc.php(130): System_Core_Application->run()
#13 /var/www/web34/html/support/admin/setup/install.php(509): System_Bootstrap::run('Common_Applicat...', 'Admin_Setup_Ins...')
#14 {main}

As the error message says, the DB user doesn't have permissions to create a view.

Regards,
Michał