Current time: 10-21-2020, 06:10 AM Hello There, Guest! (LoginRegister)


Post Reply 
dns management
Author Message
uwe Offline
Junior Member
*

Posts: 68
Joined: Feb 2008
Reputation: 0
Post: #26
RE: dns management
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 Smile

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
03-24-2008 01:18 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
dns management - kevin666 - 02-12-2008, 03:22 PM
RE: dns management - blocker - 02-12-2008, 03:38 PM
RE: dns management - kevin666 - 02-12-2008, 03:41 PM
RE: dns management - gOOvER - 02-12-2008, 04:19 PM
RE: dns management - kevin666 - 02-12-2008, 04:33 PM
RE: dns management - gOOvER - 02-12-2008, 04:40 PM
RE: dns management - kevin666 - 02-12-2008, 04:50 PM
RE: dns management - kevin666 - 02-12-2008, 04:56 PM
RE: dns management - MicCo - 02-12-2008, 07:17 PM
RE: dns management - kevin666 - 02-12-2008, 07:38 PM
RE: dns management - joximu - 02-12-2008, 07:45 PM
RE: dns management - MicCo - 02-12-2008, 11:03 PM
RE: dns management - RedBOX - 02-23-2008, 03:33 AM
RE: dns management - uwe - 03-01-2008, 09:21 PM
RE: dns management - joximu - 03-01-2008, 09:24 PM
RE: dns management - popsikle - 03-07-2008, 08:34 AM
RE: dns management - uwe - 03-08-2008, 12:13 AM
RE: dns management - Kika - 03-12-2008, 12:42 AM
RE: dns management - uwe - 03-12-2008, 11:38 AM
RE: dns management - uwe - 03-13-2008, 11:03 PM
RE: dns management - joximu - 03-14-2008, 06:51 AM
RE: dns management - kevin666 - 03-14-2008, 06:26 PM
RE: dns management - vacancy - 03-14-2008, 06:41 PM
RE: dns management - kevin666 - 03-14-2008, 06:46 PM
RE: dns management - uwe - 03-23-2008, 11:25 PM
RE: dns management - uwe - 03-24-2008 01:18 AM
RE: dns management - Aneu - 03-26-2008, 09:00 AM
RE: dns management - uwe - 04-03-2008, 10:21 PM
RE: dns management - TrippleEx - 05-28-2008, 12:50 AM
RE: dns management - uwe - 07-14-2008, 05:35 PM
RE: dns management - antencek - 07-15-2008, 03:26 AM
RE: dns management - MicCo - 07-15-2008, 03:54 AM
RE: dns management - antencek - 07-15-2008, 08:02 PM
RE: dns management - MicCo - 07-15-2008, 09:55 PM
RE: dns management - xister - 07-15-2008, 09:11 PM
RE: dns management - uwe - 08-03-2008, 10:12 PM
RE: dns management - antencek - 11-04-2009, 09:49 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)