Scenario: I want to move vCenter DB from the bundled SQL 2005 express to a standalone SQL 2008. The SQL Native Client required for the upgrade is 10.0 To check what version you have running (on SQL 2005): Run regedit -> Computer->HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Native Client/Current Version. As you see from the screenshot I Read More…
The SSL password dilemma when starting Apache
OS: Linux Software: Apache 2.x Dilemma: You have set a passphrase on your SSL certificate. Upon starting Apache the default behaviour is interactively type the password in. This obviously has an impact on boot and when you need to automatically restart Apache. If this doesn’t fit your model then there are 2 options: 1) Remove the Read More…
How to disable SELinux.
OS: Centos 6 Whenever something isnt working properly – its normally due to SELinux ! One example I recently had was when I tried to simply FTP to a newly created internal server. After having a quick look over the vsftpd config I swiftly moved onto my next suspect: SELinux. Before I show you how Read More…
How much bandwidth does Netflix use?
I was curious as to how much bandwidth Netflix uses when watching a movie. I decided to monitor this by watching Warrior starring Tom Hardy and Joel Edgerton. Runtime was 2:19 hrs. My 21CN broadband connections sync rate is ~6Mbps. Using my PS3 plugged directly into a Sonicwall TZ 210 I SNMP monitored the port Read More…
There isn’t enough disk space or memory when trying to update a table
OS: Windows 7 Software: MS Access 2003 When trying to change the column in MS Accees 2003 from Currency to Number we received the error : “There isn’t enough disk space or memory” Looking in the table there are 350, 000 records – which makes sense. To fix this we need to edit the registry. Go Read More…
VMware : Check new notifications are queued
Software: Vcenter 5.0 All your “Check new notifications” are queued when viewing via your client. This is very easy to fix. Log into your vCenter server. Go to Services and then restart the “VMware vSphere Update Manager Service”
MS Access displaying NULL values in currency column after upsizing to SQL 2008
Software: MS Access 2003 / MS SQL 2008 After upsizing a database, a currency column in a particular table was completely empty via the Access application. However, when viewing the table in SQL 2008, the values are present in “money” format. Suggested workarounds didn’t really fit for us (eg changing the workstations to English US Read More…
Connecting to a share on Linux via Windows 2003 (SP1) NFS Client
Scenario: We have an NFS share on a Centos 6.x server – which other Linux machines use for a data repository. A requirement arose in the network to use a Windows 2003 to server to connect to this share. I believe Windows 2003 SP2 and 2008+ all ship with the NFS Client (although you may Read More…
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL server table that has an IDENTITY column
We just upgraded an internal MS Access 2003 DB to use MS SQL 2008 (in linked server table format) and immediately got the error listed in the title (and pictured below) The debug option gave the following line as the problem: Set rs = db.OpenRecordset(sql) I tried Set rs = db.OpenRecordset(sql, dbSeeChanges) but just Read More…
Setting up a daily cron job to mysqldump
Here is a a little life saver to dump a MySQL DB via cron and zip it up in date format 0 2 * * * root mysqldump -u root -pPASSWORD databasename | gzip > /tmp/DBBACKUPS/database_`date ‘+%Y-%m-%d’`.sql.gz This runs at 2am every morning. You can then set up another cron to delete old files or use logrotate to save Read More…
You must be logged in to post a comment.