[00:06] https://pastebin.com/raw/RHDyE4mR === NotPyrrhic is now known as Pyrrhic === notdaniel_ is now known as notdaniel === JanC is now known as Guest52949 === JanC_ is now known as JanC [03:24] good night world [03:32] Good night j_ :) === guampa_ is now known as guampa === ChmEarl is now known as PryMar56 === PryMar56 is now known as ChmEarl [06:34] Good morning [06:51] hey im trying to debug a invalid certificate should be be valid [06:51] im seeeing that there are some parameters missing in the CSR as in organization name etc, could that be the cause of it? [08:20] DK2: how do you check currently that it is invalid? [08:20] DK2: I'd ahve hope that tells you at least a bit about the reason [08:21] Without any other data my first guess for unexpected invalid certs would be odd local time [08:21] DK2: since I don't know what cert you are looking for I don't know if it applies, but step by step checking like the following might be good https://www.cyberciti.biz/faq/test-ssl-certificates-diagnosis-ssl-certificate/ === Sin-ZzZz is now known as Sinned [09:42] i think i figured it out [09:42] maybe its just my buggy thundebrird [10:19] win 4 [10:19] sorry [10:32] nano vsftpd.conf - [ Error reading lock file /etc/.vsftpd.conf.swp: Not enough data read ] [10:32] hello, how fix it? [10:49] Village: you're editing a swap file [10:49] Village: you're supposed to edit the real file [10:49] I'd guess the swap file is caused by another editor crashing with the file open ? [10:52] Or another editor still has the file open. [11:04] Hello! I'm trying to run systemd --user, but it results with [11:04] Trying to run as user instance, but $XDG_RUNTIME_DIR is not set. [11:04] Any idea how do I fix this? [11:05] ikonia, how i can make in not swap , unlock? [11:07] Village: Is there another editor running with the file open? [11:07] no, i don't think so [11:08] Village: Did you verify? [11:09] now i im with vim [11:10] and i dont know how to to exit from file with vim [11:10] Village: :q [11:10] Given you didn't edit your buffer. [11:13] :Q1 [11:13] :q1 [11:13] it needs [11:13] so how now i can unlock file? [11:13] It's now not opened with any editor [11:15] I usually remove those (don't even have the option enabled), but to be safe you can simply rename the file. [11:15] how i can remove? [11:16] i remove file and then his again shows same, maybe i need remove [11:16] Village: To rename the file use 'mv', if you really want to delete it use 'rm'. [11:16] .vsftpd.conf.swp [11:17] Ofcourse it is recreated if your editor is set up to create a swap file. [11:17] ok it's now free [11:17] thank You [11:17] I remove .vsftpd.conf.swp [11:17] and all good === IdleOne is now known as Guest17507 === icey_ is now known as icey === daker_ is now known as daker === Guest17507 is now known as IdleOne [14:43] coreycb: hello! [14:49] <_yeeve> hey chat, those who use mysql-server, what have you done about the changes to sql_mode/group-by? It seems that I keep running into this "only_full_group_by" error and I'm ready to give in and just hardcode the change to be like it used to in 5.6 [14:51] rbasak: --^ ? [14:51] good morning [14:56] _yeeve: not sure. It's not in packaging, so is that a change in 5.7 perhaps? Or are you reporting some change in behaviour during the lifetime of a stable release? [14:57] <_yeeve> 5.7 changed to include a setting in sql_mode for `only_full_group_by` which causes errors in previous which worked. I've been fighting this a lot lately (in symfony you can add a setting to the doctrine options to change it for that project) but that's not always doable [14:57] <_yeeve> previous queries* [15:00] <_yeeve> This: http://stackoverflow.com/a/37248560 fixes the issue but it's not an ideal fix. At first I didn't want to change this, I was updating queries when I first ran into it but it's not feasible at all. I then moved to overriding specifically but I've got to the point where I can't override the setting via the platform code so I'm just doing it on a server-wide level now :( (there might be a way to set it per user or db/table but I didn't find [15:00] <_yeeve> anything when I looked) [15:05] Ah, OK. [15:05] I don't know much about that, sorry. [15:11] <_yeeve> No worries rbasak, cheers :) [16:11] coreycb: I am upgrading from Mitaka to Newton and I have hit this bug https://bugs.launchpad.net/horizon/+bug/1643964 [16:11] Launchpad bug 1643964 in horizon (Ubuntu) "compressing static assets fails with xstatic-bootswatch 3.3.7.0" [Undecided,Fix released] [16:12] I got the error CommandError: An error occurred during rendering /usr/share/openstack-dashboard/openstack_dashboard/templates/horizon/_scripts.html: '\"../bower_components/respond/dest/respond.min.js\"' isn't accessible via COMPRESS_URL ('/horizon/static/') and can't be compressed [16:12] Following the discussion on the bug [16:12] I fixed it doing [16:12] apt-get remove python-django-horizon [16:13] and then I could finish the installation of openstack-dashboard [16:13] zioproto, zul, i think we came across that before. are you using newton-proposed? the problem i think is that we shouldn't be refreshing xstatic files in stable releases. [16:13] I am using newton stable [16:16] coreycb: are you saying the fix is in newton proposed but not yet in newton stable ? [16:17] zioproto, i'm hoping (and looking to see) that updated xstatic files weren't promoted to newton-updates. are you using ubuntu packages or your own? [16:18] coreycb: I am using -> sudo add-apt-repository cloud-archive:newton [16:20] coreycb: I have to leave my office ... I can give you feedback on this tomorrow [16:20] bye [16:21] zioproto, zul, i just checksummed the xstatic orig files for newton and it looks like xstatic files have not been updated for ubuntu packages since newton was released, so that's good === niemeyer_ is now known as niemeyer [17:57] So ... not sure how useful this'll be to anyone here, but I'm currently working on evaluating the costs we're paying for ec2 instances in AWS, and as such I've been screwing around with jq. Thought I'd share the product since I know I'm not alone in being a sysadmin-type who doesn't know jq well. [17:57] aws ec2 describe-instances | jq '.[]|.[].Instances|.[] | select ( .State.Name == "running" ) | .InstanceId + "," + .InstanceType + "," + "\( .Tags[] | select ( .Key == "Name" ) | .Value)"' [17:58] That command will take the output of `aws ec2 describe-instances` and output in CSV-format the instance-id, instance-type, and instance-name ... for every running ec2 instance your CLI can find. This makes for easy importation into spreadsheet. [17:58] Then calculate the annual cost of instances by multiplying the hourly rate for that instance-type by 8677 [18:00] you had much better success with jq than I did. I think I got lost with it when trying to parse maps (objects?) with arbitrary keys [18:00] I had better luck with jshon, it fit my mental model far better; but I spent less time learning how to use serde_json in rust and got more done. hehe. :) [18:03] sarnold: heh. === IdleOne is now known as Guest96888 === patrickmn is now known as pmn [22:21] rbasak: did you have an updated ubuntu-server-triage merge for me to look at yet? Should I accept what is there? [22:28] powersj: sorry, not yet [22:28] rbasak: no worries, just wanted to be sure I haven't missed it :) [22:28] powersj: feel free to accept what is there though. It should do no harm. [22:28] (IIRC no functional change either, unless you use the new option) [22:28] rbasak: thx - was just looking at it and do like the changes, so I'll grab 'em both [22:28] We can make it default in a future commit [22:28] (after changing the bits we discussed) === Serge is now known as hallyn [23:40] howdy - i'm trying to clean out a boot partition on a small VM, GRUB version is 1.99 i want to know if i can dpkg purge a kernel version later than the "uname -r" one which is the only one that boots ? [23:41] with out breaking things : ) [23:43] manukapua: without knowing details it's hard to be specific [23:44] manukapua: in general, I like to keep at least two kernels installed, sometimes three -- the newest kernel, the currently running kernel, and maybe the next most-recent kernel. [23:45] sarnold: the more recent kernels dont "work" due to lack of disk space need to purge them [23:45] ow :) [23:45] then by all means start deleting away [23:48] 3.2.0-48-virtual is good but 51 and 126 are borked [23:48] doing housekeeping , leaned out a lot of older ones [23:49] does apt-get purge work at that point? [23:49] *cleaned [23:49] or is it too busted/ [23:51] ive been doing dpkg --force-all -P on the earlier ones [23:52] as apt-get purge wouldn't [23:52] just need to be sure its ok to go for the "latest" ones [23:53] yeah [23:53] you can even delete the currently running kernel, if you're positive another kernel actually works [23:54] the trouble with removing the currently running kernel is that you can't then load any new kernel modules (say, for cifs or something) [23:56] want to keep current running and remove a couple of more recent ones.. [23:56] already ditched everything proir to currently running [23:58] just being cautious - as do not want to break it