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