Postgres backend db: can't connect

  • 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.
4 replies [Last post]
Mon, 2011-06-13 05:45
Anonymous

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

Top
Mon, 2011-06-13 16:38
#1
Rodrigo (not verified)

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

Top
Mon, 2011-06-13 16:53
#2
Rodrigo (not verified)

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

Top
Mon, 2011-06-13 17:43
#3
wojtek's picture
Wojtek
Online
Joined: 2010-11-24
Points: 1182

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.

Top
Mon, 2011-06-13 18:56
#4
Rodrigo (not verified)

Wonderful!
It's working! Thanks,

Rodrigo

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.