Vicibox 11 - Slave Install breaks at DB Dump stage

All installation and configuration problems and questions

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

Vicibox 11 - Slave Install breaks at DB Dump stage

Postby rustynail » Thu May 02, 2024 6:58 am

Hi,

While installing - ViciBox v.11.0.1 230806 - cluster, when I installed slave server, all goes fine till the stage where it says "Beginning database load into slave, this may take a while..." and starts dumping data from master to /tmp/vicimaster.sql.

After a while (depending on DB size) it crashes with below error:

Doing Slave-specific MySQL setup...

Beginning database dump from master, this may take a while...

Info: Using unique option prefix 'all-database' is error-prone and can break in the future. Please use the full name 'all-databases' instead.
mysqldump: Couldn't execute 'show create table `user`': SHOW VIEW command denied to user 'slave'@'xx.xx.xx.xx' for table `mysql`.`user` (1142)
Could not get database dump from master: 512 at /usr/local/bin/vicibox-install line 280, <STDIN> line 16.

Can someone please guide if there is any patch to fix this or if I can do some modification in script so that it go smoothly.

Thanks.
rustynail
 
Posts: 74
Joined: Mon Nov 21, 2016 6:21 pm

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby carpenox » Thu May 02, 2024 3:03 pm

Just add the slave user to the asterisk database and it should work. I am not sure the exact user its asking for but you should have it on your error logs of mysql, add that user, search google if you need to, to find out how to do it. Good luck, youcan also message me directly through any method below.
Alma Linux 9.4 | SVN Version: 3839 | DB Schema Version: 1714 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572 -:- Skype: https://join.skype.com/ujkQ7i5lV78O | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2270
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby rustynail » Fri May 03, 2024 12:21 pm

carpenox wrote:Just add the slave user to the asterisk database and it should work. I am not sure the exact user its asking for but you should have it on your error logs of mysql, add that user, search google if you need to, to find out how to do it. Good luck, youcan also message me directly through any method below.


Thanks, So you mean to add this user on master db server or the slave one that I am installing? It's the 'slave' user for which the command is getting denied.. and I can see this user exists on master DB... as you see below...

| cron | *A4B61573190FG57F932C8886EBFCF | % |
| cron | *A4B6157319074F7F932C8886EBFCF | localhost |
| custom | *39798AA2596A7702568384D8C5AC3 | localhost |
| custom | *39798AA2596A7702568384D8C5AC3 | % |
| slave | *DAE180E1578479C7060AC1198C2F5 | % |

The actual issue seems this user doesn't have access on mysql.user table for SHOW VIEW....

Any further suggestions..
rustynail
 
Posts: 74
Joined: Mon Nov 21, 2016 6:21 pm

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby carpenox » Thu May 09, 2024 8:35 am

search google or chatgpt/bing how to add "show view" permissions to mysql
Alma Linux 9.4 | SVN Version: 3839 | DB Schema Version: 1714 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572 -:- Skype: https://join.skype.com/ujkQ7i5lV78O | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2270
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby rustynail » Thu May 09, 2024 9:58 am

carpenox wrote:search google or chatgpt/bing how to add "show view" permissions to mysql


permission on Master DB ,,,right?
Yes, that can be done and I have done it previously on one of my clusters. But I am looking for a method so I do not have to do it manually before installing slave. a patch or some modification in install.pl before starting vicibox-install ?

Thanks.
rustynail
 
Posts: 74
Joined: Mon Nov 21, 2016 6:21 pm

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby rustynail » Fri Jun 07, 2024 10:52 am

Has anyone figured out what is the issue and how it can be solved before installing slave. Should we correct permissions on master DB before installing slave?
rustynail
 
Posts: 74
Joined: Mon Nov 21, 2016 6:21 pm

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby carpenox » Wed Jun 19, 2024 1:20 pm

maybe this article i wrote a few years ago can help you out

https://dialer.one/how-to-setup-a-slave ... -vicidial/
Alma Linux 9.4 | SVN Version: 3839 | DB Schema Version: 1714 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572 -:- Skype: https://join.skype.com/ujkQ7i5lV78O | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2270
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Vicibox 11 - Slave Install breaks at DB Dump stage

Postby williamconley » Sat Jun 22, 2024 3:23 am

rustynail wrote:Has anyone figured out what is the issue and how it can be solved before installing slave. Should we correct permissions on master DB before installing slave?


At the top of this page is a link for "Vicidial Issue Tracker".

If you post the details well enough and describe the situation carefully you should get the issue fixed eventually. That's what the Issue Tracker is specifically for.

Also, if you post the line in the install.pl where it dies, it's very likely we can generate a sql command that could be placed one line before that to allow success (in future installs). In fact, if you can do that in a test install and place that line in your Isue tracker as a comment after the fact, it may well get used temporarily until they find the earlier problem that caused this hiccup.

And it'll help everyone who's installing 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20029
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

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