What does this mean, and what do I have to do?

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Okay, I'm kinda a newbie with web based stuff. I know how to setup a website, but not Databases, nor PHPNuke. I uploaded everything in HTML onto my website and went to the Installation file and ran the install document. Here is the error I get:

Database connection failed due to Access denied for user: 'root@localhost' (Using password: NO)

Edit the database settings in /home/neo/public_html/INSTALLATION/installSQL.php or contact your database provider

What does that mean? And what I am supposed to do. If someone could guide me that would be great Smile

Raven · Posted: Fri Nov 25, 2005 8:26 pm

- You need to follow the instructions in the README file.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

I assume you mean the ReadMe in the installation folder? I'll check it out.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

How do I get the DataBase Host? I tryed using "localhost" but it's not working.

evaders99 · Posted: Fri Nov 25, 2005 10:00 pm

localhost is correct if the database is on the same server as the web server

Do not use the root user, create a database user in your MySQL configuration and use that login for phpNuke

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Alright, still getting an error then:

Database connection failed due to Access denied for user: 'neo_NukeD@localhost' to database 'neo_NukeDB'

My settings:

$dbhost = "localhost";
$dbuname = "neo_NukeD";
$dbpass = "*******"; <--- I blocked it out, but it's correct
$dbname = "neo_NukeDB";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+e9"; <-- I changed it slightly
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";
$tipath = "images/topics/";
$display_errors = false;

Raven · Posted: Fri Nov 25, 2005 11:15 pm

Step 1 in the README states
1) Using whatever your host requires you to use to create a MySQL database, create a database for your site.

You need to get familiar with your cPanel that your host uses. In your home page for your cPanel, usually towards the bottom of the left hand column, should be a line similar to Documentation Click to View. Click the link and you should be taken to a cPanel documentation site. In the table of contents look for MySQL. Click it and follow those instructions. Pay particular instructions to Add User to Db to give the user permission to access the database.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Alright, sorry for any inconvience, but im a first timer with alot of this stuff, and im not used to being a newb at things Wink

Anyways, thanks Raven, if you wouldn't mind could you point me out to some articles/guides about PHPNuke on here, so I can see how to properly use it. Specifically how to change skins, and top banner, as well as why the "Who Is Online" block is not working. Thanks Smile

Raven · Posted: Sat Nov 26, 2005 12:35 am

No inconvenience! There's an old adage that I just love that says
Give a man to fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.

I have been trying to lead you but not do it for you. Try this for starters. Although it is not entirely up to date with the latest releases, it is very valuable. The forums, here also, are very good for most any problem you would have Smile

Only registered users can see links on this board!
Get registered or login to the forums!

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Well while I'm here. Few things I didn't see in the guide:

-Why is it not saving any of my preferences when I edit them and then click save button at the bottom? It reverts everything back to default, can't even change skins.
-Why can't I deactivate some of the blocks? I hit "Deactivate" and it refreshes the page but it's still activated.
-How do I get a link to the forums appear at the top toolbar.

If anyone could help me with those, that would be nice.

Raven · Posted: Sat Nov 26, 2005 2:04 am

In your config.php file, set $display_errors to TRUE. Then, see if any error messages are showing on your screen.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Okay, changed it. Don't see any when I click the save button. Is it supposed to popup or appear somewhere?

Raven · Posted: Sat Nov 26, 2005 8:50 am

In your cPanel is an icon called Error Log. Open it up to see if there are any error messages being recorded.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Here is what it has logged:

[Sat Nov 26 17:38:34 2005] [error] [client 24.4.122.25] File does not exist: /home/neo/public_html/404.shtml
[Sat Nov 26 17:38:34 2005] [error] [client 24.4.122.25] File does not exist: /home/neo/public_html/favicon.ico
[Sat Nov 26 17:38:34 2005] [error] [client 24.4.122.25] File does not exist: /home/neo/public_html/404.shtml
[Sat Nov 26 17:38:34 2005] [error] [client 24.4.122.25] File does not exist: /home/neo/public_html/cp

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

This is what shows up when I click the save button on the preferences page:

