Entries by Stefan Helander

Ispconfig not processing job queue – spamfilter_policy error

Suddenly some of my slave servers stopped processing the job queue. Ispconfig version 3.2.9. Investigating the log files. /var/log/ispconfig/cron.log shows: PHP Fatal error:  Uncaught mysqli_sql_exception: Data truncated for column ‘warnvirusrecip’ at row 1 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302 See this discussion: https://forum.howtoforge.com/threads/uncaught-mysqli_sql_exception-data-truncated-for-column-warnvirusrecip-at-row-1.90116/ This is how I solved it. On the master server: mysqldump -uroot -p –add-drop-table dbispconfig spamfilter_policy […]

CloudLog gives ‘Access denied’

Checking to web server logs reveals: Got error ‘Access to the script ‘/var/www/XXX/web/logbook’ has been denied (see security.limit_extensions)’ The URL of the logbook showed https://DOMAIN/index.php/logbook Solution Add the following to php.ini for the site: cgi.fix_pathinfo=1

Joomla! breadcrumbs module caching problem

I’ve hade problems with the Joomla! breadcrumbs module being cached, so the wrong breadcrumb is being displayed. The problem is that the module is being cached. This has been reported as a bug and it has the status as being fixed. However, in an old Joomla! install, which is updated to the latest version, I […]

Zoneminder 1.37 no image – capturing but not analyzing

Zoneminder version 1.37.28. The installation had been running for years without problem but somehwere in the 1.37 version problems started to occur. Some cameras did not give visible streams in Zoneminder from time to time. Checking the cameras video directly, they where ok, so the problem was in Zoneminder. Some cameras was “capturing” but analyzing […]

Nagios check_vnc without authentication

If you need to monitor a VNC service without logging in, the following check_command can be used. Edit your nagios configuration file and add: # VNCdefine command{ command_name check_vnc command_line $USER1$/check_tcp -H $HOSTADDRESS$ -p $ARG1$ -w 5 -c 8 -e “RFB”} Then on the service you want to monitor use: define service{ use generic-service ; […]

Running HP EliteDesk 800 G1 USDT on 13.8 volts DC

I got a HP EliteDesk 800 G1 USDT Ultra Slim Desktop computer for my ham schack. This is a small computer running on an external power supply just lika a laptop. It turned out to be the major source of RFI in my ham schack.

I suspected the power supply was the culrpit as those are switched ones and thought it might be possible to run the computer directly on my 13.8 VDC power supply that I use for my radios. The only voltages used in a computer is 12 and 5 volts, so there is probably a voltage regulator on the power input that regulates the voltage down from the 19 volts DC that the power supply outputs. Will it also run on 13.8 VDC?

Ispconfig3 certbot is not renewing certificates (Ubuntu 20)

When creating a new site, a valid certificate was issued but when expiring they where never renewed. Investigating /etc/letsencrypt directories was missing the usual subfolders, like live for example. It turned out the server had both acme.sh and certbot installed. The solution was to remove certbot. Investigate if the directory /root/.acme.sh exists and it’s contents. […]