Bluishprints

Execute huge queries in MSSQL

2013-09-30T18:11:00.003+02:00

sqlcmd -S <server>\<instance> -d <database> -i <sqlFile>.sql

Simplifying calls to WebMethods with PageMethods AJAX

2013-09-26T09:58:00.000+02:00

AJAX calls to WebMethods in ASP.net pages can be easier implemented (the javascript part) by using the PageMethod feature in Microsoft ASP.NET AJAX framework instead of jQuery.

The code I used to write (jQuery):

$(document).ready(function () {
                $("#Button1").click(function () {
                    $.ajax({
                        type: "POST",
                        url: "index.aspx/diHola",
                        data: "{'nombre': '" + $('#<%= TextBox1.ClientID %>').val() + "'}",
                        contentType: "application/json; charset=utf-8",
                        dataType: "json",
                        success: callbackFunction
                    });
                });
                function callbackFunction(response) {
                    alert(response.d);
                }
            });

And this is the code I write now using PageMethods:

function pageLoad(){
     $("#Button1").click(function () {
                    PageMethods.diHola($get("<%= TextBox1.ClientID %>").value, callbackFunction);
                    return false;
      });
}

function callbackFunction(response){
      alert(response);
}

Just remember to activate PageMethods in your ScriptManager:

.ASPX

Tu nombre:
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <input type="button" data-role="none" ID="Button1" value="Enviar" />
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">   </asp:ScriptManager>
        <script type="text/javascript">
            function pageLoad(){
                $("#Button1").click(function () {
                    PageMethods.diHola($get("<%= TextBox1.ClientID %>").value, callbackFunction);
                    return false;
                });
            }

            function callbackFunction(response){
                alert(response);
            }
        </script>

.ASPX.CS

[WebMethod]
        public static string diHola(string nombre)
        {
            return "Hola " + nombre;
        }

Java: diagram for choosing a Collection type

2013-09-25T23:31:00.000+02:00

Sometimes in Java I don't know which type of Collection should I use.
Furthermore, I can't remember all of them and what are they for, so I use a diagram I found some time ago. It really came in handy while I was working for GMV.

