Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Installation Help
Author Message
johnson121
New Member
New Member


Joined: Mar 19, 2007
Posts: 6

PostPosted: Tue Mar 20, 2007 4:28 pm Reply with quote

I'm new to nuke so i'm sorry if my question are "dumb."

After uploading a php-nuke to my website, currently using gate (dot) com, i ran into a couple problems. When trying to install it says the following....

Quote:
I was unable to reach your MySQL server using the MySQL connection settings in your nuke config.php file. The exact error message that your MySQL server reported is Can't connect to MySQL server on 'localhost' (10061).



I also have another question.... what part of the config.php do i edit. there are 2 parts that contain database information which baffles me.
Code:
 Database & System Config

//
// dbhost:       SQL Database Hostname
// dbuname:      SQL Username
// dbpass:       SQL Password
// dbname:       SQL Database Name
// $prefix:      Your Database table's prefix
// $user_prefix: Your Users' Database table's prefix (To share it)
// $dbtype:      Your Database Server type. Supported servers are:
//               MySQL, mysql4, postgres, mssql, oracle, msaccess,
//               db2 and mssql-odbc
//               Be sure to write it exactly as above, case SeNsItIvE!
// $sitekey:    Security Key. CHANGE it to whatever you want, as long
//               as you want. Just don't use quotes.
// $gfx_chk:    Set the graphic security code on every login screen,
//      You need to have GD extension installed:
//      0: No check
//      1: Administrators login only
//      2: Users login only
//      3: New users registration only
//      4: Both, users login and new users registration only
//      5: Administrators and users login only
//      6: Administrators and new users registration only
//      7: Everywhere on all login options (Admins and Users)
//      NOTE: If you aren't sure set this value to 0
// $subscription_url: If you manage subscriptions on your site, you
//                    must write here the url of the subscription
//                    information/renewal page. This will send by
//                    email if set.
// $admin_file: Administration panel filename. "admin" by default for
//         "admin.php". To improve security please rename the file
//              "admin.php" and change the $admin_file value to the
//              new filename (without the extension .php)
// $tipath:          Path to where the topic images are stored.
// $display_errors:  Debug control to see PHP generated errors.
//                   false: Don't show errors
//                   true: See all errors ( No notices )
//
//#####################################################################
//Inspired by phoenix-cms at website-portals.net
//Enhanced by Raven at ravenphpscripts.com
if (!defined('NUKE_BASE_FOLDER')) {
    $path_parts = pathinfo($_SERVER['PHP_SELF']);
    define('NUKE_BASE_FOLDER', str_replace('\\/', '/', $path_parts['dirname'].'/')); //montego - modified slightly to work on some windows platforms
}
//Absolute Nuke directory
if (!defined('NUKE_BASE_DIR')) define('NUKE_BASE_DIR', dirname(__FILE__) . '/');
//Absolute Nuke directory + includes
if (!defined('NUKE_BLOCKS_DIR')) define('NUKE_BLOCKS_DIR', NUKE_BASE_DIR . 'blocks/');
if (!defined('NUKE_IMAGES_DIR')) define('NUKE_IMAGES_DIR', NUKE_BASE_DIR . 'images/');
if (!defined('NUKE_INCLUDE_DIR')) define('NUKE_INCLUDE_DIR', NUKE_BASE_DIR . 'includes/');
if (!defined('NUKE_LANGUAGE_DIR')) define('NUKE_LANGUAGE_DIR', NUKE_BASE_DIR . 'language/');
if (!defined('NUKE_MODULES_DIR')) define('NUKE_MODULES_DIR', NUKE_BASE_DIR . 'modules/');
if (!defined('NUKE_THEMES_DIR')) define('NUKE_THEMES_DIR', NUKE_BASE_DIR . 'themes/');
if (!defined('NUKE_ADMIN_DIR')) define('NUKE_ADMIN_DIR', NUKE_BASE_DIR . 'admin/');
if (!defined('NUKE_ADMIN_MODULE_DIR')) define('NUKE_ADMIN_MODULE_DIR', NUKE_ADMIN_DIR . 'modules/');
if (!defined('NUKE_FORUMS_DIR')) define('NUKE_FORUMS_DIR', (defined('IN_ADMIN') ? './../' : 'modules/Forums/'));

$dbhost = 'localhost';
$dbuname = 'rnv210';
$dbpass = 'rnv210';
$dbname = 'rnv21000';
$prefix = 'nuke';
$user_prefix = 'nuke';
$dbtype = 'MySQL';
$sitekey = 'SdFk*fa2rnv21076v28367-dm56w69.3a2fDS+e9';
$gfx_chk = 7;
$subscription_url = '';
$admin_file = 'admin';
$tipath = 'images/topics/';
$display_errors = FALSE;  //This should only be used (set to TRUE) when testing locally and not in a production environment

