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

mysql: grant all privileges on test.* to ‘root’@’localhost’ identified by ‘s3kr1t’

The below is part of the output when receiving an error attempting to install the Perl DBD::mysql module using the CPAN shell. I rarely use the Perl CPAN shell since most of the packages are available on CentOS, my typical Linux distribution choice for servers, using the yum package manager. In this case I was working on installing Monarch on a server at work to assist with Nagios file management. Monarch allows you to backup the entire Nagios configuration files with the click of a button. Monarch will also provide a visual view of any Nagios build errors, Nagios configuration files (including users, user groups, services, check commands, etc.,), and more. So when attempting to build the Perl DBD:mysql module via the CPAN shell I received some errors which I initially did not understand because they did not explain the specific issue however I eventually located the problem which ended up being easy to resolve. Below I describe the error in detail as well as information on how to resolve.

Technology Insights

CentOS Linux Error: -bash: traceroute: command not found

You may receive the below error on a Linux server which is caused by traceroute not being installed. The chances are that if traceroute is not installed that the tracepath package is installed. The difference between the two is that tracepath does not require superuser privileges and traceroute does require super user privileges. Below is information on the traceroute error, how to install traceroute using yum on CentOS Linux, or how to alternatively use tracepath instead of traceroute.