Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro
Author Message
AliasXNeo
New Member
New Member


Joined: Nov 25, 2005
Posts: 20

PostPosted: Fri Nov 25, 2005 8:04 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website AIM Address MSN Messenger
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Fri Nov 25, 2005 8:26 pm Reply with quote

RTM - You need to follow the instructions in the README file.
 
View user's profile Send private message
AliasXNeo
PostPosted: Fri Nov 25, 2005 8:30 pm Reply with quote

I assume you mean the ReadMe in the installation folder? I'll check it out.
 
AliasXNeo
PostPosted: Fri Nov 25, 2005 9:15 pm Reply with quote

How do I get the DataBase Host? I tryed using "localhost" but it's not working.
 
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Fri Nov 25, 2005 10:00 pm Reply with quote

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

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
AliasXNeo
PostPosted: Fri Nov 25, 2005 10:41 pm Reply with quote

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;


Image
 
Raven
PostPosted: Fri Nov 25, 2005 11:15 pm Reply with quote

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
PostPosted: Sat Nov 26, 2005 12:28 am Reply with quote

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
PostPosted: Sat Nov 26, 2005 12:35 am Reply with quote

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!
 
AliasXNeo
PostPosted: Sat Nov 26, 2005 1:08 am Reply with quote

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
PostPosted: Sat Nov 26, 2005 2:04 am Reply with quote

In your config.php file, set $display_errors to TRUE. Then, see if any error messages are showing on your screen.
 
AliasXNeo
PostPosted: Sat Nov 26, 2005 3:14 am Reply with quote

Okay, changed it. Don't see any when I click the save button. Is it supposed to popup or appear somewhere?
 
Raven
PostPosted: Sat Nov 26, 2005 8:50 am Reply with quote

In your cPanel is an icon called Error Log. Open it up to see if there are any error messages being recorded.
 
AliasXNeo
PostPosted: Sat Nov 26, 2005 11:33 am Reply with quote

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
PostPosted: Sat Nov 26, 2005 11:38 am Reply with quote

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
PostPosted: Sat Nov 26, 2005 11:38 am Reply with quote

Are you running Apache or IIS as your web sever? Are you running *nix or windoze as your OS?
 
AliasXNeo
PostPosted: Sat Nov 26, 2005 11:53 am Reply with quote

OS: Windows XP (SP2)
Server: Apache 1.3.34 (Unix)
 
AliasXNeo
PostPosted: Sat Nov 26, 2005 9:00 pm Reply with quote

Soooo any idea?
 
Raven
PostPosted: Sat Nov 26, 2005 11:02 pm Reply with quote

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 "<b><u>Attempting to retrieve current value</u></b>";
$sql = "SELECT sitename from ".$prefix."_config";
$result = $db->sql_query($sql);
echo '<br />$result = '.$result;
echo '<br />Number of rows retrieved = '.$db->sql_numrows($result);
$record = $db->sql_fetchrow($result);
$oldSiteName = $record['sitename'];
echo '<br />Sitename before write attempt = '.$oldSiteName;

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

// Attempt to reset sitename in nuke_config table to original value
echo "<br /><br /><b><u>Attempting to restore original value</u></b>";
$sql = "UPDATE ".$prefix."_config SET sitename = '$oldSiteName'";
$result = $db->sql_query($sql);
$sql = "SELECT sitename from ".$prefix."_config";
$result = $db->sql_query($sql);
echo '<br />$result = '.$result;
echo '<br />Number of rows retrieved = '.$db->sql_numrows($result);
$record = $db->sql_fetchrow($result);
echo '<br />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! or whatever the path is to your root folder. Then paste the result in your next message.


Last edited by Raven on Sun Nov 27, 2005 12:28 am; edited 1 time in total 
AliasXNeo
PostPosted: Sun Nov 27, 2005 12:21 am Reply with quote

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
PostPosted: Sun Nov 27, 2005 12:26 am Reply with quote

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
PostPosted: Sun Nov 27, 2005 12:37 am Reply with quote

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
PostPosted: Sun Nov 27, 2005 12:45 am Reply with quote

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
PostPosted: Sun Nov 27, 2005 12:47 am Reply with quote

So, it's another database problem?
 
Raven
PostPosted: Sun Nov 27, 2005 12:56 am Reply with quote

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.
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©