jcubbin

We are looking to do something similar at my school but are thinking of using the remote control / monitoring software that will already be installed on all the Classroom Teacher machines. Clevertouch software sounds good but if it is not used regularly then it will end up becoming IT's responsibilty. If you have impero / senso etc could you not create a new group that includes all the teaching machines and then have a defined group of staff users (IT /SLT / Admin / Reception) who have the permission to send the lock down alert. Have the lock down alert slide available for these staff on their desktop so it is quickly accessible and then use the broadcast feature to send the lock down message to the machine group. Teaching staff don't need to be logged on at the machine to see the lock down alert, the machine just needs to be switched on. I am going to give this a test run next week at half term but believe it should be a suitable and cheap implementation.

Thank you for the reply. I managed to get to the bottom of it and for some reason they haven't listed the Router admin Password alongside the Serial number of each device where you would expect to see it in the portal. In our case the password is only revealed when you click on the link to https://get-help-with-tech.education.gov.uk/sign-in. Why it couldn't have just been provided in one central place alongside the list of BIOS and Administrator password for the laptops is beyond me. The page had the serial and the iMEI and the data allowance figures but not the admin password for the router. Anyway all good now.Thanks

Hi All, has anyone managed to reset their huawei 4g routers yet? The default password at the ip address of 192.168.8.1 is supposed to be "admin" but I can't get a single router to accept this password. I have tried resetting the router several times but don't seem to have any luck.Did anyone get a list of individual passwords assigned to their batch of routers or are your s all set to the default of "admin"Thanks

For everyone asking what BIOS settings to use to get USB network adapters working I would say that you will know as soon as you have a compatible adapter. I'm not sure what adapter I have as it has a USB-C Connection on it but I have usd a USB-C to USB-A Converter. It works and I have a few of them so I'm not too concerned, it may be a samsung?I played around with this for a few hours trying every setting I could think of using a Startech and another adapter without any joy. I never once seen the option to select a USB NIC until I got the compatible adapter. I'm not 100% sure if it is relevant but I also used the USB port at the front of the laptop (shown in the pictures). I had to "Enable UEFI Network Stack", "Enable USB Support" and "Enable External USB Port".This will boot up and connect to your WDS or MDT solution with Secure boot enabled and PTT onHopes this helps

I know this a really old post but I've just had the same problem on an Explorer II which I managed to fix by changing the Advanced options of the print driver from "spool print documents etc" to "print directly to printer". Hope it helps someone else in the future.

Hi davie887, are you using sql mode? and connecting using the format shown below start the shell command line \sql (This switches you to SQL classic mode) \c -c username@assword@serverip:serverport (example would be \c -c user1:[email protected]:3306 )

Your best bet would be to use the command line utility called gpresult so that you can see what gpo's are being applied and then drill down in the generated report to see which gpo is setting access to the C:\ drive and control panel. you can generate a report and find what settings are taking effect on a classroom machine if you know the machine name and also the account name of a user who has logged on at the computer. so assuming you computer is called pc1 and your user account is called pupil1 you would the start a command prompt and run as administrator and the command would be gpresult /s pc1 /user pupil1 /h c:\mygporeport.html this command is to be run from a command prompt on your technician computer. once you have this information you should have a better understanding of what is being applied at the workstation and you should see some differences if you alter your GPO. Did you create a new GPO or alter an exisiting one. If you are keen to learn more on group policy i would recommend "Group Policy: Fundamentals, Security, and the Managed Desktop" by Jeremy Moskowitz as it is a very good reference book i found.

Hi friendlytechnician, are you sure you want to enable this level of access to all students? I only ask because it's most likely that they need to use the control panel and access the c:\ drive for only a small portion of one term and very likely to be just one year group at that. The suggestions so far are really good but I would look more at using security groups, one for the PCs and one for the students you want to have access. Create a new gpo with only the settings you require and set the security filter to your two new groups only after removing authenticated users first. Apply it at the user ou level ( you possibly have the students split into year ou's ) the only thing you need to do then is move the order of precedence of the new gpo so that it gets applied last, this will then overwrite the default settings when the users in your new user security group logon at the PCs in the new PCs security group. When these users logon at any other PCs around the school they will not get the new gpo settings applied as the other PCs have no read access to the new gpo and therefore cannot apply it. This is only true if you have removed the authenticated users from the new gpo though so make sure you that step first.

