I had been scouring the web this morning looking for a way to get the hostname of the server in my e-mails without hard-coding it into my action.d scripts (e.g. mail.conf, mail-whois.conf, etc.). The fail2ban wiki was not much help in this regard. In fact, somebody had posted this exact request on the community page, but it seems as though this request has not gone through. But, alas, I found a solution that’s not ideal, but isn’t the horrible must hard-code my hostname into every action.d script.
Read more…
Systems Administration
e-mail, fail2ban, security, ssh, Systems Administration
I’ve been moving the databases at work from one Microsoft SQL 2005 server to another SQL 2005 Server. When the databases grant security to non-domain users, they have a tendency to not be attached / accessible on the new server. What you have to do is reattach / rejoin the orphaned security authorization to the credential that you reestablish on the new SQL Server. This is done with the following pl_Sql command:
sp_change_users_login 'Auto_Fix'
sp_change_users_login 'Update_One', 'old_username', 'new_username'
Auto_Fix can only be used if the old_username and the new_username are the same.
Uncategorized
security, sql, stored procedures
Recent Comments