phpMyFAQ in Solaris 9

[saronno]

Hello,

I have installed successfully the application (v. 2.0.17) in a Solaris 9 box with the following SW:
Apache 2.055
PHP 4.3.6
MySQL 5.0.60

Apparently everything went fine, the DB was created, but when I try to add a new category through the admin menu nothing happens, it just goes back to the Home admin section automatically and the category is not created. What can be the reason? I have successfully created manually a category in the DB without any problem.

Juan

[Thorsten]

Hi,

do you see any errors in your error log?

bye
Thorsten

[saronno]

Hello,

I do not have root access neither on the web server nor in the mySQL server. I just got a user in the web server, and a DB created with a DB user in the mySQL server. Apparently I have all the rights granted in the mySQL server:

mysql> show grants;
+-------------------------------------------------------------------------------------------------------------------------------------+
| Grants for usuweb69@% |
+-------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'usuweb69'@'%' IDENTIFIED BY PASSWORD '*01EEA2622D1D70C44F47309511819F5F613DA405' WITH MAX_USER_CONNECTIONS 5 |
| GRANT ALL PRIVILEGES ON `usuweb69`.* TO 'usuweb69'@'%' WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

I have had a look at the apache error log, but there are no entries there (I did not setup the server, so something might be missing).

Some info has been written in the DB as of the installation:
mysql> show tables;
+----------------------+
| Tables_in_usuweb69 |
+----------------------+
| faqadminlog |
| faqcaptcha |
| faqcategories |
| faqcategory_group |
| faqcategory_user |
| faqcategoryrelations |
| faqchanges |
| faqcomments |
| faqconfig |
| faqdata |
| faqdata_group |
| faqdata_revisions |
| faqdata_tags |
| faqdata_user |
| faqglossary |
| faqgroup |
| faqgroup_right |
| faqlinkverifyrules |
| faqnews |
| faqquestions |
| faqright |
| faqsessions |
| faqtags |
| faquser |
| faquser_group |
| faquser_right |
| faquserdata |
| faquserlogin |
| faqvisits |
| faqvoting |
+----------------------+
30 rows in set (0.00 sec)

mysql> select * from faqconfig;
+-----------------------------------+---------------------------------------------------------+
| config_name | config_value |
+-----------------------------------+---------------------------------------------------------+
| main.administrationMail | webmaster@example.org |
| main.bannedIPs | |
| main.contactInformations | |
| main.currentVersion | 2.0.17 |
| main.disableAttachments | true |
| main.enableAdminLog | true |
| main.enableRewriteRules | false |
| main.enableUserTracking | true |
| main.ipCheck | false |
| main.language | language_en.php |
| main.languageDetection | true |
| main.ldapSupport | false |
| main.maxAttachmentSize | 100000 |
| main.metaDescription | phpMyFAQ should be the answer for all questions in life |
| main.metaKeywords | |
| main.metaPublisher | John Doe |
| main.numberOfRecordsPerPage | 10 |
| main.numberOfShownNewsEntries | 3 |
| main.permLevel | basic |
| main.phpMyFAQToken | |
| main.referenceURL | http://www4.xxxx.edu/cgi-bin/cgiwrap/perifrasis/faq |
| main.send2friendText | |
| main.titleFAQ | phpMyFAQ 2.0.17 |
| main.urlValidateInterval | 86400 |
| records.defaultActivation | false |
| records.defaultAllowComments | false |
| records.enableVisibilityQuestions | false |
| records.numberOfRelatedArticles | 5 |
| records.orderby | id |
| records.sortby | DESC |
| spam.checkBannedWords | true |
| spam.enableCatpchaCode | true |
| spam.enableSafeEmail | true |
+-----------------------------------+---------------------------------------------------------+
33 rows in set (0.00 sec)

Hi,

do you see any errors in your error log?

bye
Thorsten

[Thorsten]

Hi,

how do the entries look like in the tables faqright and faquser_right?

bye
Thorsten

[saronno]

Hi,

