| [00:26:15] | * farmBOT has quit (Ping timeout: 256 seconds) |
| [00:26:39] | * farmBOT has joined #farmos |
| [08:06:21] | <tool172[m]> | monkeyflowerfarm: I use portainer to house my docker VM and manage the containers, i use docker-compose in folders and segregate data locations that way, i use nginxproxy for all my port 80 and 443 redirects so I can run mulitple servers on the front end. I think I have 18 containers right now running |
| [08:07:02] | <tool172[m]> | you could also use traefik, but i found it cumbersome for my usecase , i also have my own DNS uprouting server through pihole that takes care of A records for me |
| [08:07:47] | <mstenta[m]> | wow nice setup tool172 :-) |
| [08:08:58] | <tool172[m]> | its really just a cheap optiplex with proxmox VE -> LXC Ubuntu -> dockerman (portainer etc.) then I have a 74U 16core xeon with 256GB Ram and a lot of storage that is now just my main webserver/nextcloud/wordpress/farmosproduction |
| [08:09:31] | <tool172[m]> | i'm moving farmos off then wordpress off - leaving nextcloud with apache and lets-encrypt, i can proxy the rest in vhost over to my optiplex |
| [08:09:56] | <tool172[m]> | I'm still struggling through the migration from mysql to postgres -> i tried running 3 different docker containers (failed) |
| [08:10:13] | <tool172[m]> | so i'm going to spinup a VM next and do it the right way then destroy it |
| [08:10:33] | <tool172[m]> | or comment out that line and just roll with it |
| [08:11:11] | <tool172[m]> | mstenta: recommend docker setup details and compose example that is plug n play on dockerhub for farmos instead of digging through the git |
| [08:18:43] | <mstenta[m]> | tool172: all of the testing I did during development of the migration logic was with the official development compose file https://github.com/farmOS/farmOS/blob/2.x/docker/docker-compose.developm... - with the addition of `www1x` and `db1x` containers running farmOS 1.x + MariaDB, respectively |
| [08:18:58] | <mstenta[m]> | All on Debian/Ubuntu |
| [08:19:28] | <mstenta[m]> | Same in my production environment (but spread across multiple servers without docker compose, and DBs not running in Docker) |
| [08:19:45] | <mstenta[m]> | So we know MariaDB -> PostgreSQL works and is well-tested |
| [08:21:24] | <mstenta[m]> | The one issue we've discovered (https://github.com/farmOS/farmOS/issues/506) is ONLY related to MySQL -> MySQL migrations (not into PostgreSQL) |
| [08:22:29] | <mstenta[m]> | And that's just a minor issue, which you can workaround easily by commenting out the line mentioned in that issue... the only downside is you won't get the nifty "Migrated from farmOS 1.x on [date]" revision log messages in your migrated entities |
| [08:22:55] | <mstenta[m]> | But... you seemed to suggest that you saw the same error when migrating from MySQL -> PostgreSQL? Is that correct? |
| [08:23:57] | <mstenta[m]> | That doesn't make sense to me, because the issue described in that GitHub link is clearly attributable to a difference in SQL syntax between MySQL/PostgreSQL... so I'm curious if it's actually the same error, or if it's something different. |
| [08:28:17] | <tool172[m]> | no i haven't |
| [08:28:36] | <tool172[m]> | i'm loading a connector right now to perform a re-install in docker with a mysql -> postgres |
| [08:28:47] | <tool172[m]> | i was running pgloader |
| [08:28:51] | <tool172[m]> | and it crapped out |
| [08:31:17] | <mstenta[m]> | oh i'm not familier |
| [08:31:56] | <mstenta[m]> | oh, maybe i misunderstood. did you see the error during MySQL->PostgreSQL? Or MySQL->MySQL? |
| [08:32:10] | <tool172[m]> | as previosly discussed mysql->mysql |
| [08:32:19] | <mstenta[m]> | ok that's what i thought |
| [08:32:40] | <mstenta[m]> | i misunderstood earlier then (was chatting from my phone ha) |
| [09:51:17] | <tool172[m]> | so the migration fails - but different this time |
| [09:51:24] | <tool172[m]> | the way I understand the docks, i create a folder called migrate under files and place my log files in there same structure? |
| [09:52:08] | <tool172[m]> | error is on file migration |
| [09:52:15] | <tool172[m]> | ACTION uploaded an image: (9KiB) < https://libera.ems.host/_matrix/media/r0/download/matrix.org/NmHzqxvaJQb... > |
| [09:57:56] | <tool172[m]> | i figured out the error |
| [09:58:08] | <mstenta[m]> | oh good |
| [09:58:11] | <mstenta[m]> | was just going to say... a tip: |
| [09:58:29] | <mstenta[m]> | `drush migrate:messages [migration_id]` will provide more details about errors sometimes |
| [09:58:36] | <tool172[m]> | lol i looked |
| [09:58:41] | <tool172[m]> | it's a hierarchy issue |
| [09:59:42] | <tool172[m]> | it worked |
| [09:59:43] | <tool172[m]> | marvelous |
| [09:59:57] | <tool172[m]> | now to resecure my mysql server |
| [09:59:58] | <tool172[m]> | lol |
| [10:00:01] | <mstenta[m]> | 🎉 |
| [10:00:08] | <mstenta[m]> | that's great! |
| [10:00:38] | <tool172[m]> | is 2.x branch the latest for 2.0 in docker |
| [10:00:45] | <tool172[m]> | i assume latest is for dev only |
| [10:01:45] | <mstenta[m]> | i would recommend pinning to a specific version, the most recent is `2.0.0-beta4` |
| [10:01:46] | <mstenta[m]> | `2.x` is the dev branch |
| [10:02:03] | <mstenta[m]> | `latest` points to the most recent tagged release (`2.0.0-beta4`) - but I recommend NOT using `latest` |
| [10:03:23] | <tool172[m]> | thanks, and is there a process for the app too? |
| [10:03:38] | <tool172[m]> | or just reset it up to point to the new server |
| [10:03:49] | <mstenta[m]> | you mean Field Kit? |
| [10:03:54] | <tool172[m]> | yes |
| [10:04:06] | <mstenta[m]> | ah unfortunately not ready for use yet |
| [10:04:13] | <tool172[m]> | that's fine for now |
| [10:04:23] | <tool172[m]> | i still have my main server operational |
| [10:08:41] | <tool172[m]> | thanks again. i'm officially now on docker - and apache i guess until the next update |
| [10:44:55] | <tool172[m]> | this is under 2.0.4-beta, docker, migrated - loaded google maps module, and blank maps |
| [10:45:24] | <symbioquine[m]> | https://farmos.discourse.group/t/map-images-no-longer-loading/1226/2 |
| [10:45:58] | <mstenta[m]> | yea the google maps module isn't compatible with 2.0.0-beta4 (yet) |
| [10:46:20] | <tool172[m]> | is mapbox good enough |
| [10:46:41] | <symbioquine[m]> | OpenStreetMap (or custom basemap sources) should still work too. |
| [10:54:23] | <tool172[m]> | coolio |
| [10:54:24] | <tool172[m]> | thanks all |
| [10:54:26] | <tool172[m]> | bed time |
| [10:54:46] | <mstenta[m]> | 👋 |
| [11:16:44] | <paul121[m]> | <FarmerEd[m]> "Anything interesting at DrupalCo..." <- Yes! There were numerous talks on API concepts (OAuth, jsonapi, graphql, decoupled) that were quite good. Almost everything should have been recorded & be released soon. I'll make sure to share that and maybe a list of what might be most interesting to farmOS. It's been fun meeting people from the community and maintainers of other modules we've worked with |
| [15:04:53] | <mstenta[m]> | First one to spot paul121 wins! 😄 https://twitter.com/drupalcon/status/1520055603183464450 |
| [15:06:35] | <FarmerEd[m]> | He's right there ☝️ |
| [15:31:46] | <paul121[m]> | Ha! |
| [15:31:56] | <paul121[m]> | I was standing next to a tall person |
| [15:32:06] | <paul121[m]> | Not that it helps 😁 |
| [15:35:43] | <paul121[m]> | Ahh we should have tweeted, I had stickers |
| [15:35:54] | <paul121[m]> | I still have lots of stickers 🤣 |
