Problem installing SQL tables with installSQL.php

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

This is the second install of RavenNuke(tm) I've done. The first was flawless! Now I am trying to install on a different domain using MySQL 5.0.45 (the only difference I can find) and running into this issue:

Code:

Warning: Unknown(): open(/xxx/php_sessions/sess_xxxxxxxxxxxxxxxx, 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 (/xxx/php_sessions) in Unknown on line 0

I double checked my config.php and found localhost would not work so change it to (mysite).startlogicmysql.com (I know, its startpoop.. but it's too late now). installSQL.php shows the login to MySQL works just fine. But the error above shows up at the bottom of the page.

It seems to load the tables and then refreshes to say the tables are "Not Loaded" even though MyPHPAdmin shows them. I went through steps 1-5 and attempted to login to the new install but it would not allow admin, or general user to login.

Please help, I hope that is enough info for now. Thank you for taking a look at my problem.

log live RavenNuke(tm)!!!!!

Raven · Posted: Mon Jan 21, 2008 4:10 pm

This is a php config (php.ini) issue. The error is telling you that the setting session.save_path=/xxx/php_sessions does not exist or is not writable. Your host will need to correct that unless you have access to a local php.ini file and can override the path setting.

jakec · Posted: Mon Jan 21, 2008 4:16 pm

Is this using a different host?

Depending on the setup the $dbhost may not always be localhost. Therefore please double check the name of your database host.

......but I'm not sure that is the cause of problem.

Can you confirm your setup. i.e. windows/unix, PHP version etc.

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

Startpoop just upgraded platforms and are using vDeck 3.0 which has caused some issues for me. The funny thing is they offer an auto installer of PHPNuke 8.0 which I am avoiding due to the issues mentioned here at Raven. Currently they are using:

Platform Type: Debian
MySQL Version: 5.0.45
Perl Version: 5.8.8
PHP Version: 4.4.7
Path to Perl: /xxx/perl
Path to PHP: /xxx/php

I am still looking to see if I have access to the php.ini file

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

i'm sorry jakec. I didn't fully answer your question.

I have two sites with startpoo' one on the old platform (my older install of Raven) and one site that has been upgraded to the new platform. RavenNuke(tm) installed perfectly on the old platform (about 2 months ago) but on the new platform I have run into this issue.

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

I found the php.ini file and I can edit it. does it matter where i add the code?

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

Raven,

You nailed it. They are allowing me to edit for PHP 4 or PHP 5 and specify which with the script which one I would like to use. It was defaulting to PHP 5 so once I modified the php.ini file and renamed installSQL.php to installSQL.php5 it worked!

Thank you so much for your support. Raven rules! RavensScripts

Raven · Posted: Mon Jan 21, 2008 7:34 pm

okatvrider · Hangin' Around Joined: Jan 02, 2008 Posts: 43

Ok im having same exact problems...I had vDeck 1.0 and everything was fine and perfect..Now i have vDeck 3.0 and same problem what Mrkniceguy had...What did you do to fix it exactly...

Here is my Info

Platform Type
Debian
MySQL Version
5.0.45
Perl Version
5.8.8
PHP Version
4.4.7
Path to SendMail
/xxx/sendmail
Path to Perl
/xxx/perl
Path to PHP
/xxx/php

Same as yours........I didnt quite understand what you did to make it work....

okatvrider · Hangin' Around Joined: Jan 02, 2008 Posts: 43

Right now i have Default version of PHP: 4

Do i need to change it to 5?

Raven · Posted: Wed Jan 23, 2008 10:15 pm

Please clarify what problem exactly you are having.

okatvrider · Hangin' Around Joined: Jan 02, 2008 Posts: 43

Here you go....
Hope you can figure this one out....

MySQL Database Connectivity Test Results

config.php file found!

I was unable to reach your MySQL server using the MySQL connection settings in your nuke config.php file. The exact error that MySQL reported is:
MySQL Error # 2 = Can't connect to local MySQL server through socket '/xxx/mysqld.sock' (2)
Warning: Unknown(): open(/xxx/sess_xxxx, 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 (/xxx/php_sessions) in Unknown on line 0

evaders99 · Posted: Wed Jan 23, 2008 10:52 pm

It's not a phpNuke problem. As Raven said

Quote:

the setting session.save_path=/xxx/php_sessions does not exist or is not writable.

okatvrider, you really do need to check with your host concerning the permissions on that folder

okatvrider · Hangin' Around Joined: Jan 02, 2008 Posts: 43

What do i need to ask them....
I have to wait for like an hour before i can even talk to anyone on the phone anytime i call...

I would like to know what exactly do i need to tell them and what the problem is.....

okatvrider · Hangin' Around Joined: Jan 02, 2008 Posts: 43

mrkniceguy wrote:

Raven,

You nailed it. They are allowing me to edit for PHP 4 or PHP 5 and specify which with the script which one I would like to use. It was defaulting to PHP 5 so once I modified the php.ini file and renamed installSQL.php to installSQL.php5 it worked!

Thank you so much for your support. Raven rules! RavensScripts

I can also change from php 4 to php5...I see the option to do it but no exactly sure what im doing if i did that...does that changed everything on all my pages and other sites from php 4 to php5?

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

I changed it to ver. 5. Then edited the php.ini file
(go to vdeck > Scripting and Add-Ons > CGI and Scripted Language Support > PHP Scripting

Search for "Sessions" and look for the info above.
I changed mine to

Code:

session.save_path = "/XXXXXXXX/xxx/php_sessions"

from

Code:

session.save_path=/xxx/php_sessions

I then created folder called xxx/php_sessions on the ROOT and chmod to 755

anybody know if this is a security risk? Question

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

Well, that only worked so far as to allow the installSQL.php and setup.php to work. Now when I go to the main page it shows up as blank. I can see it try to load and then nothing. Same for admin.php

any ideas?

Raven · Posted: Thu Jan 24, 2008 12:14 pm

Quote:

anybody know if this is a security risk?

It wasn't until you posted your real path structure Shocked

. You need to edit your post and remove that info.

Quote:

Now when I go to the main page it shows up as blank

Check your server error log to see if you have any error messages.

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

Oh, wow. thank you. did that fix it? or do I need to change post Fri Jan 25, 2008 with path inc. XXXXX?

Raven · Posted: Thu Jan 24, 2008 12:41 pm

I just noticed the info is in other posts. Change what you can and then I'll change the rest. If I were you I would also change your real setup since you may have been customized.

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

Ug, got a sick feeling in my stomach when I saw that. Thank you for your help Raven!

Do I need to change my php.ini file? Can I specify any location? i.e. can I change the "xxx" folder to something else and be ok?

Raven · Posted: Thu Jan 24, 2008 1:19 pm

Quote:

Do I need to change my php.ini file? Can I specify any location? i.e. can I change the "var" folder to something else and be ok?

This will all be dependent on what you host allows, via folder/file permissions. Since you are customizing your environment, it would be a logical assumption that if you can create the folder and apply permissions then your php.ini should be able to point to it Smile

mrkniceguy · New Member Joined: Oct 25, 2007 Posts: 18

Ok, awesome. Thank you. This php.ini customization is new to me. I guess I should have learned a little more before I started messing with it!! Smile

That's what you get for being hasty.
No site at all is better than a site made in haste with compromised security! Very Happy

Thank you again Raven.

Raven · Posted: Thu Jan 24, 2008 1:29 pm

You might want to read more in these forums.

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

okatvrider · Hangin' Around Joined: Jan 02, 2008 Posts: 43

Ok i found this

session.save_path = /xxx/php_sessions

What do i change it to?
I change the /xxx/ correct?