The Linux Page

console

Can I create an INDEX to accelerate a SELECT MIN(IF(...)) in MySQL?

I have a table with a few columns, two of which are integers, one of which can be NULL in which case the other integer is to be used in my query.

CREATE TABLE my_table (col1 INTEGER NOT NULL, col2 INTEGER);

If `col2` is NULL, then use `col1`. As is, there is how my query looks like:

SELECT MIN(IF(col2, col2, col1)) AS smallest FROM my_table LIMIT 1;

In other words, I need to get the row with the smallest integer, but if one column is NULL, I want to use the other column value.

On a very small sample, the query is still very fast, but the real version is not unlikely to have thousands ...

Boot into the command line console in Ubuntu 16.04

As I just upgraded my 14.04 installation to 16.04, it booted right up to lightdm.

I had it properly setup to boot in a console before, but somehow it changed the behavior on me.

This is because the computer is now using systemd to boot.

I already had the GRUB variables setup as expected:

GRUB_CMDLINE_LINUX_DEFAULT="text"
GRUB_CMDLINE_LINUX="text"
GRUB_TERMINAL=console

But this is not enough if you want to start in the console when running systemd (which is running since 15.04).

systemd has a list of variables you can tweak using the systemctl command. To boot in ...

Remove the Keyboard Repeat in a VirtualBox console running Linux?

When I use virtualbox over the network (from a headless computer) and I connect using SSH, that virtualbox is going to be slow.

Somehow, I did not have that problem with older versions (Ubuntu 14.04 and older) but newer versions have required me to turn off keyboard repetition otherwise I get keys repeated (mainly the Enter key when something takes processing time at the time I hit the enter key) as in:

Heeeeeelllllooooo

The solution is to run the folloing command:

setterm -repeat off

It works in most terminals, for sure, the regular Linux console you get after installing a server in a ...

Solaris virtual consoles are password protected, how to remove the protection?

Solaris 11.2 (Open SunOS really) has virtual console a la Linux. This works great. You can use the Alt-F1 to Alt-F6 keys to instantly switch between 6 different consoles. I use that to have one console with an editor and another with my make and runtime tests.

Unfortunately, Solaris includes a lock which manes that each time you switch between a console, it hides the content and ask you for your password to unlock the console (that way you could have multiple users on the same computer, each using a different console and the system remains safe since people cannot just go to someone's ...

Supermicro X9SCI/X9SCA, video is gone!

As I am still trying to get my computers to work with a dual seat (or multiseat), I did an attempt in using the onboard video (a relatively decent Matrox card.) So I went in the BIOS and changed the setup for the video from Offboard to Onboard. Big mistake!

The video stopped working. On reboot the computer beeped 8 times and booted the OS normally (I have SSH setup so I could access the computer, but absolutely no video on either port: on board and off board.)

I have a Supermicro X9SCI/X9SCA. Searching for "no video" or "missing video on boot"... returned nothing ...

xhtml2pdf generating an error under 14.04+

Note: This bug is fixed in Ubuntu 16.04

Working on a website I have to convert invoices to PDF so end users have the ability to print and share the invoices from the website.

In order to do that, I generate an HTML page with the invoice which also gets displayed in the website, and then convert that HTML to PDF with xhtml2pdf. I use that tool instead of whtmltopdf because it does not require X11 to work. The other tool is said to require Qt and X11 and we do not want those things on our backend servers.

So... I upgraded to 14.04 and the tool stopped working with an ugly error:

 ...

[ODBC Driver Manager] Data source name not found and no default driver specified

As I was working on a MS-Windows installation, I ran in this weird error: Data source not found and no default driver specified...

This was output when I was running the following in a command line prompt:

osql -E

The result should have been an MSSQL prompt instead!

The problem on the computer was that I uninstalled MSSQL 2005 that was automatically installed by Visual Studio C++ and was not compatible with our application, so I first uninstalled that but that uninstallation is really not proper. It leaves a LOT of things behind.

After that I installed MSSQL 2014 which was reported as ...

Adding a group for to a logged in Linux user

Once in a while I want to add my user to a group and then right away make use of that group.

Unfortunately, in general Unix kind of forces you to re-log in for the new group to be attached to your account.

However, a command has been added, a while back, to do just that on the fly. Not something you would want to use in a script, but at least, it works for me when doing a few things here and there.

In my case, I wanted to run QEMU, which I hadn't done in a while, and the system told me that it could not open the KVM, the error: kvm permission denied.

The problem was that I was not part ...

The for() in C, C++, Java, PHP, JavaScript...

As I am working on my as2js compiler, I stumble on a couple of problems with the for() loop parsing because of the in keyword. That made me think and the for() statement was actually a very funny one. Yes! You can actually write something like this and it compiles:

int zero;
for(3;2;1) zero;

As you can see, all 3 entries in the for() statement are valid expressions and therefore the compiler can compile that code. This creates a loop that runs forever, similar to:

for(;;) zero;

but much less clear to read, obviously.

Now that's food for thought, isn't it?

In JavaScript, you ...

Repair a Cassandra Cluster

I use the Cassandra database cluster system to manage a new set of websites and once in a while I start getting many errors and the website stops working altogether.

When that happens, it is likely that Cassandra broke something in the temporary tables that it holds. The only way to go past that problem is to clear those tables. Until then, it will fail over and over again (they really would need some euristic to auto-clean up even if it means that you're losing some data.)

The command to repair the database, really quick, is as follow:

nodetool scrub snap_websites files

Note that ...

Syndicate content Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

Find the page/content you are looking for with our index.