phpBB-TweakS
The easiest way to 'tweak' your phpBB!
  
Advanced Search
    
 
Home Downloads FAQ Register FAQ Memberlist Usergroups Ranks
  Log in to check your private messages Log in  
   
 

Please help us to develop!

 
It appears you are using a browser that is not based on Internet Explorer, this means you are not viewing the web as good as you should be. Other browsers might try to immitate Internet Explorer, but none can parse the web as it should like Internet Explorer can. So view the web as it was meant to be with Avant Browser!
         

phpBB-TweakS Forum Index phpBB Security Backup Database Failed
Display posts from previous:   
Half Thread Topic  Fully Thread Topic  Download Topic
      All times are GMT - 5 Hours  
Post new topic  Reply to topic

Mon Mar 28, 2005 3:28 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Backup Database Failed Reply with quote
I keep getting the error that the backup failed.
I have my folder: backups
and the name: backupdb
time is set for 10pm

dont know what to check Embarassed
Post #1
      Back To Top  

Mon Mar 28, 2005 5:17 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
I found (about 10 minutes ago wheni was installing this on someones site) somthing i neglected to fix when i updated the download.

OPEN
includes/phpbb_security.php

FIND
Code:

."/". $backup_folder ."/".


REPLACE WITH
Code:

. $board_config['script_path'] . $backup_folder ."/".
Post #2
      Back To Top  

Mon Mar 28, 2005 6:34 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Reply with quote
I cant find the code you have listed above in the file you stated??!
the closest I can find is the following:
Quote:
$last_backup = $board_config['phpBBSecurity_last_backup_date'];
$backup_time = $board_config['phpBBSecurity_backup_time'];
$use_backup = $board_config['phpBBSecurity_backup_on'];
$backup_folder = $board_config['phpBBSecurity_backup_folder'];
$backup_file = $board_config['phpBBSecurity_backup_filename'];

