Created
April 22, 2014 04:31
-
-
Save nibalizer/11165405 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> use storyboard; | |
| Database changed | |
| mysql> show tables; | |
| +-----------------------+ | |
| | Tables_in_storyboard | | |
| +-----------------------+ | |
| | alembic_version | | |
| | authorizationcodes | | |
| | bearertokens | | |
| | comments | | |
| | permissions | | |
| | project_group_mapping | | |
| | project_groups | | |
| | projects | | |
| | stories | | |
| | storytags | | |
| | tasks | | |
| | team_membership | | |
| | team_permissions | | |
| | teams | | |
| | user_permissions | | |
| | users | | |
| +-----------------------+ | |
| 16 rows in set (0.00 sec) | |
| mysql> select * from users; | |
| Empty set (0.00 sec) |
root@vagrant-ubuntu-precise-64:/home/storyboard/storyboard# cat /etc/storyboard/storyboard.conf
[DEFAULT]
Default log level is INFO
verbose and debug has the same result.
One of them will set DEBUG log level output
debug = False
verbose = False
Where to store lock files
lock_path = $state_path/lock
log_format = %(asctime)s %(levelname)8s [%(name)s] %(message)s
log_date_format = %Y-%m-%d %H:%M:%S
use_syslog -> syslog
log_file and log_dir -> log_dir/log_file
(not log_file) and log_dir -> log_dir/{binary_name}.log
use_stderr -> stderr
(not user_stderr) and (not log_file) -> stdout
publish_errors -> notification system
use_syslog = False
syslog_log_facility = LOG_USER
use_stderr = True
log_file = /var/log/storyboard/storyboard.log
log_dir = /var/log/storyboard/
publish_errors = False
Address to bind the API server
bind_host = 0.0.0.0
Port the bind the API server to
bind_port = 8080
OpenId Authentication endpoint
openid_url = https://login.launchpad.net/+openid
Time in seconds before an access_token expires
token_ttl = 3600
List paging configuration options.
page_size_maximum = 500
page_size_default = 20
[database]
This line MUST be changed to actually run storyboard
Example:
connection = mysql://storyboard1:some_pass@127.0.0.1:3306/storyboard
Replace 127.0.0.1 above with the IP address of the database used by the
main storyboard server. (Leave it as is if the database runs on this host.)
connection=sqlite://
The SQLAlchemy connection string used to connect to the slave database
slave_connection =
Database reconnection retry times - in event connectivity is lost
set to -1 implies an infinite retry count
max_retries = 10
Database reconnection interval in seconds - if the initial connection to the
database fails
retry_interval = 10
Minimum number of SQL connections to keep open in a pool
min_pool_size = 1
Maximum number of SQL connections to keep open in a pool
max_pool_size = 10
Timeout in seconds before idle sql connections are reaped
idle_timeout = 3600
If set, use this value for max_overflow with sqlalchemy
max_overflow = 20
Verbosity of SQL debugging information. 0=None, 100=Everything
connection_debug = 0
Add python stack traces to SQL as comment strings
connection_trace = False
If set, use this value for pool_timeout with sqlalchemy
pool_timeout = 10
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
192.168.33.1 - - [18/Apr/2014:01:37:50 +0000] "GET /favicon.ico HTTP/1.1" 200 116096 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:28.0) Gecko/20100101 Firefox/28.0"
192.168.33.1 - - [18/Apr/2014:01:37:51 +0000] "GET /api/v1/openid/authorize?response_type=code&client_id=192.168.33.10&redirect_uri=http%3A%2F%2F192.168.33.10%3A80%2F%23!%2Fauth%2Ftoken&scope=user&state=N4axbEnJmOVx6VBucBO8 HTTP/1.1" 303 1343 "http://192.168.33.10/" "Mozilla/5.0 (X11; Linux x86_64; rv:28.0) Gecko/20100101 Firefox/28.0"
192.168.33.1 - - [18/Apr/2014:01:37:56 +0000] "GET /api/v1/openid/authorize_return?scope=user&state=N4axbEnJmOVx6VBucBO8&response_type=code&client_id=192.168.33.10&sb_redirect_uri=http%3A%2F%2F192.168.33.10%3A80%2F%23%21%2Fauth%2Ftoken&openid.assoc_handle=%7BHMAC-SHA1%7D%7B535081eb%7D%7B2W0f%2Fg%3D%3D%7D&openid.ax.count.Email=0&openid.ax.count.FirstName=0&openid.ax.count.LastName=0&openid.ax.mode=fetch_response&openid.ax.type.Email=http%3A%2F%2Fschema.openid.net%2Fcontact%2Femail&openid.ax.type.FirstName=http%3A%2F%2Fschema.openid.net%2FnamePerson%2Ffirst&openid.ax.type.LastName=http%3A%2F%2Fschema.openid.net%2FnamePerson%2Flast&openid.claimed_id=https%3A%2F%2Flogin.launchpad.net%2F%2Bid%2FKDENpnQ&openid.identity=https%3A%2F%2Flogin.launchpad.net%2F%2Bid%2FKDENpnQ&openid.mode=id_res&openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.ns.ax=http%3A%2F%2Fopenid.net%2Fsrv%2Fax%2F1.0&openid.ns.sreg=http%3A%2F%2Fopenid.net%2Fsreg%2F1.0&openid.op_endpoint=https%3A%2F%2Flogin.launchpad.net%2F%2Bopenid&openid.response_nonce=2014-04-18T01%3A37%3A47Z7MLgPh&openid.return_to=http%3A%2F%2F192.168.33.10%2Fapi%2Fv1%2Fopenid%2Fauthorize_return%3Fscope%3Duser%26state%3DN4axbEnJmOVx6VBucBO8%26response_type%3Dcode%26client_id%3D192.168.33.10%26sb_redirect_uri%3Dhttp%253A%252F%252F192.168.33.10%253A80%252F%2523%2521%252Fauth%252Ftoken&openid.sig=aM2Up8YFKsI9VemAh1Svhw3UPbk%3D&openid.signed=assoc_handle%2Cax.count.Email%2Cax.count.FirstName%2Cax.count.LastName%2Cax.mode%2Cax.type.Email%2Cax.type.FirstName%2Cax.type.LastName%2Cclaimed_id%2Cidentity%2Cmode%2Cns%2Cns.ax%2Cns.sreg%2Cop_endpoint%2Cresponse_nonce%2Creturn_to%2Csigned%2Csreg.email%2Csreg.fullname%2Csreg.nickname&openid.sreg.email=krum.spencer%40gmail.com&openid.sreg.fullname=Spencer+Krum&openid.sreg.nickname=nibalizer HTTP/1.1" 500 641 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:28.0) Gecko/20100101 Firefox/28.0"
==> /var/log/apache2/error.log <==
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] exc_info
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] reraise(type(exception), exception, tb=exc_tb)
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] context)
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] cursor.execute(statement, parameters)
[Tue Apr 22 04:32:46 2014] [error] [client 192.168.33.1] OperationalError: (OperationalError) no such table: users u'SELECT users.created_at AS users_created_at, users.updated_at AS users_updated_at, users.id AS users_id, users.username AS users_username, users.full_name AS users_full_name, users.email AS users_email, users.openid AS users_openid, users.is_staff AS users_is_staff, users.is_active AS users_is_active, users.is_superuser AS users_is_superuser, users.last_login AS users_last_login \nFROM users \nWHERE users.openid = ?\n LIMIT ? OFFSET ?' (u'https://login.launchpad.net/+id/KDENpnQ', 1, 0)
[Tue Apr 22 04:32:46 2014] [debug] mod_deflate.c(615): [client 192.168.33.1] Zlib: Compressed 618 to 384 : URL /api/v1/openid/authorize_return