[ECODP-dev] ODP status call > some questions to be answered.

Tue Oct 1 14:16:36 UTC 2013

Hi John,

On the most viewed dataset view:
   * does running ckan_clear_activity_table.sh have impact?
   * what is exactly counted. Which clicks lead to a number increase (To be
added to the Operations Manual too.)

   * what more statistics we can get from CKAN?

On user accounts:
   * are user only be created in lower case or not, what happens when one
is created in upper case?
     In rel.09.00 it seems that newly created publishers names with upper
case can only login with a user name in lower case...

kind regards,

Bert

-----

source /applications/ecodp/users/ecodp/ckan/conf/backup_restore.conf

if [ -z $RDF2CKAN_UPLOADS_FILES_DIR ] || [ -z "$APPLICATION_FILES_DIR" ] ||
[ -z "$TARGETBACKUPDIR" ] || [ -z "$CKAN_USER" ] || [ -z "$CKAN_PWD" ] || [
-z "$POSTGRES_USER" ] || [ -z "$POSTGRES_HOST" ]  ; then
    echo "configuration variables not proberly set"
    exit
    fi

DATE=`date +%Y-%m-%d-%H-%M-%S`

CKANHOME=/applications/ecodp/users/ecodp/ckan
CKANTMP=/applications/ecodp/users/ecodp/ckan/var/tmp

mkdir -p $CKANTMP

# default value; should not be changed
DATABASE=ecodp

echo "start clearing activity table"

# Dump the activity tables for prosperity
pg_dump  -a -t activity -t activity_detail -h $POSTGRES_HOST -U
$POSTGRES_USER $DATABASE> $CKANTMP/activity_backup_$DATE.sql
gzip $CKANTMP/activity_backup_$DATE.sql

# Clean their contents
psql -d $DATABASE -h $POSTGRES_HOST -U $POSTGRES_USER -c 'truncate
activity, activity_detail;'

echo "finished clearing activity table"

-- 
Bert Van Nuffelen

Semantic Technologies Software Architect at TenForce
www.tenforce.be

Bert.Van.Nuffelen at tenforce.com
Office: +32 (0)16 31 48 60
Mobile:+32 479 06 24 26
skype: bert.van.nuffelen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20131001/112f6158/attachment.html>