# Sonata Stats Debian

**URL:** https://forums.vitalpbx.org/t/sonata-stats-debian/2134
**Category:** VitalPBX 4
**Created:** [December 20, 2022, 9:01pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134 "2022-12-20T21:01:16Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![mloaiza](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@mloaiza](https://forums.vitalpbx.org/u/mloaiza)
#### Post date: [December 20, 2022, 9:01pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/1 "2022-12-20T21:01:17Z")

</div>

We have VitalPBX 4.0.0. R7 with the lastest version of SONATA STATS already installed and set up. After updating to the latest version Sonata Stats gave us the setup screen. During the update process I did see some message in which was mentioning the SONATA STATS, but could capture any screenshots. This would be in the logs, right? Which ones can I provide

Now since the SONATA Stats is giving the set up screen asking the for root password, even typing the correct one does not help, it says that failed to established connection. I like I mention we have SONATA Stats set up.

This happened to me in to different systems, one just updated only the SONATA Stats add-on and the second time just now updating 4.0.0 R7 to 4.0.0 R8

---

<div class="post-metadata">

### Author: ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)
#### Post date: [December 20, 2022, 9:19pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/2 "2022-12-20T21:19:15Z")

</div>

Try removing the wizard file and re-running the wizard.

```auto
rm -f /var/lib/sonata/stats/wizard.conf

```

---

<div class="post-metadata">

### Author: ![mloaiza](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@mloaiza](https://forums.vitalpbx.org/u/mloaiza)
#### Post date: [December 20, 2022, 9:30pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/3 "2022-12-20T21:30:09Z")

</div>

> [@miguel](#):
>
> `rm -f /var/lib/sonata/stats/wizard.conf`

I remove the file you asked.

Now it pass the databases and pbx settings, but in the report settings it gave us a flag of “server error” and this is no listing on the timezones.

---

<div class="post-metadata">

### Author: ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)
#### Post date: [December 21, 2022, 5:02pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/4 "2022-12-21T17:02:52Z")

</div>

I’ve tried a brand-new installation using Multi-Tenancy.

 ![image](https://forums.vitalpbx.org/uploads/default/original/2X/d/dacbc47e66906c1d7fa358409a7d3b02af4605a1.png)

---

<div class="post-metadata">

### Author: ![mloaiza](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@mloaiza](https://forums.vitalpbx.org/u/mloaiza)
#### Post date: [December 21, 2022, 5:35pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/5 "2022-12-21T17:35:18Z")

</div>

I have another system that I need to update R7 to R8 and it SONATA STATS installed and set up with users , permissions, agents sync, and see what happened.

For the moment the current system in my office after doing the command,  
rm -f /var/lib/sonata/stats/wizard.conf

I click on the SONATA Stats option on vitalpbx

 ![VitalBX4R8](https://forums.vitalpbx.org/uploads/default/original/2X/c/c787ebebca099d4c96a96dd58ac5c39ba5dce3ae.jpeg)

click next on the database settings

 ![DatabaseSettings](https://forums.vitalpbx.org/uploads/default/original/2X/0/07358f7efedfa335c3b23377c0fa34ec0b0602e1.jpeg)

click next on the PBX Settings

 ![PBXSerttings](https://forums.vitalpbx.org/uploads/default/original/2X/1/16cc79624d69f97a566442b8466171c4962fbc35.jpeg)

and this is what happened after click next on the reporting settings

 ![ReportSettigs](https://forums.vitalpbx.org/uploads/default/original/2X/4/4792e5b1afe0978e4b1d4ef34f215ebf719b588b.jpeg)  
 ![ReportSettigs-Timezone](https://forums.vitalpbx.org/uploads/default/original/2X/5/542875391a526338741100e318c1a383f33281db.jpeg)

If you need to check the logs let me know which ones you need.

---

<div class="post-metadata">

### Author: ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)
#### Post date: [December 21, 2022, 6:27pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/6 "2022-12-21T18:27:44Z")

</div>

Try doing a clean install of the Sonata Stats add-on

```auto
apt-get --purge remove sonata-stats -y
rm -f /var/lib/sonata/stats/wizard.conf
rm -rf /usr/share/queues-stats/
apt-get install -y sonata-stats

```

---

<div class="post-metadata">

### Author: ![mloaiza](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@mloaiza](https://forums.vitalpbx.org/u/mloaiza)
#### Post date: [December 21, 2022, 7:51pm UTC](https://forums.vitalpbx.org/t/sonata-stats-debian/2134/7 "2022-12-21T19:51:52Z")

</div>

If I do a clean install, we don’t have a problem. We are able to pbx teh setup screens and able to use the app.

But this issue happeneed when we update from sonata-stasts 4.0.0-1 to 4.0.0-2, and yesterday when we update from vitalpbx 4.0.0. R7 to 4.0.0 R8.

We would have to see next updaet to see if happen again.

Like I mentin before there is another system we need to update Iet you know if we get any messages during the update.
