vsftpd virtual users home directories with pam-mysql

Question

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?

Answer 1

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

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