LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-23-2011, 02:41 AM   #1
mark305
LQ Newbie
 
Registered: Dec 2011
Posts: 4

Rep: Reputation: Disabled
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
 
Old 12-23-2011, 02:49 AM   #2
Habbie
LQ Newbie
 
Registered: Dec 2011
Posts: 8

Rep: Reputation: Disabled
Hi Mark,

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

- Peter
 
Old 12-23-2011, 02:51 AM   #3
Habbie
LQ Newbie
 
Registered: Dec 2011
Posts: 8

Rep: Reputation: Disabled
https://github.com/poweradmin/powera...-structure.sql may be of use.
 
Old 12-23-2011, 02:58 AM   #4
mark305
LQ Newbie
 
Registered: Dec 2011
Posts: 4

Original Poster
Rep: Reputation: Disabled
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 !
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Fedora 12 LXer Syndicated Linux News 0 06-21-2010 02:50 PM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 9.10 LXer Syndicated Linux News 0 04-16-2010 11:10 AM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Fedora 10 LXer Syndicated Linux News 0 02-14-2009 01:02 AM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 8.10 LXer Syndicated Linux News 0 01-30-2009 10:50 AM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Etch LXer Syndicated Linux News 0 01-20-2009 06:00 PM


All times are GMT -5. The time now is 03:57 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration