# (SOLVED) Installing local Server on Ubuntu Desktop 18.04 LTS PB

**URL:** <https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343>\
**Category:** Installation\
**Created:** [March 30, 2020, 2:27pm UTC](https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343 "2020-03-30T14:27:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ludo](https://avatars.discourse-cdn.com/v4/letter/l/5f9b8f/32.png) [@Ludo](https://forum.mattermost.com/u/Ludo)\
**Post date:** [March 30, 2020, 2:27pm UTC](https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343/1 "2020-03-30T14:27:22Z")

</div>

Hi There!

I’m following the doc [https://docs.mattermost.com/install/install-ubuntu-1804.html](https://docs.mattermost.com/install/install-ubuntu-1804.html)  
I’m using MySQL

at step 9.b when I Start the Mattermost server as the user mattermost, I have this answer:

/opt/mattermost$ sudo -u mattermost ./bin/mattermost  
Error: failed to load configuration: failed to load: invalid config: Config.IsValid: model.config.is\_valid.sql\_driver.app\_error:

THX 4 help

---

<div class="post-metadata">

**Author:** ![paulrothrock](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/paulrothrock/32/2967_2.png) [@paulrothrock](https://forum.mattermost.com/u/paulrothrock)\
**Post date:** [March 30, 2020, 2:51pm UTC](https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343/2 "2020-03-30T14:51:36Z")

</div>

Hi @Ludo! Make sure your `SqlSettings` are correct and that your configuration file is valid, specifically the `DriverName` which should be set to `mysql` or `postgres`. To check your configuration file use [this CLI command](https://docs.mattermost.com/administration/command-line-tools.html#mattermost-config-validate).

---

<div class="post-metadata">

**Author:** ![Ludo](https://avatars.discourse-cdn.com/v4/letter/l/5f9b8f/32.png) [@Ludo](https://forum.mattermost.com/u/Ludo)\
**Post date:** [March 30, 2020, 3:12pm UTC](https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343/3 "2020-03-30T15:12:42Z")

</div>

Hi Thx @paulrothrock for ur quick response. the config.json ( `/opt/mattermost/config/config.json`)  
is already as follow  
“SqlSettings”: {  
“DriverName”: “mysql”,  
“DataSource”: “mmuser:mmuser-password@tcp(localhost:3306)/mattermost?charset=utf8mb4,utf8\u0026readTimeout=30s\u0026writeTimeout=30s”,

---

<div class="post-metadata">

**Author:** ![ahmaddanial](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/ahmaddanial/32/2938_2.png) [@ahmaddanial](https://forum.mattermost.com/u/ahmaddanial)\
**Post date:** [March 31, 2020, 3:04am UTC](https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343/4 "2020-03-31T03:04:32Z")

</div>

Hi, @Ludo

For sanity check purposes, can you please run the following command on your Mattermost terminal and provide the full output with any sensitive information such as password redacted?

```auto
cat /opt/mattermost/config/config.json | grep -A11 "SqlSettings"

```

Just want to make sure that we don’t miss out on any details. For example, this is how it looks like on my end:

```auto
ahmaddanial@mattermost:~$ cat /opt/mattermost/config/config.json | grep -A11 "SqlSettings"
    "SqlSettings": {
        "DriverName": "mysql",
        "DataSource": "xxxxx:xxxxx@tcp(127.0.0.1:3306)/mattermost?charset=utf8mb4,utf8\u0026readTimeout=30s\u0026writeTimeout=30s",
        "DataSourceReplicas": [],
        "DataSourceSearchReplicas": [],
        "MaxIdleConns": 20,
        "ConnMaxLifetimeMilliseconds": 3600000,
        "MaxOpenConns": 300,
        "Trace": false,
        "AtRestEncryptKey": "xxxxx",
        "QueryTimeout": 30
    },

```

Also, may I know the behavior if you change `localhost` to the IP address `127.0.0.1` which is similar to mine? Are you still getting the same error too?

---

<div class="post-metadata">

**Author:** ![Ludo](https://avatars.discourse-cdn.com/v4/letter/l/5f9b8f/32.png) [@Ludo](https://forum.mattermost.com/u/Ludo)\
**Post date:** [March 31, 2020, 9:56am UTC](https://forum.mattermost.com/t/solved-installing-local-server-on-ubuntu-desktop-18-04-lts-pb/9343/5 "2020-03-31T09:56:02Z")

</div>

Hi @ahmaddanial, thx for ur help.  
my config.json looked exactly the same than yours… but still some errors.  
I’ve solved the issue by installing PostgreSQL, with the good settings, and it works now!