how to start to play with local TIGASE server? (add user to local TIGASE server and connect to it with client)

Ah, right. This might be the case indeed. The tigae.conf file point the Tigase to correct location for all startup files, including configuration files with database connection details. If missing then no admin or any other account may work.

i had similar problem and the reason was that i ran server using

instead of

If you installed the Tigase server using our installer it creates an admin account automatically. The password is exactly what you entered on the installation screen which asks you to enter administrator accounts and passwords.

If you installed the Tigase by manually copying files then there is no admin account in database and you have to register a new account for yourself using any XMPP client.

Can I ask what is the password of the admin account?

> Any thoughts?

Yes. First thing first:

You normally use a different authentication database only if that database already exists. This function is used for integration of the Tigase server with other systems - website database, e-mail system, group collaboration system, etc...
Therefore if you select a different authentication database the installer doesn't try to create it, (perhaps it should try to connect to it to make sure settings are correct).
So obviously, as you selected Derby as authentication database, it just doesn't exist and the Tigase server can't connect to it.

You can, however select another authentication connector (Tigase Auth) and still use the same physical database for user data (roste, vcard, etc) and authentication data (user ID, password).

Another thing. I am not sure if you noticed that but the installer doesn't install MySQL for you. You have to do it on your own if you want to use MySQL as a database for the Tigase server. If you don't want to install it or don't know how to install it, I would suggest to stick to the default - Derby database which is installed by the Tigase installer. Derby is in fact kind of built-in database for the Tigase server and works well for small installations or for development purposes.

And last thing. From the log file, it looks like the init.property file you entered to your post was not used during the server run. The log shows that the Tigase tries to connect to the Derby database while the init.property file doesn't say anything about Derby database. If you change anything in the init.properties file or change configuration settings using the installer or reinstall the Tigase to the same directory with new configuration make sure you deleted tigase.xml file from 'etc/' directory.
More information about the Tigase configuration can be found in the online documentation.

If you try to reinstall the Tigase server from scratch my suggestion is to backup or delete the old installation and then run new installation, or install the Tigase server in a different directory.

Thanks for your quick reply.

I did clean installation again and still had problem.

I used MySQL as db and derby for the authentication db

Here is my init.properties

--cluster-mode = false
config-type = --gen-config-def
--cluster-nodes = localhost
--debug = server,xmpp.impl,db
--user-db = mysql
--auth-db = tigase-auth
--admins = admin@localhost
--user-db-uri = jdbc:mysql://127.0.0.1/tigasedb?user=tigase&password=passw02d
--virt-hosts = localhost
--comp-class-1 = tigase.muc.MUCComponent
--comp-name-1 = muc
--sm-plugins = +jabber:iq:auth,+urn:ietf:params:xml:ns:xmpp-sasl,+urn:ietf:params:xml:ns:xmpp-bind,+urn:ietf:params:xml:ns:xmpp-session,+jabber:iq:register,+roster-presence,+jabber:iq:privacy,+jabber:iq:version,+http://jabber.org/protocol/stats,+starttls,+msgoffline,+vcard-temp,+http://jabber.org/protocol/commands,+jabber:iq:private,+urn:xmpp:ping,+basic-filter,+domain-filter,+pep,-zlib

Below is the tigase-console.log

