SOLVED Need guidance for big mistake

[krooney]

Hi i would need some guidance on how to fix my issue.
Here it is my backup node got deleted so i need to add it back i know how to create a cluster from scratch but to fix this i dont i am a paid member of fusionpbx but i cant find in documents what would help me to fix this.

My main pbx is fine and working with about 140 devices so i need to fix this with minimal downtime and no lost of data


Thanks in advance for the help.

 

[ad5ou]

If you still have a copy of old google doc from advanced class it will probably make it easier to find info needed because I don’t think everything has been copied into new member documentation.

I don’t have exact commands handy but you would start with removing the dead node from cluster. Even if that leaves the cluster with a single node, the cluster would then be “healthy” and can accept new nodes.

When the cluster is ready, follow instructions from class to install/prepare second node. In the google doc, search “adding a node”.

 

[krooney]

Thanks @ad5ou for the quick reply but i dont have the doc but found this thread https://www.pbxforums.com/threads/stopping-replication.2908/ if this command is right where would i run it? In switch, sql or shell.

 

[Ian Oakes]

You want to part the node, then add via instructions from second node on, almost as if you are starting from scratch. It might be easier though, to dump db, drop db, set up new cluster, add second node, then import previous dump. If your practiced it shouldn't be much more than half an hour to an hour tops.

 

[ad5ou]

The notes in the forum post you mentioned are what you need. Also refer to http://bdr-project.org/docs/stable/node-management-removing.html

All of this could probably be done from the command page in GUI as sql but most instructions are assuming a shell connection.

 

[krooney]

You want to part the node, then add via instructions from second node on, almost as if you are starting from scratch. It might be easier though, to dump db, drop db, set up new cluster, add second node, then import previous dump. If your practiced it shouldn't be much more than half an hour to an hour tops.

Will customer loose voicemail messages if i dump

 

[krooney]

sorry for my ignorance so i found in member documents how to remove node 2 i have the commands so i login with putty and try to run the command but it does not work do i have to enter something in order to send the commands.

 

[krooney]

if i make a backup and start from scratch will i loose my recordings and voicemails

 

[krooney]

if i could just stop the replication so it doesnt crash i will get paid help. If someone can point me right direction.

Thanks

 

[ad5ou]

The the postgres commands have to done in postgresql as user postgres. Look a bit deeper in the docs.

If you do a full backup as listed in docs, it will save recordings and voicemail etc.

My understanding is official fusionpbx support is only available to purple and higher paid members. They no longer do on demand hourly support.

 

[krooney]

@ad5ou thanks I will look a bit more.

 

[krooney]

@DigitalDaz any guidance would be apreciated please.
Thanks in advance

 

[krooney]

I was able to delete broken node but when I run node.sh to add 2nd node back it does not work

 

[krooney]

I made backup and restored but recordings and voicemails are not following. Is the an extra script that need to be ran?

 

[ad5ou]

Which backup script did you use?
If using the /etc/crond.daily/fusionpbx-backup.sh script double check the sections after #backup the databse. There is a section for "package" based and "source" installs of Freeswitch. Depending on which type of install, some directory locations are different.

The "tar" command will pack up all of the relevant files but at least in my backup script, it specifically excluded the recordings folders.

#package
tar --exclude='/var/lib/freeswitch/recordings/*/archive' -zvcf /var/backups/fusionpbx/backup_$now.tgz /var/backups/fusionpbx/postgresql/fusionpbx_pgsql_$now.sql /var/www/fusionpbx /usr/share/freeswitch/$

 

[krooney]

Thanks @ad5ou i will give this a try later and let you know.

 

[krooney]

@ad5ou when restoring do we i untar also

 

[ad5ou]

You would need to untar to restore the backed up items.
You can also manually copy the directories/files needed between servers.

 

[krooney]

Made full backup
Recreated new cluster and restored
All back in order
Thanks for your time and help.