[Sat Nov 26 17:38:34 2005] [error] [client 24.4.122.25] File does not exist: /home/neo/public_html/favicon.ico
[Sat Nov 26 17:38:34 2005] [error] [client 24.4.122.25] File does not exist: /home/neo/public_html/404.shtml

I assume I am missing an error page?

Raven · Posted: Sat Nov 26, 2005 11:38 am

Are you running Apache or IIS as your web sever? Are you running *nix or windoze as your OS?

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

OS: Windows XP (SP2)
Server: Apache 1.3.34 (Unix)

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Soooo any idea?

Raven · Posted: Sat Nov 26, 2005 11:02 pm

Save this code as test.php and ftp it to your root nuke folder (the same place that your config.php file is).

Code:

<?
//
// Quick php script to test if database table is writeable by this user
// Author: Raven 11/26/2005
//
include("mainfile.php");
// Attempt to retrieve current sitename from nuke_config table
echo "Attempting to retrieve current value";
$sql = "SELECT sitename from ".$prefix."_config";
$result = $db->sql_query($sql);
echo ' $result = '.$result;
echo ' Number of rows retrieved = '.$db->sql_numrows($result);
$record = $db->sql_fetchrow($result);
$oldSiteName = $record['sitename'];
echo ' Sitename before write attempt = '.$oldSiteName;

// Attempt to update current sitename in nuke_config table
echo " Attempting to update current value";
$sql = "UPDATE ".$prefix."_config SET sitename = 'TEST SITE'";
$result = $db->sql_query($sql);
if (mysql_error()) {
echo ' ERROR: MySQL said '.mysql_error().'';
die();
}
$sql = "SELECT sitename from ".$prefix."_config";
$result = $db->sql_query($sql);
echo ' $result = '.$result;
echo ' Number of rows retrieved = '.$db->sql_numrows($result);
$record = $db->sql_fetchrow($result);
$newSiteName = $record['sitename'];
echo ' Sitename after write attempt = '.$newSiteName;

// Attempt to reset sitename in nuke_config table to original value
echo " Attempting to restore original value";
$sql = "UPDATE ".$prefix."_config SET sitename = '$oldSiteName'";
$result = $db->sql_query($sql);
$sql = "SELECT sitename from ".$prefix."_config";
$result = $db->sql_query($sql);
echo ' $result = '.$result;
echo ' Number of rows retrieved = '.$db->sql_numrows($result);
$record = $db->sql_fetchrow($result);
echo ' Sitename after restoring attempt = '.$record['sitename'];
?>

Then run it through your browser as

Only registered users can see links on this board!
Get registered or login to the forums!

or whatever the path is to your root folder. Then paste the result in your next message.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Quote:

Attempting to retrieve current value
$result = Resource id #36
Number of rows retrieved = 1
Sitename before write attempt = PHP-Nuke Powered Site

Attempting to update current value

ERROR: MySQL said UPDATE command denied to user: 'neo_NukeD@localhost' for table 'nuke_config'

By the way, with the errors in the CPanel, I created a 404 page and an icon and the errors stopped but it's still not saving, and I guess that explains why.

Raven · Posted: Sun Nov 27, 2005 12:26 am

That's what I suspected and why I wrote you that little diddy Wink

. neo_NukeD does not have sufficient privledges for your database. You have a MySQL setup issue. Verify that that user has been added to the database.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

Alright, fixed it Smile

I just deleted the user and remade it with all privelages, must have been missing some. Thanks for all the help.

One last thing if you don't mind. With the "There is a problem right now with this block.", that's originally like that right, and not a problem with me?

Thanks again for all your help and patience Smile

Raven · Posted: Sun Nov 27, 2005 12:45 am

You should not see that block message. If you do, then that's just what it means. It's often times caused by a block not receiving the data from the data base that it's expecting.

AliasXNeo · New Member Joined: Nov 25, 2005 Posts: 20

So, it's another database problem?

Raven · Posted: Sun Nov 27, 2005 12:56 am

Possibly. If that user didn't have the correct rights, then your database install may be incomplete. I would use phpMyAdmin and drop the database and start over and reinstall everything.