docs/REDHAT-README
changeset 8 47dd15d8bb8c
parent 7 ac0ca51809b1
child 9 d55459cd1712
equal deleted inserted replaced
7:ac0ca51809b1 8:47dd15d8bb8c
     1 RedHat 8.0 BUG and howto 'fix'
       
     2 
       
     3 Ok it seems to be that there is some bug in PowerAdmin (for now we assume so).
       
     4 It is currently reported all on RedHat 8.0 machines.
       
     5 
       
     6 The bug seems to be appear when Apache 2.0 is being used with the default
       
     7 installed PHP RPM on the platform. New shapshots might remove this bug. We havent
       
     8 tested this yet. If you have any more insights on this bug please email us
       
     9 at info@poweradmin.sjeemz.nl
       
    10 
       
    11 We kindly refer you to http://bugs.php.net/bug.php?id=18648
       
    12 We havent tested this out fully yet! Not even the fix since we arent native
       
    13 RedHat users.
       
    14 
       
    15 Quick dirty fix. We just avoid the bug by not using php :)
       
    16 
       
    17 NOTE: THIS IS A MYSQL FIX!
       
    18 
       
    19 Ok what to do:
       
    20 
       
    21 - Login to mysql using the poweradmin account information.
       
    22 - Issue the following queries:
       
    23 
       
    24 
       
    25 /****************
       
    26  * USER TABLE	*
       
    27  ***************/
       
    28 
       
    29 CREATE TABLE users (
       
    30 id int(11) NOT NULL,
       
    31 username varchar(16) NOT NULL default '',
       
    32 password varchar(255) NOT NULL default '',
       
    33 fullname varchar(255) NOT NULL default '',
       
    34 email varchar(255) NOT NULL default '',
       
    35 description text NOT NULL,
       
    36 level tinyint(4) NOT NULL default '0',
       
    37 active tinyint(4) NOT NULL default '0',
       
    38 PRIMARY KEY  (id)
       
    39 ) TYPE=MyISAM;
       
    40 
       
    41 /****************
       
    42  * ZONES TABLE	*
       
    43  ***************/
       
    44 
       
    45 CREATE TABLE zones (
       
    46 id int(11) NOT NULL,
       
    47 name varchar(255) NOT NULL default '',
       
    48 owner int(11) NOT NULL default '0',
       
    49 comment text NOT NULL,
       
    50 PRIMARY KEY  (id)
       
    51 ) TYPE=MyISAM;
       
    52 
       
    53 
       
    54 
       
    55 /************************
       
    56  * INSTALL YOURSELF	*
       
    57  ***********************/
       
    58 
       
    59 - $login == your prefered login
       
    60 - $full	== your fullname
       
    61 - $pass == your prefered password
       
    62 - $email == your prefered email
       
    63 - $desc == your prefered description
       
    64 
       
    65 INSERT INTO users VALUES (1,'$login',md5('$pass'),'$full','$email','$description',10,1)
       
    66 
       
    67 Example
       
    68 INSERT INTO users VALUES (1,'trance',md5('test'),'me','trancer@nospam.trancer.nl','its me!',10,1);
       
    69 
       
    70 - Ok, now we have a problem. PowerAdmin uses PEAR. And to remain independent PEAR has
       
    71 its own incrementation functions. For this there is a seperate table. We didnt use pear yet, therefore
       
    72 the current setup is inconsistent with what pear is thinking (you are one id behind).
       
    73 We now have to setup a users_seq table for this.
       
    74 
       
    75 
       
    76 CREATE TABLE users_seq (
       
    77   id int(10) unsigned NOT NULL auto_increment,
       
    78   PRIMARY KEY  (id)
       
    79 ) TYPE=MyISAM;
       
    80 
       
    81 INSERT INTO users_seq VALUES (1);
       
    82 
       
    83 
       
    84 Done! It should now work. If you encounter any problems feel free to email us, also monitor the website
       
    85 bugfixes might come available.
       
    86 
       
    87 Roeland, PowerAdmin Team
       
    88