Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Neririn on August 03, 2005, 06:34:06 PM

Title: Webmail Address book
Post by: Neririn on August 03, 2005, 06:34:06 PM

I am migrating users from one SME box to the next.  I am doing it rather crudely but just creating the user on the new box and moving the Maildir etc.  Having done so, all the mail folders appear in Webmail as expected, but the address book is empty.  DOes anyone know where those are saved and how to migrate?

Thanks a million!

Neru

Title: Re: Webmail Address book
Post by: mrjhb3 on August 05, 2005, 02:53:23 AM

Quote from: "Neririn"

I am migrating users from one SME box to the next.  I am doing it rather crudely but just creating the user on the new box and moving the Maildir etc.  Having done so, all the mail folders appear in Webmail as expected, but the address book is empty.  DOes anyone know where those are saved and how to migrate?

Thanks a million!

Neru

The actual individual user added addresses are stored in the horde DB.  If your domain name is the same on the new as the old, then you could simply dump the horde DB on the old server, and load the db to the new server and all the user added addresses should be there.  Or, you could have each of your users export their entries, then re-import them when they login to the new box.  Now that I think about it, I can't remember if 2.0 had an import/export option for this.  If you need to know this, then I can check on of my test servers.

JB

Title: Yes, any help will be great
Post by: Neririn on August 06, 2005, 06:15:02 AM

Sorry, I have no idea where the horde DB would be nor how to dump it.  Is it a mysql db?  Is it its own independant db?

Title: Webmail Address book
Post by: ergozd on August 06, 2005, 12:51:52 PM

Need some more info on this one

1 - Are you running Horde2 or did you do any upgrade?

a - Horde2
check your conf.php file at
/home/httpd/html/horde/kronolith/config

and make sure you have the correct dbname, username and password

b - Horde3 check your conf.php at
/home/httpd/html/horde/kronolith/config

and make sure you have correct parameters

Title: Re: Yes, any help will be great
Post by: mrjhb3 on August 06, 2005, 01:53:24 PM

Quote from: "Neririn"

Sorry, I have no idea where the horde DB would be nor how to dump it.  Is it a mysql db?  Is it its own independant db?

Before I go on, which address book is empty?  The system shared address book, or the individual user address books?  If it's the system address book, do as ergozd has suggested, except substitute turba (address book) for kronolith (calendar).  If it's the individual user address books, then you can try this.  This assumes that both servers are running the same version of horde.  Do from the server console:

1.  On the old server, mysqldump --opt horde > /root/horde.sql   <--This dumps the horde table.

2.  Look through this file and verify that you can see the individual user address books.

3.  Make sure you have all of the users created on the new server.

4.  On the new server, mysqldump --opt horde > /root/horde_current.sql   <--Dump the current horde db just in case you need to revert.

5.  mysqladmin drop horde <--This drops the horde DB from mysql from the new server

6.  mysqladmin create horde  <- create new horde db

7.  mysql horde < /root/horde.sql  <--This imports the horde db from the old server to the new server.

8.  login as a user that is supposed to have personal contacts and check them.

If you have issues, then repeat steps 5 - 8 but use the horde_current.sql and you should be back to where you started.

HTH,

JB

Title: Webmail Address book
Post by: Neririn on August 09, 2005, 05:12:56 AM

worked great!  Thanks!

Title: Webmail Address book
Post by: mrjhb3 on August 09, 2005, 05:38:18 AM

Quote from: "Neririn"

worked great!  Thanks!

I am glad it worked for you.  You are very welcomed

JB