This user hasn't shared any profile information

Posts by pinchii

Wake-On-Lan Shell Script for Tomato

I needed a way to wake up my server when I was away. And since I run DD-WRT, I Wrote a WOL Script for it. You can read more about it here

Some people emailed me or asked via the comments section if I would create a version for Tomato, which is another popular firmware for routers

Now that I upgraded my main router to a Bufallo WZR-HP-AG300H, I had my old and trusty Buffalo WHR-G54S to play with, so I loaded Tomato on it, and decided to modify my WOL scrit for it.



Once you get the script into your router (copy and paste into VI or WinSCP), to use it, all you have to do is type “./ <servername> and the script will handle the rest

Don’t forget to “chmod +x” the script first

This script dumps out the “dhcpd_static” nvram variable into “/tmp/static.hosts”, so if you have a DHCP reservation for your server like I do, it should be included in this file as a “static” ip adress, along with the MAC address, which is what you really need for WOL to work

Facebook Twitter Email Linkedin Digg Delicious

Broke SSH in DD-WRT After Upgrade – This is How to Fix it

I recently updated my version of DD-WRT from 14xxx to the latest and greatest 18946

I know that they recommend you do the 30/30/30 reset, but you know what, I didn’t want to lose all my settings.

What I found when the router restarted, is that everything worked fine, Except for SSH

It seems that as of version 17xxx the guys are DD-WRT switched from OpenSSH to Dropbear. No big deal really, exept the SSH keys are not compatible with each other, thus preventing SSH from running.

To fix SSH:

    • Enable Telnet
    • Telnet into your router and run the following commands:
      1. cd /tmp/root/.shh/
      2. rm authorized_keys
      3. rm ssh_host_dss_key
      4. rm ssh_host_rsa_key
      5. nvram unset sshd_rsa_host_key
      6. nvram commit
      7. reboot

Once the Router Restarts, SSH should be working, and when you try to login, you will get a prompt to accept the new Key Generated by DropBear


Don’t Forget to Disable Telnet

Facebook Twitter Email Linkedin Digg Delicious

EDIT the SI_VIEWER_URL property in Crystal Reports Server 2008

I had an issue were I started to publish reports via Crystal Reports Server 2008, but if I included the variable SI_VIEWER_URL so that a link to the report would be included, it always went to wrong host name, and not to the DNS Alias that I setup.  Also, It kept referring to the “JAVA” openDocument viewer, and I am using the .NET version.


So in order to change it:

Log In to the CMC

Under Management Click “Applications”


Under the Applications View Right Click on CMC and Select “Processing Settings”


Then Finally Replace the URL that is in the Box, with whatever it is you need your URL to look like.  Note the Extension change to ASPX from JSP because i’m running the .NET Viewer

Thats all there is.  Now Next time you include the SI_VIEWER_URL variable, it should point to the URL you entered in the CMC Settings Above.

Happy Reporting!!

Facebook Twitter Email Linkedin Digg Delicious

Failed to open the connection When Viewing Report On Crystal Server 2011

So you created a report in Crystal Designer 2011 (or whatever other version) and it runs well on your system.  You uploaded it to your Shiny New Crystal Reports Server 2011 (BO 4.0, XI4, whatever you call it) and it doesn’t work.  You can’t view the report because you get an error:

The Problem is that Crystal Designer is 32-bit, and Crystal Server 2011 is 64-bit.

So if you want to use your report on Crystal Server 2011, you need to add the ODBC connection to the server using the \Windows\SysWOW64\odbcad32.exe ODBC Manager Control panel.  After that, your report should run just fine.

Facebook Twitter Email Linkedin Digg Delicious

Trasmission BT Client on The Patriot Javelin S4 with Optware

This is how to get the Transmission BT Client installed on the Javelin S4 Media Server NAS

  • Install Trasmission (Ipkg Install Transmission)
  • edit  /root/.config/transmission-daemon/settings.json
  • set  “rpc-whitelist” from “” to “”
  • set “rpc-whitelist-enabled” from true to 0
  • the call the daemon with /opt/bin/transmission-daemon -g /root/.config/transmission-daemon/
  • now open your browser and connect to your your nas IP port 9091


There are other settings to be configured i’m sure, but for now i’m just happy with the Transmission Client working