if ($use_backup)
{
if ( ($last_backup != $today) && (date('H') >= $backup_time) )
{
system("/usr/bin/mysqldump -u". $dbuser ." -p". $dbpasswd ." -h ". $dbhost ." ". $dbname ." > ". (($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] : $HTTP_SERVER_VARS['DOCUMENT_ROOT']) . $board_config['script_path'] . $backup_folder ."/". $backup_file ."-". time() .".sql", $fp);


I would think it is the second part, or I forgot to install something Embarassed but I dont want to change until I know for sure!
Post #3
      Back To Top  

Mon Mar 28, 2005 7:41 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
Yours is already changed properly. So next logical step is make sure that the backupfolder you have specified in the ACP is the same as the folder in your forums root & make sure it is CHMOD -> 777

If still a no go, contact your host & ask if system() is supported on your server.
Post #4
      Back To Top  

Tue Mar 29, 2005 3:28 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Reply with quote
Quote:
There should be no problems executing system() calls.

That is from an administrator at IPOWER

The folder (backup) is in the root directory and is 777

I just get the error that backup failed?

I also noticed when I select a time for the backup and save it, when I go back to the settings, the time is set back to ---
Post #5
      Back To Top  

Tue Mar 29, 2005 4:18 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
The time saves fine, just doesn't default back into the drop down.

As for the folder..

/ipw-web/bulletin/bb/index.php is yoru path, so

/ipw-web/bulletin/bb/backup/ should be the path, with backup 777

your script path in the acp should be

/ipw-web/bulletin/bb/

With all those settings, it should work fine.
Post #6
      Back To Top  

Tue Mar 29, 2005 4:28 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Reply with quote
I acually had that..almost Embarassed I had /bulletin/bb/backup/
I will try this, script is correct as you had...
Will let you know. Thanks! Very Happy
Post #7
      Back To Top  

Tue Mar 29, 2005 6:24 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
the backup folder name in the ACP will simply be backup no slashes or foldernames etc..
Post #8
      Back To Top  

Wed Mar 30, 2005 3:36 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Reply with quote
ARGHH! Mad
Still get the database backup failed!

Quote:
Daily Database Backup Enabled
Folder To Put Backups In /ipw-web/bulletin/bb/backup/
This folder is in forum root directory, CHMOD -> 777
Name Used For DB Backups backupdb



the bold items are how it is in the acp.
Post #9
      Back To Top  

Wed Mar 30, 2005 3:38 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Reply with quote
PS script path = /ipw-web/bulletin/bb/
Post #10
      Back To Top  

Wed Mar 30, 2005 6:24 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
aUsTiN wrote:
the backup folder name in the ACP will simply be backup no slashes or foldernames etc..
Post #11
      Back To Top  

Thu Mar 31, 2005 6:09 pm
Author Message
Cool sippenhaft Cool
Site Supporter
Site Supporter


Joined: 13 Mar 2005
Posts: 210
Words Posted: 23,478
Average Post: 111.80
Location: nj
Post subject: Reply with quote
Still no good! BACKUP failed Sad

IPOWER said
Quote:
If your script is trying to run mysqldump it most likely will not be allowed as php runs as nobody and the nobody use would not have the ability to run a script such as that. Other than that i have no further suggestions good luck with getting the script to work and let us know if you have any further questions regarind anythign being disabled or not.


Any other suggestions?
Post #12
      Back To Top  

Thu Mar 31, 2005 6:29 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
You said

Folder To Put Backups In /ipw-web/bulletin/bb/backup/


I said multiple times

Folder To Put Backups In backups

If you have not fixed that in the ACP, then your settings are wrong therefor breaking it.
Post #13
      Back To Top  

Tue Apr 12, 2005 11:18 am
Author Message
forluvish
New TweakeR
New TweakeR


Joined: 12 Apr 2005
Posts: 9
Words Posted: 732
Average Post: 81.33
Post subject: Reply with quote
I do want to backup my database into the root folder, rather than forum sub folder. Now the backup function is working perfectly well that is made to the forum sub folder

Is it possible to change the path of backup folder to the root?

My document root folder is
/web/home/scientech/html
my foum folder is
/html/phpBB2

I want to backup into
/html
instead of
html/phpBB2/backup

Is it possible, and if so, what would be the path of it in the setting ?
Post #14
      Back To Top  

Wed Apr 13, 2005 6:44 am
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
Not really because it needs to be readable/writeable...
Post #15
      Back To Top  

Mon Sep 18, 2006 5:07 pm
Author Message
AViorel
New TweakeR
New TweakeR


Joined: 19 Jul 2006
Posts: 3
Words Posted: 167
Average Post: 55.67
Location: Rovinari / Romania
Post subject: Reply with quote
Hy i have the same problem :

"From: Administrator
To: Administrator
Posted: 18 Sep 2006 11:30 pm
Subject: phpBB Security Update
Your Daily Database Backup Failed. "


"Clean Avaliable Backups:
1. uff2-2006-09-17.sql :: 0 B :: 16 Sep 2006 11:05 pm
2. uff2-2006-09-18.sql :: 0 B :: 17 Sep 2006 11:50 pm
3. uff2-2006-09-19.sql :: 0 B :: 18 Sep 2006 11:30 pm"


" [backup] DIR 15.09.2006 02:05:40 drwxrwxrwx"

I have 777 on the backup dir .. but I am not using .phpbbsecurity, i`m using .htpasswd to control access to admin may be this the problem ???
Post #16
      Back To Top  

Tue Sep 19, 2006 4:15 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
No, that wouldn't be the problem. The reason it wouldn't work would be restrictions on the server not allowing the PHP function needed to work being allowed to execute.
Post #17
      Back To Top  

Mon Sep 25, 2006 5:37 am
Author Message
AViorel
New TweakeR
New TweakeR


Joined: 19 Jul 2006
Posts: 3
Words Posted: 167
Average Post: 55.67
Location: Rovinari / Romania
Post subject: Reply with quote
aUsTiN wrote:
No, that wouldn't be the problem. The reason it wouldn't work would be restrictions on the server not allowing the PHP function needed to work being allowed to execute.



And how do we make the server to allow PHP function to write the file ?
Post #18
      Back To Top  

Tue Sep 26, 2006 2:20 am
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
Ask your host if they can enable it. The function it needs to make it is system()
Post #19
      Back To Top  

Thu Oct 12, 2006 3:05 pm
Author Message
AViorel
New TweakeR
New TweakeR


Joined: 19 Jul 2006
Posts: 3
Words Posted: 167
Average Post: 55.67
Location: Rovinari / Romania
Post subject: Reply with quote
aUsTiN wrote:
Ask your host if they can enable it. The function it needs to make it is system()


I have acc at forum and at the PC where the forum is UP ... what can i do to correct that ?
Post #20
      Back To Top  

Thu Oct 12, 2006 4:21 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
I dont follow you?
Post #21
      Back To Top  

Fri Feb 02, 2007 4:48 pm
Author Message
gbox master
New TweakeR
New TweakeR


Joined: 27 Jan 2007
Posts: 1
Words Posted: 76
Average Post: 76.00
Post subject: Reply with quote
hi guys
i have the same problem with the backup
it made 3 backups and after that it keeps failing
i found this in the acp
Fatal error: Unknown function: gd_info() in /www/xxxx.xxxx.xxxx/htdocs/gbox/admin/admin_security.php on line 64


some how i get the feeling that the data base is to big could this be ?
anyway great tool and i feel beter since i installed this safety hack

thnx
gbox master
Post #22
      Back To Top  

Sat Feb 03, 2007 8:04 am
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
The Unkown function error just means your server doesn't have GDLib installed on it, which is an image library.

If it was making backups then stopped, something was changed. Either the folder, the CHMOD properties, etc..
Post #23
      Back To Top  

Sat Feb 10, 2007 11:35 am
Author Message
Cool DragonMaster Cool
Site Supporter
Site Supporter


Joined: 11 Jan 2005
Posts: 373
Words Posted: 36,703
Average Post: 98.40
Location: USA
Post subject: Reply with quote
I have found that unless the database is tiny, it will not work properly unless it is broken into small segments.

Now I have the daily backups done automatically by my new server host that I pay for

I also have to have them install the backup if it is ever necessary
Post #24
      Back To Top  

Mon Feb 12, 2007 8:32 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
My databases are around 60-80 MB's & backup fine. So how small are you talking?
Post #25
      Back To Top  

Mon Feb 12, 2007 8:59 pm
Author Message
Cool DragonMaster Cool
Site Supporter
Site Supporter


Joined: 11 Jan 2005
Posts: 373
Words Posted: 36,703
Average Post: 98.40
Location: USA
Post subject: Reply with quote
1 to 3 megs

Any more I always get errors

Currently mine is 86 after deleting all my current IP tables
Post #26
      Back To Top  

Sun Feb 18, 2007 12:13 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
Your server settings are probobly alot lower than mine. max ececution time, etc..
Post #27
      Back To Top  

Sun Feb 18, 2007 1:08 pm
Author Message
Cool DragonMaster Cool
Site Supporter
Site Supporter


Joined: 11 Jan 2005
Posts: 373
Words Posted: 36,703
Average Post: 98.40
Location: USA
Post subject: Reply with quote
Could be plus I don't know how to do it using Unix
Post #28
      Back To Top  

Mon Feb 19, 2007 5:37 pm
Author Message
p17blo
New TweakeR
New TweakeR


Joined: 17 Jan 2007
Posts: 7
Words Posted: 433
Average Post: 61.86
Post subject: Reply with quote
Can anyone offer any assistance with this.
I tried to run set the backup to run daily. After the first attempt I got a PM saying it had failed. Since then nothing. I have a folder called backup in the root level of my PHPBB directory which I have CHMOD to 777.
After reading comments about system() I contacted my host to ask them and this was the response.

"You do have access to system(), but PHP safe mode/open_basedir might be restricting which Unix commands you can access. If you let me know which script it is I'll see if I can see why it doesn't work."

Any thoughts? And why did it PM me the first time to let me know it had failed but has not on subsequent occasions?

What runs the job? Is it visitor activity? As I havn't seen a CRON job setup for it

Thanks

Paul
Post #29
      Back To Top  

Wed Feb 21, 2007 9:12 am
Author Message
p17blo
New TweakeR
New TweakeR


Joined: 17 Jan 2007
Posts: 7
Words Posted: 433
Average Post: 61.86
Post subject: Reply with quote
I am now regularly receiving backup failed messages (once a day) from PHPBB so I just need to know if anyone can shed any light as to what is actually happening when the backup script is run (is there an actual script run) so I can try to bottom this one out.

Thanks

Paul
Post #30
      Back To Top  

Wed Feb 21, 2007 8:21 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Avera