MySQL connections failures and timeouts, part 2
Seems like Surftown got the problems fixed without moving my database to another server.
Seems like Surftown got the problems fixed without moving my database to another server.
So there seems to be some problems with the MySQL database server at Surftown where my sites are hosted. Surftown have informed me that they will move my database to another server, so there will be some downtime while pointers are updated across the DNS servers, when they have moved it.
Playing around with a new theme, so several items will probably be missing or otherwise not working, until I have fixed it.
I recently installed Ubuntu on my Dell Studio 17, dualbooting Windows 7 and I wanted to make windows 7 the default boot. I did this by changing the “default=0″ setting in “/etc/default/grub” to “default=4″, then running “update-grub”. This basically tells GRUB to use menu-entry number 5 (0, 1, 2, 3, 4) as the default boot option. Since Ubuntu by default have 2 Linux kernels (regular and recovery) as well as 2 Memtest, this would select Windows 7.
A little while later I upgraded several applications in Ubuntu as well as the kernel. Updating the kernel added 2 extra menu-entries to GRUB, which t hen meant that menu-entry 5 (“default=4″) would be one of the 2 Memtest entries. This would mean I actually had to update GRUB manually every time I upgraded kernels? Nah, I didn’t want that. The way I did this was rather simple.
First I ensured that the “default” setting in “/etc/grub/default” were set to “0″ (“default=0″) which is first menu-entry. Second I renamed “/etc/grub.d/30_os-loader” to “/etc/grub.d/09_os-loader”. If you notice there are several numbered files in “/etc/grub.d”. These determines the order of selection (or rather order of compilation) when running the “update-grub” command. By putting the “os-loader” entry below the “linux” entry it puts Windows 7 before the Linux entries in the GRUB menu.
First… ArkInventory rules/pwns/is awesome etc.
Aah… I just had to get that one out there, now on to the “rules” part
ArkInventory is a a bag replacement for World of Warcraft which gives you a massive amount of options to sort and order the contents of your bags and bank. The way ArkInventory does this is by splitting the bags into sections according to the users desire. For example have a section with all your tradeskill items, another for all your trash etc.
ArkInventory is plenty as is for most people just using categories. Using rules makes it even greater. With rules it is possible to specify multiple criteria for how the sections should handle items. Here ar my favorite rules.
Managed Equipment – This rule will create a section where all equipment, which is part of an equipment set (be that Outfitter or Blizzards own Equipment Manager):
Soulbound Equipment, unmanaged – This rule keeps track of all the gear that are no part of an equipment set:
Idols – I’m a druid so this is to keep all my collected idols nice and orderly:
Trinkets – This handles your trinkets:
Tabards – With Wrath of the Lich King tabards actually became useful. This rule will give you control of them:
Tradeskill Tools – Keep track of that Pick, Skinning Knife, Enchanting Rod etc.:
Spell Power and MP5 – This keeps track of all the items that have Spell Power or MP5. Similar approach can be used for other stats:
So I’ve more or less switched to using only Google Apps‘ Webmail (Gmail with your own domain), making Thunderbird obsolete. To that end I’ve been trying to find a way to make mailto links launch my Google Apps composer window rather than the default Gmail composer window, and also how to make Gmail start by default in https (secure) mode rather than http (plain) mode.
In my search I’ve stumbled upon several resources, most pointing to using GreaseMonkey and a small script that re-writes all mailto links, another resource pointing to Gmail Manager saying it could handle Google Hosted Accounts (aka. Google Apps accounts), as well as some sites that explains how you fix the Gmail button for Google Toolbar to launch Gmail as https by default.
Of the resources pointed out in regards to the mailto handling, I found several GreaseMonkey scripts that did this job very well, although I didn’t really relish the idea of having that addon installed merely because I needed 1 script to handle mailto links, so I decided to try Gmail Manager instead
Gmail Manager was very easy to set up to handle Google Apps accounts in regards to checking e-mails, opening inbox and a few other minor things. All I had to do was type in my e-mail address and my password. Gmail Manager also handles mailto links, at least it opens my inbox when clicking a mailto link, but that isn’t enough for me, I want it to open the actual compose window. I decided it probably just was some hidden configuration option so I decided to muck around a bit in about:config, and behold: There I found “google.toolbar.mailto.providers.Gmail”, which contained the URL that Google Toolbar uses to open the composer window, when clicking mailto links.
So basically, all I had to do from the start was this:
Edit the Gmail button to open the Google Apps account instead of the Gmail account, and in https rather than http
To:
Change:
To:
Change:
To:
(Note: Replace MYDOMAIN.TLD with your own domain)
Thanks to Stefano Savanelli for his comment referring to this following link where you can add a Google Apps e-mail button:
http://code.google.com/p/gtb-gmail-apps-button/
Now the Gmail button is fixed, now to make Google Toolbar send e-mail using the Google Apps account:
To:
(Note: Replace MYDOMAIN.TLD with your own domain)
By adding the “&tf=1” variable to the URL the composer window will open “full screen”, without the folder list to the left and the search bar at the top.
There.. Now we have made Google Toolbar handle all aspects of our Google Apps account
So I got tired of Servage being slow as hell so I moved back to Surftown, best host for cheap amount of cash I’ve found.
There might still be a few quirks, most likely related to permissions, that I need to find and work out. If you find any, feel free to comment on them in this post
I got the urge the other day to watch some Star Trek: The Next Generation series, unfortunately for me I didn’t have the series around here so I accidentally ordered the entire series. That’s 7 seasons and a total cost of 2332 SEK at www.DVD.se. Now I’m just waiting for them to arrive so I can satisfy my urges
It’s so bothersome all the comment spam that occurs on blogs all around, a common denominator is that they (almost) always contain links. For this very reason I’m now blocking/blacklisting ALL comments that contain a web address.
I recently switched host from Surftown.dk to Servage.net, mostly just to check Servage out, but also because I know the owner and one of the admins.
So far I must say I’m a bit disappointed. The administration panel isn’t as intuitive as the one I used at Surftown, but I guess I can live with it, most of the functions I had at Surftown, and lacks here at Servage, were functions I didn’t really use. Servage seems to have problems with responsiveness quite often, can’t pinpoint any specific times, it’s in periods, usually after I’ve done a lot of SQL queries, which makes me think they’re a bit too restrictive on the number of MySQL connections they allow. — Time will tell how well Servage fares, my needs aren’t big so I doubt I’ll have any great concerns.
While moving hosts I also upgrade to the latest WordPress, and made a lot of changes:
Instead of my own gallery page I decided to go with NextGEN Gallery. Has a lot of nice features, however compared to my own gallery it’s very very cumbersome to maintain. My own were just “upload files to a folder”, then the script would handle the rest the next time that folder would be browsed. The pagination, ability to add descriptions and the “effects” that comes with NGG, and also the fact that I rarely upload any pictures, makes it good for me. Made a small change though, had to make NGG add margin-top to every thumbnail, so that it would align properly within its container.
Codebin have been removed, instead I’ll just make a regular blog entry in the Code category, when adding new snippets of code. Again it’s not as easy to administrate as my previous one, but easier to maintain WordPress with updates, backups etc. A thing that bothers me hugely, is that when editing one of these code blogs, the formatting (indentation, special characters etc.) are completely screwed up due to WordPress’ handling of the text-fields, or some such.
Aah, and then I dropped my own theme, mostly because there were some quirks with the CSS that I simply couldn’t figure out, so I decided to drop it entirely. Instead I’m using a pre-made theme, which I’m modifying a bit to suit my taste and needs. Only few changes have been necessary though, mostly to the sidebar.