CentOS docs - Feb 2010 - Re #3: Contribution for Wiki CentOS - Virtual Hosting with VSFTPD and MySQL on CentOS 5 - HowTO Tutorial

Hello

I hope I finally made the changes right for my contribution to Wiki How To.

My Wiki username is now : ThomasLibnsek

and the HowTo is located at 
http://centosforserver.blogspot.com/2010/02/virtual-hosting-with-vsftpd-and-mysql.html


I 've added some
- explanations: why do you want to store users in MySQL? Why should 
youchoose a different password for mysql's root account than for your normal
account?
  hopefully understandable, please tell me how if not.
- vsftpd  commented explanations *why* you set the other settings like they 
are.
- correction of paths like local_root=/usr/tmp/user1


Please review it, if it is acceptable or tell me what /how to change

Thank you.

Regards,
Thomas Libnsek



----- Original Message ----- 
>
###############################################################################
> ----- Original Message ----- 
> From: "Ralph Angenendt" <ralph.angenendt at gmail.com>
> To: <centos-docs at centos.org>
> Sent: Tuesday, February 02, 2010 9:49 PM
> Subject: Re: [CentOS-docs] Contribution for Wiki CentOS - Virtual Hosting 
> with VSFTPD and MySQL on CentOS 5 - HowTO Tutorial
>
>
>>
>> Nice article, but ...
>>
>> A few things which should be changed: The explanations in the first
part
>> are a bit terse (why do you want to store users in MySQL? Why should
you
>> choose a different password for mysql's root account than for your
>> normal account?).
>>
>> Then: your vsftpd.conf contains tons of commented lines. On the other
>> hand it is missing explanations *why* you set the other settings like
>> they are.
>>
>> Next: Please do not use paths like local_root=/usr/tmp/user1 in a
HowTo.
>> Please use a sensible path for that.
>>
>> cat /dev/null > /etc/pam.d/vsftpd is useless use of cat.
>> ">/etc/pam.d/vsftpd" is enough.
>>
>> Why use
>>
ftp://ftp.pbone.net/mirror/centos.karan.org/el5/extras/testing/i386/RPMS/pam_mysql-0.7-0.5.rc1.el5.kb.2.i386.rpm
>> if you can also use http://centos.karan.org/ for downloading it?
>>
>> Cheers,
>>
>> Ralph
>> _______________________________________________
>> CentOS-docs mailing list
>> CentOS-docs at centos.org
>> http://lists.centos.org/mailman/listinfo/centos-docs
>

Nice tutorial.

But there's one particular problem that interest me a lot. Everywhere
somebody writes about vsftpd+mysql, two FTP-dedicated users are created, so all
content is owned by them. Does anybody have yet discovered how FTP is configured
on cPanel? I know they uses pure-ftpd, but their way of dealing with users is
great. Let me give an example for those who are not familiar with cPanel/WHM.

user1 is a system user. He can access (via FTP also) /home/user1. He creates a
directory /home/user1/public_html/website and wants to create virtual user. We
need to make user2 (which is virtual - NOT system user) and give him access to
/home/user1/public_html/website ONLY. If server has got suPHP running, all PHP
files under /home/user1/public_html must be owned by user1, so user2 has to
upload files with user1's ownership.

How to achieve this? Maybe someting like this is possible on vsftpd also?

Yours faithfully,
Gytis Repecka

www.repecka.com


2010 Vasaris 8, 23:20, Pir, Han Solo ra??:
> Hello
>
> I hope I finally made the changes right for my contribution to Wiki How To.
>
> My Wiki username is now : ThomasLibnsek
>
> and the HowTo is located at
>
http://centosforserver.blogspot.com/2010/02/virtual-hosting-with-vsftpd-and-mysql.html
>
>
> I 've added some
> - explanations: why do you want to store users in MySQL? Why should
> youchoose a different password for mysql's root account than for your
normal
> account?
>   hopefully understandable, please tell me how if not.
> - vsftpd  commented explanations *why* you set the other settings like they
> are.
> - correction of paths like local_root=/usr/tmp/user1
>
>
> Please review it, if it is acceptable or tell me what /how to change
>
> Thank you.
>
> Regards,
> Thomas Libnsek

Am 08.02.10 22:20, schrieb Han Solo:
> Hello
> 
> I hope I finally made the changes right for my contribution to Wiki How To.
> 
> My Wiki username is now : ThomasLibnsek
> 
> and the HowTo is located at 
>
http://centosforserver.blogspot.com/2010/02/virtual-hosting-with-vsftpd-and-mysql.html
> 
> 
> I 've added some
> - explanations: why do you want to store users in MySQL? Why should 
> youchoose a different password for mysql's root account than for your
normal
> account?
Yupp.
>   hopefully understandable, please tell me how if not.
It is mostly okay, I don't think readers will have problems setting it
up from this guide.
> - vsftpd  commented explanations *why* you set the other settings like they
> are.
Some of the config file stuff is still a bit superfluous, but that can
be changed later on.
> - correction of paths like local_root=/usr/tmp/user1
Not completely >:)

> Please review it, if it is acceptable or tell me what /how to change
I think you should put it into the wiki and corrections can be made
after that. Do you want to do that? If so I can give you a page on the
wiki to put the guide on.

Cheers,

Ralph