Part IV: setting up XOOPS

This process is mainly described by the XOOPS documentation and is further simplified by the XOOPS installation wizard, so I won't go into too much detail here. Please consult those places for additional information.

1. Start with a fresh install. Download XOOPS and unpack it. Move the xoops2/html directory to somewhere in your web server's tree. For example if your web server has its root directory in /var/www/html then you can either replace the entire contents of /var/www/html with the contents of xoops2/html or you can move xoop2/html to be a subdirectory of /var/www/html. If you do the latter:

mv xoops2/html /var/www/html/xoops

Then your XOOPS installation will be available via:

http://yourhost.yourdomain.dom/xoops/

If you did the former:

mkdir /var/www/html/bak
mv /var/www/html/* /var/www/html/bak
mv xoops2/html/* /var/www/html

Then your XOOPS installation would be available via:

http://yourhost.yourdomain.dom/

Either way (it doesn't matter to me), just point your browser there. If you get a blank screen, then make sure you're starting with a fresh install. If it still doesn't work, check your web server error logs and do a search on this site to see if someone else has figured out what your problem is already. After doing a search and trying to fix the problem on your own, if you're still stuck, make a new post to the appropriate forum and someone will most likely be able to help you. When you do this, please include all relevent information (which web server, specific error messages, log output, anything you can think of that might shed light on your problem).

2. Assuming you were presented with the installation wizard, follow the instructions until you get to the page entitled:

General configuration

Fill in all of the information here according to what you created in parts I & II:

Database select MySQL
Database Hostname whatever your MySQL hostname is
Database Username xoops
Database Password whatever password you entered in part II, step 3
Database Name xoops

If you do not know what your DB hostname is then ask your system administrator, or look at the main screen when you first log into phpMyAdmin. You'll see a line that says something like:

MySQL X.XX.XX running on HOSTNAME as USER@HOSTNAME

You will most likely be able to copy and paste HOSTNAME from this line directly into the Database Hostname field of the XOOPS installation. If this doesn't work, ask your system administrator.

3. Finish the installation. If all went well, you should be up and running. If you still have a problem connecting to your database, double-check your work in parts I - III. If this fails, contact your system administrator.

Thanks for looking into this. I took a look at the fix and it only partially corrects the problem. The post_comment.php now looks only to the GET query for the information, but not to POST query. When you post a new comment, the $commentnav "post comment" button is a POST query to the comments form and therefore the values aren't passed properly.


Would something like that do the trick? Probably better to seperate into a seperate utility sub.


I know there's a more appropriate place for something like this, but I'm not familiar enough with XOOPS core yet to even guess. Also please pardon my hack|buggy PHP coding, I don't have time to properly test the code now or look up the XOOPS coding standards.

Thanks for all the great work.

Part III: assigning permissions

1. Log phpMyAdmin. You should be presented with a list of operations under the heading MySQL. If you're not, follow the Home link (in the upper left corner). You should see something like this:

MySQL
Create new database [Documentation]
+--------------+
|______________| Create

Show MySQL runtime information [Documentation]
Show MySQL system variables [Documentation]
Show processes [Documentation]
Reload MySQL [Documentation]
Users [Documentation]
Databases statistics
Change password
Log out (*)

If you do not see this, then ask your system administrator how to get to this page. Better yet, ask your system administrator to create the DB for you.

2. Provided you're looking at this page, follow the Users link. You should be presented with a list of existing users (including the one you created during part II).

3. To the left of the xoops user, there should be three links. Click on Grants. If you followed the steps in part II exactly, you should be taken to a screen called Host % - User xoops which contains a form to set privileges. If you received and error or if you do not see this screen, contact your system administrator to help you.

4. In the form, select "Database (*) :" and select the xoops database that you created from part I from the drop-down. Select "Any table" and "Any Column". In the "Privileges :" section, make sure only the following are checked:

Select Insert
Update Delete
Create Drop
Index Alter

When this is done, click the "Go" button. You should see a screen that says:

You have added a new privilege..
Remember reload the server.

Note: if you did not reload MySQL in part II, then this step will not work.

5. Go back to the main screen (follow the Home link in the upper left corner), and click on the Reload MySQL link. You should see a message that says:

MySQL reloaded.

If you got this far, congratulations, you've now assigned the permissions to the user. Now you can set up XOOPS (see part IV: setting up XOOPS).

By the way, everything I have outlined here so far is in the MySQL documentation available online.

Part II: creating the user

1. Log phpMyAdmin. You should be presented with a list of operations under the heading MySQL. If you're not, follow the Home link (in the upper left corner). You should see something like this:

MySQL
Create new database [Documentation]
+--------------+
|______________| Create

Show MySQL runtime information [Documentation]
Show MySQL system variables [Documentation]
Show processes [Documentation]
Reload MySQL [Documentation]
Users [Documentation]
Databases statistics
Change password
Log out (*)

If you do not see this, then ask your system administrator how to get to this page. Better yet, ask your system administrator to create the DB for you.

2. Provided you're looking at this page, follow the Users link. You should be presented with a list of existing users as well as a form at the bottom to create a new user.

3. In the new user form, make sure "Any host" is selected (you can change this later, but for now we want to make sure you can connect). Make sure "User name :" is selected and enter in "xoops" as the user name. Make sure "Password :" is selected and enter in and confirm your password (it can be anything, just make sure it's reasonably hard to guess and make sure you remember it for later). In the "Privileges :" section, make sure all the privileges are unchecked (click on Uncheck All). And finally, click the Go button.

If there was an error, contact your system administrator. You should see a screen that says:

You have added a new user.
Remember reload the server.

4. Go back to the main screen (follow the Home link in the upper left corner), and click on the Reload MySQL link. You should see a message that says:

MySQL reloaded.

If you got this far, congratulations, you've now created a user. However, you still need to assign the appropriate permissions (see part III: assigning permissions).

Part I: creating the database

1. Log phpMyAdmin. You should be presented with a list of operations under the heading MySQL. If you're not, follow the Home link (in the upper left corner). You should see something like this:

MySQL
Create new database [Documentation]
+--------------+
|______________| Create

Show MySQL runtime information [Documentation]
Show MySQL system variables [Documentation]
Show processes [Documentation]
Reload MySQL [Documentation]
Users [Documentation]
Databases statistics
Change password
Log out (*)

If you do not see this, then ask your system administrator how to get to this page. Better yet, ask your system administrator to create the DB for you.

2. Provided you're looking at this page, you'll want to create a new database. Enter "xoops" into the text field next and click the Create button.

3. The database should now be created and you should be presented with a screen that looks something like:

Database XOOPS running on ********
Database XOOPS has been created.

_| Structure |__| SQL |__| Export |__| Search |__| Drop |_

No tables found in database.
...

If you received and error instead, or if you do not see this screen, contact your system administrator to help you.

Provided everything went well, congratulations, you've now created a database. However, you will not be able to access it until you create a user and permissions (see Part II: creating the user).

Thought site was running ok,after many updates testing and all that

Though have one user, who can view site ok
However whenever he trieds to do something like guestbook entry or post a vote in weblinks he gets a error messahe
0013 which i believe is

Error Code: 0013 ERROR: Could not query the database

any ideas on why ? and if possible advice

site on linux 4.1.x php
xoops r2.02

user msie 6 aol

many thanks
mike

help me?

ttt

This has been fixed on CVS. You can download the fixed file here.

This function Quote:

...would seems to indicate that inserting postnuke.pn_pass into xoops.pass will work without any problems. That's what I needed to know. Thanks!