Tigase Forge
Dashboards
Projects
Pull Requests
Issues
Builds
Packages
Code Search
server-core
Code
Pull Requests
Issues
List
Boards
Iterations
Builds
Packages
Statistics
Child Projects
OneDev 11.5.2
Documentation Support & Bug Report RESTful API Incompatibilities License Agreement Check Update
Projects tigase _server server-core Issues #925
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
wojciech.kapcia@tigase.net commented 7 years ago

%Daniel , please test above with MySQL and 7.1.2 version using web installer.
wojciech.kapcia@tigase.net 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.net 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.net 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.net commented 7 years ago

Looks good, thank you!
issue 1 of 1
Type
Bug
Priority
Normal
Assignee
wojciech.kapcia@tigase.net
RedmineID
6753
Version
tigase-server-7.1.4
Spent time
17h 30m
Issue Votes (0)
Login to vote
Watchers (0)
Reference
tigase/_server/server-core#925
Please wait...
Page is in error, reload to recover