[Users] Unable to get managed connection for java:/ENGINEDataSource
snmishra at linux.vnet.ibm.com
snmishra at linux.vnet.ibm.com
Thu Mar 7 23:59:41 UTC 2013
Quoting Juan Hernandez <jhernand at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
More information about the Users
mailing list