LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Installing poweradmin for PowerDNS (https://www.linuxquestions.org/questions/linux-newbie-8/installing-poweradmin-for-powerdns-920144/)

mark305 12-23-2011 01:41 AM
Installing poweradmin for PowerDNS
 
Hi,

I am trying to install poweradmin for powerDNS following this tutorial:
http://www.howtoforge.com/installing...-on-centos-5.2

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:
Code:
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:
http://doc.powerdns.com/configuring-db-connection.html

Am I doing something wrong? I can't just create the table because I don't know the columns.

Thanks

- Mark

Habbie 12-23-2011 01:49 AM
Hi Mark,

PowerAdmin is supposed to create this table. Are you sure the MySQL account you made for it has enough permissions?

- Peter

Habbie 12-23-2011 01:51 AM
https://github.com/poweradmin/powera...-structure.sql may be of use.

mark305 12-23-2011 01:58 AM
I am using the root account... I'll try the SQL you suggested and let you know if it works.

Thanks a lot and Merry Christmas !


All times are GMT -5. The time now is 09:30 PM.