I am trying to install poweradmin for powerDNS following this tutorial:
I have got as far as running the "install" script through the browser for Poweradmin, and after I enter the database details in step 3, and click "go to step 4", I get a page of SQL (which it seems it successfully executed) and then this error:
Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_15019023f95d398308652e1295f39f4cab37881ee FROM 'INSERT INTO perm_items VALUES (?, ?, ?)'] [Native code: 1146] [Native message: Table 'powerdns.perm_items' doesn't exist]
Obviously it means there is a table missing, so I double checked I didn't miss the create table statement in the SQL and then went to the official documentation and ran the SQL it suggests there just to ensure the tutorial wasn't out of date:
Am I doing something wrong? I can't just create the table because I don't know the columns.