compiling ezmlm on centos 5.x (tls errors and more)

getting killed by:

usr/bin/ld: errno: TLS definition in /lib/libc.so.6 section .tbss mismatches non-TLS reference in substdio.a(substdo.o)
/lib/libc.so.6: could not read symbols: Bad value

?

phew…

man…

ok, here’s how to get this crap to compile:

untar it, etc
cd to the dir

then:

echo gcc -O2 -include /usr/include/errno.h > conf-cc
echo cc -m32 -O2 -include /usr/include/errno.h >> conf-cc
echo cc -m32 >conf-ld

(these are just files in the current dir)

add :

#include “log.h”

to :

ezmlm-manage.c

and

ezmlm-return.c

(thanks to: http://lists.freebsd.org/pipermail/freebsd-ports-bugs/2003-August/009785.html for that little tidbit)

make

it should work

This fixes the following errors:

ezmlm-manage.c: In function âmainâ:
ezmlm-manage.c:320: warning: incompatible implicit declaration of built-in function âlogâ
ezmlm-manage.c:320: error: incompatible type for argument 1 of âlogâ
ezmlm-manage.c:320: error: too many arguments to function âlogâ
ezmlm-manage.c:331: warning: incompatible implicit declaration of built-in function âlogâ
ezmlm-manage.c:331: error: incompatible type for argument 1 of âlogâ
ezmlm-manage.c:331: error: too many arguments to function âlogâ
ezmlm-manage.c:135: warning: return type of âmainâ is not âintâ

and

/usr/bin/ld: errno: TLS definition in /lib/libc.so.6 section .tbss mismatches non-TLS reference in substdio.a(substdo.o)
/lib/libc.so.6: could not read symbols: Bad value

also see:

http://fixunix.com/plan9/353463-re-9fans-plan9-httpd-pegasus-unix.html

towards a perfect fedora 8 desktop

yum -y install unrar gnome-applet-netspeed azureus ntfs-config filezilla

wget http://www.mjmwired.net/resources/files/msttcorefonts-2.0-1.noarch.rpm

MySQL 5 Left Joins not working – CodingForums.com

Mysql Upgrade – left joins not working?

If you are getting an error like:

Unknown column ‘i.blah’ in ‘on clause’

using a left join like:

FROM items_table AS items, meta_data_table AS md, categories_table AS cat LEFT JOIN restricted_table AS rst ON items.item_id=rst.item_id WHERE items.title LIKE ‘the%’

switch the order of the from around so that the item MySQL is complaining about is at the end of the from clause. That should fix it in many cases.

how to disable selinux for redhat enterprise

Edit:

/etc/selinux/config

change the line:

SELINUX=enforcing

to:

SELINUX=disabled

Reboot to make the change effective.

converting an entire mysql server to not use isam files

So you’ve got a mysql server with an unknown number of isam tables and you need to convert them (the easy way)? Here’s how:

find /var/lib/mysql/ -name “*.ISM” -print > convert.txt

emacs convert.txt

replace: “/var/lib/mysql/” with “alter table “

replace “.ISM” with ” type = myisam;”

replace “/” with “.”

Be careful to include the spaces where I have them.

The run:

mysql -u root -p < convert.txt

How to modify return-path header in php mail function

Normally the return path is set by sendmail (or whatever the server is running, qmail, etc.)

However you can pass a fifth argument to php’s mail function to reset it to what you want. Here’s an example:

$result = mail($to, $subject, $body, “From: $from\n”, “-f$from”);

make sure you do not put a newline in after the fifth argument’s from. php will error out.

update to apache 1.3.37 no worky with ssl? here’s your fix

When updating from apache 1.3.33 to higher versions (at least 1.3.37) you need to change all occurances of:

SSLCertificateChainFile

to

SSLCACertificateFile

All fixed.

keeping ssh key passphrase loaded when re-attaching a screen session

So for years I’ve lived with the problem of not having my ssh key passphrase loaded when I re-attach a screen session.

Today I finally, figured out how to fix this. When you log into the new ssh session, do not enter the passphrase, just control-c out of it. Then do screen -r -d like normal, you’ll find that your key is still loaded.

i love cli

fun command line:

for f in  `cat  /usr/local/apache/logs/suexec_log | cut -d” ” -f 6 | cut -d”/” -f1 | cut -d”(” -f2 | sort | uniq` ; do grep $f  /usr/local/apache/logs/suexec_log | wc -l; echo -n $f; done   | sort | tr -s ‘ ‘ | sort +1 -n

tells you who is running the most su_exec’d stuff.

(if you cut and paste this from the blog you’ll need to fix up the quotes – wordpress screws them up somehow in when copy and pasting)