Sorry! Failed to set up Icinga Web 2 successfully - SQLSTATE[42000]

Icinga Web
1

Hello Guys,

I’m setting up a fresh new icinga installation, when I was configuring icingaweb using the cli on the browser, at the very last step I got the following error

image
image1869×541 46.1 KB

Has someone experienced this or has a clue on how to fix it?

I appreciate your time.

2

I’ve fixed this by adding
innodb_file_per_table=true
innodb_large_prefix=1
innodb_file_format=Barracuda

to the /etc/my.cnf file and restarting the db service

1 Like