8
+ − 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