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