Page 1 of 1

chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 3:54 pm
by Cyberwolf2
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

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 3:56 pm
by GenXOutsourcing
The MySQL root password has nothing to do with Vicidial. The users for Vici are cron and custom.

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 4:01 pm
by Cyberwolf2
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

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 4:09 pm
by GenXOutsourcing
Be sure that you have Campaign ID and Campaign Name both filled out.

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 4:13 pm
by Cyberwolf2
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

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 4:19 pm
by GenXOutsourcing
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.

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 4:27 pm
by Cyberwolf2
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

Re: chaged MYSQL password, Vicidial broken

PostPosted: Thu May 13, 2021 5:50 pm
by carpenox
try importing a backup