http://dryice.name/blog Tue, 31 Aug 2010 12:01:11 +0000 http://backend.userland.com/rss092 en 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 ... http://dryice.name/blog/freebsd/never-think-your-password-is-complicated-enough/ 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, ... http://dryice.name/blog/postgresql/sqlite-doesnt-support-more-than-one-primary-key-in-one-table/ 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 ... http://dryice.name/blog/python/sqlobject-in-one-file/ postgresql use this kind of table to keep track of sequence. Share This http://dryice.name/blog/postgresql/dont-create-table-with-name-ends-_seq/