1
hughs
Database on Localhost
  • 2004/1/11 14:51

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


Hello,
I've been trying to install XOOPS as localhost.
Unfortunatlly my knowledge of mysql, php and and and is next to nothing and I've got as fas as that:

"Could not connect to the database Server."
"Please check the database Server and its configurations."

I would like to know "where and how" could i solve this.
By the way i have also installed UniServer 3.0

Thanks a lot
Hughs

2
ghbook
Re: Database on Localhost
  • 2004/1/11 15:35

  • ghbook

  • Just popping in

  • Posts: 21

  • Since: 2003/11/14


Hi,
Well i don't know UniServer, but i suppose that it's some kind of a package including Apache, Php, MySql and, somewhere, PhpMyAdmin.
For MySql all you have to know is the server's name (localhost for you), and the user name and password, in general by default "root" and nothing (nothing at all).

So go to PhpMyAdmin and check how it works. If it's working, you can find, in the directory where PhpMyAdmin is located the config.inc.php file.

You'll find in this configuration file something like that :


$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'YourPassword'; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed

You have everything you need.

3
ghbook
Re: Database on Localhost
  • 2004/1/11 15:37

  • ghbook

  • Just popping in

  • Posts: 21

  • Since: 2003/11/14


I'have forgotten something : you must check that Apache and MySql are running. You have probably a little program that monitors the servers. Check it before configuring MySql.
Gilles

4
hughs
Re: Database on Localhost
  • 2004/1/11 16:11

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


Thank you for your explanation..
I'll do my best to understand it and put it into practice !!
Hughs

5
rabideau
Re: Database on Localhost
  • 2004/1/11 17:04

  • rabideau

  • Home away from home

  • Posts: 1042

  • Since: 2003/4/25


Trying going to http://www.apachefriends.org and downloading XAMPP. If you are able to follow their simple (but large) install you should solve your problems.

Once you get ready to use XAMPP, be sure to shut off IIS before trying to run Apache on your machine, though.

...mark

6
hughs
Re: Database on Localhost
  • 2004/1/11 17:19

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


Hello Mark..
Thank you for your answer.
I've installed Uniform Server 3.0, i have very little knowledge about it, what i know is that is a very thin
programm, just the very basics.
I must admit that i'm a bit confused 'cos i know that there are quite a few programm running as localhost, but i do not know which one will be for me better..
hughs

7
elvir
Re: Database on Localhost
  • 2004/1/11 17:54

  • elvir

  • Just popping in

  • Posts: 90

  • Since: 2004/1/4 1


Hi hughs,

may be this can help:

I'm testing XOOPS on localhost for last 4 months (themes and modules) and I can tell you I had no any problem with the mysql. It's simple - you just have to install MySQL and odbc connector. You can find these on

http://www.mysql.com
http://www.mysql.com/products/myodbc/

Offcourse, you have to set up the link in data source. In this case for testing xoops, during the installation skip databse username and database pasword. XOOPS is working perfectly without it.

Also, by downloding the NUSPHERE you cn easily solve most of the problems (sql - apache installation). Go here:

http://www.nusphere.com/cgi-bin/nsp.cgi/custsrvc/utils/download_now.htm?psn=4393377914383287

Hope this can help!

8
Herko
Re: Database on Localhost
  • 2004/1/11 18:16

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


I use Uniserver 3.0, and it works fine for me! What you need to do is go to localhost/a/ and start the MySQL server, and then return to localhost/ . That's all. Make sure you fill in the correct informatio during install: database username: root, password is empty (no value), database name can be anything. The XOOPS installer will create it for you.

Herko

9
hughs
Re: Database on Localhost
  • 2004/1/12 8:58

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


Good Morning..
By installing XOOPS on Localhost i got this..

Fatal error: Unable to connect to database in W:\www\html\class\database\databasefactory.php on line 34

As i said before i have very little knowledge about Mysql.
sorry to ask these silly questions.
Hughs

10
hughs
Re: Database on Localhost
  • 2004/1/12 12:19

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


I just want to say that i've got XOOPS on localhost "alive and kicking", thanks to you all..
once again, many thanks for your help..
Hughs

Login

Who's Online

1070 user(s) are online (287 user(s) are browsing Support Forums)


Members: 0


Guests: 1070


more...

Donat-O-Meter

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

Latest GitHub Commits