Postgres backend db: can't connect

5 posts / 0 new
Last post
Anonymous
Postgres backend db: can't connect

Hi there
I can't understand why I'm not being able to make Tigase to connect to my db backend...
Already tested the jdbc connection string, it's ok!
Could you please help me?

Thanks

Rodrigo

2011-06-13 01:37:42 ConfiguratorAbstract.setProperties() SEVERE: Can't initialize user repository: tigase.db.DBInitException: Problem initializing jdbc connection: jdbc:postgresql://xxxx.xxxxx.com:5432/tigase?user=tigase_user&password=tigase_password
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:433)
at tigase.db.RepositoryFactory.getUserRepository(RepositoryFactory.java:94)
at tigase.conf.ConfiguratorAbstract.setProperties(ConfiguratorAbstract.java:583)
at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:655)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:174)
at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:67)
at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:127)
at tigase.server.MessageRouter.addRegistrator(MessageRouter.java:151)
at tigase.server.MessageRouter.setConfig(MessageRouter.java:565)
at tigase.server.XMPPServer.main(XMPPServer.java:135)
Caused by: org.postgresql.util.PSQLException: ERROR: function tiggetdbproperty(unknown) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 8
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at tigase.db.jdbc.JDBCRepository.checkDBSchema(JDBCRepository.java:369)
at tigase.db.jdbc.JDBCRepository.initRepo(JDBCRepository.java:396)
at tigase.db.jdbc.JDBCRepository.initRepository(JDBCRepository.java:429)
... 9 more

Application: 
Tags: 
Rodrigo

I found that I needed to run some other scripts to make it happen, but I'm still having trouble to correctly start tigase.
My doubt right now is:

Which of these scripts must I run in a new installation, and in which order? I'm running Tigase 5.0, with Postgres 9.

postgresql-create-db.sql
postgresql-schema-4-props.sql
postgresql-schema-4-sp.schema
postgresql-schema-4.sql
postgresql-schema-upgrade-to-4.sql
postgresql-schema.sql

What is confusing me is that there are some "4" in the scripts...

Thanks

Rodrigo

OK, just droped the database and ran again the following scripts:

1) postgresql-schema.sql
2) postgresql-schema-4-sp.schema

No error message on the log, just the comment below. Any help would be much appreciated.

Thanks

Please upgrade database schema now.
Current scheme version is: null, expected: 4.0
Check the schema upgrade guide at the address:
http://www.tigase.org/en/mysql-db-schema-upgrade-4-0
----
If you have upgraded your schema and you are still
experiencing this problem please contact support at
e-mail address: support@tigase.org

Hi,
by analogy to Prepare the MySQL database for the Tigase server you should run postgresql-schema.sql for all Tigase versions below 4.0. For version (inclusive) 4.0 and above you should run postgresql-schema-4.sql. Also, .schema file is automatically run so there is no need to call it again.

Rodrigo

Wonderful!
It's working! Thanks,

Rodrigo