Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > MyDNSConfig > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 3rd May 2007, 20:35
wrd wrd is offline
Junior Member
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Admin user can't see user-created records

I created a test user, 'cg', and logged in as that user. I then created a new SOA and a new record. After saving, the 'cg' user can see and edit the new record.

I logged out and logged back in as the admin user. I can see the SOA record in the list, but when I click on it, I get "You don't have the permission to view this record or this record does not exist!"

The recor'ds sys_userid is 3, sys_groupid is 0, and sys_perm_user and sys_perm_group are both set to riud.

Any thoughts?
Reply With Quote
Sponsored Links
  #2  
Old 5th May 2007, 13:06
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,713
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

It should normally work with these permissions. I will have to check that. A workaround might be to define a group and make the admin and user members of this group. The group must be set as default group for the user, so every new record will be owned by the group too.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 19th May 2007, 01:14
sqlparrot sqlparrot is offline
Junior Member
 
Join Date: May 2007
Location: California
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default mydnsimport issue is how I fixed this..

Greetings!

I used mydnsimport to shove our dns1 into a mydns system. Using mydnsconfig was pretty easy -I had to hack the install a bit for my apache2 (Suse 10 Enterprise) but its working now.

I also rec'd the "You do not have permission..." message. After double checking the db permissions for the backend login on the mydnsconfig site, and finding I really did do that part correctly, I went looking at the tables.

Nothing stood out so I built a bogus entry in the system. Aha!

In my SOA table -these columns were null on all auto-imports, but 1 on the bogus entry: sys_userid, sys_groupid

Also in SOA table -these columns said, "riud": sys_permuser, sys_permgroup.

I ran an update query that went something like this:

UPDATE `mydns`.`soa`
SET sys_userid = 1, sys_groupid = 1, sys_permuser = 'riud', sys_permgroup = 'riud';

Tada! Now when I click on an imported SOA I can go browse the groups.

A minor detail, but I bet someone has bumped into it and gotten frustrated.

This could be why making groups and moving users works. It sets the ids whereas they may be null w/o this.

A default value of 1 might be good on the table defs, then anything inserted will always drop into the admin group bucket... just don't forget the 'riud' as well!

-Squawk Squawk

-The SQLParrot
Reply With Quote
  #4  
Old 19th May 2007, 01:30
sqlparrot sqlparrot is offline
Junior Member
 
Join Date: May 2007
Location: California
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Followon with rr table

The rr table also needs an update...

UPDATE rr
SET sys_userid = 1, sys_groupid = 1, sys_perm_user = 'riud', sys_perm_group = 'riud';

This was discovered when I went to edit a record -after having fixed the SOA table -the RR table refused to let me edit entries. -Suspecting the same issue with the auto-import tool, I updated the table columns and it all is flyin' now.

-The Parrot
Reply With Quote
  #5  
Old 19th May 2007, 10:34
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,713
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
 
Default

The auto import tool is for a plain mydns database and not for mydnsconfig. Mydnsconfig uses some extra database column to store the permissions for the database records which have to be added after import as you did.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
Anything I can do against illegal login-requests? schmidtedv Installation/Configuration 17 7th November 2008 09:25
Admin access and user listing is broken cryptic General 4 31st December 2006 20:27
Rename folder -> create new folder equals contents of old folder BlueStream General 20 15th December 2006 03:32
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs pontifex HOWTO-Related Questions 2 26th October 2005 17:54


All times are GMT +2. The time now is 10:20.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.