-
Does this apply only to 7.2.0?
I think it's possible it may be related to newly introduced Kernel as other users created on ad-hoc basis (those are created during component startup) were created ok - for example
vhost-manager
which is not yet based on the Kernel.tigase.db.UserNotFoundException: User does not exist: multi-user-chat at tigase.db.jdbc.JDBCRepository.getUserUID(JDBCRepository.java:1232) at tigase.db.jdbc.JDBCRepository.getNodeNID(JDBCRepository.java:1202) at tigase.db.jdbc.JDBCRepository.getSubnodes(JDBCRepository.java:407) at tigase.db.UserRepositoryMDImpl.getSubnodes(UserRepositoryMDImpl.java:224) at tigase.muc.repository.MucDAO.getRoomsJIDList(MucDAO.java:151) at tigase.muc.repository.inmemory.InMemoryMucRepository.initialize(InMemoryMucRepository.java:264) at tigase.kernel.core.Kernel.initBean(Kernel.java:296) at tigase.kernel.core.Kernel.getInstance(Kernel.java:182) at tigase.component.AbstractKernelBasedComponent.setProperties(AbstractKernelBasedComponent.java:179) at tigase.muc.MUCComponent.setProperties(MUCComponent.java:192)
tigase.kernel.KernelException: Can't find bean implementing interface tigase.pubsub.repository.IPubSubRepository
Bartek - can you take a look?
-
Not able to confirm at this time due to dbschemaloader not setting up database properly. Attempted a number of previous builds, but cannot confirm with builds older than a month. will wait for #5371 fix.
-
While I haven't run into the same issue (as
multi-user-chat
user is setup later on) but I have a problem with adding admin user via setup:* adding admin account doesn't work Adding XMPP admin accounts ERROR Adding XMPP Admin Account, URI: jdbc:derby:tigaseinst123;create=true RepositoryFactory.getAuthRepository(null, jdbc:derby:tigaseinst123;create=true,{data-repo-pool-size=1}) Error initializing DBtigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigaseinst123;create=true
Dan, can you check this out in the latest builds?
-
Yes I just noticed this setting up a test server, it looks like the order is all wrong, database is made, admins added, and then schema files are loaded?
2017-04-24 13:34:51.810 [http-server-pool-2] DBSchemaLoader.<init>() CONFIG: Properties: {dbHostname=localhost, adminJID=admin@local, dbType=derby, rootUser=root, useSSL=false, dbPass=tigase12, adminJIDpass=tigase, dbName=tigasedb, schemaVersion=7-2, rootPass=123, dbUser=tigase} LogLevel: CONFIG 2017-04-24 13:34:51.813 [http-server-pool-2] DBSchemaLoader.<init>() CONFIG: Properties: {dbHostname=localhost, adminJID=admin@local, dbType=derby, rootUser=root, useSSL=false, dbPass=tigase12, adminJIDpass=tigase, dbName=tigasedb, schemaVersion=7-2, rootPass=123, dbUser=tigase} 2017-04-24 13:34:51.813 [http-server-pool-2] DBSchemaLoader.<init>() CONFIG: Properties: {dbHostname=localhost, adminJID=admin@local, dbType=derby, rootUser=root, useSSL=false, dbPass=tigase12, adminJIDpass=tigase, dbName=tigasedb, schemaVersion=7-2, rootPass=123, dbUser=tigase} 2017-04-24 13:34:51.825 [http-server-pool-2] DBSchemaLoader.validateDBConnection() INFO: Validating DBConnection, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:51.825 [http-server-pool-2] DBSchemaLoader.validateDBConnection() INFO: Validating DBConnection, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:58.819 [http-server-pool-2] DBSchemaLoader.validateDBConnection() CONFIG: DriverManager (available drivers): [org.apache.derby.jdbc.AutoloadedDriver@52e2b863, jTDS 1.3.1, com.mysql.jdbc.Driver@6879f885, com.mysql.fabric.jdbc.FabricMySQLDriver@6940afbc, org.postgresql.Driver@5ecffc82] 2017-04-24 13:34:58.819 [http-server-pool-2] DBSchemaLoader.validateDBConnection() CONFIG: DriverManager (available drivers): [org.apache.derby.jdbc.AutoloadedDriver@52e2b863, jTDS 1.3.1, com.mysql.jdbc.Driver@6879f885, com.mysql.fabric.jdbc.FabricMySQLDriver@6940afbc, org.postgresql.Driver@5ecffc82] 2017-04-24 13:34:58.819 [http-server-pool-2] DBSchemaLoader.validateDBConnection() INFO: Connection OK 2017-04-24 13:34:58.819 [http-server-pool-2] DBSchemaLoader.validateDBConnection() INFO: Connection OK 2017-04-24 13:34:58.820 [http-server-pool-2] DBSchemaLoader.validateDBExists() INFO: Validating whether DB Exists, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:58.820 [http-server-pool-2] DBSchemaLoader.validateDBExists() INFO: Validating whether DB Exists, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:58.821 [http-server-pool-2] DBSchemaLoader.validateDBExists() INFO: Exists OK 2017-04-24 13:34:58.821 [http-server-pool-2] DBSchemaLoader.validateDBExists() INFO: Exists OK 2017-04-24 13:34:58.822 [http-server-pool-2] DBSchemaLoader.validateDBSchema() INFO: Validating DBSchema, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:58.822 [http-server-pool-2] DBSchemaLoader.validateDBSchema() INFO: Validating DBSchema, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:58.950 [http-server-pool-2] DBSchemaLoader.validateDBSchema() WARNING: Exception, possibly schema hasn't been loaded yet. 2017-04-24 13:34:58.950 [http-server-pool-2] DBSchemaLoader.validateDBSchema() WARNING: Exception, possibly schema hasn't been loaded yet. 2017-04-24 13:34:58.950 [http-server-pool-2] DBSchemaLoader.validateDBSchema() INFO: DB schema doesn't exists, creating one..., URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:34:58.950 [http-server-pool-2] DBSchemaLoader.validateDBSchema() INFO: DB schema doesn't exists, creating one..., URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.071 [http-server-pool-2] DBSchemaLoader.validateDBSchema() INFO: New schema loaded OK 2017-04-24 13:35:03.071 [http-server-pool-2] DBSchemaLoader.validateDBSchema() INFO: New schema loaded OK 2017-04-24 13:35:03.072 [http-server-pool-2] DBSchemaLoader.addXmppAdminAccount() INFO: Adding XMPP Admin Account, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.072 [http-server-pool-2] DBSchemaLoader.addXmppAdminAccount() INFO: Adding XMPP Admin Account, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.072 [http-server-pool-2] DBSchemaLoader.addXmppAdminAccount() CONFIG: RepositoryFactory.getAuthRepository(null, jdbc:derby:tigasedb;create=true,{data-repo-pool-size=1}) 2017-04-24 13:35:03.072 [http-server-pool-2] DBSchemaLoader.addXmppAdminAccount() CONFIG: RepositoryFactory.getAuthRepository(null, jdbc:derby:tigasedb;create=true,{data-repo-pool-size=1}) 2017-04-24 13:35:03.139 [http-server-pool-2] DBSchemaLoader.addXmppAdminAccount() WARNING: Error initializing DBtigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.139 [http-server-pool-2] DBSchemaLoader.addXmppAdminAccount() WARNING: Error initializing DBtigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.140 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-muc-schema-2.5.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.140 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-muc-schema-2.5.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.968 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:03.968 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:03.968 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-pubsub-schema-3.3.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:03.968 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-pubsub-schema-3.3.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:06.289 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:06.289 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:06.289 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-message-archiving-schema-1.3.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:06.289 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-message-archiving-schema-1.3.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:09.077 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:09.077 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:09.077 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-http-api-schema-1.3.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:09.077 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: Loading schema from file(s): [database/derby-http-api-schema-1.3.0.sql], URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:09.363 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:09.363 [http-server-pool-2] DBSchemaLoader.loadSchemaFile() INFO: completed OK 2017-04-24 13:35:09.363 [http-server-pool-2] DBSchemaLoader.postInstallation() INFO: Post Installation, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:09.363 [http-server-pool-2] DBSchemaLoader.postInstallation() INFO: Post Installation, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:09.363 [http-server-pool-2] DBSchemaLoader.postInstallation() INFO: Finalizing... 2017-04-24 13:35:09.363 [http-server-pool-2] DBSchemaLoader.postInstallation() INFO: Finalizing... 2017-04-24 13:35:09.367 [http-server-pool-2] DBSchemaLoader.postInstallation() INFO: completed OK 2017-04-24 13:35:09.367 [http-server-pool-2] DBSchemaLoader.postInstallation() INFO: completed OK 2017-04-24 13:35:09.368 [http-server-pool-2] DBSchemaLoader.shutdownDerby() INFO: Validating DBConnection, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:09.368 [http-server-pool-2] DBSchemaLoader.shutdownDerby() INFO: Validating DBConnection, URI: jdbc:derby:tigasedb;create=true 2017-04-24 13:35:12.132 [http-server-pool-2] DBSchemaLoader.shutdownDerby() WARNING: Database 'tigasedb' shutdown. 2017-04-24 13:35:12.132 [http-server-pool-2] DBSchemaLoader.shutdownDerby() WARNING: Database 'tigasedb' shutdown.
-
Actually this is caused by: https://projects.tigase.org/issues/5416.
Closing this one as it's not possible to reproducible anymore.
Type |
Bug
|
Priority |
Normal
|
Assignee | |
RedmineID |
3927
|
Version |
tigase-server-8.0.0
|
Spent time |
0
|
Installing Tigase v7.2.0 using the web installer does not install all users properly, a fresh install on mySQL or derby yields the following error:
Attached is the tig_users table from v710 and v720
v710 tig_user.csv v720 tig_user.csv