#archlinux32 | Logs for 2018-04-13

[02:22:36] <buildmaster> libgit2 is broken (says rechenknecht).
[03:08:33] -!- Cthulu201 has joined #archlinux32
[03:52:52] <tyzoid> hey Cthulu201
[03:53:07] <tyzoid> didn't notice you joined :P
[04:45:29] -!- Mart|n has quit [Remote host closed the connection]
[04:50:23] -!- Mart|n has joined #archlinux32
[07:09:11] <girls> tyzoid: cname is set
[07:46:54] -!- oaken-source has joined #archlinux32
[07:56:47] -!- abaumann has joined #archlinux32
[07:57:46] <abaumann> City-busz: libreoffice would solve bug FS32#6, right?
[07:58:33] <abaumann> City-busz: I removed bluegriffon from the blacklist.
[08:03:49] <City-busz> It allows to launch LibreOffice Writer without a crash by default, but LibreOffice still crashes if the user installs any Java extension on first load.
[08:04:09] <City-busz> It is reported also in Fedora, they think that it's a kernel bug: https://bugzilla.redhat.com
[08:07:12] -!- oaken-source has quit [Ping timeout: 260 seconds]
[08:07:18] <abaumann> Fedora mentions a Debian fix: https://bugs.debian.org
[08:07:28] <abaumann> maybe we could try this one?
[08:08:39] <City-busz> yes, we could try it
[08:08:46] <abaumann> I just feel, that the JVM should stop playing funny tricks which are crashing in the kernel. IMHO this is hardly the kernels fault..
[08:08:53] <abaumann> *with
[08:09:58] -!- davor has quit [Ping timeout: 264 seconds]
[08:15:48] <City-busz> here is the Debian patch: https://salsa.debian.org
[08:16:24] -!- davor has joined #archlinux32
[08:18:24] <abaumann> Ah, the Debian patch does the same as the kernel parameter "stack_guard_gap=1"
[08:20:08] <abaumann> mmh. the fix cannot possibly know that it's the JVM, so it changes the behaviour for all processes.
[08:23:45] <abaumann> tyzoid: on bugs.archlinux32.org I sometimes get: "Completely unexpected exception: Connection to Timed Out This should never happend, please inform Flyspray Developers".
[09:03:42] -!- titus_livius has joined #archlinux32
[09:06:43] * buildmaster resumes sanity.
[09:07:35] -!- oaken-source has joined #archlinux32
[09:19:37] <abaumann> girls: in the buildmaster on the broken package list I cannot see and download links anymore for logfiles of failed packages..
[09:19:50] <deep42thought> oh
[09:19:51] <deep42thought> my bad
[09:21:00] <deep42thought> I moved all the php files to a different host (tyzoid's), and broke all the links ...
[09:27:53] <abaumann> no problems. migrations are like this. :-)
[09:28:04] <girls> (file_exists("/srv/http/build-logs/error/".$last_log))
[09:28:05] <girls> hah
[09:28:12] <girls> this obviously won't work :-D
[09:28:18] <abaumann> :-)
[09:28:33] <girls> ok, I'll just add links
[09:28:37] <girls> no matter if the log still exists
[09:28:57] <abaumann> yeah. broken links don't matter there.
[09:29:47] -!- oaken-source has quit [Ping timeout: 245 seconds]
[09:31:40] <abaumann> me have logs. me happy. thanks :-)
[09:31:57] <girls> :-)
[09:32:39] <abaumann> the reason is: I'm downloading all logfiles of the bugs I'm inspecting. So I get a repository of the things I did in the past.
[09:33:00] <girls> you must have a huge disk ;-)
[09:33:18] <abaumann> so far it's 35 MB.
[09:33:23] <abaumann> not that many bugs..
[09:33:39] <deep42thought> I'd say, you fixed ~80% of all bugs ...
[09:34:10] <abaumann> not sure about that.. you also fix a lot..
[09:34:33] <deep42thought> yeah, but just the trivial stuff ;-)
[09:34:57] <abaumann> speaking of bugs: FS32#6, libreoffice, I summorized all options. I saw, you patched libreoffice to not use those plugins.
[09:35:15] <deep42thought> City-busz's suggestion
[09:35:19] <abaumann> yes.
[09:35:31] <abaumann> and the things mentioned at Fedora and Debian on the topic.
[09:36:03] <abaumann> I don't feel comfortable with fixing the kernel in such a way, just to please a OpenJDK/libreoffice corner case.
[09:36:05] <deep42thought> feel free to apply those patches - if it helps something
[09:36:15] <deep42thought> ah, it's a kernel patch???
[09:36:17] <deep42thought> hmm
[09:36:30] <deep42thought> we should introduce linux-libre
[09:36:36] <abaumann> The Archlinux way (at least as I understood it) is in case of doubt, stick to Vanilla and don't go for featuritis and patchitis.
[09:36:52] <deep42thought> yes
[09:37:18] <deep42thought> I assume, kernel devs are aware of that patch?
[09:37:40] <deep42thought> In that case, they'll have a good reason not to implement it (if it's not in the vanilla kernel)
[09:37:49] <abaumann> No clue. But I guess the kernel option "stack_guard_gap=1" is there for a reason. :-)
[09:37:50] <deep42thought> so we should not implement it either
[09:38:01] <deep42thought> hmmm
[09:38:16] <abaumann> The patch is just hard-patching the option above.
[09:38:28] <deep42thought> ah, ok
[09:38:34] <abaumann> And as I see it, it applies to all processes, not just to the OpenJDK VM.
[09:38:46] <deep42thought> so the fix for libreoffice is putting "stack_guard_gap=1" into your boot options?
[09:38:50] <abaumann> Java was always it's own operating system, at least mentally. :-)
[09:38:55] <abaumann> no.
[09:39:09] * deep42thought feels dumb
[09:39:15] <abaumann> people how wanted to use the plugins in libreoffice would have to boot with this boot option.
[09:39:25] <deep42thought> that's what I meant
[09:39:37] <abaumann> I guess, you get a lot of bug reports, if you go that way. :-)
[09:39:44] <deep42thought> "you" = "the one who wants to have working libreoffice plugins"
[09:39:54] <abaumann> yes. that 'you'
[09:40:00] <abaumann> the general you. :-)
[09:40:22] <abaumann> I'm fine with disabling the plugins, I didn't even find out, what they did exactly..
[09:40:26] <deep42thought> but I don't see a reason to patch anything
[09:40:33] <abaumann> exactly
[09:40:34] <deep42thought> just close the fs bug with this explanation
[09:40:36] <deep42thought> and done.
[09:40:39] <abaumann> ok.
[09:42:08] <abaumann> aha. still hickups on bugs.archlinux32.org, but you can post, then the timeout error happens.
[09:45:22] -!- eduardoeae has quit [Ping timeout: 264 seconds]
[09:54:17] <deep42thought> tyzoid: community-testing and community-staging are missing from your package interface
[09:54:25] <deep42thought> I only get 404's on packages in these repositories
[10:26:32] <deep42thought> also it would be nice to get makedepends information from your frontend, but I think, that information is not in the package anymore :-/
[11:12:17] -!- deep42thought has quit [Quit: Leaving.]
[11:17:00] -!- abaumann has quit [Quit: leaving]
[11:29:14] -!- belanthor has joined #archlinux32
[11:50:16] -!- eduardoeae has joined #archlinux32
[12:41:42] -!- oaken-source has joined #archlinux32
[13:22:35] -!- deep42thought has joined #archlinux32
[13:33:07] <deep42thought> tyzoid: nvm my request for makedepends - I'll simply query the missing information from the mariadb
[13:36:39] <tyzoid> abaumann: I think it's related to not having email set up on the new bugtrackers
[13:36:53] <tyzoid> but I didn't think it needed email for everything
[13:37:10] <tyzoid> deep42thought: I can take a look at putting it in the api, if you think it'd be helpful in general
[13:37:23] <deep42thought> there is too much stuff missing anyway
[13:37:24] <tyzoid> Need to figure out the pacman command
[13:37:32] <deep42thought> e.g. there are no repositories given for the dependencies
[13:37:52] <deep42thought> so I'll need to query mariadb in parallel anyway
[13:38:24] <deep42thought> plus: It's a nice check, that the package _content_ is actually consistent with the buildmaster's database
[13:38:27] <tyzoid> hmm, both community-testing and community-staging are set to be included
[13:38:51] <deep42thought> capitalization?
[13:39:04] <deep42thought> all minor letters?
[13:39:28] <tyzoid> all lowercase
[13:39:32] <deep42thought> hmm
[13:39:46] <City-busz> deep42thought: the gnome-desktop thumbnailer currently fails to work on i686. It seems that we have to remove this one line: https://git.gnome.org
[13:40:01] <City-busz> Could you apply this patch for gnome-desktop? Currently I don't have a powerful PC to build and test it. http://pkgbuild.com
[13:41:01] <deep42thought> why does upstream do this?
[13:41:22] <deep42thought> maybe we should link /usr/lib64 to /dev/null ;-)
[13:42:26] <deep42thought> City-busz: so this needs to be applied on gnome-desktop?
[13:43:31] <City-busz> they forget that not all system have /lib64 when they applied this change: https://git.gnome.org
[13:44:16] <City-busz> yes, the patch should fixes the thumbnailer I think. Currently Nautilus fails to generate any thumbnails due to this bug in gnome-desktop
[13:44:26] <deep42thought> ok
[13:44:35] <deep42thought> but I think, this is something upstream should fix
[13:44:42] <deep42thought> but for now, I can include the fix
[13:45:00] <deep42thought> (upstream = gnome)
[13:50:42] <deep42thought> tyzoid: https://pkgapi.arch32.tyzoid.com
[13:50:55] <deep42thought> https://pkgapi.arch32.tyzoid.com
[13:51:00] <deep42thought> sry, typo
[13:51:34] <deep42thought> maybe it hicks up on the hyphen?
[13:55:41] <tyzoid> deep42thought: Fixed
[13:55:49] <deep42thought> \o/
[13:55:50] <deep42thought> thanks!
[13:56:14] <tyzoid> had an overly-restrictive regex that errored on repo-names with hyphens
[13:56:22] <deep42thought> :-)
[13:58:07] <tyzoid> if abaumann comes back, you can tell him I "fixed" the bugtracker
[13:58:14] <tyzoid> by disabling email notifications temporarily
[13:58:17] <deep42thought> hehe
[13:58:18] <deep42thought> lol
[13:59:00] <tyzoid> anyway, be back in ~1hr
[13:59:07] <deep42thought> cu later
[14:33:59] <eschwartz> City-busz: lol, the linked bug for thumbnailer indicates they were told it is broken on i686 since December 28 but no activity
[14:34:14] <deep42thought> great
[14:34:18] <deep42thought> but at least, they know
[14:34:31] <eschwartz> They just said "oh, bwrap bug, it shouldn't fail"
[14:34:50] <eschwartz> No linked bug for beeap to fix bwrap...
[14:34:57] <eschwartz> *bwrap
[14:35:12] <deep42thought> bwrap?
[14:35:32] <eschwartz> The thingy it uses to sandbox the thingy
[14:43:47] <eschwartz> City-busz: maybe discuss this with the bubble wrap people?
[14:44:18] <eschwartz> Lol, I'm just waiting to hear "we did that deliberately"
[14:48:43] <eschwartz> May have misread that, maybe they just wanted a separate internal bug for thumbnailer breaking due to depending on undefined behavior
[14:49:04] <eschwartz> Why they're incapable of opening the bug themselves I do not know
[14:53:37] -!- Khorne has joined #archlinux32
[14:55:51] -!- Khorne has parted #archlinux32
[15:06:17] * buildmaster goes insane.
[15:10:27] -!- mohsen_1 has joined #archlinux32
[15:11:39] -!- mohsen_1 has parted #archlinux32
[15:14:14] * buildmaster resumes sanity.
[15:26:22] -!- Scorpion26 has joined #archlinux32
[15:26:41] <Scorpion26> hello and good morning yall!!!!
[15:26:53] <deep42thought> Hi!
[15:28:26] <Scorpion26> so question? i installed arch32 last night which is not my first time. and i installed chromium. i went to open it and it wouldn't open any help would be awesome
[15:29:17] <tyzoid> do you get any errors when running it from the console?
[15:29:52] <deep42thought> I think, chromium needs sse2 - does your cpu have that?
[15:30:04] <deep42thought> e.g. what does "grep sse2 /proc/cpuflags" give you?
[15:32:15] <Scorpion26> error while loading shared libraries: libicui18n.so.60:
[15:32:32] <tyzoid> buildmaster: wtf libicui18n.so.60
[15:32:38] <buildmaster> Huh, I don't know that one.
[15:32:58] <deep42thought> it's from icu-60
[15:33:18] <tyzoid> is the new chromium still in testing?
[15:33:32] <deep42thought> staging O.o
[15:33:36] <deep42thought> https://packages.archlinux32.org
[15:33:36] <tyzoid> ah
[15:33:44] <Scorpion26> when i installed arch before and used chromium on it i never had this problem and i did everything the same
[15:34:18] <tyzoid> scorpion26: No, it's an issue on our end
[15:34:25] <tyzoid> try installing this package: https://archive.archlinux32.org
[15:34:25] <deep42thought> let me move it ...
[15:34:29] <tyzoid> or that ^
[15:34:44] <deep42thought> ... now in [testing] :-D
[15:34:51] <deep42thought> ... let me move it further ...
[15:35:09] <tyzoid> Scorpion26: What mirror are you using?
[15:35:29] <Scorpion26> official
[15:35:38] <deep42thought> which one?
[15:35:40] <tyzoid> ^
[15:35:45] <deep42thought> there are multiple official ones
[15:35:50] <Scorpion26> ummmmmmm?
[15:35:53] <deep42thought> :-D
[15:35:58] <tyzoid> can you post your /etc/pacman.d/mirrorlist ?
[15:36:10] <Scorpion26> just a sec
[15:36:25] <tyzoid> deep42thought: Can we add a paste command to buildmaster which does the same as !ptpb?
[15:36:32] <eschwartz> Presumably all mirrors are officially mirrors no matter who operates them :)
[15:36:55] <deep42thought> or we get phrik in here
[15:36:57] <tyzoid> "official" is a relative term for a community-led fork
[15:37:03] <deep42thought> so we do not need to reimplement every feature
[15:37:04] <eschwartz> Could ask an op to invite phrik here
[15:37:12] <deep42thought> ... I really like the quotes one ;-)
[15:37:12] <Scorpion26> Server = https://32.arlm.tyzoid.com
[15:37:12] <Scorpion26> Server = https://mirror.math.princeton.edu
[15:37:17] <eschwartz> Ask tigrmesh or someone
[15:37:29] <tyzoid> deep42thought: Did that package make stable?
[15:37:37] <deep42thought> it's on its way
[15:38:05] <tyzoid> scorpion26: 32.arlm.tyzoid.com will get that package pretty much immediately after it gets put into stable.
[15:38:40] <tyzoid> So if you wanted to wait until it gets put in stable, a pacman update will fix that in a few minutes here.
[15:38:48] <Scorpion26> do u have an idea when that will be by chance?
[15:38:53] <deep42thought> ok, should be there
[15:38:56] <tyzoid> in a few minutes
[15:38:58] <tyzoid> or now
[15:38:59] <tyzoid> lol
[15:39:01] <Scorpion26> oh ok
[15:39:04] <Scorpion26> lol
[15:39:23] <tyzoid> yup, mirror just got it
[15:40:32] <tyzoid> thanks eschwartz
[15:40:35] <Scorpion26> i have only been using linux for about 5 months used many distros and then i saw a vid on youtube about arch and went to the arch32 website to investigate and i was hooked
[15:40:43] <tyzoid> :)
[15:42:41] <tyzoid> scorpion26: Can you confirm for us that the update worked as expected?
[15:42:46] <eschwartz> o_O what did I do
[15:42:53] <tyzoid> told me who to ask
[15:43:00] <deep42thought> um
[15:43:09] <deep42thought> tyzoid: you're not asking in parralel to me, are you?
[15:43:10] <Scorpion26> so im kinda learning as im going so please forgive me if i seem a little slow to catch on
[15:43:19] <eschwartz> Lol
[15:43:34] <tyzoid> deep42thought: No, I did not ask yet
[15:43:34] <deep42thought> Scorpion26: np, we all started as noobs
[15:43:37] <Scorpion26> houston we have contact!!!!!!! lol
[15:43:53] <deep42thought> ... or at least _I_ did ...
[15:44:12] <tyzoid> lol. I was born with 25 years of unix experience.
[15:44:27] <Scorpion26> i know arch is not a place a person should learn linux but i really liked what arch has to offer and the custimisation
[15:44:40] <deep42thought> Scorpion26: why not?
[15:44:41] <tyzoid> scorpion26: It's a great place for people to learn linux
[15:44:45] <tyzoid> it just takes more investment
[15:44:48] <deep42thought> ^
[15:44:51] <deep42thought> exactly
[15:44:53] <City-busz> eschwartz: I don't know if it's a bug in bubblewrap (does not allow non-existing bind mounts) or a bug in gnome-desktop (tries to bind mount a non-esistent directory)
[15:45:11] <deep42thought> City-busz: open a bug in both then ;-)
[15:45:27] <Scorpion26> alot of people have told me to stay away from arch till i have atleast a year of linux under my belt
[15:46:00] <Scorpion26> see i love a challenge that's why when i was 17 i joined the marines
[15:46:56] <eschwartz> City-busz: the bwrap manpage does not say it gracefully ignores...
[15:46:57] <Scorpion26> and i built my first computer when i was 12 so i know hardware and i had always been interested in software
[15:47:05] <eschwartz> I say it is a thumbnailer bug
[15:47:40] <eschwartz> But my current take is that the gnome drvs won't bother tracking the hug and fixing it unless someone else submits a new ticket
[15:47:48] <eschwartz> *devs
[15:47:52] <eschwartz> *bug
[15:48:13] <Scorpion26> now in the update i seen there was an update to cairo is that cairo dock
[15:48:14] <eschwartz> Auto-incorrect :)
[15:48:48] <deep42thought> eschwartz: maybe, they won't track hugs either ;-P
[15:49:04] <eschwartz> Are they BSD
[15:49:04] <tyzoid> scorpion26: `pacman -Si cairo` give you info about a package
[15:49:26] <tyzoid> or use -Qi instead of -Si for info about the locally-installed version
[15:50:17] <Scorpion26> ok was just curious
[15:50:41] <eschwartz> So you asked tigrmesh? What did she say
[15:50:52] <deep42thought> nothing yet
[15:51:02] <tyzoid> Scorpion26: No problem. It's good to know where you can look for info.
[15:51:10] <tyzoid> Btw, my first arch install took about 20 hours to get right.
[15:51:20] <tyzoid> Now I'm at a point where I can do a custom install in ~10minutes
[15:51:42] <Scorpion26> my first install took two months to get it right.
[15:51:43] <tyzoid> (I've got a private video on youtube showing me setting up a machine that auto-boots to netflix in ~10minutes)
[15:51:47] <eschwartz> Pfft, you must not cache packages right
[15:51:52] <deep42thought> a man page a day keeps the cluelessness away
[15:52:12] <tyzoid> yup, lol
[15:52:47] <tyzoid> deep42thought: Only three things left to migrate. *yay*
[15:52:48] <tyzoid> https://srv0.tyzoid.com
[15:52:55] <tyzoid> ZNC is the big one
[15:53:02] <deep42thought> znc :'-(
[15:53:24] <Scorpion26> see i had to video cards one was on board intel and the other was agp nvidia. so i eventually had to remove the nvidia card cuz i couldn't get it to work and i can only use xfce d.e.
[15:53:25] <tyzoid> deep42thought: Well you know me and my commitment to uptime
[15:53:40] <deep42thought> I do
[15:53:51] <tyzoid> In theory you won't notice anything :P
[15:54:52] <deep42thought> https://www.xkcd.com
[15:55:03] <Scorpion26> i wish i could of got that nvida card working with arch cuz i would really like to use kde
[15:57:01] <Scorpion26> anyone have any experience getting older nvidia video cards working with arch?
[15:57:48] <tyzoid> scorpion26: What card is it?
[15:58:01] -!- isacdaavid has joined #archlinux32
[15:58:26] <Scorpion26> nvidia geforce fx 5200
[15:58:37] <Scorpion26> agp
[15:59:15] <Scorpion26> worked really well out of the box with mx-17 and other distros
[15:59:20] <tyzoid> scorpion26: https://wiki.archlinux.org
[15:59:32] <tyzoid> Says you need to install https://aur.archlinux.org
[16:01:53] <Scorpion26> ok this might sound stupid but but how do i go about downloading aur packages cuz i tried installing yaurt so i could install google-chrome but it wouldn't let me install yaourt
[16:02:14] <tyzoid> scorpion26: https://wiki.archlinux.org
[16:02:18] <deep42thought> before using yaourt, it's best to try it manually
[16:02:28] <deep42thought> just so you see what the caveats are
[16:02:43] <tyzoid> City-busz: You wouldn't happen to have a binary repo with that package, would you?
[16:05:55] <tyzoid> just checked, his repo doesn't have it
[16:06:07] <deep42thought> I think, mine has
[16:06:34] <deep42thought> http://arch.eckner.net
[16:06:37] <deep42thought> well, my mirror has
[16:06:47] <tyzoid> deep42thought: I meant the nvidia-173xx package :P
[16:06:47] <deep42thought> ah no
[16:06:51] <deep42thought> that one won't work
[16:06:55] <deep42thought> oops
[16:06:57] <deep42thought> :-D
[16:08:04] <Scorpion26> sorry i was reading the arch wiki on nvidia
[16:08:27] <tyzoid> np
[16:09:46] <Scorpion26> deep42thought: are u talking about the package for my vid card
[16:09:57] <deep42thought> no, I meant yaourt
[16:10:09] <deep42thought> but I believe, the yaourt from archlinuxfr won't work
[16:10:18] <deep42thought> but I haven't tested, actually
[16:11:47] <tyzoid> Scorpion26: You should read up on the AUR and understand how it works before you use helpers
[16:11:55] <tyzoid> that way, if you encounter an issue, you can fix it
[16:12:10] <tyzoid> That said, I have a very minimal helper script that I wrote, if you're interested
[16:12:11] <tyzoid> https://dl.tyzoid.com
[16:12:19] <tyzoid> requires the installation of wget
[16:12:43] <City-busz> tyzoid: I recently removed nvidia-173xx-dkms from my repo, because I had to fix the kernel module on every major update of linux, and I'm not interested in fixing it anymore
[16:12:50] <deep42thought> tyzoid: why don't you use curl?
[16:12:52] <deep42thought> that's in base-devel
[16:13:10] <tyzoid> deep42thought: Because I haven't changed it yet
[16:13:19] <tyzoid> xD
[16:16:38] <Scorpion26> what's the helper script for exactly?
[16:16:47] <tyzoid> installing packages from the AUR
[16:16:52] <Scorpion26> ok
[16:19:26] <tyzoid> *oops*
[16:19:45] <deep42thought> tyzoid: is it possible to retrieve tree-like structures easily from mysql via php?
[16:19:50] <deep42thought> (two levels only)
[16:20:26] <tyzoid> lol, I accidently broke pool.mirror.archlinux32.org with my mirror
[16:20:31] <tyzoid> deep42thought: What do you mean?
[16:20:49] <tyzoid> You mean where one record informs the selection of another
[16:20:51] <tyzoid> ?
[16:21:45] <deep42thought> I'd like to retrieve records like { a: x, b: {c: y; d: z}; e: u}
[16:22:05] <deep42thought> so I have {a: x; b: id; e: u} in one table
[16:22:35] <deep42thought> and a second table linking "id" to "y" and "z"
[16:23:01] <tyzoid> Is there a reason a join wouldn't work here?
[16:23:05] <deep42thought> my example is a little wrong, but I hope you still get the idea
[16:23:30] <deep42thought> with a join, I get multiple rows, which have identical "a" and "e" part
[16:24:08] <tyzoid> right, well you can't really have arrays with mysql. What you can do is a group_concat and a group by
[16:24:21] <tyzoid> which will turn the non-duplicated fields into comma separated values
[16:24:57] <deep42thought> ok
[16:25:11] <deep42thought> and is there a way in php to "collapse" the array afterwards?
[16:26:03] <tyzoid> Yes, but it depends on which approach you take, whether you want to leave the duplciates and fix it in PHP, or fix the duplicates in sql and expand in PHP
[16:26:20] <tyzoid> I'd recommend the second one, fewer rows is almost always better for performance
[16:27:03] <deep42thought> but I need the flattened list of those unique-by-definition entries, too
[16:27:11] <deep42thought> and I get that with my current join
[16:27:13] <Alina-malina> hey tyzoid deep42thought howdy guys? I have a question, how to make syslog-ng to autostart on boot? I have to start it each time manually
[16:27:26] <tyzoid> Is there not a systemd service file for it?
[16:27:41] <tyzoid> deep42thought: Let me write up an example to show you
[16:27:55] <deep42thought> I think, I understand already
[16:29:42] <deep42thought> oh, there is even JSON_ARRAYAGG
[16:32:06] <tyzoid> deep42thought: http://www.sqlfiddle.com!9/dc5e4a/1
[16:32:17] <tyzoid> The second example is the group_concat
[16:32:29] <tyzoid> then you can just loop through and explode(',' $row);
[16:32:30] <Scorpion26> once i git clone https://aur.archlinux.org what do i do with it
[16:33:10] <Scorpion26> do i have to mkpkg
[16:33:17] <deep42thought> Scorpion26: makepkg
[16:33:28] <Alina-malina> strange, because when i am trying to enable it says: Failed to enable unit: Unit file syslog-ng.service does not exist. but when i just tyle syslog-ng it starts
[16:33:31] <deep42thought> but I recommend reading its man page first
[16:33:37] <Alina-malina> type*
[16:33:57] <deep42thought> Alina-malina: then it does not ship with a systemd unit file
[16:34:11] <deep42thought> tyzoid: I don't see anything there :-/
[16:35:32] <eschwartz> Scorpion26: mkpkg is a wrapper script only available on archlinux private build servers, which literally calls extra-x86_64-build and then copies the results to ~/public_html
[16:35:41] <eschwartz> :p
[16:36:09] <eschwartz> Makepkg on the other hand has actual vowels
[16:38:24] <Scorpion26> ok so once i have the git clone i makepkg -si?
[16:38:43] <deep42thought> yews
[16:38:44] <deep42thought> yes
[16:39:05] <Scorpion26> just making sure im understanding what im reading
[16:40:13] <Scorpion26> after that it says resolve the dependencies with pacman. not sure what there refering
[16:41:44] <Scorpion26> ==> ERROR: PKGBUILD does not exist.
[16:41:44] <Scorpion26> ==> ERROR: An unknown error has occurred. Exiting...
[16:42:10] <deep42thought> that means, you're running it in the wrong directory
[16:42:52] <Scorpion26> scratching my forehead.....lol
[16:43:17] <Scorpion26> oh wait i have to run sudo don't i.....lol
[16:43:28] <deep42thought> no
[16:43:32] <deep42thought> only for installation
[16:43:37] <deep42thought> not for building
[17:01:07] -!- isacdaavid has quit [Quit: Leaving.]
[17:05:17] -!- deep42thought has quit [Quit: Leaving.]
[17:21:20] <tyzoid> scorpion26: After you git clone, you need to cd into the directory
[18:15:04] <Scorpion26> ok
[18:17:53] -!- belanthor has quit [Quit: Leaving]
[18:22:28] <Scorpion26> ==> Making package: nvidia-173xx-utils 173.14.39-5 (Fri Apr 13 16:20:27 UTC 2018)
[18:22:28] <Scorpion26> ==> Checking runtime dependencies...
[18:22:28] <Scorpion26> ==> Installing missing dependencies...
[18:22:28] <Scorpion26> error: target not found: xorg-server<1.15.99
[18:22:28] <Scorpion26> ==> ERROR: 'pacman' failed to install missing dependencies.
[18:23:14] <tyzoid> City-busz: Does Scorpion26 need to downgrade xorg-server?
[18:23:22] <Scorpion26> does that mean in order to use the nvidia vid card i have to downgrade my xorg
[18:23:44] <Scorpion26> if so i have no idea how to do that
[18:23:50] <tyzoid> It could be, or it could be that you can remove the version requirement
[18:24:00] <tyzoid> if you edit the pkgbuild, you can look and remove the version
[18:24:05] <tyzoid> see if it builds
[18:37:57] <Scorpion26> ==> ERROR: depends should be an array
[18:37:57] <Scorpion26> ==> ERROR: An unknown error has occurred. Exiting...
[18:38:31] <Scorpion26> that's after i remove the xorg-server version
[18:42:57] <tyzoid> sounds like you changed something else. Can you post the edited version of your pkgbuild file?
[18:43:06] <tyzoid> use something like https://ptpb.pw
[18:44:32] <Scorpion26> im using leafpad
[18:48:36] <Scorpion26> if i wanted to look at the pkgbuild file from terminal how would i do that so that i can paste it using that website u gave me
[18:49:29] <tyzoid> the website shows how to send it using curl
[19:02:31] <Scorpion26> https://ptpb.pw
[19:21:52] -!- Scorpion26 has quit [Read error: Connection reset by peer]
[19:24:46] <tyzoid> That's your dmesg
[19:24:48] <tyzoid> I need your pkgbuild
[19:26:41] <tyzoid> girls: you on?
[19:46:06] <tyzoid> girls: bbs32.test has been migrated
[19:46:17] <tyzoid> I put that on the same container running the main forum
[19:46:35] -!- scorpion26 has joined #archlinux32
[19:46:40] <tyzoid> wb scorpion26
[19:46:49] <tyzoid> You pasted your dmesg, I need the pkgbuild
[19:47:12] <scorpion26> sorry thought computer froze but it was mouse batteries
[19:47:20] <tyzoid> lol, no problem
[19:47:54] <scorpion26> ok so instead of puting dmesg put pkgbuild?
[19:48:05] <tyzoid> well, the path to your pkgbuild file
[19:48:18] <tyzoid> or if running it as a command, then you'll need to redirect or cat it
[19:59:04] <scorpion26> "/home/scorpion26/nvidia-173xx-utils/pkgbuild" that is the path but it tells me this "sudo: /home/scorpion26/nvidia-173xx-utils/pkgbuild: command not found
[19:59:06] <scorpion26> date: 2015-03-03T00:05:42.457000+00:00
[19:59:06] <scorpion26> digest: da39a3ee5e6b4b0d3255bfef95601890afd80709
[19:59:06] <scorpion26> long: ANo5o-5ea0sNMlW_75VgGJCv2AcJ
[19:59:06] <scorpion26> short: 2AcJ
[19:59:06] <scorpion26> size: 0
[19:59:07] <scorpion26> status: already exists
[19:59:09] <scorpion26> url: https://ptpb.pw
[19:59:12] <scorpion26> "
[19:59:46] <scorpion26> i tried without sudo and it told me permission denied
[20:02:38] <tyzoid> scorpion26: That paste is blank
[20:03:04] <tyzoid> should be `curl -F c=@/path/to/pkgbuild https://ptpb.pw`
[20:03:10] <scorpion26> yea i know i checked it before i sent it to you
[20:10:42] <scorpion26> i see what i did wrong
[20:10:46] <scorpion26> hold on
[20:18:17] <scorpion26> does normally take a long time for them to build
[20:22:56] <tyzoid> depends on the pacakge
[20:23:03] <tyzoid> I'd imagine nvidia would take some time
[20:24:48] <scorpion26> still compilling
[20:25:24] <tyzoid> I've seen packages take ~30min to compile before
[20:25:25] <tyzoid> just be patient
[20:25:34] <scorpion26> ok
[20:26:56] <scorpion26> the funny thing is i know exactly what i removed from the pkgbuild
[20:45:00] <scorpion26> now i do have a question when it comes to installing.
[20:45:44] <scorpion26> is there a need for swap? and when doing pacstrap do u install anything else besides base and base-devel
[20:52:54] <tyzoid> swap can be useful
[20:53:17] <tyzoid> I always put 8g of swap on most of my systems
[20:53:26] <tyzoid> It's not strictly necessary
[20:53:26] <scorpion26> as far as what? just curious
[20:53:31] <tyzoid> but it can come in handy
[20:53:48] <tyzoid> If you're system runs out of ram, you can run into issues
[20:53:58] <tyzoid> esp. if oom-killer keeps selecting the wrong process
[20:54:15] <scorpion26> i have a 250g hd with 4gb of ram
[20:54:39] <tyzoid> if you've got swap, it (a) gives the kernel a place to put little-used memory / tmpfs usage, and (b) acts as a slower overflow, which would allow you to recover the system before it becomes unusable
[20:55:28] <scorpion26> ok someone from the archlinux forum told me it was only used for hybernation
[20:56:13] <scorpion26> so if i have 4gb of ram i should be using what 6g of swap?
[20:58:36] <scorpion26> i use 100g for my first partition /mnt and at present i have 6gb for swap and the rest of the 250 which i believe is 126 for my /mnt/home partition
[21:03:30] <scorpion26> still haven't finished compiling
[21:07:18] <scorpion26> it's funny tyzoid there is 20 people in here and u and i are the only ones talking
[21:09:25] -!- deep42thought has joined #archlinux32
[21:09:38] <deep42thought> now it's 21 and 3 talking ;-)
[21:09:54] <scorpion26> welcome back deep42
[21:10:33] <deep42thought> scorpion26: some of the "people" in here are just loggers, bouncers or bots
[21:10:45] <deep42thought> so, e.g. girls is my bouncer
[21:10:51] <deep42thought> titus_livius and buildmaster are bots
[21:11:00] <deep42thought> and others have bouncers, too
[21:11:34] * buildmaster failed to execute a mysql query - can you have a look at "tmp.mysql-functions.query.stdin.2018-04-13T21:08:12.HGFpQ2"?.
[21:13:10] <scorpion26> so i have been thinking long and hard about this all day since i got off of work this morning, of redooing my install. when it comes to pacstrap do u recomend just doing base and base-devel and leave it at that or can u install others then too
[21:13:42] <deep42thought> it depends what you want
[21:13:46] <deep42thought> but usually base is enough
[21:13:58] <deep42thought> so "pacstrap" is only there to get you started
[21:14:13] <deep42thought> it installs (almost) everything you need to boot archlinux
[21:14:43] <deep42thought> then you can use your fresh install to install whatever you like (desktop, webserver, browser, music player, ...)
[21:14:58] <deep42thought> or if you know right at the start, you can also let pacstrap install that for you
[21:15:03] <deep42thought> this makes little difference
[21:15:33] <scorpion26> well im using ethernet right now but i have wifi. i use the wifi for my xbox. cuz some people have told me to go ahead and install xorg then too
[21:16:07] <deep42thought> when you know, you'll need it, then you can install it right away
[21:16:38] <deep42thought> my approach is usually: "pacstrap base <packages I know I'll need>" and after boot: "pacman -S <packages I forgot to install>"
[21:17:45] <scorpion26> i have a 250g hard drive partition is /mnt 100g, partition 2 is swap 6g, and 3rd partition is /mnt/home 126g?
[21:18:00] <scorpion26> i have 4g of ram
[21:18:29] <deep42thought> sounds good
[21:19:41] <scorpion26> is ther an easy way to downgrade xorg?
[21:19:57] <deep42thought> have a look in archive.archlinux32.org
[21:20:03] <deep42thought> if the version you need is there
[21:20:09] <scorpion26> for my nvidia vid card driver
[21:20:17] <deep42thought> then you can just download that and install via "pacman -U"
[21:20:50] <scorpion26> ok.
[21:21:00] <deep42thought> but usually a downgrade of such a central package requires a downgrade of other packages
[21:21:10] <deep42thought> and then you easily end up with ~100 packages to downgrade
[21:21:11] <deep42thought> ...
[21:21:17] <scorpion26> i can even express my thanks to the two of you today
[21:21:35] <scorpion26> can't not can
[21:22:23] <scorpion26> xorg and xorg-server and xorg-xinit and xorg-apps?
[21:22:42] <deep42thought> and possibly other xorg-* packages
[21:23:48] <scorpion26> just cuz im cautious, will arch let me know there incompatible?
[21:24:18] <deep42thought> most times: yes
[21:24:21] <deep42thought> but sometimes: no
[21:24:36] <deep42thought> e.g. "partial upgrades" are not officially supported
[21:25:07] <City-busz> scorpion26: you need to downgrade xorg-server-common xorg-server and xf86-input-evdev
[21:25:36] <scorpion26> is that it or will there be more that you know?
[21:25:44] <City-busz> e.g. you can find my old xorg-server1.12 and xf86-input-evdev1.12 packages in AUR
[21:26:12] -!- tigrmesh has joined #archlinux32
[21:26:31] <City-busz> but I recommend to use current xorg-server and the nouveau driver instead
[21:26:53] -!- phrik has joined #archlinux32
[21:27:05] <deep42thought> thanks tigrmesh!
[21:27:12] <tigrmesh> you are welcome :)
[21:28:06] <scorpion26> tigrmesh is the one that pointed me here this morning
[21:28:42] <scorpion26> is that the xf86-video-nouveau
[21:31:18] <scorpion26> now when installing the kde enviroment it's "plasma kde-applications and sddm?
[21:37:27] * buildmaster resumes sanity.
[21:50:45] -!- scorpion26 has quit [Remote host closed the connection]
[21:58:43] -!- oaken-source has quit [Ping timeout: 256 seconds]
[22:34:49] <deep42thought> should we list link dependencies on packages.archlinux32.org?
[22:37:43] <deep42thought> I think, we should :-)
[22:44:46] <tyzoid> deep42thought: That'd be nice
[22:46:49] -!- deep42thought has quit [Quit: Leaving.]
[23:45:07] eschwartz is now known as fingernail
[23:45:45] fingernail is now known as eschwartz
[23:59:18] -!- davor has quit [Ping timeout: 256 seconds]