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!

You can download the Conversion Template from Boobtoob here:

https://xoops.org/modules/mydownloads/singlefile.php?lid=204

This was built for converting data from Postnuke 7.1x to XOOPS 3.0x. But maybe it is a good starting point for you.

Yes, I know this question was asked before. The information link given, however, is dead. There are two questions that I have:

1) Through searching I have seen that a PostNuke to XOOPS script would be provided in the full release. Since XOOPS is now at v2.0.2 (stable) it must be a full release. I do not see a conversion script in the package. Am I missing something?

2) If there are no conversion scripts, the only thing that would give me a problem is use passwords. Does PN & XOOPS encrypt the passwords in the same manner? If I simply import the PN user passwords into the XOOPS password field, would they work?