MyDNSConfig w/ PHP 5.1.4, MySQL 5.0.24, Apache 2.0.55: Error: No permission

[jarre]

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:

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:

.../MyDNSConfig/web/dns/soa_edit.php?id=1

I'm stunned, what could be the problem?

[till]

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

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]

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:

mysql> select * from sys_group;
+---------+-------+----------------------+
| groupid | name | description |
+---------+-------+----------------------+
| 1 | admin | Administrators group |
| 2 | user | Users Group |
+---------+-------+----------------------+

And the sys_user table looks like this:

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]

Also run this MySQL command:

UPDATE sys_user SET groups = '1,2' WHERE userid = 1;

Afterwards it should work.

[jarre]

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