| [10:06:22] | * theMusician has quit (Quit: theMusician) |
| [13:04:40] | * roycroft has quit (Ping timeout: 240 seconds) |
| [13:05:23] | * roycroft has joined #aegir |
| [13:42:53] | * gusaus has quit (Quit: gusaus) |
| [17:12:35] | * reaper013 has joined #aegir |
| [17:58:05] | * ybabel has joined #aegir |
| [23:39:10] | * v20th has joined #aegir |
| [23:46:33] | * noecc has joined #aegir |
| [23:53:38] | * fatguylaughing has joined #aegir |
| [00:14:34] | * noecc has quit (Ping timeout: 268 seconds) |
| [00:15:34] | * noecc has joined #aegir |
| [01:05:02] | * orangey_ has joined #aegir |
| [01:09:48] | * zz_kvanderw has joined #aegir |
| [01:10:18] | * drakythe_ has joined #aegir |
| [01:10:51] | * Lowell has quit (*.net *.split) |
| [01:10:51] | * orangey has quit (*.net *.split) |
| [01:10:52] | * drakythe has quit (*.net *.split) |
| [01:10:53] | * kvanderw has quit (*.net *.split) |
| [01:10:55] | * zz_kvanderw is now known as kvanderw |
| [01:10:56] | * drakythe_ is now known as drakythe |
| [01:11:22] | * drakythe is now known as zz_drakythe |
| [01:11:34] | * zz_drakythe is now known as drakythe |
| [01:11:56] | * Lowell has joined #aegir |
| [01:20:38] | * theMusician has joined #aegir |
| [01:21:08] | * fatguylaughing has quit (Quit: fatguylaughing) |
| [01:27:58] | * fatguylaughing has joined #aegir |
| [02:03:32] | * reaper013 has quit (Quit: Page closed) |
| [02:59:22] | * v20th has quit (Ping timeout: 245 seconds) |
| [03:58:33] | * theMusician has quit (Ping timeout: 240 seconds) |
| [04:00:34] | * theMusician has joined #aegir |
| [04:03:02] | * theMusician has quit (Client Quit) |
| [04:05:14] | * memtkmcc has joined #aegir |
| [04:05:26] | * theMusician has joined #aegir |
| [04:06:47] | <helmo42[m]> | Hi all, ergonlog1c bgm jonpugh colan cweagans gboudrias memtkmcc .. Scrum time?. |
| [04:08:41] | <helmo42[m]> | Zeus is end of life :) |
| [04:08:53] | <helmo42[m]> | The debian repo is now moved to the Coop's server. And we have HTTPS there. |
| [04:08:55] | <bgm> | long live Zeus :) |
| [04:09:18] | <bgm> | cool! |
| [04:09:20] | <helmo42[m]> | Jenkins is offline. the CI DNS record is moved to the gh pages archive |
| [04:09:36] | <jonpugh> | End of an era |
| [04:09:51] | * anarcat waves goodbye to Zeus |
| [04:12:53] | <memtkmcc> | thanks, thanks… :-) |
| [04:14:02] | <memtkmcc> | We are working on ProxySQL support in Aegir, so it could easily leverage Percona XtraDB Cluster of any size, but there is some weird problem I couldn't track down. |
| [04:14:04] | <helmo42[m]> | In the comming week I'll finish some doc updates relating to this ... The inpack on the release process in not as big as I feared :) |
| [04:15:23] | <helmo42[m]> | memtkmcc: nice that could be helpful in larger installations |
| [04:15:41] | <memtkmcc> | Since ProxySQL listens on port 6033, we can't use localhost, because it would try to use local mysql socket instead of the custom port, so we had to use 127.0.0.1 instead of localhost. |
| [04:15:50] | <memtkmcc> | However, with proper grants and everything, hostmaster installation fails with errors: |
| [04:15:56] | <memtkmcc> | Could not find a free database names after 100 attempts [error] |
| [04:15:56] | <memtkmcc> | Unable to create new databases. [error] |
| [04:15:56] | <memtkmcc> | Database could not be created. [error] |
| [04:15:56] | <memtkmcc> | Failed to drop database [warning] |
| [04:15:56] | <memtkmcc> | Unable to drop database. [error] |
| [04:16:05] | <memtkmcc> | Not sure what else may need extra tricks in Provision, but it just refuses to work, and there are no specific errors reported on the db servers side, just nothing. |
| [04:16:11] | <memtkmcc> | Any ideas? Anyone tried to use ProxySQL with Aegir? |
| [04:18:16] | <memtkmcc> | Now trying to make Provision more verbose and report what it is actually doing when trying these test connections.. |
| [04:18:54] | <anarcat> | use te source luke ;) |
| [04:19:01] | <anarcat> | it's just trying a CREATE DATABASE, iirc |
| [04:19:23] | <helmo42[m]> | my first guess would be in the way grants are generated. |
| [04:20:12] | <memtkmcc> | the problem is that when I manually connect with correct credentials as aegir system user, I can CREATE DATABASE, no problem |
| [04:20:15] | * gusaus has joined #aegir |
| [04:20:48] | <jonpugh> | Grants is already problematic for using docker, fyi |
| [04:20:54] | * v20th has joined #aegir |
| [04:21:00] | <jonpugh> | When using, I should say. |
| [04:21:23] | <jonpugh> | Aegir grants by detected IP, which changes on container restarts |
| [04:21:54] | <jonpugh> | memtkmcc: might be related |
| [04:22:46] | <helmo42[m]> | I got sql on an alternate port once in https://www.drupal.org/node/2762479 |
| [04:22:47] | <hefring> | https://www.drupal.org/node/2762479 => Use ssh tunnel to connect remote MySQL server [#2762479] => 6 comments, 3 IRC mentions |
| [04:22:53] | <memtkmcc> | yea, but here it is not about grants, because they just work when I test this manually from web node, rather something between PDO on Aegir side and ProxySQL, I guess, it is just silent about the exact problem |
| [04:23:00] | <memtkmcc> | hmmm |
| [04:23:34] | <memtkmcc> | the ProxySQL is the tunnel and load balancer in this case |
| [04:24:43] | <memtkmcc> | will check this issue, thanks! |
| [04:25:32] | <helmo42[m]> | I tried the hosting_distributions module ... looking nice :) ... first remarks in https://www.drupal.org/node/2869389 ergonlog1c ++ |
| [04:25:33] | <hefring> | https://www.drupal.org/node/2869389 => Minor review items [#2869389] => 0 comments, 1 IRC mention |
| [04:26:00] | <memtkmcc> | by the way, we manage grants in BOA outside of Aegir, so it is not a problem, just something weird between PDO and ProxySQL, I think |
| [04:26:21] | <memtkmcc> | anyway, working on this until it works :-) |
| [05:02:09] | * fatguylaughing has quit (K-Lined) |
| [05:08:11] | * theMusician has quit (Quit: theMusician) |
| [05:15:04] | * noecc has left #aegir ("pax") |
| [05:41:52] | * theMusician has joined #aegir |
| [06:55:49] | * ybabel has quit (Quit: ybabel) |
| [07:07:30] | * theMusician has quit (Quit: theMusician) |
| [07:12:00] | * theMusician has joined #aegir |
| [07:17:40] | * theMusician has quit (Quit: theMusician) |
| [07:25:09] | * theMusician has joined #aegir |
| [07:28:16] | * theMusician has quit (Client Quit) |
| [07:40:55] | * theMusician has joined #aegir |
| [07:55:57] | * v20th has quit (Quit: Leaving) |
| [08:34:16] | * theMusician has quit (Quit: theMusician) |
| [08:44:21] | * theMusician has joined #aegir |
| [09:06:47] | <memtkmcc> | Still trying to get ProxySQL to work with Aegir.. |
| [09:06:51] | <memtkmcc> | After enabling a little more verbose mode it gets only more weird.. Provision confirms that it can create databases, but then fails to suggest dbname to use. Very intriguing.. |
| [09:07:38] | <memtkmcc> | Verbose log snippet: |
| [09:07:41] | <memtkmcc> | Provision can create new databases. [1.85 sec, 11.39 MB] [success] |
| [09:07:41] | <memtkmcc> | Provision can grant privileges on database users. [2.35 sec, 11.39 MB] [success] |
| [09:07:41] | <memtkmcc> | Provision can activate multi-byte UTF-8 support on Drupal 7 sites. [2.35 sec, 11.4 MB] [success] |
| [09:07:41] | <memtkmcc> | ..... |
| [09:07:41] | <memtkmcc> | ..... |
| [09:07:42] | <memtkmcc> | Could not find a free database names after 100 attempts [7.29 sec, 11.84 MB] [error] |
| [09:07:42] | <memtkmcc> | Unable to create new databases. [7.29 sec, 11.84 MB] [error] |
| [09:07:43] | <memtkmcc> | Database could not be created. [7.29 sec, 12.47 MB] [error] |
| [09:07:43] | <memtkmcc> | Returned from hook drush_db_pre_provision_install [7.29 sec, 12.47 MB] [debug] |
| [09:07:44] | <memtkmcc> | Dropping database [7.29 sec, 12.47 MB] [notice] |
| [09:07:44] | <memtkmcc> | Failed to drop database [7.29 sec, 12.47 MB] [warning] |
| [09:07:45] | <memtkmcc> | Unable to drop database. [7.29 sec, 11.85 MB] [error] |
| [09:07:45] | <memtkmcc> | Changes made in drush_db_pre_provision_install have been rolled back. [7.29 sec, 12.47 MB] [debug] |
