[Users] Testing ovirt all in one on F18 gives error on DB creation

[Adrian Gibanel]

Not sure if you can skip doing engine-cleanup as you ask.

You probably have installed a non-English system and that makes Postgres default database not to be in the charset that oVirt needs to create its database. 

Not sure if it's documented on oVirt wiki but here's how I solve it.
Please note that you LOOSE all your databases with my commands so be careful if this is not a test system. 


# service postgresql stop
### WARNING NEXT COMMAND DELETES ALL DATABASES
# rm -rf /var/lib/pgsql/data
# su postgres
$ initdb --locale=en_US.UTF-8 -D /var/lib/pgsql/data
$ exit
# service postgresql start

----- Mensaje original ----- 

> De: "Gianluca Cecchi" <gianluca.cecchi at gmail.com>
> Para: "users" <users at ovirt.org>
> Enviados: Domingo, 2 de Diciembre 2012 0:57:58
> Asunto: [Users] Testing ovirt all in one on F18 gives error on DB
> creation

> Hello,
> testing oVirt for with all in one config in f18 beta.
> engine-setup fails in Database creation and in db log file:
> saying to check log file
> /var/log/ovirt-engine/engine-setup_2012_12_01_15_35_22.log
> I can see
> 2012-12-01 15:36:32::DEBUG::setup_sequences::59::root:: running
> _createDB
> 2012-12-01 15:36:32::DEBUG::engine-setup::937::root:: installing
> postgres db
> 2012-12-01 15:36:32::DEBUG::engine-setup::940::root:: engine db
> creation is logged at
> /var/log/ovirt-engine//engine-db-install-2012_12_01_15_36_32.log
> 2012-12-01 15:36:32::DEBUG::common_utils::309::root:: Executing
> command --> '/usr/share/ovirt-engine/dbscripts/engine-db-install.sh
> -l
> engine-db-install-2012_12_01_15_36_32.log -w ******** -u postgres -s
> localhost -p 5432 -r local'
> 2012-12-01 15:36:40::DEBUG::common_utils::335::root:: output =
> Running
> local installation
> adding uuid-ossp.sql from contrib...
> error, failed creating enginedb

> How can I workaround this?
> Do I have to rollback what already done by engine-setup or can I only
> resolve the db part?

> Version I find is
> ovirt-engine-setup-3.1.0-1.fc18.noarch

> Thanks
> Gianluca

-- 
-- 
Adrián Gibanel 
I.T. Manager 

+34 675 683 301 
www.btactic.com 



Ens podeu seguir a/Nos podeis seguir en: 

i 


Abans d´imprimir aquest missatge, pensa en el medi ambient. El medi ambient és cosa de tothom. / Antes de imprimir el mensaje piensa en el medio ambiente. El medio ambiente es cosa de todos. 

AVIS: 
El contingut d'aquest missatge i els seus annexos és confidencial. Si no en sou el destinatari, us fem saber que està prohibit utilitzar-lo, divulgar-lo i/o copiar-lo sense tenir l'autorització corresponent. Si heu rebut aquest missatge per error, us agrairem que ho feu saber immediatament al remitent i que procediu a destruir el missatge . 

AVISO: 
El contenido de este mensaje y de sus anexos es confidencial. Si no es el destinatario, les hacemos saber que está prohibido utilizarlo, divulgarlo y/o copiarlo sin tener la autorización correspondiente. Si han recibido este mensaje por error, les agradeceríamos que lo hagan saber inmediatamente al remitente y que procedan a destruir el mensaje .