Missing from the dependencies installed via apt-get install is python-sqlalchemy.

I am a developer, but not a Python developer, so I am looking for some help with installation.

here are the steps I have followed.

1. I have a SUSE Linux distribution.
2. I have MySQL.
3. I downloaded the software and unpacked it on the web server.
4. I created the database, and ran all the database scripts.

The resutls are at http://cbu.milwaukee.gov/cbu/main.py.

Please eamail me at [email protected], if you have suggestions.

Missing from the dependencies installed via apt-get install is python-imaging.

The wiki does not have any documentation about creating local configuration files using fabric, or deployment using fabric. This is necessary for new users to know how to set up a site using fabric.

The file path for loading config.yaml is incorrect resulting in the following error:

IOError: [Errno 2] No such file or directory

I completed Installation Instructions (Ubuntu) and attempted to start Lighttpd resulting in:

(.env)$:~/apps/Change-By-Us$ /usr/sbin/lighttpd -D -f lighttpd.conf
Traceback (most recent call last):
  File "./main.py", line 17, in <module>
    from framework.log import log
  File "/home/cvee/apps/Change-By-Us/framework/log.py", line 63, in <module>
    logfile = Config.get('logfile') # %s/../logs/%s.log' % (os.path.dirname(os.path.realpath(__file__)), name)
  File "/home/cvee/apps/Change-By-Us/framework/config.py", line 57, in get
    raise KeyError
KeyError

logs/main.log file contains the following:

2012-01-04 16:22:54: (log.c.166) server started
2012-01-04 16:22:54: (mod_fastcgi.c.1104) the fastcgi-backend ./main.py failed to start:
2012-01-04 16:22:54: (mod_fastcgi.c.1108) child exited with status 1 ./main.py
2012-01-04 16:22:54: (mod_fastcgi.c.1111) If you're trying to run your app as a FastCGI backend, make sure you're using the FastCGI-enabled version.
If this is PHP on Gentoo, add 'fastcgi' to the USE flags.
2012-01-04 16:22:54: (mod_fastcgi.c.1399) [ERROR]: spawning fcgi failed.
2012-01-04 16:22:54: (server.c.938) Configuration of plugins failed. Going down.
2012-01-04 16:23:19: (log.c.166) server started
2012-01-04 16:23:19: (mod_fastcgi.c.1104) the fastcgi-backend ./main.py failed to start:
2012-01-04 16:23:19: (mod_fastcgi.c.1108) child exited with status 1 ./main.py
2012-01-04 16:23:19: (mod_fastcgi.c.1111) If you're trying to run your app as a FastCGI backend, make sure you're using the FastCGI-enabled version.
If this is PHP on Gentoo, add 'fastcgi' to the USE flags.
2012-01-04 16:23:19: (mod_fastcgi.c.1399) [ERROR]: spawning fcgi failed.
2012-01-04 16:23:19: (server.c.938) Configuration of plugins failed. Going down.
2012-01-04 16:51:13: (log.c.166) server started
2012-01-04 16:53:26: (server.c.1396) [note] graceful shutdown started
2012-01-04 16:53:26: (server.c.1512) server stopped by UID = 0 PID = 0

Could this be related to my question in issue #16 regarding FastCGI configuration?

Creating a project results in the error:

(OperationalError) (1054, "Unknown column 'project_need.subtype' in 'field list'") 'SELECT project_need.id AS project_need_id, project_need.type AS project_need_type, project_need.subtype AS project_need_subtype, project_need.request AS project_need_request, project_need.quantity AS project_need_quantity, project_need.description AS project_need_description, project_need.address AS project_need_address, project_need.date AS project_need_date, project_need.time AS project_need_time, project_need.duration AS project_need_duration, project_need.project_id AS project_need_project_id, project_need.event_id AS project_need_event_id \nFROM project_need \nWHERE %(param_1)s = project_need.project_id ORDER BY project_need.id DESC' {'param_1': 1L}

Python /home/cbu/cbudc/.env/local/lib/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler, line 35
Web GET http://cbudc.istrategylabs.com:8080/project/1

In sql/models.sql the 'project_need' CREATE TABLE block is missing the definition of the 'subtype' column.

Creating a new MySQL database results in tables having the character set latin1 and collation latin_swedish_ci. To support Unicode the database tables should have a default character set of utf8 and collation of utf8_unicode_ci.

