/dev-club/b/dev-blog/posts/developing-using-docker---office-hours-recapOn Dec 6th, we held our monthly office hours session on doing local Sugar development using Docker containers. A sort of continuation from our session last month on using Demo Builder for development . Our own Rafael Fernandes was the exper...en-USTelligent Community 12https://sugarclub.sugarai.com/dev-club/b/dev-blog/posts/developing-using-docker---office-hours-recapFri, 23 Feb 2024 17:08:29 GMT5c521d64-519d-47a6-9065-134618b211bf:262a5c87-4fe4-46f8-8758-168b27af8d36Sanchez Jorge Luis3<p>Hi guys.</p> <p>Dear [mention:1ec9289a19b7489188e562f4d7c7d4ac:e9ed411860ed4f2ba0265705b8793d05]&nbsp;I run the SugarDockerizer project on Arch Linux. I have had some problems with the script to restore oncloud backups. When I try to move the database to the mysql container, it always tells me that the database is corrupt.</p> <p>I believe these are the lines in the restorefromfile script that are causing the problem.</p> <p>[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:af0ae472-7678-44c9-8f85-13d0ddc5f0ee:type=markdown&text=%20%20%20%20%20%20%20%20%20%20%20%20if%20%5B%20-d%20%24TEMP_FOLDER%2Fsql%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20then%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20find%20%24TEMP_FOLDER%2Fsql%20-type%20f%20-name%20%27sugar%2A%27%20%21%20-name%20%27%2Atriggers%2A%27%20-exec%20sh%20-c%20%27sql%3D%24%7B1%3A-%3A%7D%3B%20x%3D%22%24%7B2%3A-%3A%7D%22%3B%20mv%20%22%24x%22%20%22%24sql%2Fsugar.sql%22%27%20bash%20%22%24TEMP_FOLDER%2Fsql%22%20%7B%7D%20%2B%5C%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20find%20%24TEMP_FOLDER%2Fsql%20-type%20f%20-name%20%27%2Atriggers%2A%27%20-exec%20sh%20-c%20%27sql%3D%24%7B1%3A-%3A%7D%3B%20x%3D%22%7B%7D%22%3B%20mv%20%22%24%7B2%3A-%3A%7D%22%20%22%24sql%2Fsugar_triggers.sql%22%27%20bash%20%22%24TEMP_FOLDER%2Fsql%22%20%7B%7D%20%2B%5C%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20fi]</p> <p>Because it is expected that they will create a sugar.sql file, but in the end the one that comes with the tar.gz file is left.</p> <p></p> <p>The other problem is when I want to make a backup, the backup script tells me that the config.php file does not have a db_name, and I have already seen that this is the case because it is written in the config_override.php file.</p> <p>[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:4a85cb7d-874e-418e-af28-25c2360f67ed:type=bat&text=cat%20.%2Futilities%2Fconfigs%2Fconfig_override_dockerized.php%20%3E%3E%20.%2Fdata%2Fapp%2Fsugar%2Fconfig_override.php]</p> <p>The backup script expects the following and does not find it in the config.php file.</p> <p>[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:a21b65dc-1465-4289-9c88-bc69de9a8a37:type=bat&text=%23%20checking%20db%20name%20if%20it%20is%20indeed%20sugar%0A%20%20%20%20%20%20%20%20%20%20%20%20DB_NAME%3D%60cat%20data%2Fapp%2Fsugar%2Fconfig.php%20%7C%20grep%20db_name%20%7C%20awk%20%27%7Bprint%20%243%7D%27%20%7C%20sed%20%27s%2F%5B%5E%5B%3Aalnum%3A%5D%5D%2F%2Fg%27%60]</p> <p></p> <p>I&#39;m thinking of an improvement, which is that when restoring an oncloud backup, the database is sometimes very large due to data in tables that are not very important when inspecting a problem. Therefore, I suggest that a sed implementation be made to reduce the volume of data that we do not need when inspecting instances. It is something like this:</p> <p>[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:e63fa423-a899-4e5b-88c9-7b6252ac27f3:type=bat&text=sed%20-i.bak%20%27%2F%5E%5C%28INSERT%20INTO%5C%29%5C%28%20%60pmse_bpm_flow%60%5C%29%2Fd%27%20sugar1320ent.sql%3B]</p> <p>Have a great weekend, greetings.</p><img src="https://sugarclub.sugarai.com/aggbug?PostID=3774&AppID=56&AppType=Weblog&ContentType=0" width="1" height="1">https://sugarclub.sugarai.com/dev-club/b/dev-blog/posts/developing-using-docker---office-hours-recapWed, 03 Jan 2024 22:09:52 GMT5c521d64-519d-47a6-9065-134618b211bf:262a5c87-4fe4-46f8-8758-168b27af8d36Sudipta Prodhan0<p>Can you please also try same demo&nbsp;on MAC M1?</p><img src="https://sugarclub.sugarai.com/aggbug?PostID=3774&AppID=56&AppType=Weblog&ContentType=0" width="1" height="1">