Happy Torrenting

Facebook Twitter Email Linkedin Digg Delicious

Resetting Crystal Reports Server 2008 Administrator Password

Recently someone asked me how to reset the Administrator password on a Crystal Reports Servers 2008 installation without losing all the data. I’m going to share here the solution, just in case someone else is searching for the same thing.

In the Crystal Database, there is a table called “InfoObjects6”, maybe you have already heard of it in one of my previous post.  In this table, the object with objectID = 12 is the Administrator account.

So, in order to reset the admin password, run this query:

For those whom are curious what this really does. The CRC is the “hash” that verifies that the value of the “Properties” column has not been changed. By setting it to blank, it makes whatever password is stored under Properties Invalid. Next time you try to log in, a new “default” password hash will be created along with a new CRC.

Basically, it will set the Administrator password to blank, at which point you can log in and set it to whatever you want!!

Facebook Twitter Email Linkedin Digg Delicious

Optware for the Patriot Javelin S4 Media Server

Disclaimer: I am not responsible for any damage you may cause your device for doing this

Disclaimer: I am responsible for any AWESOMENESS that comes from your device for doing this


Every time I get a new toy, like any techie I have to see whats under the hood.  And this time it was the Javelin S4 Media Server NAS by Patriot.

I bought this NAS to help solve my storage needs.  I’m into photography, and currently I have 4 different External HD’s to store my photos.  Problem is, they all get out of sync with each other, and there was no real easy way to maintain them all. My solution was to get a NAS that would support RAID and thus, thanks to a nice rebate from newegg I got the Javelin S4.

The *ONLY* problem I had found was that the S4 didn’t support SSH (like it was listed on’s website), and I wanted/needed to be able to SFTP/SSH.

I had 2 problems to overcome.  First, gain access to the console on the NAS, second, add SSH to the device.

The solution to my first issue was found in the Patriot Memory Forums and a few posts by a user called “BadIntentions”

BadIntentions was kind enough to release a plugin called “Rooter” which allowed “root” access to the console via telnet port 2380, and also it included a new, enhanced version of busybox that he compiled for the device.

Once I was in, I started to look around the NAS and found that getting SSH on this thing wasn’t going to be easy.  Most of the files in /etc are replaced every time the device gets rebooted, and the partition of the OS where all the utility scripts reside is set to read-only.

So I went about searching for a way to get SSH on this thing, and through my poking around the system I realized that the only way I was going to get SSH was going to be by creating a “plugin”.

Now the S4 is a little box, but it packs a nice punch


so I wasn’t worried about ssh running, the only issue was, were to get it from.

I automatically thought about the optware project.  These guys have been around for a while, and knowing the work that they have done with the NSLU2, and other NAS devices, I figured it was only a matter of finding the right “feed” (this is what they call the package repositories) that would work on the S4.  Through some searching, I found that the Synology DS101G has a “similar” PowerPC processor, so I took the risk of giving the packages from the ds101g a try.

Created all the necessary folders and symlinks, placed all the binaries where they were expected, ran the ssh command, and voila, I now had SSH, and I was done (but not quite).

Now I could have called it a day, maybe try to create a plugin for SSH on the S4, but I though, why not get the whole IPKG system working on the S4.  Really contribute to the community, plus with optware running on the S4, It would open up this device to way more binaries besides SSH, and make this a very powerful box.

So I went about taking apart the Optware Install Script for the DS101G also known as the DS101Bootstrap.  Since there are two versions of the DS101, we specifically target the DS101*G* which has a powerpc processor.

The DS101Bootstrap script does the following in a nutshell:

  • runs a bootstrap script that creates a temp ipkg install environment
  • creates and mounts the /opt folder structure
  • installs the necessary libraries for ipkg
  • installs ipkg
  • installs openssl
  • installs wget-ssl
  • sets up the environment so that on every reboot, the /opt folder gets mounted and all the other PATH and variables get set

What I did, in order to get optware to install on the S4 is:

    I created a plugin folder called Optware with a configuration file telling the system where to find the init script
  • I took apart the script, the bootstrap.ipk, and the temporary install script and modified them to work on the S4 (mostly Capitalization, and instead of mounting /VOLUME1, mounting my Plugin Directory)
  • I ran the install process, which surprisingly ran pretty smoothly, except for a missing library that needed to be installed before wget-ssl, and also symlinking wget to the /bin directory, after fixing those two things, it finished without a problem
  • After that was completed, I took the script from the bootstrap.ipk, modified it to fit the S4, and used that as a script to mount and initialize optware

