Rsync Backup - User Permissions

Jan 18, 2009

I have a problem with my rsync backup

First of all my setup is thus:

I have a Linux box at the office which has an rsync cron on it which pulls from my web server as a backup. It pulls websites, mysql, conf files etc.

My web server is running debian etch LAMP etc.

When I originally set it up I used root user to log into the web server, and setup keys to authenticate, this worked perfectly.

I then decided that having direct root access to the web server was a bad thing so I have turned off root login (PermitRootLogin no in sshd_config)

I then setup a backup user which works fine for the website files but fails on permissions for the mysql data files (/var/lib/mysql)

How can I get over this without granting root access to the backup user which would defeat the object of not allowing root access.

I have been told about host authentication based on ip address but I have dynamic address at the office so that would be no good

View 2 Replies


ADVERTISEMENT

Plesk 12.x / Linux :: Webspace System User And Rsync Permissions

Nov 21, 2014

I have just used rsync to backup a dedicated server to a new cloud server. I put the files in a plesk webspace 'Backup' folder for ease of use (gui). In File Manager for that webspace it shows the folder user and group as root, which is obviously correct as rsync maintains users etc?

Thats fine, I just wanted to be able to back them up along with the rest of the server configuration and content.

However, when I run backup it says "For security reasons, backing up is performed on behalf of subscription's system user. This system user has no read access to:" and "So it was not backed up. All other data was backed up successfully. To fix this issue you may grant access read/write to the file or directory for system user "(username)" or "apache"."

I don't know how to give read/write access to the system user? Through file manager there is no option to change permissions.

View 1 Replies View Related

Upgrading To VPS - User And Group Permissions

Jul 23, 2009

I've finally made the leap to upgrading from shared hosting to a VPS. I'm still setting up my configuration before I point the domain name to my new server, but for now, I have the site mirrored and I'm ensuring that all is running well. For the most part, everything is working, but I am running into a few permission issues...

As of right now, all the files in my htdocs directory are owned by root, and I am logging into my FTP client as root. However, I'm pretty sure that this is not how I should be doing this, because I need to allow write permissions to some folders from my php scripts.

I was just curious, how do you you guys set up the users and groups on your linux servers (running apache). I'm just not certain of the best way to handle it. Should I make a new FTP user, and if so, what group should it go in? Should that user be the owner of all the web files? When is it safe to set folder permissions to 777?

View 4 Replies View Related

MySQL Forgetting User Permissions

Jul 5, 2007

Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found.

[url]

I am running a VPS server with the following:

WHM 10.8.0 cPanel 10.9.1-S14304
RedHat 9 i686 - WHM X v3.1.0
phpMyAdmin - 2.9.0.2
MySQL client version: 4.1.10
mysql version: 5.0.27-standard

I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE".

Here's a look at the database permissions from phpMyAdmin.

Code:
User Host Password Global privileges Grant
hello localhost Yes ALL PRIVILEGES Yes
hello_ % No ALL PRIVILEGES Yes
hello_ localhost No ALL PRIVILEGES Yes

The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.

View 3 Replies View Related

What Are Common MySQL User Permissions

Jun 29, 2007

I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security.

Here is a full list of permissions I can grant to the user (via Webmin):

-Select table data
-Insert table data
-Update table data
-Delete table data
-Create tables
-Drop tables
-Grant privileges
-Reference operations
-Manage indexes
-Alter tables
-Create temp tables
-Lock tables

View 3 Replies View Related

Cronjob :: User/bin/crontab Permissions Are Incorrect

Apr 19, 2008

I am trying to setup a cronjob but cPanel, (Linux Centos 5), tells me that user/bin/crontab permissions are incorrect and need to be changed to 4755 - I try to change permissions in WinSCP [Properties] but it doesn't 'take'.

how to force a change of permissions with SSH (Putty)

View 2 Replies View Related

How To Edit FTP User Permissions On A CPanel Account

May 15, 2008

My Pink Floyd website has a photo section of rare concert pictures that our members upload. We have about 3,000 of these pictures, that our members upload via an FTP server that is hosted on a simple cPanel web hosting account. Someone logged into the account and not only deleted all the pictures, but uploaded obscene pictures and index.html files to some really nasty stuff.

We delete all the obscene stuff, but before we re-upload all the pictures I need to know...

On a cPanel account is there a way to have the FTP User only able to upload files and not edit/delete/change? Somehow we can edit their permission?

I asked HostGator about this and the ChatTech said this cannot be done, and I was a bit surprised. I could easily do this on my own server, but i'm not sure where to start at the user level.

View 7 Replies View Related

Plesk Automation :: Change Of Permissions For User

Jul 2, 2014

I believe the product we are using is Parallels Operations Automation.

