HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=21)
-   -   MyDNSConfig w/ PHP 5.1.4, MySQL 5.0.24, Apache 2.0.55: Error: No permission (http://www.howtoforge.com/forums/showthread.php?t=7099)

jarre 27th September 2006 00:07

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?

till 27th September 2006 10:01

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');

jarre 27th September 2006 22:30

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 :).

falko 28th September 2006 21:02

Also run this MySQL command:

Code:

UPDATE sys_user SET groups = '1,2' WHERE userid = 1;
Afterwards it should work.

jarre 29th September 2006 17:37

Now working!
 
Thanks, that last update query did the trick, now it's working again.


All times are GMT +2. The time now is 05:35.

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