docs/README.redhat-8
author rejo
Wed, 02 Jan 2008 21:49:07 +0000
changeset 58 78558a77131e
parent 8 47dd15d8bb8c
permissions -rwxr-xr-x
[feladat @ 105] Correcting included file in users.inc.php.
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