/*********************************************************************/
/* The configuration options for RavenNuke(tm) have been moved to a  */
/* separate file here:                                               */
/*********************************************************************/
require_once(NUKE_BASE_DIR.'rnconfig.php');


You help will be greatly appreciated.


btw im using RavenNuke_v2.10.00.
 
View user's profile Send private message
jakec
Site Admin


Joined: Feb 06, 2006
Posts: 3048
Location: United Kingdom

PostPosted: Tue Mar 20, 2007 4:54 pm Reply with quote

The most important part is probably this:

Code:
$dbhost = 'localhost'; 

$dbuname = 'rnv210';
$dbpass = 'rnv210';
$dbname = 'rnv21000';


Otherwise you won't be able to connect to your database.

The first of what you listed is commented out (//) and just shows you what each of the settings are for.
 
View user's profile Send private message
johnson121
PostPosted: Tue Mar 20, 2007 5:45 pm Reply with quote

Thanks for the help.... I entered in all the information correctly but when i got to install it says "The exact error message that your MySQL server reported is Can't connect to MySQL server on 'my sql server name' (10061)."
 
jjh221
Worker
Worker


Joined: Dec 05, 2006
Posts: 178

PostPosted: Tue Mar 20, 2007 8:20 pm Reply with quote

login to your host, set up a user for you mysql database and a password.

Creat a database(db), name it whatever you like. Assign your user to that database.

Fill in:
Code:


$dbhost = 'localhost';   --- leave the same
$dbuname = 'rnv210';  ---This is the username that you just created
$dbpass = 'rnv210';     --- This is the password of the user assinged to the db
$dbname = 'rnv21000'; --- This is the name of the db you created.


if im wrong someone correct me.
 
View user's profile Send private message
johnson121
PostPosted: Tue Mar 20, 2007 11:49 pm Reply with quote

I already have a data base set up..... Do i need a Data Source Name?
this is what i see when i look at databases in gate dot com.

Code:


tools> Database
# Type: SQL Server 2005
# Server: sql002.whp.server-hosting.com
# Database Name:my db name
# Username: my user name
# Password: my password
 
jjh221
PostPosted: Wed Mar 21, 2007 12:34 am Reply with quote

$dbhost = 'localhost'; --- leave the same
$dbuname = 'my user name'; ---This is the username that you just created
$dbpass = 'my db pass'; --- This is the password of the user assinged to the db
$dbname = 'my db name'; --- This is the name of the db you created.

what do you mean "Data Source Name"?
 
jakec
PostPosted: Wed Mar 21, 2007 1:23 am Reply with quote

If the dbhost is set to localhost and that doesn't work then It looks like you will need to change the dbhost to the server they have supplied.

Is your database using mySQL? Just noticed the Type says SQL Server 2005.
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Wed Mar 21, 2007 1:56 am Reply with quote

Sounds like you are using a Windows server. Nuke is not certified to run on Windows though many people have successfully done so (with some hiccups along the way).
What does your hosting provider say about setting up and connecting to databases?
 
View user's profile Send private message Send e-mail
johnson121
PostPosted: Fri Mar 23, 2007 4:56 pm Reply with quote

repeated....


Last edited by johnson121 on Fri Mar 23, 2007 5:04 pm; edited 1 time in total 
johnson121
PostPosted: Fri Mar 23, 2007 5:02 pm Reply with quote

Yeah.... apparently I have been working on a windows server.... I can get another web hosting plan with 1&1 with Linux... So it seems I will have to go this route.

After looking at the plans, do you guys think that these plans would be sufficient for using php-nuke. I was thinking about going with the business plan. Only registered users can see links on this board! Get registered or login!
 
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Fri Mar 23, 2007 8:20 pm Reply with quote

phpNuke definitely runs fine on Linux Smile PHP and such is already configured to work nicely.

I don't know if Raven wants us talking about hosting (since he runs his own hosting)
Just be careful because you'll be on a shared server .. you may not get the best performance. I hear 1and1's shared servers are overloaded. (I use 1&1 myself, but I have a nice root server with no performance issues. So it may not be the company, but the plan)

_________________
- 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
jakec
PostPosted: Sat Mar 24, 2007 5:07 am Reply with quote

Personally I wouldn't go with 1and1 because I was with them then changed because my sites became very slow, unless you go with what evaders has. I'm personally not with Raven, but you can't go wrong with Raven's hosting, although we are probably biased. Wink
 
johnson121
PostPosted: Sat Mar 24, 2007 12:59 pm Reply with quote

I would love to go with raven Very Happy. But, my boss only has accounts with only Gate and 1&1. So I'm pretty much limited when it come to web hosting companies.

EDIT:Evader are you using the developer plan?
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Installation Help

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 ©