greg.banbury
11-05-2008, 11:18 AM
Hi,
I'm running with Bi server 2.0.0-RC1 and have converted hibernate and quartz over to be user owned schemas in my postgres database.
I have followed the wiki guide to deploy the server to postgres and have no problems (so far!) with the user console. I have thus guessed what I need to do to configure the Admin Console.
I have changed /resource/config/console.xml to:
<hibernate-config-path>postgresql.hibernate.cfg.xml</hibernate-config-path>
and within /resource/hibernate/postrgres.hibernate.cfg.xml I have entered:
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.url">jdbc:postgresql://pizza/devdss</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.username">devhibernate</property>
<property name="connection.password">****</property>
The server starts fine, however when I fire up pizza:8099 I get the following errors:
- Unable to refresh data sources list: Failed to get a data source
- Unable to refresh security information: Failed to get usernames
- The element type "meta" must be terminated by the matching end-tag "</meta>"
When I look at the server log it correctly says it is using config file "postgres.hibernate.cfg.xml" however it then coughs out:
INFO: using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/hibernate
05-Nov-2008 16:11:55 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=hibuser, password=****}
05-Nov-2008 16:11:55 org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
org.postgresql.util.PSQLException:
FATAL: password authentication failed for user "hibuser"
I have searched the whole biserver-ce directory on the server for the string "jdbc:postgresql://localhost:5432/hibernate" and it isn't in any files!
Why is it using this url with the user "hibuser" and not the details I have entered in my postgres.hibernate.cfg.xml?
Hope someone can help...
Cheers,
Greg
I'm running with Bi server 2.0.0-RC1 and have converted hibernate and quartz over to be user owned schemas in my postgres database.
I have followed the wiki guide to deploy the server to postgres and have no problems (so far!) with the user console. I have thus guessed what I need to do to configure the Admin Console.
I have changed /resource/config/console.xml to:
<hibernate-config-path>postgresql.hibernate.cfg.xml</hibernate-config-path>
and within /resource/hibernate/postrgres.hibernate.cfg.xml I have entered:
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.url">jdbc:postgresql://pizza/devdss</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.username">devhibernate</property>
<property name="connection.password">****</property>
The server starts fine, however when I fire up pizza:8099 I get the following errors:
- Unable to refresh data sources list: Failed to get a data source
- Unable to refresh security information: Failed to get usernames
- The element type "meta" must be terminated by the matching end-tag "</meta>"
When I look at the server log it correctly says it is using config file "postgres.hibernate.cfg.xml" however it then coughs out:
INFO: using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/hibernate
05-Nov-2008 16:11:55 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=hibuser, password=****}
05-Nov-2008 16:11:55 org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
org.postgresql.util.PSQLException:
FATAL: password authentication failed for user "hibuser"
I have searched the whole biserver-ce directory on the server for the string "jdbc:postgresql://localhost:5432/hibernate" and it isn't in any files!
Why is it using this url with the user "hibuser" and not the details I have entered in my postgres.hibernate.cfg.xml?
Hope someone can help...
Cheers,
Greg