STARTED Tigase Wed Sep 30 23:06:20 CST 2009
2009-09-30 23:06:20 XMLDB.setupNewDB() INFO: Create empty DB.
2009-09-30 23:06:20 DNSResolver.<clinit>() WARNING: Resolving default host name took: 6
2009-09-30 23:06:20 MessageRouter.addRegistrator() INFO: Adding registrator: Configurator
2009-09-30 23:06:20 MessageRouter.addComponent() INFO: Adding component: Configurator
2009-09-30 23:06:20 Configurator.componentAdded() CONFIG: component: basic-conf
2009-09-30 23:06:20 ServiceEntity.findNode() FINEST: Looking for a node: basic-conf
2009-09-30 23:06:20 ServiceEntity.findNode() FINEST: Looking for a node: basic-conf
2009-09-30 23:06:20 ConfigRepository.getProperties() CONFIG: Reading properties for: basic-conf
2009-09-30 23:06:20 ConfigRepository.getProperties() CONFIG: Looking for properties for basic-conf in node.
2009-09-30 23:06:20 ConfigRepository.getProperties() CONFIG: Found keys: null
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Saving properties for: basic-conf
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=null, key=auth-repo-class, value=tigase.db.jdbc.JDBCRepository
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=auth-repo-params, key=param-1, value=value-1
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=null, key=auth-repo-url, value=jdbc:derby:tigase-derbydb;create=true
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=null, key=demo-mode, value=false
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=.level, value=CONFIG
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=handlers, value=java.util.logging.ConsoleHandler java.util.logging.FileHandler
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.ConsoleHandler.formatter, value=tigase.util.LogFormatter
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.ConsoleHandler.level, value=WARNING
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.FileHandler.append, value=true
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.FileHandler.count, value=5
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.FileHandler.formatter, value=tigase.util.LogFormatter
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.FileHandler.level, value=ALL
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.FileHandler.limit, value=10000000
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=java.util.logging.FileHandler.pattern, value=logs/tigase.log
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=logging, key=tigase.useParentHandlers, value=true
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=null, key=user-repo-class, value=tigase.db.jdbc.JDBCRepository
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=user-repo-params, key=param-1, value=value-1
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=null, key=user-repo-pool-size, value=1
2009-09-30 23:06:20 ConfigRepository.putProperties() CONFIG: Setting property: root=basic-conf, node=null, key=user-repo-url, value=jdbc:derby:tigase-derbydb;create=true
2009-09-30 23:06:22 Configurator.setProperties() SEVERE: Can't initialize user repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigase-derbydb;create=true
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java)
at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java)
at tigase.conf.Configurator.setProperties(Configurator.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.XMPPServer.main(XMPPServer.java)
Caused by: java.sql.SQLSyntaxErrorException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java)
... 10 more
Caused by: java.sql.SQLException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 20 more
Caused by: ERROR 42Y03: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 14 more

2009-09-30 23:06:22 Configurator.setProperties() SEVERE: Can't initialize auth repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigase-derbydb;create=true
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java)
at tigase.db.RepositoryFactory.getAuthRepository(RepositoryFactory.java)
at tigase.conf.Configurator.setProperties(Configurator.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.XMPPServer.main(XMPPServer.java)
Caused by: java.sql.SQLSyntaxErrorException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java)
... 10 more
Caused by: java.sql.SQLException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 20 more
Caused by: ERROR 42Y03: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 14 more

