Fields needed in Emerald Database:
IISServer=Boolean
Toggle to see if External process to create user account via Resource
Kit's Create User command
Domain=varchar
Domain the user is created on (usually the server's local user table, not
the whole company domain)
IISServerName=varchar
Server where to create the user account.
IISClientDirectory=varchar
The Directory that the client's website will be hosted on (usually in UNC
structure since we would use the Samba method (the one hackers use to gain
access to a netbios connected drive) to connect to the domain to create the
directory or use the net login command.
IISFPHosting=Boolean
This would be to verify if the client will be hosting via Frontpage. If
so, it will just create a new directory web site via the web administration
tools.
IISIPMap=varchar
The IP Address the client's website will be using for binding to the site.
IISServerWebName=varchar
The name the site will be called (usually full domain name www.xyz.com)
IISServerFTPName=varchar
The name the site will be called via FTP
Any other variables that would be needed can be displayed at a later date.
Procedure of having Emerald setup the client's FTP or Frontpage site.
If the IISServer has a value of true, then on the SQL Server the run external
process would start the batch file with the variables needed to first create
the Client's account. We could use the Resource Kit's create user program to
make the account with the appropriate values and have them assigned to the
correct groups. Along with the username and password would come the
Expiration date as well. This way Emerald would control the dates and active
account information for the client. The client's Home directory will be based
within the User Manager via a global directory name based on the copied user
account defined for this (usually Z:\INetPub\users.xyz.com\~%USERNAME%). IF
the client has a full domain name, then a different home directory would be
used (Z:\INetPub\%VALUE%-%USERNAME%, Value is the value passed from
IISServerWebName and username is to make easy tracking for accoutning
purposes).
The Next step would be to use the power of SQL to make a HTML Request to the
destination server and access a modified version of the ASP web based
administration page where it would create the virtual site and bind it to an
available IP that was assigned via IISIPMap. If the server is gonna be a
frontpage server, the IISFPHosting will determine if the Frontpage Hosting
features would be activated. Any additional features could be defined at a
later date that would be needed for this.
If the site is not gonna be Frontpage hosted, then a second ASP request would
be made to make the www.xyz.com be associated to ftp.xyz.com. The client's
FTP Site would not have anonymous login and could access it via username and
password. If the client's site is a virtual directory, the same would follow
but he would see a list of all directories in the virtual site. He will only
have access to his directory structure only as read and write.
Now if the client needs a CGI-BIN directory, this can also be created via the
web-based management.
If anyone out there is interested in programming this, I would like to hear
from you so that we could work together on this and finally have Emerald work
directly with NT and IIS instead of using just one FTP server solution.
Dale, any insite on this type of configuration that could be added to Emerald
to make this function or give negative feedback on this would be appreciated.
Now the task of finding someone who would be interested in developing this
(prefer a Canadian Programmer since we are based in Canada)
----
Rudy Komsic
President, Network Administrator - Cyberglobe Communications Inc.
4996 Place de la Savane, Suite 200, Montreal, Quebec, H4P 1Z6
Tel: (514)342-3883 Fax: (514)342-5139 E-Mail: rudyk@cyberglobe.net