mysql> select * from faqright;
+----------+--------------+----------------------------------+-----------+------------+
| right_id | name | description | for_users | for_groups |
+----------+--------------+----------------------------------+-----------+------------+
| 1 | adduser | Right to add user accounts | 1 | 1 |
| 2 | edituser | Right to edit user accounts | 1 | 1 |
| 3 | deluser | Right to delete user accounts | 1 | 1 |
| 4 | addbt | Right to add faq entries | 1 | 1 |
| 5 | editbt | Right to edit faq entries | 1 | 1 |
| 6 | delbt | Right to delete faq entries | 1 | 1 |
| 7 | viewlog | Right to view logfiles | 1 | 1 |
| 8 | adminlog | Right to view admin log | 1 | 1 |
| 9 | delcomment | Right to delete comments | 1 | 1 |
| 10 | addnews | Right to add news | 1 | 1 |
| 11 | editnews | Right to edit news | 1 | 1 |
| 12 | delnews | Right to delete news | 1 | 1 |
| 13 | addcateg | Right to add categories | 1 | 1 |
| 14 | editcateg | Right to edit categories | 1 | 1 |
| 15 | delcateg | Right to delete categories | 1 | 1 |
| 16 | passwd | Right to change passwords | 1 | 1 |
| 17 | editconfig | Right to edit configuration | 1 | 1 |
| 18 | addatt | Right to add attachments | 1 | 1 |
| 19 | delatt | Right to delete attachments | 1 | 1 |
| 20 | backup | Right to save backups | 1 | 1 |
| 21 | restore | Right to load backups | 1 | 1 |
| 22 | delquestion | Right to delete questions | 1 | 1 |
| 23 | addglossary | Right to add glossary entries | 1 | 1 |
| 24 | editglossary | Right to edit glossary entries | 1 | 1 |
| 25 | delglossary | Right to delete glossary entries | 1 | 1 |
| 26 | changebtrevs | Edit revisions | 1 | 1 |
| 27 | addgroup | Right to add group accounts | 1 | 1 |
| 28 | editgroup | Right to edit group accounts | 1 | 1 |
| 29 | delgroup | Right to delete group accounts | 1 | 1 |
+----------+--------------+----------------------------------+-----------+------------+
29 rows in set (0.01 sec)

mysql> select * from faquser;
+---------+-----------+----------------------------------+-------------------+----------------+----------------+----------------+-------------+----------------+
| user_id | login | session_id | session_timestamp | ip | account_status | last_login | auth_source | member_since |
+---------+-----------+----------------------------------+-------------------+----------------+----------------+----------------+-------------+----------------+
| 1 | admin | 408a98dd88270e216ea3b8c62452bed4 | 1259710034 | xxx.yyy.132.225 | protected | 20091202001750 | local | 20091201233611 |
| -1 | anonymous | NULL | 1259706971 | NULL | protected | NULL | NULL | 20091201233611 |
+---------+-----------+----------------------------------+-------------------+----------------+----------------+----------------+-------------+----------------+
2 rows in set (0.01 sec)

[Thorsten]

Hi,

I also need the table faquser_right to see if all the relations are stored.

bye
Thorsten

[saronno]

Apologies, here it is.

mysql> select * from faquser_right;
+---------+----------+
| user_id | right_id |
+---------+----------+
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 1 | 5 |
| 1 | 6 |
| 1 | 7 |
| 1 | 8 |
| 1 | 9 |
| 1 | 10 |
| 1 | 11 |
| 1 | 12 |
| 1 | 13 |
| 1 | 14 |
| 1 | 15 |
| 1 | 16 |
| 1 | 17 |
| 1 | 18 |
| 1 | 19 |
| 1 | 20 |
| 1 | 21 |
| 1 | 22 |
| 1 | 23 |
| 1 | 24 |
| 1 | 25 |
| 1 | 26 |
| 1 | 27 |
| 1 | 28 |
| 1 | 29 |
+---------+----------+
29 rows in set (0.00 sec)

[saronno]

By the way, it is also impossible for me to add a new user as admin. I get the following error:

User Administration

Please enter a password.

Please enter a valid mail address.

The specified user name is invalid.

Please enter your real name.

Obviously I had entered all the information correctly.

[Thorsten]

Hi,

well, I cannot reproduce all of these errors, sorry. The tables are looking okay... I don't know what's happening... Maybe try to upgrade your 5 year old PHP...

bye
Thorsten