Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th December 2011, 10:18
vmos vmos is offline
Member
 
Join Date: Nov 2008
Posts: 57
Thanks: 1
Thanked 0 Times in 0 Posts
Default secure local mysql backups?

Good morning,
we've got a couple of servers that run a script that dumps the mysql databases into a local directory on the server.

Now this has two significant flaws. First, the mysql root password is stored as plain text in the script. Secondly, the databases dumps are just plain text, albiet zipped.

Now I've been looking for various solutions and not come up with anything satisfactory.

I could encrypt the zips but that still leaves the passwords in the script. I put the script and the dumps into an encrypted directory but then you can't run that with a cron job.

I could have a remote server login and take backups of the databases but if possible I'd like something on the local server.

These particular servers are either running debian or ubuntu with apache

Any suggestions?
Reply With Quote
Sponsored Links
  #2  
Old 7th December 2011, 10:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,974
Thanks: 825
Thanked 5,367 Times in 4,214 Posts
 
Default

There is no security problem when you run the script as root cronjob so that the script itself is owned by root and has 700 permissions and the directory where the script dumps its files has to be owned by root as well with 700 permissions. So no user except of the root user can see the mysql password in the sdript or get the mysql database contents.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Tags
dump, local, mysql, secure

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
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 10:05
I Fail at installing ispconfig where did I go wrong? stocker741 Installation/Configuration 14 30th October 2008 14:12
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11


All times are GMT +2. The time now is 13:42.


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