Anything else need to do to upgrade mySQL DB for Enterprise Edition. And one error

Openfire Openfire Support
1

Just upgraded to Enterprise Edition 3.5.0. Thank you very much to the guys for opening it up for us all. We dig it.

Is there anything else I need to do to upgrade our mySQL DB to make it ready for Enterprise Edition?

And, in the same vein, I noticed this:

2008.04.12 19:56:58 com.jivesoftware.openfire.enterprise.stats.RrdSqlBackend.exists(RrdSqlBackend.ja va:190) Error while accessing information in database: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table ‘wildfire.entRRDs’ doesn’t exist

2008.04.12 19:56:58 com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(StatsEngin e.java:359) Error sampling for statistic proxyTransferRate

What can I do to resolve this?

Thanks much to everyone. Great groups. Great info’.

Cheers.

Thanks.

Peace.

Sjobeck

2

still getting this in “error.log” each time I start the daemon:

Table ‘wildfire.entRRDs’ doesn’t exist

Any one have a URL to where I can find the SQL query to resolve?

Thanks so much.

Sjobeck

3

Hi,

the script should be in plugins/enterprise/database/ and contain:

…

CREATE TABLE entRRDs (

id NVARCHAR(100) NOT NULL,

updatedDate BIGINT NOT NULL,

bytes IMAGE NULL,

CONSTRAINT entRRDs_pk PRIMARY KEY (id)

);

…

LG