Tuesday, March 07, 2017

Bad Company Gaming Community - Domination Takistan. Some secrets revealed.

The Bad Company Gaming Community has a public Arma 2 server running Domination Takistan.

Here are some tricks to make life easier in sunny rebel infested Takistan

  • Second primary weapon: Pick up a gun with full ammo and switch it to backpack.(With scroll mouse.) Now you can pick up a second primary gun with full ammo.
  • Unlimited ammo for your primary guns: Switch between guns and all clips that where
    not completely empty are full 
    again. (This gives you unlimited ammo.)
  • C130J flyable by all: You don't have to be a pilot to fly the C130J. If you get into the back of the plane you can sneak into the pilot seat and off you go.
  • C130J Gunship: Load a tank (Tusk/Boomer) into the C130J (Fortress 1) with the turret sideways.
    Now the gunner can hammer the target from the air if the C130J circles the AO.
  • Gun-laser: During night with the night-vision on you can turn on your gun-laser with L and
    use the beam to communicate with friendlies. Not all guns have a laser, try them all.
  • Tube and backpack filled with rockets: If you first pick a tube with rockets and then a
    backpack it will work and you can use them both.
  • Far vision (Up to 10K): Hold the space button and scroll mouse to select communication.
    Here you can increase the view distance from 1 to 10 kilometers. 
  • Set a viewpoint: Go to the map with M. Click on the map, Don't move the mouse and press/hold left-shift then right-click on the map. (If you are in group channel your group members will also see the marker.)
  • Swimming erases all your gear: If you go for a swim you loose all your guns, ammo, tubes, backpack and even your night-vision and binoculars. But you can switch to your second primary gun. (If you acquired one.)
  • Everybody can use stinger and strela AA rockets: Strela rockets are less vulnerable to countermeasures than stingers. Best used against slow flying choppers.

Thursday, November 03, 2016

Some tips and tricks for the Kenwood TS-590S

  • If you need very low TX output for modes like WSPR you can use the  DRV output. Push the DRV button and for TX the DRV output will be used and that is about 1 mW depending on the TX power setting. For RX the normal antenna will be used.
  • Listening to AM broadcast stations you can set the bandwidth control up to 5 kHz wide but beware this is per sideband so in AM the bandwidth is actually twice that wide. Normally a broadcast in AM is 9 kHz wide so the 10 kHz available is more than enough.
  • The option to buy a TXCO from Kenwood is expensive. A cheap chinese TCXO works perfect too and only costs about 12 euro. Search for them on eBay or AliExpress.
    Cheap chinese TCXO

Monday, October 24, 2016

Radio Batavia taken off the air by the navy (With audio)

Every now and then I scan the airwaves with my Kenwood TS-590S for some chill music and this last sunday I stumbled upon 5890 kHz AM where radio Batavia was playing its oldie tunes.

The DJ was a dutchmen telling us he was transmitting from his big ship on a very harsh North Sea.
Just after explaining how proud he was of his new huge antenna system that reached the whole of Europe, (and it has to be big on 5890 kHz!) he reported an unknown ship on the horizon.
Binoculars scanned the horizon revealing it was the navy and it headed their way fast. A radio contact with the approaching ship confirmed the navy was coming their way to board the ship.
A light panic became audible in his voice.

I started the recording at that moment.

Radio Batavia taken off the air (recording).

After a while the music stopped , the DJ stated he would be back in the future and the signal was off the air.

The airwaves are as exciting as ever.

Sunday, October 23, 2016

How to expand the transmit frequencies on a Kenwood TM-D710GE (aka Mars cap)

The Kenwood TM-D710GE originally comes with a large receive range of 118 MHz all the way up to 1300 MHz. (Interrupted from 524 MHz to 800 MHz) It has a small transmit range of 144 to 146 MHz and 430 to 440 MHz.
To expand the transmit range from 136 to 174 MHz and from 400 to 470 MHz you will have to turn off the radio, then open the set with 8 screws and remove the resistor labeled W601.
With the front of the radio facing you it is on the lower left hand corner. Closest to the control head on the left hand side of the radio.

