Site Administration

"Contact Us" emails

When a user fills out the form on the "Contact Us" page, the site sends an email to the site administrator's email address (defined in conf.emails.CONTACT_EMAIL). This email is sent out by the automated email account defined in conf.emails.EMAIL_HOST_USER. Thus, when the administrator receives the email, it will be from the automated email account, not from the user who filled out the "Contact Us" form. The first line in the email contains the user's email address.

When responding to "Contact Us" emails, remember to change the reply address to the user's email address.

2.x plugin submissions

2.x plugins are managed by UCSD's chianti server. When a developer submits a 2.x plugin, it goes to chianti, not to the App Store. When a plugin submission is approved, plugins.xml is updated, and an automatic email is sent by Barry.

To update the app page to reflect the update to plugins.xml:

  1. Go to the App Store and make sure you're signed in a staff account.
  2. In the user menu, click "2.x Plugin Management".
  3. In the plugin name field, enter the name of the 2.x plugin whose page you want to update.
  4. The page will present details about the plugin it obtained from plugins.xml. Check these details.
  5. If the details are correct, click on the blue button on the bottom right.

3.0 app submissions

When a jar is submitted to the App Store, the site sends an automated email to the administrator's email address (defined in conf.emails.CONTACT_EMAIL). Even if the app is not approved in the final step by the author, the administrator receives an email. This is done so that the administrator can monitor all submissions.

If an app page already exists for the 3.0 jar submission, the new release becomes immediately available. The administrator will receive an automated email about the submission.

If the app is new, the jar submission requires approval by staff. Sign in as staff, then go to the App Store site. In the user menu on the top right of the page, choose "Pending Apps". At this page, staff can approve an app. Approving an app sends an automatic email to the author and doesn't require any additional work. If the jar is not satisfactory, it can be rejected. No automatic email is sent to the author if the jar is rejected. This is because rejections happen when a jar is malformed and require an individualized email to the author.

App Store Code Structure

Terminology

Explanation of important files

Configuration Files

Django Apps

Other Directories

Backup System

App Store Dependencies

The App Store requires a machine with 2GB RAM and enough disk space to accommodate a growing app collection. The software itself takes 2.2GB and as of September 2015 the media directory takes 4.3GB to hold 238 apps (368 releases/jar files), and the MySQL database takes 61MB to hold associated author, release and tag data. So, 6.51GB in total. Grow your estimate as the number of apps grows and also add 2GB for temporary scratch space.

The App Store requires the following software packages. If you're on a Mac, this can be installed with Homebrew. If you're on Linux, use your distribution's package manager.

Note that the versions specified here are not mandatory. They only indicate the version with which I've tested the App Store.

The following Python packages are also required. Each can be installed with pip install. If you don't have pip, type: easy_install pip.

Testing App Store Software Dependencies

Run the test_dependencies.py script like so:

Test the GeoIP library:

Note: this script can only be run after the Django project has been configured.

Migration

If you want to move the App Store to another machine, here is what to do:

  1. Install the needed libraries on the new machine by following the instructions in the *App Store Dependencies* section above.
  2. Check out the App Store GitHub repository to the new machine: http://github.com/cytoscape/appstore

  3. In the conf directory, make a copy of each -template.py file, removing the -template.py portion of the file name (e.g. cp apikeys-template.py apikeys.py). Open each template file and fill in the fields. Copy the old machine's configuration files if necessary. Do the same for maven-app-repo-settings-template.xml in the parent directory, which contains sensitive username and password information.

  4. In the download/geolite directory, type make. This will download the needed GeoLite data files. (GeoLite maps IP addresses to geographical locations.)

  5. Create the following daily cron jobs on the new machine:
    • Database backups described above in the subsection Backup System.

    • Free text search reindexing: the crob job should run make index in the App Store directory.

  6. Take a snapshot of the database using mysqldump then load it to the new machine's database:

    • # Run this on the old machine
      mysqldump -u USER_NAME DB_NAME > CyAppStoreDbDump.sql
      
      # Transfer CyAppStoreDbDump.sql from the old to new machine
      
      # Run this on the new machine
      mysql -u USER_NAME DB_NAME < CyAppStoreDbDump.sql
  7. Create an entry in Apache's sites-enabled directory for the App Store. Use the old machine's entry if necessary.

  8. Restart Apache and run the test protocol that's described below.

Other resources

In addition to getting the CyAppStore code up and running along with its dependencies, there are other systems required for a full migration:

How requests are handled

         ||             |                               |                    |                    |            ||
Request=>|| ==Apache==> | == sites-enabled/appstore ==> | == django.wsgi ==> | == settings.py ==> | == urls.py ||
         ||             |                               |                    |                    |            ||
  1. An HTTP request is made to the Apache server.
  2. Apache looks in /etc/apache2/sites-enabled to see how to handle the request. The appstore configuration file is set to handle requests made to http://apps.cytoscape.org.

  3. appstore tells Apache to use mod_wsgi. mod_wsgi runs a Python interpreter within Apache. appstore tells mod_wsgi to start Python with /var/www/CyAppStore/django.wsgi.

  4. django.wsgi starts the Django library. It also tells Django the location of settings.py, which Django needs to start the site.

  5. settings.py contains the location of urls.py (defined in the ROOT_URLCONF variable), which is a list of URLs (in the form of regular expressions) and the Python functions that handle them.

  6. urls.py in the top directory of the App Store merely imports additional URLs from each Django app. It dispatches the request to the appropriate function that is designated to handle requests for a given URL. Functions are defined in the views.py file in each Django app.

  7. The handler function returns with a processed HTML page.

Debugging

  1. /etc/apache2/sites-enabled/appstore

    • This file tells Apache and mod_wsgi where to find the site. The most important line is this:
      WSGIScriptAlias / /var/www/CyAppStore/django.wsgi

      This tells Apache and mod_wsgi where to locate the site code. Make sure the path to django.wsgi is correct.

  2. /var/www/CyAppStore/django.wsgi

    • This file invokes Django's WSGI handler. It needs to correctly reference settings.py to start the site. Make sure these two lines are correct:

      SITE_PARENT_DIR = '/var/www'
      SITE_DIR = filejoin(SITE_PARENT_DIR, 'CyAppStore')
      To check if these variables are being defined correctly, you can launch a separate Python interpreter and enter these lines:
      from os.path import join as filejoin
      SITE_PARENT_DIR = '/var/www'
      SITE_DIR = filejoin(SITE_PARENT_DIR, 'CyAppStore')

      Then check if the variables SITE_PARENT_DIR and SITE_DIR are correct.

  3. /var/www/CyAppStore/settings.py

    • This file is pretty complicated. But if you've checked everything at this point, here's some ways to pinpoint problems in settings.py.

      1. If you're getting an HTTP 500 error, you can get the stack trace by turning on debug mode then reloading the page. Note that debug mode exposes sensitive information about the site to the public. Make sure to keep debug mode off as much as possible. Change to following line to True:

        DEBUG = False
      2. You can poke at the code by running a Python shell. Enter this command at the shell prompt in the same directory as settings.py:

        python manage.py shell
        You can check to see if the site's code is working correctly without having debug mode on. For example, to see if the list of all apps is working, enter this into the Python interpreter:
        from apps.models import App
        App.objects.all()
      3. The SQL database settings are specified by the DATABASES variable:

        DATABASES = {
                'default': deploy_database
        }

        Make sure that 'default' is pointing to the correct dictionary:

        deploy_database = {
                'ENGINE':   'django.db.backends.mysql',
                'NAME':     ...
                'USER':     ...,
                'PASSWORD': ...
        }
      4. If you're getting database errors, enter this command at the shell prompt in the same directory as settings.py:

        python manage.py dbshell
        If you're able to get a SQL prompt, that means Django can connect to the SQL database.
      5. If you make changes to a Python file but you're not seeing the changes taking effect, you may have to delete all the .pyc files. To do so, type this:

        make nopyc

Known ERROR notifications

  1. MultipleObjectsReturned: get() returned more than one AppDownloadsByGeoLoc -- it returned 2! 

    1. log into mysql: mysql -u root --password=PASSWORD cyappstore b. list any duplicate country entries per app

         select app_id, geoloc_id, count(*) as c 
         from download_appdownloadsbygeoloc 
         where app_id is not null 
         group by app_id,geoloc_id having c > 1;

      c. arbitrarily select the MAX record id from these duplicate cases and delete those records. Note: this potentially deletes valid download records and must be repeated if duplicate count is > 2

         delete from download_appdownloadsbygeoloc where id in 
         (select max from (select MAX(id) as max, app_id, geoloc_id, count(*) as c 
         from download_appdownloadsbygeoloc 
         where app_id is not null 
         group by app_id,geoloc_id having c > 1) 
         as T);
  2. MultipleObjectsReturned: get() returned more than one ReleaseDownloadsByDate -- it returned 2! 

    1. log into mysql: mysql -u root --password=PASSWORD cyappstore b. list any duplicate country entries per app

         select release_id, download_releasedownloadsbydate.when, count(*) as c 
         from download_releasedownloadsbydate 
         where release_id is not null 
         group by release_id,download_releasedownloadsbydate.when having c > 1;

      c. arbitrarily select the MAX record id from these duplicate cases and delete those records. Note: this potentially deletes valid download records and must be repeated if duplicate count is > 2

         delete from download_releasedownloadsbydate where id in 
         (select max from (select MAX(id) as max, release_id, download_releasedownloadsbydate.when, count(*) as c 
         from download_releasedownloadsbydate 
         where release_id is not null 
         group by release_id,download_releasedownloadsbydate.when having c > 1) 
         as T);

Tips

