Correct way to Upgrade / how to unbreak "broken" FreePBX modules

davidsain
Posts: 41
Member Since:
2007-09-20

After I upgraded from 2.2 to 2.6 (we just started having a bunch of kernel panics and I'm not guru enough to figure them out) I was looking around at backup and restore (search and you will get the backup and restore thread) Ok, your'e not supposed to backup and restore when you change versions. I read months ago somewhere on this forum that that was the proper and only way to upgrade. Now I'm reading that this isn't the way to upgrade.

I found out the hard way that backup and restore backs up the database and FreePBX modules, but ONLY those. That's probably why it's in FreePBX (sub) GUI and not in the trixbox GUI. And when you restore it replaces all those modules, whether they are older or not.

I did upgrade this way, and have a few problems. Well, only one problem. I had to download the latest FreePBX package and install it to un-break TBM-Core (it was out of date and I couldn't update via GUI). I was able to then use the FreePBX GUI to download and update the modules that were out of date. I have 9 modules remaining that I have to figure out how to remove or update. When trying to install or remove the "broken" modules the GUI reports back "cannot find module".

So, what would one do to delete the broken modules or download them and install them by hand?

I'm scratching my head here.

I could re-install 2.2 (still have the ISO somewhere) and restore back onto that, then figure out how to upgrade. Is that the best way to go? Upgrade instructions are so very sparse. If someone could help me, I'll write up what I do for the benefit of the public. Is that a fair trade?

Thanks,
David



davidsain
Posts: 41
Member Since:
2007-09-20
Upgrade 2.2.x to 2.6.1. Possible???

Still stuck here.

I installed tb CE 2.6.1 on an old IBM Thinkpad T42 laptop, and I see the FreePBX name is no longer on the PBX interface, so it's been de-branded and in the process of being fully integrated... Since mine was broken, and I downloaded and installed the latest FreePBX to get things working. I have no idea what might break or happen down the road, so I want to roll back to 2.2.x. Shouldn't take more than an hour or two.

But I'd like to get up to 2.6.1 without re-entering all my configurations for endpoints and trunks. I know it's all in the MySQL database. I'm not a DB guy, but I know I should be able to dump it all out and insert it back in after an upgrade as long as the table structures are the same. And I'd like to be able to preserve my IVR recordings and voicemail. I now know a full backup and restore over-writes FreePBX (or whatever it's called now) and it's modules

Is there a way, even an undocumented way? I've completely backed up the machine and can restore all the trix related stuff to another box that should run (a Dell desktop, not the SC440 I run the server on) or even the laptop, so I should be able to play around a little.

Maybe someone from the dev team can chime in????

Will this work:
(courtesy of http://www.sixapart.com/movabletype/docs/3.2/01_installation_and_...)

Backing up via the command line

To backup from the command line of your shell account, log in and type the following at the prompt replacing USERNAME and DATABASE as described previously:

mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql

You will be prompted for your database password and then the DATABASE will be dumped to a plain-text file called FILENAME.mysql.

The resulting file, FILENAME.mysql, is a full backup with which you can fully restore your database in case of problems.

Restoring via the command line
Restoring from FILENAME.mysql is a three step process:

1.
Drop the database
mysqladmin -u USERNAME -p drop DATABASE
2.
Recreate the database
mysqladmin -u USERNAME -p create DATABASE
3.
Import the backup data
mysql -u USERNAME -p DATABASE

Thank you,
David



davidsain
Posts: 41
Member Since:
2007-09-20
Some more interesting and conflicting bits re upgrade...

Here I understand that we can upgrade 2.2 to 2.4+ (to 2.6.0.7?)
http://josephades1.googlepages.com/gen_upgrade22to24

Here Kerry tells that we can upgrade to 2.6 from 2.4, but not from 2.2 to 2.4
http://trixbox.org/forums/trixbox-forums/open-discussion/are-we-t...
He also mentions the database structures are the same...



davidsain
Posts: 41
Member Since:
2007-09-20
bump

Has this subject been talked to death?

I see older posts have been removed (like some when I was building this system last October). Have all the upgrade posts been removed, because I don't see much, and nobody responds. Is the tb mafia telling you to keep your mouth shut, or is there simply no answer, or is it that nobody cares?

Just curious, that's all.

Sometimes I feel like I'm alone in a room talking to myself.



PhilT
Posts: 48
Member Since:
2007-05-10
well I'm listening but don't

well I'm listening but don't know enough about mysql etc to help, sorry.

When I did as major version upgrade I rebuilt from scratch as it was only a small setup and I took the opportunity to do it better and take advantage of lessons learned.

Having said that it broke yesterday so I'm probably in the same boat as you now !

--

Phil
UK Trixbox newbie
http://wireless.southwitham.net/



SkykingOH
Posts: 9541
Member Since:
2007-12-17
What is your problem??

Sorry deleted, replied to wrong post

--

Scott

aka "Skyking"



davidsain
Posts: 41
Member Since:
2007-09-20
Bump - Still broken

I got a response quite a while back on a different thread.

http://trixbox.org/forums/trixbox-forums/help/upgrading-2-2-2-6

That's pretty much what I did that broke things. Following the wiki http://trixbox.org/wiki/upgrade22-24 and hoping it would work for 2.6.

So I guess I want to get into the database, put what I want into a new table and discard the rest. Then re-install 2.6.x again and insert what's in the new table into asterisk.

If I can figure out how to do that, where can I find the voicemail messages? Are they in the database or are they stored as audio files on the disk? I don't see them. I see IVR and Announcments, but don't know if the binary files are actually stored there.

Please, some advice or help? Kerry, should I just throw it all away and rebuild it from scratch? It's hours and hours of time? I'd rather know how to upgrade, even if it's the hard way.



davidsain
Posts: 41
Member Since:
2007-09-20
Bump

Bump



colinjack
Posts: 334
Member Since:
2006-06-01
Just remove them using the

Just remove them using the module admin.

They will say they couldn't uninstall etc but don't worry.

Then do a 'check for updates' and upgrade all. Should be fine.

Even better, install 'real' FreePBX rather than suffer the forked version ... version 2.5 (now at RC3) is fabulous.

http://freepbx.org/news/2008-08-13/freepbx-release-candidate-easy...

--

Colin



davidsain
Posts: 41
Member Since:
2007-09-20
Colin, Thanks. I already

Colin,

Thanks. I already tried to un-install them and upgrade them, but no-go. It's been more than a couple weeks since so I'll try again to make sure I got it in the right order.

When I restored the backup on top of 2.6.1, the forked FreePBX was broken and the only fix I could come up with is to install the 'real' version right over the top of the existing (forked up) version.

I'm still working on using a DBA friend to pull my config out of the database, re-installing 2.6.1 and inserting the dumped tables. I only want trunks and extensions. The IVR needs a change anyway. It's actually not that hard. I've been poking around in the tables and am getting a feeling for where things are. Just two tables might just do it.

If anything I'm learning something about a pointless exercise in futility.

Regards,
David



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.