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 27th September 2006, 00:07
jarre jarre is offline
Junior Member
 
Join Date: Sep 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default MyDNSConfig w/ PHP 5.1.4, MySQL 5.0.24, Apache 2.0.55: Error: No permission

I'm running Debian Sarge 3.1, which was installed following these instructions: [URL="http://www.howtoforge.com/perfect_setup_debian_sarge"]

Everything was working fine, including MyDNSConfig. Shortly after the initial installation I upgraded PHP and MySQL to version 5, PHP 5.1.4 and MySQL 5.0.24 to be exact. After that upgrade I'm getting this error:

Quote:
Error:
You don't have the permission to view this record or this record does not exist!
This error occurs when I try to add or edit users, groups or servers from MyDNSConfig System panel, and also when I try to see or edit a particular SOA, eg:

Quote:
.../MyDNSConfig/web/dns/soa_edit.php?id=1
I'm stunned, what could be the problem?
Reply With Quote
Sponsored Links
  #2  
Old 27th September 2006, 10:01
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,748
Thanks: 821
Thanked 5,328 Times in 4,181 Posts
Default

Please add the following database table and records to your mydnsconfig database:

Quote:
CREATE TABLE sys_group (
groupid int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
description text NOT NULL,
PRIMARY KEY (groupid)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

#
# Daten für Tabelle `sys_group`
#

INSERT INTO sys_group VALUES (1, 'admin', 'Administrators group');
INSERT INTO sys_group VALUES (2, 'user', 'Users Group');
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th September 2006, 22:30
jarre jarre is offline
Junior Member
 
Join Date: Sep 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thanks, but that didn't help

Thank You, till, for the advise, but it didn't solve the problem. I'm still getting the same errors.

At the moment I have four tables in my mydnsconfig database:

rr
soa
sys_group
sys_user

sys_group table looks like this:

Quote:
mysql> select * from sys_group;
+---------+-------+----------------------+
| groupid | name | description |
+---------+-------+----------------------+
| 1 | admin | Administrators group |
| 2 | user | Users Group |
+---------+-------+----------------------+
And the sys_user table looks like this:

Quote:
mysql> select * from sys_user;
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
| userid | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | username | passwort | modules | startmodule | app_theme | typ | active | name | vorname | unternehmen | strasse | ort | plz | land | email | url | telefon | fax | language | groups | default_group |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
| 1 | 1 | 1 | riud | riud | | admin | e1937535a4786e44494dcedd606d0b2d | dns,admin | dns | default | admin | 1 | | Administrator | | | | | | | | | | en | | 0 |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
Any further advise on how to solve this problem is highly appreciated .
Reply With Quote
  #4  
Old 28th September 2006, 21:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Also run this MySQL command:

Code:
UPDATE sys_user SET groups = '1,2' WHERE userid = 1;
Afterwards it should work.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 29th September 2006, 17:37
jarre jarre is offline
Junior Member
 
Join Date: Sep 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Now working!

Thanks, that last update query did the trick, now it's working again.
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
Freebsd 6.1 support misterm Installation/Configuration 10 9th April 2009 09:29
Slightly Confused (DNS & Server Help) JohnnyBGoode Installation/Configuration 26 14th August 2007 09:54
php script injections Grizzly General 21 18th July 2006 08:55
Downgrade php5 to php4.4.2 llizards Installation/Configuration 4 13th March 2006 23:58
apache , mysql and php aolex Server Operation 4 15th October 2005 20:19


All times are GMT +2. The time now is 11:17.


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