Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th March 2011, 21:35
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default Extending Perfect Server - Debian Squeeze [ISPConfig 3]

As I see my tutorial is posted. Please, whoever follow it, MUST be very careful. Especially the page 5 with the firewall.

The page 6 is just a suggestion for the ISPConfig developers, and no a final solution. The logic is to give the client a full back of his data IN his directory. I know that this means that his space must be bigger, but I think that this is worth it.
Reply With Quote
The Following 2 Users Say Thank You to 8omas For This Useful Post:
falko (21st March 2011), till (23rd March 2011)
Sponsored Links
  #2  
Old 23rd March 2011, 09:49
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

Personally I see the installation of webmin on a ispconfig server very critical, beacuse you may not use webmin to configure any service that is already configured by ispconfig (apache, postfix, imap, pop3, dns). Otherwise you might destroy the setup or your changes will conflict with ispconfig.

The "client" directory is not acccessible by the client and it should not be accessible, as the access in ispconfig is handled on the website level. For that reason, the backups are created per website and not per client and made available in the websites so that the client can access them.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
8omas (23rd March 2011)
  #3  
Old 23rd March 2011, 10:11
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default

I understand. That was my first thought, but I saw duplicate backups in the web folders (in cases of alias etc). That time I didn't check in the sql query if the domain was an alias, or a 'real' domain. Now I think I can prevent that.

I will try to follow your advice and change the storing folder. I will post here the results.

As of webmin, I totally agree with you. I only install it for web based access in case of problems (e.g. I once managed to lock myself out of ssh. Thank God, I had installed webmin, and I unlocked myself.) Probably I must mention it in the tutorial.

P.S.
Could you move this thread to the right section of forum? I accidenty put it here, when it should be placed to 'How To related"

Last edited by 8omas; 24th March 2011 at 10:46.
Reply With Quote
  #4  
Old 23rd March 2011, 13:16
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default

Quote:
Originally Posted by till View Post
The "client" directory is not acccessible by the client and it should not be accessible, as the access in ispconfig is handled on the website level. For that reason, the backups are created per website and not per client and made available in the websites so that the client can access them.
Why do you say that the 'client' directory is not accessible?

I have a client webxy that can access '/var/www/clients/clientz/' directory (through sftp).
I followed the instructions in the manual and Perfect Server and the client can download his backup as long as the permissions on the files are ok for him (660 for webxy:clientz).

Am I missing sth here?

I do not have jail enabled as I haven't solved the problem with the greek characters yet ( http://www.howtoforge.com/forums/showthread.php?t=51047 )

Last edited by 8omas; 23rd March 2011 at 18:19.
Reply With Quote
  #5  
Old 23rd March 2011, 17:48
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default

I now know what you mean
I always use ssh (sftp) to access my files, and of course (assumed that jail isn't enabled) I can access the whole filesystem
With ftp, my root dir is the clientz/webxy folder.
I will change the script accordingly.
Thanks.

Last edited by 8omas; 24th March 2011 at 10:47.
Reply With Quote
  #6  
Old 23rd March 2011, 18:17
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default

Ok. I did it.
Now the backups (websites and dbs) are stored in the webxy dir.
After a very few tests, I see that there are no dublicates (concerning clients with alias domains etc).
I can also access them through ftp, as you mentioned.

I updated the tutorial, too.

Thanks again Till.
Reply With Quote
The Following User Says Thank You to 8omas For This Useful Post:
falko (24th March 2011)
  #7  
Old 28th March 2011, 12:22
tazmon95 tazmon95 is offline
Junior Member
 
Join Date: Nov 2006
Posts: 29
Thanks: 4
Thanked 1 Time in 1 Post
Default

8omas,

Thanks for this How-To. A lot of great things in it. I've been able to get most of it working but there are a couple parts where I'm getting error messages I haven't been able to trouble shoot.

When running /root/scripts/mytail I get:
Quote:
Couldn't find file: -- Quitting.
/root/scripts/mytail: line 3: -n: command not found
and when I try /root/scripts/mybackup.sh I get:
Quote:
-------------------------------------------------------------
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
-------------------------------------------------------------
CLEANING OLD BACKUPS in SITES folder
-------------------------------------------------------------


ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Reply With Quote
The Following User Says Thank You to tazmon95 For This Useful Post:
8omas (28th March 2011)
  #8  
Old 28th March 2011, 17:48
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default

As for the mytail, you probably forget the \ (backslash) at the end of the line:
I updated the tutorial, so it is more readable:
Code:
#!/bin/bash
multitail -ci yellow -e "ailed" -n 1000 /var/log/auth.log  \
-ci red -e "Ban" -n 1000 -I /var/log/fail2ban.log \
-ci red -e "fw" -n 1000 -I /var/log/messages \
-ci green -e "Unban" -n 1000 -I /var/log/messages \
-ci blue -e "fail" -n 1000 -I /var/log/syslog
please change the word iopen with fw.

In my backup, there is a mistake:
Code:
QRY="use dbispconfig; SELECT web_domain.system_user, web_domain.system_group, \
web_domain.document_root, web_domain.domain FROM web_domain WHERE  \
web_domain.type!='alias' AND web_domain.system_user IS NOT NULL AND LENGTH(web_domain.redirect_path)<5 OR web_domain.redirect_path IS NULL) ;"
must be written as:
Code:
QRY="use dbispconfig; SELECT web_domain.system_user, web_domain.system_group, \
web_domain.document_root, web_domain.domain FROM web_domain WHERE  \
web_domain.type!='alias' AND web_domain.system_user IS NOT NULL AND (LENGTH(web_domain.redirect_path)<5 OR web_domain.redirect_path IS NULL) ;"
I corrected this.
Thanks

Last edited by 8omas; 29th March 2011 at 00:02.
Reply With Quote
  #9  
Old 28th March 2011, 18:14
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
Default

Sorry, I just saw that is a copy-paste mistake.
The same mistake appears in all queries.
Just change the NULL) to NULL and you 'll be ok

Not correct. See the next post

Last edited by 8omas; 29th March 2011 at 00:08.
Reply With Quote
  #10  
Old 29th March 2011, 00:09
8omas 8omas is offline
Senior Member
 
Join Date: Jan 2011
Posts: 148
Thanks: 16
Thanked 35 Times in 26 Posts
 
Default

The mistake is the missing ( before LENGTH -- NOT what I mention above. So you must have this:
Code:
(LENGTH(web_domain.redirect_path)<5 OR web_domain.redirect_path IS NULL)
I reupdated the tutorial

sorry for the inconvenience
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
problem-Perfect Server Debian Squeeze (Debian 6.0) With BIND & Courier [ISPConfig 3] ph-tvs HOWTO-Related Questions 2 21st February 2011 15:00
Debian 5 Ajax error + network interface always shutting down ev0css Installation/Configuration 3 5th June 2010 12:58
URGENT PLEASE HELP!!! RE: The Perfect Server - Debian Lenny (Debian 5.0) [ISPConfig 2 husskii HOWTO-Related Questions 1 6th January 2010 22:45
The Perfect Server - Debian Lenny (Debian 5.0) [ISPConfig 2] - Page 3 edge HOWTO-Related Questions 4 19th February 2009 20:24
What can be wrong martin_rudowicz Installation/Configuration 9 11th May 2008 19:42


All times are GMT +2. The time now is 22:24.


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