Roundcube address groups empty after migration
again i throw my self at the mercy of the infinite wisdom of the community:
I had to run from a bad server co. in the process I transferred all accounts seemingly successfully with few exceptions, one of them being the fact that the address groups in roundcubes address book didnt transfer properly. All the addresses seems to be there AND all the groups are there but they are not "in" their groups.
transfer log reported the following:
I have an account backup file from the old server but attempts to restore on another temporary cpanel server (its been a month) have proven unfruitful (even though the above error did not appear) This all being said, I have a .sql backup file that I found in my system files backup that I made just prior to migration in var/cpanel/roundcube its a few months old but it seems to have an sql for 'contactgroups' - the problem there is that it seems this is a global db AND i have no idea where to put it as there doesnt seem to be a roundcube database in my global phpmyadmin. (my last server had all the databases listed, this one only seems to have account dbs). And yes - before you ask - the old server is dead and buried - the company not worth contacting.. but like i said, I DID make a system_files backup
> exec(/usr/bin/mysqldump,--skip-add-drop-table --complete-insert --quote-names --quick --where contact_id IN (175,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,324,325,326,327,328,329,330,331,332,333,334,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,400,402,405,406,412,413,416,417,418,419,420,421,422,423,424,425,426,430,431,432,433,434,436,437,438,439,440,441,442,443,445,446,448,451,452,453,454,455,456,457,459,460,461,462,463,464,466,467,468,469,470,471,472,474,475,476,479,480,481,482,483,484,486,487,488,489,491,492,495,496,497,500,501,502,504,506,510,512,513,515,516,518,519,521,522,523,524,526,527,528,529,531,532,534,535,538,539,540,543,544,546,547,548,549,550,551,552,553,554,555,556,558,559,560,562,563,565,567,568,570,571,572,576,577,578,579,580,581,583,585,586,587,588,589,590,591,593,594,595,596,597,598,599,602,603,604,605,606,608,612,614,615,616,617,618,619,620,621,626,627,628,629,630,631,632,634,635,636,637,638,639,640,641,642,643,644,645,647,649,650,651,652,653,655,656,657,658,659,660,663,664,665,666,667,668,669,670,671,672,673,675,676,678,679,680,681,682,683,684,685,686,687,688,689,690,691,694,695,696,698,699,700,701,702,703,705,706,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,724,725,726,728,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,747,748,749,750,751,752,753,754,755,756,758,759,760,762,763,764,765,766,767,768,769,770,771,772,773,775,776,777,779,780,781,782,783,784,786,787,788,789,791,792,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,814,815,816,817,818,819,820,823,824,825,826,827,828,829,830,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,889,890,891,892,893,894,895,896,897,898,899,900,901,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,926,927,928,930,931,933,934,935,936,937,938,939,940,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,964,965,966,967,968,969,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1033,1034,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1152,1153,1154,1155,1156,1157,1158,1159,1160,1258,1274,1277,1279,1280,1281,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1328,1329,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1343,1345,1346,1347,1353,1355,1356,1358,1364,1369,1370,1371,1373,1374,1375,1376,1377,1398,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1459,1520,1521,1522,1523,1524,1525,1526,1527,1528,1531,1532,1533,1535,1548,1551,1554,1555,1556,1559,1560,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1604,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1642,1643,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,176,203,219,267,304,323,335,356,399,401,403,404,407,408,409,410,411,414,415,427,428,429,435,444,447,449,450,458,465,473,477,478,485,490,493,494,498,499,503,505,507,508,509,511,514,517,520,525,530,533,536,537,541,542,545,557,561,564,566,569,573,574,575,582,584,592,600,601,607,609,610,611,613,622,623,624,625,633,646,648,654,661,662,674,677,692,693,697,704,707,723,727,729,746,757,761,774,778,785,790,793,794,811,812,813,821,822,831,864,887,888,902,925,929,932,941,963,970,1032,1035,1053,1111,1134,1135,1151,1161,1275,1276,1282,1330,1344,1359,1372,1534,1557,1558,1577,1578,1603,1605) --routines -- roundcube contactgroupmembers) exited with error: The "/usr/bin/mysqldump" command (process 7287) ended prematurely because it received the "SEGV" (11) signal. at /usr/local/cpanel/Cpanel/Pkgacct.pm line 459.
> warn [pkgacct] Failed to dump database roundcube: The subprocess ended prematurely because it received the "SEGV" (11) signal.
> [2018-01-30 07:57:57 -0500] Failed to dump database roundcube: The subprocess ended prematurely because it received the "SEGV" (11) signal.I have an account backup file from the old server but attempts to restore on another temporary cpanel server (its been a month) have proven unfruitful (even though the above error did not appear) This all being said, I have a .sql backup file that I found in my system files backup that I made just prior to migration in var/cpanel/roundcube its a few months old but it seems to have an sql for 'contactgroups' - the problem there is that it seems this is a global db AND i have no idea where to put it as there doesnt seem to be a roundcube database in my global phpmyadmin. (my last server had all the databases listed, this one only seems to have account dbs). And yes - before you ask - the old server is dead and buried - the company not worth contacting.. but like i said, I DID make a system_files backup
-
This all being said, I have a .sql backup file that I found in my system files backup that I made just prior to migration in var/cpanel/roundcube its a few months old but it seems to have an sql for 'contactgroups' - the problem there is that it seems this is a global db AND i have no idea where to put it as there doesnt seem to be a roundcube database in my global phpmyadmin. (my last server had all the databases listed, this one only seems to have account dbs).
Hello, We now use SQLite for Roundcube storage for each account. Here's a document that may help you recover some of the data if you have a copy of the old Roundcube MySQL database from the previous server: How to Convert Roundcube to SQLite - cPanel Knowledge Base - cPanel Documentation Thank you.0 -
Interesting cPanelMichael - is the user the cpanel user or is it something special for roundcube? 0 -
New Interesting cPanelMichael - is the user the cpanel user or is it something special for roundcube?
It's referring to the cPanel username of the account. Thank you.0
Please sign in to leave a comment.
Comments
3 comments