[Users] Unable to get managed connection for java:/ENGINEDataSource

[snmishra at linux.vnet.ibm.com]

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