#Installing MariaDB (10.7.1)

1 messages · Page 1 of 1 (latest)

static wren
#

I'm quite new to Arch so I've been trying to figure this out. Currently running Arch KDE Plasma and I'm trying to install Mariadb 10.7.1, I downloaded it to my Documents folder after getting it off their web page. I would like the software's path to point to it in the Documents folder and to store the database in a subfolder within Documents which is not contained within the software path.

Preferred config:
Software path: /home/bryton/Documents/mariadb-10.7.1
Database path: /home/bryton/Documents/1.20.1 Server/mariadb
host: localhost
port: 3306
user: root
password: MadDog443

dull verge
naive lake
#

Ever heard of packages?

static wren
#

i have to run a very specifc version due to changes to mariadb

naive lake
#

Binaries belong to /bin

#

And u prob have to create a systemd service manually then

dull verge
static wren
#

old, specifically 10.7.1

#

its cause the software that relies on it cannot use newer versions

#

i know you probably shouldnt have something like mariadb installed to documents but id prefer it there as kind of a working directory as this pc does nothing but run a server. which is why i wanted the db location to be hosted within the server files for easy backups and server transfers

naive lake
#

Documents is user space tho

marsh field
dull verge
marsh field
#

.aw downgrade

errant gulchBOT
dull verge
marsh field
static wren
#

could i tell pacman to use the tar.gz i downloaded?

marsh field
#

this way you still use arch but let the debian box container do the db stuff

dull verge
marsh field
#

and thus, no package breakage

#

other people use docker

#

.aw distrobox

errant gulchBOT
marsh field
#

@static wren try with distrobox , setup a debian container as it may use older mariadb and updates way slower and it will be isolated from your arch yet able to integrate

static wren
#

i could run docker for the server but the server is already setup and changing the environment now would be a really big pain.

#

i can hop in vc and stream

marsh field
#

.aw mariadv

errant gulchBOT
marsh field
#

.aw mariadb

errant gulchBOT
marsh field
#

arch can be a server but my advice is to use containers so you avoid breaking it

naive lake
marsh field
#

correct me if I'm wrong

#

and prefer package managers over standalone packages

static wren
#

im not using containers that would be a real pain to setup at this point, mind you i've only been using arch for a week.

#

and this thing is supposed to be as barebones as possible, only reason it has kde is cause i was having trouble at the start figuring out commands in cli

naive lake
marsh field
#

idk if you ever will run a headless server

#

you may have to master terminal if you are making a server

static wren
#

im not bothered by it that much, anyway cant i just stop the services that i had to start to use kde on install and revert back to cli?

marsh field
#

then select the version

marsh field
#

and you may like to learn ssh

#

.aw ssh

errant gulchBOT
marsh field
#

so you login from another pc

static wren
#

thats ok i know that already kinda lol

#

ok preferably id like to just use the package i downloaded already as that would probably be the least problematic for the system since i wouldnt be downgrading.

#

and someone mentioned downgrading can have adverse effects the system

errant gulchBOT
marsh field
#

whatever works for you

naive lake
marsh field
#

dunno if arch updates may break it anyways

static wren
#

does arch auto update stuff?

naive lake
static wren
#

cause i dont run any

#

nor plan to

naive lake
#

but u should update regularly

naive lake
marsh field
#

not updating arch in months is a bad idea

static wren
#

if it works it works, if there is a security update ill probably update then

marsh field
naive lake
marsh field
#

and break mariadb or something

naive lake
#

prob breaking your mariadb

marsh field
#

that's why I suggested arch with a debian distrobox

static wren
#

ngl your opinion on if i should update or not is off topic, so to confirm i need to go look at how to downgrade using pacman right?

marsh field
naive lake
marsh field
#

for servers, static release distros are the recommendation

static wren
#

and downgrade is probably the best option for breaking the least amout of things right?

static wren
naive lake
#

and u need to lock the package

marsh field
#

I mean, yes.. but still...

marsh field
static wren
#

so nagging about it instead of focusing on what im asking is frustrating

#

sorry

marsh field
#

debian seems to offer an older mariadb

#

and since they are not rolling, it should work ootb

#

no updates required nor shenanigans

static wren
# naive lake Dont ask for help then

you ever heard the term too many chefs in the kitchen? im currently being told 3 different solutions by 3 different people, it gets very confusing which plan is the likely one to succeed

marsh field
#

up to you what you do now

static wren
#

alright so if downgrading and locking the package does not work is there any other options besides running a different distro or some container?

naive lake
#

