Moved to new server, access denied for SU in cp

New Member Joined: Oct 01, 2004 Posts: 6

Apache 2.0.51 (custom compile)
PHP 4.3.8 (a few performance tweaks)
MySQL 4.0.21 (Pentium optimized binary)
Dedicated PIV 3.06 Ghz w/HT (1024 MB DDR RAM)
IPB-Nuke 7.3 (essentially PHPNuke only using Invision Power Board)
Turck-mmcache 2.4.6-4.1 (RPM from DAG)

Yes Yes I know.. Invision. However Invision works fine and is not the problem. The problem is entirely php-nuke related.

I moved from one dedicated server to another... moved my dbase by going to the data dir and issuing:
$ tar -cvf (dbasefolder)

Then creating a new dbase through webmin... deleting its data folder, and replacing with untarred folder I created.

This worked for just about everything on my massive site, however when logging in as GOD admin, or any admin for that matter, a blank "access denied" page is given for add story ... add survey.. and a few other areas. Mysteriously, a few other areas such as preferences will load on up. The statistics page, for whatever bizarre reason, gives a "warning: division by zero" error... but I don't really care too much about that... just want to be able to post surveys and stories again Sad

More information:

Access Denied comes up for new content... add story... add survey... etc. I can load and use the preferences and other modules. The access denied message when trying to use survey is NOT being called from admin/modules/polls.php ... which is BIZARRE.

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

Run a REPAIR through phpMyAdmin for starters. Then, check your Apache Error Log to see if anything is being recorded there.

Posted: Fri Oct 01, 2004 12:52 pm

1) Ran this: mysqlcheck -u (myusername) -p --auto-repair -o --all-databases
It then proceeded to run through everything... taking fair time to optimize dbases and repair one or two.

2) Apache error log:
- Bunch of image not founds (expected)
- Bunch of this (not expected):
[Fri Oct 01 14:52:26 2004] [warn] [client 64.182.3.27] mod_include: Options +Includes (or IncludesNoExec) wasn't set, INCLUDES filter removed
[Fri Oct 01 14:52:27 2004] [warn] [client 64.182.3.27] mod_include: Options +Includes (or IncludesNoExec) wasn't set, INCLUDES filter removed

For various IP's... over... AND OVER... AND OVERRRRRRRR

Posted: Fri Oct 01, 2004 2:59 pm

It does not sound like your database and/or files have been restored correctly. That's just a guess Smile

Posted: Sat Oct 02, 2004 4:12 pm

I moved all the files over... and tar/untarred the database... what more is there to do??

Posted: Sat Oct 02, 2004 4:59 pm

This may be like peeling an onion, but I'd start with the mod_include module. Try looking here http://httpd.apache.org/docs/mod/mod_include.html and comparing that with your setup.

Hangin' Around Joined: Jun 25, 2004 Posts: 32

gt_swagger, I replied to your initial post at IPBNuke with the thought it may have something to do with the new server running MySQL4..

Posted: Sun Oct 03, 2004 4:00 pm

Just as a side note, I've been running MySQL 4.x for 1.5 years for both my servers and personal and have never had any issues at all.

Posted: Sun Oct 03, 2004 10:54 pm

Raven wrote:

This may be like peeling an onion, but I'd start with the mod_include module. Try looking here http://httpd.apache.org/docs/mod/mod_include.html and comparing that with your setup.

mod_include is properly setup now (forgot AddHandler), and the dbtype directive in config.php is correct. Same problem persisting.

Posted: Sun Oct 03, 2004 10:55 pm

Would running a setup script for it / upgrade script have a shot at fixing it without ruining any database stuff?

Posted: Sun Oct 03, 2004 11:02 pm

What kind of errors are you throwing in Apache now?

Posted: Mon Oct 04, 2004 12:21 am

I removed the entire admin folder and config file, and replaced with a pristine copy in another working install. Obviously I had to alter the config file slightly.

Anyway... it worked after that *scratches head*

Posted: Sun Jun 05, 2005 3:04 pm

Has anybody had issues with MySQL 4.1.1 or is anyone using MySQL 4.1.1
I'm getting an error generated in line 286 of includes/sql_layer.php

The affected function is;

Code:

function sql_fetch_row(&$res, $nr=0)


{


global $dbtype;


switch ($dbtype) {





    case "MySQL":


        $row = mysql_fetch_row($res);


        return $row;


    break;;





    case "mSQL":


        $row = msql_fetch_row($res);


        return $row;


    break;;





    case "postgres":


    case "postgres_local":


   if ( $res->get_total_rows() > $res->get_fetched_rows() ) {


      $row = pg_fetch_row($res->get_result(), $res->get_fetched_rows() );


      $res->increment_fetched_rows();


      return $row;


   } else {


      return false;


   }


    break;;





    case "ODBC":


    case "ODBC_Adabas":


        $row = array();


        $cols = odbc_fetch_into($res, $nr, $row);


        return $row;


    break;;





    case "Interbase":


        $row = ibase_fetch_row($res);


        return $row;


    break;;





    case "Sybase":


        $row = sybase_fetch_row($res);


        return $row;


    break;;





    default:


    break;;


    }


}

And I fail to see why I'm getting the error

Code:

mysql_fetch_row(): supplied argument is not a valid MySQL result resource in

Bizzare!!

Posted: Sun Jun 05, 2005 3:30 pm

4.1, is not compatible with 4.0 schemas in many cases. You have to convert 4.0 tables to 4.1 and then some coding may be necessary. That error means that the table handler ($res) is not valid, meaning the table is not available for some reason. Turn $debug on in includes/sql_lqyer.php to see more about the error.