Re: sql help with serv-u

Dale E. Reed Jr. ( (no email) )
Mon, 03 Mar 1997 11:29:31 -0800

Erik Lundby wrote:
>
> OK I installed serve-u for my authenticated ftp. It seems to work great,
> so-far. One problem, I have not had a default directory for anybody that
> I have created to date. Do I have to go and put one in manually for every
> user currently in the system?, or can I create a default directory with
> usernames for all my current ppp, and pppx2, and pppx3 accts with isql?

There are two issues:

A) Setting the field in SQL Server
B) Creating the directory

A) Use a SQL Statement like:

Update SubAccounts
Set HomeDir = "\\server\share\" + login
Where AccountType = "PPP"

Repeat as often as needed changing PPP to what you need.

B) Create the directories.

What I did a while back was this query:

Select cmd="MD " + homedir