Error installing 5.1.0: Incorrect table definition regarding TIMESTAMP column

17 posts / 0 new
Last post
Anonymous
Error installing 5.1.0: Incorrect table definition regarding TIMESTAMP column

I am trying to install the 5.1.0-beta2 version of Tigase on a brand new server and am getting the following error:

Checking connection to the database
Connection OK
Checking if the database exists
Exists OK
Checking the database schema
Can't load schema: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Checking whether the database needs conversion
Something wrong, the schema still is not loaded...
Adding XMPP admin accounts
Database schema is invalid

I looked at the database/mysql-schema-4.sql file and modified the query to the following:

-- Time the account has been created
acc_create_time timestamp DEFAULT NOW(),
-- Time of the last user login
last_login timestamp DEFAULT NOW(),
-- Time of the last user logout
last_logout timestamp DEFAULT NOW(),

But when re-configuring Tigase, it still tries to use the old query, as noted in the MySQL (5.5.11) query log:

4 Query create table if not exists tig_users ( uid bigint unsigned NOT NULL auto_increment, user_id varchar(2049) NOT NULL, sha1_user_id char(128) NOT NULL, user_pw varchar(255) default NULL, acc_create_time timestamp DEFAULT CURRENT_TIMESTAMP, last_login timestamp DEFAULT CURRENT_TIMESTAMP, last_logout timestamp DEFAULT CURRENT_TIMESTAMP, online_status int default 0, failed_logins int default 0, account_status int default 1, primary key (uid), unique key sha1_user_id (sha1_user_id), key user_pw (user_pw), key user_id (user_id(765)), key last_login (last_login), key last_logout (last_logout), key account_status (account_status), key online_status (online_status) ) ENGINE=InnoDB default character set utf8 ROW_FORMAT=DYNAMIC

Anyone know where I can change this query?

Application: 

Yes, this is known issue with Tigase and the last MySQL version. We have fixed it already and new release should install properly with MySQL 5.5.
In the meantime I suggest to download MySQL schema from the source repository and install it manually following the guide.

Anonymous

Ok, I imported the database that way, seemed to import just fine with no errors. Ran through the installer again, but only the configuration part of it. Seemed to configure ok (successful), modified the scripts/tigase.sh script to include JAVA_HOME, TIGASE_HOME, and TIGASE_CONFIG variables and started up Tigase.

Tried to register an account, and got this error in the tigase log:

2011-04-27 14:03:24 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.

Any idea what is causing this? Is something missing or misconfigured in the database caused by my manual db/table creation?

Thanks!

Anonymous

Tried your method, no success (see my other post). I then noticed you said it was a problem with MySQL 5.5, so I tried MySQL 5.0, same problem. Version tried:

# /usr/libexec/mysqld --version
/usr/libexec/mysqld Ver 5.0.77 for redhat-linux-gnu on x86_64 (Source distribution)

Same error:

Checking connection to the database
Connection OK
Checking if the database exists
Doesn't exist, creating... OK
Checking the database schema
Can't load schema: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Checking whether the database needs conversion
Something wrong, the schema still is not loaded...
Adding XMPP admin accounts
Database schema is invalid

Modification to database/mysql-schema-4.sql:

# cat database/mysql-schema-4.sql |grep timestamp |head -3
acc_create_time timestamp DEFAULT '1970-01-01 01:01:01',
last_login timestamp DEFAULT '1970-01-01 01:01:01',
last_logout timestamp DEFAULT '1970-01-01 01:01:01',

Anyone know how I can successfully install Tigase 5.1.0-beta2's DB?

As I said, use the MySQL schema from the trunk SVN repository which has this problem fixed. Have a look at the current file, line 49 to 53: mysql-schema-4.sql It does look different from what you show in your comment above. Here is how I installed the Beta2: First from the command line create database and load the schema:

 $ mysql --version
mysql  Ver 14.14 Distrib 5.5.10, for osx10.6 (i386) using readline 5.1
 $ mysqladmin -u root -p create dbtest
Enter password: 
 $ svn checkout https://svn.tigase.org/reps/tigase-server/trunk/database database
A    database/mysql-schema-4-test.sql
A    database/postgresql-schema-4-sp.schema
A    database/sqlserver-schema.sql
A    database/sqlserver-schema-4.sql
A    database/derby-schema-4-sp.schema
A    database/mysql-schema-4-sp.schema
A    database/postgresql-create-db.sql
A    database/derby-create-db.sql
A    database/mysql-create-db.sql
A    database/postgresql-schema.sql
A    database/postgresql-schema-4.sql
A    database/mysql-schema.sql
A    database/postgresql-schema-4-props.sql
A    database/derby-schema-4.sql
A    database/mysql-message-archive-schema.sql
A    database/mysql-schema-4.sql
A    database/mysql-schema-4-props.sql
A    database/derby-schema-4-props.sql
A    database/postgresql-schema-upgrade-to-4.sql
A    database/mysql-schema-upgrade-to-4.sql
Checked out revision 2639.
 $ mysql -u root -p dbtest < database/mysql-schema-4.sql 
Enter password: 
uid
1
NOW()	- Setting schema version to 4.0
2011-04-29 11:26:14	 - Setting schema version to 4.0
 $ 

Next, run the installer and install the Tigase in a normal way, here are a few screenshots from the most important windows:

Anonymous

Is the GUI installer different than the console installer? I am not installing via GUI. I am installing via console.

The mysql-schema-4.sql file in subversion is exactly the same as the one that comes with beta2, except for the "DEFAULT CURRENT_TIMESTAMP" is changed to "DEFAULT 0". As you'll notice in my mysqld log output, the query still contains "DEFAULT CURRENT_TIMESTAMP", even though I change it to a 1970 timestamp ("0" in subversion, I just don't like "0").

To be sure I'm not crazy:

# ls -al database/mysql-schema-4*
-rw-r--r-- 1 root root 5235 Apr 27 13:59 database/mysql-schema-4-foo.sql
-rw-r--r-- 1 root root 983 Feb 11 17:29 database/mysql-schema-4-props.sql
-rw-r--r-- 1 root root 13462 Mar 9 11:32 database/mysql-schema-4-sp.schema
-rw-r--r-- 1 root root 3390 Feb 11 17:29 database/mysql-schema-4-test.sql

Performing DB tasks

Checking connection to the database
Connection OK
Checking if the database exists
Exists OK
Checking the database schema
Can't load schema: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Checking whether the database needs conversion
Something wrong, the schema still is not loaded...
Adding XMPP admin accounts
Database schema is invalid

It still finds the schema somewhere, tries to load it, mysql returns the same error. The database/mysql-schema-4.sql file doesn't exist...

Anonymous

BTW, I did try loading the schema manually before (see previous post) and it did load fine with the fix, but I still got an error saying the DB may have been misconfigured, which is why I was going back to the installer to do the DB import.

Just wanted to make this point clear.

The console installer is the same as the GUI, the same code is used for the database installation. If you make changes to the schema files then I you are on your own, I cannot help in such a case.

I admit there is a problem with Beta2 and MySQL 5.5.0, I have tested it with MySQL 5.1.0 before the release. The fix is in SVN now and will be included in Beta3.
I have posted above steps to install the Beta2 with MySQL 5.5.0, did you try this way? I mean without changing anything.

Anonymous

Yes, I was able to manually import the database just fine, per your instructions. However, I am getting this error:

2011-04-27 14:03:24 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.

What causes this?

"probably DB misconfiguration problem" :-)
May I see your init.properties file content?

Anonymous

init.properties, minus the password, hostname:

--user-db = mysql
--admins = admin@
--user-db-uri = jdbc:mysql://localhost/tigasedb?user=tigase&password=
config-type = --gen-config-def
--virt-hosts =
--debug = server,tigase.xmpp,tigase.xmpp.impl,tigase.conf,tigase.db,tigase.io,tigase.net,tigase.xml,tigase.server.bosh
--comp-name-1=pubsub
--comp-class-1=tigase.pubsub.PubSubComponent
--monitoring=jmx:9050,http:9080,snmp:9060
bosh/max-inactivity[L]=60

