-----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/