Subject:*
<
Name/Email:*
<
Message Icon:*
<
Select*
<
Message:*
<



Click the Preview to see the content in action.
Options:*
<
Confirmation Code*
<
3 + 9 = ?  
Input the result from the expression
Maximum attempts you can try: 10
*
<
     

Re: mainfile.php settings with xampp
by stefan88 on 2008/12/1 7:58:42

Hi

Quote:
I added a password to db user "root" and got the "unable to access database" error


You added it to the mainfile too ... And it is spelled ok ...:


Quote:
// Database Hostname
// Hostname of the database server. If you are unsure, "localhost" works in most cases.
define( 'XOOPS_DB_HOST', 'localhost' );

// Database Username
// Your database user account on the host
define( 'XOOPS_DB_USER', 'root' );

// Database Password
// Password for your database user account
define( 'XOOPS_DB_PASS', '?????' );



Any luck with error logs?
Try changing localhost to 127.0.0.1 (once I had problem with corupted hosts file)

There is a bat file in MySQL folder of xampp if you need to reset the database pass.

Re: mainfile.php settings with xampp
by Anonymous on 2008/11/30 23:27:20

@ghia and @stefan88

MySQL and Apache are running fine.

I added a password to db user "root" and got the "unable to access database" error. I am confident that it's not an issue with the db connection; changing the root pasword gives a db error and the xampp control panel says apache and My SQL running. http://localhost/xampp gives the expected content.

I think it's to do with the xoops_data folder and either the path or the permissions; this is what we'd say to users whose white screen has this when looking at the source code:

le="color: #000000"><?php <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD> <BODY></BODY></HTML>


It's as if the XOOPS content of the page isn't being passed to the browser.

Keep going guys.... all help/advice welcome.

@ghia
Yes, I'll do a clean install of XOOPS 2.3.2a via xampp tomorrow evening.
Re: mainfile.php settings with xampp
by stefan88 on 2008/11/30 22:01:38

Hi,

Any debug errors from xoops?

Any errors in server logs? (c:\xampp\apache\logs\error.log) or something like that...

You may turn php error logging (also to file) in php.ini or php5.ini depending on the version.

Re: mainfile.php settings with xampp
by ghia on 2008/11/30 21:56:33

At the install of XAMPP, you must run one time the setup_xampp.bat file from cmd.
To start your site execute (double click) mysql_start.bat and then apache_start.bat. For stopping the site execute first apache_stop.bat and then mysql_stop.bat.

Could you see if a fresh install of XOOPS (in eg the site2 subdirectory of xampp/htdocs/)is possible?

Otherwise use phpMyAdmin, to create a database and a database user, assign the user to the database and give him all the rights. You can then use this database and user in the credentials of mainfile.php.
Re: mainfile.php settings with xampp
by Anonymous on 2008/11/30 20:56:42

Yep - didn't think I needed to post that one!

Who's Online

201 user(s) are online (119 user(s) are browsing Support Forums)


Members: 0


Guests: 201


more...

Donat-O-Meter

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

Latest GitHub Commits