-
Posts
3,659 -
Joined
-
Last visited
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by jinnantonnixx
-
Create redundancy for our SQL server?
jinnantonnixx replied to reggiep's topic in Windows Server 2008 R2
There are various options, but we use log shipping. The logs of our live databases are backed up, copied and restored to a standby server. It's easy to set up one or two using the wizard, but for a hundred I had to write scripts. It works well, we have used it after a failure and the failover time for (from memory, about 10 SIMS databases) was about 15 minutes to get it up and running on the secondary server. About Log Shipping (SQL Server) Another option is database mirroring. http://msdn.microsoft.com/en-gb/library/ms189852.aspx -
I use Sqlteman (on Ubuntu) to 'administer' the database, but in reality there's really nothing to administer. Sqliteman is great for quickly developing queries. It's got a few goodies too - it can populate tables with as many dummy records as you want - this is handy for testing. It's a huge dilemma trying to pick a language. I was into .net. That's fine if you're a Microsoft shop, but I see a tide of Linux systems heading our way. I looked at Python and I see it to be a universal language with fantastically powerful list processing capabilities. My Python apps are developed on Ubuntu and they happily run on Windows. Cross-platform - this is a huge plus. I always make sure I stick to the stock 2.7.
-
It's the bees knees, I tells ya. Why LISP? Strange choice. Though I shouldn't judge; last time I used it was in uni, and I didn't really have a practical use for it. Saying that, I use a dictionary in Python to hold my data structure, then commit the dictionary keys by their keyname to the SQLite record. It's so simple, it's hard to believe. Python is awesome .I've done a fair bit with dotnet and MS SQL over the years, but this is like a breath of fresh air.
-
Initial tests are very promising. From a 2 gigabyte JSON source file, I've distilled the columns I need into an SQLite database. Now, on the resulting SQLite database, I can do a fairly complex query using wildcard text searches, multiple conditions and sorting on the database (which contains over 1 million records) and the results come back in less than 1 second. Very, very impressive. Well done, SQLite. http://www.pythoncentral.io/introduction-to-sqlite-in-python/
-
At least my favourite colour and my first pet's name isn't on the list. Not much they can do without that.
-
I've been doing a project in Python and realised that I'd be better off using a small, simple database instead of the JSON files I'd been using. It had never occurred to me to use SQLite, but looking a little closer it seems to be a really nice, simple database. Zero configuration, no faffing about. Great for simple apps. It even has a front-end (SQLiteman) in Ubuntu. More importantly, its binding are baked into Python. I found a really nice website with some good examples of Python and Sqlite. SQLite Python tutorial
-
Is this the phone I am looking for?
jinnantonnixx replied to box_l's topic in Mobile Devices & Tablets
My wallet's shut for the moment, but I've got my beady on a Moto G - are these better phones? -
Try it and see. It's the only way. Don't fret about possible black-spots. Try it where you spend most of your time, and if it's OK then it'll be fine.
-
[video] Kids react to: Old Computers
jinnantonnixx replied to computer_expert's topic in Jokes/Interweb Things
Rather crass. Come on kids, get the 6502 assembler running. When I was your age I was DJNZ'ing my B registers like there was no tomorrow. Of course, that was on the Z80. Kids these days. Bah! -
Just been enjoying the music on blinkbox and thought I'd let you guys know about it. It works like a curated music station; search for something you like and it creates a 'music station' with a similar music style. Remember to like/dislike songs that float/sink your boat and it will make excellent suggestions for you. I've found some great tracks here. An important difference from other services is that the mobile app allows you to download the stations to your phone using wi-fi for off-line listening. Handy if you have a small data plan or bad signal. And it's free! Anyway, see what you think. Free Music Online | blinkbox music
-
I'd check the server RADIUS logs. If your're using a Windows server, the RADUS logs are not human readable, they'll need de-coding with a third-party log file viewer. I had a problem years ago with Cisco Airnets and the Radius logs shed light on the problem.
-
You should be OK just letting DNS sort itself out. I've seen pickles where we have strange routing over multiple sites. Have you got a single site (under AD sites and services)? It's been a while since I got deep into DNS, but I think it works like this: Client pings each of the DCs it finds in _msdcs/dc/_tcp If it gets a reply it will look up in (by IP) under AD's sites and services and find the site of DC, and hence the site it belongs to It will then bind to that DC (under _sites//_tcp) and this will be its domain controller for that session.
-
This looks useful - see if it helps Creating Kerberos Keytab Files Compatible with Active Directory ~ ITAdminTools.com The default location is /etc/krb5.keytab
-
Could be. Don't rely on 'locate' - it reads a database which it normally updates once a day. Locate is handy for finding static files, but it isn't dynamic. Use 'find' instead. Normally, the krb5.keytab file is created when you run mstkutil and all you have to worry about is setting the permissions. You can make it manually, but what you've done already should work. You ARE running msktutli under sudo aren’t you? Look for it in /etc/. Is it there?
-
Did you delete the kerberos tickets on the Debian server before starting over with msktutil? rm /etc/squid/HTTP.keytab rm /etc/krb5.keytab This is important at the new tickets might be appended to the file and missed. Then Delete the kerberos account for the computer. Wait for replication Then kinit Administrator Then the msktutil...... with the --dont-expire-password --enctypes 28 parameters. Wait for replication (wait for the computer account to appear on all controllers) Set permissions on the file /etc/squid/HTTP.keytab with the commands: chmod 660 /etc/squid/HTTP.keytab chown squid:squid /etc/squid/HTTP.keytab Reboot the Debian server
-
[news] Well, who'd have thought it?
jinnantonnixx replied to creese's topic in Jokes/Interweb Things
Reminds me of Fritz Lang's Metropolis. -
I'm a amazed I haven't had a flurry of 'change your ebay password' scam emails, pointing to superscamsite.com/hc3/flakysite/icantbelivetheyclickthis.php
-
I did not expect this when I got home last night.....
jinnantonnixx replied to Iain.Faulkner's topic in General Chat
Absolutely. Image you had badgers in your garden! I can't tell if you have goalposts in your garden, but it's a sure bet they would have been moved. -
Install kerbtray (it's in one of the Windows resource kits - PITA to find) and stick it on one of the client windows machines. It'll appear in the system tray (bottom right), use it to view the Kerberos tickets on the machine. Then use it to delete all Kerberos tickets Close the browser and reopen it, and see if you get any fresh tickets from the Squid server. Foudn a link http://www.computerperformance.co.uk/Litmus/tools_ezine.htm#Kerbtray
-
I did not expect this when I got home last night.....
jinnantonnixx replied to Iain.Faulkner's topic in General Chat
What would Bart Simpson say in this situation.... 'Eat my shorts?' -
I did not expect this when I got home last night.....
jinnantonnixx replied to Iain.Faulkner's topic in General Chat
You'll write off 500 quid? Are you serious? Small claims court!!!! http://www.inbrief.co.uk/animal-law/liability-livestock-trespass-nuisance-animals-act-1971.htm -
I did not expect this when I got home last night.....
jinnantonnixx replied to Iain.Faulkner's topic in General Chat
Ah, ever the bastions of logic. -
I did not expect this when I got home last night.....
jinnantonnixx replied to Iain.Faulkner's topic in General Chat
... but... somehow.... now own the cows? But remain shy when asked to stump up for the damage? Am I near the mark? -
Progress! Of sorts, anyway. I would definitely delete the AD computer account, and tomorrow re-run the msktutil with the additional parameters I mentioned. Don't forget to delete the keytab files rm /etc/squid/HTTP.keytab rm /etc/krb5.keytab then run 'kinit Administrator' before attempting the msktutil. Then set the keytab permissions chmod 660 /etc/squid/HTTP.keytab chown squid:squid /etc/squid/HTTP.keytab List the Kerberos tickets with the command klist -ekt If you get a failure after the inital msktutil, don't despair - try this a few times msktutil --auto-update --verbose If that fails, then despair. If it still doesn't work, change your squid.conf so that the NTLM auth directive appears above the Kerberos directive (or even comment the Kerberos line out with a '#'). NTLM isn't a pretty authenticator, but if it works it will buy you time.
