##// END OF EJS Templates
Pass in old groups data to CanWriteToGroup validator for later skipping group checks....
Pass in old groups data to CanWriteToGroup validator for later skipping group checks. This will be a part of refactoring done to do user permissions changes without messing with main repo form data

File last commit:

r3522:7174ee85 beta
r3525:0cef54d3 default
Show More
development.ini
439 lines | 12.8 KiB | text/x-ini | IniLexer
Marcin Kuzminski
Added pylons manage script...
r12 ################################################################################
################################################################################
Celery is configured by the .ini files and run from paster now...
r776 # RhodeCode - Pylons environment configuration #
Marcin Kuzminski
Added pylons manage script...
r12 # #
# The %(here)s variable will be replaced with the parent directory of this file#
################################################################################
Marcin Kuzminski
major app speedup moved the wsgi creation to app globals, in order to make it run only once....
r10
Marcin Kuzminski
initial commit.
r0 [DEFAULT]
debug = true
added simple profiling middleware controlled by .ini file flag
r1355 pdebug = false
Implemented password reset(forms/models/ tasks) and mailing tasks....
r474 ################################################################################
## Uncomment and replace with the address which should receive ##
Celery is configured by the .ini files and run from paster now...
r776 ## any error reports after application crash ##
## Additionally those settings will be used by RhodeCode mailing system ##
Implemented password reset(forms/models/ tasks) and mailing tasks....
r474 ################################################################################
configs fixups
r258 #email_to = admin@localhost
Implemented password reset(forms/models/ tasks) and mailing tasks....
r474 #error_email_from = paste_error@localhost
more renames for rhode code !!
r549 #app_email_from = rhodecode-noreply@localhost
Implemented password reset(forms/models/ tasks) and mailing tasks....
r474 #error_message =
Notification fixes...
r1717 #email_prefix = [RhodeCode]
Implemented password reset(forms/models/ tasks) and mailing tasks....
r474
configs fixups
r258 #smtp_server = mail.server.com
Marcin Kuzminski
change error controller,...
r14 #smtp_username =
Celery is configured by the .ini files and run from paster now...
r776 #smtp_password =
Implemented password reset(forms/models/ tasks) and mailing tasks....
r474 #smtp_port =
Celery is configured by the .ini files and run from paster now...
r776 #smtp_use_tls = false
#smtp_use_ssl = true
Updated ini files for new auth flag for mailing
r1582 # Specify available auth parameters here (e.g. LOGIN PLAIN CRAM-MD5, etc.)
#smtp_auth =
Marcin Kuzminski
initial commit.
r0
[server:main]
added option to ini file to define lightweight dashboard items per page before pagination
r3087 ## PASTE
Marcin Kuzminski
Added few options to configs,...
r86 ##nr of threads to spawn
Switch to waitress wsgi server by default in rhodecode....
r2597 #threadpool_workers = 5
Marcin Kuzminski
Added few options to configs,...
r86
Celery is configured by the .ini files and run from paster now...
r776 ##max request before thread respawn
Switch to waitress wsgi server by default in rhodecode....
r2597 #threadpool_max_requests = 10
Marcin Kuzminski
Added few options to configs,...
r86
##option to use threads of process
Switch to waitress wsgi server by default in rhodecode....
r2597 #use_threadpool = true
Marcin Kuzminski
Added few options to configs,...
r86
Switch to waitress wsgi server by default in rhodecode....
r2597 #use = egg:Paste#http
added option to ini file to define lightweight dashboard items per page before pagination
r3087
#WAITRESS
threads = 5
Switch to waitress wsgi server by default in rhodecode....
r2597 use = egg:waitress#main
added option to ini file to define lightweight dashboard items per page before pagination
r3087
some logging extras for development config files
r716 host = 0.0.0.0
Marcin Kuzminski
Added pylons manage script...
r12 port = 5000
Marcin Kuzminski
initial commit.
r0
added comments into beaker session,...
r2615 [filter:proxy-prefix]
# prefix middleware for rc
use = egg:PasteDeploy#prefix
prefix = /<your-prefix>
Marcin Kuzminski
initial commit.
r0 [app:main]
renamed project to rhodecode
r547 use = egg:rhodecode
added comments into beaker session,...
r2615 #filter-with = proxy-prefix
Marcin Kuzminski
initial commit.
r0 full_stack = true
docs update, developments serves statics as default
r253 static_files = true
Added optional repo_name into issue tracker url to get just the name of repo without group prefix
r2339 # Optional Languages
added option to ini file to define lightweight dashboard items per page before pagination
r3087 # en, fr, ja, pt_BR, zh_CN, zh_TW, pl
implements #212 moved default encoding variable into rhodecode-config. It's now possible to change...
r2016 lang = en
Marcin Kuzminski
initial commit.
r0 cache_dir = %(here)s/data
Implemented whoosh index building as paster command....
r683 index_dir = %(here)s/data/index
implements #212 moved default encoding variable into rhodecode-config. It's now possible to change...
r2016 app_instance_uuid = rc-develop
fixes #79 cut off limit was added into .ini config files
r812 cut_off_limit = 256000
Added option to ini files for controlling full cache of VCS instances....
r3025 vcs_full_cache = True
Added force https option into config files
r914 force_https = false
moved statistics parse_limit into .ini files...
r1076 commit_parse_limit = 25
added option to ini file to define lightweight dashboard items per page before pagination
r3087 # number of items displayed in lightweight dashboard before paginating
dashboard_items = 100
#21 added optional flag to disable gravatar, and use local icon
r1110 use_gravatar = true
sync alternative gravatar options to other .ini files...
r2736
Implemented #661 Add option to include diff in RSS feed...
r3028 ## RSS feed options
rss_cut_off_limit = 256000
rss_items_per_page = 10
rss_include_diff = false
sync alternative gravatar options to other .ini files...
r2736 ## alternative_gravatar_url allows you to use your own avatar server application
## the following parts of the URL will be replaced
fixes issue #543, un-broken alternative gravatar option...
r2751 ## {email} user email
## {md5email} md5 hash of the user email (like at gravatar.com)
## {size} size of the image that is expected from the server application
Implemented patch from andrewsh ref #565 Add support for {netloc} and {scheme}...
r2836 ## {scheme} http/https from RhodeCode server
## {netloc} network location from RhodeCode server
fixes issue #543, un-broken alternative gravatar option...
r2751 #alternative_gravatar_url = http://myavatarserver.com/getbyemail/{email}/{size}
#alternative_gravatar_url = http://myavatarserver.com/getbymd5/{md5email}?s={size}
sync alternative gravatar options to other .ini files...
r2736
Some code cleanups and fixes
r1628 container_auth_enabled = false
proxypass_auth_enabled = false
Implemented #647, option to pass list of default encoding used to encode to/decode from unicode
r3008 ## default encoding used to convert from and to unicode
## can be also a comma seperated list of encoding in case of mixed encodings
implements #212 moved default encoding variable into rhodecode-config. It's now possible to change...
r2016 default_encoding = utf8
Marcin Kuzminski
initial commit.
r0
configurable clone url...
r1652 ## overwrite schema of clone url
#73 mapping of commited issues from commit message into issue tracker url.
r1837 ## available vars:
## scheme - http/https
## user - current user
## pass - password
## netloc - network location
## path - usually repo_name
#clone_uri = {scheme}://{user}{pass}{netloc}{path}
## issue tracking mapping for commits messages
changed default issue tracker links pattern
r1933 ## comment out issue_pat, issue_server, issue_prefix to enable
#73 mapping of commited issues from commit message into issue tracker url.
r1837
## pattern to get the issues from commit messages
changed default issue tracker links pattern
r1933 ## default one used here is #<numbers> with a regex passive group for `#`
## {id} will be all groups matched from this pattern
#73 mapping of commited issues from commit message into issue tracker url.
r1837
changed default issue tracker links pattern
r1933 issue_pat = (?:\s*#)(\d+)
#73 mapping of commited issues from commit message into issue tracker url.
r1837
changed default issue tracker links pattern
r1933 ## server url to the issue, each {id} will be replaced with match
Added optional repo_name into issue tracker url to get just the name of repo without group prefix
r2339 ## fetched from the regex and {repo} is replaced with full repository name
## including groups {repo_name} is replaced with just name of repo
#73 mapping of commited issues from commit message into issue tracker url.
r1837
added repository name into issue tracker link to support different projects issues tracker mapping
r1868 issue_server_link = https://myissueserver.com/{repo}/issue/{id}
#73 mapping of commited issues from commit message into issue tracker url.
r1837
## prefix to add to link to indicate it's an url
## #314 will be replaced by <issue_prefix><id>
UI fixes...
r1865 issue_prefix = #
#73 mapping of commited issues from commit message into issue tracker url.
r1837
#518 multiple issues patterns...
r2866 ## issue_pat, issue_server_link, issue_prefix can have suffixes to specify
## multiple patterns, to other issues server, wiki or others
## below an example how to create a wiki pattern
# #wiki-some-id -> https://mywiki.com/some-id
#issue_pat_wiki = (?:wiki-)(.+)
#issue_server_link_wiki = https://mywiki.com/{id}
#issue_prefix_wiki = WIKI-
implements #212 moved default encoding variable into rhodecode-config. It's now possible to change...
r2016 ## instance-id prefix
## a prefix key for this instance used for cache invalidation when running
## multiple instances of rhodecode, make sure it's globally unique for
## all running rhodecode instances. Leave empty if you don't use it
instance_id =
configurable clone url...
r1652
Alternative HTTP response codes when client failed to Authenticate correctly
r2132 ## alternative return HTTP header for failed authentication. Default HTTP
## response is 401 HTTPUnauthorized. Currently HG clients have troubles with
## handling that. Set this variable to 403 to return HTTPForbidden
auth_ret_code =
Marcin Kuzminski
Added sqlalchemy support...
r49 ####################################
Celery is configured by the .ini files and run from paster now...
r776 ### CELERY CONFIG ####
####################################
use_celery = false
broker.host = localhost
broker.vhost = rabbitmqhost
broker.port = 5672
broker.user = rabbitmq
broker.password = qweqwe
celery.imports = rhodecode.lib.celerylib.tasks
celery.result.backend = amqp
celery.result.dburi = amqp://
celery.result.serialier = json
#celery.send.task.error.emails = true
#celery.amqp.task.result.expires = 18000
celeryd.concurrency = 2
#celeryd.log.file = celeryd.log
celeryd.log.level = debug
moved statistics parse_limit into .ini files...
r1076 celeryd.max.tasks.per.child = 1
Celery is configured by the .ini files and run from paster now...
r776
#tasks will never be sent to the queue, but executed locally instead.
celery.always.eager = false
####################################
Marcin Kuzminski
Added sqlalchemy support...
r49 ### BEAKER CACHE ####
####################################
moved statistics parse_limit into .ini files...
r1076 beaker.cache.data_dir=%(here)s/data/cache/data
beaker.cache.lock_dir=%(here)s/data/cache/lock
moved out sqlalchemy cache from meta to the config files....
r609 beaker.cache.regions=super_short_term,short_term,long_term,sql_cache_short,sql_cache_med,sql_cache_long
#37 fixed json imports for python2.5...
r592
added password validation, second try on paster setup-app,...
r597 beaker.cache.super_short_term.type=memory
beaker.cache.super_short_term.expire=10
Cached readme generation...
r1607 beaker.cache.super_short_term.key_length = 256
moved out sqlalchemy cache from meta to the config files....
r609
Marcin Kuzminski
Added sqlalchemy support...
r49 beaker.cache.short_term.type=memory
added empty controllers for branches tags files graph, routing and test for them
r93 beaker.cache.short_term.expire=60
Cached readme generation...
r1607 beaker.cache.short_term.key_length = 256
moved out sqlalchemy cache from meta to the config files....
r609
added password validation, second try on paster setup-app,...
r597 beaker.cache.long_term.type=memory
beaker.cache.long_term.expire=36000
Cached readme generation...
r1607 beaker.cache.long_term.key_length = 256
added password validation, second try on paster setup-app,...
r597
moved out sqlalchemy cache from meta to the config files....
r609 beaker.cache.sql_cache_short.type=memory
Celery is configured by the .ini files and run from paster now...
r776 beaker.cache.sql_cache_short.expire=10
Cached readme generation...
r1607 beaker.cache.sql_cache_short.key_length = 256
moved out sqlalchemy cache from meta to the config files....
r609
beaker.cache.sql_cache_med.type=memory
beaker.cache.sql_cache_med.expire=360
Cached readme generation...
r1607 beaker.cache.sql_cache_med.key_length = 256
moved out sqlalchemy cache from meta to the config files....
r609
beaker.cache.sql_cache_long.type=file
beaker.cache.sql_cache_long.expire=3600
Cached readme generation...
r1607 beaker.cache.sql_cache_long.key_length = 256
moved out sqlalchemy cache from meta to the config files....
r609
updated config files,...
r436 ####################################
### BEAKER SESSION ####
####################################
## Type of storage used for the session, current types are
Celery is configured by the .ini files and run from paster now...
r776 ## dbm, file, memcached, database, and memory.
updated config files,...
r436 ## The storage uses the Container API
default session settings was reverted to file....
r1771 ## that is also used by the cache system.
db based session example for .ini
r1660
added comments into beaker session,...
r2615 ## db session ##
db based session example for .ini
r1660 #beaker.session.type = ext:database
#beaker.session.sa.url = postgresql://postgres:qwe@localhost/rhodecode
#beaker.session.table_name = db_session
added comments into beaker session,...
r2615 ## encrypted cookie client side session, good for many instances ##
default session settings was reverted to file....
r1771 #beaker.session.type = cookie
added comments into beaker session,...
r2615 ## file based cookies (default) ##
#beaker.session.type = file
more renames for rhode code !!
r549 beaker.session.key = rhodecode
added comments into beaker session,...
r2615 ## secure cookie requires AES python libraries ##
removed default encryption in inis to not require AES
r1831 #beaker.session.encrypt_key = g654dcno0-9873jhgfreyu
#beaker.session.validate_key = 9712sds2212c--zxc123
added comments into beaker session,...
r2615 ## sets session as invalid if it haven't been accessed for given amount of time
beaker.session.timeout = 2592000
added httponly and secure cookie into ini files
r1714 beaker.session.httponly = true
added comments into beaker session,...
r2615 #beaker.session.cookie_path = /<your-prefix>
default session settings was reverted to file....
r1771
added comments into beaker session,...
r2615 ## uncomment for https secure cookie ##
added httponly and secure cookie into ini files
r1714 beaker.session.secure = false
updated config files,...
r436
added comments into beaker session,...
r2615 ## auto save the session to not to use .save() ##
updated config files,...
r436 beaker.session.auto = False
added comments into beaker session,...
r2615 ## default cookie expiration time in seconds `true` expire at browser close ##
updated config files,...
r436 #beaker.session.cookie_expires = 3600
implements #212 moved default encoding variable into rhodecode-config. It's now possible to change...
r2016
Added Errormator and Sentry support part of pull request #71
r2939 ############################
## ERROR HANDLING SYSTEMS ##
############################
####################
### [errormator] ###
####################
# Errormator is tailored to work with RhodeCode, see
# http://errormator.com for details how to obtain an account
# you must install python package `errormator_client` to make it work
# errormator enabled
errormator = true
errormator.server_url = https://api.errormator.com
errormator.api_key = YOUR_API_KEY
# TWEAK AMOUNT OF INFO SENT HERE
# enables 404 error logging (default False)
errormator.report_404 = false
# time in seconds after request is considered being slow (default 1)
errormator.slow_request_time = 1
# record slow requests in application
# (needs to be enabled for slow datastore recording and time tracking)
errormator.slow_requests = true
# enable hooking to application loggers
# errormator.logging = true
# minimum log level for log capture
# errormator.logging.level = WARNING
# send logs only from erroneous/slow requests
# (saves API quota for intensive logging)
errormator.logging_on_error = false
# list of additonal keywords that should be grabbed from environ object
# can be string with comma separated list of words in lowercase
# (by default client will always send following info:
# 'REMOTE_USER', 'REMOTE_ADDR', 'SERVER_NAME', 'CONTENT_TYPE' + all keys that
# start with HTTP* this list be extended with additional keywords here
errormator.environ_keys_whitelist =
# list of keywords that should be blanked from request object
# can be string with comma separated list of words in lowercase
# (by default client will always blank keys that contain following words
# 'password', 'passwd', 'pwd', 'auth_tkt', 'secret', 'csrf'
# this list be extended with additional keywords set here
errormator.request_keys_blacklist =
# list of namespaces that should be ignores when gathering log entries
# can be string with comma separated list of namespaces
# (by default the client ignores own entries: errormator_client.client)
errormator.log_namespace_blacklist =
################
### [sentry] ###
################
# sentry is a alternative open source error aggregator
# you must install python packages `sentry` and `raven` to enable
sentry.dsn = YOUR_DNS
sentry.servers =
sentry.name =
sentry.key =
sentry.public_key =
sentry.secret_key =
sentry.project =
sentry.site =
sentry.include_paths =
sentry.exclude_paths =
Marcin Kuzminski
Added pylons manage script...
r12 ################################################################################
## WARNING: *THE LINE BELOW MUST BE UNCOMMENTED ON A PRODUCTION ENVIRONMENT* ##
## Debug mode will enable the interactive debugging tool, allowing ANYONE to ##
## execute malicious code after an exception is raised. ##
################################################################################
#set debug = false
Marcin Kuzminski
initial commit.
r0
Marcin Kuzminski
Added sqlalchemy support...
r49 ##################################
### LOGVIEW CONFIG ###
##################################
logview.sqlalchemy = #faa
logview.pylons.templating = #bfb
logview.pylons.util = #eee
#########################################################
### DB CONFIGS - EACH DB WILL HAVE IT'S OWN CONFIG ###
#########################################################
Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy....
r1360 #sqlalchemy.db1.url = sqlite:///%(here)s/rhodecode.db
sqlalchemy.db1.url = postgresql://postgres:qwe@localhost/rhodecode
sqlalchemy.db1.echo = false
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 sqlalchemy.db1.pool_recycle = 3600
Mysql fixes...
r2149 sqlalchemy.db1.convert_unicode = true
Marcin Kuzminski
Added sqlalchemy support...
r49
Marcin Kuzminski
Added pylons manage script...
r12 ################################
### LOGGING CONFIGURATION ####
################################
Marcin Kuzminski
initial commit.
r0 [loggers]
Whoosh logging is now controlled by the .ini files logging setup
r2102 keys = root, routes, rhodecode, sqlalchemy, beaker, templates, whoosh_indexer
Marcin Kuzminski
initial commit.
r0
[handlers]
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 keys = console, console_sql
Marcin Kuzminski
initial commit.
r0
[formatters]
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 keys = generic, color_formatter, color_formatter_sql
Marcin Kuzminski
initial commit.
r0
Marcin Kuzminski
Added pylons manage script...
r12 #############
Marcin Kuzminski
initial commit.
r0 ## LOGGERS ##
Marcin Kuzminski
Added pylons manage script...
r12 #############
Marcin Kuzminski
initial commit.
r0 [logger_root]
Marcin Kuzminski
added log4j to development,
r15 level = NOTSET
Marcin Kuzminski
Added pylons manage script...
r12 handlers = console
Marcin Kuzminski
initial commit.
r0
[logger_routes]
Marcin Kuzminski
Updated logginf of routes
r69 level = DEBUG
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 handlers =
Marcin Kuzminski
initial commit.
r0 qualname = routes.middleware
# "level = DEBUG" logs the route matched and routing variables.
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 propagate = 1
Marcin Kuzminski
initial commit.
r0
some logging extras for development config files
r716 [logger_beaker]
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 level = DEBUG
handlers =
some logging extras for development config files
r716 qualname = beaker.container
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 propagate = 1
some logging extras for development config files
r716
[logger_templates]
level = INFO
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 handlers =
some logging extras for development config files
r716 qualname = pylons.templating
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 propagate = 1
some logging extras for development config files
r716
renamed project to rhodecode
r547 [logger_rhodecode]
Marcin Kuzminski
initial commit.
r0 level = DEBUG
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 handlers =
renamed project to rhodecode
r547 qualname = rhodecode
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 propagate = 1
Marcin Kuzminski
Added pylons manage script...
r12
[logger_sqlalchemy]
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 level = INFO
handlers = console_sql
Marcin Kuzminski
Added pylons manage script...
r12 qualname = sqlalchemy.engine
added empty controllers for branches tags files graph, routing and test for them
r93 propagate = 0
Marcin Kuzminski
Added pylons manage script...
r12
Whoosh logging is now controlled by the .ini files logging setup
r2102 [logger_whoosh_indexer]
level = DEBUG
handlers =
qualname = whoosh_indexer
propagate = 1
Marcin Kuzminski
Added pylons manage script...
r12 ##############
Marcin Kuzminski
initial commit.
r0 ## HANDLERS ##
Marcin Kuzminski
Added pylons manage script...
r12 ##############
Marcin Kuzminski
initial commit.
r0
[handler_console]
class = StreamHandler
args = (sys.stderr,)
Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy....
r1360 level = DEBUG
Added colored formatter to project, and configs
r153 formatter = color_formatter
Marcin Kuzminski
initial commit.
r0
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 [handler_console_sql]
class = StreamHandler
args = (sys.stderr,)
Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy....
r1360 level = DEBUG
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 formatter = color_formatter_sql
Marcin Kuzminski
Added pylons manage script...
r12 ################
Marcin Kuzminski
initial commit.
r0 ## FORMATTERS ##
Marcin Kuzminski
Added pylons manage script...
r12 ################
Marcin Kuzminski
initial commit.
r0
[formatter_generic]
Added colored formatter to project, and configs
r153 format = %(asctime)s.%(msecs)03d %(levelname)-5.5s [%(name)s] %(message)s
Marcin Kuzminski
Static files for production fixed...
r46 datefmt = %Y-%m-%d %H:%M:%S
Marcin Kuzminski
initial commit.
r0
Added colored formatter to project, and configs
r153 [formatter_color_formatter]
renamed project to rhodecode
r547 class=rhodecode.lib.colored_formatter.ColorFormatter
Added colored formatter to project, and configs
r153 format= %(asctime)s.%(msecs)03d %(levelname)-5.5s [%(name)s] %(message)s
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging
r1186 datefmt = %Y-%m-%d %H:%M:%S
[formatter_color_formatter_sql]
class=rhodecode.lib.colored_formatter.ColorFormatterSql
format= %(asctime)s.%(msecs)03d %(levelname)-5.5s [%(name)s] %(message)s
changed dafault to use sqlite for dev
r1278 datefmt = %Y-%m-%d %H:%M:%S