I tested version 2.1.6 from the git with postgresql 9.1.

If i add a zone with a template i get this error:

Error: doQuery: [Error message: Could not execute statement] [Last executed query: SELECT substring((SELECT substring(pg_get_expr(d.adbin, d.adrelid) for 128) FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef ) FROM 'nextval[^\']'([^\'])') FROM pg_attribute a LEFT JOIN pg_class c ON c.oid = a.attrelid LEFT JOIN pg_attrdef d ON d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef WHERE (c.relname = 'domains_id' OR (c.relname = 'domains' AND a.attname = 'id') ) AND NOT a.attisdropped AND a.attnum > 0 AND pg_get_expr(d.adbin, d.adrelid) LIKE 'nextval%' ORDER BY a.attnum] [Native message: FEHLER: Syntaxfehler bei »]« LINE 6: ) FROM 'nextval[^\']'([^\']_)') ^]

Same error with 2.1.5 and postgres 9.1.

Hello,

it's a really big problem to us, because we are an isp in austria. So whats the problem? Our customers need to edit their subdomains and IPv4-PTR-Records without our help or anything else. In PowerAdmin v1.0 there was the opportunity to give a user only rights to some records in a zone. Why i cant do this in 2.1.6? Is there a workaround to do this as in the old version? Thank you very much and sorry for my bad english (austria, u knw?).

hi!

in dns.inc.php, function is_valid_hostname_fqdn()

    $hostname = preg_replace("/\.$/","",$hostname);

    if (strlen($hostname) > 255) {
        error(ERR_DNS_HN_TOO_LONG);
        return false;
    }

i think that the length check is wrong because 255 includes the trailing dot.

please see
http://en.wikipedia.org/wiki/Domain_name#Domain_name_syntax and
http://en.wikipedia.org/wiki/Domain_name#cite_note-3

thank you,
raoul

When a template zone has one or more linked domains, it should not permitted to save template without changing also linked domains.

When a template domain has one or more linked zones, it should be only permitted to:

• list linked domains (in the bottom part of the form)
• unlink one or more domains
• save template and change all linked zones

When a template domain has no linked zones, it should only be permitted to save it.

A template could always be cloned, despite of links.

"Type one domaine per line:" should be

"Type one domain per line:"

Owner col should be visible only if $perm_adit = "own", not ALL.

should be:

/* If user has all edit permissions show zone owners */
if ( $perm_edit == "own"){
echo "<th><a href=\"javascript:zone_sort_by('owner')\">" . _('Owner') . "</a></th>\n";
}


AND:

if ( $perm_edit == "own" ) {
echo "<td>" . $zone['owner'] . "</td>";
}


I recently encountered a problem when I tried to use dig AXFR query on one of our zones.
After a fair amount time I found that one of our TXT records contained a pair of trailing dots
in the name fields. After correcting this the AXFR started to work.

While I still looking into how exactly the bad name was entered into the zone.
I did find that it was possible to add a name contain two trailing dots using the insert form
contained w/in the zone page of poweradmin. I did find that you can not edit an
existing record to contain trailing dots

I would ask that you consider adding some processing to the insert form that flags or corrects this condition
t

Thanks,
James

P.S We are using poweradmin v2.1.4 on a CentOS 6.2, and powerdns is v 2.9.22.6-1

Currently Poweradmin can encrypt user passwords using MD5 or MD5SALT algorithms. Encryption mode is defined in configuration file, but there is no way for users how to migrate from one mode to another. Implement interface which will allow to user to migrate their password to different encryption mode. It can be somehow controlled from config.inc.php (allow users to update passwords).

Two unexpected behaviours here;

• User cannot change a native domain and set it up as a slave domain, perhaps this should be possible? If I also add zone_slave_add, then the user can set a pre-existing domain as slave, but then the user also can create new slave zones, this is not desireable. I am trying to create a poweruser template that let users mostly freely edit their own zones, including changing it to slave from their own master server.
• In addition, users are allowed to add additional owners to their zone when meta_edit_own is set, this makes little sense to me unless user also has some privilege that lets them manipulate users. Reason beeing that user can add themselves or remove themselves from the zone metadata, but nothing much else. They are infact allowed to remove themselves and thus "orphaning" the zone.
• Further it seems that they can change the template of the zone, however as they are unable to create or maintain templates this ability also seems unreasonable without additional privileges.

Please consider changing the behaviour. Thanks,
Rune

TXT records don't seem to be edited or saved correctly with double-quotes ". This is a problem with SPF records imported as TXT from bind. A TXT field in the database with content like this:

"spf2.0/pra,mfrom +ip4:1.2.3.0/24 +ip4:4.5.6.0/24 ?all"

Will be displayed in PowerDNS "edit" with backslashes, although sometimes the ending double-quote will be missing.

"spf2.0/pra,mfrom +ip4:1.2.3.0/24 +ip4:4.5.6.0/24 ?all"

Saving this causes duplicate backslashes to appear the next time it's edited:

\"spf2.0/pra,mfrom +ip4:1.2.3.0/24 +ip4:4.5.6.0/24 ?all\"

And worse, a query to PowerDNS returns embedded 's:

example.org. 3600 IN TXT ""spf2.0/pra,mfrom +ip4:1.2.3.0/24 +ip4:4.5.6.0/24 ?all""

Test environment:
Safari 6.0.2 OSX 10.8.2
PowerDNS 3.1 mysql backend
PowerAdmin 2.1.6
Php 5.3.20

When I've defined a supermaster (ip address, local name and user) all zone transfer stuff works fine, except that the received zone's owner is not set. When I edit the received zone I'm slave for, I can set the ownership manually, but would expect this to go automatically since I've already set the "user" when defining the supermaster. Is this a bug or feature request, not clear to me. I'm running version 2.1.6.

Regards,

Leon

BTW: Great product!!!!

The myql_real_escape_string needs a classic mysql connection.

Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /var/www-ssl/padmin/dynamic_update.php on line 32 Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www-ssl/padmin/dynamic_update.php on line 32

The records template should no longer be defined in the config file, it should be in the databases. Preferably, there should be support for multiple templates, which can be created and used by users themselves (or delegated from an admin to a user).

One kind of database implementation is like PowerDNS Administration ( http://sourceforge.net/projects/powerdnsadmin).

The CERT record type is something we need to be able to create records for and it is not currently available from the list of record types.

The trac ticketing instance had a similar ticket from a few years ago ( https://www.poweradmin.org/trac/ticket/89 ).

Doing a "List zones," zones are not sortable by number of records, although the column heading is a hyperlink promising to do just that. It's not all that desirable a feature for us, but probably should not be hyperlinked if not actually sorting.

There are 2 copies of list_permission_templates in users.inc.php -- list_permission_templates and get_list_permission_templates. It looks like a small code cleanup task.

Hello--just tried adding an A record:

()& 3600 IN A 127.0.0.1

This was accepted without comment or error.

Currently it's not possible to sort by owner on the list zones page, because existing implementation initially fetches the list of zones and only later gets info on owner. Another thing is that every zone can have more than one owner. There is workaround for sorting by owner, but it works properly only when zones have one owner:
https://github.com/poweradmin/poweradmin/tree/order_by_single_owner

Integrate portable PHP password hashing framework:
http://www.openwall.com/phpass/
http://www.openwall.com/articles/PHP-Users-Passwords

Proposal: bcrypt could be default encryption (requires php 5.3+)
http://en.wikipedia.org/wiki/Bcrypt

Add language selection box on the logon screen.

We're setting up internal root nameservers so we can use our own TLDs -- like "internal," "vlanXXX," etc. Just tried to add a domain called "hostname.test." It was rejected. Would it be possible to add support for internal-only domains?

As Described in http://rfc-ref.org/RFC-TEXTS/1912/chapter2.html#sub4 CNAMEs should not coexists with other Records.

Poweradmin ignores this rule while saving new or modified records.

New Versions of ISC-Bind (used as public Slave Servers) reject this zones with "failed while receiving responses: CNAME and other data". A lot of Records are ignored until a new zone without this error will be transfered.

It would be a nice feature, if poweradmin would reject this zonemodifications.

Reported by: ryanpq

I am fairly certain I am working with the latest release. I have been developing a custom system based on PowerAdmin and have found and fixed what I believe is a bug and wanted to pass it along to the project.

In inc/record.inc.php line 286 The line currently reads as

if ( $perm_content_edit == "all" || ($perm_content_edit == "own" && $user_is_zone_owner == "0" )) {

This function checks that a user is either an admin or is the owner of the zone and has permissions to edit their own zones. Currently the check allows editing if they have edit permissions and are NOT the owner of the zone. Unless I am mistaken the line should read:

if ( $perm_content_edit == "all" || ($perm_content_edit == "own" && $user_is_zone_owner == "1" )) {

Note: It appears that the ticket system removes the "or" bars in these lines so they wont read exactly as they do in the codebase.

When deleting an A record that has a corresponding PTR record, the PTR record remains after the A record has been deleted, so you have to go in manually and remove the PTR record. Could this be changed so that in effect, PTR records never have to be touched manually?

Hi,

I'm trying to create custom private TLDs for my internal network (eg: .cdz ) with Poweradmin. Unfortunately, Poweradmin doesn't allow me to create/modify zones that contain only the TLD has the zone name. Event if the "dns_strict_tld_check" parameter has been set to false. For example, I can create a master zone "test.cdz" but not "cdz".

I've checked the code, and the problem seems to come from the function "is_valid_hostname_fqdn" in the dns.php file. The function tests if the value of "hostname_labels" variable is 1, which is the case with my private TLDs.

...
if ($label_count == 1) {
return false;
}
...

I've removed the last test from the function and I able the create/modify zones that contains only the TLD has the zone name. But I think it would be better to have a setting in the configuration file for this.

Regards

Yanick

postgresql backend on poweradmin chokes on this:

(line 1107)

$db->setLimit($rowamount, $rowstart);

i've set it to:

$db->setLimit($rowamount . ' OFFSET ' . $rowstart);

which is supported by both mysql (since 4.0.6) and postgres.

Starting with the PowerDNS Authoritative Server 3.0, each served zone can have "metadata". Such metadata determines how this zone behaves in certain circumstances:

http://doc.powerdns.com/domainmetadata.html

After successfully creating a zone template, I tried to add a test zone and got the following error:

The following query generated an error:

INSERT INTO zones (domain_id,
 owner,
 zone_templ_id) VALUES ('',
 '1',
 '1')

SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: ""
LINE 1: ...O zones (domain_id, owner, zone_templ_id) VALUES ('', '1', '...
                                                             ^

When you perform some changes in a template and you press the button "Update zones", all zones where this template is used are flushed. I just lost all my records!!! I had to restore a backup to have them back.
This behaviour is wrong, since all records should be preserved. I am using PowerAdmin v2.1.6

Given a root domain of domainname.tld, we usually create an A record:

domainname.tld. IN A <IP_ADDR>

When creating this record for a domain and checking "Add also reverse record," the forward record is created, but the reverse record isn't.

When you perform some changes in a template and you press the button "Update zones", all zones where this template is used are flushed. I just lost all my records!!! I had to restore a backup to have them back.
This behaviour is wrong, since all records should be preserved. I am using PowerAdmin v2.1.6

HI

since 2.1.6 i am not able to add new PTR records or edit existing records. Error:

Error: Zone has not been updated successfully.

Thanks
Ognjen

I think that there's a strange behavior, I don't know if it's a bug: when you modify the template and then update zones, the SOA serial is reset to the first one (YYYYMMDD00) even if it was modified before (ie: was YYYYMMDD02). Is this correct?

I'm watching update_zone_records in inc/record.inc.php, maybe the solution should be getting the SOA of current zone and update it instead of recreate it

ok: the reset issue seems related to inc/toolkit.inc.php, function parse_template_value, it bring back to 00 the SOA..

so, maybe replacing parse_template_value with update_soa_records if $rtype? is == 'SOA' should work...

I tried to modify the update_zone_records (and update_soa_records) in order to increment the serial instead reset it: http://pastebin.com/tCmKLKJk (I'm not sure that it works fine, because I hadn't so much time to read the entire code!)

dynamic_update updates all A records of the domain id the dyndns-domain belongs to.

Fix:
$updatequery ="UPDATE records SET content ='{$ip}' where name='{$row2["name"]}' and type='A'";

Just noticed that I had to use the search feature or "Show all" to see zones beginning with an underscore (e.g. _tcp.domain.tld). They aren't visible via the alphabetical links. Not a huge bug, just a small inconvenience.

When you perform some changes in a template and you press the button "Update zones", all zones where this template is used are flushed. I just lost all my records!!! I had to restore a backup to have them back.
This behaviour is wrong, since all records should be preserved. I am using PowerAdmin v2.1.6

Having a CNAME in the apex of a DNS zone is not valid configuration. PowerAdmin currently allows them to be created. Caused me a few hours of hunting/debugging this evening to find that one out!

Reported by: rejo Owned by:
Priority: major Milestone: Later
Component: interface Version: 2.1.3

Add usergroup support. Afterwards, a zone or record can be owner by a usergroup, which consists of one or more users.

There could be three different options:

1. Use existing syslog functionality and log user activity
2. Implement activity logging to some external file
3. Store user activity in the database

For zone templates, since they most often contain SOA records, NS records, and MX records--stuff where the left side of the record is implied, why not prepopulate the "Name" field with [ZONE] and the "TTL" field with whatever the system's default is? This'll save some typing, and will remind people what they've set their default TTL to.

i have this error on ubuntu server
installing using apt-get install pdns-server pdns-backend-mysql

You have an error in your SQL
â syntax; check the manual that corresponds to your MySQL server version â
â for the right syntax to use near 'type=InnoDB' at line 10

Currently Poweradmin can encrypt user passwords using MD5 or MD5SALT algorithms. Encryption mode is defined in configuration file, but there is no way for users how to migrate from one mode to another. Right now just add some informative message instead of authentication failed. Implementation of Migration is set to other milestone (separate task).

Hi,

Adding an entry and also check add reverse checkbox for an IP address whos in-addr zone is not handled by poweradmin results in the following error message(s):

Error: Invalid argument(s) given to function %s
Error: Invalid argument(s) given to function get_record_from_id
Error: Invalid argument(s) given to function get_zone_name_from_id Not a valid domainid:
The PTR-record was successfully added.
The record was successfully added.

Id suggest handling this rather than trying to add to a nonexistent zone, also I would suggest considering disabling the add reverse using an ajax call to verify that the zone is available and/or that the user has the proper rights to add an entry to the relevant in-addr zone.

Whatever you decide is your call - but Id suggest better handling this exception than dumping that set of messages on the end user :-)

Best,
Rune

After you remove user, Poweradmin will show:

Notice: Undefined index: zone in /Users/eg/Projects/poweradmin/delete_user.php on line 42
The user has been deleted successfully.

When sorting domains by type (master/native/slave), there should be a secondary sort by name so zones are easily visible. Currently have to use the browser search to find the zone I'm looking for.

If you will try to delete user template which is used for some user then you will get two different messages:

Error: This template is assigned to at least one user.
The permission template has been deleted successfully.

in SVN trunk there is a small bug in function for changing username of user:

file "inc/users.inc.php" line 302
$query = "SELECT id FROM users WHERE username = " . $db->quote($user, 'integer');

i juste replace integer to text:

$query = "SELECT id FROM users WHERE username = " . $db->quote($user, 'text');

then function work.

(Eg. Create new user without FQDN email id, click on commit changes, all entered data will reset with error message on top)

When adding new user, zone etc. If error is encountered during validation when committed (submit) all entered data is reset form is reloaded, user has to enter all data again. instead is should show red border / highlight the box which needs correction, Not reset all data.

We run a /16 network, so we manage several hundred reverse zones. On the third page of pagination, the results from the second page are repeated, followed by a new set of results.

Hello,

I'm testing out PowerAdmin 2.1.6 and ran into the following problem: when adding a record to a zone template, the form accepts a blank content field. There probably should be some sort of error message here.