Quoting Juan Hernandez <jhernand@redhat.com>:
On 03/05/2013 05:24 PM, Dennis Böck wrote:
Dear oVirt-Users,
since I had a typo in my engine-setup I did a engine-cleanup, a reboot and started again. Unfortunately now the engine doesn't come up any more. Obviously there are problems accessing the database:
2013-03-05 17:13:08,078 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-32) Error in getting DB connection. The database is inaccessible. Original exception is: DataAccessResourceFailureException: Error retreiving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ENGINEDataSource
I already tried: yum erase ovirt-engine yum earse postresql-server and installed it again, but it didn't help.
Does anyone have an idea?
Best regards and thanks in advance Dennis
In the /etc/sysconfig/ovirt-engine file you should have the details of the connection to the database, in particular you should have something like this:
ENGINE_DB_URL=jdbc:postgresql://localhost:5432/engine
Are you using "localhost" as in this example? If that is the case then check that the database is listening in right address and port:
# netstat --listen --tcp --numeric --program | grep postgres tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 10424/postgres
Then also check that connection to the database is working:
psql --host localhost --port 5432 --user engine --password engine Password for user engine: psql (9.2.3) Type "help" for help.
engine=>
You may also run a simple query to check that the tables are there:
engine=> select count(*) from vdc_options; count ------- 346 (1 row)
Hopefully, if there is an error, the output of these commands will give you a hint.
I am running into this issue today. Running "select count(*) from vdc_options;" gives me permission denied. But when I run the same command with postgres (psql --host localhost --port 5432 --user postgres --password engine) it works fine. -Sharad
-- Dirección Comercial: C/Jose Bardasano Baos, 9, Edif. Gorbea 3, planta 3ºD, 28016 Madrid, Spain Inscrita en el Reg. Mercantil de Madrid ? C.I.F. B82657941 - Red Hat S.L. _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users