Arch Linux

Flavoured-Goo

Member

Registered: 2020-08-17

Posts: 31

Re: [SOLVED] XAMPP and Mariadb

@loqs

"stat /opt/lampp/var/mysql/" yields:

"
  File: /opt/lampp/var/mysql/
  Size: 4096          Blocks: 8          IO Block: 4096   directory
Device: 805h/2053d    Inode: 36702799    Links: 6
Access: (0755/drwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2020-08-19 02:50:26.000000000 +0530
Modify: 2020-08-19 02:50:44.242566237 +0530
Change: 2020-08-19 02:50:44.242566237 +0530
Birth: 2020-08-19 02:50:26.602567008 +0530
"

starting lampp with lampp start or xampp start or /opt/lampp/lampp start all yield

"
Starting XAMPP for Linux ...
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.

/opt/lampp/bin/mysql.server: line 264: kill: (47243) - No such process
"

Flavoured-Goo

Member

Registered: 2020-08-17

Posts: 31

Re: [SOLVED] XAMPP and Mariadb

So installing directly from apachefriends.org seems to work like a charm. I didn't bother with the UID mismatch workaround because I'd rather not use a broken AUR build. Marking as [SOLVED]

loqs

Member

Registered: 2014-03-06

Posts: 17,438

Re: [SOLVED] XAMPP and Mariadb

Please leave a message on the xampp package page on AUR about your issue linking to this thread.

Flavoured-Goo

Member

Registered: 2020-08-17

Posts: 31

Re: [SOLVED] XAMPP and Mariadb

Alright will do

Flavoured-Goo

Member

Registered: 2020-08-17

Posts: 31

Re: [SOLVED] XAMPP and Mariadb

Can you create the mysql database using:

		mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Although personally I would recommend using apache ,  mariadb,  php from the official repositories.

I think the suggestion to use apache, mariadb and php from the official repositories is the best too now. XAMPP doesn't feel very well integrated.

Trilby

Inspector Parrot

Registered: 2011-11-29

Posts: 29,559

Website

Re: [SOLVED] XAMPP and Mariadb

If you are considering alternatives and are just getting started, I'd strongly encourage you to consider nginx over apache.  I was slow to transition my servers from apache to nginx: I had spent a while learning all the ins and outs of apache and didn't want to have to start from scratch.  I really regret not changing sooner: apache works great, but configuring it right can be a lot of work and always seemed a bit obscure / magical to me.  Nginx is trivially easy to configure, and it's relatively easy to understand what it is doing.

Nginx also seems (IMHO) to be much more flexible: there were times in using Apache when I struggled to have different services or options running concurrently: conceptually it was a bit like applying conflicting patches to source code, each could "just work" as documented on their own, but when you put them together a lot of manual adjustment is needed.  With nginx it's simple and perfectly clear how to have different subdomains or even paths serving different varieties of content.

Last edited by Trilby (2020-08-20 12:31:54)

---

"UNIX is simple and coherent..." - Dennis Ritchie, "GNU's Not UNIX" -  Richard Stallman

grufo

Member

Registered: 2012-08-09

Posts: 100

Re: [SOLVED] XAMPP and Mariadb

I have done a general cleanup of the xampp package on AUR. Everything should work like a charm now.

--grufo

loqs

Member

Registered: 2014-03-06

Posts: 17,438

Re: [SOLVED] XAMPP and Mariadb

I have done a general cleanup of the xampp package on AUR. Everything should work like a charm now.

--grufo

Thank you for the cleanup.
You can use systemd-sysusers to create system users and systemd-tmpfiles to change directory ownership rather than doing it in the .install.

Last edited by loqs (2020-09-17 17:07:30)

grufo

Member

Registered: 2012-08-09

Posts: 100

Re: [SOLVED] XAMPP and Mariadb

You can use systemd-sysusers to create system users and systemd-tmpfiles to change directory ownership rather than doing it in the .install.

That is great! I did not know systemd-sysusers and systemd-tmpfiles were a thing.

Package updated.

Thank you