11
TitaNs
Re: Database problem
  • 2003/4/29 17:09

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


help me?

12
mbogosian
do this (pt. I - creating the database)
  • 2003/4/29 18:34

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


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

13
mbogosian
do this (pt. II - creating the user)
  • 2003/4/29 18:46

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


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

14
mbogosian
do this (pt. III - assigning permissions)
  • 2003/4/29 19:04

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


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.

15
mbogosian
do this (pt. IV - setting up XOOPS)
  • 2003/4/29 19:44

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


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.

16
mbogosian
do this (pt. V - troubleshooting)
  • 2003/4/29 19:52

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


Part V: troubleshooting

If the following the steps in parts I - IV did not yield a working database for your XOOPS installation, then you'll most likely need some hand-holding. You can get this online (even here in this forum), but you will need to be very explicit and forthcoming about your setup. Take screenshots of every step that you take (or copy every command you issue) and present them with the results.

An easier way to troubleshoot is to find a knowledgable friend who is willing to help you out for a few hours. If you can convince someone to do this, try to make it convenient for them by meeting them where they want (if possible). If your site is hosted, this shouldn't be a problem, since all one needs is an Internet connection (e.g., a local library in your friend's area). If you can afford it, make absolutely sure that you at least feed that person (as a thank you for the courtesy) either at the time, or afterwards (dinner) or both.

I hope this helps.

17
mbogosian
Re: Database problem
  • 2003/5/2 17:11

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


Quote:
TitaNs wrote:
help me?

Did that fix your problem or were you still unable to complete the installation?

18
TitaNs
Re: Database problem
  • 2003/5/4 14:55

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


Thank you for helping about database creation.
Installation completed but when i connect to home page it shows blank page.

19
mbogosian
Re: Database problem
  • 2003/5/9 17:45

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


What do the logs say?

In general when requesting help, please provide as much relevent information as possible.

20
mbogosian
Re: Database problem
  • 2003/5/9 19:45

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


Also, there is about one "blank page - please help" post here per week (at least). Did you do a search to see if any previous posts could help you out?

Login

Who's Online

177 user(s) are online (120 user(s) are browsing Support Forums)


Members: 0


Guests: 177


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits