/srv/irclogs.ubuntu.com/2019/05/08/#ubuntu-server.txt

damascenehello, as asked in #KVM I want to allow a virtual instance to use network in bridge mode. I'm on Ubuntu 18.04 which uses netplan. That confused me a lot if any one knows how to do it please advice. I read multiple articles but the setup didn't work for me. each one of the should have static IP05:31
damasceneheadless server05:37
lotuspsychje!netplan | damascene start here05:57
ubottudamascene start here: Netplan is a network configuration abstraction renderer which uses YAML descriptions of a network to work with either a NetworkManager or Systemd-networkd "renderer". More information at https://netplan.io/05:57
lotuspsychjedamascene: im not the server expert myself, but netplan uses the yaml file to edit your routes in05:57
lotuspsychjeask again here Rembo05:58
Rembohello, does one of the following patches require reboot? https://pastebin.com/GvPpQFi305:58
Rembodoes grub patches require reboot after patching on Ubuntu 16.04 Server ?05:58
damascenelotuspsychje, thank you for trying to help, I've tried many solution and edited the yaml file. I'm being locked out of PC06:11
lotuspsychjeas again here whitebyte06:16
lotuspsychjealso you might need to patient a bit, -server support wakes up more at US wakeup06:17
whitebyteI have setup Kea DHCP on ubuntu-18.04 server and trying to set hostname for a client ubuntu 18.04 machine. The hostname is passed in the lease file provided by kea-dhcp server but that is not taking any effect on client machine.06:17
whitebytesure @lotuspsychje06:17
lordievaderGood morning06:22
gnomethroweroh nice06:23
gnomethroweri had no idea this was a channel06:23
gnomethrowershould the link in the topic be referencing 18.04? :)06:24
gnomethrower(ping Pici )06:24
damasceneI wanted to setup network interface not to write python code what the hell with this yaml07:10
damasceneI'm unable to know if the issue is with indenting or wrong configuration it keeps complaining as if is saying anything smart07:11
damascenehow to modify this to add KVM bridge? https://paste.ubuntu.com/p/sQWcpKQdyN/07:15
damasceneip for the bridge should be 192.168.1.12107:15
damascenecould you please me add a bridge to my netplan file? https://paste.ubuntu.com/p/yw8gpBgMN2/08:45
damasceneI've tried many configuration but I'm getting thrown out of the server08:45
lotuspsychjere-ask here chl_ ; )09:39
chl_i've set option 66 and option 67 in isc-dhcp, but its not appearing on the dhcp packets if I check by dhcpdump. Has anyone had that problem?09:40
=== Wryhder is now known as Lucas_Gray
leftyfbSo I reported bug #1820096 and it got fixed. The problem is, I cannot seem to recreate the issue and in fact, have found that adding the hosts entry back in breaks tools like dnsdomainname. So now I'm debating whether or not the fix should be reverted.13:51
ubottubug 1820096 in subiquity "/etc/hosts not populated, preventing dns registration with dhcp" [High,Fix released] https://launchpad.net/bugs/182009613:51
patstomsmorning, is there any other service which do scheduling other than irqbalance?13:54
ahasenackrbasak: hi, quick look? https://code.launchpad.net/~ahasenack/usd-importer/+git/usd-importer/+merge/36711214:21
leftyfbahasenack: any suggestions on what we should do about #1820096 and the 127.0.1.1 entry in /etc/host for Ubuntu server? Is this something you can test on your end as well?14:24
ahasenackin principle I would remove it on a server14:25
leftyfbThat's what I'm thinking. But in my initial testing with 18.04 server using the subiquity installer, with the entry there, the system wasn't registering it's hostname with dhcp/dns. Now I can't seem to reproduce the issue.14:26
rbasakI'm not sure I follow your exact problem.14:27
rbasakThe generally right thing that's needed is14:27
rbasak127.0.0.1 localhost14:27
rbasak127.0.1.1 hostname-without-dots fqdn14:27
rbasakin /etc/hosts14:27
rbasakand hostname-without-dots in /etc/hostname14:28
rbasakAnd the system hostname set without dots (which happens from /etc/hostname on boot, or use the hostname command)14:28
rbasakI believe that's the current Debian and Ubuntu standard.14:28
rbasakThe RH world is different I think.14:28
rbasakfqdn in /etc/hosts can be missing if you don't have one14:29
leftyfbwell no, not with server. From what I understand, the 127.0.1.1 is only to work around a bug in some gnome applications that don't work unless we can do a local lookup of our hostname with no network or on a network without a local DNS server that will resolve it. Otherwise (server) it shouldn't be needed14:29
rbasakdnsdomainname et al should then just work.14:29
leftyfbrbasak: with the default 127.0.1.1 entry(no fqdn), dnsdomainname does not work14:30
rbasakYou can get away without 127.0.1.1 like in your example, but it requires an extra round trip to your DNS server so why have it set up that way? The one way that is (should be?) installer default works in all cases, including dynamic, no FQDN, etc.14:30
rbasakleftyfb: with no fqdn, dnsdomainname returns empty, as expected.14:31
rbasakAny machine should be able to look up its own name, and know its own FQDN, without resorting to the network.14:32
leftyfbrbasak: but on the network, the system does have a fqdn, so it should return it's valid hostname. Just because the 127.0.1.1 entry fails at adding the fqdn, does not mean the system does not have one on the network14:32
ahasenackrbasak: I don't recall how this works, should I merge https://code.launchpad.net/~ahasenack/usd-importer/+git/usd-importer/+merge/367112, wait for the bot to run tests, both, something else?14:32
rbasakahasenack: wait for the bot and if it passes go ahead and merge please14:32
ahasenackok14:32
rbasakleftyfb: I don't follow your statement14:33
rbasakleftyfb: what's the problem you're trying to solve? Do you have a failing or illustratively-bad use case?14:33
leftyfbrbasak: if there's a 127.0.1.1 entry, without a fqdn, and the lookup says there is not fqdn, that is returning false information. There is a fqdn, but we're being forced to use the file as opposed to dns and not able to look it up properly14:34
rbasakleftyfb: how is it that you ended up with a 127.0.1.1 entry without an fqdn? And what do you mean by "forced to use"?14:34
leftyfbrbasak: On my network, my devices have fqdn's on the network per the local DNS server. I want to use dnsdomainname to lookup what the domain is. That fails when there is a 127.0.1.1 entry without a fqdn.14:34
rbasakleftyfb: why haven't you told your machine its fqdn during installation?14:35
leftyfbrbasak: forced per the nsswitch order. If "file" has an entry, we don't don't bother looking up "dns"14:35
leftyfbrbasak: To start with, the fqdn can and will change depending on which network(domain) the machine connects to. Hardcoding it is not the right solution.14:36
leftyfbrbasak: And there's no way to populate /etc/hosts with a fqdn with dhcp14:36
rbasakleftyfb: why do you need the machine's idea of its "fqdn" to change as it moves around?14:36
leftyfbrbasak: because it's on a different domain and we want to determine which domain we are on by using the tool meant to do so (dnsdomainname)14:37
rbasakYou're going to have to go through the five whys here, sorry.14:37
leftyfbrbasak: what do you mean?14:38
rbasakI don't see how it's a problem for the machine to consider itself to have a blank fqdn.14:38
leftyfbrbasak: because it's not valid14:38
rbasakAs a road warrior laptop user, I don't want other networks to inject bad data into my laptop.14:38
rbasakIt's perfectly valid, and until someone persuades me otherwise, it's even preferable14:39
leftyfbrbasak: In our particular case, we have robots that move between networks (customer sites) with different domains and we want to use dnsdomainname to determine which domain we are on in order to set some variables14:39
rbasakIt sounds like it might not be the right thing to be using dnsdomainname in that case.14:40
leftyfbrbasak: If a device on a network has a valid fqdn that every other machine on the network knows about, then it is not valid for dnsdomainnam to lie and say there isn't one.14:40
rbasakWhat happens if you have two NICs that both DHCP and get conflicting "FQDN"s?14:40
rbasakPerhaps better for your software to do a reverse lookup on the IP of one network interface it's interested in.14:41
rbasakThat would more unambigiously identify "what network you're on".14:41
leftyfbrbasak: so you're ok with broken tools? For what purpose? Because you want to keep an entry that was only put there to work around a bug in some Gnome applications which aren't relevant in a server install?14:42
rbasakWho said it's broken?14:42
rbasakI think you're making a false assumption here about what the tool is supposed to do for you.14:42
compdocbiggest problem with 2 nics and dhcp, is getting two gateways set for the pc14:43
leftyfb"dnsdomainname - show the system's DNS domain name"14:43
rbasakSee the manpage example that uses 127.0.1.1!14:43
rbasakVia /etc/hosts14:43
leftyfbThe only way to populate /etc/hosts is manually. That is a bad way to use the tool to "show the system's DNS domain name" which has a valid fqdn on the network14:45
cryptodanyou could simply add it to the hostname config at install when you give the computer a hostname14:45
leftyfbWe're not talking about at install. The FQDN is going to change across multiple networks/domains.14:46
leftyfbThe only reason the entry exits in the first place is from https://www.linuxtopia.org/online_books/linux_system_administration/debian_linux_guides/debian_linux_reference_guide/ch-gateway.en_009.html14:48
leftyfbwhich is for a desktop environment, not server14:48
rbasakI'm saying that for the FQDN to dynamically change as you roam between networks is broken in the general case.14:48
rbasakI don't think a default Ubuntu installation should be doing that by default.14:48
leftyfbrbasak: why do you say that is broken?14:49
rbasakJust because I'm connecting to some random wifi somewhere doesn't mean that my FQDN should change.14:50
rbasakAnd on a server, an FQDN change should certainly only happen directly when a sysadmin wants it, and not automatically.14:50
rbasak(by default)14:50
leftyfbIt 100% means it should change if you are on a network with a different domain.14:50
rbasakI don't think that meets normal sysadmin expectations.14:50
rbasakNetworks don't have "domains".14:51
leftyfbI don't even know how to respond to that14:52
rbasakAn individual IP address issued by a DHCP server may reverse lookup to something whose FQDN has something specific according to the DNS server provided by the DHCP lease issued by the DHCP server to that IP address.14:53
rbasakThat's something that's per-IP though, not per-network.14:53
leftyfbrbasak: ok, so to be clear, you're saying the current state should be:  We want a bug workaround for Gnome applications to stay in Ubuntu server for ${reasons}, we don't want dnsdomainname to actually be able "show the system's DNS domain name" from DNS and "Networks don't have "domains".14:59
rbasakleftyfb: no.15:02
rbasakleftyfb: I make no reference to any workaround.15:02
rbasakleftyfb: my reasons for supporting the long standing standard for how this work stand on their own merits.15:03
leftyfbrbasak: and yet, before my bug report, the entry was removed from the subiquity installer15:03
leftyfbSo someone made the decision at some point in the past year to remove it15:03
rbasakleftyfb: are you saying that the current state of the installers don't match my position?15:04
leftyfbrbasak: The current state of the latest available Ubuntu live server installer iso does not match your position15:05
rbasakleftyfb: what does it do instead?15:05
leftyfbrbasak: it does not have an entry for 127.0.1.115:05
cryptodanbut why should it15:05
rbasakleftyfb: in what scenario? Manual IP entry?15:06
rbasakleftyfb: what exactly does it do?15:06
leftyfbrbasak: As basic of an install as you can do, with dhcp and only setting a hostname during the install15:07
rbasakleftyfb: does it add a 127.0.0.1 entry? If so with what? Just localhost?15:08
leftyfbyes and yes. But let me do a quick install to doublecheck15:08
leftyfbTaking longer than expected. We moved the lab around yesterday and don't have a wired connection to my test devices at the moment. The live installer takes forever timing out trying to get to the repos and falling back to the usb15:22
rbasakleftyfb: no worries. Feel free to ping me when you're ready. I appreciate the discussion, and would like there to be a consistent position and bugs open against installers as needed referring to that position.15:23
rbasakleftyfb: seems that my position may need to change to accomodate the DHCP during install + no FQDN supplied during install case.15:25
leftyfbrbasak: https://photos.app.goo.gl/FLDqgAy5VPfrfz4B915:35
leftyfbUsing ubuntu-18.04.2-live-server-amd64.iso15:36
rbasakleftyfb: is that with the fix to bug 1820096? Or does it describe bug 1820096 and it's pending release?15:37
ubottubug 1820096 in subiquity "/etc/hosts not populated, preventing dns registration with dhcp" [High,Fix released] https://launchpad.net/bugs/182009615:37
leftyfbYes. Though the odd part is I can't seem to reproduce the issue now.15:38
leftyfbI'm wondering if mwhudson was able to15:38
leftyfband if he still can15:38
leftyfband if the bug should be invalidated or the fix kept15:39
leftyfboh wait15:39
leftyfbrbasak: no, that is NOT with the fix15:39
rbasakOK15:39
leftyfbrbasak: In order to get the fix, I would need to snap refresh and get the latest subiquity installer.15:39
rbasakSo my position is slightly different (but fundamentally remains the same IMHO)15:39
rbasakIn the case that DHCP is all that is used, and an FQDN is never provided at install time, then it makes sense to have a 127.0.1.1 line with the non-qualified hostname only.15:40
rbasak(by default; the sysadmin can change later of course)15:40
leftyfbI'd like to find the bug and/or discussion that was had to decide on removing the entry for the live installer. That would give us more insight into whether it's actually needed15:40
rbasakRationale: any FQDN provided indirectly via DHCP and DNS at install time cannot be trusted to be the correct FQDN for the final installation.15:41
leftyfbrbasak: why do you say it cannot be trusted? I don't understand that reasoning. You're making decisions based on the assumption that the server install is running on untrusted networks providing "invalid" fqdn's to clients on the network.15:42
rbasakleftyfb: it's quite common for non-automated installs to be done in some kind of non-production network with different settings.15:43
leftyfbrbasak: ok. But why hardcode such that we do not have a FQDN and have no way of using the tool meant to look it up?15:44
rbasakHardcode how?15:44
leftyfbrbasak: If you write an entry for 127.0.1.1 without the fqdn, you are hardcoding invalidating any fqdn lookups15:46
Ussatrbasak, even some automated install will do install in a non-prod network if you are building replacement servers....build, change vlan/hostname/ip replace15:46
Ussatwe do that all the time15:46
leftyfbrbasak: But again, I refer to the Debian documentation stating that the entry was only there in the first place to allow some gnome applications to not break when trying to do a fqdn lookup when we have no network or local DNS server which will resolve the client's fqdn. This does not apply to server installs. Especially ones running on a network with a local dynamic DNS server15:47
rbasakleftyfb: OK. I call that "the system doesn't have a defined FQDN", which is IMHO correct.15:47
leftyfbrbasak: the entry does not exist in any other linux distro other than Debian-based15:47
rbasakUssat: agreed15:48
rbasakleftyfb: I think the current behaviour is sensible behaviour, barring that current subquity bug.15:48
leftyfbrbasak: you cannot make that assumption if you don't look it up on the network15:48
rbasakleftyfb: you're already on very strange territory to have a non-cloud server installation running DHCP that didn't know its own hostname and FQDN at installation time.15:49
rbasakleftyfb: that the default doesn't work for you isn't surprising to me.15:49
rbasakleftyfb: you can override default behaviour by changing /etc/hosts :-)15:49
leftyfbrbasak: I disagree. And we do know our hostname. But for devices that join multiple networks with different domains, no, we do not yet know our FQDN until we are on the network that provides it.15:50
leftyfbA FQDN should not be defined by the client but the network it's on15:50
rbasakSure. I mean you don't know your own (hostname and FQDN) :)15:50
rbasakAs I said before, that doesn't work for multi-homed hosts.15:51
rbasakYou can't make a general statement about what should define an FQDN.15:51
rbasakIt's up to the sysadmin in an individual environment who knows the type of network environment it'll be operating in.15:51
leftyfbIt does when you're not doing something stupid like looking up your FQDN across different DNS servers hosting different domains15:51
leftyfbJust because your client likes to pretend it's FQDN is host.google.com in /etc/hosts, does not mean any other machine on the network is going to agree. The client does not decide what it's FQDN is15:53
rbasakleftyfb: there's a difference between what a client considers its FQDN to be and what points to it via an A or AAAA record, and what reverse lookups via in-addr.arpa and in6.arpa say. They can all disagree.16:08
rbasakleftyfb: therefore it's up to the sysadmin to decide which one is the canonical FQDN. You cannot infer it.16:09
rbasakleftyfb: and therefore it is not a function of the network.16:09
rbasakThough it is generally a misconfiguration somewhere if a machine's FQDN exists in DNS but points to some other machine.16:10
whitebyteI have setup Kea DHCP on ubuntu-18.04 server and trying to set hostname for a client ubuntu 18.04 machine. The hostname is passed in the lease file provided by kea-dhcp server but that is not taking any effect on client machine.16:17
teward!crosspost | whitebyte17:10
ubottuwhitebyte: Please don't ask the same question in multiple Ubuntu channels at the same time. Many helpers are in more than one channel and it's not fair to them or the other people seeking support.17:10
whitebyte@ubottu Sorry. I will keep in mind17:15
ahasenackwhitebyte: check if you have the hostname in /etc/hosts17:17
ahasenackmaybe that's overriding it17:17
ahasenackparide: around still?17:19
ahasenackrbasak: any idea why ci hasn't run on my git-ubuntu branch yet?17:20
ahasenackI'm not seeing errors in https://jenkins.ubuntu.com/server/view/git-ubuntu/job/git-ubuntu-ci/17:21
whitebyte@ahasenack I have only `127.0.0.1 localhost` in /etc/hosts17:22
ahasenackok17:24
ahasenackrbasak: I wonder if it's about an MP limit, I count 10 skips in the job logs17:29
ahasenackhttps://jenkins.ubuntu.com/server/view/git-ubuntu/job/git-ubuntu-ci-trigger/57736/console17:29
* ahasenack wonders where launchpadTrigger comes from17:31
whitebyteI am getting `Not connected to system bus, not setting hostname` in syslog from systemd-network.service. Can I force networkd to start after dbus.service is up17:59
leftyfbrbasak: A FQDN is a function of the network regardless of what the client thinks it is. The rest of the network doesn't give one lick what the client thinks it is and will only resolve what the network(DNS server) thinks it is. Playing pretend in /etc/host is a workaround for lack of network connectivity or a DNS server which will resolve the hosts FQDN.17:59
rbasakahasenack: limit> yeah maybe. paride looks after the job, so he might know? You can manually trigger a job using https://jenkins.ubuntu.com/server/view/git-ubuntu/job/git-ubuntu-ci/build?delay=0sec19:07
ahasenackrbasak: we found out, the mp was approved already, so ci didn't look at it19:08
rbasakAh19:08
ahasenackrbasak: I merged it19:08
ahasenack(after ci's approval)19:08
rbasak\o/19:08
gislavedguys does a tftp client check UDP and TCP both ?19:16
RoyKtftp is udp only19:17
gislavedRoyK you can configure it on TCP19:23
sarnoldI've never seen tftp on tcp19:25
gislavedyou can otherwise you cannot loadbalanc eit19:28
gislaved*loadbalance19:28
gislavedor less easy19:29
sarnoldit's tftp. I can't imagine that it is ever under that kind of load.19:32
gislavedsarnold have you ever seen a tftp server crashing ?19:32
sarnoldno, they don't do anything complicated :)19:32
gislavedsarnold I need failover, LB-er is most easy for that19:32
gislavedthen I can just cehck if the server is alive :)19:32
gislavedheh maybe it's time for anycast19:32
sdezielgislaved: if you really need to LB multiple TFTP servers with healthchecks and what not, you can use keepalived/ipvs I think19:35
gislavedsdeziel I think I can let HAproxy do that, it does not support UDP but I think it can just let it foreward19:35
sdezielgislaved: I don't know if HAproxy can handle UDP at all19:36
sdezielgislaved: for DNS, I've also used IPtables with random module to spread the load among multiple servers ... quick and dirty but it works19:37
gislavedsdeziel normally not but I have doen DNS loadbalancing as well in the past, so let's see19:37
gislavedsdeziel not that dirty :)19:37
sdezielyou can get creative with how you do it with iptables so that you remove backends when they are down but there is no builtin healthcheck which is why I said it was dirty ;)19:38
gislavedheh :)19:40
sdezielgislaved: that said, even under load, I wouldn't expect the service to crash, which package is it?19:44
gislavedsdeziel me neither. xinetd19:44
rbasakleftyfb: again, that's not generally true. Say for example I have a web server on AWS. In that case, the network the instance sees has nothing to do with the real FQDN of the server.19:44
sdezielgislaved: have you tried tftpd-hpa?19:45
gislavedsdeziel not yet, not supported by foreman19:45
leftyfbrbasak: and equally irrelevant is a fqdn entry in /etc/hosts on that instance19:45
rbasakleftyfb: I'd want all services on that instance to see the "right" fqdn, so I would set it correctly in /etc/hosts. I don't see how that's irrelevant.19:46
leftyfbrbasak: I would point the instance to a proper DNS server that knows about the fqdn to do the lookup. Hardcoding entries in /etc/hosts is a hack19:47
rbasakleftyfb: that won't work, because the instance won't have its public IP address actually assigned to an interface19:48
rbasakleftyfb: I don't think the server's _own_ entry in /etc/hosts against 127.0.1.1 is a hack.19:48
rbasakIn the general case for other hosts, yes.19:48
sdezielgislaved: I'd try that one first personally. It's the only tftpd I can see in 'main' and I've seen many deployments using it (although I don't know how many tftp clients you hit your server with...)19:48
rbasakBut for a machine to know its own name and fqdn, that's not a hack. It's the status quo.19:48
gislavedsdeziel not that much but I hate to have things "down"19:48
rbasakDNS isn't necessary for a host to have a name.19:49
leftyfbNo, you're right. It's a big fix for some desktop applications19:49
rbasak(and fqdn)19:49
leftyfbIt is for anything else on the network to utilize the fqdn19:49
sdezielgislaved: I personally wouldn't trust xinetd for production stuff19:49
gislavedsdeziel why not ? it's the most known one that alw ays work(s)(ed)19:50
gislaved*always19:50
sdezielgislaved: I've only ever used dnsmasq and tftpd-hpa myself and the fact that the later is in main (while xinetd is in universe) speaks for itself19:52
gislavedsdeziel it's supported by RH so I trust it :)19:52
rbasakleftyfb: it's useful for various things. Like HTTP error pages being correct, etc.19:56
=== Roy_Mustang is now known as A_D
Aison0hello, anybody experienced with freeradius and openssl 1.1.1b? since 1.1.1b freeradius logs these kind of messages: https://pastebin.com/SacLArvy20:17
Aison0I upgraded my notebook to disco and now freeradius logs these kinds of errors on the ubuntu server20:18
sarnoldAison0: might be worth a filing a bug with ubuntu-bug20:26
Aison0sarnold, the problem is, I don't know if it is really related to that upgrade :-)20:27
Aison0or is this a openssl-1.1.1b thing20:27
sarnoldit feels plausible anyway20:30
=== msmarcal is now known as msmarcal|eod
=== cim2090 is now known as cim209
Disaster_AreaHi! I'm used to using MS SQL Server at work and basically want to use something similar at home for fun. I managed to install SQL server at home on Ubuntu 16.04 but22:49
Disaster_Areawell a) recommended GUIs/CLIs22:49
Disaster_Areab) why do I get some syntactical errors I don't get when using MS SQL Server, e.g. https://i.imgur.com/boLOU6C.png22:49
sarnoldhey Disaster_Area, you may have more luck in an ms-sql channel; someone here might be able to help with postgresql or mariadb or sqlite3, but mssql is pretty rare22:51
Disaster_Areahmm I was pointed this way from #ubuntu ok I'll have a look over there22:52
sarnoldyeah, I can see how they would have aimed you this way :) but I *think* you're the first person I've seen use mssql :)22:54
OerHeksoh, ms sql22:55
michael2I have wanted to tinker with it, but haven't yet22:55
OerHeksis this on WSL?22:55
Disaster_Areayeah I picked up SQL at work first ever programming language or anything for me haha well touched python and R a little bit22:55
Disaster_AreaWSL?22:55
michael2Windows Subsystem for Linux22:56
sarnoldOerHeks: MS releases MSSql *for* linux22:56
sarnoldno need to run mssql on wsl, you could just run it on windows windows :)22:56
Disaster_Areaso I'm on linux at home and I wanted to use something like I'm used to at work rather than having to pick up a different variant22:56
michael2are you having trouble installing it?22:56
Disaster_AreaI've installed MS SQL server on linux fine but22:56
Disaster_AreaI was asking for advice on GUIs/CLIs and22:57
OerHekshardening?22:57
michael2I have used dbeaver community edition22:57
Disaster_AreaI ran some code that creates a simple function with some while loops in that works on MS SQL Server Studio but didn't run at home22:57
sarnoldDisaster_Area: maybe try a much simpler function? something that just returns an integer?22:58
Disaster_AreaI'll have a stab at that sure22:59
Disaster_Areathat worked ok23:00
Disaster_Areahmm what should I post my SQL output in, might be quicker than sharing a screenshot23:01
Disaster_Areaor is pastebin fine? \shrug/23:02
sarnoldthe pastebinit tool makes pasting easy -- you can pastebinit /path/to/file  and then just copy-paste the URL you get back23:02
Disaster_Areahttps://pastebin.com/h1EXGNeD23:02
sarnoldnice23:02
sarnoldnow try a tiny loop.. one variable, small body..23:03
Disaster_Areahaha I keep fucking it up every time I try and code it, and this is why I need a better interface23:04
Disaster_Areabc with this u cant go back and edit the same thing u can just scroll up to find lines you already wrote ....23:04
sarnoldew :)23:05
sarnoldcan you use a text editor like vim or emacs or whatever and feed that as input?23:05
michael2Disaster_Area: Give dbeaver a try23:05
Disaster_Areahttps://pastebin.com/RHA26uSL23:05
Disaster_Areai've got no idea haven't tried & don't have experience with that stuff23:06
Disaster_Areathe MS doc mentioned azure data studio and a couple other interface options23:06
michael2dbeaver is a lot like Sql Server Management Studio23:06
Disaster_Areahmm23:07
Disaster_Areai'll look it up23:07
michael2the Community Version is free and works with sql server and many others23:07
Disaster_Arealooks neat thanks I'll try it I think23:08
michael2I like it because I can use the same interface for ms sql, mysql, postgres, maria...23:08
Disaster_Areaooh hm I need to install java or something hmmmmm23:09
Disaster_AreaI fucked up my java situation really bad so like23:10
Disaster_AreaI had downloaded openjdk when I moved to the OS so I could run minecraft23:10
Disaster_Areathen when I was applying for jobs outta uni one of them was for a java thing and the guy on the phone basically pushed me into trying to learn it23:10
Disaster_Areawhich on linux meant a lot of effing around with uninstalling and installing stuff23:10
Disaster_Areaoops appears i disconneted >_>23:16
Disaster_Areahaha here we go installed it and tried to run and got the following error message:23:16
Disaster_AreaA Java Runtime Environment (JRE) or Java Development Kit (JDK)23:16
Disaster_Areamust be available in order to run Dbeaver. No Java virtual machine23:16
Disaster_Areawas found after searching the following locations:23:16
Disaster_Areajava in your current PATH23:16
Disaster_Area--usr/share/dbeaver/jre/bin/java that was the location it gave23:17
Disaster_Areabuuut when I tried updating my java earlier:23:17
Disaster_Areahttps://pastebin.com/EqX5NgeT23:18
Disaster_Areawould there be a better place for me to ask how to sort this issue out? lol23:18
OerHeks 9 not to upgrade. run apt full-upgrade23:20
Disaster_Areai'll try that see if it helps23:21
Disaster_Areastill same error msg23:23
Disaster_Areahmm its weird it gives the usr/share/... since there is no jre folder in usr/share/dbeaver ...23:26
tomreynmaybe dbeaver have a support channel? it's not part of ubuntu's software repositories, so unless michael2, who is apparently familiar with it, can help you out, you'll better look for a software specific community support channel23:27
Disaster_Areahmm good idea23:29
Disaster_Areathough this might be more of a java issue honestly23:29
tomreynas long as you have apt package "default-jre" installed, this should be all that's needed if the software you're using was made to be ubuntu compatible.23:30
Disaster_Areathink I was missing that..........23:30
Disaster_Areathanks!!23:30
tomreynit's really just a tracking package for the latest openjdk*-jre package, which you seemed to have already23:32
tomreynahem, "default-jre-headless" is what you'd want on a headless server, sorry.23:32
Disaster_Areait installed that one too23:34
Disaster_Areaaaaand dbeaver still same complaint23:34
Disaster_Areaon the other hand how do I find my java path?23:35
Disaster_Areai think i can do it if I can find that?23:35
tomreyn"apt depends <package_a>" lists the other packages package_a depends on.23:38
tomreyn"dpkg -L <package>" lists the files (and paths) which belong to the given package23:39
tomreynyou just reached the point where a moderate understanding of ubuntu's software management utilities could be useful.23:41
Disaster_Areahm i found the path23:41
Disaster_Areayeah I really could do with knowing the ins and outs of knowing my OS better at this point in time23:41
tomreynchances are you'd be better off with these (also normally unsupported here, just like the ones you have now, and mssql) dbeaver packages: https://launchpad.net/~serge-rider/+archive/ubuntu/dbeaver-ce?field.series_filter=xenial23:42
Disaster_Areai dont think its a case of missing packages i think it just needs me to tell it where java is23:43
tomreynon linux it's common to build and package software multiple times for different distributions, to make the software apply to the different environments.23:44
tomreyne.g. one distro may have java binaries in one path, the other in another path.23:44
tomreynalso by using apt repositories you get an easy and secure upgrade path23:46
Disaster_Areawell, I did install the default-jre and default-jre-headless and it didnt appear to have helped... anyway so i tried some things and23:47
Disaster_Areahttps://pastebin.com/zVDiVs1q23:49
Disaster_Areaoh hmm this is good23:51
Disaster_Areathe filepath i found at the top23:51
Disaster_Areadoesn't exist any more23:51
Disaster_Area>_>23:51

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