New install

New Member Joined: Sep 17, 2008 Posts: 6

Hi, I am new to this so bear with me please. I made a database and uploaded the html files to my webspace following the included instructions. When i visit www.yoursite.com (replaced with my actual domain) i get these messages

There seems to be a problem connecting to the MySQL server.
MySQL is Reporting
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

If you are the System Administrator and installing this for the first time, did you remember to create your database first?

There seems to be a problem with the System Configuration Table - it's missing.

If you are the System Administrator and installing this for the first time, did you remember to run the INSTALLATION/installSQL.php file?

Is this what I should see? I see that the bottom part is what I am supposed to see before running installSQL.php, but the top part about cant connect isnt in the instructions. I have tried 2 ways of putting in the info into the config.php. The first way I had it just my username, password, and dbname with out my host username. Then i tried with my host username(i am assuming that by host user, it is meant my actual login username to get to my cpanel) but got the same results. If this is what I am supposed to see then great just let me know. If not and you can help then i would be greatful. Thanks in advance.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

You need to verify your settings in your config.php. The settings have nothing to do with your cPanel. When you created your database you have to create a database user/password and then you have to add that username to the database you created. Then, use those settings in your config.php file. Then you can trun your installSQL.php script.

Posted: Sat Sep 20, 2008 9:24 pm

$dbhost = 'localhost';
$dbuname = 'myuser';
$dbpass = 'mypass';
$dbname = 'mydb';
$prefix = 'nuke';
$user_prefix = 'nuke';
$dbtype = 'MySQL';
$sitekey = 'SdFk*fa2rnv21076v28367-dm52?6w69.3a2fDS+e9killer';
$gfx_chk = 3;
$subscription_url = '';
$admin_file = 'admin';
$tipath = 'images/topics/';

this is what i have in my config.php with dbuname,pass, and name changed. this is what i mean by my cpanel login username.

For this example, we will assume that your site name is ravensite.com and your host username is raven. That means that your database name and database username will automatically be prefaced by raven_. This is an important point to remember. Let us get started.

what is my host username? is it the username i use to login to my cpanel?
i have tried it with no username before ie raven_mydb and without ie just mydb. both times getting the same message when i visit mydomain.com
I know i am doing something wrong i just dont know where. I would be glad to pm you an actual copy of my config and db settings if you would like to see.

Posted: Sat Sep 20, 2008 9:49 pm

Quote:

what is my host username? is it the username i use to login to my cpanel?

No. That's what I detailed in my first response.

Goto http://www.ravennuke.com/HowToInstall/ and select Prepare/Install the Database and follow those detailed istructions.

Posted: Sat Sep 20, 2008 10:08 pm

sry i misunderstood what you meant in your install guide by host username..like i said...im a noob....anyways i got it figured out right after posting had to replace localhost with different entry. Now when i load the installSQL.php and get to step 1-load core tables i click it and it doesnt load. i get an error at the bottom of page

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Duplicate entry 'Feeds-use_fb' for key 1
Warning: Unknown(): open(/var/php_sessions/sess_da28625526e7229a3a89218f5217f88c, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/php_sessions) in Unknown on
line 0

what did i do wrong now? thanks again

Posted: Sat Sep 20, 2008 11:33 pm

i found some posts in the forums with like problems and tried some things
first i deleted all tables from the db and went to mypage.com/INSTALLATION/installSQL.php and this was already at the bottom of the page

Warning: Unknown(): open(/var/php_sessions/sess_95f7a17e72d435d6c56d317c6cf1e07a, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/php_sessions) in Unknown on line 0

Should it be like this? when i click the load core tables button it flashes real quick something in the box and then goes back to not loaded. I also changed the My SQL connection collation to latin1_bin. I dont know if that was supposed to help, seemed to help some in other posts. there are other latin1 selections also. but i havent the slightest idea what the difference is. with latin1_bin i get the same result. There is another line above my sql connection collation but i cant seem to be able to adjust it. its called My SQL charset and it seems to be perma set to UTF-8 unicode (utf8) Right now im lost so any help would be great. thanks

Posted: Sun Sep 21, 2008 12:52 am

sry for the constant posts. i got it to work by just going through the load buttons even though it never said loaded in the box. finished and went to setup and everything seems to be working. finished rest of installation instructions. now just one final question. Where do i use the wysiwyg editior? is there instructions somewhere on how to use it?

Posted: Sun Sep 21, 2008 3:36 am

The first thing you need to do is contact your host and ask them to check the session.save_path is correctly set on the server - the error message you are getting indicates it is not set correctly.

The editor is turned on by default and the setting is found in rnconfig.php

Code:

$advanced_editor = 1;

to turn it off change the 1 for a 0

If the editor is not working, it is likely that either some files were not uploaded correctly or were uploaded in ASCII mode instead of BINARY

registered · Posted: Sun Sep 21, 2008 7:38 am

Yeah, and not having the session path fixed will create other problems for you using RavenNuke(tm). For example, the login captcha will not work. They need to fix their screwed up installation.

Posted: Sun Sep 21, 2008 11:45 am

thanks for the help guys. the editor was working i just didnt realize it.