App Store Test Protocol

  1. Does the front page load?
  2. Does "All Apps" load?
    1. Does sorting work as expected?
  3. Does a category load?
  4. Does a 2.x plugin page load? (e.g. /apps/psicquicuniversalclient)

    1. Does plugin downloading work?
    2. Does "Search for posts" work?
    3. Does ratings work?
  5. Does a 3.x app page load? (e.g. /apps/cluego)

    1. Do release downloads work?
    2. When a release is downloaded, is it reflected in the stats page?
  6. Does app page editing work?
    1. Icon?
    2. Any link field?
    3. Details editing?
    4. Deleting a 3.0 release?
      1. Does the release still show in the download stats?
      2. Does the release no longer show in the app page?
      3. Does the release no longer show in the backend?
      4. Does depending on the deleted release fail?
      5. Does submitting a jar with the same name and version succeed?
  7. Does search work?
  8. Do app author pages work? (e.g. /apps/with_author/John%20"Scooter"%20Morris)

  9. Does the "About" page load?
  10. Does the "Contact Us" page load and work?
  11. Does the /backend/all_apps page work?

    1. Does it refer accurately to icon and release URLs?
  12. Do the admin pages load?

App Submission Test Protocol

App submissions will principally test the manifest file. The following snippets are for jars created with the manifest files listed below.

To create an empty jar with just a given manifest, first make sure to have an empty file in the current directory. This is because jar requires at least one input file (besides the manifest) to create a jar. Run this command to create the jar:

jar cmf manifest jar-name.jar empty

Empty manifest test

This should fail: no Cytoscape-App-Name in the manifest.

Simple app test: no version

This should fail: no Cytoscape-App-Version in the manifest.

Manifest:

Cytoscape-App-Name: blah

Simple app test: no API compatibility

This should fail: no Cytoscape-API-Compatibility in the manifest.

Manifest:

Cytoscape-App-Name: blah
Cytoscape-App-Version: 1.0

Simple app test: new app

Manifest:

Cytoscape-App-Name: blah
Cytoscape-App-Version: 1.0
Cytoscape-API-Compatibility: 3.0

Simple app test: new release

This should succeed and not require admin approval. It should still send an email to the admin about the submission.

Manifest:

Cytoscape-App-Name: blah
Cytoscape-App-Version: 2.0
Cytoscape-API-Compatibility: 3.0

Simple app test: no authorization

Submit the jar with the same manifest as above but under a different, non-admin account. Submission should be rejected.

OSGi bundle: no name

This should fail: no Bundle-Name.

Manifest:

Bundle-SymbolicName: blah

OSGi bundle: no version

This should fail: no Bundle-Version.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah

OSGi bundle: no Cytoscape imports

This should fail: no Cytoscape packages in Import-Package.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah
Bundle-Version: 3.0
Import-Package: xyz,abc

OSGi bundle: no Cytoscape version in imports

This should fail: no Cytoscape packages in Import-Package.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah
Bundle-Version: 3.0
Import-Package: org.cytoscape.a, org.cytoscape.b

OSGi bundle: new release

This should succeed.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah
Bundle-Version: 3.0
Import-Package: org.cytoscape.a;version="(3.0,4]",
  org.cytoscape.b;version="(3.5,4]"

OSGi bundle: export package

This should succeed and ask for a pom and Javadocs.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah
Bundle-Version: 4.0
Import-Package: org.cytoscape.a;version="(3.0,4]",
  org.cytoscape.b;version="(3.5,4]"
Export-Package: blah

OSGi bundle: deleted dependency

Delete an existing release. Then try to submit an app that depends on it. This should fail.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah
Bundle-Version: 3.0
Import-Package: org.cytoscape.a;version="(3.0,4]",
  org.cytoscape.b;version="(3.5,4]"
Cytoscape-App-Dependencies: GeneMANIA;3.0.0.beta1

OSGi bundle: multiple dependencies

Submission should succeed. After submission, GeneMANIA and ClueGO must list blah as a dependency.

Manifest:

Bundle-SymbolicName: blah
Bundle-Name: blah
Bundle-Version: 5.0
Import-Package: org.cytoscape.a;version="(3.0,4]",
  org.cytoscape.b;version="(3.5,4]"
Cytoscape-App-Dependencies: GeneMANIA;3.0.0.beta2, ClueGO;2.0.0

Extract list of authors for recently updated/submitted apps

Use case: producing a contact list for F1000Research channel authors

  1. log into server: root@apps.cytoscape.org

  2. log into docker (if a docker instance): docker exec -it appstore_mysql_1 /bin/bash
  3. log into mysql: mysql -u root --password=PASSWORD cyappstore
  4. select distinct first_name,last_name,email,release_file from apps_app_editors left join apps_release on apps_app_editors.app_id=apps_release.app_id left join auth_user on apps_app_editors.user_id=auth_user.id where apps_release.created>"2015-03-01 01:01:01"; 

AppStore (last edited 2017-02-23 20:08:50 by AlexPico)

Funding for Cytoscape is provided by a federal grant from the U.S. National Institute of General Medical Sciences (NIGMS) of the Na tional Institutes of Health (NIH) under award number GM070743-01. Corporate funding is provided through a contract from Unilever PLC.

MoinMoin Appliance - Powered by TurnKey Linux