Page 1 of 1

Your Daily Database Backup Failed.

PostPosted: Sat May 10, 2008 6:44 pm
Author: Blue-Blood
Your phpBB Version: 2.0.23
phpBB Type: Integramod 141f
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://vividcs.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Your Daily Database Backup Failed.


What was done to try to solve the problem?
CHMOD is 777
deleted the .htacess




De.scription and Message

I get this message in my inbox

Your Daily Database Backup Failed.

thanks

PS i found bug on this forum in the Latest ratings page

when you click onthe topic you get this message

The topic or post you requested does not exist

Re: Your Daily Database Backup Failed.

PostPosted: Sat May 10, 2008 6:49 pm
Author: Blue-Blood
oh yeah i do have the bot name mod installed. but the backups still worked after i installed it...

it just started not working the past week

PostPosted: Thu May 15, 2008 2:27 pm
Author: star
my bk ups dont work and that was with a fresh install of 141 with nothing added everything chmd right i get a pm that says your daily back up failed.. lists the dates of available bk ups on my server and in admin special but all say 0 kb's

Re: Your Daily Database Backup Failed.

PostPosted: Sat May 17, 2008 3:39 pm
Author: XHIBIT
Yeah I'd like to join this club also, I've been getting the exact same thing for over a month now

Re: Your Daily Database Backup Failed.

PostPosted: Sat May 17, 2008 6:58 pm
Author: Allen
First install I didn't set the permissions before running install. so I also had the problem. Now I have installed a second forum and I was sure to check the file permissions and I got my first backup failed email just now.

So it is not a permissions problem.

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 12:47 am
Author: Allen
Never mind, I messed up and published the phpbb_security.php from the test site when I uploaded all my patched CTracker pages...... The test site of course did not have the permissions set prior to install. What a confusing mess I have made for myself.

I will remove and do a fresh install in the morning.

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 8:55 am
Author: Helter
if you do a search for the error message, you will find some usefull info, but it seems more common lately that web hosts are tightening up security and disabling certain php functions that are required for phpbbsecurity to work properly. Windows servers are notorious for issues here due to directory structure and permissions. Also be sure your host has not disabled the ()system command

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 1:29 pm
Author: Allen
Ok, Re-installed. No changes what so ever aside from finishing my profile. Went to Admin. Security-special setting the Max admin and mod.

All CHmod permissions set and double check prior to running the install. Program will not hold max admin and mod settings. This is right out of the box.

I know I can go in and

"HelterSkelter";p="32862" wrote:it is because when you installed your forum, includes/phpbb_security.php was not chmodded to 666 so the install was not able to write to the file. You will have to edit the file to match the database entry.
in your database open phpbb_config.
look for these thee entries and thier following values.

sec_admin
sec_mods
sec_name

open includes/phpbb_security.php
find

function phpBBSecurity_AdminConfigName()
{
return 'phpBBSecurity_max_admins';
}

function phpBBSecurity_ModConfigName()
{
return 'phpBBSecurity_max_mods';
}

function phpBBSecurity_UseSpecial()
{
return 'phpBBSecurity_use_max';
}

replace the info in red with the values from the database fields
*note... the values are auto generated and will look something like kxucgncqteynvtykgiusb
after you have edited this file, set the chmod to 644


This will fix the max admins but it wont fix the back up issue.

I will be adding this

"HelterSkelter";p="33063" wrote:try this

OPEN includes/phpbb_security.php

FIND
Code: Select all
            system("/usr/bin/mysqldump -u". $dbuser ." -p". $dbpasswd ." -h ". $dbhost ." ". $dbname ." > ". (($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] ]) . $board_config['.script_path'] . $backup_folder ."/". $backup_file  ."-". date('Y-m-d') .".sql", $fp);  


REPLACE WITH

Code: Select all
    include_once($phpbb_root_path .'includes/functions.'. $phpEx);    $my_path = search_mysqldump();    system($my_path ."mysqldump -u". $dbuser ." -p". $dbpasswd ." -h ". $dbhost ." ". $dbname ." > ". (($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] ]) . $board_config['.script_path'] . $backup_folder ."/". $backup_file  ."-". date('Y-m-d') .".sql", $fp);



I hope this will solve the back up issue. I will repost with the results.

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 1:37 pm
Author: Allen
I this the correct information?

Folder To Put Backups In
This folder MUST be in your forum root directory, it MUST be CHMOD -> 777
folder name- backup

Should there be a or a / before the folder name?

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 1:43 pm
Author: star
"HelterSkelter";p="33181" wrote:if you do a search for the error message, you will find some usefull info, but it seems more common lately that web hosts are tightening up security and disabling certain php functions that are required for phpbbsecurity to work properly. Windows servers are notorious for issues here due to directory structure and permissions. Also be sure your host has not disabled the ()system command


ive been running 140 with out any issues on back ups worked fine for 2 years on my server was working right up till i replaced it.. only since i installed 141 did it stop and was a clean full install not an upgrade

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 3:39 pm
Author: Helter
"Allen";p="33186" wrote:I this the correct information?

Folder To Put Backups In
This folder MUST be in your forum root directory, it MUST be CHMOD -> 777
folder name- backup

Should there be a or a / before the folder name?


that depends whether you looking at it from the server root path "" or the ftp path"/"
which slash to use depends on how your looking at the folder.


"star";p="33187" wrote:
"HelterSkelter";p="33181" wrote:if you do a search for the error message, you will find some usefull info, but it seems more common lately that web hosts are tightening up security and disabling certain php functions that are required for phpbbsecurity to work properly. Windows servers are notorious for issues here due to directory structure and permissions. Also be sure your host has not disabled the ()system command


ive been running 140 with out any issues on back ups worked fine for 2 years on my server was working right up till i replaced it.. only since i installed 141 did it stop and was a clean full install not an upgrade


is your 140 backup still functioning? The #1 reason for this failure on a site that once worked is a php version upgrade with tighter security

Re: Your Daily Database Backup Failed.

PostPosted: Sun May 18, 2008 5:07 pm
Author: Allen
The fix's I quoted from Helter Work!

I just got an email saying

Your Daily Database Backup Was Completed.

PostPosted: Sat Jun 21, 2008 10:34 pm
Author: BurninFingerTipz
Slight problem, I did as Allen quoted, but now I'm banned from my site since that values were set to nothing since the mod wasn't installed correctly by default... <img>

How can I fix this?


[s:c9rnue37][Edit] - Also, trying to figure out why it's blocking my account when I had it disabled...[/s:c9rnue37]

[Edit] - Figured a work around.

function phpBBSecurity_UseSpecial()
{
return 'sec_name';
}

Just leave sec_name misspelled, out, or at whatever it was, but the rest of it make sure it's sec_admin, sec_mods (as post in Allen's post,) this way it'll save your set # of admin(s) and mods, but it'll be disabled (so no admin/mod banning.) Edit the file to have sec_name, then it'll enable, and you're set to go!


Thanks to Allen for the security fix, and Helter for the original post quoted.

Re: Your Daily Database Backup Failed.

PostPosted: Mon Jun 30, 2008 2:50 pm
Author: .QUACK.Major.Pain
"Allen";p="33192" wrote:The fix's I quoted from Helter Work!

I just got an email saying

Your Daily Database Backup Was Completed.


Tried the fix and didn't work here.

It worked on our site for several months and then stopped.
Our host said no updating has been done with security that would cause this.
Never believed anything they said anyway. LOL