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