/srv/irclogs.ubuntu.com/2020/01/31/#ubuntu-server.txt

=== JanC_ is now known as JanC
=== not_phunyguy is now known as phunyguy
lordievaderGood morning07:35
catphishi'd like to configure an ethernet interface with a /32 primary IP and /24 secondary IP, will ifupdown let me do this?11:02
catphishor am i better off configuring the /24, then adding the /32 and updating the source IP for routes afterwards?11:03
lordievaderBelieve so. IIRC you can simply add two "address" specifications.11:04
catphishi didn't know what was even possible! i've always used post-up commands for secondary IPs  in the past11:05
catphishalternatively i guess i can just add the /24 with ifupdown normally then add the /32 as an extra IP, and default route with the custom source IP in a post-up11:05
catphishthe aim is to have a /24 LAN IP, but then a /32 IP for outbound WAN traffic11:06
catphishwhich IP is primary is probably irrelivant to the source on the defaut route anyway11:08
catphishthanks, i'll have a play11:08
catphishturns out i'm an idiot, these servers have netplan11:20
catphishso i just need to work out how to choose the source IP for the default route in netplan11:21
=== Wryhder is now known as Lucas_Gray
=== RoyK^ is now known as RoyK
coreycbsahid: python-tabulate (git)merged and uploaded to focal. thanks for the updates.15:18
tomreynso... 2.5 months to go for autoinstall to be implemnted, tested, serious bugs to be fixed. is this actually realistic?15:19
tomreyn18.04 LTS's server installer was a mess, I have a feeling it'll be the same in 20.04 :-/15:20
sahidcoreycb: ack, thanks for the review15:22
sdezieltomreyn: someone's working on this ATM, see https://discourse.ubuntu.com/t/server-autoinstall-design-questions/1420715:23
tomreynsdeziel: yes, and my calendar says january 31st15:24
tomreyni'm glad it's being worked on, though15:24
tomreynthere once used to be a principle (or just a goal?) to get major changes into the release before an LTS, and this semed to make a lot of sense.15:30
tomreynanyways, this is the wrong place to spread a bad mood, i'm just disappointed with where ubuntu is heading. will move it elsewhere.15:31
rbasaktomreyn: let's wait for the outcome. The installer is a little special here - it can now be updated out of band of Ubuntu releases. Not being directly involved with it I'm not sure what the plans are around that, but it does mean that the usual risk is reduced. The usual hard deadline is feature freeze anyway, and we're not there yet.15:51
tomreynI can't live update the installer on airgapped systems (yes, can be a corner case). I'll not be able to wait, but will certainly watch.15:56
isostaticI'm reserving judgement tomreyn, but in theory if the installer didn't work until August, a working server CD / etc with 2004 could be released then16:38
tomreynisostatic: sure, if it'll be ready then, but ideally in april.16:47
rbasakisostatic: but wouldn't you want the ISO to remain...static? :-P17:33
isostaticMy build ISO hasn't changed since 2008, other than a new initrd and kernel and menu item every 2 years :D17:34
isostatic(Actually I lie, I did update isolinux to use a pretty menu about 4 years ago)17:34
sahidcoreycb: cinder for focal in ready in my repo18:41
johnfghi folks18:54
johnfgThe installation of 19.10 server, LAMP pkg, installed mysql vs. mariadb.  Is mysql what's 'expected' on ubuntu vs. mariadb?18:56
quadrathoch2mariadb is the expected LAMP stack johnfg18:59
sarnoldjohnfg: that's your choice; mysql is in main, so there's more testing around it, but the mariadb updates provided by a community member are usually pretty timely18:59
johnfgquadrathoch2: Coming from debian buster, I thought so too.  However, mysql is installed and not mariadb.18:59
quadrathoch2johnfg: welp what sarnold said, I didn't even know :) so here you go19:00
johnfgI guess since it's here installed, unless I have problems, I'll stick with mysql.19:05
johnfgTruly, I've not found very much, if any, difference between the 2, in executing anything.19:13
sarnoldjohnfg: just be sure you don't try to swap between the two just for fun :)19:16
sarnoldsomething like 80% of the bugs I see on both in launchpad come from folks who have tried swapping between them on the fly, or try one and then the other19:17
sdezielIIRC, only mysql has an Apparmor profile shipped by the package19:20
sdezielI remember the mariadb maintainer trying to get one too but I don't think it happened yet19:20
sarnoldyeah, having a profile in one but not the other is like 60% of those bugs19:20
johnfgGood advice!  Thanks!19:22
sarnold(otto's even been working on upstream apparmor project to try to improve the notifications around apparmor denials :)19:23
johnfgI just noticed, working on the same thing, that in ubuntu, as it was on debian, root is the owner.group of /var/www.  On debian, I changed everything to www-data.www-data.  Should this be on ubuntu-server as well?19:23
sdezielsarnold: I guess you were right about wireguard ending up in 20.04 kernel: https://www.phoronix.com/scan.php?page=news_item&px=Ubuntu-20.04-Adds-WireGuard19:24
sarnoldjohnfg: I think the webserver process should only have write access to log files and database sockets; maybe an upload directory if it runs an application that lets users upload..19:27
sarnoldyay :)19:27
johnfgtypo3 9.5.13 won't work with mysql, but will with mariadb.  If I want to stick with mysql, I'll have to wait for the point version of typo3-cms-10 to come out in the spring.19:46
orentanayI have a local ubuntu apache2 server for testing websites, but i'm having a very hard time getting self signing ssl to work. Can someone look at my config files and see if i'm doing something wrong? https://pastebin.com/DPZMJkBN  thanks.21:52
sarnoldorentanay: fix the connection error before working on tls21:54
sdezielorentanay: have you installed PHP 7.1 from a PPA by any chance? 18.04 ships with 7.221:55
orentanayyes, I installed 7.121:55
sdezielwhy?21:55
orentanaythis works just fine in http without the redirect21:55
orentanayb/c I'll need to work with Magento 2.2, and it's only 7.1 compatible21:56
sdezielah OK21:56
sdezielorentanay: pastebin the output of "apache2ctl -S"21:56
orentanayit wasnt my call, but we migrated just before Magento announced they were discontining support for 2.2, and now we have to migrate to 2.3. not a great day.21:57
orentanayok, one sec.21:57
orentanaywow, that was interesting...21:59
orentanayAH00526: Syntax error on line 48 of /etc/apache2/sites-enabled/mysite-ssl.test.conf:21:59
orentanaySSLCertificateKeyFile: file '/etc/ssl/private/mysite.test-selfsigned.key' does not exist or is empty21:59
orentanayAction '-S' failed.21:59
orentanayThe Apache error log may have more information.21:59
orentanayI may have misplaced a file?21:59
tomreyndoes the SSLCertificateKeyFile exist then?22:01
orentanaychecking...22:01
orentanayyes, it's there, and it's not empty22:02
orentanayright next to ssl-cert-snakeoil.key22:03
tomreynand if you run    file    against it it says?22:04
orentanaycannot open, permission denied. I see that the user:group for snakeoil is root:ssl-cert and for my key its root:root22:05
orentanaycould it be as simple as the wrong group?22:06
tomreynapache httpd on ubuntu normally starts up as root so it can read those files, spawns child processes which drop privileges (IIRC)22:06
tomreynso unless it's not got the read bit set (chmod-wise) i *think* it should be readable to root22:06
tomreynso when you    sudo file   it, it says?22:07
orentanayASCII text22:08
orentanaythe snakeoil file has permissions -rw-r----- and my file has -rw-------22:08
tomreynhmm, and if you     sudo head -1 /etc/ssl/private/mysite.test-selfsigned.key | hd     does it return readable text?22:09
orentanayyes22:09
tomreynalso run file and head -1 against the snakeoil key and compare22:10
sdezielsudo openssl rsa -in /etc/ssl/private/mysite.test-selfsigned.key -noout; echo $?22:10
sdezielshould return 0 unless you use something fancy like ECDSA22:11
orentanaytomreyn, identical output.22:11
tomreynsdeziel's approach is better.22:11
orentanayit returned 022:12
sdezielorentanay: next op is comparing this: openssl rsa -in /etc/ssl/private/mysite.test-selfsigned.key -noout -modulus | md5sum22:12
sdezielorentanay: with openssl x509 -in /etc/ssl/certs/mysite.test-selfsigned.crt -noout -modulus | md5sum22:13
tomreyni also like inspecting -text22:13
sdezielorentanay: invoke those oenssl commands with sudo22:13
sdezieltomreyn: agreed for the x509 one22:14
tomreynright22:14
orentanaytrying it now.22:14
orentanaythey output is identical22:17
sdezielorentanay: what happens if you use the snakeoil cert and key instead?22:18
orentanayI haven't tried that, yet22:18
orentanayjust tried it, and I got the same result22:24
orentanayI made sure to restart apache before testing22:25
sdezielorentanay: apachectl -S still complain even for the snakeoil key?22:25
orentanayyes22:26
orentanayAH00526: Syntax error on line 50 of /etc/apache2/sites-enabled/idwholesaler-ssl.test.conf:22:26
orentanaySSLCertificateKeyFile: file '/etc/ssl/private/ssl-cert-snakeoil.key' does not exist or is empty22:26
orentanayAction '-S' failed.22:26
orentanayThe Apache error log may have more information.22:26
sdezielorentanay: what do you have from "ll /etc/ssl/"22:27
sdezielorentanay: oh, "sudo apachectl -S"22:28
orentanaythat outputs quite a few lines, but it seems the first 2 are most relevant...22:30
tomreynoops :)22:30
orentanay*:443                  mysite.test (/etc/apache2/sites-enabled/mysite-ssl.test.conf:38)22:31
orentanay*:80                   is a NameVirtualHost22:31
sdezielyeah, facepalm22:31
tomreyni failed there, too22:32
sdezielorentanay: now, are you able to start/restart apache2? If yes, please show "ss -nlt"22:32
orentanayrestarted apache, and here is the output...22:33
orentanayState                   Recv-Q                    Send-Q                                        Local Address:Port                                       Peer Address:Port22:33
orentanayLISTEN                  0                         80                                                127.0.0.1:3306                                            0.0.0.0:*22:33
orentanayLISTEN                  0                         128                                           127.0.0.53%lo:53                                              0.0.0.0:*22:33
orentanayLISTEN                  0                         128                                                 0.0.0.0:22                                              0.0.0.0:*22:33
orentanayLISTEN                  0                         128                                                       *:443                                                   *:*22:33
orentanayLISTEN                  0                         128                                                       *:80                                                    *:*22:33
orentanayLISTEN                  0                         128                                                    [::]:22                                                 [::]:*22:33
orentanaysorry, i should have used patebin for that one22:34
sdezielorentanay: looks good to me22:35
orentanayBTW: I really appreciate all the help thats been offered.22:36
tomreynorentanay: so this is Ubuntu 18.04 LTS, fully updated, with apache httpd 2.4.29 from Ubuntu, PHP 7.1 from Ondřej Surý's PPA, and you've not changed how apache httpd starts and which user it runs as etc?22:43
tomreynoh and does ssl work fine now, or is this not yet fixed?22:45
orentanaystill no ssl, but correct on everything else you mentioned.22:47
tomreynorentanay: so are there still errors on the log? still the same error - i assume not?22:48
orentanaylooking for the log files now...22:50
tomreynalso ( if you're ok with posting this to https://termbin.com ):    sudo lsof -n -sTCP:LISTEN -iTCP:80 -iTCP:443 | nc termbin.com 999922:52
orentanayonesec...22:54
orentanayHere you go https://termbin.com/otnd22:56
tomreynhmm no ipv4, but ss -nlt showed ipv4.22:57
tomreynthe rest looks fine though. so what about the logs?22:58
tomreyni think it's unusual that the server would start up if there are still critical SSL key issues.22:58
tomreynorentanay: so what does "still no ssl" look like?22:59
orentanayHere's a small section of my error.log https://pastebin.com/XyHfnLpK23:02
orentanayI still get the refued to connect webpage.23:02
tomreynso stapling will likely not work with a self-signed certificate (i haven't actually tried this, but it seems logical to fail)23:06
tomreynso either comment out / remove this directive off your :443 virtualhost configuration or use a lets encrypt certificate23:07
tomreynor a commercial certificate if you have one which can be used for this purpose23:08
orentanaythanks, I think that will be my next attempt. thank you for all of your help and time.23:10
tomreynyour certificate SubjectAltName (SAN) or Common Name (CN) also doesn't seem to match the FQDNs provided in the :443 virtual host configuration.23:10
tomreynyou're welcome.23:13

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!