Le 2021-06-24 19:08, Jean-Yves LENHOF a écrit :
Hi,


I try to silently install a french version of SQLServer (this is not
my idea, it's become this is the licensed version we have) with
ansible using some code like this (I already installed MUI French lang
pack via ansible) :

    - name: "Change LANG"
      win_shell: |
        Set-WinUILanguageOverride -Language fr-FR

    - name: "Silent Install of SQL Server 2019"
      win_shell: |
        D:\SETUP.EXE
/ConfigurationFile=c:\Windows\ansible_SQLSERVER2019_EXPRESS_ConfigurationFile.ini
/SAPWD=MySuperPassw0rd /IAcceptSQLServerLicenseTerms

But it keeps saying that there's something wrong with my language...

fatal: [myserver]: FAILED! => {
    "changed": true,
    "cmd": "D:\\SETUP.EXE
/ConfigurationFile=c:\\Windows\\ansible_SQLSERVER2019_EXPRESS_ConfigurationFile.ini
/SAPWD=MySuperPassw0rd /IAcceptSQLServerLicenseTerms",
    "delta": "0:00:00.531238",
    "end": "2021-06-24 04:13:53.809159",
    "msg": "non-zero return code",
    "rc": 1,
    "start": "2021-06-24 04:13:53.277921",
    "stderr": "",
    "stderr_lines": [],
    "stdout": "This SQL Server setup media does not support the
language of the OS, or does not have the SQL Server English-language
version installation files.  Use the matching language-specific SQL
Server media; or install  both the language specific MUI and change
the format and system locales through the regional settings in the
control panel.\r\n\r\n\r\n\r\n",
    "stdout_lines": [
        "This SQL Server setup media does not support the language of
the OS, or does not have the SQL Server English-language version
installation files.  Use the matching language-specific SQL Server
media; or install  both the language specific MUI and change the
format and system locales through the regional settings in the control
panel.",
        "",
        "",
        ""
    ]
}

But If I'm connecting on the server the UI Lang is changed to French
(so this part seems to work) and if I run the command line on
powershell it succeed.
On Linux I would have just surcharged LANG parameter before my command
but on windows, I think this is not possible...

Is there's something on ansible which force the language to english ?
If not, is someone has an idea on what's going on...

Thanks


Regards,


Fucking off Windows !

Little followup, because that was a quite difficult one to found.
It seems that windows does'nt directly changed tue UI Language when we do it programmatically.... the configuration is pending an interactive connection to that user make actually the change Here's the registry key difference I found (note the pending in the entry) :

Control Panel\Desktop

-"PreferredUILanguages"=hex(7):66,00,72,00,2d,00,46,00,52,00,00,00^M
+"PreferredUILanguagesPending"=hex(7):66,00,72,00,2d,00,46,00,52,00,00,00^M

I will have just to create directly this key in the hive of my ansible user to have the right language directly I think...


Regards,

--
Jean-Yves LENHOF
[email protected]

--
You received this message because you are subscribed to the Google Groups "Ansible 
Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-project/af389056acd4984745a0707bc723e670%40lenhof.eu.org.

Reply via email to