Installation Problem - Tigase authentication against custom MySQL DB

  • warning: Creating default object from empty value in /home/webapp/drupal-6.28/sites/all/modules/advanced_forum/advanced_forum.module on line 492.
  • warning: Creating default object from empty value in /home/webapp/drupal-6.28/sites/all/modules/advanced_forum/advanced_forum.module on line 492.
  • warning: Creating default object from empty value in /home/webapp/drupal-6.28/sites/all/modules/advanced_forum/advanced_forum.module on line 492.
  • warning: Creating default object from empty value in /home/webapp/drupal-6.28/sites/all/modules/advanced_forum/advanced_forum.module on line 492.
8 replies [Last post]
Fri, 2010-06-04 07:10
Anonymous

Hi, I'm trying to install the latest version of Tigase on Snow Leopard 10.6.3.
I'm using "java -jar tigase-server-5.0.0-b2135.jar -console" to install and everything goes smoothly until I get to the last step where MySQL database gets created and I get the following 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: Invalid default value for 'last_logout'
Checking whether the database needs conversion
Something wrong, the schema still is not loaded...
Adding XMPP admin accounts
Database schema is invalid
****************************************
In my installation option, I selected custom authentication against MySQL database.

MySQL version I use is 5.1.33

I tried using creating tigasedb before running the installation and also letting the wizard create it for me. Both give me the same error.

Any ideas why this is happening?

Thanks
Marko

Top
Fri, 2010-06-04 08:43
#1
kobit's picture
Artur Hefczyc
Offline
Joined: 2006-09-03
Points: 267814

Setting up custom authentication is a bit tricky as it is... custom stuff. My suggestion is to install Tigase with default MySQL authentication settings and then change the configuration file manually for custom authentication.
I will look at the installer though to find out whether I can fix the problem in future versions.

Top
Mon, 2010-06-07 01:00
#2
Marko (not verified)

I still get the same error, even with default MySQL settings. This wasn't an issue in v4.3.1 though.

Top
Mon, 2010-06-07 14:31
#3
kobit's picture
Artur Hefczyc
Offline
Joined: 2006-09-03
Points: 267814

Have you tried a fresh install or you are trying to install over the previous installation? Try fresh install.
If this still does not solve your problem you could possibly send me your config file and zipped log files. I might be able to help you having this information.

Top
Mon, 2010-06-07 14:36
#4
Marko (not verified)

Yeah I tried a fresh install. I.E. Stop the server, delete everything from "/Applications/tigase", empty trash, delete DB and run the jar again.

I'll try to send you the details tomorrow. Thanks for looking into this.

Marko

Top
Mon, 2010-06-07 15:15
#5
kobit's picture
Artur Hefczyc
Offline
Joined: 2006-09-03
Points: 267814

Do you have a way to run the installer in graphical mode? I just wonder if this might be related to the console mode...
I usually install Tigase on Mac using GUI installer.

Top
Tue, 2010-06-08 07:26
#6
Marko (not verified)

I haven't tried the GUI installer.
I'll give that a go when I get a changce and let you know how it goes.

Thanks
Marko

Top
Sat, 2010-06-12 04:26
#7
juice (not verified)

This is fixed by changing the last_logout default value to:

last_logout timestamp DEFAULT '1970-01-02 01:01:01',

Top
Sat, 2010-06-12 16:39
#8
kobit's picture
Artur Hefczyc
Offline
Joined: 2006-09-03
Points: 267814

Thank you for letting me know. I think this problem is already fixed in the development branch 5.1.0.

Top

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.