Forum

Thread tagged as: Problem, Runway, Backup

How do I do that?

I use Sequel Pro on the Mac - if that helps?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Right click on the table. Choose Truncate Table.

Thanks, I've truncated the table.

Unfortunately I'm still experiencing the same problem. Database backs up, but not the assets?

I don't understand why this isn't working?

It's strange the database backs up but not the assets.

Has anyone else had this problem? Is there anything I can do or provide you with to help fix this?

I've a few Perch Runway websites (with different hosting providers) and I've never been able to get the assets to backup.

I'm really sorry to keep dragging this thread on, but I'd really like to get backup working :)

Drew McLellan

Drew McLellan 2638 points
Perch Support

I'll take a look into it as soon as I can.

Hi

I asked about this issue in the Slack group and Rachel kindly replied. She suggested the issue could be related to the server not having the right resources to perform a asset backup.

Any change you could let me know what resources are needed, so I can pass them on to my hosting provider (Media Temple - VPS).

Many thanks.

Are you using perch_dropbox for backups? That works great for me.

Drew McLellan

Drew McLellan 2638 points
Perch Support

We've not been able to reproduce this here at all. It's working fine for us. Nothing new in your error logs?

Hmmmm, interesting.

I'll try to move the site to another server and test it there.

@Scott - Yes, I'm using DropBox for the backups.

Perch backup is a killer feature, it's a shame I can only get the database to backup and not the assets.

I'll keep at it! :)

I was wondering, is there anything specific I can ask my hosting provider to check for?

Database backs up, assets don't.

Does the assets backup have different requirements to database backup? If so, what are they?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Have you got anything new in the logs?

Yes, there's this message in the error_log. Looking back through the log It appears quite often

    [Sun May 29 11:02:16 2016] [warn] [client 39.33.180.99] mod_fcgid: stderr: PHP Notice: Undefined index: path in /var/www/vhosts/domain.co.uk/httpdocs/perch/core/runway/lib/PerchRouter.class.php on line 149 

My PERCH_SITEPATH in config.local.php looks like this:

  define('PERCH_SITEPATH', '/var/www/vhosts/domain.co.uk/httpdocs');

Are these two related?

Drew McLellan

Drew McLellan 2638 points
Perch Support

That's odd, but it's not related to back up at all.

Hmmm, ok.

There are a few other repeating errors. Would any of these be related to issues with backup?

Directory index forbidden?

Hosting provider said this sounds like it could be related to my .htaccess file

    [error] [client 72.76.243.86] Directory index forbidden by Options directive:           /var/www/vhosts/domain.co.uk/httpdocs/perch/addons/feathers/myfeather/js/ 

This is my .htacess file

    # Perch Runway
    RewriteEngine On
    RewriteCond %{REQUEST_URI} !^/perch 
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule .* /perch/core/runway/start.php [L]

    Redirect 301 /csr /social-gain

A few other errors

I wouldn't expect there to be a html file in this folder, don't suppose you'd know of a way to debug this error?

   [error] [client 72.76.243.86] File does not exist: /var/www/vhosts/domain.co.uk/httpdocs/perch/addons/feathers/myfeather/js/min/video.html

Again, I wouldn't expect there to be anything in the js folder except JavaScript files. Is this people (or scripts) sniffing for vulnerabilities?

  [error] [client 72.76.243.86] File does not exist: /var/www/vhosts/domain.co.uk/httpdocs/perch/addons/feathers/myfeather/js/text 
  [error] [client 157.55.39.95] File does not exist: /var/www/vhosts/domain.co.uk/httpdocs/perch/addons/feathers/myfeather/js/'+b.jqueryurl+'  

The IP address [client 72.76.243.86] appears a lot, I used www.iplocation.net to check it out. Looks like this IP address is repeatedly trying to access the website, specifically the js folder...

I'm getting the same thing. I can provide diagnostics later if required. Identical setup to Stephen.

The database backs up absolutely fine, but the assets aren't backing up properly. I have 30 assets spread across the default, and a few other local buckets. Only one asset gets backed up into the default bucket, and one asset into my 'projects' bucket. So they're partially working, which points me towards the possibility of it being a server resources problem of some kind?

Drew McLellan

Drew McLellan 2638 points
Perch Support

That's what my suspicion is.

Is there a server requirements page for Perch Backup? I've had a brief nosey and can't find anything.

I use a Level 1 VPS on Media Temple (RAM: 2gb, Storage: 20 Gb, Bandwidth: 2Tb), there's only one website on the VPS.

Would those specs raise any backup related eyebrows? :) I remember reading in the forums, only 5 images are backed up at a time. Surely that wouldn't max out the VPS?

It'd be handy to have some information to forward on to Media Temple.

Many thanks Stephen

Drew McLellan

Drew McLellan 2638 points
Perch Support

What's your script execution time set to?

Is this it?

Requirements for Perch & Perch Runway

  • 64 bit integers for Dropbox functionality on the server

Drew McLellan said:

What's your script execution time set to?

You mean my cron settings? See below:

  • Minute : */15
  • Hour: *
  • Day of the month: */1
  • Month: *
  • Day of the week: *

Perch Screenshot

Perch Screenshot

Scott Gruber said:

Is this it?

Requirements for Perch & Perch Runway

  • 64 bit integers for Dropbox functionality on the server

Hi Scott, thanks for your input.

Checked with Media Temple, they replied "Your DV server supports 64-bit integers. Native 64-bit integers require 64-bit hardware AND the 64-bit version of PHP, both of which are true for your DV"