We have a customer that we want to be able to give the right to unlock user accounts. The only way to do this seems to be to enable "Billing" as one of the privileges. Unfortunately this gives them more access than we really want to. Is there some trick we can use to give this user only these rights?

View 2 Replies View Related

Granting MySQL Command Line Permissions To A User

Sep 3, 2007

Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account.

The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't.

Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.

View 7 Replies View Related

Plesk 12 Permissions For Sites Using Apache For User And Group

Jan 6, 2015

We have several sites on one server. When I use the plesk wordpress manager it some how updates the User and Group permissions on folders and files with the username apache. How or what command do I run to get it to use the site username and psacln. It appears something maybe in an update or whatever has caused this issue. This only occurs with wordpress and drupal updates from the plesk interface.

What command can I run just to update the permissions to update all users to a username and psacln security settings on folders and directories.Running Plesk 12.0.18 and CentOS7

View 1 Replies View Related

Plesk 12.x / Linux :: Modify Permissions On User Www-data

May 6, 2015

We cant' modify any files of my website in WordPress that contain user www-data.

How can you can change the permissions to this user (www-data).

The version is Plesk 12.0.18 Actualización #44

We have also Plesk 11.5 with WordPress and never has www-data user.

View 3 Replies View Related

Rsync Backup To NAS Via FTP

Apr 7, 2008

I just signed up with Rsync Palace for remote backups 2 days ago. Otto and Darin at Rsync Palace gladly helped me out and actually ended up setting me up for free. It's really an inexpensive price to pay for a little additional piece of mind to have a remote backup.

I have a VPS with cPanel that has NAS on a private network. The way they set it up was for Cpanel cron job to create backups of my VPS and place the backups in a /backup folder off root; Daily, Weekly and Monthly.

Then they have Rsync via cron set up to take those backups to the remote Rsync Palace server daily.

I still want to maintain backups on my NAS in the datacenter. (cPanel will only backup remotely or locally, but not both.)

In addition to Rsync securely transferring my data to Rsync Palace for offsite backups... How can I set up Rsync to ftp the same /backup data across the private network to the NAS? (Only ftp is available via the NAS.)

View 2 Replies View Related

How To Backup To Your PC Using Rsync

Jul 28, 2008

I use bqbackup.com in addition to ServInt's backup. The ServInt backup is inaccessible to me and can be restored only by their NoC.

Is there a way for me to download the backup files from bqbackup.com to my PC? I am using Win XP Pro. I backup the entire VPS, but I want to be downloading only the changes made each day after the initial download to my PC.

View 2 Replies View Related

Rsync / Backup

Nov 10, 2007

I am setting up a mirror server to kick on in the event my main server fails and I need some help with syncing the two.

It is my understanding I can use rsync to mirror the two. But, will that cover everything (ie. database, mail, etc) or only files?

View 5 Replies View Related

Rsync Backup

Apr 13, 2007

I am using rsync to database and i found out it corrupted my database. I should have used mysql dump before backing up the data..The problem with taking mysql dump each is that it takes a long time and resources as database is around 10 GB

if i want to take backups every 4 hour, whats the best way as mysql dump causes server load problem

View 14 Replies View Related

So I Do An RSync Backup - How Do I Restore It?

May 3, 2008

Backing up a server is obviously very important. Lets say I do a daily rSync backup and eventually my server HDD crashes, I know it isn't just a 'one click' job to restore my backup but what is it necessary to do in order to carry out a complete and effective restore back to how it was?

A step-by-step 'tutorial' on restoring an rSync backup would be helpful not just to me but to many 'would-be' server administrators.

View 4 Replies View Related

Basic Rsync Backup

Apr 23, 2009

Does anyone have a good link that explains the basics of setting up rsync for going from one host to another host?

View 5 Replies View Related

SSH, Rsync And Offsite Backup

Jun 3, 2008

I have a VPS with remote backup that I dod every night with rsync.

Now, for further SEO testing, Im looking into a reseller account.

Some reseller plan do offer access via SSH. Im not familiar with this ssh access for a reseller. Would I still be able to program a cpanel backup and then rsync all my cpanel backup ?

View 5 Replies View Related

Databases Backup ? (Rsync)

Nov 3, 2008

I am using bqinternet.com to backup (Rsync) some accounts.

I sent them a ticket before 2 days and didn't get any reply.

I used this command to schedule a remote backup for specific accounts:

Code:
echo "30 6 * * * root rsync -avz -e ssh ~account1 ~account2 ~account3 myuser@myuser.bqbackup.comerver" >> /etc/crontab

But, I found this command will backup only files.

How can I backup also databases?

View 11 Replies View Related

Rsync Backup Related

Apr 16, 2007

Currently I am using rsync to backup directory and mysqldump sql file on both external and internal backup drive

