DB Slave install error

[franklinsj]

Vicibox 4.02 from .iso Supermicro 7046T-3R

I am currently installing a vicidial cluster for the company i work for through vicibox 4.02 64 bits .iso

This particular server is intended to work as a DB slave, web and archive.

After updating repositories and installing updates i go through the wizard that is presented by running the command vicibox-install i get the following error message:

Updated to revision 1919.
Doing general DataBase requirements...
Doing Slave-specific MySQL setup...
/usr/bin/sed: -e expression #1, char 29: unterminated `s' command
Could not modify my.cnf for slave: 256 at /usr/local/bin/vicibox-install line 279, <STDIN> line 20.

Any help would be appreciated.

[williamconley]

Perhaps you could share with us the order that you've done this in ... I mean, the db slave server cannot be installed first ...

Also of note: You want to MATCH the version of the other servers on this server, not just update to the latest SVN on this one server.

You may also want to investigate that line of that file and post the results here, in case that sheds some light on the problem.

Oh! and some Newbie help:
when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

Happy Hunting!

[Kumba]

What is the name of the database and what was the slaveID you assigned to it?

When I run that sed command I don't get the warning. Here is what it's bombing on:

Code: Select all

if (system("/usr/bin/sed -i 's/server-id\t= 1/server-id\t= $DBmysqlid\nreplicate-do-db=$VICIdatabase/g' /etc/my.cnf")!=0) { die "Could not modify my.cnf for slave: $?"; }


Basically there is something it doesn't like about the sed statement. Either how the variables are being passed in or how it's formatted. You can comment out that line in /usr/local/bin/vicibox-install.pl and re-run the slave set-up. You will just need to manually edit /etc/my.cnf and set the slave ID and database name prior to running the slave set-up.

Search for server-id and change the ID from 1 to something else like 2. Directly below that add "replicated-do-db=<dbname>" where <dbname> is the name of the vicidial database on your master. By default the database name is 'asterisk'.

I will probably change the slave set-up behaviour in the next version of ViciBox to do a mirrored database replication as opposed to slaved. This would duplicate everything on the primary database, including users and permissions, instead of just duplicating the vicidial database.

[franklinsj]

Vicibox 4.0.2 from .iso | Vicidial 2.6.-392a Build 130102-1135 | Asterisk Server not installed yet | Multiserver installation in process | No Digium/Sangoma Hardware | No Extra Software After Installation | Supermicro X8DT3 Intel Xeon L5638

Hi, Thank you for your response. Kumba, I followed your instructions and at the end i got this error:

Doing general DataBase requirements...
Failed to start MySQL: 256 at /usr/local/bin/vicibox-install line 242, <STDIN> line 20.

When i went to vicibox-install line 242 i found this:

if (system("/etc/init.d/mysql start >> /var/log/vicibox.log 2>> /var/log/vicibox.log")!=0) { die "Failed to start MySQL: $?"; }


i also tried starting mysql manually y typing service mysql start and it did not work. Tried rebooting and same situation

Thanks

[Kumba]

You would need to look through the logs to see why it didn't start. All that error tells me is to start looking at MySQL.

I'm guessing it didn't like something in the my.cnf file. Look in /var/log/messages and the mysql logs for errors