mysql DB errors

4 posts / 0 new
Last post
Anonymous
mysql DB errors

Hi,

i'm trying to set up a tigase with mysql database. When i try to start the server i get several errors:

2010-10-14 14:35:12 ConfiguratorAbstract.setProperties() SEVERE: Can't initialize auth repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:mysql://myserver.net:3306/tigase?user=user&password=password
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:433)
at tigase.db.RepositoryFactory.getAuthRepository(RepositoryFactory.java:123)
...

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION tigase.TigGetDBProperty does not exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
....

I did follow the steps described here: http://www.tigase.org/content/prepare-mysql-database-tigase-server

As i understand the problem tigase tries to use a stored procedure that isn't there.

I hope you can help me fix that.

Application: 
Tags: 

Please check the guide again at the step 3. You probably loaded the old schema for the version 4 or earlier. I assume you are using the most recent Tigase version 5.x, then you need to load db schema-4 which includes required stored procedures.

AlexanderB

SQL-Befehl:

-- QUERY END:
-- QUERY START:
-- Database properties get - function
CREATE FUNCTION TigGetDBProperty(
_tkey varchar( 255 ) CHARSET utf8
) RETURNS mediumtext CHARSET utf8READS SQL DATA BEGIN declare _result mediumtext CHARSET utf8;

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

i can't import the file....

AlexanderB

reply to myself. after checking everything twice i had a little discussion with our db admins. no stored procedures for our database....