peterdoherty

use screenstream - ScreenStream Frequently Asked Questions

http://www.speedtest.net/result/653247613.png

cheers everyone works a treat! now any ideas on how to script a backup to backup all dbs (was going to then schedule the script in using a scheduled task). Thanks

Cheers, CSV file just contains 2 fields (username/studentid & password) - permissions will be the same for each user on their appropriate DB (the db name will be their username/studentid)

thanks, yeah will only be allowing them a few permission on the DB (SELECT/DELETE/UPDATE/INSERT/CREATE I think). Theyre only doing basic stuff. passwords will be set to their DOB (not majorly concerned with security as the server is isolated etc..)

Hi, We are in the process of setting up a mysql server (running on W2k3) for student use and have to set up a user and db for each student (100's). Is it possible to script the creation of user accounts (& set db permission) & script the creation of dbs from a file? UserId and DB name will be thier student ID which I can have in a CSV file already. Tried googling but had no luck. Any help much appreciated.

erm... http://www.edugeek.net/forums/how-do-you-do/44171-personal-webspace-pupils.html#post406578

Option Explicit Dim oFSO, oExcel, oSheet, sUser, iRow, sYear, sCourse iRow = 9 Set oFSO = CreateObject("Scripting.FileSystemObject") Set oExcel = CreateObject("Excel.Application") Set oSheet = oExcel.Workbooks.Open("C:\createaccounts\RequestForCAASWEB.xls") Do Until oExcel.Cells(iRow,1).Value= "" sUser=oExcel.Cells(iRow,1).Value sYear=oExcel.Cells(iRow,3).Value sCourse=oExcel.Cells(3,2).Value Call HomeDir() iRow = iRow+1 Loop oExcel.Quit WScript.Echo "finished!!" Wscript.Quit Sub HomeDir() Dim sHome, sHomeDir, oFolder,oShell sHome = "d:\Web\" sHomeDir = sHome&sCourse&"\"&sYear&"\"&sUser 'WScript.Echo sHomeDir If oFSO.FolderExists(sHomeDir) Then Set oFolder = oFSO.GetFolder(sHomeDir) Else oFSO.CreateFolder(sHomeDir) End If Set oShell = Wscript.CreateObject("Wscript.Shell") oShell.Run "%COMSPEC% /c cacls "& sHomeDir & " /e /g " & sUser&"@student.belfastmet.int:c", 2, false oShell.Run "%COMSPEC% /c cacls "& sHomeDir & " /e /g " & "caasweb\iusr_caasweb:c", 2, false 'set up IIS application for VD dim IIsWebVDirObj dim IIsWebVDirRootObj dim NewFolderName NewFolderName = sCourse&"\"&sYear&"\"&sUser '"HNCComputingDay\07\GIL08173716" const UseExistingApplicationPool = true 'Set IIsWebVDirObj = GetObject("IIS://localhost/W3SVC/1/Root/" & NewFolderName) ' Create the Metabase entry Set IIsWebVDirRootObj = GetObject("IIS://LocalHost/W3SVC/1/Root") Set IIsWebVDirObj = IIsWebVDirRootObj.Create("IIsWebDirectory", NewFolderName) IIsWebVDirObj.AppCreate3 2, "DefaultAppPool", UseExistingApplicationPool IIsWebVDirObj.AppFriendlyName = sUser IIsWebVDirObj.SetInfo End Sub Obviously will need to change paths etc. Blank excel file also attached I'll just wait for all the powershell fans to crucify my vbscripting!!!! RequestForCAASWEB.xls

We have a W2k3 server running IIS. have created a script to create a folder for the class then a subfolder for each students (which is then set up as an application in IIS incase they need ASP.net). Folder permissions are all set up so that they can only add/edit files in their folder. They can upload in a couple of ways - either by connecting to a file share then navigating to their class and then their folder or the server is also set up for FTP access. All authentican is though AD. Server also had PHP installed for the adventerous types!!

i've used these guys a lot in the past - AMC :: Home cheap, excellent quality and can do any length of their max width.

some sort of foam pipe insulation or decorative coving from a diy store may do

its really the same process as vista so any any site with a guide to deploying vista will be 99% of the way to 7

big thumbs up for teamviewer - saved me a lot of miles over the past while!

you could use the file and settings transfer wizard to copy most of your files and settings over to a clean install machine then you owuld only need to install apps

try kenable - HDMI Cables, Optical Cables, USB Cables, Network Cables, Audio Cables, Sata Cables kenable for HDMI Optical TOS Network Ethernet RJ45 Scart Audio Phono Jack USB Firewire 800 ADSL Cable Leads