XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Database Connection problem...
Register
1
bumperscoot
Database Connection problem...

Hi All...

I'm running Win XP Pro, Apache 2.0.55, PHP 4.4.2, and Msql 4.1.

When I attempt to install Xoops, everything runs fine until the database Connection check, runs, and fails.
I've triple checked the root/username are correct (I can connect with MySql administrator), and the presence/name of the XOOPS Schema. I've rebooted as well.

Any other ideas here?

Thanks soo much in advance!!!

Steve
2
peterr
Re: Database Connection problem...

  • 2006/3/24 9:40

  • peterr

  • Just can't stay away

  • Posts: 518

  • Since: 2004/8/5 9


Can you tell us the error message please, if there is one.
NO to the Microsoft Office format as an ISO standard.
Sign the petition
3
bumperscoot
Re: Database Connection problem...

Here's the error:

check database
Could not connect to the database server.


Please check the database server and its configuration.
4
bumperscoot
Re: Database Connection problem...

One more tidbit here...

I had been advised to move to PHP4.4.X and not to use MySQL 5.X, and instead use MySQL 4.1.

I just noticed in the PHP.ini file there is no MySQL extension option, only the msql and mssql extensions.

There also does not appear to be a MySQL extension dll in extensions folder.

I suspect this might have something to do with it...

Does this help??

Steve
5
peterr
Re: Database Connection problem...

  • 2006/3/25 0:03

  • peterr

  • Just can't stay away

  • Posts: 518

  • Since: 2004/8/5 9


I have seen some issues, when people are running XOOPS at home (I assume that if it is Win XP), that you need to be careful in XOOPS, not to 'exclude' 127.0.0.1

Check your hosts file, and the Apache setup for allowed hosts.

P
NO to the Microsoft Office format as an ISO standard.
Sign the petition
6
bumperscoot
Re: Database Connection problem...

Thanks Peterr..

Yes, the local host address works.
I am also able to connect via the MySQL administrator without issue..


Steve
7
msdana
Re: Database Connection problem...

  • 2006/3/25 0:35

  • msdana

  • Just can't stay away

  • Posts: 817

  • Since: 2005/12/11


Hi bumperscoot,

I use PHP 4.4.2 and MySQL support is built in, so no extension is needed.

What is the database hostname?
[size=x-small]If God is watching us, the least we can do is be entertaining.[/size]
Graphic Worx : Xoops Themes
8
peterr
Re: Database Connection problem...

  • 2006/3/25 0:43

  • peterr

  • Just can't stay away

  • Posts: 518

  • Since: 2004/8/5 9


The messages are coming from these two defines ..

Quote:

define("_INSTALL_L106","Could not connect to the database server.");
define("_INSTALL_L107","Please check the database server and its configuration.");


and in the install, these error messages are invoked by ..

Quote:

case "checkDB":
include_once "../mainfile.php";
include_once './class/dbmanager.php';
$dbm = new db_manager;
$title = _INSTALL_L104;
$content = "<table align='center'><tr><td align='left'>\n";

if (! $dbm->isConnectable()) {
$content .= _NGIMG._INSTALL_L106."<br />";
$content .= "<div style='text-align:center'><br />"._INSTALL_L107;
$content .= "</div></td></tr></table>\n";


in /install/index.php

because there are so many instances of mainfile.php being included before the install gets to this stage, we can probably assume your mainfile.php is okay.

Therefore, I'd check that the file /install/class/dbmanager.php is present, for XOOPS 2.0.13.2 , the size is 9945 bytes.

P
NO to the Microsoft Office format as an ISO standard.
Sign the petition
9
bumperscoot
Re: Database Connection problem...

Yup..
dbmanager is ok.. I've even tried unzipping a new install as well.
Keep in mind that I am able to connect to the DB using the MySQL administrator with localhost or 127.0.0.1, and the XOOPS schema is present.

I did read that PHP 4.1 supports MySQL natively. Is there nothing else in my PHP setup that might be causing this issue?

Thanks again,

Steve
10
peterr
Re: Database Connection problem...

  • 2006/3/25 6:13

  • peterr

  • Just can't stay away

  • Posts: 518

  • Since: 2004/8/5 9


I've only ever run XOOPS on a web server, and if you got that far in the install, .. it just doesn't make sense that the connect is failing.

Can you turn on 'report all errors' with php, and try again ? There must be a method to force MySQL to display the error msg for the failed connection, because all we are seeing is XOOPS failed connect messages.

edit:- I seem to remember there was some sort of MySQL admin tool for Windows, where you can turn on the logging, that _should_ show 'why' the db connection failed. Sorry, it's been a long time since I did any WAMP stuff, but it shouldn't be too hard to find.

P
NO to the Microsoft Office format as an ISO standard.
Sign the petition
(1) 2 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

223 user(s) are online (130 user(s) are browsing Support Forums)

Members: 0

Guests: 223

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