|
1
|
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 |
|