(I can't find the one in English!)

Diagram source: http://chatejus.blogspot.com.es/2011/04/decidir-que-tipo-de-coleccion-usar-java.html

jQuery FullCalendar and ASP.Net: Problems with AJAX requests and responses

2013-09-19T16:56:00.004+02:00

The "Fullcalendar" plugin for jQuery sends two parameters ("start" and "end") as form parameters via POST requests, which are not well processed by ASP.net WebServices (version >=3.5), which are expecting a well-formed JSON.

The result of the asp.net webmethod is a JSON object nested in the property "d" of another JSON object. This sintax is not understandable by Fullcalendar.

To solve these problems just edit fullcalendar.js changing _fetchEventSource function:

[...]
$.ajax($.extend({}, ajaxDefaults, source, {
data: JSON.stringify(data), // -- Line changed
success: function(events) {
//events = events || []; -- Line commented
events = events.d; // -- Line added
[...]

Note: JSON.stringify() is a function from the json2.js library.

How to use VMware and HyperV alternately in Windows Server 2012

2013-08-27T12:43:00.000+02:00

VMware workstation can not be installed nor executed in Windows Server if HyperV is running, so to do it HyperV should be deactivated at boot time.

By following these steps you'll change the boot menu to offer 2 options: boot with HyperV support and boot withOUT HyperV support (so you can run VMware).

(The reason why I want to run VMware sometimes is to virtualize USB devices without third party solutions like USB over Network).

Execute in a command line as Administrator:

BCDEDIT /COPY {DEFAULT} /D "No HyperV support"It copies the current boot entry into a new one called "No HyperV support". (Remember to retype the double-quotes if you copy and paste the command)

BCDEDIT /SET {COPYHERETHEIDTHEPREVIOUSCOMMANDRETURNED} HYPERVISORLAUNCHTYPE OFFIt deactivates the HyperV support for the boot entry we just created.

BCDEDIT /DEFAULT {COPYHERETHEIDTHEFIRSTCOMMANDRETURNED}It sets the new boot entry as default.

BCDEDIT /ENUM /VChecks if the new entry is correctly set up.

Installing VMware 9 in Debian Jessie with 3.10 kernel

2013-08-23T12:21:00.000+02:00

Today I reinstalled Linux and some software in my HP Pavillion laptop. I installed Debian Linux Testing (currently called Jessie) and upgraded the kernel to 3.10-2-amd64.

After that, I successfully installed VMware 9.0.2, but when I tried to open it for the first time...the compilation of kernel modules failed.

I did some googling and found that "The call create_proc_entry() has been dropped from 3.10 in favor of proc_create(). This requires patching of the vmblock and vmnet modules that use them."

So, to solved the compilation problem you just have to patch some files following the instructions listed in Archlinux Wiki: https://wiki.archlinux.org/index.php/VMware#3.10_kernels

Patches for older kernels are also provided in that site.

3.10 kernelsThe call create_proc_entry() has been dropped from 3.10 in favor of proc_create(). This requires patching of the vmblock and vmnet modules that use them.
The patches (including the optional fuse patch) can be found here and here:
$ cd /tmp
$ curl -O http://pkgbuild.com/git/aur-mirror.git/plain/vmware-patch/vmblock-9.0.2-5.0.2-3.10.patch$ curl -O http://pkgbuild.com/git/aur-mirror.git/plain/vmware-patch/vmnet-9.0.2-5.0.2-3.10.patch$ cd /usr/lib/vmware/modules/source
# tar -xvf vmblock.tar
# tar -xvf vmnet.tar
# patch -p0 -i /tmp/vmblock-9.0.2-5.0.2-3.10.patch
# patch -p0 -i /tmp/vmnet-9.0.2-5.0.2-3.10.patch
# tar -cf vmblock.tar vmblock-only
# tar -cf vmnet.tar vmnet-only
# rm -r vmblock-only
# rm -r vmnet-only
# vmware-modconfig --console --install-all

(Remember: commands preceded by "#" should be executed as root)

If you have problems trying to enter your serial number through the UI, give the command line a try:

/usr/lib/vmware/bin/vmware-vmx --new-sn XXXXX-XXXXX-XXXX-XXX-XXXXX

Setting up a SMB server on a HG556a router

2011-12-05T08:39:00.001+01:00

Vodafone Huawei HG556a

I wanted to have my external 1TB harddisk available from every computer in the home LAN, but I didn’t want to have a computer running all day. To achieve this challenge I look into the specs of the Vodafone router I have (Huawei HG556a):

Apparently, if a harddisk is connected to the router, it is mounted and can be accessed via FTP or DLNA. However, although it’s not said in the router configuration page, it also runs a SAMBA server which allows MS Windows computers (and other os with smb support) to access the harddisk as a “shared folder”.

It seemed that it was exactly what I wanted, but it wasn’t. I tried to see the contents of the harddrive through a PC and I was able to do it, but when I attempted to copy a 700MB file to the drive an error message appeared saying that it wasn’t enough free space! There was obviously something wrong...
Even if I deleted files, it reported that there was only 29MB left, which made the huge harddrive useless.

Accessing the router through telnet (changing the default admin password is needed) I discoverd that the hardisk was being mount at /var/mnt/USBDrive_1/ and the content of /etc/samba/smb.conf was:

# cat /etc/samba/smb.conf[global] workgroup = vodafone netbios name = vodafone server string = vodafone security = share[Share] path = /var/mnt/ comment = Share files browseable = yes public = yes writable = yes guest ok = yes

With these settings, when accessing through SAMBA it was reported the free space in the router (/var/mnt/), instead of the harddisk.
Changing the path to the real mount-point of the harddisk (/var/mnt/USBDrive_1/) I got ride of that “29MB left” error message, allowing me to copy bigger files.

To modify the smb.conf file I had to copy it to the harddrive, edit it in my laptop and then overwrite the original file, because the small linux installed in the router doesn’t have vi or nano to edit text files. Of course, you need to restart the smbd daemon and repeat these steps every time the adsl router is restarted.

I also improved a bit the data rate killing the snmp and ftp service. However, it is still not very good (<3MBps), but it seems to be a global problem of hg556a. So, if anybody knows how to make this fix permanent or improve the datarate, contact me!

Developing SEDILEC website http://www.sedilec.com/

2011-06-28T12:40:00.000+02:00

http://www.sedilec.com/

Today, I finally uploaded the website for the company called SEDILEC S.L. which is specializing in lighting and security systems.

It is a light web based on PHP and MySQL that allows the website administrator to add, edit and delete products from the catalogue quite easily.

I hope it won't throw strange errors along the time :S and it gets positioned well on search engines.

Padding video files to earn money!

2011-02-26T12:50:00.000+01:00

Yesterday I saw a link to a very recent Spanish movie in a Torrents site. It caught my attention because it was said that it had a very good video&audio quality, what was improbable due to the fact that it opened just some days ago. So, I started to download it just to see if it was a fake or not.

When it was finally downloaded, I tried to opened it with VLC Player. I could watch 4 seconds and suddenly it stopped playing. First I thought that the "unRARing" process went wrong (which was strangely fast), so I did it again. However, I obtained the same result.

I decided to open the file with a hexadecimal editor, just to see if there was something "odd", and there was. Firstly, I noticed that this film was edited with "Windows Movie Maker" and trans-coded with WMV codec.

Then, I continued observing it: meaningless bytes for me (seemed to be video data for those 4 seconds) and after that..... the word "PADDING" repeated thousands of times. The file was not corrupted, it was filled with text.

Video file opened with a hexadecimal editor

Taking this fact into account, the compressed file should have been much smaller, but it wasn't (700MB). I checked with the "rar" utility and it threw a message telling me that the compression rate was set to 0%...

So, everything was absolutely done on purpose. Who would do that? Firstly I thought about the film industry, but then I found a comment attached to the RAR file:

"Thanks for downloading!

If you have problem playing the movie, download and install the codec below :

http://7d9e0c22.linkbucks.com"

That link led me to a website which offered the download of a XVID codec. I knew I had it already installed, so that was not the problem. However, I downloaded it and sent it to some online antivirus: It was detected as "NSIS:LoudMo-B [Drp]".

Microsoft Malware Encyclopedia says:

http://www.microsoft.com/security/portal/Threat/Encyclopedia/Entry.aspx?Name=Adware%3AWin32%2FLoudmo%20

"Adware:Win32/LoudMo is a program that delivers advertisements, monitors Web browsing habits and prompts advertising popups, while automatically updating itself."

Doing a WHOIS to the domain in which the alleged XVID codec was (downloaddirect.com) I could find that it was owned by somebody who has an email account at loudmo.com. If you visit Loudmo website, you'll see that is a company which pay per every install of their applications (which all of them are fake copies of popular apps with spyware).

Summing up, all this mess was made with the aim of gaining money and stealing information from the users without their permission, but in a quite smart way.

A naive user would have downloaded it and when they see that their video players can't play it, would have downloaded the "codec" and got infected with the spyware.

Today I found some more files in torrents site with the same "content". So... double check what you download!

When common TV channels are boring you...

2011-01-01T21:33:00.000+01:00

During this Christmas time, contents in every TV channel in Spain are almost the same: films which has been on again and again, pop musical programs and mixtures of Youtube videos.
Because of this, I looked for other programs which could “entertain” me a little more, so I ended up on the BBC UK webpage, where I found tones and tones of good quality programs. It seems that the money that BBC gets from TV Licenses is well managed!

Thanks to the BBC webpage it is possible to watch their TV channels (BBC One, BBC Two, …) in live streaming but only if you are in the UK (due to legal facts). However, it’s possible to watch the programs which has been already on TV through the “BBC iPlayer”, a Flash application to play sources of video streaming (also available to run it with Adobe AIR).

My boringness seemed to be finished! But when I was trying to watch a programme... I realized that my Internet connection was not enough to watch it smoothly (iPlayer don’t allow you to change the cache size easily). I continue searching for a while and I found a multi-platform program to record and watch BBC programs which offers lots of options (subtitles, programmes guide, using of proxy [~~you know what for~~], etc...). It’s name is get_iplayer (http://www.infradead.org/get_iplayer/html/get_iplayer.html) and it is an open-source project. It's aim is to provide a way to watch BBC programmes in devices which don't support Adobe Flash. It was abandoned by its author, but some other people has continued developing it.

So what I do now is start downloading the programme I want to watch, after a few seconds I start playing that file with VLC and I enjoy it :). When exams are gone, I’ll try to make a simple GUI to make it easier to use!

One programme I’d really like to recommend is “Come Fly With Me”, a new comedy series which takes place in an airport. You can read more about it and watch some chapters here: http://www.bbc.co.uk/programmes/b00trc9v
It’s on BBC One every Saturday at 21.00 (UK).

If I could pay for an UK TV License to watch these channels on my standard TV I would do it with pleasure.

Cyberattacks and microtasks

2010-12-10T11:25:00.000+01:00

Today, a long bank holiday came to an end for me. Five days which had been led by the air traffic controllers and the Internet-war due to the W¡k¡leaks issue.

It's quite impressive how a relatively small number of users are creating such a mess to big companies like Mastercard, Visa or Paypal (I'm talking about the DDoS attacks). It is true that there are lots of people who want to show their support to W¡k¡leaks, but I don't know if this is the right way, mostly because of the possible side effects (such as using them as a an excuse to restrict the Internet user liberties in the future). The figures about this attacks are being tracked by Panda labs.

However, these days have been quite normal for me on the RealWorld™. I have been able to enjoy them with friends and also to prepare myself a bit more for the final exams on January. The end of this holiday seems to me the start of the countdown for exams, so that, my hours of studying are going to be increased in an exponential way in the next days.

To finish this entry, I would like to share the little piece of work we were working on last week for Microprocessors class. It can be useful for other students who have to face up to a task similar to this one.

The aim of it was just developing a program (for a specific machine) in assembler to calculate the factorial of a given number throughout consecutive sums. It was not a difficult task, but it took us more than expected owing to the fact of being used to coding in higher level languages.

The design of the machine for ISIS: http://db.tt/b00z7lG

The program itself: http://db.tt/rOZ3bg4

Because actions speak louder than words...

2010-11-23T05:21:00.000+01:00

Last Monday I could attend a talk at my University where some Teleco alumnis explained us what they had done during the years they spent here as students, and also, how their career is being.

I found it very interesting for me and made me actually think about my future, but above all, about the present.

From what I listened, I could conclude that it would be better for me to do more things apart from just studying what the teachers say. I have realised how "similar" every single student seems to the companies when it finishes its studies and the need of being "noticed" among all that people.

Well, nowadays I am an active member of BEST Valladolid (being Public Relations Responsible since October), but it's time to take more responsabilities and be more proactive in this association, but also in other aspects of life.

So, this is the reason why I am starting this blog and the aims I'd like to achieve are: creating my personal identity on the net, improving my English by writing and starting to be a bit more "different" from the "student-mass". Let's see...