Systems Administration Problem Solvers

Category: Random UNIX Related Items

  • Process Sendmail clientmqueue

    You have emails stuck in clientmqueue that are stuck because of a prior sendmail issue. To process all e-mails in the clientmqueue:   sendmail -Ac -q -v Manually flush clientmqueue: sendmail -Ac -q -v

  • vCSA Postgres Database Repair – PANIC: checksum mismatch

    You are confronted with various database errors in the /var/log/vmware/vpx/vpxd.log and you also have various errors in /storage/db/vpostgres/pg_log Similar in theme to: error ‘Default’ opID=HB-host-8637@82541-3778684f] [VdbStatement] SQLError was thrown: “ODBC error: (00000) – ” is returned when executing SQL statement error ‘Default’ opID=HB-host-8637@82541-3778684f] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] […]

  • FreeBSD – Upgrade Perl Version

    To upgrade the version of Perl installed on a FreeBSD server: vi /etc/make.conf Add this line (adjust for Perl version): DEFAULT_VERSIONS+=perl5=5.22 Execute on command line (adjust for Perl version): pkg set -o lang/perl5.16:lang/perl5.22 Execute on command line (adjust for Perl version): portupgrade -o lang/perl5.22 -f perl-5.16.\* Execute on command line: portupgrade -rf perl*

  • Interspire Email Marketer Can’t Login

    You all of the sudden cannot login to Interspire Email Marketer. You are entering the correct password and the login screen refreshes when you enter the correct login details but will not allow access to the admin panel. Your problem is the session cannot be saved. Check your php.ini file to ensure the location for […]

  • XymonQV – Xymon Android App

    Upon purchasing a new phone, I discovered that XymonQV was no longer in the Google Play store and the link on GitHub was 404. I was able to export the installed app from an old phone. If you need the XymonQV Android App, you download it here:   XymonQV Android App This is a copy of […]

  • Stolen Motorola Moto G Second Generation

    Dual SIM Motorola Moto G Second Generation IMEI:  353326061401933 IMEI:  353326061401941 The phone was stolen in France. Police report on file.

  • SSHD mm_request_send: write: Broken pipe

    You are attempting to login to a Linux machine (probably CentOS) and your SSH sessions are instantly disconnected. /var/log/secure shows various Signal 15 crashes and this error: mm_request_send:  write:  Broken pipe Your box has been hacked.    Format and Reinstall. Be sure to run “yum update” at frequent intervals to keep your servers/VMs up-to-date!!     […]

  • Connect Error (2000) mysqld cannot connect to MySQL 4.1+ using old authentication ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused

    You are receiving these errors: Connect Error (2000) mysqld cannot connect to MySQL 4.1+ using old authentication ERROR 1275 (HY000): Server is running in –secure-auth mode, but ‘dbname’@’localhost’ has a password in the old format; please change the password to the new format ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option […]

  • Convert squid log timestamps to human readable

    Convert squid log timestamps to a human readable format: cat access.log | perl -p -e ‘s/^([0-9]*)/”[“.localtime($1).”]”/e’

  • Shell Script Remove All Blank Links

    Use the following ‘awk’ command to remove all blank lines from a file: awk ‘NF > 0’ filename