RN not connecting to db

New Member Joined: Jun 17, 2007 Posts: 8

i am having problems getting RN installed. i have edited the config file so it shows this:

Quote:

// Database & System Config
//
// dbhost: mysql.mysite.com
// dbuname: dbusername
// dbpass: dbuserpass
// dbname: dbname
// $prefix: nuke
// $user_prefix: nuke
// $dbtype: MySQL
// MySQL, mysql4, postgres, mssql, oracle, msaccess,
// db2 and mssql-odbc
// Be sure to write it exactly as above, case SeNsItIvE!
// $sitekey: kjfdhglkg9078907(*%(j5397g HtrLOH
//
// $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 )

*that is a direct copy part from my config file*

ok now in this my sql is not localhost, it is correct with mysql.mysite.com (i've installed phpnuke and nuke-evo and it installs but i don't like using them)

this is the error it gives:

Quote:

MySQL is Reporting

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

can anyone help me on what is going on? i know for 100% sure that my dbname, username and pass are legit because the other ones installed fine. any info or help would be gretaly appreciated.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

This is puzzling. I don't think RN is substantively different than other Nuke distributions as far as database connections go.
Can you verify that the configuration variables are identical to those you used with the others? You might also want to create a standalone script that looks something like:

Code:

<?php


include('config.php');


echo '<br />dbhost = '.$dbhost;


echo '<br />dbuname = '.$dbuname;


echo '<br />dbpass = '.$dbpass;


echo '<br />dbname = '.$dbname;


?>

Also, are you using a different database user than with the other distributions? Can you verify that the DB user has the correct access to the RN database?

Posted: Sun Jun 17, 2007 8:51 pm

kguske wrote:

This is puzzling. I don't think RN is substantively different than other Nuke distributions as far as database connections go.
Can you verify that the configuration variables are identical to those you used with the others? You might also want to create a standalone script that looks something like:

Code:

<?php


include('config.php');


echo '<br />dbhost = '.$dbhost;


echo '<br />dbuname = '.$dbuname;


echo '<br />dbpass = '.$dbpass;


echo '<br />dbname = '.$dbname;


?>

Also, are you using a different database user than with the other distributions? Can you verify that the DB user has the correct access to the RN database?

well on the other one's they had an automated setup system, i just installed it then went to the website and configured it from there. when i tried to configure phpnuke manually through the config.php i was getting a similar error message as with the ravennuke error.

is there an autmated install system so i don't have to mess with the config file with RN? I am by no means experienced with php, and my sql experience goes about as far as exporting/importing db's and creating a table on a rare occasion. do you think it is because the user doesn't have rights to the db?

i'd really like to use RN, but my site is down until i either rollback to phpnuke or get RN fixed, and i have to get it up as soon as possible, even if it means i go back to phpnuke

Posted: Sun Jun 17, 2007 9:09 pm

Oh - do you mean that you installed them through your control panel using something like Fantastico?

If you like, send me a private message with your control panel or FTP info, and I'll take a look.

Posted: Sun Jun 17, 2007 10:04 pm

If I may, that issue has absolutley nothing to do with RavenNuke. It is more likely due to an overload of the mysql server OR a bad simlink somewhere.

This is a host or server issue, I said or, because I want you to contact your host on this issue.

I dont mean to but in, If you need help Kguske, give me a holar, I'll be on for a bit.

Posted: Sun Jun 17, 2007 10:12 pm

OK, I was finally able to get in via FTP, and the config.php file had default info in it. Since the database was created, I have to assume that it was loaded via an SQL import. I am thinking of reinstalling, but don't have enough details to do that. selfinfliction?

Posted: Sun Jun 17, 2007 10:46 pm

It's all set up. Just needed to configure the config.php file before uploading (and the htaccess and staccess).

Posted: Sun Jun 17, 2007 10:53 pm

Does that mean it worked?

Posted: Mon Jun 18, 2007 4:26 am

Yes, the site is working normally after completing a regular installation.

Posted: Mon Jun 18, 2007 8:29 pm

gregexp wrote:

Does that mean it worked?

yep they saved me. thanks again guys