the_quick

Thanks guys. Unixman - that software is not using standard sql - create database or show tables command do not work at all. So can't use it. As students supposed to create databases and tables using standard SQL. Benjie - yeah, probably will try that. My another problem is that 30 students need to create database each and work on it for several weeks. Might install WAMP just on all computers in that classroom. Thanks again for ideas.

Morning guys I have been given task to provide access to mysql command line. year 10 need to do some task for controlled assessment and they need to create databases and run some queries on them. I remember doing something like this at Uni, using a terminal to linux server, but can't remember how it was done. Anyone done it? Probably can be done with putty and linux server, but not sure if giving access to putty to students is a great idea. Would you mind sharing your solutions please? Thanks Kris

Unfortunately it did not work. RM changes safety net and it will offer used based filtering, so it will cover what we do with smartcache. So for now I'm leaving it. Thanks for your help again. Kris

Thanks Pete, I will try that. Does this new routing IP have to be assigned to some device or should be free? I'm not sure I understand how smartcache is going to use this IP. Kris

Thanks to you both for your input. All ip routing addresses are gateways for each ip range, I though that what it needs. and even with your example Pete, as it is in same subnet it should work. We don't really use smartcache for any sort of filtering, we just use it to record pupils activity, what website they have visited, for that is works fine. For all blocking we still use SafetyNet - so far it worked well for us. Huge resistance here to get any more advance solution (ie smoothwall or lightspeed or similar) mainly because of costs involved. One more thing that bugs me, I can't ping smartcache from any other subnet than it's own. I guess possibility is, it can't reach gateway for some reason I might give RM a ring

HI Guys Just finished with reconfiguring network to use vlans (before just one), now I have multiple vlans for pupils PCs. The problem is that smartcache only works for the computers that are on the same vlan as smartcache box. I have change config file, but still no luck, can some one suggest anything? Below my config: 192.168.1.106 255.255.252.0 255.255.252.0 192.168.8.0 192.168.11.254 255.255.252.0 192.168.4.0 192.168.7.254 255.255.252.0 192.168.12.0 192.168.15.254 255.255.252.0 192.168.16.0 192.168.19.254 255.255.252.0 192.168.20.0 192.168.23.254 255.255.252.0 192.168.24.0 192.168.27.254 255.255.252.0 192.168.28.0 192.168.31.254 192.168.3.254 dns1 dns2 my_proxy.com 0 0 SchoolName 11111 NTP Server post.smartcache.va.ifl.net 0

Thanks all for replies, Encoder - can't use it, limit is too small CamStudio - bit bloatware, it installed additional pieces of software, without even telling me and it installed itself to appdata folder - so unless pupils will be given permissions to install software, it will not work, Arreks how did you overcome those problems? On-line version of Screencats-o-matic looks promising, just need to check if I can run it on student account

Hi Guys Just wonder if anyone uses any screen capture software. ICT students need to record their work, what they are doing on computers, can some one recommend any software? Of course free would be the best, but very often either do not work or have limitations. Thanks

Martin, what a brilliant observation. Just changed dynamic TCP/IP port in our firewall settings (as it now use some ridiculous 49xxx , instead of 1433) and now sims is around 8-10 sec to open and FMS is lighting quick at around 4 seconds. Capita still haven't figured that out and I did not until no as well. Thanks Martin

Running my on Vmware as virtual - works well, assigned 8 cores and 16GB RAM - probably overkill but now it hardly spike up to 40% of CPU usage. When we had 2 cores and 8GB it was struggling a bit. Secondary school with 1250 student and 150 staff

Mine is running on SQL 2014 standard - so full version. I don't think there Capita official fix, but changing compatibility mode to SQL 2012 works really well. When sims loads (30 seconds in my school) it is working well. To be honest I would wait with upgrade. But if you have to upgrade, I just would do it to SQL2012

So far applied on sims db. But both sims and fms take a while to load.

Still loading sims takes a bit of time. But when it's loaded everything working as it should. FMS take a long to load as well. Maybe something with the logging in process.

Arron did you see improvement straight after you did change compatibility? I can answer myself, as I just did it. I can see it is working so much better now.

