Hello,
I moved my Openfire DB back-end to postgresql. I have created the respective schema using database/*_postgresql.sql files (for the core and all the plugins), imported data from embedded-db/openfire.script, added and into conf/openfire.xml, and modified .
Unfortunately, OpenFire fills my logs with tons of error messages related to “monitoring” plugin. Other components seems to be OK.
Can you help me, please? Thank you.
The error message looks like this one:
2016.01.02 23:20:27 org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic XXX
java.io.IOException: The underlying backend has no canonical path
at org.jrobin.core.RrdDb.getCanonicalPath(Unknown Source)
at org.jrobin.core.Header.validateHeader(Unknown Source)
at org.jrobin.core.RrdDb.<init>(Unknown Source)
at org.jrobin.core.RrdDb.<init>(Unknown Source)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngin e.java:362)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
where XXX is proxyTransferRate, conversations, muc_outgoing, packet_count, etc.
I am sure that ofrrds table exists:
openfire=# \d ofrrds
Table "public.ofrrds"
Column | Type | Modifiers
-------------±-----------------------±----------
id | character varying(100) | not null
updateddate | bigint | not null
bytes | bytea |
Indexes:
"ofrrds_pk" PRIMARY KEY, btree (id)
And it contains “something”:
openfire=# select id,updateddate from ofrrds;
id | updateddate
-------------------±--------------
sessions | 1451776587083
muc_occupants | 1451776587096
server_bytes | 1451776587102
conversations | 1451776587113
packet_count | 1451776587126
muc_traffic | 1451776587141
server_sessions | 1451776587153
muc_users | 1451776587158
proxyTransferRate | 1451776587108
muc_rooms | 1451776587149
(10 rows)