update schema problem (#925)

Unknown opened 7 years ago

i download tigase-issue #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

Activities

Wojciech Kapcia (Tigase) commented 7 years ago

%Daniel , please test above with MySQL and 7.1.2 version using web installer.
Wojciech Kapcia (Tigase) commented 7 years ago

%kobit I'm pondering whether we should or not enable auto-creation of accounts in mailhandler script - currently if someone submits a ticket via e-mail it's marked as anonymous and we have no way () of getting more information (like MySQL version). Yes, it would cause more accounts in the system (but we already expect to have way more than those anonymous submissions) and the hyperbole I used () is not that handy (going through the logs or accessing fastmail support account gets in a way a bit).
Artur Hefczyc commented 7 years ago

%wojtek yes, exactly my thoughts. I think we should at least try it. My only concern and hesitation for this is the spam would create lots of new spammer accounts. But, yes, please go ahead and enable it.
Wojciech Kapcia (Tigase) commented 7 years ago

Artur Hefczyc wrote:

yes, exactly my thoughts. I think we should at least try it. My only concern and hesitation for this is the spam would create lots of new spammer accounts. But, yes, please go ahead and enable it.

I've enabled it and configured it to add users to FromMail group. While at it I also simplified setup to point it directly ruby script.
Artur Hefczyc commented 7 years ago

Great, thank you.
Daniel Wisnewski commented 7 years ago
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.
Wojciech Kapcia (Tigase) commented 7 years ago

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).
Daniel Wisnewski commented 7 years ago

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.
Wojciech Kapcia (Tigase) commented 7 years ago

Looks good, thank you!
Login to comment

Type	Bug
Priority	Normal
Assignee	Wojciech Kapcia (Tigase)
RedmineID	6753
Version	tigase-server-7.1.4
Spent time	0

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#925