The green wire in older radios
In the popular youtube videos doing this mod on older versions of the radio this is a green wire.

After removing the resistor and turning the transceiver on it will reset to the default settings so it is a good idea to save all settings and memory banks beforehand to a file. This can be done with both MCP-6A or CHIRP.

Here are some more hints and tricks concerning this radio.

Tuesday, September 08, 2015

How to search for % in a string in Cognos Report Studio

If you need to search in a report for % it will not work. The % character is reserved in SQL.

The solution is to use \% (Backslash Percentage)

Thursday, July 02, 2015

Kenwood TM-D710GE hints and tricks


The Kenwood TM-D710GE has a GPS built inside the head so you can put an APRS beacon on the air without the wire hassle.
The internal GPS  has to be turned on with the GPS button after which the iGPS icon appears. Here are some hints and tricks that are not in the manual.
  • After the GPS searches for satellites, finds a few of them and gets a lock/fix the iGPS icon will start to blink.
    Mostly on other hardware this is shown the opposite way and the icon starts to blink if a fix is needed. So keep in mind, blinking is good as it shows the internal GPS has a lock/fix.
  • The internal GPS placed in front of the hand brake has a very good reception as it even keeps tracking inside my garage outfitted with only a small roof window. Its summer here so the car has no roof.
  • The rig shows GPS coordinates in minutes or degrees but also shows a very useful Maidenhead locator. After the GPS has a fix and the iGPS icon is blinking press the POS button and the Maidenhead locator is on the bottom line. Navigate trough the pages with the arrow keys.

Other hints and tricks

  •  If you leave the head in the sun the display will turn black. If it cools down it will turn normal again.
  • Note that the problem with the ceramic filter in the 2nd IF stage that is present in older versions of this radio has been solved by Kenwood in this Kenwood TM-D710GE. 
  • The transmit frequency range of this radio can be expanded by removing resistor W601 as described here.
  • Don't forget to check out if there are firmware updates that give extra fun. The latest panel firmware update increases the amount of rigs shown in the APRS list.

Saturday, June 20, 2015

How to click on a DX call in a cluster and set your rig to the correct frequency in Ubuntu.

I have Hamradio Deluxe working under WINE on Ubuntu but realized I only used the DX-cluster. I found Xdx that has exactly the same functionality and works native on Ubuntu.

Xdx is a Linux DX-cluster client. It features the possibility to click on a DX entity in the cluster where Xdx automatically changes the frequency of your rig to the stations location on the band.
It is installable from the Ubuntu Software Center where it has the option to install the rig control software in one go.
or open a terminal and type: sudo apt-get install xdx

Connecting to the DX-cluster server.

After starting the program you will have to set the URL and port of a DX-cluster server.
To get a list of DX-cluster servers check: http://www.ng3k.com/misc/cluster.html 
or http://www.iw5edi.com/ham-radio/?dx-cluster-telnet-links,65

My local DX-cluster server
After connecting with the DX-cluster server there is a welcome text in the bottom part of your screen.  It is called the terminal screen and you can send several useful commands to the server:

reject/spot 1 on hf/cw      Do not show spots on HF with CW.
reject/spot 2 on vhf          Do not show spots on VHF. (second rule)
accept/spot on hf/ssb      Only show spots on HF in SSB.
show/bands                       Show what bands are available for filtering etc.
show/filter                         Show the filters that are set.
apropos buddy                  Show any help info on the buddy command

You can check who is connected to the server and chat with them.

who                                  Show connected users. (To check if someone is DXing.)
talk callsign blah           Send blah to a connected user with callsign.

Just like in a packet BBS you can list, read and send messages worldwide to all servers in the cluster.

directory                       Show a list of public messages. (Like in a BBS.)
read 25                         Read a message with number 25 in the directory list.

Xdx screen-shot, click to enlarge

Connecting Xdx to your transceiver.

Go to Setting > preferences.

Check out the number of your rig with rigctl.   Type in terminal: rigctl -l