Now the directory has around 100,000 files that hardly change. Only thing that happens in that directory is either the old files are deleted or new files are added. All of them image

Due to some reason when i rsync using any of the two commands below, it transfer each and every file again rather then transferring the new or updated files.

Here is what i am currently using

rsync -avH /old/path /destination/path (this is for internal backup drive)

or

rsync -avz -e ssh /old/path username@username.remoteaddress:/destination/path

why all my files in the directory all uploaded again

View 4 Replies View Related

Using Rsync To Backup An Entire Server

Mar 12, 2007

The backup program (cpbackup) that comes with WHM/Cpanel is not ideal for our current situation. We have lots of third party applications installed on our server along with many customized configuration files. We need a solution that will backup everything and allow for fairly simple restoration.

How viable is rsync for full server backups? Can it handle 100 GB of data?

More importantly, how would you restore the backup to a new server? If the new server already has an OS the restored files would break the system, right?

View 2 Replies View Related

Rsync Command To Backup On Other Server

Mar 27, 2009

We want to backup the contents of our public_html dir to another server we sue for backups. What is the proper rsnyc command to use. I am currently in the source server and want to send it to a specific user account on the destination server.

View 2 Replies View Related

Rsync Backup Service Recommendations?

Apr 16, 2008

I'm looking for a new rsync backup solution. I've googled around and have seen a few but wanted to get the opinion of the community.

Any recommendations? All I know about is bqbackup.com and rsync.net. Any other ones?

View 14 Replies View Related

Want To Start My Own RSYNC/FTP Backup Service

Oct 31, 2008

Want to start my own RSYNC/FTP backup service... whats needed?

Besides the physical server and lots of GB's what software packages are needed, any tips on how to tie them together?

Do you create linux users, and then assign those users to an FTP account to a home folder?

View 10 Replies View Related

What Is The Best Way To Get Backup From Linux Server To Windows Same As Rsync

Nov 5, 2008

What is the best way to get backup from linux server to windows same as rsync

i need to take offside backup from my linux server to windows server,before i used rsync to take backup,now i need to make backup in windows server with help of any software which work same as rsync or any software which must have good feature.

View 2 Replies View Related

Rsync To Remove Server, Backup Solution

May 1, 2008

I have two vps's. VPS1 is for hosting my sites, VPS to I purchashed to backup to.

I know I can use rsync but i'm confused at how to do this exactly.

Backup to remote server every other day.
Only do incremental backups.
Backup cpanel accounts

View 1 Replies View Related

Which Folders Should I Exclude From A Whole Server Backup (Rsync )

Nov 10, 2008

I am going to backup the whole server. (Rsync)

I understood it is not efficient to backup the local "backup" folder to avoid duplicated backups.

1. Should I exclude additional folders from the backup process?

2. I noticed it is familiar to exclude the "proc" folder also ... Why?

View 5 Replies View Related

Daily Backup + Rsync Ssh + Large Number Of Files

Oct 29, 2006

i just wana know is it safe to do remote daily backup for about 70,000 files?

file sizes is about 200kb and every day i have about 1000 new file, so rsync first should check old files becouse i am deleting about 30-50 of them daily and them backup new 1000 files ,
so how much it will take every time to compare that 70,000 files?

i have 2 option now:

1-using second hdd and raid 1
2-using rsync and backuping to my second server , so i can save about $70 each month.

View 9 Replies View Related

Offsite Backups (via Rsync) - What Files/folders To Backup

Jun 3, 2009

I'm currently using (amongst other backup systems) rsync to an offsite space (am using BQBackup at the moment)

I'm just wondering - apart from backing up all of /home/, /var/lib/mysql/ and the important config files (httpd.conf, php.conf, etc etc) is there anything else that *needs* to be backed up?

Obviously in a worst case scenario, a new machine would be deployed with a fresh OS install (and a fresh WHM/cPanel install) so I wouldn't worry about backing up OS files or cPanel core files, although I'm wondering if there's anything apart from the /home/ directory and the MySQL databases which would be lost (and so need backing up) in the event of a crash?

View 10 Replies View Related

Errors During WHM Backup - Problem With Permissions

Apr 6, 2009

Getting this error in our log report for WHM backups.

Copying homedir..../bin/gtar: ./public_html/webmail/SQL: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/config: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/logs: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/program: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/skins: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/temp: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/_old.php.jpgg: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/._CHANGELOG: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/.htaccess: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/CHANGELOG: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/INSTALL: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/LICENSE: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/README: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/UPGRADING: Cannot stat: Permission denied
/bin/gtar: ./public_html/webmail/index.php: Cannot stat: Permission denied
/bin/gtar: Error exit delayed from previous errors


The permissions for webmail looks like this:

drw-rw-rw- 8 mainuser mainuser 4096 Apr 15 2008 webmail

What should it be?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved