installing flarum with plesk

[Hari]

finally got it running but i am getting these errors how to fix them?

root@amazing-hellman:/var/www/vhosts/test.tk/httpdocs# php flarum info
PHP Fatal error:  Uncaught PDOException: could not find driver in /var/www/vhosts/test.tk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
Stack trace:
#0 /var/www/vhosts/test.tk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO->__construct()
#1 /var/www/vhosts/test.tk/httpdocs/vendor/illuminate/database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
#2 /var/www/vhosts/test.tk/httpdocs/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection()
#3 /var/www/vhosts/test.tk/httpdocs/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#4 /var/www/vhosts/test.tk/httpdocs/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connector in /var/www/vhosts/test.tk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php on line 18
root@amazing-hellman:/var/www/vhosts/test.tk/httpdocs# 

[phenomlab]

@Hari That looks like the php-mysql extension is not installed, or not loaded for the PHP version you are using.

[Hari]

i want to learn these things

• change PHP version to 8 at the server level and also for my domain in Plesk using SSH

• instead of maria DB i want to use MySQL as default, how can i do that? is it really possible? without a docker or any other things (since i am getting those SQL errors as shown in the earlier reply want to switch to MySQL from MariaDB)

• update composer to v2 for my domain via SSH.

@phenomlab said in installing flarum with plesk:

@Hari Flarum will 100% work on Plesk, but as I alluded to in a previous thread, it’s not a simple exercise. Installing Flarum using Pocket Hold isn’t necessary as you should be able to complete the entire installation process using SSH without issue.

i don’t know the reason but i am unable to install any extensions or flarum using SSH that is the reason i had to use pocket hold

[phenomlab]

@Hari My responses below

change PHP version to 8 at the server level and also for my domain in Plesk using SSH

PHP 8.x has been available in Plesk since October 2021. There’s no need to change this using SSH, and it’s actually not recommended. The entire point of Plesk is to manage this using the portal - see below

https://support.plesk.com/hc/en-us/articles/115000769793

instead of maria DB i want to use MySQL as default, how can i do that? is it really possible? without a docker or any other things (since i am getting those SQL errors as shown in the earlier reply want to switch to MySQL from MariaDB)

Possible, yes - although it’s usually the other way round in the sense that people want to replace MySQL with MariaDB

https://www.plesk.com/blog/product-technology/mysql-vs-mariadb/

update composer to v2 for my domain via SSH.

You should take the same route as is advertised here

https://getcomposer.org/download/

[Hari]

@phenomlab oh i see in that case i think my old backup is causing the issues regarding MySQL and PHP versions. i will try fresh installation now.

[phenomlab]

@Hari Ok. Let me know.

[Hari]

@phenomlab

i have installed and set my project settings to PHP 8 but CLI is not updating to 8.0

should i try this?

https://talk.plesk.com/threads/set-default-php-version-for-command-line.345940/

[phenomlab]

@Hari What version of Plesk do you have ? You should be able to install this using the links I posted earlier ?

[Hari]

@phenomlab

Plesk Obsidian Version 18.0.41

domain settings

[phenomlab]

@Hari What’s the output of php -v from CLI ?

[Hari]

@phenomlab

i just sent logins, please teach me what changes i need to make i really want to learn this setup process … i want to do a youtube video on this too

[phenomlab]

@Hari Looks like the environment variable is not set.

What is the output of

locate php and whereis php ?

[Hari]

@phenomlab

should i goto the root and run these commands again?

[phenomlab]

@Hari No. Plesk typically installs PHP in /opt/plesk/php/7.4/bin so what is the output of /opt/plesk/php/7.4/bin/php -v ?

Should be

PHP 7.4.28 (cli) (built: Feb 18 2022 07:57:20) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with the ionCube PHP Loader + ionCube24 v11.0.1, Copyright (c) 2002-2022, by ionCube Ltd.
    with Zend OPcache v7.4.28, Copyright (c), by Zend Technologies

Therefore, PHP 8 should be in /opt/plesk/php/8.0/bin, so you should also get output from /opt/plesk/php/8.0/bin/php -v as below

PHP 8.0.16 (cli) (built: Feb 18 2022 07:57:20) ( NTS )
Copyright (c) The PHP Group
Zend Engine v4.0.16, Copyright (c) Zend Technologies
    with Zend OPcache v8.0.16, Copyright (c), by Zend Technologies

This means that because your environment variable is missing, you have to specify the full path to PHP 8, so instead of just php, you need /opt/plesk/php/8.0/bin/php

Welcome to Plesk

[Hari]

@phenomlab

[phenomlab]

@Hari sorry - that should be /opt/plesk/php/8.0/bin/php. Previous post corrected.

[Hari]

@phenomlab i installed Plesk directly from DO app area… it’s free up to 2-3 domains.

after running opt command the screen got stuck

[phenomlab]

@Hari That’s expected because you are now running PHP as a daemon Kill it by pressing CTRL + C (sometimes CTRL + Z or CTRL + X), then issue the correct command of /opt/plesk/php/8.0/bin/php -v which should spit out the version used in CLI.

[Hari]

@phenomlab

[phenomlab]

@Hari There you go…!