Skip to content

Never think your password is complicated enough

Last week I was asked to help a friend to check out his server that has been hacked. First I was thinking some kind of PHP leak or SQL injection. But I was wrong. The crack uses some kind of SSH user/password scanner and got his root password.
I find this out because the cracker created […]

Posted 21 April 2008 § freebsd ‡ Comments (0)

sqlite doesn’t support more than one primary key in one table

This cost me several hours today.
Postgresql support multiple primary keys in one table, and I took granted that sqlite does the same thing when I did some prototype today.
And they have a good reason explained in the SQLite CVSTrac.
The odd thing is, if I specify two primary keys in sqlite, it won’t complain when creating […]

Posted 28 August 2006 § postgresql ‡ Comments (0)

sqlobject in one file

Looks if two SQLObject class got reference to each other, i.e,
ForeignKey
, they should stay in the same file. Else the generated reference column name will get messed up and causing problem. This is where I wasted 3 hours today
Also the column name should be in mixedCase instead of
MixedCase
. This should be a bug […]

Posted 17 May 2005 § python ‡ Comments (0)

don’t create table with name ends "_seq"

postgresql use this kind of table to keep track of sequence.

Share This

Posted 14 June 2004 § postgresql ‡ Comments (0)
Close
E-mail It