no

marsh field
#

if you still want to stay on arch, distrobox or docker is the way to go

#

tho distrobox may make it ez

#

ik as I used mint as base system then made archbox on top allowing mint to get aur access

#

you can do it the other way around, arch base then debian on top

#

so you use debianbox for your server needs

#

or, just run debian and ask the installer to setup it as a server

dull verge
#

The source is quite large (1.2 GiB), please consider using CI such as github actions or gitlab CI if internet speed is a concern.

static wren
#

i have this

dull verge
#

I am currently building the package on codespace.

marsh field
#

then how about debian container?

static wren
#

oh

dull verge
#
diff --git a/PKGBUILD b/PKGBUILD
index f502188..41d3083 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -4,23 +4,23 @@
 pkgbase=mariadb
 pkgname=('mariadb-libs' 'mariadb-clients' 'mariadb' 'mytop')
 pkgdesc='Fast SQL database server, derived from MySQL'
-pkgver=10.7.3
+pkgver=10.7.1
+_srctag="mariadb-$pkgver"
 pkgrel=1
 arch=('x86_64')
 license=('GPL')
 url='https://mariadb.org/'
 makedepends=('boost' 'bzip2' 'cmake' 'cracklib' 'curl' 'jemalloc' 'judy' 'krb5' 'libaio'
-             'libxcrypt' 'libxml2' 'lz4' 'openssl' 'systemd' 'zlib' 'zstd' 'xz')
+             'libxcrypt' 'libxml2' 'lz4' 'openssl' 'systemd' 'zlib' 'zstd' 'xz' 'gcc12')
 options=('debug')
 validpgpkeys=('199369E5404BD5FC7D2FE43BCBCB082A1BB943DB') # MariaDB Package Signing Key <[email protected]>
 # The default links with mirror redirection fail for signatures, specific
 # mirrors may be out of date every now and then. Let's use the upstream
 # rsync source via https and hope it does not hurt them too much.
 # https://mariadb.com/kb/en/library/mirror-sites-for-mariadb/
