Die Suche ergab 54 Treffer

von Antoine GUEVARA
08 Jan 2015, 13:17
Forum: Free support
Thema: silently populate mysql database
Antworten: 1
Zugriffe: 1100

silently populate mysql database

Hi,

There is a way to silently deploy the mysql module and populate mysql DB ?

ex :

Code: Alles auswählen

opsi-setup --configure-mysql --user root --password password


my mysql.conf file is correctly fill with username & database & password

How can I do it automaticaly and silently ?

Thanks,

Antoine
von Antoine GUEVARA
06 Jan 2015, 13:55
Forum: Bugs
Thema: Email subject for opsi-product-updater report
Antworten: 6
Zugriffe: 2298

Email subject for opsi-product-updater report

Hi, I have made a patch for opsi-product-updater which permit to add a custom subject for email notification : Here it is : /usr/bin/opsi-product-updater --- opsi-product-updater 2015-01-06 13:40:32.752175175 +0100 +++ opsi-product-updater-custom 2015-01-06 13:42:23.368178138 +0100 @@ -216,6 +216,8 ...
von Antoine GUEVARA
06 Jan 2015, 09:22
Forum: Bugs
Thema: Incoherence mysql with depotid > 50 chars
Antworten: 8
Zugriffe: 3241

Re: Incoherence mysql with depotid > 50 chars

Hi,

Happy new year and thank you for your reactivity.

What kind of patch did you do ? what are the files impacted by this one ?

Regards,

Antoine
von Antoine GUEVARA
10 Dez 2014, 08:44
Forum: Bugs
Thema: Incoherence mysql with depotid > 50 chars
Antworten: 8
Zugriffe: 3241

Re: Incoherence mysql with depotid > 50 chars

Yes, This is the patch for opsi-setup : --- opsi-setup-old 2014-12-04 09:50:10.158781374 +0100 +++ opsi-setup 2014-12-03 15:48:37.029043590 +0100 @@ -1214,7 +1214,7 @@ logger.notice(u"Updating database table HOST from opsi 3.3 to 3.4") # SOFTWARE_CONFIG logger.notice(u"Updating table ...
von Antoine GUEVARA
03 Dez 2014, 08:07
Forum: Bugs
Thema: Incoherence mysql with depotid > 50 chars
Antworten: 8
Zugriffe: 3241

Re: Incoherence mysql with depotid > 50 chars

this is the shell script I use to path my OPSIs servers #!/bin/bash TABLES="HARDWARE_CONFIG_1394_CONTROLLER HARDWARE_CONFIG_AUDIO_CONTROLLER HARDWARE_CONFIG_BASE_BOARD HARDWARE_CONFIG_BIOS HARDWARE_CONFIG_CACHE_MEMORY HARDWARE_CONFIG_CHASSIS HARDWARE_CONFIG_COMPUTER_SYSTEM HARDWARE_CONFIG_DISK_...
von Antoine GUEVARA
03 Dez 2014, 08:03
Forum: Free support
Thema: Backend referential integrity error
Antworten: 6
Zugriffe: 2370

Re: Backend referential integrity error

Hi,

Thank you for your reply, but I think there are problems with mysql and depot∕host with fqdn > 50 chars

Here is my bug topic.

viewtopic.php?f=6&t=7016

Regards,

Antoine
von Antoine GUEVARA
02 Dez 2014, 15:37
Forum: Bugs
Thema: Incoherence mysql with depotid > 50 chars
Antworten: 8
Zugriffe: 3241

Re: Incoherence mysql with depotid > 50 chars

This is the same for HARDWARE_* tables, the row hostId is limited to 50 chars
von Antoine GUEVARA
02 Dez 2014, 15:02
Forum: Bugs
Thema: Incoherence mysql with depotid > 50 chars
Antworten: 8
Zugriffe: 3241

Incoherence mysql with depotid > 50 chars

Hi, During my setup of opsi Mysql Module I've found this bug : When I launch opsi-product-updater -i -vv I've got this message , ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`opsiXXXXXXXX`.`PRODUCT_ON_DEPOT`, CONSTRAINT `PRODUCT_ON_DEPOT_ibfk_2` FOREIGN KEY (...
von Antoine GUEVARA
02 Dez 2014, 08:52
Forum: Free support
Thema: Backend referential integrity error
Antworten: 6
Zugriffe: 2370

Re: Backend referential integrity error

extract of : opsi-convert file mysql Error occured: Failed to replicate object <ProductOnDepot productId 'win2k', depotId 'opsi.FQDN'>: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`opsixxxxxxxx`.`PRODUCT_ON_DEPOT`, CONSTRAINT `PRODUCT_ON_DEPOT_ibfk_2` FOREIGN KEY (`depo...
von Antoine GUEVARA
02 Dez 2014, 08:46
Forum: Free support
Thema: Backend referential integrity error
Antworten: 6
Zugriffe: 2370

Re: Backend referential integrity error

Ok, thank you, But now when I try to import file backend to mysql backend I always have this error : ERROR: Backend error: Failed to install package '/var/lib/opsi/repository/config-win-base_4.0.1-1.opsi' on depot 'opsixxxxxxxxx.fr': (1452, 'Cannot add or update a child row: a foreign key constraint...