#1  
Old 6th November 2012, 10:14
tio289 tio289 is offline
Member
 
Join Date: Mar 2009
Posts: 70
Thanks: 2
Thanked 14 Times in 9 Posts
Default Web backups

Hello, I on latest SVN version and I try to use web backups. I set period "daily" and copies to "7".

When I look on disk, backups was created, but not inserted in DB web_backup table. I added logs to cron_daily.php and it generate sql queries, which are correct. Problem is probably in $app->db, which not execute these queries.

Many times it insert only query for 1. web, other time for first 5 webs...If some queries is inserted, them it inserted two times, because was called $app->db and $app->dbmaster. So I solve this problem by comment out $app->dbmaster .

First problem persists.
__________________
Independent Senior Webdeveloper

Last edited by tio289; 8th November 2012 at 00:42.
Reply With Quote
Sponsored Links
  #2  
Old 6th November 2012, 10:19
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,036
Thanks: 841
Thanked 5,655 Times in 4,464 Posts
Default

This has been fixed already in the current beta which is available in this forum, the svn trunk which you seemed to use does not contain latest code for the 3.0.5 release. If you want to get the latest code, then check out the stable branch for the 3.0.5 release.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 6th November 2012, 10:44
tio289 tio289 is offline
Member
 
Join Date: Mar 2009
Posts: 70
Thanks: 2
Thanked 14 Times in 9 Posts
Default

Hi, I switch on ispconfig-3.0.5 branch, duplicate entries was solved, but my firsts problem persists.
__________________
Independent Senior Webdeveloper
Reply With Quote
  #4  
Old 6th November 2012, 11:03
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,036
Thanks: 841
Thanked 5,655 Times in 4,464 Posts
Default

It works here on my test server. Is this a multiserver system? If yes, did you choose to reconfigure permissions on master server during update?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 6th November 2012, 12:07
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 932
Thanks: 16
Thanked 264 Times in 208 Posts
Default

It works on my servers (multiserver setup), too. So I think it might really be a permission problem.
__________________
Marius Cramer

pixcept KG
Reply With Quote
  #6  
Old 7th November 2012, 20:36
tio289 tio289 is offline
Member
 
Join Date: Mar 2009
Posts: 70
Thanks: 2
Thanked 14 Times in 9 Posts
Lightbulb

Hi guys, I was finally figure out problem:

it was with mysql connection timeout. I set wait_timeout and interactive_timeout to small values (60s), because many sites,cms etc. don't correctly close connections.

ispconfig backup script is running long time and mysql close connection. So I contribute path:

/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php

Code:
105 105	public function query($queryString) {
    106		parent::ping();
106 107 	$this->queryId = parent::query($queryString);
ping check for connection and if lost and mysqli.reconnect is enabled them reconnect it.

So enable reconnect in /etc/php5/cli/php.ini

Code:
mysqli.reconnect = On
Here is question if is not better to have custom php.ini for ispconfig cronjobs, which will have preddefined values, because backup files have UTC time by default. I have to set timezone also.

It's working now

I also edit cron job, I change nice and ionice, because backuping is intensive task

Code:
30 00 * * * /usr/bin/nice -n19 /usr/bin/ionice -c3 /usr/local/ispconfig/server/cron_daily.sh > /dev/null 2>> /var/log/ispconfig/cron.log
I don't know, what is better:

Calling ping direct in query function, or call it in long time scripts before every query?
Changing nice and ionice for whole cron_daily.sh or only in backup section when calling zip/tar/gzip commands?
__________________
Independent Senior Webdeveloper

Last edited by tio289; 8th November 2012 at 17:07.
Reply With Quote
The Following 2 Users Say Thank You to tio289 For This Useful Post:
falko (8th November 2012), till (8th November 2012)
  #7  
Old 8th November 2012, 16:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Thanks a lot! I've added this to our bugtracker.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #8  
Old 7th January 2013, 11:51
abdi abdi is offline
Senior Member
 
Join Date: Sep 2012
Posts: 118
Thanks: 0
Thanked 10 Times in 6 Posts
 
Default

Falko: do we have yet a feature in the upcoming version of API to initiate backup download. IE, in the control panel when you click download backup file, it's then pushed to the backup folder in the root of a domain name.

Thanks
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Server hangs, BUG: Bad page state in process lucani Installation/Configuration 1 6th September 2012 19:50
I'm attack brute force qb7 General 6 21st July 2012 22:34
Problem with fetchmail/getmail brianetilley Installation/Configuration 3 27th January 2012 13:15
ISPConfig reports SMTP-server down, with Roundcube installed toffie Installation/Configuration 2 1st December 2011 11:55
Error show pages in server qb7 General 1 31st October 2011 10:09


All times are GMT +2. The time now is 19:08.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.