After a reboot of the S4, my optware plugin’s init script gets called, /opt gets mounted, all the init.d scripts for optware run if needed (ssh being one of them) and the system works perfect

I can now SSH to my NAS via port 2222, and If I need to install any other packages, its as easy as “ipkg install <packagename>” (you must be root, so sudo su – if you login as “admin”)



The only thing left now if for me to package all this up into a nice .ppg that the S4 will recognize and automatically install via the webpanel.  The day you want to get rid of optware, its as easy as deleting the plugin from the web panel as well.

As for what else is compatible with the S4, well, so far I’ve only tested the SSH package, the wakelan, openssl, and wget-ssl.  I read somewhere that the bash package will brick your device, but that was referring to another device, so YMMV


The Link to the Optware Plugin for the Javelin S4:


[download id=”1″]


The Link to the Rooter Plugin for the Javelin S4 (needed to install Optware): Rooter Plugin PPG (you must sign up for the forums to download)


If you Enjoy Optware, please consider donating to the guys at the NSLU2 Project (I am not affiliated with them, and I do not receive a “cut” from them, FYI)

None of this would have been possible without BadIntentions and his Rooter plugin

Facebook Twitter Email Linkedin Digg Delicious

Adding Services to Default Application Proxy Group in SharePoint 2010

After you setup your Sharepoint, you later find that you have to add another service. (or you delete a service and recreate it)

In my case, I had to re-add the “User Profile Service Application”.

Turns out after I added it, the USPA was not part of the Default Application Proxy Group

(_admin/WebApplicationList.aspx -> Service Connections)

I found an article online by Amit Khanna Tittle “Associating services to Custom Application Proxy Groups in Sharepoint 2010”, which explained how to create a new group and associate a service, so I figured that would help me.

The one problem I found was that when I put in “default” as the proxy group name I got an error “Object not found”
It’s obviously an error with the Name or “Identity” of the ProxyGroup, and the command Get-SPServiceApplicationProxyGroup gives you the “friendly” name of the service, but not the real name.  In order to get the real name you need to run this command “Get-SPServiceApplicationProxyGroup | Select Name,Id”Interestingly enough, you can see that the real name is “<blank>”.

So, if you try to run that command again, but leaving the Identity of the proxy group blank, and passing the GUID of the memberyou will successfully add the service application the default group



Facebook Twitter Email Linkedin Digg Delicious

Site Web Analytics reports show no data in SharePoint 2010

It seems that in Sharepoint 2010 it is common for the Site Web Analytics reports and Site Collection Web Analytics reports to not show data.  Many Folks over at the MS TechNet Forum seemed to think that it was an issue with Sharepoint, but it is really not.  The real issue is that the Jobs that are supposed to collect the data for the Health Analyzer are disabled by default.  So you must go in and enable them.

In the Admin Panel: http://mysharepointserver/_admin/ServiceJobDefinitions.aspx enable the following jobs (their default times are fine, so you can leave those as is)

Diagnostic Data Provider: Event Log
Diagnostic Data Provider: Performance Counters – Database Servers
Diagnostic Data Provider: Performance Counters – Web Front Ends
Microsoft SharePoint Foundation Usage Data Import
Microsoft SharePoint Foundation Usage Data Processing
There are other services that are disabled (Some SQL jobs and some trace job) which you can enable if you want, but for me, these were enough for what I needed




Facebook Twitter Email Linkedin Digg Delicious

Where is the Startup Folder For All Users In Windows 2008?

I needed to make bginfo, a great utility from our friends over at Microsoft (SysInternals) run for every user that logged in to a set of servers I had built.


My solution needed to be simple.  Add a shortcut to the “All users” startup folder, but I couldn’t find it.
Turns out that it got moved and its hidden.

To find it, go to Folders, Advanced Settings, and Click on “Show Hidden Files” or just open a “Run Command” window and paste this path

There it is. Simple. Shortcut Created. Done.

Facebook Twitter Email Linkedin Digg Delicious
pinchii's RSS Feed
Go to Top