Monthly Archives: July 2017

mysql – #1241 – Operand should contain 1 column(s)

So!, I was/am writing a subquery to get a value to rating_stars… and I got this (beginner) error…

mysql – #1241 – Operand should contain 1 column(s)

(SELECT value, (sum(value)/count(value)) FROM model_ratings WHERE modelId = id) AS rating_stars

Subquery should return one column, whatever corresponds to rating_stars.

(...) (SELECT (sum(value)/count(value)) FROM model_ratings WHERE modelId = id) AS rating_stars (...)

Instrument 666 — Cyrus’ War Remix (Ver 5.0)

Cyrus: Can you count, suckers? I say, the future is ours… if you can count!

Now, look what we have here before us. We got the Saracens sitting next to the Jones Street Boys. We’ve got the Moonrunners right by the Van Cortlandt Rangers. Nobody is wasting nobody. That… is a miracle. And miracles is the way things ought to be.

You’re standing right now with nine delegates from 100 gangs. And there’s over a hundred more. That’s 20,000 hardcore members. Forty-thousand, counting affiliates, and twenty-thousand more, not organized, but ready to fight: 60,000 soldiers! Now, there ain’t but 20,000 police in the whole town. Can you dig it? Can you dig it? Can you dig it?!

Continue reading Instrument 666 — Cyrus’ War Remix (Ver 5.0)

dashboard for VMware, SNMP, REST API and more

Simple dashboard system for sysadmins with modules for VMware, SNMP, REST API and more

SysAdminBoard is a simple dashboard system written in Python, HTML and Javascript and served on a simple CherryPy Webserver (included). It was originally written to reformat snmp data for the Panic Statusboard iPad App, but has since become a fully stand-alone project that can grab data from a variety of sources and render charts and graphs in a web browser.

End of script output before headers – No such file or directory: exec of

 

[Wed Jul 19 16:08:45.679229 2017] [cgi:error] [pid 2954] [client 94.63.xxx.xxx:12439] End of script output before headers:4KUYWRBjpMFod9i.cgi
[Wed Jul 19 16:09:05.030839 2017] [cgi:error] [pid 783] [client 94.63.xxx.xxx:37260] AH01215: (2)No such file or directory: exec of ‘/home/webroot/nasamos.com/www/cgi-bin/x9uWvwAREeUkQn5p/4KUYWRBjpMFod9i.cgi’ failed

Well!,
I saw a few blog posts and forum threads about this issue, but NONE was able to help me….

Yah!, syntax was okay….

perl -c 4KUYWRBjpMFod9i.cgi
4KUYWRBjpMFod9i.cgi syntax OK

I’v created a brand new file on /cgi-bin/ with some dummy filename and pumped a simple perl script on it…

#!/usr/bin/perl
# hello.pl -- my first perl script!
print "Content-type: text/html\n\n";
print "Hello, world!\n";

I was able to run it successfully, so…. the issue wasn’t on the CGI/PERL/APACHE/FIREWALL/SUEXEC.
I guess that the 4KUYWRBjpMFod9i.cgi had some issue… even using file -i  it looked to be okay… I’v decided to copy the content of 4KUYWRBjpMFod9i.cgi to the new dummy cgi file … and it worked….

I guess that the issue was on the encoding of the original cgi…