Things I tend to forget


Generate a random password in bash

Here’s a quickie that Feliscimo sent me:

< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c8

Similar Posts:

    None Found




AWStats for one or more domains

The documentation is per http://awstats.sourceforge.net/docs/awstats_setup.html

Here’s quick HOWTO, where I assume you have installed awstats using apt-get or rpm:
Copy the file /etc/awstats/awstats-dist.conf to /etc/awstats/awstats.mydomain.com.conf and changed the domain name there to fit the new site.

Then run the following command:
[root@funinc ~]# perl /usr/local/awstats/wwwroot/cgi-bin/awstats.pl -config=mydomain.com -update
(you may need to find the awstats.pl script, on debian /usr/lib/cgi-bin/awstats.pl)

Awstats creates a new set of files for the new site in its database.

Added the following line to your crontab file:
12 00 * * * perl /usr/local/awstats/wwwroot/cgi-bin/awstats.pl -update -config=mydomain.com

basically this will tell awstats to generate a new set of reports for the mydomain.com site daily (at 12 noon!)

That’s it, go to http://mydomain.com/awstats/awstats.pl?config=mydomain.com

The apache configuration for debian:

Alias /awstatsclasses "/usr/share/awstats/lib/"
Alias /awstats-icon/ "/usr/share/awstats/icon/"
Alias /awstatscss "/usr/share/doc/awstats/examples/css"
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
ScriptAlias /awstats/ /usr/lib/cgi-bin/
Options ExecCGI -MultiViews +SymLinksIfOwnerMatch

Similar Posts:




Grooming

It’s just so funny to watch

Cleaning up!

Similar Posts:




Email to user@ip address

And I found the answer in this post:
http://www.irbs.net/internet/postfix/0406/2819.html

Basically it says:
To mail to IP address, use IP literals, such as user@[72.249.191.48]

You might also what to look at the following post for related info as well:
http://www.cyberciti.biz/faq/postfix-receive-mail-on-specific-network-interfaces/

Similar Posts:

    None Found




The perfect bed

  • June 13, 2008
  • Cat

The boss chose a new bed today. A pile of my shirts waiting for laundry

Similar Posts:

    None Found




Hierarchy in SQL

from this blog post

CREATE TABLE Tree (
Node int NOT NULL IDENTITY(100, 1),
ParentNode int,
EmployeeID int NOT NULL,
Depth tinyint,
Lineage varchar(255) )
UPDATE Tree SET Lineage='/', Depth=0 WHERE ParentNode Is Null
WHILE EXISTS (SELECT * FROM Tree WHERE Depth Is Null) 
   UPDATE T SET T.depth = P.Depth + 1, 
   T.Lineage = P.Lineage + Ltrim(Str(T.ParentNode,6,0)) + '/' 
   FROM Tree AS T 
   INNER JOIN Tree AS P ON (T.ParentNode=P.Node) 
   WHERE P.Depth>=0 
   AND P.Lineage Is Not Null 
   AND T.Depth Is Null
SELECT Space(T.Depth*2) + E.Name AS Name
FROM Employees E
INNER JOIN Tree T ON E.EmployeeID=T.EmployeeID
ORDER BY T.Lineage + Ltrim(Str(T.Node,6,0))
Alternatieven zij ontvangen een goede bescherming van elementen voor visit page beter postrecurrence. Door mensen die baat hebben viagra vervanger bij andere.

Similar Posts:




Apt-get update hangs on RHEL

If you’re using apt to manage your software installations on a redhat based machine, especially to make use of the rpmforge repository and tools, you might get this error.

Description:

I start apt-get update.  After a while, it gets to the apt.sw.be and hangs at a certain %. You cannot stop it as it hogs the CPU. (hint. login using console and kill it?)

The problem seems to be related to the /etc/apt/sources.list.d/rpmforge.list file. Simply comment out the repomd line and let it use the rpm line as follows:
rpm http://apt.sw.be redhat/el$(VERSION)/en/$(ARCH) dag
#repomd http://apt.sw.be redhat/el$(VERSION)/en/$(ARCH)/dag

This seems to affect rhel4/fedora servers.

Similar Posts:




MySQL Tuning

I’ve always felt it was a hassle to gather the data needed for tuning mysql, let alone interpret it. Here’s a great tool to do just that: the MySQL Performance Tuning Primer Script. From the page:

Currently it handles recomendations for the following:

  • Slow Query Log
  • Max Connections
  • Worker Threads
  • Key Buffer
  • Query Cache
  • Sort Buffer
  • Joins
  • Temp Tables
  • Table (Open & Definition) Cache
  • Table Locking
  • Table Scans (read_buffer)
  • Innodb Status
  • Similar Posts:




    Php5.2 on RHEL4

    Setting up the latest (as of June 2008) php on a RHEL4 server (the same would work on RHEL5 or CentOS as well):

    Similar Posts: