1
bicetre
Need help for setting up my host
  • 2004/4/1 15:05

  • bicetre

  • Just popping in

  • Posts: 5

  • Since: 2003/9/18


Hi,
I'm noob and I need to manage a site where I want to put Xoops.
The site is hosted on a institutional server, I have FTP access and phpMyAdmin with root privileges.

The server is a SUN Ultra250, it runs php 4.2.0 and MySQL 2.23.39

My problem is that I can't install Xoops, Version 2 just doesn't launches the install.php, and Version 1.3.10 can't create (actually seems to be unable to connect to the database server) the database.

I have an uncommon extended control over the server, and I'm not sure that the default settings are correct.

Can you help?

2
Herko
Re: Need help for setting up my host
  • 2004/4/1 15:53

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


The XOOPS2 files (which can be found in the HTML/ folder of the XOOPS package) need to be put in the website's root folder, and then all you have to do is point your browser to the site's root. Index.php automatically redirects to the installer, if applicable.
Be sure to check the file permissions (mainfile.php, cache/ uploads/ and templates_c/ folders).

Herko

3
bicetre
Re: Need help for setting up my host
  • 2004/4/2 8:12

  • bicetre

  • Just popping in

  • Posts: 5

  • Since: 2003/9/18


Thank you for your answer, the basic setup is done.*
I have already used XOOPS on personal ISP webhosting with no problem.
My current problem is with that particuliar hosting.
The install scripts can't create the database, nor access the database server (it seems).
I'm currently running the 1.3.10 version.
The final messages are
Quote:
The following database was not found on the server:

main1

Attempt to create it?

when I answer 'yes', I have
Quote:
Could not create database. Contact the server administrator for details.

The checkenv.php gives
Quote:
PHP: 4.2.0

$REQUEST_METHOD:
$REQUEST_URI:
$SCRIPT_NAME:
$HTTP_REFERER:
$HTTP_HOST:
$HOSTNAME:
$REMOTE_ADDR:


$HTTP_SERVER_VARS['REQUEST_METHOD']: GET
$HTTP_SERVER_VARS['REQUEST_URI']:
$HTTP_SERVER_VARS['SCRIPT_NAME']: /portail/checkenv.php
$HTTP_SERVER_VARS['HTTP_REFERER']:
$HTTP_SERVER_VARS['HTTP_HOST']:
$HTTP_SERVER_VARS['HOSTNAME']:
$HTTP_SERVER_VARS['REMOTE_ADDR']: 164.2.249.226


$HTTP_ENV_VARS['REQUEST_METHOD']:
$HTTP_ENV_VARS['REQUEST_URI']:
$HTTP_ENV_VARS['SCRIPT_NAME']:
$HTTP_ENV_VARS['HTTP_REFERER']:
$HTTP_ENV_VARS['HTTP_HOST']:
$HTTP_ENV_VARS['HOSTNAME']: argiope
$HTTP_ENV_VARS['REMOTE_ADDR']:


getenv("REQUEST_METHOD"):
getenv("REQUEST_URI"):
getenv("SCRIPT_NAME"):
getenv("HTTP_REFERER"):
getenv("HTTP_HOST"):
getenv("HOSTNAME"): argiope
getenv("REMOTE_ADDR"):

So?

PS : I'm a noob with the server management, not with XOOPS

4
Mithrandir
Re: Need help for setting up my host

Are you sure you have permissions to create the database?

5
bicetre
re:
  • 2004/4/2 9:42

  • bicetre

  • Just popping in

  • Posts: 5

  • Since: 2003/9/18


I gave to the database user the privileges : Select Insert Update Delete Create Drop Reload Process File References Index Alter

6
Mithrandir
re:

to which database?

Check up on the MySQL documentation, but I think that creating a database is beyond the privileges you list.

Alternatively create the database manually with root and then use the mentioned user for installation/use of XOOPS

7
bicetre
re:
  • 2004/4/2 10:04

  • bicetre

  • Just popping in

  • Posts: 5

  • Since: 2003/9/18


To the database I intend to use with xoops, I called it 'main1'

I already manually created the database with phpMyAdmin (so with root), but the message from XOOPS install is those I mentionned above. That's why I think I have a problem of comm between XOOPS and MySQL.

Does XOOPS use a sock connection to MySQL?

8
bicetre
re:
  • 2004/4/2 10:11

  • bicetre

  • Just popping in

  • Posts: 5

  • Since: 2003/9/18


YESSSSSSS!
I did it!

The problem was the connection to MySQL!
I had to put 'localhost:13377:/tmp/mysql77.sock' instead of 'localhost'!

Thanks all for your help anyway

Login

Who's Online

140 user(s) are online (87 user(s) are browsing Support Forums)


Members: 0


Guests: 140


more...

Donat-O-Meter

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

Latest GitHub Commits