hi, in case this is intended please close this issue

however: the table users only contains locally stored users
chaning users.uid to accounts.uid would make it possible to also have an overview over users which are originated from e.g.: an ldap source

e.g. diff

16c16
< query="SELECT ${envtableprefix}users.uid, COUNT(${envtableprefix}authtoken.uid) AS count FROM ${envtableprefix}users LEFT JOIN ${envtableprefix}authtoken ON ${envtableprefix}authtoken.uid = ${envtableprefix}users.uid GROUP BY ${envtableprefix}users.uid ORDER BY ${envtableprefix}users.uid ASC"
---
> query="SELECT ${envtableprefix}accounts.uid, COUNT(${envtableprefix}authtoken.uid) AS count FROM ${envtableprefix}accounts LEFT JOIN ${envtableprefix}authtoken ON ${envtableprefix}authtoken.uid = ${envtableprefix}accounts.uid GROUP BY ${envtableprefix}accounts.uid ORDER BY ${envtableprefix}accounts.uid ASC"
20c20
<     echo "graph_title Cloud users sessions"
---
>     echo "graph_title Cloud accounts sessions"
24c24
<     echo "graph_info Show the number of users opened sessions."
---
>     echo "graph_info Show the number of accounts opened sessions."

best regard norb

I don't have graphs in my diagramms. On command line I get:

$ sudo munin-run cloud_disk
mysql: [Warning] Using a password on the command line interface can be insecure.
user1.value 905010112
user2.value 47884276

Perhaps the myql-warning prevents munin to draw the graphs. Can you provide another method for mysql?

Stefan

Hello,

in /etc/munin/plugin-conf.d/munin-node:
[cloud_*]
env.dbuser owncloud
env.dbpassword mypassword
env.dbname owncloud
env.dbtableprefix oc_
env.quotaratio 0.95

If run on putty:
mysql -uowncloud -pmypassword

connected.

use owncloud;

work

after:
:/etc/munin/plugins# ls -all
total 8
drwxr-xr-x 2 root root 4096 avril 8 13:37 .
drwxr-xr-x 7 root root 4096 mars 18 21:31 ..
lrwxrwxrwx 1 root root 35 avril 8 13:37 cloud_disk -> /usr/share/munin/plugins/cloud_disk
lrwxrwxrwx 1 root root 36 avril 8 13:37 cloud_quota -> /usr/share/munin/plugins/cloud_quota
lrwxrwxrwx 1 root root 38 avril 8 13:37 cloud_session -> /usr/share/munin/plugins/cloud_session
lrwxrwxrwx 1 root root 36 avril 8 13:37 cloud_share -> /usr/share/munin/plugins/cloud_share
lrwxrwxrwx 1 root root 38 avril 8 13:37 cloud_storage -> /usr/share/munin/plugins/cloud_storage

reload munin

for all:
munin-run cloud_storage

Unknown service 'cloud_storage'

Unknown service 'cloud_disk'

Unknown service 'cloud_session'

no graph, no error in log file...
cloud_* doesn't displayed on munin-node-configure

munin work fine, i have rtorrent graph (work)

Latest owncloud

I have a account like "someuser." on my cloud. If i fetch the data manually I get:

someuser..label someuser.
someuser..critical 30601641984
someuser..info Quota is 30G
someuser..draw AREA

The graph shows
No . label provided

Hi Rauks,

it is not possible to configure an empty variable in munin-node.

Therefore it is not possible to use your plugins to monitor a cloud without table prefix.

So i removed the default value for me in your files.

Beste regards,
Jörg