-source=("https://rsync.osuosl.org/pub/mariadb/mariadb-${pkgver}/source/mariadb-${pkgver}.tar.gz"{,.asc}
+source=("$pkgbase-$pkgver::git+https://github.com/MariaDB/server#tag=$_srctag"
         '0001-arch-specific.patch')
-sha256sums=('da286919ffc9c913282202349709b6ba4ebcd342815e8dae0aa6b6bd8f515cd4'
-            'SKIP'
+sha256sums=('SKIP'
             '3289efb3452d199aec872115f35da3f1d6fd4ce774615076690e9bc8afae1460')
 
 prepare() {
@@ -34,6 +34,7 @@ prepare() {
 }

 build() {
+
   local _cmake_options=(
     # build options
     -DCOMPILATION_COMMENT="Arch Linux"
@@ -89,6 +90,7 @@ build() {
 
   mkdir build
   cd build
+  export CC=/usr/bin/gcc-12 CXX=/usr/bin/g++-12
 
   cmake ../"$pkgbase-$pkgver" "${_cmake_options[@]}"
marsh field
#

oh well, good luck bro. @naive lake and me gave you the best long term solution

static wren
# dull verge

so is this 10.7.1 or is the script you posted the process of downgrading im not knowledgeable on this stuff

naive lake
dull verge
static wren
jovial brambleBOT
#

nyasaki received a thank you cookie!

static wren
jovial brambleBOT
#

You're thanking too much ó_ò

dull verge
static wren
#

well... i got 6 cores running 4ghz

#

probably will do great

dull verge
static wren
#

laptop about to turn into an airplane

marsh field
#

why compiling when you can use your package manager?

#

.aw downgrade

errant gulchBOT
marsh field
naive lake
#

Aparently actually helpful recommendations arent worth anything anymore lol

marsh field
#

ikr

naive lake
#

gl with your unstable shit xD

marsh field
#

yeah, it will turn into manjaro

naive lake
#

and thats why ppl claim arch is unstable, smh

marsh field
#

not arch fault

dull verge
static wren
#

yall are really living up the bad name arch users get lmao

#

not Sena tho

#

awesome

marsh field
#

when downgrade exists

#

tho it's not recommended

static wren
#

ok ill try downgrade first

#

or is compiling safer?

marsh field
#

bruh

#

why compiling if the package is already there?

#

I literally found it

static wren
#

quote "tho its not recommended"

marsh field
#

you already know @naive lake and my own reasons why not holding back arch or packages

#

so we gave you alternatives

#

anyways, I'm off. take or leave the advice.

dull verge
#

541 commits and 1314 file changes in between

marsh field
static wren
#

ok uno momento gotta do something

marsh field
#

debian 10 offers older mariadb

#

even debian 11

static wren
#

bro stop trying to push your opinion on me i said no.

static wren
dull verge
static wren
#

uh just now, so what command do i use to use pkgbuild

dull verge
static wren
#

ahh

#

ok makes sense now

#

so makepkg -s -j6

dull verge
static wren
#

ok where would i append -j6 to utilize all cores?

dull verge
dull verge
static wren
#

im getting the error Cannot find the git package needed to handle git sources.

dull verge
dull verge
static wren
#

installing some stuff brb

dull verge
# static wren installing some stuff brb

The build process will take a while, so please be patient.

In the meantime, I've set up an action to build this package, thus we can compare the results to see if the build is deterministic.

marsh field
#

so you can compile

static wren
#

already doing it, just waiting on the slow af downloads lmao

static wren
static wren
#

@dull verge it has finished!

#

so is this a working install or a installer?

dull verge
# static wren so is this a working install or a installer?

It would produce the following packages

[codespace memchr/linux-clang artifacts] 0
% ls
mariadb-10.7.1-1-x86_64.pkg.tar.zst          mariadb-libs-10.7.1-1-x86_64.pkg.tar.zst
mariadb-clients-10.7.1-1-x86_64.pkg.tar.zst  mytop-10.7.1-1-x86_64.pkg.tar.zst
mariadb-debug-10.7.1-1-x86_64.pkg.tar.zst
static wren
#

yep

dull verge
static wren
#

ok so when i run packman do i use args to specify the install path now or later?

dull verge
#

Well, except for mariadb-debug, which is a debug package.

static wren
#

ok i renamed the folder this is all in to "mariadb builder" cause i want "mariadb" to be the path in Documents to install to

#

(after the build completed of course)

dull verge
static wren
#

is there a way to change that, in the case where thats a no, is there a way to move the data path where databases are stored?

dull verge
dull verge
static wren
#

got it

dull verge
# static wren got it

move the data path where databases are stored
Please refer to the mariaDB documentation for this, as it is more relevant to mariadb itself than to the package.

static wren
#

i know it can do it but ive never done it for arch so this will be fun

dull verge
#

The Arch Wiki has some information on this

static wren
#

ok so now i just have to enable maria.db service and start it i think

dull verge
# static wren got it

Tip: If you use something different from /var/lib/mysql for your data dir, you need to set datadir=YOUR_DATADIR under section [mariadb] of your /etc/my.cnf.d/server.cnf.

static wren
#

which is like systemctl right?

dull verge
dull verge
#

The unit files are

  • mariadb.server - main server file
  • mariadb.socket - socket activation
  • mariadb-extra.socket - socket activation extra port
#

You can use the following command to see what the unit file does

systemctl cat unit_file_name
  • unit_file_name is a wildcard that should be replaced with the full name of the unit file.
static wren
#

sudo systemctl enable mariadb.serivce and then sudo systemctl start mariadb.service
yet im getting an error, oh wait i gotta do the whole mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql thing first

static wren
dull verge
#

id est

sudo systemctl enable --now mariadb.serivce
dull verge
#

The difference between socket and service units is that socket units allow services to be launched on demand when a connection is made to a network socket.

static wren
#

ah, well currently getting the error Job for mariadb.service failed because the control process exited with error code. I assume i must run the command i mentioned above first, mariadb-install-db

static wren
#

which the docs says

#

so ima figure that out rq

#

sooo i think this should work mariadb-install-db --user=root --basedir=/usr --datadir=/home/bryton/Documents/1.20.1 Server/mariadb

#

assuming root is the login for mariadb and not arch linux

#

it wasnt

dull verge
static wren
#

yep i just noticed lol

#

F

#

could entering it without quotation marks and then adding them and running the program again caused this?

dull verge
# static wren

you have a buffer overflow and the canary gets overwritten by a different value. This is a security mechanism implemented by gcc/g++ to prevent buffer overflow exploits using -fstack-protector

static wren
#

neat

#

thats good to know

dull verge
#

Please do note that 10.7.1 is a release candidate.

dull verge
# static wren
??:0(__stack_chk_fail)[0x7efcdd043ce6]
??:0(my_md5)[0x55c402a51d32]
??:0(TABLE_LIST::calc_md5(char*))[0x55c4026fe167]

Seems to me that the md5 hash calculation caused this

static wren
#

XD

#

amazing you have my respect for helping me

#

would i just remove the package and bump the packagebuild?

dull verge
static wren
#

im willing to try bumping to 10.7.2 but im pretty sure issues start occuring with later versions

dull verge
#

Mariadb uses semantic versioning, the last number is the patch level.

static wren
#

ah

dull verge
static wren
#

aight, should i rebuild it as .2 or use pacman to update it to that same version?

dull verge
#

For this reason, my suggestion to you is this version

static wren
#

and youre sure its only bug fixes not anything changed?

#

we can try it

#

so do i pacman -R mariadb?

dull verge
static wren
#

no its just the plugin uses maria and they did something which stops it from using the db

#

and i really dont want to dig around in a civ plugin

#

ima give that a try rq

dull verge
static wren
dull verge
#

You may also want to consider enabling ccache for makepkg, which should speed up rebuilding the next time this happens.

static wren
#

so pacman -R and then do-over the makepkg but change the file to say 10.7.8 instead of .1?

dull verge
#
diff --git a/PKGBUILD b/PKGBUILD
index 94264f8..55389e7 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -4,7 +4,7 @@
 pkgbase=mariadb
 pkgname=('mariadb-libs' 'mariadb-clients' 'mariadb' 'mytop')
 pkgdesc='Fast SQL database server, derived from MySQL'
-pkgver=10.7.1
+pkgver=10.7.8
 _srctag="mariadb-$pkgver"
 pkgrel=1
 arch=('x86_64')
static wren
#

alright done

#

pkgbuild changed

#

do i need to delete anythig in that folder?

dull verge
static wren
#

and my laptop is an airplane again lol

dull verge
static wren
#

ccache?

#

clear?

#

im lost lol

dull verge
# static wren ccache?

ccache is a compiler wrapper that stores on disk the compiled binaries and offers them back to speed up any eventual recompilation of the same code. While it may take a few seconds longer to compile a program the first time, subsequent compiles will be much faster as no proper compilation is made, only a lookup through the previously stored binaries. ccache is compatible with GCC and Clang.

static wren
#

ah

#

im gonna go figure out how to stop -Syu from updating mariadb aswell

dull verge
# static wren ah

The speed-up can be one or two orders of magnitude, depending on how much the source is changed.

dull verge
static wren
#

it seems i got an error

dull verge
static wren
#

was just trying to grab it lol

dull verge
static wren
#

i ran makepkg --cleanbuild

#

after changing the version

dull verge
static wren
#

oops

#

so where do i grab those

#

github?

dull verge
#

The packages are in the directories where the PKGBUILD resides.

dull verge
# static wren oops

You can remove the debug package before installing them all at once

rm mariadb-debug*pkg.tar.zst
sudo pacman -U --noconfirm *pkg.tar.zst
#

Also, holding a package back required frequent rebuilding in the event that the major dependent library on arch was updated, so I advise you to either learn and use ccache, or set up a CI (Both GitHub and GitLab offer free CI) to automatically build and release that package whenever you want.

#

This is the price we pay for building packages ourselves.

static wren
#

oof

#

alright so now i run the build script?

dull verge
static wren
#
[bryton@archlinux mariadb]$ ls
0001-arch-specific.patch             mariadb-clients-10.7.1-1-x86_64.pkg.tar.zst  pkg
mariadb-10.7.1                       mariadb.install                              PKGBUILD
mariadb-10.7.1-1-x86_64.pkg.tar.zst  mariadb-libs-10.7.1-1-x86_64.pkg.tar.zst     src
mariadb-10.7.8                       mytop-10.7.1-1-x86_64.pkg.tar.zst
dull verge
static wren
#

oops

dull verge
static wren
#

ok so i deleted the old folder and extracted this one

dull verge
#
git clone https://github.com/memchr/mariadb
static wren
#

now i run sudo makepkg -s

dull verge
static wren
#

ok

#

but do run makepkg

dull verge
static wren
#

alright il run git clone

dull verge
static wren
#

i owe you a case of beers dude

dull verge
# static wren alright il run git clone

I've updated the PKGBUILD to use ccache if found on your system. This would speed up the rebuild by orders of magnitude. You can get this update after the current build process has finished.

git pull

To install ccache, use

sudo pacman -S --noconfirm ccache

There is no need to interrupt the current build process. The ccache would be used the next time you build the package.

#

However, this has the potential to increase memory usage, so make sure you have enough free memory and swap space if you ever get this error.

{standard input}: Assembler messages:                                                           
{standard input}:133779: Warning: end of file not at end of a line; newline inserted            
{standard input}: Error: open CFI at the end of file; missing .cfi_endproc directive            
g++-12: fatal error: Terminated signal terminated program cc1plus                               
compilation terminated.                                                                         
make[2]: *** [storage/rocksdb/CMakeFiles/rocksdblib.dir/build.make:314: storage/rocksdb/CMakeFil
es/rocksdblib.dir/rocksdb/db/db_impl/db_impl.cc.o] Error 1                                      
make[2]: *** Waiting for unfinished jobs....
static wren
#

ill try again

#

wait i think i forgot something

#

im probably doing something wrong ima take a break lmk if you need logs

dull verge
static wren
#

so far i did git pull *link* , sudo pacman -S --noconfirm ccache, sudo systemctl enable mariadb.service , mariadb-install-db --user=bryton --basedir=/usr --datadir="/home/bryton/Documents/1.20.1 Server/mariadb" , sudo systemctl Start mariadb.service

static wren
#

uhhhhhh

#

let me see

#
[bryton@archlinux mariadb]$ sudo pacman -S --noconfirm ccache
resolving dependencies...
looking for conflicting packages...

Packages (2) hiredis-1.2.0-1  ccache-4.8.2-1

Total Download Size:   0.58 MiB
Total Installed Size:  1.57 MiB

:: Proceed with installation? [Y/n] 
:: Retrieving packages...
 ccache-4.8.2-1-x86_64                    540.9 KiB   265 KiB/s 00:02 [#######################################] 100%
 hiredis-1.2.0-1-x86_64                    52.0 KiB  86.2 KiB/s 00:01 [#######################################] 100%
 Total (2/2)                              592.8 KiB   211 KiB/s 00:03 [#######################################] 100%
(2/2) checking keys in keyring                                        [#######################################] 100%
(2/2) checking package integrity                                      [#######################################] 100%
(2/2) loading package files                                           [#######################################] 100%
(2/2) checking for file conflicts                                     [#######################################] 100%
(2/2) checking available disk space                                   [#######################################] 100%
:: Processing package changes...
(1/2) installing hiredis                                              [#######################################] 100%
(2/2) installing ccache                                               [#######################################] 100%
:: Running post-transaction hooks...
(1/1) Arming ConditionNeedsUpdate...
#

then i ran

dull verge
static wren
#

wth

dull verge
static wren
#

XD i think i built the old shit

0001-arch-specific.patch                     mariadb-debug-10.7.8-1-x86_64.pkg.tar.zst  pkg
mariadb                                      mariadb.install                            PKGBUILD
mariadb-10.7.8-1-x86_64.pkg.tar.zst          mariadb-libs-10.7.8-1-x86_64.pkg.tar.zst   src
mariadb-clients-10.7.8-1-x86_64.pkg.tar.zst  mytop-10.7.8-1-x86_64.pkg.tar.zst
#

or not

#

ok so i need to uninstall it and reinstall the right one

dull verge
static wren
#

ah i used the wrong pacman script

#

do i need to sudo the whole mariadb-install-db

dull verge
static wren
#

its still 10.7.1

#

hmm

dull verge
#

In the PKGBUILD directory

 cat src/mariadb/VERSION
static wren
#
[bryton@archlinux mariadb]$ pacman -Q mariadb
mariadb 10.7.1-1
[bryton@archlinux mariadb]$ cat src/mariadb/VERSION
MYSQL_VERSION_MAJOR=10
MYSQL_VERSION_MINOR=7
MYSQL_VERSION_PATCH=8
SERVER_MATURITY=stable
dull verge
#
pacman -Qip mariadb-10.7.8-1-x86_64.pkg.tar.zst 
static wren
#

shouldnt i remove the old stuff?

dull verge
static wren
#
[bryton@archlinux mariadb]$ sha256sum PKGBUILD
e05023872c33589b05e20a81a75961257ba47f118344f8b7fd5bd880fca27d82  PKGBUILD
[bryton@archlinux mariadb]$ pacman -Qip mariadb-10.7.8-1-x86_64.pkg.tar.zst
Name            : mariadb
Version         : 10.7.8-1
Description     : Fast SQL database server, derived from MySQL
Architecture    : x86_64
URL             : https://mariadb.org/
Licenses        : GPL
Groups          : None
Provides        : mysql=10.7.8
Depends On      : mariadb-clients=10.7.8  bzip2  libxml2  lz4  systemd-libs  libxml2  zstd
Optional Deps   : cracklib: for cracklib plugin
                  curl: for ha_s3 plugin
                  galera: for MariaDB cluster with Galera WSREP
                  judy: for Open Query GRAPH (OQGraph) computation engine
                  perl-dbd-mariadb: for mariadb-hotcopy, mariadb-convert-table-format and mariadb-setpermission
                  python-mysqlclient: for myrocks_hotbackup
                  xz: lzma provider
Conflicts With  : mysql
Replaces        : None
Compressed Size : 69.58 MiB
Installed Size  : 243.94 MiB
Packager        : Unknown Packager
Build Date      : Thu 03 Aug 2023 02:51:58 AM PDT
Install Script  : Yes
Validated By    : None
Signatures      : None

[bryton@archlinux mariadb]$ 
dull verge
static wren
#

?!

#

how tho

dull verge
# static wren how tho

Please run this command

sudo pacman -U --noconfirm mariadb-10.7.8-1-x86_64.pkg.tar.zst mariadb-clients-10.7.8-1-x86_64.pkg.tar.zst mariadb-libs-10.7.8-1-x86_64.pkg.tar.zst mytop-10.7.8-1-x86_64.pkg.tar.zst 

And post the output of

pacman -Q mariadb
static wren
#

10.7.1-1

#
[bryton@archlinux mariadb]$ sudo pacman -U --noconfirm mariadb-10.7.8-1-x86_64.pkg.tar.zst mariadb-clients-10.7.8-1-x86_64.pkg.tar.zst mariadb-libs-10.7.8-1-x86_64.pkg.tar.zst mytop-10.7.8-1-x86_64.pkg.tar.zst
[sudo] password for bryton: 
loading packages...
resolving dependencies...
looking for conflicting packages...

Packages (4) mariadb-10.7.8-1  mariadb-clients-10.7.8-1  mariadb-libs-10.7.8-1  mytop-10.7.8-1

Total Installed Size:  313.44 MiB
Net Upgrade Size:        0.66 MiB

:: Proceed with installation? [Y/n] 
(4/4) checking keys in keyring                                        [#######################################] 100%
(4/4) checking package integrity                                      [#######################################] 100%
(4/4) loading package files                                           [#######################################] 100%
(4/4) checking for file conflicts                                     [#######################################] 100%
error: failed to commit transaction (conflicting files)
/usr/lib/mysql/plugin/zstd.so exists in both 'mariadb-libs' and 'mariadb'
Errors occurred, no packages were upgraded.
[bryton@archlinux mariadb]$ pacman -Q mariadb
mariadb 10.7.1-1
static wren
#

ima just pay someone to do it at this point i dont want to waste your time. do you have a paypal?

dull verge
dull verge
static wren
#

uh git pull i think pulls from the wrong place

#
[bryton@archlinux mariadb]$ git pull
warning: redirecting to https://gitlab.archlinux.org/archlinux/packaging/packages/mariadb.git/
There is no tracking information for the current branch.
Please specify which branch you want to merge with.
See git-pull(1) for details.

    git pull <remote> <branch>

If you wish to set tracking information for this branch you can do so with:

    git branch --set-upstream-to=origin/<branch> mariadb-10.7.1

#
[bryton@archlinux mariadb]$ git remote set-url origin [email protected]:memchr/mariadb                  108.5G  ─╯
usage: git remote set-url [--push] <name> <newurl> [<oldurl>]
   or: git remote set-url --add <name> <newurl>
   or: git remote set-url --delete <name> <url>

    --push                manipulate push URLs
    --add                 add URL
    --delete              delete URLs

#

am i doing it wrong

dull verge
static wren
#

ok done

dull verge
static wren
#
[bryton@archlinux mariadb]$ makepkg --nocheck --holdver --noextract -fi
==> Making package: mariadb 11.0.2-2 (Thu 03 Aug 2023 04:30:20 AM PDT)
==> Checking runtime dependencies...
==> Checking buildtime dependencies...
==> WARNING: Using existing $srcdir/ tree
==> Removing existing $pkgdir/ directory...
==> Starting build()...
mkdir: cannot create directory ‘build’: File exists
==> ERROR: A failure occurred in build().
    Aborting...
[bryton@archlinux mariadb]$ 
#

do i need to git pull first?

dull verge
static wren
#
[bryton@archlinux mariadb]$ git pull
The authenticity of host 'github.com (192.30.255.112)' can't be established.
ED25519 key fingerprint is SHA256:+DiY3wvvV6TuJJhbpZisF/zLDA0zPMSvHdkr4UvCOqU.
This key is not known by any other names.
Are you sure you want to continue connecting (yes/no/[fingerprint])? y       
Please type 'yes', 'no' or the fingerprint: yes
Warning: Permanently added 'github.com' (ED25519) to the list of known hosts.
[email protected]: Permission denied (publickey).
fatal: Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.
dull verge
static wren
#

not at all lol

#

you wanna remote into mine? XD

dull verge
static wren
#

i have krfb setup

#

alright its downloading

dull verge
static wren
#

im not worried

dull verge
# static wren im not worried

How long does it take to build this on your machine? Mine is about 12 minutes, although caching may have contributed.

static wren
#

15

#

ish

#

ok so i ran the script above

dull verge
static wren
#

how do i close the curl

dull verge
static wren
#

i ran the curl script and its not freeing the console

dull verge
static wren
#

ima just reopen it

dull verge
dull verge
static wren
#

aight its ready

#

it has curl'd

dull verge
static wren
#

ok no errors

dull verge
static wren
#

YES

#

IT WORKED

#

so enable install and start

#
[bryton@archlinux mariadb]$ sudo mariadb-install-db --user=bryton --basedir=/usr --datadir=/home/bryton/Documents/1.20.1-Server/mariadb
Installing MariaDB/MySQL system tables in '/home/bryton/Documents/1.20.1-Server/mariadb' ...
/usr/bin/mariadbd: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

Installation of system tables failed!  Examine the logs in
/home/bryton/Documents/1.20.1-Server/mariadb for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/bin/mariadb-install-db --defaults-file=~/.my.cnf

You can also try to start the mariadbd daemon with:

    shell> /usr/bin/mariadbd --skip-grant-tables --general-log &

and use the command line tool /usr/bin/mariadb
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mariadb -u root mysql
    MariaDB> show tables;

Try '/usr/bin/mariadbd --help' if you have problems with paths.  Using
--general-log gives you a log in /home/bryton/Documents/1.20.1-Server/mariadb that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at https://mariadb.org/jira

[bryton@archlinux mariadb]$ 
static wren
#

not found

dull verge
dull verge
# static wren not found

I recommend that you download pacman file db using pacman -Fy, so that the next time a file or command is not found on your computer, you can simply run

pacman -F name_of_file_or_command

to find out what package you need to install

static wren
#

ayo?

bryton@archlinux mariadb]$ sudo mariadb-install-db --user=bryton --basedir=/usr --datadir=/home/bryton/Documents/1.20.1-Server/mariadb
Installing MariaDB/MySQL system tables in '/home/bryton/Documents/1.20.1-Server/mariadb' ...
OK

To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is bryton@localhost, it has no password either, but
you need to be the system 'bryton' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mariadb-safe --datadir='/home/bryton/Documents/1.20.1-Server/mariadb'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mariadb-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
dull verge
static wren
#
[bryton@archlinux mariadb]$ sudo systemctl enable mariadb.service
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
[bryton@archlinux mariadb]$ sudo systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
[bryton@archlinux mariadb]$ mariadb -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111)
#

time to figure out why it wont start XD

#

this is great i did this before on windows and i cant remember how

#

hmm 1 sec

dull verge
static wren
#

wait yea 1 sec

#

cd right

#

but thats the data not the sofware

#

i should be able to login

#

and start

dull verge
# static wren wait yea 1 sec

If you use something different from /var/lib/mysql for your data dir, you need to set datadir=YOUR_DATADIR under section [mariadb] of your /etc/my.cnf.d/server.cnf

static wren
#

thats what im reading right now lol

#

so im looking around

#

so

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.7 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.7]
datadir=/home/bryton/Documents/1.20.1-Server/mariadb
#

is good?

dull verge
static wren
#
[bryton@archlinux mariadb]$ sudo systemctl enable mariadb.service
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
[bryton@archlinux mariadb]$ sudo systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
[bryton@archlinux mariadb]$ 
dull verge
#

See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

static wren
#
× mariadb.service - MariaDB 10.7.8 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
     Active: failed (Result: exit-code) since Thu 2023-08-03 05:27:16 PDT; 59s ago
TriggeredBy: × mariadb.socket
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 97370 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 97371 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, st>
    Process: 97413 ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 97413 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 194ms

Aug 03 05:27:15 archlinux systemd[1]: Starting MariaDB 10.7.8 database server...
Aug 03 05:27:16 archlinux mariadbd[97413]: 2023-08-03  5:27:16 0 [Warning] Can't create test file /home/bryton/Documents/1.20.1-Server/mariadb/archlinux.lower-test
Aug 03 05:27:16 archlinux mariadbd[97413]: [121B blob data]
Aug 03 05:27:16 archlinux mariadbd[97413]: 2023-08-03  5:27:16 0 [ERROR] Aborting
Aug 03 05:27:16 archlinux systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Aug 03 05:27:16 archlinux systemd[1]: mariadb.service: Failed with result 'exit-code'.
Aug 03 05:27:16 archlinux systemd[1]: Failed to start MariaDB 10.7.8 database server.
lines 1-20/20 (END)

and

#
Aug 03 05:27:09 archlinux systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
Aug 03 05:27:09 archlinux systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Aug 03 05:27:09 archlinux systemd[1]: Failed to start MariaDB 10.7.8 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ A start job for unit mariadb.service has finished with a failure.
░░ 
░░ The job identifier is 4599 and the job result is failed.
Aug 03 05:27:15 archlinux systemd[1]: Starting MariaDB 10.7.8 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ A start job for unit mariadb.service has begun execution.
░░ 
░░ The job identifier is 4699.
Aug 03 05:27:16 archlinux mariadbd[97413]: 2023-08-03  5:27:16 0 [Warning] Can't create test file /home/bryton/Documents/1.20.1-Server/mariadb/archlinux.lower-test
Aug 03 05:27:16 archlinux mariadbd[97413]: [121B blob data]
Aug 03 05:27:16 archlinux mariadbd[97413]: 2023-08-03  5:27:16 0 [ERROR] Aborting
Aug 03 05:27:16 archlinux systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
Aug 03 05:27:16 archlinux systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Aug 03 05:27:16 archlinux systemd[1]: Failed to start MariaDB 10.7.8 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ A start job for unit mariadb.service has finished with a failure.
░░ 
░░ The job identifier is 4699 and the job result is failed.
dull verge
#

Aug 03 05:27:16 archlinux mariadbd[97413]: 2023-08-03 5:27:16 0 [Warning] Can't create test file /home/bryton/Documents/1.20.1-Server/mariadb/archlinux.lower-test
Aug 03 05:27:16 archlinux mariadbd[97413]: [121B blob data]
Aug 03 05:27:16 archlinux mariadbd[97413]: 2023-08-03 5:27:16 0 [ERROR] Aborting

static wren
#

should i not run my data file away from the software? i mean it makes it harder for backups and transfers

dull verge
static wren
#

i want to keep the data for a plugin which uses a database in the actual server folder so it can easily be archived

#

makes backups easy

#

i run it that way on windows without issue

dull verge
static wren
#

so what do i do?

#

re-run the install script with what is reccomended?

dull verge
static wren
#
[bryton@archlinux mariadb]$ sudo -u mysql /usr/bin/mariadbd
2023-08-03  5:37:16 0 [Warning] Can't create test file /home/bryton/Documents/1.20.1-Server/mariadb/archlinux.lower-test
/usr/bin/mariadbd: Can't change dir to '/home/bryton/Documents/1.20.1-Server/mariadb/' (Errcode: 13 "Permission denied")
2023-08-03  5:37:16 0 [ERROR] Aborting
[bryton@archlinux mariadb]$ 
dull verge
#

I would like the software's path to point to it in the Documents folder and to store the database in a subfolder within Documents
I'd just like to interject for a moment, what you're refering may not worth the effort.

dull verge
static wren
#

i see that now

#

invalid user?

dull verge
dull verge
static wren
#

its not worth it tbh

#

alright so do i run the install command again?

#

sudo mariadb-install-db --user=bryton --basedir=/usr --datadir=/var/lib/mysql

dull verge
static wren
#

chown: invalid user: ‘mariadb:mariadb’

dull verge
static wren
#

where

dull verge
static wren
#
[bryton@archlinux mariadb]$ sudo chown -R mariadb:mariadb /home/bryton/Documents/1.20.1-Server/mariadb
chown: invalid user: ‘mariadb:mariadb’
[bryton@archlinux mariadb]$ 
#

i think im gonna get off i need sleep, i got a friend ill pay to setup the db. dont worry, thank you for getting me this far.

dull verge
static wren
#

if anyone needs help with civ plugins lmk

dull verge
static wren
#

bruh

#

why does mariadb even use that prefix

#

so weird

#

so sudo chown -R mysql:mysql /home/bryton/Documents/1.20.1-Server/mariadb