Backup DB via ACP

Posted: Thu Nov 15, 2007 2:41 pm

The only thing i have noticed is the Backup DB via the admin control panel isnt working. Just noticed it today, could be related to something else i suppose....

although, it works if i remove the addhandler line that tells it to run in php5

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

Are you referring to the ACP in nuke? If so, check your server error log to see if there's a MySQL error.

Posted: Mon Nov 19, 2007 11:09 am

ya sorry i didnt give more info. the latest RN distro, on RWH. the nuke acp, backup database option. works under php4 but not php5.
I get a 500 internal server error when trying to use.

if you are talking about the cpanel error log only thing i saw as a possibility was:
File does not exist: /home/myname/public_html/config/sender.php

Posted: Mon Nov 19, 2007 1:24 pm

RN does not have any folder called config so I don't think that has anything to do with it.

Posted: Mon Nov 19, 2007 7:26 pm

ya i looked into it - looks like that was from some kind of hack attempt designed for some other cms, joombla maybe....

I can tell you that i'm building another site with a "barebones" database and it does the same thing, also under RN. So not sure it's an sql error. If i remove this from htaccess it works fine on both sites.

Quote:

AddHandler application/x-httpd-php5 .php .php4 .php3 .phtml

so i assumed it had to do with the upgrade to php5.. if there is somewhere else to look at errors (other than cpanel) I'd be glad to spend some time troubleshooting.

Posted: Mon Nov 19, 2007 8:37 pm

A 500 error is almost always a misconfigured .htaccess file. But that line of code is correct so it is something else. I have logged it as an issue in our issue tracking system. We will get back with you if/when we resolve it.

Posted: Tue Nov 20, 2007 1:56 am

thats cool - not critical there are others ways to get the job done. just thought you might want to know since it seemed like, at least on the surface, a php5 issue.

Client Joined: Jan 29, 2004 Posts: 624

spasticdonkey wrote:

ya i looked into it - looks like that was from some kind of hack attempt designed for some other cms, joombla maybe....
AddHandler application/x-httpd-php5 .php .php4 .php3 .phtml

I have that addhandler line in my .htaccess so in effect I'm running PhP5 and I can backup my RavenNuke database through the RN ACP. I don't think PhP5 is the issue. Maybe your database has been corrupted by the same hack attempt that put the config folder in your site, that is what shell sc ripts do, create folders and files that don't belong and mess w/t database.

Posted: Tue Nov 20, 2007 7:06 pm

i didnt have a config folder, that was in the error log. the hack attempt was looking for that file. thought possibly it was a server folder i didnt have access to see....

However, I'll take another look at it, since it's working for you.

Posted: Tue Nov 20, 2007 8:31 pm

Oh OK,Well why not get a copy of Raven's Hack Alert sc ript from D/Ls, rename it sender.php make a config folder and put it in there, then if the hack attempt comes looking for it you'll know who and what it is. Just put your admin email in it...

Posted: Mon Nov 26, 2007 10:31 am

I don't know if this is the cause but there are errors in backup.php.

The function mysql_die tries to access variables that are out of scope. You need the line:

global $strError, $sql_query, $strSQLQuery, $strBack, $strMySQLSaid;

at the top of that function.

I was able to run a backup thru the ACP on my localhost using php5.2.5 after doing that. Also the variable $name is undefined. I'm not sure what the author intended that to be (and I don't care). But you can make it a global at the top of the program (right after the access denied) by putting in this line:

global $prefix, $db, $admin_file, $name;

* note $name is just added to the other globals there.

If someone can test this and see if it fixes the situation that would be appreciated.

Hopefully we will be able to get a fix in 2.20 (or eliminate the backup entirely). I'm not entirely comfortable that the undefined variables are what's causing this but they are errors. However, I can't replicate the problem and I am able to get a backup under PHP5.x.

Posted: Wed Nov 28, 2007 1:01 pm

Well I tried the fix and no change. Was gonna troubleshoot some more but looks like the conversion to php5 is complete, so when removing the addhandler line i can no longer try in php4 (it worked without that line prior to conversion)

Tried it with a "virgin" htaccess file on a fairly new, non-public, unmodded database and still no luck Sad

i get a 500 error when trying to backup via ACP in IE.
In firefox i get this instead of save as sql

i'm in a remote area and NOT on high speed Sad

15kb sec 128kISDN line...
this option was always the fastest for me - seemed to build the file dynamically instead of downloading a large file...

Posted: Wed Nov 28, 2007 2:33 pm

I am working on a version of backup.php for Ravennuke 2.20. I can probably forward you a copy in a day or two to try out, I am just making what I hope are some final changes today. The old program was riddled with bugs. I still would recommend using something like PHPmyadmin or a host based backup program but we'll provide a working backup.php for those situations where you can't.

If you don't have it you will want to get bigdump (search for links) and gzip the dump file on your PC before reuploading it to the server. With IP2country and some other big tables in the Nuke database it really isn't practical to restore the database any other way.

Posted: Tue Dec 04, 2007 1:07 pm

sounds great man Smile

for now i'll stumble thru the less user-friendly (for me) way of backups Smile