2009-09-30 23:06:22 Configurator.setProperties() SEVERE: Can't initialize user repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigase-derbydb;create=true
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java)
at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java)
at tigase.conf.Configurator.setProperties(Configurator.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.MessageRouter.setProperties(MessageRouter.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.XMPPServer.main(XMPPServer.java)
Caused by: java.sql.SQLSyntaxErrorException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java)
... 17 more
Caused by: java.sql.SQLException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 more
Caused by: ERROR 42Y03: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 21 more

2009-09-30 23:06:22 Configurator.setProperties() SEVERE: Can't initialize auth repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigase-derbydb;create=true
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java)
at tigase.db.RepositoryFactory.getAuthRepository(RepositoryFactory.java)
at tigase.conf.Configurator.setProperties(Configurator.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.MessageRouter.setProperties(MessageRouter.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.XMPPServer.main(XMPPServer.java)
Caused by: java.sql.SQLSyntaxErrorException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java)
... 17 more
Caused by: java.sql.SQLException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 more
Caused by: ERROR 42Y03: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 21 more

2009-09-30 23:06:22 VHostJDBCRepository.setProperties() SEVERE: Can't initialize VHost repositorytigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigase-derbydb;create=true
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java)
at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java)
at tigase.vhosts.VHostJDBCRepository.setProperties(VHostJDBCRepository.java)
at tigase.vhosts.VHostManager.setProperties(VHostManager.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addComponent(MessageRouter.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setProperties(MessageRouter.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.XMPPServer.main(XMPPServer.java)
Caused by: java.sql.SQLSyntaxErrorException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java)
... 18 more
Caused by: java.sql.SQLException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 28 more
Caused by: ERROR 42Y03: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 22 more

2009-09-30 23:06:22 SocketReadThread.getInstance() WARNING: 2 SocketReadThreads started.
2009-09-30 23:06:22 SessionManager.setProperties() SEVERE: Can't initialize auth repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:derby:tigase-derbydb;create=true
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java)
at tigase.db.RepositoryFactory.getAuthRepository(RepositoryFactory.java)
at tigase.server.xmppsession.SessionManager.setProperties(SessionManager.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addComponent(MessageRouter.java)
at tigase.server.MessageRouter.addRouter(MessageRouter.java)
at tigase.server.MessageRouter.setProperties(MessageRouter.java)
at tigase.conf.Configurator.setup(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.conf.Configurator.componentAdded(Configurator.java)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java)
at tigase.server.MessageRouter.setConfig(MessageRouter.java)
at tigase.server.XMPPServer.main(XMPPServer.java)
Caused by: java.sql.SQLSyntaxErrorException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java)
... 17 more
Caused by: java.sql.SQLException: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 more
Caused by: ERROR 42Y03: 'TIGGETDBPROPERTY' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.RowResultSetNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 21 more

[Deprecated] Xalan: org.apache.xml.utils.PrefixResolver
Loading plugin: jabber:iq:register=2 ...
Loading plugin: jabber:iq:auth=2 ...
Loading plugin: urn:ietf:params:xml:ns:xmpp-sasl=2 ...
Loading plugin: urn:ietf:params:xml:ns:xmpp-bind=2 ...
Loading plugin: urn:ietf:params:xml:ns:xmpp-session=2 ...
Loading plugin: roster-presence=4 ...
Loading plugin: jabber:iq:privacy=2 ...
Loading plugin: jabber:iq:version=2 ...
Loading plugin: http://jabber.org/protocol/stats=2 ...
Loading plugin: starttls=2 ...
Loading plugin: msgoffline=2 ...
Loading plugin: vcard-temp=2 ...
Loading plugin: http://jabber.org/protocol/commands=2 ...
Loading plugin: jabber:iq:private=2 ...
Loading plugin: urn:xmpp:ping=2 ...
Loading plugin: basic-filter=0 ...
2009-09-30 23:06:25 SessionManager.addPlugin() WARNING: No implementation found for plugin id: basic-filter
Loading plugin: domain-filter=0 ...
2009-09-30 23:06:25 SessionManager.setProperties() WARNING: Admin script found but it has no command ID or command description: scripts/admin/GroovyExample.groovy
2009-09-30 23:06:25 SessionManager.setProperties() WARNING: Admin script found but it has no command ID or command description: scripts/admin/UserDomainFilter.groovy
2009-09-30 23:06:36 AbstractMessageReceiver$QueueListener.run() SEVERE: [in_0-sess-man] Exception during packet processing: to=null, from=null, data=<iq id="eba54d35-ffff-437f-9466-1bee7cc3b986" type="get" from="c2s@localhost/0:0:0:0:0:0:0:1%0_5222_0:0:0:0:0:0:0:1%0_3225" to="sess-man@localhost"><command xmlns="http://jabber.org/protocol/commands" node="GETFEATURES"/></iq>, XMLNS=null, priority=HIGHjava.lang.NullPointerException
at tigase.xmpp.RepositoryAccess.queryAuth(RepositoryAccess.java)
at tigase.xmpp.XMPPResourceConnection.queryAuth(XMPPResourceConnection.java)
at tigase.xmpp.impl.SaslAuth.supStreamFeatures(SaslAuth.java)
at tigase.server.xmppsession.SessionManager.getFeatures(SessionManager.java)
at tigase.server.xmppsession.SessionManager.processCommand(SessionManager.java)
at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java)
at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java)

Any thoughts?

If you can't connect with your admin account then there must be a problem with either the Tigase server configuration or your client configuration. Maybe you have written the admin account name incorrectly? Please, remember you have to provide a full admin account name consisting of the user name part and the domain part, like: 'admin@some.domain.tld'.

If this still doesn't work, you can try to register a new account using any XMPP client. I would recommend the Psi client for you. There is even a simple guide for this client on our website: Psi initial configuration which might be helpful. Please note this guide describes configuration for a bit older Psi version than it is available now.

If this still doesn't work, please post here your exact error message you get (or exception) and also your configuration file - the init.properties file. I am sure we can together work this out.