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