The installation instructions are not complete and I cannot get a copy of this application running locally on my dev box. I have followed all comments, issues, etc. trying to get this application to work. Can more complete documentation be created.

Missing from the dependencies installed via apt-get install is python-yaml.

In lighttpd.conf.sample, the Fast CGI section appears as follows:

# Fast CGI settings
#--------------------------------------------------------------------
# Settings for Fast CGI.
#
#--------------------------------------------------------------------
fastcgi.server = ("/main.py" =>
    ((  "socket" => "/tmp/fastcgi.socket",
        "bin-path" => var.binpath,
        "max-procs" => 1,
        "bin-environment" => (
            "REAL_SCRIPT_NAME" => ""
        ),
        "check-local" => "disable"
    ))
)

The Installation Instructions (Ubuntu) do not provide clear instructions about what values need to be set. Is REAL_SCRIPT_NAME supposed to be replaced by a value? If so, what value should be provided?

The Application Configuration section contains the following instructions:

Application

1. Copy the sample config.yaml.sample file to config.yaml
   • cp config.yaml.sample config.yaml
2. Edit config.yaml with appropriate values.

config.yaml.sample cannot be found in the project root. Has the file been moved to an alternate location or removed completely?

On a fresh install of CBU, attempting to sign in with Facebook results in the following JavaScript error on line 23 of all.js:

Error: OAuth2 specification states that 'perms' should now be called 'scope'.  Please update.

Logging handlers are not writing to the destination defined in the config file. Change requires that logging use the webpy logging process, instead of assuming that stdout/stderror will be caught by the target.

The solution steps are as follows:

• Change framework/log.py to use webpy's logging process
• Ensure that there's an SMTP handler so that errors are emailed to admins
• Add sqlalchemy.engine logging handler
• Remove timed-rotation-filehandler since it's better to implement this with logrotate.d

Missing from the dependencies installed via apt-get install is python-memcache.

CREATE TABLE project_need (
id int(11) NOT NULL AUTO_INCREMENT,
type varchar(10) DEFAULT NULL,
subtype varchar(10) DEFAULT NULL,
request varchar(64) DEFAULT NULL,
quantity int(11) DEFAULT NULL,
description text,
project_id int(11) NOT NULL,
date date DEFAULT NULL,
time varchar(32) DEFAULT NULL,
duration varchar(64) DEFAULT NULL,
address varchar(256) DEFAULT NULL,
event_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY project_id (project_id),
KEY event_id (event_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

need string

subtype varchar(10) DEFAULT NULL,

Text fields do not support non-Latin characters.

I appears the links to install guides all result in 404 errors: https://github.com/localprojects/Change-By-Us/blob/master/INSTALL.txt

Perhaps you intended to link to https://github.com/localprojects/Change-By-Us/wiki rather than Code for America wiki entries?

Ran xgettext right after finishing the installation. I noticed some of the string that were marked as "translatables" didn't appear in the .po file. For example: line 167 of the base.html template partial. The string is "News" and it has the right syntax, but it doesn't appear in the .po file.

The base Change by Us code contains references to NYC media assets:

• Line 4063 of Change-By-Us/static/css/tc.gam.main.css
• Lines 481 and 496 of Change-By-Us/static/css/tc.gam.mobile.css

This causes CBU instances to display "Hey NYC!" on the main page.

It would be very helpful if an ansible playbook could be built that automated the steps outlined here:

https://github.com/localprojects/Change-By-Us/wiki/Installation-Instructions-%28Ubuntu%29

is there a better example of the syntax of the changes to the yaml file?

for instance, in the database area, there is an entry for db. the sample file has %(database_db)s.

do i leave the % sign?

do i leave the s?

do i leave the parenthasis?

do i replace the whole thing with my database name?

Attempting to install python dependencies using:

pip install -r requirements.txt

results in:

Double requirement given: Fabric==1.3.1 (from -r requirements.txt (line 28)) (aready in fabric (from -r requirements.txt (line 11)), name='Fabric')

In the Get Code section, the GitHub URL for cloning the repository is incorrect.

Attempting to clone using:

git clone [email protected]:lp-changebyus.git

results in:

Permission denied (publickey,keyboard-interactive).
fatal: The remote end hung up unexpectedly

The installation instructions should be updated to use the Git Read-Only URL.

git clone git://github.com/localprojects/Change-By-Us.git