This is the current list:
 Rig #  Mfg                    Model                   Version         Status
     1  Hamlib                 Dummy                   0.5             Beta
     2  Hamlib                 NET rigctl              0.3             Beta
   101  Yaesu                  FT-847                  0.5             Beta
   103  Yaesu                  FT-1000D                0.0.6           Alpha
   104  Yaesu                  MARK-V FT-1000MP        0.0.5           Alpha
   105  Yaesu                  FT-747GX                0.4.1           Beta
   106  Yaesu                  FT-757GX                0.4.1           Beta
   107  Yaesu                  FT-757GXII              0.4             Stable
   109  Yaesu                  FT-767GX                1.0             Stable
   110  Yaesu                  FT-736R                 0.3             Stable
   111  Yaesu                  FT-840                  0.1             Untested
   113  Yaesu                  FT-900                  0.1             Untested
   114  Yaesu                  FT-920                  2010-08-23      Stable
   115  Yaesu                  FT-890                  0.1             Stable
   116  Yaesu                  FT-990                  0.2.1           Alpha
   117  Yaesu                  FRG-100                 0.4             Beta
   118  Yaesu                  FRG-9600                0.2             Untested
   119  Yaesu                  FRG-8800                0.2             Untested
   120  Yaesu                  FT-817                  0.5.1           Beta
   121  Yaesu                  FT-100                  0.4.1           Beta
   122  Yaesu                  FT-857                  0.4             Beta
   123  Yaesu                  FT-897                  0.3.3           Beta
   124  Yaesu                  FT-1000MP               0.1.1           Beta
   125  Yaesu                  MARK-V Field FT-1000MP  0.0.5           Alpha
   126  Yaesu                  VR-5000                 0.2             Alpha
   127  Yaesu                  FT-450                  0.22.1          Beta
   128  Yaesu                  FT-950                  0.22.2          Stable
   129  Yaesu                  FT-2000                 0.22.1          Stable
   130  Yaesu                  FTDX-9000               0.22.1          Untested
   131  Yaesu                  FT-980                  0.1             Alpha
   132  Yaesu                  FT-DX5000               0.22            Alpha
   133  Vertex Standard        VX-1700                 1.1             Alpha
   201  Kenwood                TS-50S                  0.8             Untested
   202  Kenwood                TS-440               Alpha
   203  Kenwood                TS-450S                 0.8.1           Beta
   204  Kenwood                TS-570D                 0.8.2           Stable
   205  Kenwood                TS-690S                 0.8.1           Beta
   206  Kenwood                TS-711               Untested
   207  Kenwood                TS-790                  0.8.2           Alpha
   208  Kenwood                TS-811               Untested
   209  Kenwood                TS-850                  0.8.1           Beta
   210  Kenwood                TS-870S                 0.8.0           Beta
   211  Kenwood                TS-940S              Alpha
   213  Kenwood                TS-950SDX               0.8             Beta
   214  Kenwood                TS-2000                 0.8.4           Beta
   215  Kenwood                R-5000                  0.6.1           Alpha
   216  Kenwood                TS-570S                 0.8.1           Stable
   217  Kenwood                TH-D7A                  0.5             Alpha
   219  Kenwood                TH-F6A                  0.5             Beta
   220  Kenwood                TH-F7E                  0.5.1           Beta
   221  Elecraft               K2                      20120615        Beta
   222  Kenwood                TS-930                  0.8             Untested
   223  Kenwood                TH-G71                  0.5             Beta
   224  Kenwood                TS-680S                 0.8.1           Beta
   225  Kenwood                TS-140S                 0.8.1           Beta
   226  Kenwood                TM-D700                 0.5             Beta
   227  Kenwood                TM-V7                   0.5             Beta
   228  Kenwood                TS-480                  0.8.5           Untested
   229  Elecraft               K3/KX3                  20120615        Beta
   230  Kenwood                TRC-80                  0.8             Alpha
   231  Kenwood                TS-590S                 0.8.1           Beta
   232  SigFox                 Transfox                20111223        Alpha
   233  Kenwood                TH-D72A                 0.5.1           Alpha
   234  Kenwood                TM-D710                 0.5             Untested
   302  Icom                   IC-1275                 0.7             Beta
   303  Icom                   IC-271                  0.7             Untested
   304  Icom                   IC-275                  0.7.1           Beta
   306  Icom                   IC-471                  0.7             Untested
   307  Icom                   IC-475                  0.7.1           Beta
   309  Icom                   IC-706                  0.7.1           Untested
   310  Icom                   IC-706MkII              0.7.1           Untested
   311  Icom                   IC-706MkIIG             0.7.2           Stable
   312  Icom                   IC-707                  0.7             Untested
   313  Icom                   IC-718                  0.7.1           Beta
   314  Icom                   IC-725                  0.7.1           Stable
   315  Icom                   IC-726                  0.7             Stable
   316  Icom                   IC-728                  0.7             Untested
   319  Icom                   IC-735                  0.7.1           Beta
   320  Icom                   IC-736                  0.7             Untested
   321  Icom                   IC-737                  0.7             Untested
   322  Icom                   IC-738                  0.7             Untested
   323  Icom                   IC-746                  0.7.1           Beta
   324  Icom                   IC-751                  0.7.1           Beta
   326  Icom                   IC-756                  0.7.1           Alpha
   327  Icom                   IC-756PRO               0.7             Untested
   328  Icom                   IC-761                  0.7.1           Stable
   329  Icom                   IC-765                  0.7             Stable
   330  Icom                   IC-775                  0.7.1           Untested
   331  Icom                   IC-781                  0.7.1           Untested
   332  Icom                   IC-820H                 0.7             Alpha
   334  Icom                   IC-821H                 0.7             Alpha
   335  Icom                   IC-970                  0.7             Untested
   336  Icom                   IC-R10                  0.7             Untested
   337  Icom                   IC-R71                  0.7             Untested
   338  Icom                   IC-R72                  0.7             Untested
   339  Icom                   IC-R75                  0.7             Beta
   340  Icom                   IC-R7000                0.7.0           Alpha
   341  Icom                   IC-R7100                0.7.0           Untested
   342  Icom                   ICR-8500                0.7.1           Beta
   343  Icom                   IC-R9000                0.7.1           Alpha
   344  Icom                   IC-910                  0.7.1           Beta
   345  Icom                   IC-78                   0.7             Untested
   346  Icom                   IC-746PRO               0.7             Stable
   347  Icom                   IC-756PROII             0.7             Alpha
   351  Ten-Tec                Omni VI Plus            0.2             Beta
   352  Optoelectronics        OptoScan535             0.3             Beta
   353  Optoelectronics        OptoScan456             0.3             Beta
   354  Icom                   IC ID-1                 0.7             Untested
   355  Icom                   IC-703                  0.7             Untested
   356  Icom                   IC-7800                 0.7.2           Untested
   357  Icom                   IC-756PROIII            0.7.1           Beta
   358  Icom                   IC-R20                  0.7             Untested
   360  Icom                   IC-7000                 0.7.2           Beta
   361  Icom                   IC-7200                 0.7             Beta
   362  Icom                   IC-7700                 0.7.1           Stable
   363  Icom                   IC-7600                 0.7             Beta
   364  Ten-Tec                Delta II                0.1             Untested
   365  Icom                   IC-92D                  0.7             Untested
   366  Icom                   IC-R9500                0.7.1           Untested
   367  Icom                   IC-7410                 0.7             Untested
   368  Icom                   IC-9100                 0.7             Untested
   369  Icom                   IC-RX7                  0.7             Untested
   401  Icom                   IC-PCR1000              0.8             Beta
   402  Icom                   IC-PCR100               0.8             Beta
   403  Icom                   IC-PCR1500              0.8             Beta
   404  Icom                   IC-PCR2500              0.8             Beta
   501  AOR                    AR8200                  0.6.1           Alpha
   502  AOR                    AR8000                  0.6.1           Beta
   503  AOR                    AR7030                  0.4.1           Beta
   504  AOR                    AR5000                  0.6.1           Beta
   505  AOR                    AR3030                  0.4             Untested
   506  AOR                    AR3000A                 0.5             Beta
   508  AOR                    AR2700                  0.6             Untested
   513  AOR                    AR8600                  0.6.1           Beta
   514  AOR                    AR5000A                 0.6             Alpha
   515  AOR                    AR7030 Plus             0.1             Beta
   516  AOR                    SR2200                  0.1             Beta
   605  JRC                    NRD-525                 0.1             Alpha
   606  JRC                    NRD-535D                0.6             Stable
   607  JRC                    NRD-545 DSP             0.6             Beta
   801  Uniden                 BC780xlt                0.3             Untested
   802  Uniden                 BC245xlt                0.3             Untested
   803  Uniden                 BC895xlt                0.3             Untested
   804  Radio Shack            PRO-2052                0.3             Untested
   806  Uniden                 BC250D                  0.3             Untested
   810  Uniden                 BCD-396T                0.3             Alpha
   811  Uniden                 BCD-996T                0.3             Alpha
   812  Uniden                 BC898T                  0.3             Untested
   902  Drake                  R-8A                    0.5.1           Beta
   903  Drake                  R-8B                    0.5             Untested
  1004  Lowe                   HF-235                  0.3             Alpha
  1103  Racal                  RA6790/GM               0.1             Untested
  1105  Racal                  RA3702                  0.1             Alpha
  1204  Watkins-Johnson        WJ-8888                 0.2             Untested
  1402  Skanti                 TRP8000                 0.2             Untested
  1404  Skanti                 TRP 8255 S R            0.1             Untested
  1501  Winradio               WR-1000                 0.6             Untested
  1502  Winradio               WR-1500                 0.6             Untested
  1503  Winradio               WR-1550                 0.6             Untested
  1504  Winradio               WR-3100                 0.6             Untested
  1505  Winradio               WR-3150                 0.6             Untested
  1506  Winradio               WR-3500                 0.6             Untested
  1507  Winradio               WR-3700                 0.6             Untested
  1601  Ten-Tec                TT-550                  0.2             Beta
  1602  Ten-Tec                TT-538 Jupiter          0.6             Beta
  1603  Ten-Tec                RX-320                  0.6             Stable
  1604  Ten-Tec                RX-340                  0.3             Untested
  1605  Ten-Tec                RX-350                  0.1             Untested
  1607  Ten-Tec                TT-516 Argonaut V       0.2             Stable
  1608  Ten-Tec                TT-565 Orion            0.5             Beta
  1609  Ten-Tec                TT-585 Paragon          0.3             Beta
  1611  Ten-Tec                TT-588 Omni VII         0.3             Alpha
  1612  Ten-Tec                RX-331                  0.1             Beta
  1613  Ten-Tec                TT-599 Eagle            0.4             Untested
  1701  Alinco                 DX-77                   0.7             Beta
  1801  Kachina                505DSP                  0.3             Alpha
  1901  Hamlib                 RPC rig                 0.3             Beta
  2201  TAPR                   DSP-10                  0.2             Alpha
  2301  Flex-radio             SDR-1000                0.2             Untested
  2303  DTTS Microwave Society DttSP IPC               0.2             Alpha
  2304  DTTS Microwave Society DttSP UDP               0.2             Alpha
  2401  RFT                    EKD-500                 0.4             Alpha
  2501  Elektor                Elektor 3/04            0.4             Stable
  2502  SAT-Schneider          DRT1                    0.2             Beta
  2503  Coding Technologies    Digital World Traveller 0.1             Untested
  2506  AmQRP                  DDS-60                  0.1             Alpha
  2507  Elektor                Elektor SDR-USB         0.3.1           Stable
  2508  mRS                    miniVNA                 0.1             Alpha
  2509  SoftRock               Si570 AVR-USB           0.2             Beta
  2511  KTH-SDR kit            Si570 PIC-USB           0.2             Beta
  2512  FiFi                   FiFi-SDR                0.5             Beta
  2513  AMSAT-UK               FUNcube Dongle          0.2             Beta
  2514  N2ADR                  HiQSDR                  0.2             Untested
  2601  Video4Linux            SW/FM radio             0.2.1           Beta
  2602  Video4Linux2           SW/FM radio             0.2.1           Alpha
  2701  Rohde&Schwarz          ESMC                    0.1             Alpha
  2702  Rohde&Schwarz          EB200                   0.1             Untested
  2801  Philips/Simoco         PRM8060                 0.1             Alpha
  2901  ADAT www.adat.ch       ADT-200A                1.36            Beta

