open_basedir error during 4.8.2 upgrade

[memdy]

We just moved to a new server and we are having problems with the open_basedir issue, after reading several posts it looks like the open_basedir errors were corrected/compensated for in the latest version. So we attempted an upgrade. But ....

While running 4.8.2 upgrade.php script I get this error at the top of the page.

---------- error msg -----------

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/config-inc.php on line 11

--------- error msg --------------

How do we correct the open_basedir errors?

Specs
--------------
PP 4.8.2
RedHat9
URL: http://www.offshoreonly.com/gallery
PHP Info: http://www.offshoreonly.com/gallery/phpinfo.php
Apache 2.0
PHP 4.2.2

[memdy]

That categories aren't showing up as well, the stats say the pics are still there but they aren't showing and i can't login to the admin either.

[Chuck S]

In config-inc.php


if ( !isset($skip_exheader) ) {
include "header-inc.php";
}


change to

if ( !isset($skip_exheader) ) {
include "/home/httpd/vhosts/offshoreonly.com/httpdocs/galleryheader-inc.php";
}

[memdy]

I tried both

if ( !isset($skip_exheader) ) {
include "/home/httpd/vhosts/offshoreonly.com/httpdocs/galleryheader-inc.php";
}

and
if ( !isset($skip_exheader) ) {
include "/home/httpd/vhosts/offshoreonly.com/httpdocs/header-inc.php";
}

both produce the error msg below at the top of the page

----------------error msg ----------------------------

Warning: Failed opening '/home/httpd/vhosts/offshoreonly.com/httpdocs/header-inc.php' for inclusion (include_path='.:/usr/share/pear') in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/config-inc.php on line 19

-------------- end error msg ----------------------------

Lost my vb3 style integration as well

[Chuck S]

Notice you forgot the / between gallery and header on that one line above

galleryheader-inc.php

should be

gallery/header-inc.php

[memdy]

Good catch, thanks. So it looks better now, but what happened to all my categories and pics after the upgrade?

[Chuck S]

I do not know what you mean an upgrade doesnt delete anything.

what steps did you do when you upgraded?

[memdy]

1. uploaded all the files for 4.8.2
2. ran /upgrades/upgrade.php
3. upgrade ran successfully, only seemed to be a handful of DB changes
4. i'm now unable to login to the Admin and all the categories are missing
5. The statistics say there are still 4,000 pictures but they are not displayed

[memdy]

I tried restoring my original 4.7 version and the errors are still there, it's obviously something to do with how the new server is setup and interacts with PP, but what? vBulletin and the rest of the site are working just fine.

Browse to the URL to see the errors with 4.7 (maybe i better go back to 4.8):
http://www.offshoreonly.com/gallery/index.php

[memdy]

Oh yeah, but the categories and pics are back after going back to 4.7. Should I try the upgrade again or fix the user_basedir problem first?

[memdy]

I'm having a similiar problem with the classifieds too, i think they may be related.

user_basedir error after moving to new server

[Chuck S]

Have you set your pp_path in the config file to this

/home/httpd/vhosts/offshoreonly.com/httpdocs/gallery

[memdy]

Here is a copy of my config-inc.php and header-inc.php files

http://www.offshoreonly.com/gallery/config-inc.php.txt

http://www.offshoreonly.com/gallery/header-inc.php.txt

The only place i know to set the pp_path is in the admin GUI, where is the config file for that? It shows correctly in the GUI.

I did edit the pp-inc.php to fix the templates error message, by adding my path here.

// Little cleanup in case config-inc.php isn't current
if ( !defined('TMPL_PATH') ) {
define('TMPL_PATH', '/home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/templates/');
}

[Chuck S]

You using a prior version and not the current thats fine what you did

[memdy]

The categories and pics are back, but i'm still getting the user_basedir errors.

-------------- begin errors -----------------

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 54

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 54

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 157

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 157

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 158

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 158

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 2071

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 2071

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/index.php on line 30

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/index.php on line 30

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/index.php on line 31

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/index.php on line 31

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/login-inc.php on line 15

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/login-inc.php on line 15

------------------ end errors -------------------

How do I fix this open_basedir problem?

URL to Gallery: http://www.offshoreonly.com/gallery

[Chuck S]

Yep your php is locked and these must be set. I would if I where you download 4.8 which has the pp_path variable before every file call

[memdy]

Upgrading now .....be right back

[memdy]

After uploading all the files for the upgrade, except config-inc.php and install.php then I went to /upgrades/upgrade.php and i got this error

-------------- begin error message --------------------

Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/upgrades/upgrade.php on line 15

Fatal error: Failed opening required 'config-inc.php' (include_path='.:/usr/share/pear') in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/upgrades/upgrade.php on line 15

-------------------- end error msg -------------------------

So I edited upgrade.php and put "../" in front of the config-inc.php like this....

require "../config-inc.php";

That seemed to solve the upgrade.php errors, i ran 4.7x->4.8 ( i was running 4.7j)

Upgrade script ran but got errors. Here's the output:

----------------- begin --------------------------
Preparing to reorganize admin options...
ALTER TABLE categories DROP INDEX lastphoto failed with error: Can't DROP 'lastphoto'. Check that column/key exists
ALTER TABLE categories DROP INDEX thumbnail failed with error: Can't DROP 'thumbnail'. Check that column/key exists
ALTER TABLE iponline DROP INDEX userid failed with error: Can't DROP 'userid'. Check that column/key exists
ALTER TABLE photos DROP INDEX approved failed with error: Can't DROP 'approved'. Check that column/key exists
ALTER TABLE photos DROP INDEX date failed with error: Can't DROP 'date'. Check that column/key exists


Done! You can now remove this file and check out your new Admin Options layout!

--------------- end ---------------------

Should I be concerned about the above errors? The upgrade looks successful, all the categories and pics are there.

Next i edit the header-inc.php to integrate with vBulletin again, then i get errors.

------------------ begin error msg ----------------------------
Warning: open_basedir restriction in effect. File is in wrong directory in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 63

Fatal error: Failed opening required './languages/english/pp-inc.php' (include_path='.:/usr/share/pear') in /home/httpd/vhosts/offshoreonly.com/httpdocs/gallery/pp-inc.php on line 63
----------------- end error msg --------------------------------

So now what?

[Chuck S]

What is your config-inc.php pp_path set to?

Here is line 63

require "{$Globals['PP_PATH']}/languages/$pplang/pp-inc.php";


Do you see why I am asking you what it is set to?

[memdy]

Thanks OT i don't know why of all the times i've installed PP this was such a beast. It's working now. The PP path was set to "." i guess i was looking right over it each time. Is that in config file somewhere or only set in the DB? Surely i would have seen it in a config file somewhere.