Project

General

Profile

Bug #6753

update schema problem

Added by Anonymous 12 months ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
Due date:
% Done:

100%

Estimated time:
Database:
n/a
Applicable version:
7.1.2
Source Code Disclaimer:

Description

i download tigase-server-7.1.2-b4471-dist-max.tar.gz

and i configure in web.

then i configure script ./scripts/redhat/init.d/tigase start etc/tigase.conf and etc/tigase.conf

then i start tigase with./scripts/redhat/init.d/tigase start etc/tigase.conf

console show me

Please upgrade database schema now.
Current scheme version is: null, expected: 7.1
Check the schema upgrade guide at the address:
Administration Guide > Tigase Server Schema v7.1 Updates (available locally in docs directory and online http://docs.tigase.org )‍

then i find relative info
and i do sth below

java -cp "jars/*" tigase.util.DBSchemaLoader -dbHostname ${HOSTNAME} -dbType ${DB_TYPE} -rootUser ${ROOT_USER} -dbPass ${DB_USER_PASS} -dbName ${DB_NAME} -schemaVersion ${DB_VERSION} -rootPass ${ROOT_USER_PASS} -dbUser ${DB_USER}  -adminJID "${ADMIN_JID}" -adminJIDpass ${ADMIN_JID_PASS}  -logLevel ALL -file database/${DB_TYPE}-schema-upgrade-to-7-1.sql‍

console shows that

tig_pairs pid duplicate, invalid database schema‍

so i comment this wrong statement, and run again, then success.

and i run

java -cp "jars/*" tigase.util.DBSchemaLoader -dbHostname localhost -dbType mysql -rootUser root -rootPass root -dbUser admin -dbPass admin -schemaVersion 7.1 -dbName Tigasedb -adminJID "admin@local.com" -adminJIDPass adminpass -logLevel ALL -file database/mysql-schema-upgrade-to-7.1.sql‍

then i restart tigase. it still ask me for update.

i try did not comment that wrong statement. tigase start success but i cant register user with spark and the console always show me

Couldn‘t obtain user repository for domain: vhost-manager, not even default one!‍

please help, thanks

Associated revisions

Revision f0631997 (diff)
Added by Daniel Wisnewski IoT 1 Cloud 11 months ago

#6753 MySQL upgrade instructions added (master)

Revision cc7a3a1d (diff)
Added by Daniel Wisnewski IoT 1 Cloud 11 months ago

#6753 Added MySQL upgrade instructions (Stable)

History

#1 Updated by Wojciech Kapcia TigaseTeam 12 months ago

  • Tracker changed from Support to Bug
  • Project changed from Support to Tigase XMPP Server
  • Description updated (diff)
  • Assignee changed from Wojciech Kapcia to Daniel Wisnewski
  • Target version set to tigase-server-7.1.4
  • Applicable version set to 7.1.2
  • Source Code Disclaimer set to No
  • Database n/a added

%Daniel , please test above with MySQL and 7.1.2 version using web installer.

#6 Updated by Daniel Wisnewski IoT 1 Cloud 12 months ago

  • Assignee changed from Daniel Wisnewski to Wojciech Kapcia

When using v5.7.x MySQL with this older version, it has an issue with performance_template, and when running an exiting installation, or installing a new one this error occurs:

tigase.util.DBSchemaLoader       validateDBConnection    WARNING    Table 'performance_schema.session_variables' doesn't exist

users of mysql using this should run

mysql_upgrade -u root -p --force

I think this should be added to documentation in latest version of v7.1.x

After this upgrade installing db on mysql and running Tigase operates as expected. I did not see errors in description as database initialization worked fine with web installer.

It is possible that during the setup the error above showed, however web installer posted ERROR for me in this instance.

#7 Updated by Wojciech Kapcia TigaseTeam 11 months ago

  • Assignee changed from Wojciech Kapcia to Daniel Wisnewski

Dan, good idea - please include this in our documentation (both sample error and the solution to the problem) for version 7.1.x (stable branch) and for upcoming 8.0.x (master branch).

#8 Updated by Daniel Wisnewski IoT 1 Cloud 11 months ago

  • Status changed from New to Feedback
  • Assignee changed from Daniel Wisnewski to Wojciech Kapcia
  • % Done changed from 0 to 100

Added to documentation with error presented and solution, both master and stable branches are updated within the dbschemaloader documentation pages. Close ticket if changes are acceptable.

#9 Updated by Wojciech Kapcia TigaseTeam 11 months ago

  • Status changed from Feedback to Closed

Looks good, thank you!

Also available in: Atom PDF