Error at the database connection step of the manual installation process

[Matinal111]

Bug Description

I described the problem in Discussions #881, and felt it would be more convenient to raise an Issues.
The problem is as shown in the screenshot, I checked the database and network again before this and they are working fine, do I need to provide any other information to assist with this?

How to reproduce

Setup without Docker

Expected behavior

make it work

Logs

Screenshots

LinkAce version

v2.0.0 Beta 4

Setup Method

PHP

Operating System

Linux (Ubuntu, CentOS,...)

Client details

No response

[Kovah]

Ah well okay then. Could you please install the MySQL Client on your machine? It's needed if you want to use LinkAce with a MySQL database.

[Matinal111]

Ah well okay then. Could you please install the MySQL Client on your machine? It's needed if you want to use LinkAce with a MySQL database.

I have installed MariaDB service through Docker, my other hosting services and container services to connect to the database are running fine, I have opened the external port of MariaDB and remote connection is fine, I have spent days troubleshooting this issue and still have no clue, I don't want to give up, please help me to solve this issue!

[Kovah]

Could you please share your PHP configuration? Maybe something is missing, so that PHP falls back to using the MySQL client instead of using the PDO modules which usually takes care of the database connections.

[Matinal111]

# php -m
[PHP Modules]
bcmath
calendar
Core
ctype
curl
date
dom
exif
FFI
fileinfo
filter
ftp
gd
gettext
hash
iconv
igbinary
json
libxml
mbstring
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
Phar
posix
random
readline
redis
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

[Kovah]

I have no idea where this is coming from. PDO MySQL is clearly installed and should be used during the setup. It's unusual that the mysql client is called manually.

Could you please try to finalize the setup by using the command line:

php artisan migrate
php artisan setup:complete
php artisan registeruser

[Matinal111]

[Matinal111]

I changed the database to pgsql and it also gives me an error, I have to wonder if there is something wrong with the program's database connection logic

[Kovah]

I know what the issue is. LinkAce v2 uses a database dump to create the base table structure ov LinkAce v1. This significantly increases the time to install the applications, because not all 30+ migrations need to run one after another.
But to be able to import the database dump, the real database clients are needed.

So, basically mysql-client, mariadb-client or postgresql-client postgresql-dev nedd to be installed to use LinkAce as a standalon PHP application where the database server is running on another machine, or in Docker as in your setup.

[Matinal111]

This is really bad news. That's all.

[Kovah]

Well, I know it's unfortunate that those clients are needed, but I would not like to build the whole database setup back for an rather edge case setup. LinkAce backups won't be available too, if the clients are missing from your system.