Loading...
Insights, updates, and deep dives into cybersecurity, cloud technology, and AI innovation.
To delete records where only a field is duplicated, we can use a similar technique to the general duplicate removal technique: CREATE TABLE temp AS SELECT DISTINCT ON (email) * FROM table_to_deduplicate; DROP TABLE table_to_deduplicate; ALTER TABLE temp RENAME TO table_to_deduplicate; Be mindful of the fact that this process will not preserve the constraints on […]
This solution was given to us by the Ensim staff, as a paid support request. Hopefully, if you’re reading this, you will not have to buy a support ticket: To delete the sites manually you will have to do the following: 1. Find the siteID. sitelookup -d domainname 2.cd /etc/virtualhosting/mappings/ grep siteID * 3. Remove […]
AIX has a neat feature that allows to manage a system completely from a browser interface. Since AIX 6.1 TL3, this interface runs on port 80, which makes it easy to find it. However there might be several reasons one might not want to run the AIX Web Based System Manager. For example: Something else […]
To be able to report SPAM, Viruses, or any other problem with email, the system administrators need the full email headers. These can be easily found in Netscape or Mozilla Thunderbird, just by viewing the raw message source, or by selecting View Full Headers in the View menu. However in Outlook 2003 it is a […]
Here are the links to a number of Jahia README files: http://www.jahia.org/download/jahia4/4_0/update/readme.txt http://www.jahia.org/download/jahia4/4_0/patch/README_4_0_1.html http://www.jahia.org/download/jahia4/4_0/patch/README_4_0_2.html http://www.jahia.org/download/jahia4/4_0/patch/README_4_0_3.html http://www.jahia.org/download/jahia4/4_0/patch/README_4_0_4.html http://cvspub.jahia.org/cgi-bin/cvsweb.cgi/jahia/src/views/html/startup/Attic/readme.html?rev=1.68&content-type=text/html
IP audit web is an excellent tool to monitor traffic on a given interface, and create daily and monthly statistics. It is really made of 2 components: – IPAudit – IPAudit-web As of this writing the latest version is IPAudit-Web-1.0BETA9. It contains both packages bundled. Here are the steps to follow: wget http://umn.dl.sourceforge.net/sourceforge/ipaudit/ipaudit-web-1.0BETA9.tar.gz tar xvzf […]
From the command line, as the root user, run: # perl -MCPAN -e shell And then at the cpan command line run: cpan> install Module::Name Alternatively, using sudo on one line, as any user you can directly intall a module by running: sudo perl -MCPAN -e ‘install Module::Name’
Bruce Guenter’s cvm librairies use Linux style sockets. That is usually fine on OpenBSD, except that the cvm_udp code opens a socket, and then uses sendto() which implicitly reoppens the socket. OpenBSD doesn’t like that, so here is the patch to fix cvm-0.18: — client.c.org Fri Feb 20 12:07:55 2004 +++ client.c Fri Feb 20 […]
I found this solution on the misc@ list, and just slightly had to update it: Getting Perl/CGI to work in a chroot’d Apache environment : Intentions Let me start off by saying that allowing Perl/CGI in a server environment is generally a not good idea, unless you like to spend all of your time auditing […]