Postfix rsyslog

Im using rsyslog with postfix.
Here some confs.

DROP TABLE IF EXISTS `Smtpd`;
CREATE TABLE IF NOT EXISTS `Smtpd` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ReportedTime` datetime NOT NULL,
  `MessageTime` varchar(40) NOT NULL,
  `Host` text NOT NULL,
  `Process` varchar(40) NOT NULL,
  `ProcessID` int(11) NOT NULL,
  `Message` text NOT NULL,
  `ClientHost` varchar(255) NOT NULL,
  `ClientIP` varchar(15) NOT NULL,
  `MailFrom` varchar(255) NOT NULL,
  `MailTo` varchar(255) NOT NULL,
  `MessageID` varchar(40) NOT NULL,
  `Status` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1453 ;

Postfix config

My postfix config.

#---------------------------------------------#
queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
data_directory = /var/lib/postfix

Crontab problem

I have a problem with working crontab.

With this, cron didnt work.

root@# crontab -l

mysqldump -u user --password='password' -R --lock-tables  db |  gzip -c > "/home/bak/db_$(date +%F).sql.gz"

'man crontab'

The sixth field of a line in a crontab file is a string that

is  executed  by the shell at the specified times. A percent

character in this field (unless escaped by \) is  translated

to a NEWLINE character.

Now, i escaped percent character:

root@# crontab -l

mysqldump -u user --password='password' -R --lock-tables db | gzip -c > "/home/bak/db_$(date +\%F).sql.gz"

Its work.

mysql Ruby

I've tired to install mysql Ruby libraries.
With this option, gem'll install mysql in /tmp directory.
Before run this, make sure u've install development tools like make,gcc, etc.

1. root: gem install mysql -i /tmp/ruby-mysql/ -- --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib   --with-mysql-include=/usr/local/mysql/include --with-mysql-config=/usr/local/mysql/bin/mysql_config

If u've problems after this installation, try to add
/usr/local/mysql/lib to /etc/ld.so.conf and run ldconfig.
This works fine for me.

subversion problem

'db/transactions/3-1.txn': Permission denied if u see this when u working with svn: 1. check permissions and ownership for svn directory 2. check SElinux/Apparmor 3. dunno

.Xdefaults

My .Xdefaults
Slackware 12.2


urxvt*font: xft:monospace:pixelsize=12:antialias=false
URxvt*termName: xterm
URxvt*geometry: 115x33
URxvt*transparent: true
URxvt*tintColor: grey
URxvt*highlightColor: white
URxvt*shading: 30
URxvt*fading: 20

another way to make iso

dd if=/dev/cdrom of=/home/omi/file.iso bs=65535 conv=noerror cat /dev/cdrom > /home/omi/file.iso