Install HP Color Laserjet CM1312nfi on Windows 7 or Windows 8

Installing this printer is actually quite simple if you know how to do it. It cost me some hours to figure out. The problem with the installer is that whether you choose USB or Network it fails on the step “Connecting device” or the step where you have to plugin the printer using USB. Some things i tried:

  • Every possible version of the full solution package
  • Running as administrator
  • Running in compatibility mode
  • Disable firewall and make sure host-name could be resolved.

The solution is to log in as administrator and not “run as” administrator:

  1. Right-click “Computer” and click “Manage”.
  2. Open “Local Users and Groups” -> “Users”.
  3. Double click on “Administrator” and uncheck “Account is disabled” and click OK.
  4. Right-click “Administrator” and “set password…”

Now log out and log in again with Administrator and run the setup. In my case i had the Compatibility settings set to Vista. Not sure if this is nessecary. Remember to disable the administrator account again if you are done. I have successfully installed the Solution on Windows 8 64bit. I guess this also works for Windows 7.

For printing you can also use the HP Universal Driver for network printing, but if you want to Fax and Scan via network you really need the full solution.

Posted in General, Windows | Tagged , , , , , | Leave a comment

Export blacklist and whitelist from ESVA and import to EFA

If you are migrating from ESVA to EFA you can export and import the black/whitelist with a simple script i wrote. note: This script doesn’t check for double entry’s.

  1. ssh to your ESVA server
  2. wget
  3. chmod +x
  4. ./
  5. There should be a output.sql file in the directory where you executed the script. Copy this to your EFA server. You can use scp for example: scp output.sql efaadmin@<yourEFAhost>:
  6. Now ssh to your EFA machine.
  7. Execute the following command to import the black/whitelist: mysql -u root -p`cat /etc/mysql/EFA.cnf` < output.sql
  8. All done.

By default, the black and whitelist entry’s are added under the root (id=1) account of EFA. If you want them added under another account, just change the @userid variable in the first line of output.sql. To find out the userid:

  1. Login to the EFA webinterface
  2. Go to settings -> accounts
  3. Click on the icon of the desired user
  4. The id can be found in the addressbar, for example http://<EFAhost>/accounts/user/2/. 2 is the userid.

You can get EFA here:

Posted in Linux | Tagged , | Leave a comment

SRSS 2008: An error occurred within the report server database on report deployment

When i tried to deploy a edited report, it gave me the following error:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. 

I tried this via Visual Studio 2008 and via report builder 2.0. Both with the same result. The Report builder however gave me a extra line of error:  (rsReportServerDatabaseError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors.  So i decided to turn on remote errors to see what went wrong. After some googling i found the following microsoft page. When i enabled remote errors i tried again via report builder and it gave me the following error:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> System.Data.SqlClient.SqlException: Length of LOB data (244318) to be replicated exceeds configured maximum 65536.
The statement has been terminated.

No idea what LOB data is. But i found how you can increase this value here. I executed the following 2 commands (can take a few minutes)

sp_configure ‘max text repl size’, 2147483647

After this i was be able to deploy my edited reports again 🙂

Posted in SQL Reporting Services | Tagged , , , , | 1 Comment

Regain Root access on Asus TF300T after official update

So i downloaded and installed the official update from the Asus website. After this i had no root access anymore (as expected). I found a few manuals which described to regain root access which includes to download a file of 400+ MB. There is a simpler way to regain root access:

  • Install TWRP: (use the fasboot method)
  • Boot into TWRP (hold power and volume down, select recovery using volume down and confirm with volume up)
  • Flash SuperSU (0.93-Busybox-1.20.2 in my case)
  • All done

Good Luck!

Posted in Android | Tagged , , , , | Leave a comment

OpenVPN on TF300T after Jelly Bean update

I recently updated my (rooted) Asus Transformer TF300T to the latest Android version which is Android 4.1.1 (Jelly Bean). After updating OpenVPN failed to connect with an error that looked like “ifconfig, external program fork failed”. (I can’t remember the exact error).

So i tried a number of things to make OpenVPN work again:

  • Factory reset.
  • Reinstall BusyBox at every possible location.
  • Tried different BusyBox installers.
  • Reinstall OpenVPN binaries at every possible location.

Then i found a topic where someone was having issues with superuser since he upgraded to Jelly Bean. The solution for him was to flash another version of superuser. When i flashed SuperSU to my tablet OpenVPN was be able to make a connection. I did reinstall busybox bofore trying but i am not sure if this is necessary.

Posted in Android, OpenVPN | Tagged , , , , | 1 Comment

Icarus Go (DRIGL) firmware

If you are looking for a firmware update for your Icarus Go e-reader with a DRIGLxxxxxx serial. You have to visit the following site:

Dont go to and “downloads->firmware->ICARUS GO (E600BK) FIRMWARE ” because non of those firmwares works with this version of the Icarus GO. I read somewhere that the DRIGK110000-DRIGK999999 firmware should be compatible with DRIGL devices but this is not the case! You won’t brick your e-reader but after the update the screen doesn’t work anymore. You can still reflash the reader with the correct firmware.

Posted in General | Tagged , , , | Leave a comment

Trendline with weighed average percentage from other dataset in SRSS 2008

For a report at my work (at a callcenter) I had to create a chart with a percentage of failed calls per agent per day. This chart also had to contain 1 line which represented the weighed average percentage of failed calls of all the agents. This could not be done with calculated series because the percentage would not be a weighted average.

By the way for those who don’t know what a weighted average means. Imagine you have 2 agents:
Agent 1, 2000 calls, 2% fail
Agent 2, 10 calls, 40% fail
You cannot simply add 2% and 40% and divide it by 2 (21%). The 2% failed calls of agent 1 weighs much more than the 40% failed calls of agent 2 which only did 10 calls. So to get a weighed percentage you have to add the number of total calls and the number of total fails and get a percentage of that. In this example the failed call percentage would be 2.189055%. Dataset 2 calculates the weighed percentage.

So after some trial and error I found a way to accomplish this in SRSS 2008. There are 2 datasets which output the following data:

Dataset 1: input (from date, to date, (agent 1, agent 3, agent 10))

Date Agent % of failed calls
20120701 Agent 1 1
20120701 Agent 2 4
20120701 Agent 3 2
20120702 Agent 1 0
20120702 Agent 2 5
20120702 Agent 3 2
20120703 Agent 1 1
20120703 Agent 2 7
20120703 Agent 3 2

Dataset 2: input (from date, to date)

Average % of Failed calls

Let’s presume there are 50 agents in database. Dataset 2 returns the average of all these 50 Agents.
Now we create a (line) chart (% of failed calls is called Hangup in this example):

Now to add a line which represents the average value from Dataset do the following:
– Click the + button next to Values
– Choose expression
– Type the following: =Sum(Fields!Hangup.Value, “Dataset2”)
– Click OK

It should look like this now:

So one thing has to be done:
– Right click the new created series and choose series properties
– Choose visibility and choose “Show or hide based on an expression”
– Use the following expression: =IIF(RowNumber(Nothing) = 1, False, True)
– Click ok and go to “Legend”. Here you can enter a custom legend text like “Avarage % of failed calls”
– Click ok and you’re finished!

Good luck!

Posted in SQL Reporting Services | Tagged , , , | Leave a comment

Unable to Uninstall powershell v1.0 for server 2008 upgrade

When i tried to upgrade a windows 2003 server to windows 2008 server, the installation wizard told me i had to remove powershell before i could continue with the upgrade.
– I have searched in add/remove programs to remove it
– I tried to find and remove any of the following updates: KB923845, KB943295, KB925902, KB936059, KB942841,KB926139,KB926140
But without succes. So i was going to try to upgrade powershell to v2.0 and found out that powershell v2.0 is a component of Windows Management Framework which was installed on the server. After uninstalling Windows Management Framework i was able to upgrade my server 🙂

Posted in Windows | Tagged , , , , | Leave a comment

Play Settlers 7 with more then one player on same IP/Connection

If you want to play Settlers 7 and be online (at a lanparty for example) with more than 1 player at the same time, you have to add an option to the Options.ini used by Settlers7. This file can be found in your My Documents folder:

XP: C:\Documents and Settings\YourName\My Documents\Settlers7\Options.ini
Vista\7: C:\Users\YourName\My Documents\Settlers7\Options.ini

Add the following lines to the ini File:

DefaultPort = 9205

Every player should use a different port for this to work.

Posted in Games, Windows | Tagged , , , | Leave a comment

CTRL-ALT-DEL via UltraVNC not working in Windows 7/2008(R2)

By default, send CTRL-ALT-DEL does not work on windows 7/2008 at the login screen when using UltraVNC. This can be fixed by editing a group policy:

1) “Start menu” -> “Run…” – > gpedit.msc
2) Navigate to “Computer Configuration” -> “Administrative Templates” -> “Windows Components” -> “Windows Logon Options”
3) Double-click on the “Disable or enable software Secure Attention Sequence” parameter.
4) Check “Enable”, then select “Services” in the combobox.
5) Apply the modification


Posted in Windows | 13 Comments