diff -r ac0ca51809b1 -r 47dd15d8bb8c docs/REDHAT-README --- a/docs/REDHAT-README Wed Apr 18 22:48:49 2007 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,88 +0,0 @@ -RedHat 8.0 BUG and howto 'fix' - -Ok it seems to be that there is some bug in PowerAdmin (for now we assume so). -It is currently reported all on RedHat 8.0 machines. - -The bug seems to be appear when Apache 2.0 is being used with the default -installed PHP RPM on the platform. New shapshots might remove this bug. We havent -tested this yet. If you have any more insights on this bug please email us -at info@poweradmin.sjeemz.nl - -We kindly refer you to http://bugs.php.net/bug.php?id=18648 -We havent tested this out fully yet! Not even the fix since we arent native -RedHat users. - -Quick dirty fix. We just avoid the bug by not using php :) - -NOTE: THIS IS A MYSQL FIX! - -Ok what to do: - -- Login to mysql using the poweradmin account information. -- Issue the following queries: - - -/**************** - * USER TABLE * - ***************/ - -CREATE TABLE users ( -id int(11) NOT NULL, -username varchar(16) NOT NULL default '', -password varchar(255) NOT NULL default '', -fullname varchar(255) NOT NULL default '', -email varchar(255) NOT NULL default '', -description text NOT NULL, -level tinyint(4) NOT NULL default '0', -active tinyint(4) NOT NULL default '0', -PRIMARY KEY (id) -) TYPE=MyISAM; - -/**************** - * ZONES TABLE * - ***************/ - -CREATE TABLE zones ( -id int(11) NOT NULL, -name varchar(255) NOT NULL default '', -owner int(11) NOT NULL default '0', -comment text NOT NULL, -PRIMARY KEY (id) -) TYPE=MyISAM; - - - -/************************ - * INSTALL YOURSELF * - ***********************/ - -- $login == your prefered login -- $full == your fullname -- $pass == your prefered password -- $email == your prefered email -- $desc == your prefered description - -INSERT INTO users VALUES (1,'$login',md5('$pass'),'$full','$email','$description',10,1) - -Example -INSERT INTO users VALUES (1,'trance',md5('test'),'me','trancer@nospam.trancer.nl','its me!',10,1); - -- Ok, now we have a problem. PowerAdmin uses PEAR. And to remain independent PEAR has -its own incrementation functions. For this there is a seperate table. We didnt use pear yet, therefore -the current setup is inconsistent with what pear is thinking (you are one id behind). -We now have to setup a users_seq table for this. - - -CREATE TABLE users_seq ( - id int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (id) -) TYPE=MyISAM; - -INSERT INTO users_seq VALUES (1); - - -Done! It should now work. If you encounter any problems feel free to email us, also monitor the website -bugfixes might come available. - -Roeland, PowerAdmin Team -