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

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 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 change quota’s in an openvz ve:

In the root node :

vzctl set NODE_NUMBER –diskspace hard:soft –save

example:

vzctl set 101 –diskinodes 220000:220000 –save

See:

http://wiki.openvz.org/Resource_shortage

Wow, learned how to do something in emacs that I’ve wanted to do for probably 10 years now.

Replace text with newlines. Here’s how:

when in replace mode, press control-q control-j to insert the newline.

I used replace:

<pre>
on><op></op></pre>

with

<pre>
on>control-q control-j<op></op></pre>

it to fix this ugly html:

<pre>
linux rockslinux rocks the casbahlinux is rad
</pre>

with this:

<blockquote><pre>
linux rocks
linux rocks the casbah
linux is rad
</pre></blockquote>

Of course in real life I had about 50 options I would have had to edit by hand to make it all pretty.

Thanks to http://www.cs.umd.edu/~jspacco/emacs.html

Edit:

/etc/selinux/config

change the line:

SELINUX=enforcing

to:

SELINUX=disabled

Reboot to make the change effective.

Don’t be surprised if cybersource’s php api craps out when calling cybs_run_transaction with any umlauts in the input (card holder name, etc.)

For me I get:

Aborted.

Fun.

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

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.

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.