I have set the speed of My Kenwood TS-590S USB connection to 19200. In my computer it turns up at USB0. So the following settings apply for me:

My settings for a Kenwood TS-590S with USB
Note that I have a Kenwood TS-590S (#231) but instead I used the Kenwood TS-570D (#204) because that one works very good.

Remember to become member of the group dialout. After adding yourself to the group, do a reboot or re-login.

Friday, May 01, 2015

Ham radio stations in my neighborhood

This map shows my city and the cities around it with red dots for every HAM station registered at QRZ.com

Red dots are HAM radio stations

 This map shows all registered HAM radio antennas around my QTH at http://www.antenneregister.nl.

Green dots are HAM radio stations

There are at this point in time approximately 14.000 HAM radio call-signs and about 13.000 active HAM radio operators in the Netherlands.

Thursday, March 26, 2015

How to export from HRDLOG.net and import to QRZ.com?

Normaly I log my QSO's manualy on hrdlog.net. The log is automatically exported every day to eQSL.cc and LOTW
To import an ADIF file in QRZ.com I need an ADIF file first. Hmmm... Where to get it? HRDLOG.net does not have an export function to ADIF file.
In HRDLOG you can send the logs to eQSL. eQSL has a feature to export to ADIF.

First make sure to register an eQSL account. Then set the connection to eQSL up in HRDLOG via: Home>Modify profile>eQSL

Next go to eQSL and click on Log/Outbox. Select the entire list.

On the bottom of the page there is a Download link: ( Download entire InBox in ADIF format (for importing into some loggers)   Click on the link.

Next click on the .ADI file link.
An HTML page will appear. Download it to disk in Firefox with File>Save Page As.  

This .ADI file can be imported into QRZ.com.
Now you can start harvesting those QRZ awards.

Wednesday, March 04, 2015

How to Brother HL-2135W on Ubuntu via secure WIFI router

The Brother HL-2135W laser printer only has one USB port and a wireless port. In this "how to" the USB port is never used and there is no need for any USB cable at all.
Your Ubuntu computer can use the printer wireless via your network Access Point or via a wired connection to your router, both work fine after this how to.

I use standard 32 bit Ubuntu 14.04 with the standard Unity GUI and the printer-drivers can be found in the "Ubuntu Software Center" if you search for Brother and unhide the technical items.

The printer runs fine with USB but cannot be configured with USB.

Here is how to get the printers wireless connection to your secure wireless router configured so you can use the printer by any computer in your network without using USB or Windows .

First turn on the printer in range of your wireless router Access Point.
  • Check if the printers WIFI is running, check for the green LED under the USB port on the back of the printer to light up. A new SSID called SETUP should be on air in the 2.4 GHz band. (We might need this SSID later on.)
  • If it does not light up, press and hold the Go button for 10 long seconds to turn on the printers WIFI.
  • Next, press the Go button 3 times within 2 seconds and the "network status page" will be printed.
  • Now check the settings on the paper. If they are all wrong you might want to reset the printer to factory defaults.
If you wish to reset the print server back to its default factory settings (resetting all information such as the password and IP address information), please follow the steps below:
  1. Turn off the printer.
  2. Make sure that the front cover is closed and the power cord is plugged in.
  3. Hold down the Go button as you turn on the power switch. Keep the Go button pressed down until all the LEDs light up, and then the Ready LED turns off.
  4. Release the Go button. Make sure that all the LEDs turn off.
  5. Press the Go button six times. Make sure that all the LEDs light up to indicate the print server has been reset to its factory default settings. The machine will restart.

Don’t forget to turn on the printers WIFI after the reset if needed. IP range 169.254.x.x is given when DHCP fails.
    If you have an open network with DHCP and without security, the printer has already connected to the network and you will see the Brother HL-2135W if you add a new printer in Ubuntu. (Wait for it.) But many wireless Access Points have a password so:
    • Check the IP address on the "network status page" you just printed and open it in your browser. It will open the printers web-control site. (A website inside your printer.) The standard password is admin/access.
    Now this will work if you are very lucky but most wireless network cards are not in the same IP range as the printer so then there is still no connection yet.

    BRAdmin Light works perfectly under WINE (Install wine in Terminal with " sudo apt-get install wine") and finds the wireless printer too.
    It uses its own port (631) to do that. BRAdmin Light is on the CD that came with the Brother HL-2135W and on some download-sites.

    Make a wireless connection in Ubuntu to the printers SSID called "SETUP". You might want to edit the network connection in your Ubuntu to connect successfully. Here are the settings:

    Start BRAdmin Light by pressing the Icon in the dash and it will discover the printer.

    With this tool you can set the printers network settings into the same IP range as your laptop or PC so you can connect to the web-control with your browser.
    • In the web-control site you can set all kind of settings like wireless settings, IP, Subnet Mask, Gateway, SSID and DHCP.
    • Set the printer to use the correct gateway and subnet mask and then set it to DHCP (under TCP/IP settings) and press submit to apply. 
    • Now go to "Network Configuration" - "Configure Wireless" and set up the access to your secured wireless router. (Use infrastructure Mode.) Press submit to apply the new settings.
    • After this is done, Reconnect Ubuntu again to your own wireless Access Point.
    • Reboot the printer or power it off and on again. The printer will now connect to your wireless Access Point and receive an IP from its DHCP server. 
    • Restart BRAdmin Light and it will again find the printer, this time is in the correct network IP range.
    • Any computer in the network can now connect to the web-control site of the printer with an internet browser.
    If you now add a printer in Ubuntu the Brother HL-2135W will magically appear under network printers as long as the PC or laptop is connected to the network. (Wait for Ubuntu to scan the network.)

    As Ubuntu driver choose the jetdirect driver (The one with the ip address.) Then choose Brother foomatic.

    Please let me know if this was any help.

    Monday, October 06, 2014

    50 Mhz dipole made of reed.

    On 50 MHz I never heard anything using a G5RV antenna so I decided to make a dedicated antenna for this HAM band. The band runs from 50 to 52 MHz. So the antenna tunes to 51 MHz.

    50 Mhz dipole made of reed.
    As a mast I used a plastic pole. For the horizontal part I used reed that grows in my garden.
    After I picked the reed I dried it for several years in my shed and now its hard as steel and its still flexible. Ideal antenna material.
    Duck-tape fits everything together.
    RG-58U coax with two insulated wires hang from the reeds where duck-tape keeps them placed.
    I noticed the SSB DX is found between 50.100 and 50.200 MHz. 

    Thursday, February 13, 2014

    How to concat in Cognos report studio, blank / null problem Oracle

    In certain reports, either data contains null values or the results of a complex query can return null values.
    When performing a calculation, null values will cause the calculation to return a null value.
    When concatenating names consisting of  surname, prefix and initials if one of the 3 is missing the result is a complete blank.

    In most cases this may not be the desired result.

    Only Oracle databases have this problem, other databases work fine.
    IBM states its Oracles fault because Oracle does not do standard SQL.

    One of the solutions is to change the data-items you want to concatenate so that a value is returned if the field is a blank. Here is an example:


    Change the above data-item into:
    (  '  ' )

    Or change the above data-item into:
    coalesce (  [DATABASE].[EMPLOYEE].[PREFIX] ; '  ' )

    Do this with all the fields that may contain any blanks or null values in the whole Oracle database.
    After this is done it is finally possible to concatenate the several database-fields in Oracle even if one field is NULL or blank.