This article shows how to configure the Apache webserver and a PHP website to optionally use NTLM authentication (Integrated Windows Authentication) to authenticate the website’s users. That means, a user may log in via his or her Windows account but does not have to. If he cannot be logged on…
Today I wanted to log some database output to a text file with UTL_FILE.PUT_LINE but when I called this procedure: CREATE OR REPLACE PROCEDURE writeLog(line varchar2) iS file utl_file.file_type; BEGIN file := utl_file.fopen(‘/tmp’, ‘test.txt’, ‘A’); utl_file.put_line(file, line); utl_file.fflush(file); utl_file.fclose(file); dbms_output.put_line(line); END writeLog; it produced an ORA-29280 error: invalid directory path:…
Today during my morning break I read the following headline from wasteofmind.de: (Rise Against hits the top of the German album charts) So it seems as if “good music” finally made it into the German charts 😉 What I don’t know is whether to be happy about it or not.…
Here’s a small piece of SQL to generate SQL commands for killing all user sessions of a given user (you need to be sys/system): select ‘alter system kill session ”’ || sid || ‘,’ || serial# || ”’;’ from gv$session where username=’USER’ and machine=’PCNAME’;
During the last few weeks I interviewed quite a few candidates for the position as a system administrator in our company (job ad here). But what questions do you ask a prospective administrator to check whether he or she has the needed skills for the job? We needed someone who…
Last week I’ve assembled my newly bought PC. I didn’t want to spend more than 800 EUR so it doesn’t contain the latest bleeding edge technology but on the Windows Experience Index (WEI) it scores 7,4 out of 7,9: The boot time from “power on” to “Windows 7 desktop” is…
In our Active Directory we’ve configured a logon script for the user Administrator but it wasn’t executed after logon. The script’s path was accessible via the network and could successfully be executed manually. However, the problem was that somebody changed the script’s path in the Active Directory account from a…
Wir bei der ALTE OLDENBURGER sind mal wieder auf der Suche nach neuen Kollegen im IT-Bereich (bei uns gern auch “EDV” genannt ;-)). Aktuell suchen wir sowohl eine/n Softwareentwickler/-in als auch eine/n Systemadministrator/-in für eine Festanstellung in Vechta (in unserem schicken Neubau). Auch in 2012 suchen wir wieder neue Mitarbeiter:…
When connecting to a (development) MySQL server from a remote machine (e.g. with Oracle SQL Developer) I got the following error message: Host [my host name] is not allowed to connect to this MySQL server. All user permissions in the mysql.user table were set correctly (host % for user root)…
Today I wanted to roll out Microsoft Office 2010 to a few clients but I needed to get rid of old Office installations on these systems because those could lead to problems while installing the new version. Instead of uninstalling them manually I wrote the following short PowerShell script UninstallOffice.ps1…