[08:11] morning boys and girls. [08:36] hi all; if I have a router which is "VSDL", can that be used if I switch to a fibre connection - or will I need a different router? [08:36] VDSL I should have said [15:03] marshmn: yes it typically does all ADSL services and VDSL services, but you have to be clear on what 'fibre' really is, of course [15:12] they left after 10am i think [15:13] oh yeah silly me [15:13] ah no, because i tab completed [15:13] ah, back at 11am [15:13] just texting a friend in Houston, her net connection went down :S [15:14] yeah, looking pretty biblical over there atm [15:15] they didn't evacuate in advance this time because when they did that dor rita it killed 100+ in chaos [15:16] *nod* [15:16] like all those disaster films [15:17] you tell 2m people to get out and it doesn't end well [15:49] daftykins: I mean the fibre type where you have copper from your house to the cabinet - then fibre from there [15:49] I think [15:49] essentially I'm with PlusNet right now and I have an option to upgrade to their fibre service [15:50] yeah that's just when they lie, essentially :) [15:50] I could do with the extra upload bandwidth more than the download [15:50] well just check out one of those line checkers online to see what speeds you could get [15:50] srue [15:50] yeah that was the same situation for me, i'm on VDSL2 with 60/10 [15:51] thanks for the info [15:53] the problem is the prdictions can be very touchy - I know people with barely more than ADSL on VDSL [15:55] i think the line length, if you guys can found that out easily enough up on the mainland there, is usually a pretty fair indication [15:57] daftykins: Not necessarily; there's quite a few bad lines [15:57] that's true, over here you can get it checked before committing though [16:14] dont think you can here [17:04] does ubuntu server 17.04 boot to a gui or console ? [17:05] you sure you want to touch non-LTS for server? [17:08] i have a spare pc, i just completed codecademy sql course so want to have a play with stuff on a local server [17:08] however more than likely i will ssh in to do stuff [17:09] well server typically installs headless, as it's a nice minimal install - i'd advise you stick to LTS versions though [17:09] ok good idea [17:09] thanks [17:09] np [17:09] i am not sure if this space pc has 1 or 2 gb ram [17:09] i think it may be 1 [17:10] that's plenty [17:10] cool [17:10] well i can put ssh on, start / stop mariaDB as needed [17:10] i'm typing from a 14.04 server VM with 384MB RAM allocated, running apache2, screen and irssi [17:11] cool [17:11] most of the time you have to tweak service defaults, it's no biggy [17:11] i'll just fire it up so it is running mint at the moment [17:17] who ever designed this keyboard is not a unix person [17:17] or linux person [17:18] to press a function key the fn button is at the far end of that row, ctrl-alt are normal places so to switch to virt console you need to press ctrl-alt-fn-f1 [17:18] sounds about laptop normal [17:18] this is a desktop keyboard [17:19] how to figure out memory [17:19] total 1.7G [17:19] so i am guessing i have 2G ram and the remainder betweel 1.7 and 2 is for video [17:21] 256MB onboard allocation could fit well, you could likely dial that down a bit whilst GUIless [17:22] yeah [17:23] ok bios is more useful 2048MB [17:28] there doesn't appear to be a bios option to changed the shared memory [17:30] more often than not there is [17:30] i don't know the specs to know much here [17:30] yeah [17:30] the onboard graphics option is greyed out [17:31] but this is a emachines thing so i can't put a 2nd graphics card in anyway [17:31] bit weird, if there were a discrete card you'd see all the RAM [17:31] yeah [17:32] ok 16.04 is still downloading [17:32] i then have both 16.04 and 17.04 [17:32] but i agree use 16.04 LTS [17:36] *nod* when i do upgrade servers, they're VMs so i just build a new one up beside, correct all the changes with the config then swap IPs :D [17:36] don't believe in upgrades [17:37] upgrade = breakage [17:39] ok just burning dvd now [17:43] cor, someone needs a few cheap flash drives for christmas :> [17:44] i have a stack of em, just that my dvd-r and space dvds are on my desk [17:44] :D [17:47] yay [17:47] what is a HWE kernel [17:47] i am guessing i don't need it [17:49] zleap: HWE is Hardeware Enablement [17:50] k [17:50] zleap: Basically you get a set of {kernel, X, and some othe rstuff} and there are a few versions that I think vaguely correspond to 16.04, 16.04.1, 16.04.2 etc (which I also think correspond to teh 16.10, 17.04 etc kernels) [17:51] zleap: So when you install you stick to whichever one you started with during updates, but it means that newer subreleases get newer kernels so support new hardware [17:53] popey just beat me! [17:53] i just use the normal kernel, this isn't a server grade project [17:53] hard.. [17:53] ref: https://forum.snapcraft.io/t/cant-do-two-cleanbuilds-at-once/1883 [17:53] in other news, I'm really hot [17:54] well if you downloaded a 16.04.x where x is >2 ISO, it likely came with an HWE stack already on there [17:54] (newer kernel than the 16.04 release originally came with) [17:54] k [17:54] it copying data to disk atm [17:55] i like the feature that you can see what you're typing when entering a password [17:55] especially useful for setting up the initial system [17:55] I like the feature that you tell everyone your password so that they can haxxor you :-p [17:55] hmm never been fussed [17:56] diddledan: like 'kingdiddler82' ? [17:56] :-o [17:56] you haxx0r! [17:56] i don't tell people my password [17:56] zleap: you do if you're typing it in that box that you just mentioned and someone is shoulder surfing [17:56] pretty sure i guessed your birth year wrong though :> [17:57] only one year out :-p [17:57] no one else in this room with me [17:57] that you know of [17:57] it is a small room at home [17:57] the SIS are next-door with a fibre-optic camera [17:58] lol [17:58] :> [17:59] i can't see SiS and not think of Silicon Image(?) Systems, the terrible mobo chipset maker [17:59] Schemano Index System gears [17:59] Shimano :> [18:00] bah [18:00] diddledan: :D [18:00] don't hit me again! [18:00] ok installing main system [18:00] i've got my bikes right beside me here in the lounge, so i can stare right at the shimano front derailleur of one of 'em :> [18:00] what's the best thing you can say to a police man when they arrest you for something? [18:01] "Please stop hitting me" ? [18:01] yup [18:01] or variants like "don't hit me again, I'll say whatever you want!" [18:01] "i'm the twin sibling" [18:01] :D [18:02] then you can get your lawyer to ask the cop in court: "do you recall my client insisting that you stop beating them?" [18:04] and you can get into word play like "did you or did you not *stop* beating my client?" .. "well I wasn't beating him to beg.." .. "if you weren't beating my client then you couldn't stop beating my client. I ask again, when my client requested that you stop beating them did you *stop*?" [18:05] "well, no, in that case then I didn't stop".. "no further questions mlud" [18:05] diddledan: I'm Donald Trump's son (Althought personally I'd be the one researching time travel to make sure his parents had access to birth control [18:06] hmmh, probably needed a ' " ' before that [18:08] I knew that was something off about you [18:12] daym it's 76 deg F / 24.5 deg C here at 7pm, so not used to it [18:21] ok install done, just running update [18:28] "Explaining Computers .com : Quantum Computing update 2017": https://www.youtube.com/watch?v=iYESkqXVWa0 [19:04] wow that was fast [19:05] :> [19:05] i just typed sudo reboot on the server and it shuts down super quick [19:05] yip benefits of stripping the cruft away [19:06] :) [19:16] if i want to make the console font bigger i edit /etc/default/grub [19:17] the line #GRUB_GFXMODE=640x480 does the # indicate a comment [19:18] yep [19:18] so if i remove the comment it enables that line [19:18] i've never done that though so can't comment on that being all you need [19:19] ok [19:19] yeah, then running "sudo update-grub" iirc [19:19] i love native resolution TTYs :> [19:20] yeah update grub [19:21] soothing green text on black console... nowt like it... [19:22] i just want the font size a bit bigger [19:22] but yeah green on black would be good [19:23] this IS a console though not a terminal window [19:23] i'd just get a static IP on, openssh-server, then it doesn't matter after that [19:24] i have server on a 2nd monitor, which is right next to my other monitor for this PC [19:24] once it is set up, i'll use a terminal but if i switch back to using a monitor it would be nice to have the right resolution [19:24] *nod* [19:37] i think i have sorted it [19:37] i need to put in a new vgacable too, this is making my screen look blue [19:37] ooh analog, retro [19:38] well the monitor does have dvi [19:38] check you haven't bent a pin if it looks blue... [19:38] i think the cable is dodgy [19:38] as if I wiggle the cable, the colour sorts itself out [19:38] yip sounds wonky [19:39] i have a few spare vga cables [19:39] if not here, in the tech jam kit boxes [19:48] ok so what do i need to install a basic mariaDB server and start it up when i want to, [19:48] as in manually [19:51] no idea off the top of my head, but "apt-cache search mariadb" should give the answer to the relevant package [19:51] sudo apt install mariadb-server [19:52] shh diddledan, teach a person to fish... [19:59] ...watch sales of fishfingers plummet? [20:00] ? [20:00] :D [20:01] ok the website for mariadb has a how to, it has a 404 on how to get started [20:01] i was suggesting it made more sense to tell you the 'how' and not the exact package [20:10] sudo make me a sammich! [20:11] has anyone actually seen toaster66 say anything? [20:12] I think we should kickban people when they hang around for years without a single utterance [20:12] if they ever did i think one of us would have noticed... [20:12] I mean like weeks is ok to be silent, but years?! [20:13] might be a silent order of electronic monk... [20:13] lol [20:13] although there are a few channels that I idle in and never utter a word I guess [20:13] I should probably cull a few [20:15] but... but somebody might say something life changing in that channel tomorrow.... [20:33] ok i am mega stuck here [20:33] i keep finding systemv tutorials for the permissions [20:33] i can only run mysql as sudo [20:34] systemV tutorials? [20:34] well this seems to refer to systemv stuff rather than systemd related things [20:34] what does? [20:34] the tutorial i have for setting up mysql [20:35] or mariadb [20:35] but it uses the mysql command [20:35] install mariadb-server. done. [20:35] that didn't set up a user [20:35] it just installed, so i am now trying to figure out what to do [20:35] it set up a root user [20:35] ok [20:36] it's up to you to set up any additional users you require [20:36] i am trying to find a tutorial for that [20:36] google for GRANT [20:36] http://www.yolinux.com/TUTORIALS/LinuxTutorialMySQL.html [20:36] i did [20:36] i got one that covered windows [20:37] mariadb works the same on windows as it does on linux [20:37] I am using the command line [20:37] excepting linux-specific auth via socket if you set it [20:37] what i found had screenshots [20:41] ok simple question should i have to run this as sudo [20:44] I don't know what you're trying to do [20:45] some things need root privileges, yes [20:45] ok so that is normal [20:45] right [20:45] i did the codecademy course on sql [20:45] that covers adding and searching a database [20:45] i want to set up mariadb so i have a proper db t experiment with [20:46] i just want a simple tutorial to get started with [23:33] ...and that's why i only provide support for dbase iii+ these days... :-) [23:35] dbase iii+ ftw [23:36] none of that namby pamby wishy washy dbase iv silliness... [23:46] ahh happy days [23:46] I once had to write a migration script in dbase iii+ for a boutique hotel in kightsbridge. Think this was when new London phone numbers came in. [23:47] It took 20 mins to write the update script, then spent 3 hours making it look pretty with ETA and percentage bars and stuff [23:48] it was scarily accurate too. running on some manky old dos pc in their hotel back office took an age, but ended exactly when I said it would :) - and the data was right first time which was a bonus ;) [23:48] a done bar that was accurate... and ms didn't put a bounty on your head?! :-P [23:49] http://www.capitalhotel.co.uk pretty sure it was that place [23:49] I was very much out of place there :) [23:51] my boss once drunk after a rugby match staggered back late to his hotel. and with no one on the counter while he waited noticed they had the novell server screen and keyboard on the desk by their reservation computer... so he leaned over and typed :server down giggled and waited for his key... [23:51] hah [23:51] Novel netware, also happy days [23:52] next morning woke up, went down to check out and found technicans frantically checking everything... guilt kicking in he announced he was a server specialist and offered to help and quickly brought the server back up [23:52] :) [23:53] drunk techs.... an evil combo.... [23:56] Hi, I am struggling to auto-connect on startup to my VPN connection. I see that I can enable it on the wired internet connection, but then it doesn't auto-connect on startup - which is quite important to me. Is there a solution?