HOWTO: Fix Windows Vista - The trust relationship between this workstation and the primary domain failed
Posted by Mr. IT Guy | Filed under IT in General, Microsoft, Operating System
For some unknown reason, one of my colleague gets this message everytime he’s trying to login:
“The trust relationship between this workstation and the primary domain failed”
Instead of deleting his profile and recreating it as proposed by most people, I just try to rejoin it to the domain. It works! Step by Step instruction is available after the jump. Read the rest of this entry »
Tags: domain, Howto, SYSTEM, trust relationship, Vista, windows
HOWTO: Grab List of Installed Packages using dpkg
Posted by Mr. IT Guy | Filed under IT in General
Grab the package by running:
dpkg --get-selections > packages.installed
Tags: debian, dpkg, Howto, Linux, package, ubuntu
HOWTO: Log Apache to MySQL on Ubuntu 8.04 (Hardy Heron)
Posted by Mr. IT Guy | Filed under Howto, Linux, Operating System
Installing the Software
Run the following commands in terminal:
sudo apt-get update sudo apt-get install libapache2-mod-log-sql-mysql libapache2-mod-log-sql libapache2-mod-log-sql-ssl
Create DB & User
Run the following commands in MySQL:
CREATE DATABASE apachelogs; GRANT INSERT,CREATE ON apachelogs.* TO apachelogger@localhost IDENTIFIED BY 'insert_passwd_here'; FLUSH PRIVILEGES;
Add Entry to apache2.conf
Add the following entry to apache2.conf before the VirtualHost settings (commonly before
Include /etc/apache2/sites-enabled/):
LogSQLLoginInfo mysql://apachelogger:insert_passwd_here@localhost/apachelogs
LogSQLCreateTables on
LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock
LogSQLTransferLogFormat AabfHhmRSsTUuvIModify Each Virtual Host
For each virtual host that you want to log to SQL, add the following line:
LogSQLTransferLogTable this_site_com
where access_log is replaced by any table name; to differentiate many different virtual host, you can use the name of each virtual host here by replacing each dot (’.') with underscore (’_')