Technology Errors

PostgreSQL: ERROR: role “user” cannot be dropped because some objects depend on it

When attempting to remove a user role from PostgreSQL it is possible to get an error. This error will be received if the role attempting to be removed still has access privileges for instance SELECT privileges on specific tables. Below I describe the error as well as how to remove access privileges for each table as well as a link to a previous article we wrote that will loop through every table within a specified database and revoke privileges.

Technology Errors

Cannot Update Mailbox /var/mail/root For User Root. Error Writing Message: File Too Large

Earlier today while looking into an issue on a CentOS Linux server I noticed an error message in the maillog file. The mail server running on this Linux server is Postfix and it appeared to have been complaining of the size of root’s mailbox located at /var/mail/root. When I first started investigating I figured I was going to see root’s mailbox at a size of 1GB or 2GB but I was surprised when looking into the issue that root’s mailbox was only about 48MB in size so at first I thought there might be another problem. After some digging around in /etc/postfix I figured out that Postfix limits the size of local mailboxes to 51200000 bytes or 48.8MB. Below is information on how I discovered the issue as well as how to modify the size that Postfix limits local mailboxes to.

Technology Errors

irecovery.exe System Error: The Program Can’t Start Because libusb0.dll Is Missing From Your Computer

The irecovery.exe application is used to communicate with iPhone or iPod Touch devices that are stuck in DFU mode or recovery mode. One thing that needs to be installed for the iRecovery application to work properly is LibUSB-Win32 which can be downloaded and installed for free. The error noted below will be resolved when LibUSB-Win32 has been installed properly.

Technology Errors

Postfix Error: cannot update mailbox /var/mail/root for user root. cannot create file exclusively: No such file or directory

While working on a project unrelated to Postfix on a CentOS server I noticed an error in the mail logs that indicated an issue with the root users mailbox. I have yet to locate the root cause of the problem however I was able to resolve the problem easily. Below I explain the error in more detail as well as how I was able to resolve the problem with sending email to the root users inbox.