# mysql -h localhost -u tigase -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Anonymous

Tried with DerbyDB, getting the same error, here is the new init.properties file:

--user-db = derby
--admins = admin@
--user-db-uri = jdbc:derby:/opt/tigase/tigasedb
config-type = --gen-config-def
--virt-hosts =
--debug = server
--debug = server,tigase.xmpp,tigase.xmpp.impl,tigase.conf,tigase.db,tigase.io,tigase.net,tigase.xml,tigase.server.bosh
--comp-name-1=pubsub
--comp-class-1=tigase.pubsub.PubSubComponent
--monitoring=jmx:9050,http:9080,snmp:9060
bosh/max-inactivity[L]=60

Error:

2011-04-29 20:16:05 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.

This error comes up when trying to register an account using Psi for Mac.

Are there any other errors or exceptions earlier in the log file? With the configuration file you show this kind of error seems impossible.
Or maybe you have removed too much from the configuration file when you edited if before posting?

Anonymous

The init.properties I posted is the entire file, I simply removed the password and hostname text.

logs/tigase-console.log:

STARTED Tigase Fri Apr 29 20:15:21 GMT 2011
2011-04-29 20:15:21 DNSResolver.() WARNING: Resolving default host name took: 10
2011-04-29 20:15:21 ConfiguratorAbstract.parseArgs() CONFIG: Setting defaults: -c=/opt/tigase/etc/tigase.conf
2011-04-29 20:15:21 MessageRouter.addRegistrator() INFO: Adding registrator: Configurator
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: Configurator
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: basic-conf: Loaded admin command from file: scripts/admin/ConfigList.groovy, id: config-list, ext: groovy, descr: List server/component configuration
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
Loading plugin: session-close=4 ...
2011-04-29 20:15:22 SocketThread.() WARNING: 97 socketReadThreads started.
2011-04-29 20:15:22 SocketThread.() WARNING: 97 socketWriteThreads started.
Loading plugin: session-open=4 ...
Loading plugin: default-handler=4 ...
Loading plugin: jabber:iq:register=2 ...
Loading plugin: jabber:iq:auth=24 ...
Loading plugin: urn:ietf:params:xml:ns:xmpp-sasl=24 ...
Loading plugin: urn:ietf:params:xml:ns:xmpp-bind=2 ...
Loading plugin: urn:ietf:params:xml:ns:xmpp-session=2 ...
Loading plugin: jabber:iq:roster=48 ...
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=24 ...
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: presence=48 ...
Loading plugin: disco=2 ...
2011-04-29 20:16:04 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.
2011-04-29 20:16:05 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.

logs/tigase.log.0:

2011-04-29 20:15:21 ConfiguratorAbstract.setupLogManager() CONFIG: DONE
2011-04-29 20:15:21 SSLContextContainer.init() CONFIG: Loading server certificates from PEM directory: certs/
2011-04-29 20:15:21 SSLContextContainer.init() CONFIG: Loaded server certificate for alias: hostname
2011-04-29 20:15:21 SSLContextContainer.loadTrustedCerts() CONFIG: Loading trustKeyStore from locations: [/etc/ssl/certs]
2011-04-29 20:15:21 AuthRepositoryMDImpl.initRepository() INFO: Multi-domain repository pool initialized: jdbc:derby:tigase-derbydb;create=true, params: {}
2011-04-29 20:15:21 UserRepositoryMDImpl.initRepository() INFO: Multi-domain repository pool initialized: jdbc:derby:tigase-derbydb;create=true, params: {}
2011-04-29 20:15:21 SSLContextContainer.loadTrustedCerts() CONFIG: Loaded 0 trust certificates, it took 0 seconds.
2011-04-29 20:15:21 ConfiguratorAbstract.addUserRepo() INFO: [DEFAULT] Initialized tigase.db.DummyRepository as user repository pool:, 1 url: jdbc:derby:tigase-derbydb;create=true
2011-04-29 20:15:21 ConfiguratorAbstract.addAuthRepo() INFO: [DEFAULT] Initialized tigase.db.DummyRepository as user auth repository pool: 1, url: jdbc:derby:tigase-derbydb;create=true
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: message-router
2011-04-29 20:15:21 MessageRouterConfig.getDefaults() CONFIG: Cluster mode: null
2011-04-29 20:15:21 MessageRouterConfig.getDefaults() CONFIG: Cluster mode is off.
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: message-router loaded incoming filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: message-router loaded outgoing filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 MessageRouterConfig.getRegistrNames() CONFIG: [vhost-man, stats]
2011-04-29 20:15:21 MessageRouter.addRegistrator() INFO: Adding registrator: VHostManager
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: VHostManager
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: vhost-man: Loaded admin command from file: scripts/admin/CompRepoItemAdd.groovy, id: comp-repo-item-add, ext: groovy, descr: Add new item
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: vhost-man: Loaded admin command from file: scripts/admin/CompRepoItemRemove.groovy, id: comp-repo-item-remove, ext: groovy, descr: Remove an item
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: vhost-man: Loaded admin command from file: scripts/admin/CompRepoItemUpdate.groovy, id: comp-repo-item-update, ext: groovy, descr: Update item configuration
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: vhost-man: Loaded admin command from file: scripts/admin/CompRepoReload.groovy, id: comp-repo-reload, ext: groovy, descr: Reload component repository
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: vhost-man: Loaded admin command from file: scripts/admin/SSLCertificateAdd.groovy, id: ssl-certificate-add, ext: groovy, descr: Add SSL Certificate
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 ConfigRepository.setProperties() CONFIG: Loading config item: hostname
2011-04-29 20:15:21 ConfigRepository.setProperties() CONFIG: Loading config item: localhost
2011-04-29 20:15:21 UserRepoRepository.setProperties() CONFIG: Using shared repository instance.
2011-04-29 20:15:21 UserRepoRepository.reload() CONFIG: All loaded items: {hostname=Domain: hostname, enabled: true, anonym: true, register: true, maxusers: 0, localhost=Domain: localhost, enabled: true, anonym: true, register: true, maxusers: 0}
2011-04-29 20:15:21 MessageRouter.addRegistrator() INFO: Adding registrator: StatisticsCollector
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: StatisticsCollector
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: stats
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 MessageRouterConfig.getMsgRcvNames() CONFIG: [bosh, c2s, monitor, s2s, sess-man]
2011-04-29 20:15:21 MessageRouter.addRouter() INFO: Adding receiver: BoshConnectionManager
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: BoshConnectionManager
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: bosh
2011-04-29 20:15:21 ConnectionManager.getDefaults() CONFIG: bosh defaults: {--test=false, config-type=--gen-config-default, -c=/opt/tigase/etc/tigase.conf}
2011-04-29 20:15:21 ConnectionManager.putDefPortParams() CONFIG: Generating defaults for port: 5,280
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: bosh loaded incoming filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: bosh loaded outgoing filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: type=accept
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: socket=plain
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: ifc=[Ljava.lang.String;@4a5f2db0
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: remote-host=localhost
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: required=false
2011-04-29 20:15:21 MessageRouter.addRouter() INFO: Adding receiver: ClientConnectionManager
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: ClientConnectionManager
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: c2s
2011-04-29 20:15:21 ConnectionManager.getDefaults() CONFIG: c2s defaults: {--test=false, config-type=--gen-config-default, -c=/opt/tigase/etc/tigase.conf}
2011-04-29 20:15:21 ConnectionManager.putDefPortParams() CONFIG: Generating defaults for port: 5,222
2011-04-29 20:15:21 ConnectionManager.putDefPortParams() CONFIG: Generating defaults for port: 5,223
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: c2s loaded incoming filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: c2s loaded outgoing filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: type=accept
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: socket=plain
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: ifc=[Ljava.lang.String;@2322bce
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: remote-host=localhost
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: required=false
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: type=accept
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: socket=ssl
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: ifc=[Ljava.lang.String;@2322bce
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: remote-host=localhost
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: required=false
2011-04-29 20:15:21 MessageRouter.addRouter() INFO: Adding receiver: MonitorComponent
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: MonitorComponent
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: monitor: Loaded admin command from file: scripts/admin/LoadErrors.groovy, id: load-errors, ext: groovy, descr: Load errors
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: monitor loaded incoming filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: monitor loaded outgoing filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 MessageRouter.addRouter() INFO: Adding receiver: S2SConnectionManager
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: S2SConnectionManager
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: s2s
2011-04-29 20:15:21 ConnectionManager.getDefaults() CONFIG: s2s defaults: {--test=false, config-type=--gen-config-default, -c=/opt/tigase/etc/tigase.conf}
2011-04-29 20:15:21 ConnectionManager.putDefPortParams() CONFIG: Generating defaults for port: 5,269
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: sess-man
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: s2s loaded incoming filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: s2s loaded outgoing filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: type=accept
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: socket=plain
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: ifc=[Ljava.lang.String;@64e265d0
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: remote-host=localhost
2011-04-29 20:15:21 ConnectionManager.setProperties() CONFIG: Adding port property key: required=false
2011-04-29 20:15:21 MessageRouter.addRouter() INFO: Adding receiver: SessionManager
2011-04-29 20:15:21 MessageRouter.addComponent() INFO: Adding component: SessionManager
2011-04-29 20:15:21 ConfiguratorAbstract.componentAdded() CONFIG: component: sess-man
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/HelloWorld.groovy, id: hello, ext: groovy, descr: Hello World Script.
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/UserRosterManagementExt.groovy, id: user-roster-management-ext, ext: groovy, descr: Update user roster entry, extended version.
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/UserDomainFilter.groovy, id: user-domain-perm, ext: groovy, descr: Command to change user inter-domain communication permission.
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: monitor
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/AddUser.groovy, id: add-user, ext: groovy, descr: Add user
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/BroadcastToOnline.groovy, id: online-broadcast, ext: groovy, descr: Broadcast to online
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/GroovyExample.groovy, id: groovy-example, ext: groovy, descr: An example script for Tigase scripting guide
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/OnlineUsersList.groovy, id: users-list, ext: groovy, descr: List of online users
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: basic-conf
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man,ext
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: vhost-man
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/CheckUserOnline.groovy, id: check-online-user, ext: groovy, descr: Checks if the user is online, where he is connected from and how many connections.
2011-04-29 20:15:21 Script.init() INFO: Initialized script command, lang: groovy, ext: groovy
2011-04-29 20:15:21 BasicComponent.loadScripts() CONFIG: sess-man: Loaded admin command from file: scripts/admin/UserRosterManagement.groovy, id: user-roster-management, ext: groovy, descr: Update user roster entry
2011-04-29 20:15:21 BasicComponent.loadScripts() INFO: Admin script for a different component: cl-comp
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: sess-man loaded incoming filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:21 AbstractMessageReceiver.setProperties() CONFIG: sess-man loaded outgoing filter: tigase.server.filters.PacketCounter
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Using shared repository instance: tigase.db.UserRepositoryMDImpl
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Using shared auth repository instance: tigase.db.AuthRepositoryMDImpl
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading concurrency plugins list: []
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading:
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loaded plugins list: [session-close, session-open, default-handler, jabber:iq:register, 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:roster, 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, presence, domain-filter, disco]
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: session-close
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 4, queue: 5,862 for plugin id: session-close
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: SessionCloseProc for plugin id: session-close
2011-04-29 20:15:22 SocketThread.() WARNING: 97 socketReadThreads started.
2011-04-29 20:15:22 SocketThread.() WARNING: 97 socketWriteThreads started.
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: session-open
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 4, queue: 5,862 for plugin id: session-open
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: SessionOpenProc for plugin id: session-open
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: default-handler
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 4, queue: 5,862 for plugin id: default-handler
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: DefaultHandlerProc for plugin id: default-handler
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: jabber:iq:register
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: jabber:iq:register
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqRegister for plugin id: jabber:iq:register
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: jabber:iq:auth
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 24, queue: 5,862 for plugin id: jabber:iq:auth
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqAuth for plugin id: jabber:iq:auth
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: urn:ietf:params:xml:ns:xmpp-sasl
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 24, queue: 5,862 for plugin id: urn:ietf:params:xml:ns:xmpp-sasl
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: SaslAuth for plugin id: urn:ietf:params:xml:ns:xmpp-sasl
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: urn:ietf:params:xml:ns:xmpp-bind
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: urn:ietf:params:xml:ns:xmpp-bind
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: BindResource for plugin id: urn:ietf:params:xml:ns:xmpp-bind
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: urn:ietf:params:xml:ns:xmpp-session
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: urn:ietf:params:xml:ns:xmpp-session
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: SessionBind for plugin id: urn:ietf:params:xml:ns:xmpp-session
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: jabber:iq:roster
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 48, queue: 5,862 for plugin id: jabber:iq:roster
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqRoster for plugin id: jabber:iq:roster
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added stopped processor: JabberIqRoster for plugin id: jabber:iq:roster
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: jabber:iq:privacy
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: jabber:iq:privacy
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqPrivacy for plugin id: jabber:iq:privacy
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added preprocessor: JabberIqPrivacy for plugin id: jabber:iq:privacy
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added packet filter: JabberIqPrivacy for plugin id: jabber:iq:privacy
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: jabber:iq:version
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: jabber:iq:version
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqVersion for plugin id: jabber:iq:version
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: http://jabber.org/protocol/stats
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: http://jabber.org/protocol/stats
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqStats for plugin id: http://jabber.org/protocol/stats
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: starttls
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: starttls
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: StartTLS for plugin id: starttls
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: msgoffline
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 24, queue: 5,862 for plugin id: msgoffline
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: OfflineMessages for plugin id: msgoffline
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added postprocessor: OfflineMessages for plugin id: msgoffline
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: vcard-temp
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: vcard-temp
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: VCardTemp for plugin id: vcard-temp
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: http://jabber.org/protocol/commands
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: http://jabber.org/protocol/commands
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqCommand for plugin id: http://jabber.org/protocol/commands
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: jabber:iq:private
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: jabber:iq:private
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: JabberIqPrivate for plugin id: jabber:iq:private
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: urn:xmpp:ping
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: urn:xmpp:ping
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: UrnXmppPing for plugin id: urn:xmpp:ping
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: presence
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 48, queue: 5,862 for plugin id: presence
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: Presence for plugin id: presence
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added stopped processor: Presence for plugin id: presence
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: domain-filter
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added preprocessor: DomainFilter for plugin id: domain-filter
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added packet filter: DomainFilter for plugin id: domain-filter
2011-04-29 20:15:22 SessionManager.setProperties() CONFIG: Loading and configuring plugin: disco
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Created thread pool: 2, queue: 5,862 for plugin id: disco
2011-04-29 20:15:22 SessionManager.addPlugin() CONFIG: Added processor: ServiceDiscovery for plugin id: disco
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: c2s
2011-04-29 20:15:22 UpdatesChecker.run() INFO: Server version: 5.1.0
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: basic-conf
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: s2s
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: bosh
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: vhost-man
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: sess-man
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: message-router
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: stats
2011-04-29 20:15:22 MessageRouter.setProperties() INFO: Initialization completed notification to: monitor
2011-04-29 20:16:04 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.
2011-04-29 20:16:05 SaslAuth.supStreamFeatures() WARNING: Database problem: tigase.db.TigaseDBException: No euthentication mechanisms found, probably DB misconfiguration problem.

The log content was actually very helpful and I think I found the source of your problems. The configuration file you posted earlier is not loaded at all and only some defaults are being generated. The server does not connect to MySQL database, instead it tries to access Derby database.

I think you start it up incorrectly and as a result it does not load a proper configuration, all the later problems are caused by this.

What exact command do you use to start it up?

Anonymous

That was it. I was setting the TIGASE_HOME and TIGASE_CONFIG variables and simply executing:

/opt/tigase/scripts/tigase.sh start

Apparently it must execute from the parent directory and specify the config on the command line.

Seems to be working ok, now. Thanks for the help!

Great, I am glad I could help.
We have a proper ubuntu startup scripts in version 5.1.0 so it should be much easier then.