chaged MYSQL password, Vicidial broken

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

chaged MYSQL password, Vicidial broken

Postby Cyberwolf2 » Thu May 13, 2021 3:54 pm

I outsourced my server install by some experts, they never shared with me the install steps they followed. I changed the MariaDB root password, and now I can't create lists or campaigns.

Where do I update the Vicidial mysql password?

This is what I get:

https://pasteboard.co/K1KOw5o.png
Last edited by Cyberwolf2 on Thu May 13, 2021 4:00 pm, edited 1 time in total.
Scratch install Ubuntu 24.04, Asterisk 18.18.1, AstGUIclient: (VERSION: 2.14-928a, BUILD: 240826-0918, SVN: 3874), MacPro 3,1 21GB, VOIP Provider: Skyetel, NGINX, Self Hosted + WireGuard tunnel
Cyberwolf2
 
Posts: 29
Joined: Mon May 10, 2021 7:59 pm

Re: chaged MYSQL password, Vicidial broken

Postby GenXOutsourcing » Thu May 13, 2021 3:56 pm

The MySQL root password has nothing to do with Vicidial. The users for Vici are cron and custom.
Built too many to count, Centos7 Scratch install, Opensuse Scratch install, Centos8 Scratch install, etc.
Dual 8 core/32gb RAM/500gb SSDs
SVN Version:3440
VERSION: 2.14-812a
genxoutsourcing.com
GenXOutsourcing
 
Posts: 120
Joined: Sun Sep 22, 2019 12:53 am

Re: chaged MYSQL password, Vicidial broken

Postby Cyberwolf2 » Thu May 13, 2021 4:01 pm

GenXOutsourcing wrote:The MySQL root password has nothing to do with Vicidial. The users for Vici are cron and custom.


Ok, I have no idea why its broken then. i only changed the root password.

This is what I get:

https://pasteboard.co/K1KOw5o.png
Scratch install Ubuntu 24.04, Asterisk 18.18.1, AstGUIclient: (VERSION: 2.14-928a, BUILD: 240826-0918, SVN: 3874), MacPro 3,1 21GB, VOIP Provider: Skyetel, NGINX, Self Hosted + WireGuard tunnel
Cyberwolf2
 
Posts: 29
Joined: Mon May 10, 2021 7:59 pm

Re: chaged MYSQL password, Vicidial broken

Postby GenXOutsourcing » Thu May 13, 2021 4:09 pm

Be sure that you have Campaign ID and Campaign Name both filled out.
Built too many to count, Centos7 Scratch install, Opensuse Scratch install, Centos8 Scratch install, etc.
Dual 8 core/32gb RAM/500gb SSDs
SVN Version:3440
VERSION: 2.14-812a
genxoutsourcing.com
GenXOutsourcing
 
Posts: 120
Joined: Sun Sep 22, 2019 12:53 am

Re: chaged MYSQL password, Vicidial broken

Postby Cyberwolf2 » Thu May 13, 2021 4:13 pm

GenXOutsourcing wrote:Be sure that you have Campaign ID and Campaign Name both filled out.

Yeap, that is what I'm doing.
Same thing with lists, filters

It's like it can't write, but it can read
Scratch install Ubuntu 24.04, Asterisk 18.18.1, AstGUIclient: (VERSION: 2.14-928a, BUILD: 240826-0918, SVN: 3874), MacPro 3,1 21GB, VOIP Provider: Skyetel, NGINX, Self Hosted + WireGuard tunnel
Cyberwolf2
 
Posts: 29
Joined: Mon May 10, 2021 7:59 pm

Re: chaged MYSQL password, Vicidial broken

Postby GenXOutsourcing » Thu May 13, 2021 4:19 pm

Maybe a bad install. Is it new? or have you used it?

Scratch installs, a lot of people "say" they can do them...... but most cant.
Built too many to count, Centos7 Scratch install, Opensuse Scratch install, Centos8 Scratch install, etc.
Dual 8 core/32gb RAM/500gb SSDs
SVN Version:3440
VERSION: 2.14-812a
genxoutsourcing.com
GenXOutsourcing
 
Posts: 120
Joined: Sun Sep 22, 2019 12:53 am

Re: chaged MYSQL password, Vicidial broken

Postby Cyberwolf2 » Thu May 13, 2021 4:27 pm

GenXOutsourcing wrote:Maybe a bad install. Is it new? or have you used it?

Scratch installs, a lot of people "say" they can do them...... but most cant.


Yeah, it was working, spent good money.

I've been messing with a huge data set for the list. I think I corrupted it somehow. I'm able to create new campaigns now by running
Code: Select all
mysqlcheck -u root -p --auto-repair --all-databases


I still can't create a new list.

Any guidance is appreciate it to repair vicidial_lists and any other table associated with creating lists. Even is it means I have to remove all data in that table

I don't mind just deleting the entire database and starting from scratch either
Scratch install Ubuntu 24.04, Asterisk 18.18.1, AstGUIclient: (VERSION: 2.14-928a, BUILD: 240826-0918, SVN: 3874), MacPro 3,1 21GB, VOIP Provider: Skyetel, NGINX, Self Hosted + WireGuard tunnel
Cyberwolf2
 
Posts: 29
Joined: Mon May 10, 2021 7:59 pm

Re: chaged MYSQL password, Vicidial broken

Postby carpenox » Thu May 13, 2021 5:50 pm

try importing a backup
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2423
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 67 guests