Re: Need advices for mysqldb connection best practice

2011-01-21 Thread Romaric DEFAUX
Le 20/01/2011 18:58, Dennis Lee Bieber a écrit : On Thu, 20 Jan 2011 10:04:12 +0100, Romaric DEFAUX declaimed the following in gmane.comp.python.general: So , I thought about some solutions : - restarting the server every sometimes (but it's the worst solution in my mind) - creat

Need advices for mysqldb connection best practice

2011-01-20 Thread Romaric DEFAUX
Hi all, I've a problem with a mysql connection. I run a client/server application. Every hour, clients contact the server, send datas, and the server updates the database. Everything works perfectly. But after a while, I get in trouble with my db connection. I've got the impression my server

Re: Encoding trouble

2010-12-15 Thread Romaric DEFAUX
Le 15/12/2010 14:16, Benedict Verheyen a écrit : On 15/12/2010 12:34, Romaric DEFAUX wrote: To create these query, I do this : query = "UPDATE website SET client_name='%s' WHERE ip='%s'" % (self.client_name, self.ip) then self.cursor.execute(query) Unicode ca

Encoding trouble

2010-12-15 Thread Romaric DEFAUX
Hi all, Since yesterday I'm working on an encoding problem, I become crazy now :) Could you please help me ? Here's the description of the problem : I've got two table in a MysqlDB : history_website and website The important column in them are : history_website.message (varchar(255), encoding

Re: Pickle in a POST/GET request give EOFError

2010-11-18 Thread Romaric DEFAUX
Hi answer to myself :) With str(unicode_string) ! Le 18/11/2010 12:23, Romaric DEFAUX a écrit : Sorry for this stupid question, but how can I convert unicode to string. I ask that because I hit an error (perhaps a bug) in mod_wsgi, and that crash the apache process : TypeError: sequence of

Re: Pickle in a POST/GET request give EOFError

2010-11-18 Thread Romaric DEFAUX
child pid 16211 exit signal Segmentation fault (11) Romaric Defaux Le 18/11/2010 11:26, Michael Ricordeau a écrit : When loading from json datas with simplejson, strings are unicode . Le Thu, 18 Nov 2010 11:22:30 +0100, Romaric DEFAUX a écrit : Hi again, I try simplejson, but I have a

Re: Pickle in a POST/GET request give EOFError

2010-11-18 Thread Romaric DEFAUX
ot;52428800"}, {"name": "disk2", "size": "647648"}] >>> disk_list2 = simplejson.loads(disk_list_json) >>> print disk_list2 [{u'name': u'disk1', u'size': u'52428800'}, {u'name':

Re: Pickle in a POST/GET request give EOFError

2010-11-18 Thread Romaric DEFAUX
on< 2.6) Regards Le Thu, 18 Nov 2010 09:29:00 +0100, Romaric DEFAUX a écrit : Le 17/11/2010 18:52, geremy condra a écrit : On Wed, Nov 17, 2010 at 6:44 AM, Romaric DEFAUX wrote: Le 16/11/2010 17:47, Romaric DEFAUX a écrit : Hi everybody ! First time I wr

Re: Pickle in a POST/GET request give EOFError

2010-11-18 Thread Romaric DEFAUX
Le 17/11/2010 18:52, geremy condra a écrit : On Wed, Nov 17, 2010 at 6:44 AM, Romaric DEFAUX wrote: Le 16/11/2010 17:47, Romaric DEFAUX a écrit : Hi everybody ! First time I write to this mailing list :) I started writing in python last week, that's probably why I can't

Re: Pickle in a POST/GET request give EOFError

2010-11-17 Thread Romaric DEFAUX
Le 16/11/2010 17:47, Romaric DEFAUX a écrit : Hi everybody ! First time I write to this mailing list :) I started writing in python last week, that's probably why I can't understand the following problem... I create a list called web_site_list. This list contain dictionar

Pickle in a POST/GET request give EOFError

2010-11-16 Thread Romaric DEFAUX
x27;servername\'\np4\nS\'default\'\np5\nsS\'client\'\np6\nS\'undefined\'\np7\nsS\'documentroot\'\np8\nS\'/var/www/\'\np9\nsS\'client_contact\'\np10\ng7\nsS\'serveralias\'\np11\n(lp12\nsa. It's the "pickled view" of [{'documentroot_size': '120', 'servername': '---default---', 'client': 'undefined', 'documentroot': '/var/www/', 'client_contact': 'undefined', 'serveralias': []}] Can someone help me please ? I spend my afternoon to google to try to find a solution... Thanks in advance !!! Romaric Defaux smime.p7s Description: S/MIME Cryptographic Signature -- http://mail.python.org/mailman/listinfo/python-list