dns management

[uwe]

hello, as i mentioned before, i was trying to integrate pdns admin with ispcp, maybe it would be a good idea to have pdns-admin or a customized version of it in tools/ rather than building something from scratch ... im posting here a rough description of what ive done to get it a little integrated, but by no means in a usable or correct way, but maybe useful for someone who wants to make it work by hacking ispcp too

i installed pdns-admin, and configured it to use ispcp db, then i dropped the users table and created the following view:


create VIEW users as select admin.admin_id AS user_id , admin_name AS user_name, admin_pass AS user_password ,admin_type_id AS user_group , "default" AS user_skin,lang AS user_language,email AS user_email, count(domain_name) AS user_domains,admin_missing_data.* from admin inner join admin_type_id on admin_type_id.admin_type = admin.admin_type inner join user_gui_props on admin.admin_id = user_gui_props.id left outer join domain on admin.admin_id = domain.domain_admin_id OR admin.admin_id = domain.domain_created_id OR admin_id=1 LEFT OUTER JOIN admin_missing_data ON admin.admin_id=admin_missing_data.admin_id GROUP BY admin.admin_id UNION (select 0 AS user_id,"guest" AS user_name,"" AS user_password,"4" AS user_group,"default" AS user_skin,"lang_English" AS user_language,"" AS user_email,0 AS user_domains ,NULL,NULL,NULL,NULL,NULL);

and changed the UID of guest in pdns-admin to 0 instead of 1, and ofcourse i had to create tables to map user_group and admin type, pretty stright forward:
+------------+---------------+
| admin_type | admin_type_id |
+------------+---------------+
| admin | 1 |
| reseller | 2 |
| user | 3 |
+------------+---------------+

and a table with missing data from admin .

then a few things commented out of pdns-admin, pretty obvious queries (i dont remember exactly which)

now i can login using the same user name and password of ispcp into pdns-admin, but ofcourse no domains that are created by ispcp can be viewed since ispcp writes bind files directly, other wise i can now create cusotm domains and override those used with ispcp by making pdns my defualt dns and using bind files as one of the backends.

hope it helps someone