Hi! Writing small patch, for support PostgreSQL in PyICQ-t.
Tested with: PyICQ-t 0.8, PostgreSQL 8.1.4, Python 2.4.4, psycopg2 2.0.5.1, ejabberd 1.1.2 Some changes from MySQL backend: * new parameter for backend: "table_prefix" * "encrypt" parameter use utils.encryptPassword / utils.decrypt.Password -- WBW, Unatine mailto:[EMAIL PROTECTED] xmpp:[EMAIL PROTECTED] -------------- next part -------------- A non-text attachment was scrubbed... Name: pyicq-t-0.8-pgsql.patch Type: application/octet-stream Size: 11546 bytes Desc: not available Url : http://modevia.com/pipermail/py-transports/attachments/20061009/a32e0000/pyicq-t-0.8-pgsql.obj From [EMAIL PROTECTED] Mon Oct 9 19:43:06 2006 From: [EMAIL PROTECTED] (Norman Rasmussen) Date: Mon Oct 9 19:43:11 2006 Subject: [py-transports] Stats In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> It's stats time again! Stats from my local MSN install: Using: MSN Transport 0.11.2-dev - SVN r226 / Python2.4.4 - linux (vanilla svn) Uptime 1028760 MessageCount 6737 FailedMessageCount 42 FailedAvatarCount 0 TotalUsers 567 OnlineUsers 7 AvatarCount 0 Here are some interesting stats from a large jabber installation I know of: Using: MSN Transport 0.11-dev - SVN r0 / Python2.4.2 - freebsd5 (probably slightly customised to remove avatars) Uptime 42060 MessageCount 84050 FailedMessageCount 1137 FailedAvatarCount 0 TotalUsers 239832 OnlineUsers 1792 AvatarCount 0 At a rough estimation, that's an average of two messages a second, and more than five logins per second! I _know_ this transport is suffering (jn fact not just the transport), why these guys haven't load balanced their msn transport yet, is beyond me. My only guess is that they can't find a revenue model to support the costs. -- - Norman Rasmussen - Email: [EMAIL PROTECTED] - Home page: http://norman.rasmussen.co.za/ From [EMAIL PROTECTED] Mon Oct 9 20:18:55 2006 From: [EMAIL PROTECTED] (=?ISO-8859-1?Q?Daniel_D=EDaz?=) Date: Mon Oct 9 20:18:59 2006 Subject: [py-transports] Stats In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Alright, these are ours: Statistics for PyMSNt Uptime: 1278300 Message Count: 100312 Failed Message Count: 1042 Failed Avatar Count: 0 Total Connections: 2413 Online Users: 29 Avatar Count: 0 There must be something wrong with avatar count, since we have about 84000 avatars there. That'd be JabberMX.org with SVN from 2006-08-08 23:35:00 -0500, Python 2.3.5, Linux 2.6.15-gentoo-r1 on a Pentium 4 ticking at 1.4 GHz with 768 MB RAM. Greetings! Daniel D?az [EMAIL PROTECTED] xmpp:[EMAIL PROTECTED] On 10/9/06, Norman Rasmussen <[EMAIL PROTECTED]> wrote: > It's stats time again! > > Stats from my local MSN install: > > Using: MSN Transport 0.11.2-dev - SVN r226 / Python2.4.4 - linux > (vanilla svn) > > Uptime 1028760 > MessageCount 6737 > FailedMessageCount 42 > FailedAvatarCount 0 > TotalUsers 567 > OnlineUsers 7 > AvatarCount 0 > > Here are some interesting stats from a large jabber installation I know of: > > Using: MSN Transport 0.11-dev - SVN r0 / Python2.4.2 - freebsd5 > (probably slightly customised to remove avatars) > > Uptime 42060 > MessageCount 84050 > FailedMessageCount 1137 > FailedAvatarCount 0 > TotalUsers 239832 > OnlineUsers 1792 > AvatarCount 0 > > At a rough estimation, that's an average of two messages a second, and > more than five logins per second! I _know_ this transport is > suffering (jn fact not just the transport), why these guys haven't > load balanced their msn transport yet, is beyond me. My only guess is > that they can't find a revenue model to support the costs. > > -- > - Norman Rasmussen > - Email: [EMAIL PROTECTED] > - Home page: http://norman.rasmussen.co.za/ From [EMAIL PROTECTED] Mon Oct 9 21:40:53 2006 From: [EMAIL PROTECTED] (Stian B. Barmen) Date: Mon Oct 9 21:41:06 2006 Subject: [py-transports] Stats In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Is there a manual explaining how to get these stats? Or did you do some log magic? (sorry for asking before googling or rftm ... :) -stian man, 09,.10.2006 kl. 21.43 +0200, skrev Norman Rasmussen: > It's stats time again! > > Stats from my local MSN install: > > Using: MSN Transport 0.11.2-dev - SVN r226 / Python2.4.4 - linux > (vanilla svn) > > Uptime 1028760 > MessageCount 6737 > FailedMessageCount 42 > FailedAvatarCount 0 > TotalUsers 567 > OnlineUsers 7 > AvatarCount 0 > > Here are some interesting stats from a large jabber installation I know of: > > Using: MSN Transport 0.11-dev - SVN r0 / Python2.4.2 - freebsd5 > (probably slightly customised to remove avatars) > > Uptime 42060 > MessageCount 84050 > FailedMessageCount 1137 > FailedAvatarCount 0 > TotalUsers 239832 > OnlineUsers 1792 > AvatarCount 0 > > At a rough estimation, that's an average of two messages a second, and > more than five logins per second! I _know_ this transport is > suffering (jn fact not just the transport), why these guys haven't > load balanced their msn transport yet, is beyond me. My only guess is > that they can't find a revenue model to support the costs. >
