How to patch your VMware ESXi 5x server for free using esxicli command line

First, download the current patch from VMware. VMwareIn my case, it was ESXi550-201312001 that I downloaded from Download Patches page. You will need to have a valid VMware login but you don’t have to pay for a support contract 🙂

Copy the downloaded zip file to your ESXi server. I put it in /vmfs/volumes/52f573f2-d2dddb9e-e83a-001b213a7c46/Patches/ESXi550-201312001.zip but you can put it anywhere on your server. How to transfer it? Either temporarily enable ssh on the server and use winscp or scp.

Log into the console (I enabled ssh on the server) and issue the following command:

esxcli software vib update -d *where ever you put it*/ESXi550-201312001.zip
Share Button

SAP Sybase IQ SA CR 728597 / Linux Kernel direct i/o bug & huge pages

Last year, April -> October, I asked the question about IQ supporting Huge Pages on Linux. It was mentioned that under SA CR 728597 and Red Hat Bug 891857 that there was a bug in the Linux kernel handling of direct I/O while using transparent huge memory pages (a variant of Linux Huge memory pages).

CR 728597:
This problem is related to a possible bug in the transparent huge pages (THP) feature introduced in these operating system versions. Red Hat bug 891857 has been created to track this issue.

The problem can be triggered by calling an external environment, xp_cmdshell, or other procedure that causes a fork while other I/O is occurring. A known limitation with the Linux kernel limits the use of fork while doing O_DIRECT I/O operations. Essentially what can happen is that the data can come from or go to the wrong process’ memory after the fork. SQL Anywhere performs O_DIRECT I/O operations according to the documented safe usage. However, THP appears to cause further problems and the O_DIRECT I/O data comprising database page reads/writes appears to get lost.

http://scn.sap.com/thread/3338917 and http://froebe.net/blog/2013/06/17/does-anyone-have-any-details-on-redhat-linux-bug-891857/

Does anyone know the status of this ongoing FIVE year old issue?

http://scn.sap.com/thread/3505418

Share Button

How to Add logins/users to SAP Sybase IQ and copy the password from another system!

You will need to create one or more application groups. In the below example we create the mygroup group:

sp_iqaddlogin "mygroup", null;
GRANT CONNECT TO "mygroup";
GRANT GROUP TO "mygroup";

After that you can create a user:

sp_iqaddlogin "henry", null;
GRANT CONNECT TO "henry" IDENTIFIED BY 'password';

Note that if you are copying a user from one IQ system to another and want to keep the password, this is a simple thing. You just need to grab the password column of sysuser for the user in question:

select password
from sysuser 
where user_name = "henry";
0x0112fd265040a70f82873c922d2aa5d1cbae597ff18217687d3e0ca45b4e246b74198f1713

You will need to escape each byte in order to add the password:

GRANT CONNECT TO "henry" 
IDENTIFIED BY ENCRYPTED 
'\x01\x12\xfd\x26\x50\x40\xa7\x0f\x82\x87\x3c\x92\x2d\x2a\xa5\xd1\xcb\xae\x59\x7f\xf1\x82\x17\x68\x7d\x3e\x0c\xa4\x5b\x4e\x24\x6b\x74\x19\x8f\x17\x13';

Now we need to add henry to the mygroup group:

GRANT MEMBERSHIP 
IN GROUP "mygroup" to 'henry';

Any and all object permissions should be granted to the group not the user.

Share Button