Aaron Are you saying I can do this in the middle of the day without affecting users? Oh and more think, should I change to compatibility level of 2008r2? as this what we had before?

Hi Guys, I'm in exactly same position. Upgraded from SQL2008R2 to slq2014 runs really slow, take ages for register to load etc. Of course capita says they don't know about any issues and looking at our traces. But anyway, How do I change compatibility level? Is it done on database? Should we do it on both sims and fms? Thanks Kris

We did our migration from CC3 to vanilla with help from third party engineer. He did not know RM staff - and telling the truth most of them do not need to know. Just work with them, tell them what you want to achieve - good MS engineer will do just that. RM system is bloated, heavy on resources, we simplified it. Copy all users account using CSV and than just copied all home folders. Setting up folder redirection was a bit complicated process and took a day or two to test it fully. Took us a week for creating new domain users account and exchange. Than took some time to move all data. But most of the time we spent on deployment desktops. We are using 2008 R2, with WSUS, WDS and KMS server. Before we had 3 physical servers that were quite decent and we changed them to vmware hosts. We have separated lost of tasks from RM DCs - they were before DC with dhcp and dns, file servers , print servers and other functions. With virtual environment I prefer to create more small servers with separate roles. It is a summer job, lost of work but well worth it - I would never go back to RM system. First year we spent on light tuning and small changes - but from day one it worked better than RM. So in short, find a good MS engineer who knows how to setup domains. No need to know anything about RM.

same here , after using GPP and failing, we switched to script and all the problems disappeared.

Sorry to refresh such an old topic, but got similar problem. Scratch installed from MSI, home drive is N. Each time pupils or teacher try to open scratch file from documents (double click) they get windows asking for image file. If I place image file (copied from installation folder) in same folder as scratch file, it works fine. For some strange reason scratch does not use file from it's own folder. Any ideas? Below our ini file [Global] DeferUpdate=1 ShowConsole=0 DynamicConsole=0 ReduceCPUUsage=0 ReduceCPUInBackground=0 3ButtonMouse=0 1ButtonMouse=0 UseDirectSound=1 PriorityBoost=1 B3DXUsesOpenGL=1 CaseSensitiveFileMode=0 EnableAltF4Quit=0 Home=N:

Mandatory here as well. We started with roaming and it was causing few issues, mainly with logging in - the profile grew and it than took longer to load it. Or sometime it just got corrupted - really annoying. Switched to mandatory and never looked back. Ours in not tiny, around 30MB but lots of software settings embedded in it, like office, serif apps etc.

OK, found the strange issue. Firewall service was disabled, but it was still blocking any pings. Could not started it, unless I added an additional local account in registry key HKLM/System/CurrentControlSet/Services/SharedAccess. The account I have added was mpssvc. And than firewall service would start and computer is back to normal. I checked other computers, including mine and such account is not added to this key, so it should not be needed. Need to check other services that depends on it like BFE and IPSec maybe solution is there. Just need to find out what knocked down firewall in first place. Thanks for suggestions guys

Ping was enabled (Firewall settings) by GPO. All other computers in school work as intended, I have not put anything new on them, just weird. I know nothing just happens, some one must have done something. Need to find a source. Really strange. Will check firewall over lunch time.

Will try with disabling firewall. Yeah, machine in question works fine, pinging etc, just not to them.

Hi Guys Maybe someone can shed some light on our strange issue. Today morning all computers in one classroom decided to be pinged. Can't ping them from any computers, including servers. Tried to fix it with cleaning dhcp and dns records - nothing. They do appear on network search, but can't ping them. They do not appear on Lanschool either. But if you login on those computers , they seem to be fine, no problems with browsing network and internet. Windows firewall is sett to allow pings through and everywhere else is fine, just this one classroom. Teachers computer there is fine. Checked switches, all good. Not sure where could lie the problem. Next thing to try, will rebuild one PC and see. Thanks in advance

Hello guys and gals We have here RM Smartcache and it does exactly what we need. But it is not reliable any more. We just need to see a history or visited websites by students. No need for live monitoring. Probably most of you would say smoothwall or lightspeed. I know of those product but they are quite costly and have much more features, which not necessarily we would use. So looking for some really simple solution and not to pricey, does such thing exists? Thanks in advance Kris