Hi peoples,
I am back to web-dev after a break to start a restaurant (now coding for the restaurant instead of cooking all the time).
Anyway I believe I am having a problem revolving around utf-8 encoding (breaking dbix internals with data going in) - maybe in the way I have the dbic setup. I also suspect that this is something that would cause me bigger problems in the future.
Here is the relevant parts of my config.yaml - this would be my first guess as to the source - this is my first dancer project.
charset: "UTF-8"
# template engine
# simple: default and very basic template engine
# template_toolkit: TT
template: "simple"
session: YAML
#template: "template_toolkit"
## engines:
# template_toolkit:
# encoding: 'utf8'
# start_tag: '[%'
# end_tag: '%]'
plugins:
Auth::RBAC:
credentials:
class: SanteriaAuth
DBIC:
default:
dsn: dbi:mysql:Santeria
user: root
pass: secritpass
schema_class: My::Schema
options:
mysql_enable_utf8: 1
Database:
driver: 'mysql'
database: 'Santeria'
host: 'localhost'
port: 3306
username: 'root'
password: 'secritpass'
connection_check_threshold: 10
dbi_params:
RaiseError: 1
AutoCommit: 1
on_connect_do: ["SET NAMES 'utf8'", "SET CHARACTER SET 'utf8'" ]
log_queries: 1
Other possible problems:
I am running Ubuntu 12.04.1 LTS as my platform - so I would hope to have necessary perl versions, mysql versions to make that work. However I will happily dig in deeper in that area if needed.
Maybe a mysql configuration?
Any help appreciated - if you live near Portland Oregon I'll buy you a burrito.
from here on down may not be necessary reading for someone familiar with the utf8 issues if the stuff above is ok then maybe deeper digging is required.
The problem came up when using Dancer::Plugin::Passphrase but I think that this is not relevant to my real problem.