Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Roundcube address groups empty after migration

Discussion in 'E-mail Discussions' started by nosajix, Mar 15, 2018.

Tags:
  1. nosajix

    nosajix Active Member

    Joined:
    Jul 30, 2005
    Messages:
    30
    Likes Received:
    1
    Trophy Points:
    158
    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:
    Code:
    > 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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,782
    Likes Received:
    1,712
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  3. nosajix

    nosajix Active Member

    Joined:
    Jul 30, 2005
    Messages:
    30
    Likes Received:
    1
    Trophy Points:
    158
    Interesting cPanelMichael - is the user the cpanel user or is it something special for roundcube?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,782
    Likes Received:
    1,712
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    It's referring to the cPanel username of the account.

    Thank you.
     
Loading...

Share This Page