97181a1c64763850523c23d60c07b99d29a87aa6
[citadel.git] / citadel / modules / migrate / serv_migrate.c
1 /*
2  * This module dumps and/or loads the Citadel database in XML format.
3  *
4  * Copyright (c) 1987-2014 by the citadel.org team
5  *
6  * This program is open source software; you can redistribute it and/or modify
7  * it under the terms of the GNU General Public License version 3.
8  *
9  * This program is distributed in the hope that it will be useful,
10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12  * GNU General Public License for more details.
13  */
14
15 /*
16  * Explanation of <progress> tags:
17  *
18  * 0%              nothing
19  * 1%              finished exporting config
20  * 2%              finished exporting control
21  * 7%              finished exporting users
22  * 12%             finished exporting openids
23  * 17%             finished exporting rooms
24  * 18%             finished exporting floors
25  * 25%             finished exporting visits
26  * 100%            finished exporting messages
27  */
28
29 #include "sysdep.h"
30 #include <stdlib.h>
31 #include <unistd.h>
32 #include <stdio.h>
33 #include <fcntl.h>
34 #include <signal.h>
35 #include <pwd.h>
36 #include <errno.h>
37 #include <sys/types.h>
38
39 #if TIME_WITH_SYS_TIME
40 # include <sys/time.h>
41 # include <time.h>
42 #else
43 # if HAVE_SYS_TIME_H
44 #  include <sys/time.h>
45 # else
46 #  include <time.h>
47 # endif
48 #endif
49
50 #include <sys/wait.h>
51 #include <string.h>
52 #include <ctype.h>
53 #include <limits.h>
54 #include <expat.h>
55 #include <libcitadel.h>
56 #include "citadel.h"
57 #include "server.h"
58 #include "citserver.h"
59 #include "support.h"
60 #include "config.h"
61 #include "database.h"
62 #include "msgbase.h"
63 #include "user_ops.h"
64 #include "control.h"
65 #include "euidindex.h"
66 #include "ctdl_module.h"
67
68 #define END_OF_MESSAGE  "---eom---dbd---"
69
70 char migr_tempfilename1[PATH_MAX];
71 char migr_tempfilename2[PATH_MAX];
72 FILE *migr_global_message_list;
73 int total_msgs = 0;
74
75
76 /*
77  * Code which implements the export appears in this section
78  */
79
80 /*
81  * Output a string to the client with these characters escaped:  & < >
82  */
83 void xml_strout(char *str) {
84
85         char *c = str;
86
87         if (str == NULL) {
88                 return;
89         }
90
91         while (*c != 0) {
92                 if (*c == '\"') {
93                         client_write("&quot;", 6);
94                 }
95                 else if (*c == '\'') {
96                         client_write("&apos;", 6);
97                 }
98                 else if (*c == '<') {
99                         client_write("&lt;", 4);
100                 }
101                 else if (*c == '>') {
102                         client_write("&gt;", 4);
103                 }
104                 else if (*c == '&') {
105                         client_write("&amp;", 5);
106                 }
107                 else {
108                         client_write(c, 1);
109                 }
110                 ++c;
111         }
112 }
113
114
115 /*
116  * Export a user record as XML
117  */
118 void migr_export_users_backend(struct ctdluser *buf, void *data) {
119         client_write("<user>\n", 7);
120         cprintf("<u_version>%d</u_version>\n", buf->version);
121         cprintf("<u_uid>%ld</u_uid>\n", (long)buf->uid);
122         client_write("<u_password>", 12);       xml_strout(buf->password);              client_write("</u_password>\n", 14);
123         cprintf("<u_flags>%u</u_flags>\n", buf->flags);
124         cprintf("<u_timescalled>%ld</u_timescalled>\n", buf->timescalled);
125         cprintf("<u_posted>%ld</u_posted>\n", buf->posted);
126         cprintf("<u_axlevel>%d</u_axlevel>\n", buf->axlevel);
127         cprintf("<u_usernum>%ld</u_usernum>\n", buf->usernum);
128         cprintf("<u_lastcall>%ld</u_lastcall>\n", (long)buf->lastcall);
129         cprintf("<u_USuserpurge>%d</u_USuserpurge>\n", buf->USuserpurge);
130         client_write("<u_fullname>", 12);       xml_strout(buf->fullname);              client_write("</u_fullname>\n", 14);
131         client_write("</user>\n", 8);
132 }
133
134
135 void migr_export_users(void) {
136         ForEachUser(migr_export_users_backend, NULL);
137 }
138
139
140 void migr_export_room_msg(long msgnum, void *userdata) {
141         cprintf("%ld\n", msgnum);
142         fprintf(migr_global_message_list, "%ld\n", msgnum);
143 }
144
145
146 void migr_export_rooms_backend(struct ctdlroom *buf, void *data) {
147         client_write("<room>\n", 7);
148         client_write("<QRname>", 8);    xml_strout(buf->QRname);        client_write("</QRname>\n", 10);
149         client_write("<QRpasswd>", 10); xml_strout(buf->QRpasswd);      client_write("</QRpasswd>\n", 12);
150         cprintf("<QRroomaide>%ld</QRroomaide>\n", buf->QRroomaide);
151         cprintf("<QRhighest>%ld</QRhighest>\n", buf->QRhighest);
152         cprintf("<QRgen>%ld</QRgen>\n", (long)buf->QRgen);
153         cprintf("<QRflags>%u</QRflags>\n", buf->QRflags);
154         if (buf->QRflags & QR_DIRECTORY) {
155                 client_write("<QRdirname>", 11);
156                 xml_strout(buf->QRdirname);
157                 client_write("</QRdirname>\n", 13);
158         }
159         cprintf("<QRinfo>%ld</QRinfo>\n", buf->QRinfo);
160         cprintf("<QRfloor>%d</QRfloor>\n", buf->QRfloor);
161         cprintf("<QRmtime>%ld</QRmtime>\n", (long)buf->QRmtime);
162         cprintf("<QRexpire_mode>%d</QRexpire_mode>\n", buf->QRep.expire_mode);
163         cprintf("<QRexpire_value>%d</QRexpire_value>\n", buf->QRep.expire_value);
164         cprintf("<QRnumber>%ld</QRnumber>\n", buf->QRnumber);
165         cprintf("<QRorder>%d</QRorder>\n", buf->QRorder);
166         cprintf("<QRflags2>%u</QRflags2>\n", buf->QRflags2);
167         cprintf("<QRdefaultview>%d</QRdefaultview>\n", buf->QRdefaultview);
168         client_write("</room>\n", 8);
169
170         /* message list goes inside this tag */
171
172         CtdlGetRoom(&CC->room, buf->QRname);
173         client_write("<room_messages>", 15);
174         client_write("<FRname>", 8);    xml_strout(CC->room.QRname);    client_write("</FRname>\n", 10);
175         client_write("<FRmsglist>", 11);
176         CtdlForEachMessage(MSGS_ALL, 0L, NULL, NULL, NULL, migr_export_room_msg, NULL);
177         client_write("</FRmsglist>\n", 13);
178         client_write("</room_messages>\n", 17);
179
180
181 }
182
183
184 void migr_export_rooms(void) {
185         char cmd[SIZ];
186         migr_global_message_list = fopen(migr_tempfilename1, "w");
187         if (migr_global_message_list != NULL) {
188                 CtdlForEachRoom(migr_export_rooms_backend, NULL);
189                 fclose(migr_global_message_list);
190         }
191
192         /*
193          * Process the 'global' message list.  (Sort it and remove dups.
194          * Dups are ok because a message may be in more than one room, but
195          * this will be handled by exporting the reference count, not by
196          * exporting the message multiple times.)
197          */
198         snprintf(cmd, sizeof cmd, "sort -n <%s >%s", migr_tempfilename1, migr_tempfilename2);
199         if (system(cmd) != 0) syslog(LOG_ALERT, "Error %d\n", errno);
200         snprintf(cmd, sizeof cmd, "uniq <%s >%s", migr_tempfilename2, migr_tempfilename1);
201         if (system(cmd) != 0) syslog(LOG_ALERT, "Error %d\n", errno);
202
203
204         snprintf(cmd, sizeof cmd, "wc -l %s", migr_tempfilename1);
205         FILE *fp = popen(cmd, "r");
206         if (fp) {
207                 fgets(cmd, sizeof cmd, fp);
208                 pclose(fp);
209                 total_msgs = atoi(cmd);
210         }
211         else {
212                 total_msgs = 1; // any nonzero just to keep it from barfing
213         }
214         syslog(LOG_DEBUG, "Total messages to be exported: %d", total_msgs);
215 }
216
217
218 void migr_export_floors(void) {
219         struct floor qfbuf, *buf;
220         int i;
221
222         for (i=0; i < MAXFLOORS; ++i) {
223                 client_write("<floor>\n", 8);
224                 cprintf("<f_num>%d</f_num>\n", i);
225                 CtdlGetFloor(&qfbuf, i);
226                 buf = &qfbuf;
227                 cprintf("<f_flags>%u</f_flags>\n", buf->f_flags);
228                 client_write("<f_name>", 8); xml_strout(buf->f_name); client_write("</f_name>\n", 10);
229                 cprintf("<f_ref_count>%d</f_ref_count>\n", buf->f_ref_count);
230                 cprintf("<f_ep_expire_mode>%d</f_ep_expire_mode>\n", buf->f_ep.expire_mode);
231                 cprintf("<f_ep_expire_value>%d</f_ep_expire_value>\n", buf->f_ep.expire_value);
232                 client_write("</floor>\n", 9);
233         }
234 }
235
236
237 /*
238  * Return nonzero if the supplied string contains only characters which are valid in a sequence set.
239  */
240 int is_sequence_set(char *s) {
241         if (!s) return(0);
242
243         char *c = s;
244         char ch;
245         while (ch = *c++, ch) {
246                 if (!strchr("0123456789*,:", ch)) {
247                         return(0);
248                 }
249         }
250         return(1);
251 }
252
253
254
255 /* 
256  *  Traverse the visits file...
257  */
258 void migr_export_visits(void) {
259         visit vbuf;
260         struct cdbdata *cdbv;
261
262         cdb_rewind(CDB_VISIT);
263
264         while (cdbv = cdb_next_item(CDB_VISIT), cdbv != NULL) {
265                 memset(&vbuf, 0, sizeof(visit));
266                 memcpy(&vbuf, cdbv->ptr,
267                        ((cdbv->len > sizeof(visit)) ?
268                         sizeof(visit) : cdbv->len));
269                 cdb_free(cdbv);
270
271                 client_write("<visit>\n", 8);
272                 cprintf("<v_roomnum>%ld</v_roomnum>\n", vbuf.v_roomnum);
273                 cprintf("<v_roomgen>%ld</v_roomgen>\n", vbuf.v_roomgen);
274                 cprintf("<v_usernum>%ld</v_usernum>\n", vbuf.v_usernum);
275
276                 client_write("<v_seen>", 8);
277                 if ( (!IsEmptyStr(vbuf.v_seen)) && (is_sequence_set(vbuf.v_seen)) ) {
278                         xml_strout(vbuf.v_seen);
279                 }
280                 else {
281                         cprintf("%ld", vbuf.v_lastseen);
282                 }
283                 client_write("</v_seen>", 9);
284
285                 if ( (!IsEmptyStr(vbuf.v_answered)) && (is_sequence_set(vbuf.v_answered)) ) {
286                         client_write("<v_answered>", 12);
287                         xml_strout(vbuf.v_answered);
288                         client_write("</v_answered>\n", 14);
289                 }
290
291                 cprintf("<v_flags>%u</v_flags>\n", vbuf.v_flags);
292                 cprintf("<v_view>%d</v_view>\n", vbuf.v_view);
293                 client_write("</visit>\n", 9);
294         }
295 }
296
297
298 void migr_export_message(long msgnum) {
299         struct MetaData smi;
300         struct CtdlMessage *msg;
301         struct ser_ret smr;
302
303         /* We can use a static buffer here because there will never be more than
304          * one of this operation happening at any given time, and it's really best
305          * to just keep it allocated once instead of torturing malloc/free.
306          * Call this function with msgnum "-1" to free the buffer when finished.
307          */
308         static int encoded_alloc = 0;
309         static char *encoded_msg = NULL;
310
311         if (msgnum < 0) {
312                 if ((encoded_alloc == 0) && (encoded_msg != NULL)) {
313                         free(encoded_msg);
314                         encoded_alloc = 0;
315                         encoded_msg = NULL;
316                 }
317                 return;
318         }
319
320         /* Ok, here we go ... */
321
322         msg = CtdlFetchMessage(msgnum, 1);
323         if (msg == NULL) return;        /* fail silently */
324
325         client_write("<message>\n", 10);
326         GetMetaData(&smi, msgnum);
327         cprintf("<msg_msgnum>%ld</msg_msgnum>\n", msgnum);
328         cprintf("<msg_meta_refcount>%d</msg_meta_refcount>\n", smi.meta_refcount);
329         client_write("<msg_meta_content_type>", 23); xml_strout(smi.meta_content_type); client_write("</msg_meta_content_type>\n", 25);
330
331         client_write("<msg_text>", 10);
332         CtdlSerializeMessage(&smr, msg);
333         CM_Free(msg);
334
335         /* Predict the buffer size we need.  Expand the buffer if necessary. */
336         int encoded_len = smr.len * 15 / 10 ;
337         if (encoded_len > encoded_alloc) {
338                 encoded_alloc = encoded_len;
339                 encoded_msg = realloc(encoded_msg, encoded_alloc);
340         }
341
342         if (encoded_msg == NULL) {
343                 /* Questionable hack that hopes it'll work next time and we only lose one message */
344                 encoded_alloc = 0;
345         }
346         else {
347                 /* Once we do the encoding we know the exact size */
348                 encoded_len = CtdlEncodeBase64(encoded_msg, (char *)smr.ser, smr.len, 1);
349                 client_write(encoded_msg, encoded_len);
350         }
351
352         free(smr.ser);
353
354         client_write("</msg_text>\n", 12);
355         client_write("</message>\n", 11);
356 }
357
358
359
360 void migr_export_openids(void) {
361         struct cdbdata *cdboi;
362         long usernum;
363         char url[512];
364
365         cdb_rewind(CDB_OPENID);
366         while (cdboi = cdb_next_item(CDB_OPENID), cdboi != NULL) {
367                 if (cdboi->len > sizeof(long)) {
368                         client_write("<openid>\n", 9);
369                         memcpy(&usernum, cdboi->ptr, sizeof(long));
370                         snprintf(url, sizeof url, "%s", (cdboi->ptr)+sizeof(long) );
371                         client_write("<oid_url>", 9);
372                         xml_strout(url);
373                         client_write("</oid_url>\n", 11);
374                         cprintf("<oid_usernum>%ld</oid_usernum>\n", usernum);
375                         client_write("</openid>\n", 10);
376                 }
377                 cdb_free(cdboi);
378         }
379 }
380
381
382
383
384 void migr_export_messages(void) {
385         char buf[SIZ];
386         long msgnum;
387         int count = 0;
388         int progress = 0;
389         int prev_progress = 0;
390         CitContext *Ctx;
391
392         Ctx = CC;
393         migr_global_message_list = fopen(migr_tempfilename1, "r");
394         if (migr_global_message_list != NULL) {
395                 syslog(LOG_INFO, "Opened %s\n", migr_tempfilename1);
396                 while ((Ctx->kill_me == 0) && 
397                        (fgets(buf, sizeof(buf), migr_global_message_list) != NULL)) {
398                         msgnum = atol(buf);
399                         if (msgnum > 0L) {
400                                 migr_export_message(msgnum);
401                                 ++count;
402                         }
403                         progress = (count * 74 / total_msgs) + 25 ;
404                         if ((progress > prev_progress) && (progress < 100)) {
405                                 cprintf("<progress>%d</progress>\n", progress);
406                         }
407                         prev_progress = progress;
408                 }
409                 fclose(migr_global_message_list);
410         }
411         if (Ctx->kill_me == 0)
412                 syslog(LOG_INFO, "Exported %d messages.\n", count);
413         else
414                 syslog(LOG_ERR, "Export aborted due to client disconnect! \n");
415
416         migr_export_message(-1L);       /* This frees the encoding buffer */
417 }
418
419
420
421 void migr_do_export(void) {
422         CitContext *Ctx;
423
424         Ctx = CC;
425         cprintf("%d Exporting all Citadel databases.\n", LISTING_FOLLOWS);
426         Ctx->dont_term = 1;
427
428         client_write("<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n", 40);
429         client_write("<citadel_migrate_data>\n", 23);
430         cprintf("<version>%d</version>\n", REV_LEVEL);
431         cprintf("<progress>%d</progress>\n", 0);
432
433         /* export the config file (this is done using x-macros) */
434         client_write("<config>\n", 9);
435         client_write("<c_nodename>", 12);       xml_strout(config.c_nodename);          client_write("</c_nodename>\n", 14);
436         client_write("<c_fqdn>", 8);            xml_strout(config.c_fqdn);              client_write("</c_fqdn>\n", 10);
437         client_write("<c_humannode>", 13);      xml_strout(config.c_humannode);         client_write("</c_humannode>\n", 15);
438         client_write("<c_phonenum>", 12);       xml_strout(config.c_phonenum);          client_write("</c_phonenum>\n", 14);
439         cprintf("<c_ctdluid>%d</c_ctdluid>\n", config.c_ctdluid);
440         cprintf("<c_creataide>%d</c_creataide>\n", config.c_creataide);
441         cprintf("<c_sleeping>%d</c_sleeping>\n", config.c_sleeping);
442         cprintf("<c_initax>%d</c_initax>\n", config.c_initax);
443         cprintf("<c_regiscall>%d</c_regiscall>\n", config.c_regiscall);
444         cprintf("<c_twitdetect>%d</c_twitdetect>\n", config.c_twitdetect);
445         client_write("<c_twitroom>", 12);       xml_strout(config.c_twitroom);          client_write("</c_twitroom>\n", 14);
446         client_write("<c_moreprompt>", 14);     xml_strout(config.c_moreprompt);        client_write("</c_moreprompt>\n", 16);
447         cprintf("<c_restrict>%d</c_restrict>\n", config.c_restrict);
448         client_write("<c_site_location>", 17);  xml_strout(config.c_site_location);     client_write("</c_site_location>\n", 19);
449         client_write("<c_sysadm>", 10);         xml_strout(config.c_sysadm);            client_write("</c_sysadm>\n", 12);
450         cprintf("<c_maxsessions>%d</c_maxsessions>\n", config.c_maxsessions);
451         client_write("<c_ip_addr>", 11);        xml_strout(config.c_ip_addr);           client_write("</c_ip_addr>\n", 13);
452         cprintf("<c_port_number>%d</c_port_number>\n", config.c_port_number);
453         cprintf("<c_ep_expire_mode>%d</c_ep_expire_mode>\n", config.c_ep.expire_mode);
454         cprintf("<c_ep_expire_value>%d</c_ep_expire_value>\n", config.c_ep.expire_value);
455         cprintf("<c_userpurge>%d</c_userpurge>\n", config.c_userpurge);
456         cprintf("<c_roompurge>%d</c_roompurge>\n", config.c_roompurge);
457         client_write("<c_logpages>", 12);       xml_strout(config.c_logpages);          client_write("</c_logpages>\n", 14);
458         cprintf("<c_createax>%d</c_createax>\n", config.c_createax);
459         cprintf("<c_maxmsglen>%ld</c_maxmsglen>\n", config.c_maxmsglen);
460         cprintf("<c_min_workers>%d</c_min_workers>\n", config.c_min_workers);
461         cprintf("<c_max_workers>%d</c_max_workers>\n", config.c_max_workers);
462         cprintf("<c_pop3_port>%d</c_pop3_port>\n", config.c_pop3_port);
463         cprintf("<c_smtp_port>%d</c_smtp_port>\n", config.c_smtp_port);
464         cprintf("<c_rfc822_strict_from>%d</c_rfc822_strict_from>\n", config.c_rfc822_strict_from);
465         cprintf("<c_aide_zap>%d</c_aide_zap>\n", config.c_aide_zap);
466         cprintf("<c_imap_port>%d</c_imap_port>\n", config.c_imap_port);
467         cprintf("<c_net_freq>%ld</c_net_freq>\n", config.c_net_freq);
468         cprintf("<c_disable_newu>%d</c_disable_newu>\n", config.c_disable_newu);
469         cprintf("<c_enable_fulltext>%d</c_enable_fulltext>\n", config.c_enable_fulltext);
470         client_write("<c_baseroom>", 12);       xml_strout(config.c_baseroom);          client_write("</c_baseroom>\n", 14);
471         client_write("<c_aideroom>", 12);       xml_strout(config.c_aideroom);          client_write("</c_aideroom>\n", 14);
472         cprintf("<c_purge_hour>%d</c_purge_hour>\n", config.c_purge_hour);
473         cprintf("<c_mbxep_expire_mode>%d</c_mbxep_expire_mode>\n", config.c_mbxep.expire_mode);
474         cprintf("<c_mbxep_expire_value>%d</c_mbxep_expire_value>\n", config.c_mbxep.expire_value);
475         client_write("<c_ldap_host>", 13);      xml_strout(config.c_ldap_host);         client_write("</c_ldap_host>\n", 15);
476         cprintf("<c_ldap_port>%d</c_ldap_port>\n", config.c_ldap_port);
477         client_write("<c_ldap_base_dn>", 16);   xml_strout(config.c_ldap_base_dn);      client_write("</c_ldap_base_dn>\n", 18);
478         client_write("<c_ldap_bind_dn>", 16);   xml_strout(config.c_ldap_bind_dn);      client_write("</c_ldap_bind_dn>\n", 18);
479         client_write("<c_ldap_bind_pw>", 16);   xml_strout(config.c_ldap_bind_pw);      client_write("</c_ldap_bind_pw>\n", 18);
480         cprintf("<c_msa_port>%d</c_msa_port>\n", config.c_msa_port);
481         cprintf("<c_imaps_port>%d</c_imaps_port>\n", config.c_imaps_port);
482         cprintf("<c_pop3s_port>%d</c_pop3s_port>\n", config.c_pop3s_port);
483         cprintf("<c_smtps_port>%d</c_smtps_port>\n", config.c_smtps_port);
484         cprintf("<c_auto_cull>%d</c_auto_cull>\n", config.c_auto_cull);
485         cprintf("<c_allow_spoofing>%d</c_allow_spoofing>\n", config.c_allow_spoofing);
486         cprintf("<c_journal_email>%d</c_journal_email>\n", config.c_journal_email);
487         cprintf("<c_journal_pubmsgs>%d</c_journal_pubmsgs>\n", config.c_journal_pubmsgs);
488         client_write("<c_journal_dest>", 16);   xml_strout(config.c_journal_dest);      client_write("</c_journal_dest>\n", 18);
489         client_write("<c_default_cal_zone>", 20);       xml_strout(config.c_default_cal_zone);  client_write("</c_default_cal_zone>\n", 22);
490         cprintf("<c_pftcpdict_port>%d</c_pftcpdict_port>\n", config.c_pftcpdict_port);
491         cprintf("<c_managesieve_port>%d</c_managesieve_port>\n", config.c_managesieve_port);
492         cprintf("<c_auth_mode>%d</c_auth_mode>\n", config.c_auth_mode);
493         client_write("<c_funambol_host>", 17);  xml_strout(config.c_funambol_host);     client_write("</c_funambol_host>\n", 19);
494         cprintf("<c_funambol_port>%d</c_funambol_port>\n", config.c_funambol_port);
495         client_write("<c_funambol_source>", 19);        xml_strout(config.c_funambol_source);   client_write("</c_funambol_source>\n", 21);
496         client_write("<c_funambol_auth>", 17);  xml_strout(config.c_funambol_auth);     client_write("</c_funambol_auth>\n", 19);
497         cprintf("<c_rbl_at_greeting>%d</c_rbl_at_greeting>\n", config.c_rbl_at_greeting);
498         client_write("<c_master_user>", 15);    xml_strout(config.c_master_user);               client_write("</c_master_user>\n", 17);
499         client_write("<c_master_pass>", 15);    xml_strout(config.c_master_pass);               client_write("</c_master_pass>\n", 17);
500         client_write("<c_pager_program>", 17);  xml_strout(config.c_pager_program);             client_write("</c_pager_program>\n", 19);
501         cprintf("<c_imap_keep_from>%d</c_imap_keep_from>\n", config.c_imap_keep_from);
502         cprintf("<c_xmpp_c2s_port>%d</c_xmpp_c2s_port>\n", config.c_xmpp_c2s_port);
503         cprintf("<c_xmpp_s2s_port>%d</c_xmpp_s2s_port>\n", config.c_xmpp_s2s_port);
504         cprintf("<c_pop3_fetch>%ld</c_pop3_fetch>\n", config.c_pop3_fetch);
505         cprintf("<c_pop3_fastest>%ld</c_pop3_fastest>\n", config.c_pop3_fastest);
506         cprintf("<c_spam_flag_only>%d</c_spam_flag_only>\n", config.c_spam_flag_only);
507         cprintf("<c_nntp_port>%d</c_nntp_port>\n", config.c_nntp_port);
508         cprintf("<c_nntps_port>%d</c_nntps_port>\n", config.c_nntps_port);
509         client_write("</config>\n", 10);
510         cprintf("<progress>%d</progress>\n", 1);
511         
512         /* Export the control file */
513         get_control();
514         client_write("<control>\n", 10);
515         cprintf("<control_highest>%ld</control_highest>\n", CitControl.MMhighest);
516         cprintf("<control_flags>%u</control_flags>\n", CitControl.MMflags);
517         cprintf("<control_nextuser>%ld</control_nextuser>\n", CitControl.MMnextuser);
518         cprintf("<control_nextroom>%ld</control_nextroom>\n", CitControl.MMnextroom);
519         cprintf("<control_version>%d</control_version>\n", CitControl.version);
520         client_write("</control>\n", 11);
521         cprintf("<progress>%d</progress>\n", 2);
522
523         if (Ctx->kill_me == 0)  migr_export_users();
524         cprintf("<progress>%d</progress>\n", 7);
525         if (Ctx->kill_me == 0)  migr_export_openids();
526         cprintf("<progress>%d</progress>\n", 12);
527         if (Ctx->kill_me == 0)  migr_export_rooms();
528         cprintf("<progress>%d</progress>\n", 17);
529         if (Ctx->kill_me == 0)  migr_export_floors();
530         cprintf("<progress>%d</progress>\n", 18);
531         if (Ctx->kill_me == 0)  migr_export_visits();
532         cprintf("<progress>%d</progress>\n", 25);
533         if (Ctx->kill_me == 0)  migr_export_messages();
534         client_write("</citadel_migrate_data>\n", 24);
535         cprintf("<progress>%d</progress>\n", 100);
536         client_write("000\n", 4);
537         Ctx->dont_term = 0;
538 }
539
540
541
542
543         
544 /*
545  * Here's the code that implements the import side.  It's going to end up being
546  * one big loop with lots of global variables.  I don't care.  You wouldn't run
547  * multiple concurrent imports anyway.  If this offends your delicate sensibilities
548  * then go rewrite it in Ruby on Rails or something.
549  */
550
551
552 int citadel_migrate_data = 0;           /* Are we inside a <citadel_migrate_data> tag pair? */
553 StrBuf *migr_chardata = NULL;
554 StrBuf *migr_MsgData = NULL;
555 struct ctdluser usbuf;
556 struct ctdlroom qrbuf;
557 char openid_url[512];
558 long openid_usernum = 0;
559 char FRname[ROOMNAMELEN];
560 struct floor flbuf;
561 int floornum = 0;
562 visit vbuf;
563 struct MetaData smi;
564 long import_msgnum = 0;
565
566 /*
567  * This callback stores up the data which appears in between tags.
568  */
569 void migr_xml_chardata(void *data, const XML_Char *s, int len)
570 {
571         StrBufAppendBufPlain(migr_chardata, s, len, 0);
572 }
573
574
575 void migr_xml_start(void *data, const char *el, const char **attr) {
576         int i;
577
578         /*** GENERAL STUFF ***/
579
580         /* Reset chardata_len to zero and init buffer */
581         FlushStrBuf(migr_chardata);
582         FlushStrBuf(migr_MsgData);
583
584         if (!strcasecmp(el, "citadel_migrate_data")) {
585                 ++citadel_migrate_data;
586
587                 /* As soon as it looks like the input data is a genuine Citadel XML export,
588                  * whack the existing database on disk to make room for the new one.
589                  */
590                 if (citadel_migrate_data == 1) {
591                         for (i = 0; i < MAXCDB; ++i) {
592                                 cdb_trunc(i);
593                         }
594                 }
595                 return;
596         }
597
598         if (citadel_migrate_data != 1) {
599                 syslog(LOG_ALERT, "Out-of-sequence tag <%s> detected.  Warning: ODD-DATA!\n", el);
600                 return;
601         }
602
603         /* When we begin receiving XML for one of these record types, clear out the associated
604          * buffer so we don't accidentally carry over any data from a previous record.
605          */
606         if (!strcasecmp(el, "user"))                    memset(&usbuf, 0, sizeof (struct ctdluser));
607         else if (!strcasecmp(el, "openid"))             memset(openid_url, 0, sizeof openid_url);
608         else if (!strcasecmp(el, "room"))               memset(&qrbuf, 0, sizeof (struct ctdlroom));
609         else if (!strcasecmp(el, "room_messages"))      memset(FRname, 0, sizeof FRname);
610         else if (!strcasecmp(el, "floor"))              memset(&flbuf, 0, sizeof (struct floor));
611         else if (!strcasecmp(el, "visit"))              memset(&vbuf, 0, sizeof (visit));
612
613         else if (!strcasecmp(el, "message")) {
614                 memset(&smi, 0, sizeof (struct MetaData));
615                 import_msgnum = 0;
616         }
617
618 }
619
620
621 int migr_config(void *data, const char *el)
622 {
623         if (!strcasecmp(el, "c_nodename"))                      SET_CFGSTRBUF(c_nodename, migr_chardata);
624         else if (!strcasecmp(el, "c_fqdn"))                     SET_CFGSTRBUF(c_fqdn, migr_chardata);
625         else if (!strcasecmp(el, "c_humannode"))                SET_CFGSTRBUF(c_humannode, migr_chardata);
626         else if (!strcasecmp(el, "c_phonenum"))                 SET_CFGSTRBUF(c_phonenum, migr_chardata);
627         else if (!strcasecmp(el, "c_ctdluid"))                  config.c_ctdluid = atoi(ChrPtr(migr_chardata));
628         else if (!strcasecmp(el, "c_creataide"))                config.c_creataide = atoi(ChrPtr(migr_chardata));
629         else if (!strcasecmp(el, "c_sleeping"))                 config.c_sleeping = atoi(ChrPtr(migr_chardata));
630         else if (!strcasecmp(el, "c_initax"))                   config.c_initax = atoi(ChrPtr(migr_chardata));
631         else if (!strcasecmp(el, "c_regiscall"))                config.c_regiscall = atoi(ChrPtr(migr_chardata));
632         else if (!strcasecmp(el, "c_twitdetect"))               config.c_twitdetect = atoi(ChrPtr(migr_chardata));
633         else if (!strcasecmp(el, "c_twitroom"))                 SET_CFGSTRBUF(c_twitroom, migr_chardata);
634         else if (!strcasecmp(el, "c_moreprompt"))               SET_CFGSTRBUF(c_moreprompt, migr_chardata);
635         else if (!strcasecmp(el, "c_restrict"))                 config.c_restrict = atoi(ChrPtr(migr_chardata));
636         else if (!strcasecmp(el, "c_site_location"))            SET_CFGSTRBUF(c_site_location, migr_chardata);
637         else if (!strcasecmp(el, "c_sysadm"))                   SET_CFGSTRBUF(c_sysadm, migr_chardata);
638         else if (!strcasecmp(el, "c_maxsessions"))              config.c_maxsessions = atoi(ChrPtr(migr_chardata));
639         else if (!strcasecmp(el, "c_ip_addr"))                  SET_CFGSTRBUF(c_ip_addr, migr_chardata);
640         else if (!strcasecmp(el, "c_port_number"))              config.c_port_number = atoi(ChrPtr(migr_chardata));
641         else if (!strcasecmp(el, "c_ep_expire_mode"))           config.c_ep.expire_mode = atoi(ChrPtr(migr_chardata));
642         else if (!strcasecmp(el, "c_ep_expire_value"))          config.c_ep.expire_value = atoi(ChrPtr(migr_chardata));
643         else if (!strcasecmp(el, "c_userpurge"))                config.c_userpurge = atoi(ChrPtr(migr_chardata));
644         else if (!strcasecmp(el, "c_roompurge"))                config.c_roompurge = atoi(ChrPtr(migr_chardata));
645         else if (!strcasecmp(el, "c_logpages"))                 SET_CFGSTRBUF(c_logpages, migr_chardata);
646         else if (!strcasecmp(el, "c_createax"))                 config.c_createax = atoi(ChrPtr(migr_chardata));
647         else if (!strcasecmp(el, "c_maxmsglen"))                config.c_maxmsglen = atol(ChrPtr(migr_chardata));
648         else if (!strcasecmp(el, "c_min_workers"))              config.c_min_workers = atoi(ChrPtr(migr_chardata));
649         else if (!strcasecmp(el, "c_max_workers"))              config.c_max_workers = atoi(ChrPtr(migr_chardata));
650         else if (!strcasecmp(el, "c_pop3_port"))                config.c_pop3_port = atoi(ChrPtr(migr_chardata));
651         else if (!strcasecmp(el, "c_smtp_port"))                config.c_smtp_port = atoi(ChrPtr(migr_chardata));
652         else if (!strcasecmp(el, "c_rfc822_strict_from"))       config.c_rfc822_strict_from = atoi(ChrPtr(migr_chardata));
653         else if (!strcasecmp(el, "c_aide_zap"))                 config.c_aide_zap = atoi(ChrPtr(migr_chardata));
654         else if (!strcasecmp(el, "c_imap_port"))                config.c_imap_port = atoi(ChrPtr(migr_chardata));
655         else if (!strcasecmp(el, "c_net_freq"))                 config.c_net_freq = atol(ChrPtr(migr_chardata));
656         else if (!strcasecmp(el, "c_disable_newu"))             config.c_disable_newu = atoi(ChrPtr(migr_chardata));
657         else if (!strcasecmp(el, "c_enable_fulltext"))          config.c_enable_fulltext = atoi(ChrPtr(migr_chardata));
658         else if (!strcasecmp(el, "c_baseroom"))                 SET_CFGSTRBUF(c_baseroom, migr_chardata);
659         else if (!strcasecmp(el, "c_aideroom"))                 SET_CFGSTRBUF(c_aideroom, migr_chardata);
660         else if (!strcasecmp(el, "c_purge_hour"))               config.c_purge_hour = atoi(ChrPtr(migr_chardata));
661         else if (!strcasecmp(el, "c_mbxep_expire_mode"))        config.c_mbxep.expire_mode = atoi(ChrPtr(migr_chardata));
662         else if (!strcasecmp(el, "c_mbxep_expire_value"))       config.c_mbxep.expire_value = atoi(ChrPtr(migr_chardata));
663         else if (!strcasecmp(el, "c_ldap_host"))                SET_CFGSTRBUF(c_ldap_host, migr_chardata);
664         else if (!strcasecmp(el, "c_ldap_port"))                config.c_ldap_port = atoi(ChrPtr(migr_chardata));
665         else if (!strcasecmp(el, "c_ldap_base_dn"))             SET_CFGSTRBUF(c_ldap_base_dn, migr_chardata);
666         else if (!strcasecmp(el, "c_ldap_bind_dn"))             SET_CFGSTRBUF(c_ldap_bind_dn, migr_chardata);
667         else if (!strcasecmp(el, "c_ldap_bind_pw"))             SET_CFGSTRBUF(c_ldap_bind_pw, migr_chardata);
668         else if (!strcasecmp(el, "c_msa_port"))                 config.c_msa_port = atoi(ChrPtr(migr_chardata));
669         else if (!strcasecmp(el, "c_imaps_port"))               config.c_imaps_port = atoi(ChrPtr(migr_chardata));
670         else if (!strcasecmp(el, "c_pop3s_port"))               config.c_pop3s_port = atoi(ChrPtr(migr_chardata));
671         else if (!strcasecmp(el, "c_smtps_port"))               config.c_smtps_port = atoi(ChrPtr(migr_chardata));
672         else if (!strcasecmp(el, "c_auto_cull"))                config.c_auto_cull = atoi(ChrPtr(migr_chardata));
673         else if (!strcasecmp(el, "c_allow_spoofing"))           config.c_allow_spoofing = atoi(ChrPtr(migr_chardata));
674         else if (!strcasecmp(el, "c_journal_email"))            config.c_journal_email = atoi(ChrPtr(migr_chardata));
675         else if (!strcasecmp(el, "c_journal_pubmsgs"))          config.c_journal_pubmsgs = atoi(ChrPtr(migr_chardata));
676         else if (!strcasecmp(el, "c_journal_dest"))             SET_CFGSTRBUF(c_journal_dest, migr_chardata);
677         else if (!strcasecmp(el, "c_default_cal_zone"))         SET_CFGSTRBUF(c_default_cal_zone, migr_chardata);
678         else if (!strcasecmp(el, "c_pftcpdict_port"))           config.c_pftcpdict_port = atoi(ChrPtr(migr_chardata));
679         else if (!strcasecmp(el, "c_managesieve_port"))         config.c_managesieve_port = atoi(ChrPtr(migr_chardata));
680         else if (!strcasecmp(el, "c_auth_mode"))                config.c_auth_mode = atoi(ChrPtr(migr_chardata));
681         else if (!strcasecmp(el, "c_funambol_host"))            SET_CFGSTRBUF(c_funambol_host, migr_chardata);
682         else if (!strcasecmp(el, "c_funambol_port"))            config.c_funambol_port = atoi(ChrPtr(migr_chardata));
683         else if (!strcasecmp(el, "c_funambol_source"))          SET_CFGSTRBUF(c_funambol_source, migr_chardata);
684         else if (!strcasecmp(el, "c_funambol_auth"))            SET_CFGSTRBUF(c_funambol_auth, migr_chardata);
685         else if (!strcasecmp(el, "c_rbl_at_greeting"))          config.c_rbl_at_greeting = atoi(ChrPtr(migr_chardata));
686         else if (!strcasecmp(el, "c_master_user"))              SET_CFGSTRBUF(c_master_user, migr_chardata);
687         else if (!strcasecmp(el, "c_master_pass"))              SET_CFGSTRBUF(c_master_pass, migr_chardata);
688         else if (!strcasecmp(el, "c_pager_program"))            SET_CFGSTRBUF(c_pager_program, migr_chardata);
689         else if (!strcasecmp(el, "c_imap_keep_from"))           config.c_imap_keep_from = atoi(ChrPtr(migr_chardata));
690         else if (!strcasecmp(el, "c_xmpp_c2s_port"))            config.c_xmpp_c2s_port = atoi(ChrPtr(migr_chardata));
691         else if (!strcasecmp(el, "c_xmpp_s2s_port"))            config.c_xmpp_s2s_port = atoi(ChrPtr(migr_chardata));
692         else if (!strcasecmp(el, "c_pop3_fetch"))               config.c_pop3_fetch = atol(ChrPtr(migr_chardata));
693         else if (!strcasecmp(el, "c_pop3_fastest"))             config.c_pop3_fastest = atol(ChrPtr(migr_chardata));
694         else if (!strcasecmp(el, "c_spam_flag_only"))           config.c_spam_flag_only = atoi(ChrPtr(migr_chardata));
695         else if (!strcasecmp(el, "c_nntp_port"))                config.c_nntp_port = atoi(ChrPtr(migr_chardata));
696         else if (!strcasecmp(el, "c_nntps_port"))               config.c_nntps_port = atoi(ChrPtr(migr_chardata));
697         else return 0;
698         return 1; /* Found above...*/
699 }
700
701 int migr_controlrecord(void *data, const char *el)
702 {
703         if (!strcasecmp(el, "control_highest"))         CitControl.MMhighest = atol(ChrPtr(migr_chardata));
704         else if (!strcasecmp(el, "control_flags"))              CitControl.MMflags = atoi(ChrPtr(migr_chardata));
705         else if (!strcasecmp(el, "control_nextuser"))           CitControl.MMnextuser = atol(ChrPtr(migr_chardata));
706         else if (!strcasecmp(el, "control_nextroom"))           CitControl.MMnextroom = atol(ChrPtr(migr_chardata));
707         else if (!strcasecmp(el, "control_version"))            CitControl.version = atoi(ChrPtr(migr_chardata));
708
709         else if (!strcasecmp(el, "control")) {
710                 CitControl.MMfulltext = (-1L);  /* always flush */
711                 put_control();
712                 syslog(LOG_INFO, "Completed import of control record\n");
713         }
714         else return 0;
715         return 1;
716
717 }
718
719
720 int migr_userrecord(void *data, const char *el)
721 {
722         if (!strcasecmp(el, "u_version"))                       usbuf.version = atoi(ChrPtr(migr_chardata));
723         else if (!strcasecmp(el, "u_uid"))                      usbuf.uid = atol(ChrPtr(migr_chardata));
724         else if (!strcasecmp(el, "u_password"))                 safestrncpy(usbuf.password, ChrPtr(migr_chardata), sizeof usbuf.password);
725         else if (!strcasecmp(el, "u_flags"))                    usbuf.flags = atoi(ChrPtr(migr_chardata));
726         else if (!strcasecmp(el, "u_timescalled"))              usbuf.timescalled = atol(ChrPtr(migr_chardata));
727         else if (!strcasecmp(el, "u_posted"))                   usbuf.posted = atol(ChrPtr(migr_chardata));
728         else if (!strcasecmp(el, "u_axlevel"))                  usbuf.axlevel = atoi(ChrPtr(migr_chardata));
729         else if (!strcasecmp(el, "u_usernum"))                  usbuf.usernum = atol(ChrPtr(migr_chardata));
730         else if (!strcasecmp(el, "u_lastcall"))                 usbuf.lastcall = atol(ChrPtr(migr_chardata));
731         else if (!strcasecmp(el, "u_USuserpurge"))              usbuf.USuserpurge = atoi(ChrPtr(migr_chardata));
732         else if (!strcasecmp(el, "u_fullname"))                 safestrncpy(usbuf.fullname, ChrPtr(migr_chardata), sizeof usbuf.fullname);
733         else return 0;
734         return 1;
735 }
736
737 int migr_roomrecord(void *data, const char *el)
738 {
739         if (!strcasecmp(el, "QRname"))                  safestrncpy(qrbuf.QRname, ChrPtr(migr_chardata), sizeof qrbuf.QRname);
740         else if (!strcasecmp(el, "QRpasswd"))                   safestrncpy(qrbuf.QRpasswd, ChrPtr(migr_chardata), sizeof qrbuf.QRpasswd);
741         else if (!strcasecmp(el, "QRroomaide"))                 qrbuf.QRroomaide = atol(ChrPtr(migr_chardata));
742         else if (!strcasecmp(el, "QRhighest"))                  qrbuf.QRhighest = atol(ChrPtr(migr_chardata));
743         else if (!strcasecmp(el, "QRgen"))                      qrbuf.QRgen = atol(ChrPtr(migr_chardata));
744         else if (!strcasecmp(el, "QRflags"))                    qrbuf.QRflags = atoi(ChrPtr(migr_chardata));
745         else if (!strcasecmp(el, "QRdirname"))                  safestrncpy(qrbuf.QRdirname, ChrPtr(migr_chardata), sizeof qrbuf.QRdirname);
746         else if (!strcasecmp(el, "QRinfo"))                     qrbuf.QRinfo = atol(ChrPtr(migr_chardata));
747         else if (!strcasecmp(el, "QRfloor"))                    qrbuf.QRfloor = atoi(ChrPtr(migr_chardata));
748         else if (!strcasecmp(el, "QRmtime"))                    qrbuf.QRmtime = atol(ChrPtr(migr_chardata));
749         else if (!strcasecmp(el, "QRexpire_mode"))              qrbuf.QRep.expire_mode = atoi(ChrPtr(migr_chardata));
750         else if (!strcasecmp(el, "QRexpire_value"))             qrbuf.QRep.expire_value = atoi(ChrPtr(migr_chardata));
751         else if (!strcasecmp(el, "QRnumber"))                   qrbuf.QRnumber = atol(ChrPtr(migr_chardata));
752         else if (!strcasecmp(el, "QRorder"))                    qrbuf.QRorder = atoi(ChrPtr(migr_chardata));
753         else if (!strcasecmp(el, "QRflags2"))                   qrbuf.QRflags2 = atoi(ChrPtr(migr_chardata));
754         else if (!strcasecmp(el, "QRdefaultview"))              qrbuf.QRdefaultview = atoi(ChrPtr(migr_chardata));
755         else return 0;
756         return 1;
757 }
758
759 int migr_floorrecord(void *data, const char *el)
760 {
761         if (!strcasecmp(el, "f_num"))                   floornum = atoi(ChrPtr(migr_chardata));
762         else if (!strcasecmp(el, "f_flags"))                    flbuf.f_flags = atoi(ChrPtr(migr_chardata));
763         else if (!strcasecmp(el, "f_name"))                     safestrncpy(flbuf.f_name, ChrPtr(migr_chardata), sizeof flbuf.f_name);
764         else if (!strcasecmp(el, "f_ref_count"))                flbuf.f_ref_count = atoi(ChrPtr(migr_chardata));
765         else if (!strcasecmp(el, "f_ep_expire_mode"))           flbuf.f_ep.expire_mode = atoi(ChrPtr(migr_chardata));
766         else if (!strcasecmp(el, "f_ep_expire_value"))          flbuf.f_ep.expire_value = atoi(ChrPtr(migr_chardata));
767         else return 0;
768         return 1;
769 }
770
771 int migr_visitrecord(void *data, const char *el)
772 {
773         if (!strcasecmp(el, "v_roomnum"))                       vbuf.v_roomnum = atol(ChrPtr(migr_chardata));
774         else if (!strcasecmp(el, "v_roomgen"))                  vbuf.v_roomgen = atol(ChrPtr(migr_chardata));
775         else if (!strcasecmp(el, "v_usernum"))                  vbuf.v_usernum = atol(ChrPtr(migr_chardata));
776
777         else if (!strcasecmp(el, "v_seen")) {
778                 int is_textual_seen = 0;
779                 int i;
780                 int max = StrLength(migr_chardata);
781
782                 vbuf.v_lastseen = atol(ChrPtr(migr_chardata));
783                 is_textual_seen = 0;
784                 for (i=0; i < max; ++i) 
785                         if (!isdigit(ChrPtr(migr_chardata)[i]))
786                                 is_textual_seen = 1;
787                 if (is_textual_seen)
788                         safestrncpy(vbuf.v_seen, ChrPtr(migr_chardata), sizeof vbuf.v_seen);
789         }
790
791         else if (!strcasecmp(el, "v_answered"))                 safestrncpy(vbuf.v_answered, ChrPtr(migr_chardata), sizeof vbuf.v_answered);
792         else if (!strcasecmp(el, "v_flags"))                    vbuf.v_flags = atoi(ChrPtr(migr_chardata));
793         else if (!strcasecmp(el, "v_view"))                     vbuf.v_view = atoi(ChrPtr(migr_chardata));
794         else return 0;
795         return 1;
796 }
797 void migr_xml_end(void *data, const char *el)
798 {
799         const char *ptr;
800         int msgcount = 0;
801         long msgnum = 0L;
802         long *msglist = NULL;
803         int msglist_alloc = 0;
804         /*** GENERAL STUFF ***/
805
806         if (!strcasecmp(el, "citadel_migrate_data")) {
807                 --citadel_migrate_data;
808                 return;
809         }
810
811         if (citadel_migrate_data != 1) {
812                 syslog(LOG_ALERT, "Out-of-sequence tag <%s> detected.  Warning: ODD-DATA!\n", el);
813                 return;
814         }
815
816         // syslog(LOG_DEBUG, "END TAG: <%s> DATA: <%s>\n", el, (migr_chardata_len ? migr_chardata : ""));
817
818         /*** CONFIG ***/
819
820         if (!strcasecmp(el, "config")) {
821                 config.c_enable_fulltext = 0;   /* always disable */
822                 put_config();
823                 syslog(LOG_INFO, "Completed import of server configuration\n");
824         }
825
826         else if ((!strncasecmp(el, HKEY("c_"))) && 
827                  migr_config(data, el))
828                 ; /* Nothing to do anymore */
829                 
830         /*** CONTROL ***/
831         else if ((!strncasecmp(el, HKEY("control"))) && 
832                  migr_controlrecord(data, el))
833                 ; /* Nothing to do anymore */
834         /*** USER ***/
835         else if ((!strncasecmp(el, HKEY("u_"))) && 
836                  migr_userrecord(data, el))
837                 ; /* Nothing to do anymore */
838         else if (!strcasecmp(el, "user")) {
839                 CtdlPutUser(&usbuf);
840                 syslog(LOG_INFO, "Imported user: %s\n", usbuf.fullname);
841         }
842
843         /*** OPENID ***/
844
845         else if (!strcasecmp(el, "oid_url"))                    safestrncpy(openid_url, ChrPtr(migr_chardata), sizeof openid_url);
846         else if (!strcasecmp(el, "oid_usernum"))                openid_usernum = atol(ChrPtr(migr_chardata));
847
848         else if (!strcasecmp(el, "openid")) {                   /* see serv_openid_rp.c for a description of the record format */
849                 char *oid_data;
850                 int oid_data_len;
851                 oid_data_len = sizeof(long) + strlen(openid_url) + 1;
852                 oid_data = malloc(oid_data_len);
853                 memcpy(oid_data, &openid_usernum, sizeof(long));
854                 memcpy(&oid_data[sizeof(long)], openid_url, strlen(openid_url) + 1);
855                 cdb_store(CDB_OPENID, openid_url, strlen(openid_url), oid_data, oid_data_len);
856                 free(oid_data);
857                 syslog(LOG_INFO, "Imported OpenID: %s (%ld)\n", openid_url, openid_usernum);
858         }
859
860         /*** ROOM ***/
861         else if ((!strncasecmp(el, HKEY("QR"))) && 
862                  migr_roomrecord(data, el))
863                 ; /* Nothing to do anymore */
864         else if (!strcasecmp(el, "room")) {
865                 CtdlPutRoom(&qrbuf);
866                 syslog(LOG_INFO, "Imported room: %s\n", qrbuf.QRname);
867         }
868
869         /*** ROOM MESSAGE POINTERS ***/
870
871         else if (!strcasecmp(el, "FRname"))                     safestrncpy(FRname, ChrPtr(migr_chardata), sizeof FRname);
872
873         else if (!strcasecmp(el, "FRmsglist")) {
874                 if (!IsEmptyStr(FRname)) {
875                         msgcount = 0;
876                         msglist_alloc = 1000;
877                         msglist = malloc(sizeof(long) * msglist_alloc);
878
879                         syslog(LOG_DEBUG, "Message list for: %s\n", FRname);
880
881                         ptr = ChrPtr(migr_chardata);
882                         while (*ptr != 0) {
883                                 while ((*ptr != 0) && (!isdigit(*ptr))) {
884                                         ++ptr;
885                                 }
886                                 if ((*ptr != 0) && (isdigit(*ptr))) {
887                                         msgnum = atol(ptr);
888                                         if (msgnum > 0L) {
889                                                 if (msgcount >= msglist_alloc) {
890                                                         msglist_alloc *= 2;
891                                                         msglist = realloc(msglist, sizeof(long) * msglist_alloc);
892                                                 }
893                                                 msglist[msgcount++] = msgnum;
894                                                 }
895                                         }
896                                         while ((*ptr != 0) && (isdigit(*ptr))) {
897                                                 ++ptr;
898                                         }
899                                 }
900                         }
901                         if (msgcount > 0) {
902                                 CtdlSaveMsgPointersInRoom(FRname, msglist, msgcount, 0, NULL, 1);
903                         }
904                         free(msglist);
905                         msglist = NULL;
906                         msglist_alloc = 0;
907                         syslog(LOG_DEBUG, "Imported %d messages.\n", msgcount);
908                         if (server_shutting_down) {
909                                 return;
910                 }
911         }
912
913         /*** FLOORS ***/
914         else if ((!strncasecmp(el, HKEY("f_"))) && 
915                  migr_floorrecord(data, el))
916                 ; /* Nothing to do anymore */
917
918         else if (!strcasecmp(el, "floor")) {
919                 CtdlPutFloor(&flbuf, floornum);
920                 syslog(LOG_INFO, "Imported floor #%d (%s)\n", floornum, flbuf.f_name);
921         }
922
923         /*** VISITS ***/
924         else if ((!strncasecmp(el, HKEY("v_"))) && 
925                  migr_visitrecord(data, el))
926                 ; /* Nothing to do anymore */
927         else if (!strcasecmp(el, "visit")) {
928                 put_visit(&vbuf);
929                 syslog(LOG_INFO, "Imported visit: %ld/%ld/%ld\n", vbuf.v_roomnum, vbuf.v_roomgen, vbuf.v_usernum);
930         }
931
932         /*** MESSAGES ***/
933         
934         else if (!strcasecmp(el, "msg_msgnum"))                 import_msgnum = atol(ChrPtr(migr_chardata));
935         else if (!strcasecmp(el, "msg_meta_refcount"))          smi.meta_refcount = atoi(ChrPtr(migr_chardata));
936         else if (!strcasecmp(el, "msg_meta_content_type"))      safestrncpy(smi.meta_content_type, ChrPtr(migr_chardata), sizeof smi.meta_content_type);
937
938         else if (!strcasecmp(el, "msg_text"))
939         {
940
941                 FlushStrBuf(migr_MsgData);
942                 StrBufDecodeBase64To(migr_MsgData, migr_MsgData);
943
944                 cdb_store(CDB_MSGMAIN,
945                           &import_msgnum,
946                           sizeof(long),
947                           ChrPtr(migr_MsgData), 
948                           StrLength(migr_MsgData) + 1);
949
950                 smi.meta_msgnum = import_msgnum;
951                 PutMetaData(&smi);
952
953                 syslog(LOG_INFO,
954                        "Imported message #%ld, size=%d, refcount=%d, content-type: %s\n",
955                        import_msgnum,
956                        StrLength(migr_MsgData),
957                        smi.meta_refcount,
958                        smi.meta_content_type);
959         }
960
961         /*** MORE GENERAL STUFF ***/
962
963         FlushStrBuf(migr_chardata);
964 }
965
966
967
968
969 /*
970  * Import begins here
971  */
972 void migr_do_import(void) {
973         StrBuf *Buf;
974         XML_Parser xp;
975         int Finished = 0;
976         
977         unbuffer_output();
978         migr_chardata = NewStrBufPlain(NULL, SIZ * 20);
979         migr_MsgData = NewStrBufPlain(NULL, SIZ * 20);
980         Buf = NewStrBufPlain(NULL, SIZ);
981         xp = XML_ParserCreate(NULL);
982         if (!xp) {
983                 cprintf("%d Failed to create XML parser instance\n", ERROR+INTERNAL_ERROR);
984                 return;
985         }
986         XML_SetElementHandler(xp, migr_xml_start, migr_xml_end);
987         XML_SetCharacterDataHandler(xp, migr_xml_chardata);
988
989         CC->dont_term = 1;
990
991         cprintf("%d sock it to me\n", SEND_LISTING);
992         unbuffer_output();
993
994         client_set_inbound_buf(SIZ * 10);
995
996         while (!Finished && client_read_random_blob(Buf, -1) >= 0) {
997                 if ((StrLength(Buf) > 4) &&
998                     !strcmp(ChrPtr(Buf) + StrLength(Buf) - 4, "000\n"))
999                 {
1000                         Finished = 1;
1001                         StrBufCutAt(Buf, StrLength(Buf) - 4, NULL);
1002                 }
1003                 if (server_shutting_down)
1004                         break;  // Should we break or return?
1005                 
1006                 if (StrLength(Buf) == 0)
1007                         continue;
1008
1009                 XML_Parse(xp, ChrPtr(Buf), StrLength(Buf), 0);
1010                 FlushStrBuf(Buf);
1011         }
1012
1013         XML_Parse(xp, "", 0, 1);
1014         XML_ParserFree(xp);
1015         FreeStrBuf(&Buf);
1016         FreeStrBuf(&migr_chardata);
1017         FreeStrBuf(&migr_MsgData);
1018         rebuild_euid_index();
1019         rebuild_usersbynumber();
1020         CC->dont_term = 0;
1021 }
1022
1023
1024
1025 /*
1026  * Dump out the pathnames of directories which can be copied "as is"
1027  */
1028 void migr_do_listdirs(void) {
1029         cprintf("%d Don't forget these:\n", LISTING_FOLLOWS);
1030         cprintf("bio|%s\n",             ctdl_bio_dir);
1031         cprintf("files|%s\n",           ctdl_file_dir);
1032         cprintf("userpics|%s\n",        ctdl_usrpic_dir);
1033         cprintf("messages|%s\n",        ctdl_message_dir);
1034         cprintf("netconfigs|%s\n",      ctdl_netcfg_dir);
1035         cprintf("keys|%s\n",            ctdl_key_dir);
1036         cprintf("images|%s\n",          ctdl_image_dir);
1037         cprintf("info|%s\n",            ctdl_info_dir);
1038         cprintf("000\n");
1039 }
1040
1041
1042 /*
1043  * Common code appears in this section
1044  */
1045
1046
1047 void cmd_migr(char *cmdbuf) {
1048         char cmd[32];
1049         
1050         if (CtdlAccessCheck(ac_internal)) return;
1051         
1052         if (CtdlTrySingleUser())
1053         {
1054                 CtdlMakeTempFileName(migr_tempfilename1, sizeof migr_tempfilename1);
1055                 CtdlMakeTempFileName(migr_tempfilename2, sizeof migr_tempfilename2);
1056
1057                 extract_token(cmd, cmdbuf, 0, '|', sizeof cmd);
1058                 if (!strcasecmp(cmd, "export")) {
1059                         migr_do_export();
1060                 }
1061                 else if (!strcasecmp(cmd, "import")) {
1062                         migr_do_import();
1063                 }
1064                 else if (!strcasecmp(cmd, "listdirs")) {
1065                         migr_do_listdirs();
1066                 }
1067                 else {
1068                         cprintf("%d illegal command\n", ERROR + ILLEGAL_VALUE);
1069                 }
1070
1071                 unlink(migr_tempfilename1);
1072                 unlink(migr_tempfilename2);
1073                 
1074                 CtdlEndSingleUser();
1075         }
1076         else
1077         {
1078                 cprintf("%d The migrator is already running.\n", ERROR + RESOURCE_BUSY);
1079         }
1080 }
1081
1082
1083 CTDL_MODULE_INIT(migrate)
1084 {
1085         if (!threading)
1086         {
1087                 CtdlRegisterProtoHook(cmd_migr, "MIGR", "Across-the-wire migration");
1088         }
1089         
1090         /* return our module name for the log */
1091         return "migrate";
1092 }