Thank you Eric for the wiki page. I agree that Galaxy Reports are not visible enough and this might help.
Martin, Galaxy Team On Fri, Jan 17, 2014 at 12:29 PM, Eric Rasche <rasche.e...@yandex.ru> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Well! This is the first I've heard of a Galaxy Reports page. Too bad I > already re-invented the wheel because I hadn't ever heard of this tool... > > Anyway, since "run_reports.sh" was only mentioned once anywhere in the > wiki (according to search, in a DevNewsBrief from 2008), I've added a > wiki page for the report tool. > > Please add whatever information you all feel I've left out. > https://wiki.galaxyproject.org/Admin/Usage%20Reports > > Cheers, > Eric Rasche > > On 01/17/2014 10:38 AM, Liisa Koski wrote: > > Hello, > > First..I love the Galaxy Reports tool...thanks so much for this. > > > > I did however come across an error when trying to few the Registered > > Users per month link. It would be really nice to have this working :) > > > > Thanks in advance, > > Liisa > > > > > > URL: http://domain:9001/users/registered_users_per_month > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month> > > Module paste.exceptions.errormiddleware:*144* in __call___ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >app_iter*=* > > self*.*application*(*environ*,* sr_checker*)* > > Module paste.debug.prints:*106* in __call___ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >environ*,* > > self*.*app*)* > > Module paste.wsgilib:*543* in intercept_output_ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >app_iter*=* > > application*(*environ*,* replacement_start_response*)* > > Module paste.lint:*170* in lint_app_ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >iterator*=* > > application*(*environ*,* start_response_wrapper*)* > > Module paste.recursive:*84* in __call___ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >*return*self*.*application*(*environ*,* > > start_response*)* > > Module paste.httpexceptions:*633* in __call___ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >*return*self*.*application*(*environ*,* > > start_response*)* > > Module galaxy.web.framework.base:*132* in __call___ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >*return*self*.*handle_request*(* > > environ*,* start_response*)* > > Module galaxy.web.framework.base:*190* in handle_request_ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >body*=* > > method*(* trans*,* ****kwargs*)* > > Module galaxy.webapps.reports.controllers.users:*29* in > > registered_users_per_month_ > > __>> _ > > <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# > >*for*row*in*q*.*execute*():* > > Module sqlalchemy.sql.expression:*2841* in execute > > Module sqlalchemy.engine.base:*2453* in _execute_clauseelement > > Module sqlalchemy.engine.base:*1584* in _execute_clauseelement > > Module sqlalchemy.engine.base:*1698* in _execute_context > > Module sqlalchemy.engine.base:*1691* in _execute_context > > Module sqlalchemy.engine.default:*331* in do_execute > > Module MySQLdb.cursors:*173* in execute > > Module MySQLdb.connections:*36* in defaulterrorhandler* > > OperationalError: (OperationalError) (1305, 'FUNCTION > > galaxy_production.date_trunc does not exist') 'SELECT date_trunc(%s, > > date(galaxy_user.create_time)) AS date, count(galaxy_user.id) AS > > num_users \nFROM galaxy_user GROUP BY date_trunc(%s, > > date(galaxy_user.create_time)) ORDER BY date DESC' ('month', 'month')* > > > > > > > > ___________________________________________________________ > > Please keep all replies on the list by using "reply all" > > in your mail client. To manage your subscriptions to this > > and other Galaxy lists, please use the interface at: > > http://lists.bx.psu.edu/ > > > > To search Galaxy mailing lists use the unified search at: > > http://galaxyproject.org/search/mailinglists/ > > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.17 (GNU/Linux) > > iQIcBAEBAgAGBQJS2Wh7AAoJEMqDXdrsMcpVlZsP/0PtATKuyVA8Dt3U9NzEnSd3 > oe2duZcCiIEqKrsllazdoH9l1uJja49d66FuOLcQag2/nNONVcNSSQXw4EbYqRe4 > piZTf4bptsm1m44c615NCbfvUCg5XpGW6SniA5WWAbH2c4p+TRWiA5+N6AtD6GC0 > +V5l8JScuPXyRt8Zq6Kt22mLYMeimRVOM2Y6PjSqqm/+kldvhzlwRWaQS7YCIH6v > CBiHCA13XTvaJKl3NpSaJ4CpOMkVUOjZg1eKTlydUGespOUX5w1ZVZl6J/rvIAUd > M7JRou1FtFeilCW/MiS6sgKFI4xl5IwZI4pxvq2s8dbOFSBKnz2p0/thcVjnPFzY > x3yPM4A6lIehRrJHLOa3IiqEAjb/q0pmmla+Lh53dURhEWw6FISyktwng5Yaa/IS > o/O6P+/paH/ujaOUFIMTEtb1hxoyUdkjDEaNLRwCpDlimqYOYhRG+XrAK9/8rbh5 > 8lntRnjN32Istkrq8Dk1p6ZRCceiYqfNZWdwHdvB65TYwcHfP7jmOAdLrObd3TN5 > Fy+irjZALmCng8BBksJ5661xqXWICYwyW9U2XiVdPVBnb9DF2orCpsqQ2WRwWWFK > mqJiGqpTSULy8FaPOsUQVc1n+ZafBaTgHs/XgM8PAfd8PlKUiZiaFhMkfuaUQ2so > QGWlEJDCFNEwG6vPIwYv > =7Tym > -----END PGP SIGNATURE----- > ___________________________________________________________ > Please keep all replies on the list by using "reply all" > in your mail client. To manage your subscriptions to this > and other Galaxy lists, please use the interface at: > http://lists.bx.psu.edu/ > > To search Galaxy mailing lists use the unified search at: > http://galaxyproject.org/search/mailinglists/ >
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