There are some slight differences from regular SQL commands I believe James, ha ha that's probably why it's so awkward to get it all working properly and why information on the internet doesn't seem to quite tally up when trying to run commands. I've included the sourcefile import command in some of my posts as it is one that is definitely different and your users will need it early on in their database creation. It is a steep learning curve to get this all setup and configured, why the exam board or course providers don't provide complete installation and configuration instructions I don't know as I'm sure most schools don't have SQL gurus working in them.

Hi James that is correct, once you connect you should get "creating a classic session to sqluser1@testserver:3306 (with "testserver" being the computer that is hosting the MySQL instance) and underneath that will say "no default schema selected" so you need to do \sql \c –c sqluser1:sqluser1@testserver:3306 show databases; (this will show just information schema) create database sqluser1; (create database) show databases; (you will now see sqluser in the list) use sqluser1; (use the sqluser1 database) show tables; (shows as an empty set) etc etc

Hi James, Cogrady84 has this part covered early on in the thread. After launching MySQL Shell, the command to connect to remote instance in sql/classic mode: \sql (This switches you to SQL classic mode) \c -c username:password@serverip:serverport (example would be \c -c user1:[email protected]:3306 ) you will probably need the command for importing a sql file into your database aswell which would be \source n:\yourfile.sql assuming your sql file is on the students n:\drive and that it is called "yourfile.sql" that is. also note that no semi-colon is required when using the source command in this instance. also have a look at the manual for sql shell commands MySQL :: MySQL 5.7 Reference Manual :: 3.8.4.1 MySQL Shell Commands

Hi again foofighterjim, I have attached an excel spreadsheet that you can use to gather the information you need to create, set password and grant permissions to your sql users. Create and set passwords by copying the data under the create user heading and pasting in the sql command line once you are logged in as root. Grant permissions by doing the same but using the grantpermissions header. You can grant permissions to a database called user1_exams by changing the grant permissions information like shown below grant select,insert,update,delete,create,drop on user1_exams.* to user1@'%'; this is how I created my users and use MySQL workbench to check they created correctly. https://www.dropbox.com/s/tmx3um9lem9xltr/CreateSQLUsers.xlsx?dl=0 [TABLE=width: 452] [TR] [TD=width: 603, bgcolor: transparent][/TD] [/TR] [/TABLE]

Hi foofighterjim, I'm sure that the problem is very likely because of the name of the database you are trying to create. When i initially set it up i could only get users to create databases that were the same as their username. i.e user1 could only create a database also called user1. I modified my file so that users could create a database called user1_exams but i don't have of that information t hand at the moment. When you are trying to modify or grant permissions you need to be logged on to the server hosting the MySQL database as root and i would use MySQL workbench to view what users and settings you have set. I will try and post some more info for you tomorrow once i'm back at work.

@ FN-GM I believe I've found the command that you need for importing the sql file into your database. \source n:\yourfile.sql assuming your sql file is on the students n:\drive and that it is called yourfile.sql that is. also note that no semi-colon is required when using the source command in this instance. link to all the commands when using the MYSQL shell is here MySQL :: MySQL 5.7 Reference Manual :: 3.8.4.1 MySQL Shell Commands Hope this helps anyone who is struggling with this.

Thanks to everyone who has contributed to this thread as I have been able to follow most of it with never having used SQL products before. I have it working where users can connect from any workstation that has MYSQL shell installed to the MYSQL server and can create their own database without seeing or having access to any other database. I am now in the same position as FN-GM and I'm unsure how to get an sql file imported when using the MYSQL shell set in SQL mode using \sql and at the MySQL-sql> prompt. I can also inport the sql file if I use the MySQL.exe file. Has anyone actually done this as I believe it will be part of the assessment for the pupils and like most other people we don't want to allow pupils access to the command prompt. @cogrady84 thank you for the instructions and screengrab as this helped tremendously, although it looks as if there is a space after the : in your original posting which threw me to start with. I will post a full guide to show how I got it all working from start to finish once I complete this and the teacher confirms it will do everything he needs for the assessment. Why the exam board can't provide a generic virtual machine with relevant scripts for schools that don't have anyone who is familiar with SQL I don't know, surely it would be a great help for most people. thanks