/usr/local/mysql/lib/libmysqlclient.18.dylib Set up one master SQL database. (You can keep the same sharding options in settings.py that you have configured for production.).
Configure the site defaults in settings.py. You can leave it as-is for now.Run the app:
mysql --user=root monorail < schema/framework.sql
mysql --user=root monorail < schema/project.sql
mysql --user=root monorail < schema/tracker.sql
Browse the app at localhost:8080 your browser.Optional: Create/modify your Monorail User row in the database and make that user a site admin.
- You can use ‘make serve’, or
- Run the app with AppEngine dev_appserver.py with the command:
../../../google_appengine/dev_appserver.py --mysql_user=root app.yaml module-besearch.yaml
UPDATE User SET is_site_admin = TRUE WHERE email = 'YOUR@EMAIL';
Restart your local dev appserver.
Here's how to run unit tests from the command-line:
./test.py test appengine/monorail
- Or, in the monorail directory, use
Here's how to deploy a new version to an instance that has already been set up:
- You need the master and replica databases set up on the Developer API console
- Make sure that the app ID is correct in app.yaml.
- In the monorail directory, run the command
- Make any needed schema changes by looking at the end of sql/alter-table-log.txt. Be sure to connect to the staging master DB.
- On console.cloud.google.com, try out the new version using a version specific URL:
- Test some of the expected changes
- Add a comment to an issue
- Enter a new issue and CC your personal account
- Verify that you got an email (at the “all” email address specified in settings.py)
- Try doing a query that is not cached, then repeat it to test the cached case
- When everything looks good, make the new version the default on staging.
- If you updated the staging schema, disconnect from the staging master DB so that command prompt is not left open in a terminal window.
- Repeat the process on prod. Be sure to repeat the same schema changes on the prod database.
- If you updated the prod schema, disconnect from the prod master DB so that command prompt is not left open in a terminal window.
Here's an outline of what would be needed to set up a new Monorail instance:
- Create new GAE apps for production and staging.
- Configure GCP billing.
- Create new master DBs and 10 read replicas for prod and staging.
- Set up IP address and configure admin password and allowed IP addr. Instructions.
- Set up backups on master. The first backup must be created before you can configure replicas.
- Fork settings.py and configure every part of it, especially trusted domains and “all” email settings.
- You might want to also update /_constants.py files.
- Set up log saving to bigquery or something.
- Set up monitoring and alerts.
- Set up attachment storage in GCS.
- Set up spam data and train models.
- Fork and customize some of HTML in templates/framework/master-header.ezt, master-footer.ezt, and some CSS to give the instance a visually different appearance.
- Get From-address whitelisted so that the “View issue” link in Gmail/Inbox works.
- Set up a custom domain with SSL and get that configured into GAE. Make sure to have some kind of reminder system set up so that you know before cert expire.
- Configure the API. Details? Allowed clients are now configured through luci-config, so that is a whole other thing to set up. (Or, maybe decide not to offer any API access.)
- Gain permission to sync GGG user groups. Set up borgcron job to sync user groups. Configure that job to hit the API for your instance. (Or, maybe decide not to sync any user groups.)
- Monorail does not not access any internal APIs, so no whitelisting is required.
- For projects on code.google.com, coordinate with that team to set flags to do per-issue redirects from old project to new site. As each project is imported, set it's moved-to field.
- **TypeError: connect() got an unexpected keyword argument ‘charset’ This error occurs when dev_appserver cannot find the MySQLdb library. Try installing it via sudo apt-get install python-mysqldb.
- TypeError: connect() argument 6 must be string, not None This occurs when your mysql server is not running. Check if it is running with ps aux | grep mysqld. Start it up with /etc/init.d/mysqld start on linux, or just mysqld.
- dev_appserver says OSError: [Errno 24] Too many open files and then lists out all source files dev_appserver wants to reload source files that you have changed in the editor, however that feature does not seem to work well with multiple GAE modules and instances running in different processes. The workaround is to control-C or kill the dev_appserver processes and restart them.