All posts by Bob

Simple Invoices password reset

To reset the password of a Simple Invoices user it is necessary to use MySQL.  Passwords are stored as a hash using the MD5 function. Log in to mysql and connect to your database, then:select * from si_user;update si_user set password = MD5(‘newpassword’) WHERE email = ’email@address.com’; www.simpleinvoices.org

ClamAV ScanOnAccess

ClamAV 0.99 supports scan on access, through clamav-daemon (clamd),  Below are instructions for setting this up with Lubuntu 16.04. 1) apt-get install clamav-daemon 2) apt-get install libnotify-bin   (we will use notify-send to send alerts to the desktop) 3) edit /etc/clamav/clamd.confUser root…ScanOnAccess trueOnAccessPrevention yesOnAccessIncludePath /home/user/DownloadsVirusEvent VirusEvent export DISPLAY=:0; /usr/bin/notify-send –icon=error “CLAMD VIRUS ALERT:” “$CLAM_VIRUSEVENT_VIRUSNAME FOUND IN $CLAM_VIRUSEVENT_FILENAME” 4) … Continue reading ClamAV ScanOnAccess

AWStats on Debian Wheezy with Lighttpd

Most documentation for AWStats guides users on configuring Apache web server. Below are some instructions for using AWStats on Lighttpd, based on Debian Wheezy. Unfortunately the Debian package for AWStats places the files in various locations. apt-get install awstats edit /etc/awstats/awstats.conf LogFile=”/var/log/lighttpd/access.log”…LogFormat=1…SiteDomain=”digitalfoundations.com.au” lighty-enable-mod accesslog edit /etc/lighttpd/lighttpd.conf server.modules = (        …        “mod_cgi”)#static-file.exclude-extensions = ( “.php”, “.pl”, “.fcgi” )static-file.exclude-extensions = ( … Continue reading AWStats on Debian Wheezy with Lighttpd

Configure Exim mail server on Debian

Verified on Debian 8 (Wheezy). apt-get install exim4 To support recent IOS devices you need to generate a 2048-bit SSL certificate. Add TCP port 587 to the listening ports by editing /etc/default/exim4. To support local account authentication for SMTP over SSL submission port 587 uncomment out the sslauthd section (ref: https://wiki.debian.org/Exim). Exim defaults to IPv6 before … Continue reading Configure Exim mail server on Debian

Run your own DynDNS server on Debian Linux

This outline assumes you own your own domain and manage the DNS servers running Debian Wheezy or Jessie with: bind9 for DNSlighttp for webserverphp5apt-get install bind9 – configure your zone. apt-get install lighttp php5-cgi Configure SSL: lighty-enable-mod ssl openssl … Configure authentication: lighty-enable-mod auth echo username:realm:`md5sum password | cut -b -32` >> /etc/lighttpd/.htpasswd/htdigest.userEnable PHP: lighty-enable-mod fastcgi lighty-enable-mod fastcgi-php Configure Virtual Hosting: lighty-enable-mod simple-vhost mkdir … Continue reading Run your own DynDNS server on Debian Linux

Installing Horde on Debian Jessie

Below is a guide to installing Horde mail & groupware server on Debian Jessie.  Starting with base system already installed: Install the Email server (MTA):We need a working mail system, here we use sendmail with dovecot providing IMAP: apt-get install sendmail Configure domain & SMTP settings: nano /etc/mail/local-host-names   mydomain.com nano /etc/sendmail.mc   MASQUERADE_DOMAIN(mydomain.com) make -C /etc/mail /etc/init.d/sendmail reload Install an IMAP … Continue reading Installing Horde on Debian Jessie

Automate PDF printing from batch file command line

Adobe Reader is not suitable for printing PDF files using a batch file because it remains open after the print is done and there is no simple, safe & reliable mechanism to close it.  Instead use Ghostscript commandline as shown below: gswin32c -dPrinted -dBATCH -dNOPAUSE -dNOSAFER -q -dNumCopies=1 “C:\test.pdf” *Must be a recent version of … Continue reading Automate PDF printing from batch file command line

GParted does not start in LXQt

Symptom: Clicking on GParted launcher has no effect. Log /var/log/messages shows:  The value for environment variable TERM contains suscipious content … The cause was having set the TERM variable using LXQt Session Settings, Default Applications, Terminal Emulation to /usr/bin/lxterm.  Changing back to xterm and logging out-in fixed the issue.