Re: AuthKit bails out on Unicode usernames

2007-05-29 Thread David Smith
James Gardner wrote: > > Is it considered standard practice to allow > non-ascii usernames though? Particularly since usernames are supposed to > be case-insensitive in AuthKit? I'd like to make allowing non-ascii usernames standard practice, trying to make pylons i18n the best possible. Accor

Re: Migrations like database evolution tool?

2007-05-29 Thread David Smith
I've used migrate for a project before; it has some rough spots but it does work. That being said, it's usefulness is debatable. Cheers, David Neil Blakey-Milner wrote: > > On 5/28/07, Brendan Arnold > <[EMAIL PROTECTED]> wrote: >> Is there at present a database evolutions tool similar to migr

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread David Smith
jj, I actually agree strongly with you regarding the potential dangers. My counter argument is that if you specify the encoding of the database in the config file to a different encoding than is in the mysql config file, don't you risk double-encoding anyway? Now that the bug is fixed in MySQLdb,

Pylons deployment methods

2007-05-29 Thread voltron
This is another of my "what is the best way" questions. I would like to deploy my Pylons application without headaches on my clients server. This would mean my app with its templates and creating the database. A while back, Dan posted that he had init code in websetup.py and he called this at the

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread Max Ischenko
Hi David, On 5/29/07, David Smith <[EMAIL PROTECTED]> wrote: > > > Max, I have no problems by only using Unicode field-types in my model; > that > is, my sqlalchemy connection string does not contain anything related to > UTF-8. I haven't investigated my MySQL setup so thoroughly but it seems to >

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread David Smith
Hi Max, thanks for the quick response, Max Ischenko wrote: > My exprience shows that it may be necessarily to specify encoding for > mysql in dburi. > > The reason is that mysql server may be configured with default encoding > that doesn't match the database you're connecting to. E.g. if you

Testing Pylons FCGI

2007-05-29 Thread voltron
I´m trying to get FCGI to work with a server, my configuration is: [server:main] use = egg:PasteScript#flup_fcgi_thread host = 88.80.195.6 port = 6500 When I start the server with: /projects/pylons/helloworld# paster serve --reload development.ini All is apparently well since a PID is assigne

Re: Pylons deployment methods

2007-05-29 Thread Shannon -jj Behrens
On 5/29/07, voltron <[EMAIL PROTECTED]> wrote: > This is another of my "what is the best way" questions. > > I would like to deploy my Pylons application without headaches on my > clients server. This would mean my app with its templates and creating > the database. A while back, Dan posted that h

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread Shannon -jj Behrens
On 5/29/07, David Smith <[EMAIL PROTECTED]> wrote: > jj, I actually agree strongly with you regarding the potential dangers. My > counter argument is that if you specify the encoding of the database in the > config file to a different encoding than is in the mysql config file, don't > you risk dou

Re: Pylons deployment methods

2007-05-29 Thread voltron
Ok, just to get things straight: 1. I copy my app folder(the one with the development.ini in it) from my windows machine to my Linux server 2. I run "setup-app" and this sets stuff up on my linux machine as it should Did I get it? "the way of the pylons is sometimes easy, but mostly secretive

mod_python configuration?

2007-05-29 Thread Chris Shenton
I used mod_python about 6 months back to get Apache to proxy HTTPS to my Pylons app; it wasn't easy. Now I'm trying again with current Pylons, paste and friends. But I'm again having troubles getting it to work. The simplest apache config I've seen is this from http://pythonpaste.org/module-pa

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread Max Ischenko
On 5/29/07, David Smith <[EMAIL PROTECTED]> wrote: > > > > My exprience shows that it may be necessarily to specify encoding for > > mysql in dburi. > > > > The reason is that mysql server may be configured with default encoding > > that doesn't match the database you're connecting to. E.g. if you

Re: mod_python configuration?

2007-05-29 Thread alecf
Wow.. I had no idea Paste could bridge the modpython divide but thanks to your post, I just converted my own stuff over from modpython_gateway.py, which is looks like paste.modpython derives from... I'm in the process of making my app more paste-friendly so I'm not quite ready to add the .ini fil

use of globals, threadless, and requests

2007-05-29 Thread alecf
I'm interested in serving up my pylons app under Stackless Python - Stackless is more or less single-threaded so the model is somewhat like Twisted but without all the deferreds. Instead of threads, there are tasklets which participate in kind of a cooperative parallelism - as soon as one tasklet

Re: mod_python configuration?

2007-05-29 Thread Chris Shenton
alecf <[EMAIL PROTECTED]> writes: > > SetHandler python-program > PythonHandler paste.modpython > PythonOption wsgi.application client::client_app > > > And this works great. Yeah, I just found my problem: an incompatibility between the expat built into Python-2.4.4 and the one I had installed

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread Mike Orr
The first thing is to see what MySQL thinks its server and client character sets are: $ paster shell development.ini >>> import pylons.database >>> engine = pylons.database.create_engine() >>> engine.execute("SHOW VARIABLES").fetchall() Look for the variables that start with "character_set_" and

Re: SQLAlchemy + MySQL + UTF-8 support - how?

2007-05-29 Thread David Smith
Hi Mike, Thank you for all the details. I've seen the merits of the arguments and I guess the conclusion is these points: 1) The MySQL specific option of use_unicode is not needed anymore. The MySQL specific charset option also is deprecated. 2) The SQLAlchemy convert_unicode option is recommen