Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

ive saw many solutions like homedir=/somepath/$USER where $USER takes from sysvar and i want to change it for every user with mysql database. Im using it with pam-mysql so it will look like

Id login passwd homedirectory

And i want this homedirectory to put in vsftpd.conf->home_directory = something like

 select homedirectory from vsftpd where login='$USER'

Is it possible?

share|improve this question
up vote 0 down vote accepted

Crap, it's so silly and this works...

localroot = `mysql -utest -ptest -dvsftpd -e "select homedir from vsftpdtbl where userid = '$user'"`

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.