# Probleme mssql-cli on ansible

**URL:** <https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494>\
**Category:** Ansible Project\
**Created:** [June 5, 2019, 1:11pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494 "2019-06-05T13:11:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [June 5, 2019, 1:11pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/1 "2019-06-05T13:11:02Z")

</div>

Hi all,

When i want do “sudo apt-get update” on my debian 8.11, i have this error :

E: Malformed line 1 in source list /etc/apt/sources.list.d/mssql-cli.list ([arch] is not an assignment)  
E: The list of sources could not be read.

the next commands works for install mssql-cli :

```auto
# Installer les composants du système
sudo apt-get update
sudo apt-get install curl apt-transport-https

# Importez les clés GPG du référentiel public 
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

# Enregistrez le flux de produits Microsoft 
echo " deb [arch = amd64] https://packages.microsoft.com/debian/8/prod jessie main " | sudo tee /etc/apt/sources.list.d/mssql-cli.list

```

```auto
I'm inspire for documentation officielle Microsoft : [https://github.com/dbcli/mssql-cli/blob/master/doc/installation/linux.md#debian-8](https://github.com/dbcli/mssql-cli/blob/master/doc/installation/linux.md#debian-8)

```

```auto
This probleme is not 100% of Ansible but i want this tool for use after with ansible.

```

```auto
Someone can help me please guy !!! :)

```

```auto
thanks community ansible ! ;)

```

```auto
Regards,

```

---

<div class="post-metadata">

**Author:** ![Jonathan\_Lozada\_De\_L](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@Jonathan\_Lozada\_De\_L](https://forum.ansible.com/u/Jonathan_Lozada_De_L)\
**Post date:** [June 5, 2019, 1:15pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/2 "2019-06-05T13:15:14Z")

</div>

can you share the tasks?

---

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [June 5, 2019, 2:25pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/3 "2019-06-05T14:25:52Z")

</div>

Hi Jonathan,

there is not task, on my terminal of my Debian 8.11 i will try to install mssql-cli but it’s not work and i have this error :

E: Malformed line 1 in source list /etc/apt/sources.list.d/mssql-cli.list ([arch] is not an assignment)  
E: The list of sources could not be read.

But when i delete line in /etc/apt/sources.list.d/mssql-cli.list, mssql-cli can’t install and Debian not found paquet mssql-cli …

Can you help me please ?? 🙂

Regards,

---

<div class="post-metadata">

**Author:** ![Jonathan\_Lozada\_De\_L](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@Jonathan\_Lozada\_De\_L](https://forum.ansible.com/u/Jonathan_Lozada_De_L)\
**Post date:** [June 5, 2019, 2:27pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/4 "2019-06-05T14:27:37Z")

</div>

This looks like a problem with the repository and not ansible. Looks like the file has issues itself.

---

<div class="post-metadata">

**Author:** ![racke](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/racke/32/4767_2.png) [@racke](https://forum.ansible.com/u/racke)\
**Post date:** [June 5, 2019, 2:53pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/5 "2019-06-05T14:53:27Z")

</div>

> Hi all,
> 
> When i want do "sudo apt-get update" on my debian 8.11, i have this error :
> 
> E: Malformed line 1 in source list /etc/apt/sources.list.d/mssql-cli.list ([arch] is not an assignment)  
> E: The list of sources could not be read.
> 
> the next commands works for install mssql-cli :
> 
> #Installer les composants du systèmesudo apt-get updatesudo apt-get install curl apt-transport-https
> 
> #Importez les clés GPG du référentiel publicwget -qO- [https://packages.microsoft.com/keys/microsoft.asc|](https://packages.microsoft.com/keys/microsoft.asc%7C) sudo apt-key add -
> 
> #Enregistrez le flux de produits Microsoft  
> echo "deb [arch = amd64] [https://packages.microsoft.com/debian/8/prod](https://packages.microsoft.com/debian/8/prod) jessie main " | sudo tee /etc/apt/sources.list.d/mssql-cli.list

Hello,

try to get rid of the extra spaces - [arch=amd64] instead of [arch = amd64].

Regards  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Racke

---

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [June 5, 2019, 3:23pm UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/6 "2019-06-05T15:23:02Z")

</div>

Hi,

Thanks for your answer !! 🙂

But when i do this command : “sudo apt-get update”, my probleme is now that update not finish, i have this message in end page :

100% [Working]

and when next i try to install mssql-cli, Debian not found paquet mssql-cli … ;(

Merde

Thanks for your answer 😉

Regards,

---

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [June 6, 2019, 10:05am UTC](https://forum.ansible.com/t/probleme-mssql-cli-on-ansible/30494/7 "2019-06-06T10:05:00Z")

</div>

Hi,

Problem solved !! 🙂

Regards,