Jun 14 2007

Suexec on Debian

Load the suexec module and restart Apache.

a2enmod suexec
/etc/init.d/apache2 force-reload

Jun 14 2007

Bug in automysqlbackup script

There is a bug in the MySQL Backup Script v2.5 from http://sourceforge.net/projects/automysqlbackup/, triggered by database name containing spaces. I fixed it by using quotes in the dbdump function:

# Database dump function
dbdump () {
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT "$1" > "$2"
return 0
}

Jun 12 2007

Command Line Catalog Reconfiguration with sudo

Users can use the Interchange administration interface (UI) for reconfiguring their catalog. Alternatively, you can configure sudo to allow users running interchange from the commandline:

sudo -u interchange /usr/sbin/interchange --reconfig=linuxia

Add the following line to your sudoers file with visudo to give permission to do so:

racke LOCAL = (interchange) NOPASSWD: /usr/sbin/interchange --reconfig=linuxia

Jun 06 2007

Delays on Email Delivery

To avoid unnecessary DNS lookups for the hostname of the machine, define primary hostname:

primary_hostname = linuxia.de

Or you can use on of the alternatives described at:

http://wiki.debian.org/PkgExim4UserFAQ#head-9df4f560713a5f58d5cdb9fdf230...

Apr 18 2007

Typical Permissions for Queue Users

CommentOnTicket - add comments to tickets
CreateTicket - create tickets
ModifyTicket
OwnTicket
ReplyToTicket - add replies to a ticket
SeeQueue - queues will appear in visible listings for this user (like "New Ticket")
ShowTicket - see tickets
ShowTicketComments - see comments attached to tickets
TakeTicket

Mar 20 2007

.htaccess errors

Drupal needs extensive permissions in .htaccess. If you encounter an Internal Server Error by Apache and the following error in the Apache logfile:

/var/www/drupal/.htaccess: Option Indexes not allowed here

The solution is to grant Drupal every permission:

<Directory /var/www/drupal>
AllowOverride all
</Directory>

Mar 20 2007

Mounting Shares from win2k3 DCs

This isn't possible with smbfs (see Samba mailinglist).
The solution is to mount with cifs like that:

//server/share /local/dir cifs credentials=/etc/local/creds,ip=192.168.0.200

Mar 09 2007

Discussion with pj about [search] Usertag in Action Maps

Action maps are a nice way in Interchange to turn human readable links into Interchange searches.

The required syntax for triggering a search is far from nice:

$CGI->{co} = 1;
$CGI->{fi} = 'products';
$CGI->{st} = 'db';
$CGI->{sf} = join "\0", 'prod_group', 'category';
$CGI->{op} = join "\0", 'eq', 'eq';
$CGI->{se} = join "\0", $prod_group, $category;
$CGI->{sp} = 'results';
$CGI->{mv_todo} = 'search';
$Tag->update('process');
return (1, 'results');

Mar 08 2007

Java Script

Confirm on a link:

onclick="return confirm('foo')";