Koozali.org: home of the SME Server

Webmail Turba address books gone after upgrade

ryan

Webmail Turba address books gone after upgrade
« on: October 08, 2004, 06:51:47 PM »
I have upgraded a customers SME from 5.6 to 6.01-01.  One users says his turba address book is now empty.  I setup a fresh 5.6 and restored from file/desktop.  Even on this restored 5.6 box, his address book is empty.

Something is wrong with the backup/restore, or this user had nothing in the address book to being with...  

How can I verify the address book exists in the backup to desktop file?  Even if found, how can I extract the data so it can be imported to the new 6.01-01 server?  

On the new server using 'admin' login to webmail, I am able to create new addressbook contacts, so turba appears to be working....

any help is appreciated,

ryan

Mumm-Ra

Webmail Turba address books gone after upgrade
« Reply #1 on: October 08, 2004, 09:11:09 PM »
Ryan,

are you using the backup to desktop function of the server-manager?
If you are then the Turba address book will never backup as the information is held in the horde database, within mysql, and this is not backed up with this function.

If you didn't backup the horde mysql database then unfortunately the address book info is gone.
When I last upgraded to a new server I backed up the horde database and then stopped mysql on the new server, copied the three turba entries from the database, then started mysql again.  This worked fine but then I only have 6 users on my server (used for family) and only I use the webmail function.
Also when I create users they have always been created in the same order (I use the lazy-admin tools). Don't really know if this matters as there is an owner_id field in the turba table which stores the email address of the owner of the row.

Howard

ryan

Webmail Turba address books gone after upgrade
« Reply #2 on: October 08, 2004, 11:04:30 PM »
Howard,

Yes it was the backup to desktop function.   Damn, this really sucks.

Thanks for the reply,

RS

Mumm-Ra

Webmail Turba address books gone after upgrade
« Reply #3 on: October 08, 2004, 11:22:35 PM »
you could have a look at some of the other backup contribs available.  Just search for them here.
There looks an interseting one here http://forums.contribs.org/index.php?topic=24320.0
I'm just about to install on my test machine.