diff -r 2cd8c1649ba9 -r 58094faf794d docs/REDHAT-README --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/docs/REDHAT-README Tue Apr 10 22:40:43 2007 +0000 @@ -0,0 +1,88 @@ +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 +