2 * This module dumps and/or loads the Citadel database in XML format.
4 * Copyright (c) 1987-2012 by the citadel.org team
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.
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.
23 #include <sys/types.h>
25 #if TIME_WITH_SYS_TIME
26 # include <sys/time.h>
30 # include <sys/time.h>
41 #include <libcitadel.h>
44 #include "citserver.h"
51 #include "euidindex.h"
52 #include "ctdl_module.h"
54 #define END_OF_MESSAGE "---eom---dbd---"
56 char migr_tempfilename1[PATH_MAX];
57 char migr_tempfilename2[PATH_MAX];
58 FILE *migr_global_message_list;
62 * Code which implements the export appears in this section
66 * Output a string to the client with these characters escaped: & < >
68 void xml_strout(char *str) {
74 client_write(""", 6);
76 else if (*c == '\'') {
77 client_write("'", 6);
80 client_write("<", 4);
83 client_write(">", 4);
86 client_write("&", 5);
97 * Export a user record as XML
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);
116 void migr_export_users(void) {
117 ForEachUser(migr_export_users_backend, NULL);
121 void migr_export_room_msg(long msgnum, void *userdata) {
122 cprintf("%ld\n", msgnum);
123 fprintf(migr_global_message_list, "%ld\n", msgnum);
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);
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);
151 /* message list goes inside this tag */
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);
165 void migr_export_rooms(void) {
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);
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.)
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);
186 void migr_export_floors(void) {
187 struct floor qfbuf, *buf;
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);
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);
206 * Return nonzero if the supplied string contains only characters which are valid in a sequence set.
208 int is_sequence_set(char *s) {
213 while (ch = *c++, ch) {
214 if (!strchr("0123456789*,:", ch)) {
224 * Traverse the visits file...
226 void migr_export_visits(void) {
228 struct cdbdata *cdbv;
230 cdb_rewind(CDB_VISIT);
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));
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);
244 client_write("<v_seen>", 8);
245 if ( (!IsEmptyStr(vbuf.v_seen)) && (is_sequence_set(vbuf.v_seen)) ) {
246 xml_strout(vbuf.v_seen);
249 cprintf("%ld", vbuf.v_lastseen);
251 client_write("</v_seen>", 9);
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);
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);
266 void migr_export_message(long msgnum) {
268 struct CtdlMessage *msg;
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.
276 static int encoded_alloc = 0;
277 static char *encoded_msg = NULL;
280 if ((encoded_alloc == 0) && (encoded_msg != NULL)) {
288 /* Ok, here we go ... */
290 msg = CtdlFetchMessage(msgnum, 1);
291 if (msg == NULL) return; /* fail silently */
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);
299 client_write("<msg_text>", 10);
300 CtdlSerializeMessage(&smr, msg);
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);
310 if (encoded_msg == NULL) {
311 /* Questionable hack that hopes it'll work next time and we only lose one message */
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);
322 client_write("</msg_text>\n", 12);
323 client_write("</message>\n", 11);
328 void migr_export_openids(void) {
329 struct cdbdata *cdboi;
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);
341 client_write("</oid_url>\n", 11);
342 cprintf("<oid_usernum>%ld</oid_usernum>\n", usernum);
343 client_write("</openid>\n", 10);
352 void migr_export_messages(void) {
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)) {
366 migr_export_message(msgnum);
370 fclose(migr_global_message_list);
372 if (Ctx->kill_me == 0)
373 syslog(LOG_INFO, "Exported %d messages.\n", count);
375 syslog(LOG_ERR, "Export aborted due to client disconnect! \n");
377 migr_export_message(-1L); /* This frees the encoding buffer */
382 void migr_do_export(void) {
386 cprintf("%d Exporting all Citadel databases.\n", LISTING_FOLLOWS);
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);
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 client_write("</config>\n", 10);
469 /* Export the control file */
471 client_write("<control>\n", 10);
472 cprintf("<control_highest>%ld</control_highest>\n", CitControl.MMhighest);
473 cprintf("<control_flags>%u</control_flags>\n", CitControl.MMflags);
474 cprintf("<control_nextuser>%ld</control_nextuser>\n", CitControl.MMnextuser);
475 cprintf("<control_nextroom>%ld</control_nextroom>\n", CitControl.MMnextroom);
476 cprintf("<control_version>%d</control_version>\n", CitControl.version);
477 client_write("</control>\n", 11);
479 if (Ctx->kill_me == 0) migr_export_users();
480 if (Ctx->kill_me == 0) migr_export_openids();
481 if (Ctx->kill_me == 0) migr_export_rooms();
482 if (Ctx->kill_me == 0) migr_export_floors();
483 if (Ctx->kill_me == 0) migr_export_visits();
484 if (Ctx->kill_me == 0) migr_export_messages();
485 client_write("</citadel_migrate_data>\n", 24);
486 client_write("000\n", 4);
495 * Here's the code that implements the import side. It's going to end up being
496 * one big loop with lots of global variables. I don't care. You wouldn't run
497 * multiple concurrent imports anyway. If this offends your delicate sensibilities
498 * then go rewrite it in Ruby on Rails or something.
502 int citadel_migrate_data = 0; /* Are we inside a <citadel_migrate_data> tag pair? */
503 StrBuf *migr_chardata = NULL;
504 StrBuf *migr_MsgData = NULL;
505 struct ctdluser usbuf;
506 struct ctdlroom qrbuf;
507 char openid_url[512];
508 long openid_usernum = 0;
509 char FRname[ROOMNAMELEN];
514 long import_msgnum = 0;
517 * This callback stores up the data which appears in between tags.
519 void migr_xml_chardata(void *data, const XML_Char *s, int len)
521 StrBufAppendBufPlain(migr_chardata, s, len, 0);
525 void migr_xml_start(void *data, const char *el, const char **attr) {
528 /*** GENERAL STUFF ***/
530 /* Reset chardata_len to zero and init buffer */
531 FlushStrBuf(migr_chardata);
532 FlushStrBuf(migr_MsgData);
534 if (!strcasecmp(el, "citadel_migrate_data")) {
535 ++citadel_migrate_data;
537 /* As soon as it looks like the input data is a genuine Citadel XML export,
538 * whack the existing database on disk to make room for the new one.
540 if (citadel_migrate_data == 1) {
541 for (i = 0; i < MAXCDB; ++i) {
548 if (citadel_migrate_data != 1) {
549 syslog(LOG_ALERT, "Out-of-sequence tag <%s> detected. Warning: ODD-DATA!\n", el);
553 /* When we begin receiving XML for one of these record types, clear out the associated
554 * buffer so we don't accidentally carry over any data from a previous record.
556 if (!strcasecmp(el, "user")) memset(&usbuf, 0, sizeof (struct ctdluser));
557 else if (!strcasecmp(el, "openid")) memset(openid_url, 0, sizeof openid_url);
558 else if (!strcasecmp(el, "room")) memset(&qrbuf, 0, sizeof (struct ctdlroom));
559 else if (!strcasecmp(el, "room_messages")) memset(FRname, 0, sizeof FRname);
560 else if (!strcasecmp(el, "floor")) memset(&flbuf, 0, sizeof (struct floor));
561 else if (!strcasecmp(el, "visit")) memset(&vbuf, 0, sizeof (visit));
563 else if (!strcasecmp(el, "message")) {
564 memset(&smi, 0, sizeof (struct MetaData));
571 int migr_config(void *data, const char *el)
573 if (!strcasecmp(el, "c_nodename")) SET_CFGSTRBUF(c_nodename, migr_chardata);
574 else if (!strcasecmp(el, "c_fqdn")) SET_CFGSTRBUF(c_fqdn, migr_chardata);
575 else if (!strcasecmp(el, "c_humannode")) SET_CFGSTRBUF(c_humannode, migr_chardata);
576 else if (!strcasecmp(el, "c_phonenum")) SET_CFGSTRBUF(c_phonenum, migr_chardata);
577 else if (!strcasecmp(el, "c_ctdluid")) config.c_ctdluid = atoi(ChrPtr(migr_chardata));
578 else if (!strcasecmp(el, "c_creataide")) config.c_creataide = atoi(ChrPtr(migr_chardata));
579 else if (!strcasecmp(el, "c_sleeping")) config.c_sleeping = atoi(ChrPtr(migr_chardata));
580 else if (!strcasecmp(el, "c_initax")) config.c_initax = atoi(ChrPtr(migr_chardata));
581 else if (!strcasecmp(el, "c_regiscall")) config.c_regiscall = atoi(ChrPtr(migr_chardata));
582 else if (!strcasecmp(el, "c_twitdetect")) config.c_twitdetect = atoi(ChrPtr(migr_chardata));
583 else if (!strcasecmp(el, "c_twitroom")) SET_CFGSTRBUF(c_twitroom, migr_chardata);
584 else if (!strcasecmp(el, "c_moreprompt")) SET_CFGSTRBUF(c_moreprompt, migr_chardata);
585 else if (!strcasecmp(el, "c_restrict")) config.c_restrict = atoi(ChrPtr(migr_chardata));
586 else if (!strcasecmp(el, "c_site_location")) SET_CFGSTRBUF(c_site_location, migr_chardata);
587 else if (!strcasecmp(el, "c_sysadm")) SET_CFGSTRBUF(c_sysadm, migr_chardata);
588 else if (!strcasecmp(el, "c_maxsessions")) config.c_maxsessions = atoi(ChrPtr(migr_chardata));
589 else if (!strcasecmp(el, "c_ip_addr")) SET_CFGSTRBUF(c_ip_addr, migr_chardata);
590 else if (!strcasecmp(el, "c_port_number")) config.c_port_number = atoi(ChrPtr(migr_chardata));
591 else if (!strcasecmp(el, "c_ep_expire_mode")) config.c_ep.expire_mode = atoi(ChrPtr(migr_chardata));
592 else if (!strcasecmp(el, "c_ep_expire_value")) config.c_ep.expire_value = atoi(ChrPtr(migr_chardata));
593 else if (!strcasecmp(el, "c_userpurge")) config.c_userpurge = atoi(ChrPtr(migr_chardata));
594 else if (!strcasecmp(el, "c_roompurge")) config.c_roompurge = atoi(ChrPtr(migr_chardata));
595 else if (!strcasecmp(el, "c_logpages")) SET_CFGSTRBUF(c_logpages, migr_chardata);
596 else if (!strcasecmp(el, "c_createax")) config.c_createax = atoi(ChrPtr(migr_chardata));
597 else if (!strcasecmp(el, "c_maxmsglen")) config.c_maxmsglen = atol(ChrPtr(migr_chardata));
598 else if (!strcasecmp(el, "c_min_workers")) config.c_min_workers = atoi(ChrPtr(migr_chardata));
599 else if (!strcasecmp(el, "c_max_workers")) config.c_max_workers = atoi(ChrPtr(migr_chardata));
600 else if (!strcasecmp(el, "c_pop3_port")) config.c_pop3_port = atoi(ChrPtr(migr_chardata));
601 else if (!strcasecmp(el, "c_smtp_port")) config.c_smtp_port = atoi(ChrPtr(migr_chardata));
602 else if (!strcasecmp(el, "c_rfc822_strict_from")) config.c_rfc822_strict_from = atoi(ChrPtr(migr_chardata));
603 else if (!strcasecmp(el, "c_aide_zap")) config.c_aide_zap = atoi(ChrPtr(migr_chardata));
604 else if (!strcasecmp(el, "c_imap_port")) config.c_imap_port = atoi(ChrPtr(migr_chardata));
605 else if (!strcasecmp(el, "c_net_freq")) config.c_net_freq = atol(ChrPtr(migr_chardata));
606 else if (!strcasecmp(el, "c_disable_newu")) config.c_disable_newu = atoi(ChrPtr(migr_chardata));
607 else if (!strcasecmp(el, "c_enable_fulltext")) config.c_enable_fulltext = atoi(ChrPtr(migr_chardata));
608 else if (!strcasecmp(el, "c_baseroom")) SET_CFGSTRBUF(c_baseroom, migr_chardata);
609 else if (!strcasecmp(el, "c_aideroom")) SET_CFGSTRBUF(c_aideroom, migr_chardata);
610 else if (!strcasecmp(el, "c_purge_hour")) config.c_purge_hour = atoi(ChrPtr(migr_chardata));
611 else if (!strcasecmp(el, "c_mbxep_expire_mode")) config.c_mbxep.expire_mode = atoi(ChrPtr(migr_chardata));
612 else if (!strcasecmp(el, "c_mbxep_expire_value")) config.c_mbxep.expire_value = atoi(ChrPtr(migr_chardata));
613 else if (!strcasecmp(el, "c_ldap_host")) SET_CFGSTRBUF(c_ldap_host, migr_chardata);
614 else if (!strcasecmp(el, "c_ldap_port")) config.c_ldap_port = atoi(ChrPtr(migr_chardata));
615 else if (!strcasecmp(el, "c_ldap_base_dn")) SET_CFGSTRBUF(c_ldap_base_dn, migr_chardata);
616 else if (!strcasecmp(el, "c_ldap_bind_dn")) SET_CFGSTRBUF(c_ldap_bind_dn, migr_chardata);
617 else if (!strcasecmp(el, "c_ldap_bind_pw")) SET_CFGSTRBUF(c_ldap_bind_pw, migr_chardata);
618 else if (!strcasecmp(el, "c_msa_port")) config.c_msa_port = atoi(ChrPtr(migr_chardata));
619 else if (!strcasecmp(el, "c_imaps_port")) config.c_imaps_port = atoi(ChrPtr(migr_chardata));
620 else if (!strcasecmp(el, "c_pop3s_port")) config.c_pop3s_port = atoi(ChrPtr(migr_chardata));
621 else if (!strcasecmp(el, "c_smtps_port")) config.c_smtps_port = atoi(ChrPtr(migr_chardata));
622 else if (!strcasecmp(el, "c_auto_cull")) config.c_auto_cull = atoi(ChrPtr(migr_chardata));
623 else if (!strcasecmp(el, "c_allow_spoofing")) config.c_allow_spoofing = atoi(ChrPtr(migr_chardata));
624 else if (!strcasecmp(el, "c_journal_email")) config.c_journal_email = atoi(ChrPtr(migr_chardata));
625 else if (!strcasecmp(el, "c_journal_pubmsgs")) config.c_journal_pubmsgs = atoi(ChrPtr(migr_chardata));
626 else if (!strcasecmp(el, "c_journal_dest")) SET_CFGSTRBUF(c_journal_dest, migr_chardata);
627 else if (!strcasecmp(el, "c_default_cal_zone")) SET_CFGSTRBUF(c_default_cal_zone, migr_chardata);
628 else if (!strcasecmp(el, "c_pftcpdict_port")) config.c_pftcpdict_port = atoi(ChrPtr(migr_chardata));
629 else if (!strcasecmp(el, "c_managesieve_port")) config.c_managesieve_port = atoi(ChrPtr(migr_chardata));
630 else if (!strcasecmp(el, "c_auth_mode")) config.c_auth_mode = atoi(ChrPtr(migr_chardata));
631 else if (!strcasecmp(el, "c_funambol_host")) SET_CFGSTRBUF(c_funambol_host, migr_chardata);
632 else if (!strcasecmp(el, "c_funambol_port")) config.c_funambol_port = atoi(ChrPtr(migr_chardata));
633 else if (!strcasecmp(el, "c_funambol_source")) SET_CFGSTRBUF(c_funambol_source, migr_chardata);
634 else if (!strcasecmp(el, "c_funambol_auth")) SET_CFGSTRBUF(c_funambol_auth, migr_chardata);
635 else if (!strcasecmp(el, "c_rbl_at_greeting")) config.c_rbl_at_greeting = atoi(ChrPtr(migr_chardata));
636 else if (!strcasecmp(el, "c_master_user")) SET_CFGSTRBUF(c_master_user, migr_chardata);
637 else if (!strcasecmp(el, "c_master_pass")) SET_CFGSTRBUF(c_master_pass, migr_chardata);
638 else if (!strcasecmp(el, "c_pager_program")) SET_CFGSTRBUF(c_pager_program, migr_chardata);
639 else if (!strcasecmp(el, "c_imap_keep_from")) config.c_imap_keep_from = atoi(ChrPtr(migr_chardata));
640 else if (!strcasecmp(el, "c_xmpp_c2s_port")) config.c_xmpp_c2s_port = atoi(ChrPtr(migr_chardata));
641 else if (!strcasecmp(el, "c_xmpp_s2s_port")) config.c_xmpp_s2s_port = atoi(ChrPtr(migr_chardata));
642 else if (!strcasecmp(el, "c_pop3_fetch")) config.c_pop3_fetch = atol(ChrPtr(migr_chardata));
643 else if (!strcasecmp(el, "c_pop3_fastest")) config.c_pop3_fastest = atol(ChrPtr(migr_chardata));
644 else if (!strcasecmp(el, "c_spam_flag_only")) config.c_spam_flag_only = atoi(ChrPtr(migr_chardata));
646 return 1; /* Found above...*/
649 int migr_controlrecord(void *data, const char *el)
651 if (!strcasecmp(el, "control_highest")) CitControl.MMhighest = atol(ChrPtr(migr_chardata));
652 else if (!strcasecmp(el, "control_flags")) CitControl.MMflags = atoi(ChrPtr(migr_chardata));
653 else if (!strcasecmp(el, "control_nextuser")) CitControl.MMnextuser = atol(ChrPtr(migr_chardata));
654 else if (!strcasecmp(el, "control_nextroom")) CitControl.MMnextroom = atol(ChrPtr(migr_chardata));
655 else if (!strcasecmp(el, "control_version")) CitControl.version = atoi(ChrPtr(migr_chardata));
657 else if (!strcasecmp(el, "control")) {
658 CitControl.MMfulltext = (-1L); /* always flush */
660 syslog(LOG_INFO, "Completed import of control record\n");
668 int migr_userrecord(void *data, const char *el)
670 if (!strcasecmp(el, "u_version")) usbuf.version = atoi(ChrPtr(migr_chardata));
671 else if (!strcasecmp(el, "u_uid")) usbuf.uid = atol(ChrPtr(migr_chardata));
672 else if (!strcasecmp(el, "u_password")) safestrncpy(usbuf.password, ChrPtr(migr_chardata), sizeof usbuf.password);
673 else if (!strcasecmp(el, "u_flags")) usbuf.flags = atoi(ChrPtr(migr_chardata));
674 else if (!strcasecmp(el, "u_timescalled")) usbuf.timescalled = atol(ChrPtr(migr_chardata));
675 else if (!strcasecmp(el, "u_posted")) usbuf.posted = atol(ChrPtr(migr_chardata));
676 else if (!strcasecmp(el, "u_axlevel")) usbuf.axlevel = atoi(ChrPtr(migr_chardata));
677 else if (!strcasecmp(el, "u_usernum")) usbuf.usernum = atol(ChrPtr(migr_chardata));
678 else if (!strcasecmp(el, "u_lastcall")) usbuf.lastcall = atol(ChrPtr(migr_chardata));
679 else if (!strcasecmp(el, "u_USuserpurge")) usbuf.USuserpurge = atoi(ChrPtr(migr_chardata));
680 else if (!strcasecmp(el, "u_fullname")) safestrncpy(usbuf.fullname, ChrPtr(migr_chardata), sizeof usbuf.fullname);
685 int migr_roomrecord(void *data, const char *el)
687 if (!strcasecmp(el, "QRname")) safestrncpy(qrbuf.QRname, ChrPtr(migr_chardata), sizeof qrbuf.QRname);
688 else if (!strcasecmp(el, "QRpasswd")) safestrncpy(qrbuf.QRpasswd, ChrPtr(migr_chardata), sizeof qrbuf.QRpasswd);
689 else if (!strcasecmp(el, "QRroomaide")) qrbuf.QRroomaide = atol(ChrPtr(migr_chardata));
690 else if (!strcasecmp(el, "QRhighest")) qrbuf.QRhighest = atol(ChrPtr(migr_chardata));
691 else if (!strcasecmp(el, "QRgen")) qrbuf.QRgen = atol(ChrPtr(migr_chardata));
692 else if (!strcasecmp(el, "QRflags")) qrbuf.QRflags = atoi(ChrPtr(migr_chardata));
693 else if (!strcasecmp(el, "QRdirname")) safestrncpy(qrbuf.QRdirname, ChrPtr(migr_chardata), sizeof qrbuf.QRdirname);
694 else if (!strcasecmp(el, "QRinfo")) qrbuf.QRinfo = atol(ChrPtr(migr_chardata));
695 else if (!strcasecmp(el, "QRfloor")) qrbuf.QRfloor = atoi(ChrPtr(migr_chardata));
696 else if (!strcasecmp(el, "QRmtime")) qrbuf.QRmtime = atol(ChrPtr(migr_chardata));
697 else if (!strcasecmp(el, "QRexpire_mode")) qrbuf.QRep.expire_mode = atoi(ChrPtr(migr_chardata));
698 else if (!strcasecmp(el, "QRexpire_value")) qrbuf.QRep.expire_value = atoi(ChrPtr(migr_chardata));
699 else if (!strcasecmp(el, "QRnumber")) qrbuf.QRnumber = atol(ChrPtr(migr_chardata));
700 else if (!strcasecmp(el, "QRorder")) qrbuf.QRorder = atoi(ChrPtr(migr_chardata));
701 else if (!strcasecmp(el, "QRflags2")) qrbuf.QRflags2 = atoi(ChrPtr(migr_chardata));
702 else if (!strcasecmp(el, "QRdefaultview")) qrbuf.QRdefaultview = atoi(ChrPtr(migr_chardata));
707 int migr_floorrecord(void *data, const char *el)
709 if (!strcasecmp(el, "f_num")) floornum = atoi(ChrPtr(migr_chardata));
710 else if (!strcasecmp(el, "f_flags")) flbuf.f_flags = atoi(ChrPtr(migr_chardata));
711 else if (!strcasecmp(el, "f_name")) safestrncpy(flbuf.f_name, ChrPtr(migr_chardata), sizeof flbuf.f_name);
712 else if (!strcasecmp(el, "f_ref_count")) flbuf.f_ref_count = atoi(ChrPtr(migr_chardata));
713 else if (!strcasecmp(el, "f_ep_expire_mode")) flbuf.f_ep.expire_mode = atoi(ChrPtr(migr_chardata));
714 else if (!strcasecmp(el, "f_ep_expire_value")) flbuf.f_ep.expire_value = atoi(ChrPtr(migr_chardata));
719 int migr_visitrecord(void *data, const char *el)
721 if (!strcasecmp(el, "v_roomnum")) vbuf.v_roomnum = atol(ChrPtr(migr_chardata));
722 else if (!strcasecmp(el, "v_roomgen")) vbuf.v_roomgen = atol(ChrPtr(migr_chardata));
723 else if (!strcasecmp(el, "v_usernum")) vbuf.v_usernum = atol(ChrPtr(migr_chardata));
725 else if (!strcasecmp(el, "v_seen")) {
726 int is_textual_seen = 0;
728 int max = StrLength(migr_chardata);
730 vbuf.v_lastseen = atol(ChrPtr(migr_chardata));
732 for (i=0; i < max; ++i)
733 if (!isdigit(ChrPtr(migr_chardata)[i]))
736 safestrncpy(vbuf.v_seen, ChrPtr(migr_chardata), sizeof vbuf.v_seen);
739 else if (!strcasecmp(el, "v_answered")) safestrncpy(vbuf.v_answered, ChrPtr(migr_chardata), sizeof vbuf.v_answered);
740 else if (!strcasecmp(el, "v_flags")) vbuf.v_flags = atoi(ChrPtr(migr_chardata));
741 else if (!strcasecmp(el, "v_view")) vbuf.v_view = atoi(ChrPtr(migr_chardata));
745 void migr_xml_end(void *data, const char *el)
750 long *msglist = NULL;
751 int msglist_alloc = 0;
752 /*** GENERAL STUFF ***/
754 if (!strcasecmp(el, "citadel_migrate_data")) {
755 --citadel_migrate_data;
759 if (citadel_migrate_data != 1) {
760 syslog(LOG_ALERT, "Out-of-sequence tag <%s> detected. Warning: ODD-DATA!\n", el);
764 // syslog(LOG_DEBUG, "END TAG: <%s> DATA: <%s>\n", el, (migr_chardata_len ? migr_chardata : ""));
768 if (!strcasecmp(el, "config")) {
769 config.c_enable_fulltext = 0; /* always disable */
771 syslog(LOG_INFO, "Completed import of server configuration\n");
774 else if ((!strncasecmp(el, HKEY("c_"))) &&
775 migr_config(data, el))
776 ; /* Nothing to do anymore */
779 else if ((!strncasecmp(el, HKEY("control"))) &&
780 migr_controlrecord(data, el))
781 ; /* Nothing to do anymore */
783 else if ((!strncasecmp(el, HKEY("u_"))) &&
784 migr_userrecord(data, el))
785 ; /* Nothing to do anymore */
786 else if (!strcasecmp(el, "user")) {
788 syslog(LOG_INFO, "Imported user: %s\n", usbuf.fullname);
793 else if (!strcasecmp(el, "oid_url")) safestrncpy(openid_url, ChrPtr(migr_chardata), sizeof openid_url);
794 else if (!strcasecmp(el, "oid_usernum")) openid_usernum = atol(ChrPtr(migr_chardata));
796 else if (!strcasecmp(el, "openid")) { /* see serv_openid_rp.c for a description of the record format */
799 oid_data_len = sizeof(long) + strlen(openid_url) + 1;
800 oid_data = malloc(oid_data_len);
801 memcpy(oid_data, &openid_usernum, sizeof(long));
802 memcpy(&oid_data[sizeof(long)], openid_url, strlen(openid_url) + 1);
803 cdb_store(CDB_OPENID, openid_url, strlen(openid_url), oid_data, oid_data_len);
805 syslog(LOG_INFO, "Imported OpenID: %s (%ld)\n", openid_url, openid_usernum);
809 else if ((!strncasecmp(el, HKEY("QR"))) &&
810 migr_roomrecord(data, el))
811 ; /* Nothing to do anymore */
812 else if (!strcasecmp(el, "room")) {
814 syslog(LOG_INFO, "Imported room: %s\n", qrbuf.QRname);
817 /*** ROOM MESSAGE POINTERS ***/
819 else if (!strcasecmp(el, "FRname")) safestrncpy(FRname, ChrPtr(migr_chardata), sizeof FRname);
821 else if (!strcasecmp(el, "FRmsglist")) {
822 if (!IsEmptyStr(FRname)) {
824 msglist_alloc = 1000;
825 msglist = malloc(sizeof(long) * msglist_alloc);
827 syslog(LOG_DEBUG, "Message list for: %s\n", FRname);
829 ptr = ChrPtr(migr_chardata);
831 while ((*ptr != 0) && (!isdigit(*ptr))) {
834 if ((*ptr != 0) && (isdigit(*ptr))) {
837 if (msgcount >= msglist_alloc) {
839 msglist = realloc(msglist, sizeof(long) * msglist_alloc);
841 msglist[msgcount++] = msgnum;
844 while ((*ptr != 0) && (isdigit(*ptr))) {
850 CtdlSaveMsgPointersInRoom(FRname, msglist, msgcount, 0, NULL, 1);
855 syslog(LOG_DEBUG, "Imported %d messages.\n", msgcount);
856 if (server_shutting_down) {
862 else if ((!strncasecmp(el, HKEY("f_"))) &&
863 migr_floorrecord(data, el))
864 ; /* Nothing to do anymore */
866 else if (!strcasecmp(el, "floor")) {
867 CtdlPutFloor(&flbuf, floornum);
868 syslog(LOG_INFO, "Imported floor #%d (%s)\n", floornum, flbuf.f_name);
872 else if ((!strncasecmp(el, HKEY("v_"))) &&
873 migr_visitrecord(data, el))
874 ; /* Nothing to do anymore */
875 else if (!strcasecmp(el, "visit")) {
877 syslog(LOG_INFO, "Imported visit: %ld/%ld/%ld\n", vbuf.v_roomnum, vbuf.v_roomgen, vbuf.v_usernum);
882 else if (!strcasecmp(el, "msg_msgnum")) import_msgnum = atol(ChrPtr(migr_chardata));
883 else if (!strcasecmp(el, "msg_meta_refcount")) smi.meta_refcount = atoi(ChrPtr(migr_chardata));
884 else if (!strcasecmp(el, "msg_meta_content_type")) safestrncpy(smi.meta_content_type, ChrPtr(migr_chardata), sizeof smi.meta_content_type);
886 else if (!strcasecmp(el, "msg_text"))
889 FlushStrBuf(migr_MsgData);
890 StrBufDecodeBase64To(migr_MsgData, migr_MsgData);
892 cdb_store(CDB_MSGMAIN,
895 ChrPtr(migr_MsgData),
896 StrLength(migr_MsgData) + 1);
898 smi.meta_msgnum = import_msgnum;
902 "Imported message #%ld, size=%d, refcount=%d, content-type: %s\n",
904 StrLength(migr_MsgData),
906 smi.meta_content_type);
909 /*** MORE GENERAL STUFF ***/
911 FlushStrBuf(migr_chardata);
920 void migr_do_import(void) {
926 migr_chardata = NewStrBufPlain(NULL, SIZ * 20);
927 migr_MsgData = NewStrBufPlain(NULL, SIZ * 20);
928 Buf = NewStrBufPlain(NULL, SIZ);
929 xp = XML_ParserCreate(NULL);
931 cprintf("%d Failed to create XML parser instance\n", ERROR+INTERNAL_ERROR);
934 XML_SetElementHandler(xp, migr_xml_start, migr_xml_end);
935 XML_SetCharacterDataHandler(xp, migr_xml_chardata);
939 cprintf("%d sock it to me\n", SEND_LISTING);
942 client_set_inbound_buf(SIZ * 10);
944 while (!Finished && client_read_random_blob(Buf, -1) >= 0) {
945 if ((StrLength(Buf) > 4) &&
946 !strcmp(ChrPtr(Buf) + StrLength(Buf) - 4, "000\n"))
949 StrBufCutAt(Buf, StrLength(Buf) - 4, NULL);
951 if (server_shutting_down)
952 break; // Should we break or return?
954 if (StrLength(Buf) == 0)
957 XML_Parse(xp, ChrPtr(Buf), StrLength(Buf), 0);
961 XML_Parse(xp, "", 0, 1);
964 FreeStrBuf(&migr_chardata);
965 FreeStrBuf(&migr_MsgData);
966 rebuild_euid_index();
967 rebuild_usersbynumber();
974 * Dump out the pathnames of directories which can be copied "as is"
976 void migr_do_listdirs(void) {
977 cprintf("%d Don't forget these:\n", LISTING_FOLLOWS);
978 cprintf("bio|%s\n", ctdl_bio_dir);
979 cprintf("files|%s\n", ctdl_file_dir);
980 cprintf("userpics|%s\n", ctdl_usrpic_dir);
981 cprintf("messages|%s\n", ctdl_message_dir);
982 cprintf("netconfigs|%s\n", ctdl_netcfg_dir);
983 cprintf("keys|%s\n", ctdl_key_dir);
984 cprintf("images|%s\n", ctdl_image_dir);
985 cprintf("info|%s\n", ctdl_info_dir);
991 * Common code appears in this section
995 void cmd_migr(char *cmdbuf) {
998 if (CtdlAccessCheck(ac_internal)) return;
1000 if (CtdlTrySingleUser())
1002 CtdlMakeTempFileName(migr_tempfilename1, sizeof migr_tempfilename1);
1003 CtdlMakeTempFileName(migr_tempfilename2, sizeof migr_tempfilename2);
1005 extract_token(cmd, cmdbuf, 0, '|', sizeof cmd);
1006 if (!strcasecmp(cmd, "export")) {
1009 else if (!strcasecmp(cmd, "import")) {
1012 else if (!strcasecmp(cmd, "listdirs")) {
1016 cprintf("%d illegal command\n", ERROR + ILLEGAL_VALUE);
1019 unlink(migr_tempfilename1);
1020 unlink(migr_tempfilename2);
1022 CtdlEndSingleUser();
1026 cprintf("%d The migrator is already running.\n", ERROR + RESOURCE_BUSY);
1031 CTDL_MODULE_INIT(migrate)
1035 CtdlRegisterProtoHook(cmd_migr, "MIGR", "Across-the-wire migration");
1036 CtdlRegisterProtoHook(cmd_migr, "ARTV", "Across-the-wire migration (legacy syntax)");
1039 /* return our module name for the log */